下拉文本选择

aspx:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="AddShip.aspx.cs" Inherits="ShipAgency_AddShip" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<title>新增船舶规范</title>

onload= function foo() {

//国籍

var dataSource = [];

dataSource= ShipAgency_AddShip.GetSearchItemsListCountry();

var textBox = document.getElementById("tbxAddNationality");

var configs = {

instanceName: "auto",

textbox: textBox,

dataSource: dataSource.value

}

window.auto = new neverModules.modules.autocomplete(configs);

//目的港

var dataSourcePort = [];

dataSourcePort = ShipAgency_AddShip.GetSearchItemsListPort();

var textBox_tbxAddSHIPPORT = document.getElementById("tbxAddSHIPPORT");

var configs_tbxAddSHIPPORT = {

instanceName: "auto_tbxAddSHIPPORT",

textbox: textBox_tbxAddSHIPPORT,

dataSource: dataSourcePort.value

}

window.auto_tbxAddSHIPPORT = new neverModules.modules.autocomplete(configs_tbxAddSHIPPORT);

}

</script>

</head>

<body>

<TBODY>

<TR>

<tbody>

<tr>

注册港:</div>

</td>

 </div>

</td>

</td>

</tr>

</tbody>

</table>

<br>

</FIELDSET></TD>

</TR>

</TBODY>

</TABLE>

</div></td>

</tr>

</table> </div>

</form>

</body>

</html>

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 AjaxPro;

using System.Data.OracleClient;

public partial class ShipAgency_AddShip : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

// 在此处放置用户代码以初始化页面

Utility.RegisterTypeForAjax(typeof(ShipAgency_AddShip));

if (!IsPostBack)

{

}

[AjaxMethod()]

public ArrayList GetSearchItemsListCountry(string query)

{

ArrayList items = new ArrayList();

string myConnectionString = LTP.Common.DEncrypt.DESEncrypt.Decrypt(LTP.Common.ConfigHelper.GetConfigString("ConnectionString"));

//"Data Source=JOINTWIN;Persist Security Info=True;User ID=penavico;Password=JointWin2007;Unicode=True";

string mySelectQuery =

string.Format(

"select code,cn from country where code like '{0}%' and cn is not null",

query);

OracleConnection myConnection = new OracleConnection(myConnectionString);

OracleCommand myCommand = new OracleCommand(mySelectQuery, myConnection);

myConnection.Open();

OracleDataReader myReader =

myCommand.ExecuteReader(CommandBehavior.CloseConnection);

while (myReader.Read())

{

items.Add(myReader.GetString(0) + "|" + myReader.GetString(1));

}

myReader.Close();

return items;

}

[AjaxMethod()]

public string[] GetSearchItemsListPort(string query)

{

ArrayList items = new ArrayList();

string myConnectionString = LTP.Common.DEncrypt.DESEncrypt.Decrypt(LTP.Common.ConfigHelper.GetConfigString("ConnectionString"));

string mySelectQuery =

string.Format(

"select en,cn from port where en like '{0}%' and cn is not null",

query);

OracleConnection myConnection = new OracleConnection(myConnectionString);

OracleCommand myCommand = new OracleCommand(mySelectQuery, myConnection);

myConnection.Open();

OracleDataReader myReader =

myCommand.ExecuteReader(CommandBehavior.CloseConnection);

while (myReader.Read())

{

items.Add(myReader.GetString(0) + "|" + myReader.GetString(1));

}

myReader.Close();

//String[] returnList = (String[])items.ToArray(new String[items.Count]);

// String[] strList = new String[items.Count];

// String[] returnList = (String[])items.ToArray(strList);

// string[] returnList = (string[])items.ToArray(new string[items.Count]);

string[] returnList = new string[items.Count];

for (int i = 0; i < items.Count; i++)

{

returnList[i] = items[i].ToString();

}

return returnList;

}

下载: /Files/ipusr/DownText.rar

posted on 2007-04-14 09:59 ipusr 阅读(480) 评论(0) 收藏举报