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_id
where 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"));
}
}