aspx页面
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="TripFloorDetails.aspx.cs" Inherits="IntlTicket_Product_TripFloorDetails" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"> <title>无标题页</title>
<script type="text/javascript"> function addHoldRoomTypes() { var LstHouseTypeRoomHold = document.getElementById("lbxTotalList"); var ListHouseTypeRoomSelected = document.getElementById("lbxSelectList"); var removeItems = ""; for(var i=0;i<LstHouseTypeRoomHold.options.length;i++) { if(LstHouseTypeRoomHold.options[i].selected) { ListHouseTypeRoomSelected.options.add(new Option(LstHouseTypeRoomHold.options[i].text,LstHouseTypeRoomHold.options[i].value)); removeItems += LstHouseTypeRoomHold.options[i].value + ","; } } removeArrayList(LstHouseTypeRoomHold); var removeItem = removeItems.split(","); for(var k=0;k<removeItem.length;k++) { if(removeItem[k]!="") { removeSelectItem(LstHouseTypeRoomHold,removeItem[k]); } } addIds(ListHouseTypeRoomSelected); } function removeHoldRoomTypes() { var LstHouseTypeRoomHold = document.getElementById("lbxTotalList"); var ListHouseTypeRoomSelected = document.getElementById("lbxSelectList"); var removeItems = ""; for(var i=0;i<ListHouseTypeRoomSelected.options.length;i++) { if(ListHouseTypeRoomSelected.options[i].selected) { LstHouseTypeRoomHold.options.add(new Option(ListHouseTypeRoomSelected.options[i].text,ListHouseTypeRoomSelected.options[i].value)); removeItems += ListHouseTypeRoomSelected.options[i].value + ","; } } addArrayList(ListHouseTypeRoomSelected); var removeItem = removeItems.split(","); for(var k=0;k<removeItem.length;k++) { if(removeItem[k]!="") { removeSelectItem(ListHouseTypeRoomSelected,removeItem[k]); } } addIds(ListHouseTypeRoomSelected); } //删除列表中选定项 function removeSelectItem(select,itemVal) { for(var i=0;i<select.options.length;i++) { if(select.options[i].value==itemVal) { select.options.remove(i); } } } //被选中项ID串 function addIds(select) { var hIds=document.getElementById("hIds"); var ids=""; for(var i=0;i<select.options.length;i++) { ids += select.options[i].value + ","; } hIds.value=ids; } //下拉框选中项移除数组 function removeArrayList(select) { for(var j=0;j<select.options.length;j++) { if(select.options[j].selected) { for(var i=0;i<arrList.length;i++) { if(arrList[i].split(',')[0]==select.options[j].value) { arrList.splice(i,1); break; } } } } } //下拉框选中项录入数组 function addArrayList(select) { for(var i=0;i<select.options.length;i++) { if(select.options[i].selected) { arrList[arrList.length++]=select.options[i].value+","+select.options[i].text; } } }
</script> </head><body> <form id="form1" runat="server"> <div> <table border="0" cellpadding="3" cellspacing="1" class="bmsEditTable" width="50%" align="center"> <tr> <td class="bmsInputCaption" width="15%"> 机场名称:</td> <td class="bmsInputContent" width="35%"> <asp:Literal ID="LterAirporName" runat="server"></asp:Literal></td> <td class="bmsInputCaption" width="15%"> 航站楼名称:</td> <td class="bmsInputContent" width="35%"> <asp:Literal ID="LterTripFloor" runat="server"></asp:Literal></td> </tr> <tr> <td class="bmsInputContent" colspan="2"> 查询航空公司：<input type="text" id="inputer"></td> <td class="bmsInputCaption" width="15%"> </td> <td class="bmsInputContent" width="35%"> </td> </tr> <tr> <td colspan="4" class="bmsInputCaption"> <table width="100%"> <tr> <td rowspan="2" align="center"> <asp:ListBox ID="lbxTotalList" runat="server" Height="300px" Width="250px" SelectionMode="Multiple"> </asp:ListBox></td> <td width="90px"> <input id="btnAdd" type="button" value=">>" οnclick="addHoldRoomTypes();" class="mnfCommandButton80" /> </td> <td rowspan="2" align="center"> <asp:ListBox ID="lbxSelectList" runat="server" Height="300px" Width="250px" SelectionMode="Multiple"> </asp:ListBox></td> </tr> <tr> <td> <input id="btnRemove" type="button" value="<<" οnclick="removeHoldRoomTypes();" class="mnfCommandButton80" /> </td> </tr> </table> </td> </tr> <tr> <td colspan="4" class="bmsInputCaption" align="center"> <input id="hIds" type="hidden" runat="server" /> <asp:Button ID="btnSave" runat="server" Text="保存" CssClass="mnfCommandButton80" OnClick="btnSave_Click" TabIndex="100" /> <asp:Button ID="Button1" runat="server" Text="返回" CssClass="mnfCommandButton80" OnClick="Button1_Click" /> </td> </tr> </table> </div> </form></body></html><script language="javascript">
var arrList = new Array();
function smanPromptList(arrList,objInputId){ if (arrList.constructor!=Array){alert('smanPromptList初始化失败:第一个参数非数组!');return ;}
window.onload =function() {
var ldList=document.getElementById("lbxTotalList"); for(var i=0;i<ldList.options.length;i++) { arrList[i]=ldList.options[i].value+","+ldList.options[i].text; } var objInput = document.getElementById(objInputId); //文本框对象 var intTmp; //循环用的:) if (objInput==null) {alert('smanPromptList初始化失败:没有找到"'+objInputId+'"文本框');return ;}
//文本框按键抬起 objInput.οnkeyup=checkAndShow; //文本框得到焦点 objInput.οnfοcus=checkAndShow;
function checkList(svalue) { for(var i=0;i<arrList.length;i++) { if(arrList[i]==svalue) { ldList.options.add(new Option(arrList[i].split(',')[1],arrList[i].split(',')[0])); } } }
function checkAndShow(){ ldList.options.length=0
var strInput = objInput.value if (strInput!="") { for (intTmp=0;intTmp<arrList.length;intTmp++) { for(i=0;i<arrList[intTmp].length;i++) { if (arrList[intTmp].substr(i, strInput.length).toUpperCase()==strInput.toUpperCase()) { checkList(arrList[intTmp]); break; } } } } else { for(var i=0;i<arrList.length;i++) { ldList.options.add(new Option(arrList[i].split(',')[1],arrList[i].split(',')[0])); } } } }}
smanPromptList(arrList,"inputer") </script>
aspx.cs后台代码页
using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using CRM.Buzlogic.Common;using CRM.Buzlogic.IntlTicket.Product;using System.Data.OracleClient;
public partial class IntlTicket_Product_TripFloorDetails : BasePage{ #region GetParmerter int TripId { get { return IntUtil.SafeCInt(Request.QueryString["TRIP_FLOOR_NEW_ID"]); } } #endregion
protected void Page_Load(object sender, EventArgs e) { this.PageCaption = "机"; if (!IsPostBack) { InitControl(); } }
protected void InitControl() { TripFloorNew infoTripFloorNew = new TripFloorNew(); infoTripFloorNew.TripFloorNewId = TripId; infoTripFloorNew.Load(); LterAirporName.Text = DSCRM.DBA.ExecuteScalar(string.Format("select Airport_name from T_ITP_AIRPORT where Airport_id='{0}'", infoTripFloorNew.AirportId)).ToString(); LterTripFloor.Text = infoTripFloorNew.TripFloor;
lbxTotalList.Items.Clear(); lbxSelectList.Items.Clear(); BSCRM.Component.BaseListController.FillItems(this.lbxTotalList.Items, BSCRM.Component.ListMode.Normal, string.Format(@"select Airliner_id,Airliner_id||':'||Airliner_name as Airliner_name from t_itp_airliner where Airliner_id not in(select t2.airliner_id from T_ITP_TRIP_FLOOR_AIRLINER t1 inner join t_itp_airliner t2 on t1.airliner_id=t2.airliner_id inner join T_ITP_TRIP_FLOOR_NEW t3 on t1.trip_floor_new_id=t3.trip_floor_new_idwhere t3.airport_id='{0}')", infoTripFloorNew.AirportId)); BSCRM.Component.BaseListController.FillItems(this.lbxSelectList.Items, BSCRM.Component.ListMode.Normal, string.Format("select t2.airliner_id,t2.Airliner_id||':'||t2.Airliner_name as Airliner_name from T_ITP_TRIP_FLOOR_AIRLINER t1 inner join t_itp_airliner t2 on t1.airliner_id=t2.airliner_id where t1.trip_floor_new_id={0}", TripId)); }
/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { OracleConnection loOraConn = DSCRM.DBA.GetOraConnection("CRMDB"); OracleTransaction loOraTran = loOraConn.BeginTransaction(); try { OracleCommand loOraComm = loOraConn.CreateCommand(); loOraComm.Transaction = loOraTran;
TripFloorNewAirliner.DeleteTrip(TripId, loOraComm);
string[] strIds = this.hIds.Value.Split(','); for (int i=0;i<strIds.Length-1;i++) { TripFloorNewAirliner info = new TripFloorNewAirliner(); info.AirlinerId = strIds[i]; info.TripFloorNewId = TripId; info.Add(loOraComm); } loOraTran.Commit(); } catch (Exception ex) { loOraTran.Rollback(); this.ShowException(ex); } finally { DSCRM.DBA.CloseOraConnection(loOraConn); }
InitControl(); }
protected void Button1_Click(object sender, EventArgs e) { Response.Redirect(this.AppendAppInfo("TripFloorListNew.aspx")); }}
