javascript 异步页面查询实现代码(asp.net)_javascript技巧
程序员文章站
2022-04-20 19:43:39
...
1。 testlist.aspx页面:
function ACClient( queryurl, width, objInput, objLable )
{
this.xmldom = getXmlhttp();
this.queryurl = queryurl;
this.prolist = new Array();
this.divwidth = width;
this.objInput = objInput;
this.getEligible = function(ac) {
var eligible = new Array();
if (ac.inputText.length document.getElementById(objInput.name).value = "";
document.getElementById(objLable.name).value = "";
return eligible;
}
var strURL = this.queryurl + escape(ac.inputText) + "&rand=" + Math.random();
this.xmldom.open("GET", strURL, false);
try {
this.xmldom.send();
}
catch (e) {
return;
}
this.prolist = this.xmldom.responseXML.documentElement.selectNodes("/duxion/object");
if (0 == this.prolist.length) {
return eligible;
}
for (var i = 0; i if (i > 15)
break;
var node = this.prolist.item(i);
eligible[eligible.length] = node.getAttribute("fullcontent");
}
ac.div.style.width = this.divwidth;
return eligible;
};
this.useSuggestion = function( sel )
{
if( sel>=0 )
{
var node = this.prolist.item(sel);
if(typeof(node.getAttribute( "value" )) != "undefined")
document.getElementById(objInput.name).value = node.getAttribute( "value" );
else
document.getElementById(objInput.name).value = "";
if(typeof(node.getAttribute( "content" )) != "undefined")
document.getElementById(objLable.name).value = node.getAttribute( "content" );
else
document.getElementById(objLable.name).value = "";
if (this.objInput.name == "hidfreq_code") {
document.getElementById("txtfreq_name").value = node.getAttribute("Name");
document.getElementById("hidfreq_code").value = node.getAttribute("Code");
}
}
};
return this;
}
2。 供查询的xml的testxml.aspx.cs文件
public partial class testXml : BaseForm
{
protected void Page_Load(object sender, EventArgs e)
{
ListXmlData();
}
private string[] arrwidth;
private string[] arrfield;
public string fieldlist = "区域Id,区域名,区域编码,区域层次";
public string coloumwidth = "60,10,20,30";
//显示xml格式数据
private void ListXmlData()
{
//各字段的宽度
string strwhere="";
if (Request["value"] != null)
{
strwhere = string.Format(" and Code like '{0}%'", Request["value"].ToString());
}
arrfield = fieldlist.Split(',');
arrwidth = coloumwidth.Split(',');
DataTable dtList = new Districts().Search("1=1" + strwhere);// dis // SqlHelper.GetTable(subsys_db, CommandType.Text, strsql, null);
int list_cols = dtList.Columns.Count; //字段数
int list_rows = dtList.Rows.Count; //记录数
string listlable = ""; //显示内容
XmlDocument xmldoc = new XmlDocument();
XmlDeclaration dec = xmldoc.CreateXmlDeclaration("1.0", "gb2312", null);
xmldoc.InsertBefore(dec, xmldoc.FirstChild);
XmlElement root = xmldoc.CreateElement("duxion");
xmldoc.AppendChild(root);
//显示表头
if (list_rows > 0)
{
XmlElement objtitle = xmldoc.CreateElement("object");
for (int k = 0; k {
listlable += "" + arrfield[k] + "";
if (k == arrfield.Length - 1)
break;
}
objtitle.SetAttribute("fullcontent", listlable);
root.AppendChild(objtitle);
}
//显示表头
//显示数据
for (int i = 0; i {
listlable = "";
DataRow drList = dtList.Rows[i];
XmlElement obj = xmldoc.CreateElement("object");
for (int j = 0; j {
obj.SetAttribute(dtList.Columns[j].ColumnName, drList[j].ToString());
if (j {
//listlable += "" + GetLeftString(drList[j].ToString(), Convert.ToInt16(arrwidth[j])) + "";
listlable += "" + formatXmlNode(dtList.Columns[j].DataType.ToString(), drList[j].ToString()) + "";
}
}
obj.SetAttribute("fullcontent", listlable);
root.AppendChild(obj);
}
//显示数据
//Response.ContentType = "text/xml;charset=utf-8";
//Response.ContentType = "text/xml;charset=gb2312";
Response.ContentEncoding = System.Text.Encoding.Default;
Response.ContentType = "text/xml";
Response.Clear();
Response.Write(xmldoc.OuterXml);
Response.End();
}
private string formatXmlNode(string field_type, string field_value)
{
string return_value = field_value.Trim();
switch (field_type)
{
case "System.Double":
case "System.Decimal":
return_value = string.Format("{0:0.###}", Convert.ToDouble(return_value));
break;
}
return return_value;
}
}
3.效果图:
4。 另外的.js以及.css文件见附件
复制代码 代码如下:
function ACClient( queryurl, width, objInput, objLable )
{
this.xmldom = getXmlhttp();
this.queryurl = queryurl;
this.prolist = new Array();
this.divwidth = width;
this.objInput = objInput;
this.getEligible = function(ac) {
var eligible = new Array();
if (ac.inputText.length document.getElementById(objInput.name).value = "";
document.getElementById(objLable.name).value = "";
return eligible;
}
var strURL = this.queryurl + escape(ac.inputText) + "&rand=" + Math.random();
this.xmldom.open("GET", strURL, false);
try {
this.xmldom.send();
}
catch (e) {
return;
}
this.prolist = this.xmldom.responseXML.documentElement.selectNodes("/duxion/object");
if (0 == this.prolist.length) {
return eligible;
}
for (var i = 0; i if (i > 15)
break;
var node = this.prolist.item(i);
eligible[eligible.length] = node.getAttribute("fullcontent");
}
ac.div.style.width = this.divwidth;
return eligible;
};
this.useSuggestion = function( sel )
{
if( sel>=0 )
{
var node = this.prolist.item(sel);
if(typeof(node.getAttribute( "value" )) != "undefined")
document.getElementById(objInput.name).value = node.getAttribute( "value" );
else
document.getElementById(objInput.name).value = "";
if(typeof(node.getAttribute( "content" )) != "undefined")
document.getElementById(objLable.name).value = node.getAttribute( "content" );
else
document.getElementById(objLable.name).value = "";
if (this.objInput.name == "hidfreq_code") {
document.getElementById("txtfreq_name").value = node.getAttribute("Name");
document.getElementById("hidfreq_code").value = node.getAttribute("Code");
}
}
};
return this;
}
2。 供查询的xml的testxml.aspx.cs文件
复制代码 代码如下:
public partial class testXml : BaseForm
{
protected void Page_Load(object sender, EventArgs e)
{
ListXmlData();
}
private string[] arrwidth;
private string[] arrfield;
public string fieldlist = "区域Id,区域名,区域编码,区域层次";
public string coloumwidth = "60,10,20,30";
//显示xml格式数据
private void ListXmlData()
{
//各字段的宽度
string strwhere="";
if (Request["value"] != null)
{
strwhere = string.Format(" and Code like '{0}%'", Request["value"].ToString());
}
arrfield = fieldlist.Split(',');
arrwidth = coloumwidth.Split(',');
DataTable dtList = new Districts().Search("1=1" + strwhere);// dis // SqlHelper.GetTable(subsys_db, CommandType.Text, strsql, null);
int list_cols = dtList.Columns.Count; //字段数
int list_rows = dtList.Rows.Count; //记录数
string listlable = ""; //显示内容
XmlDocument xmldoc = new XmlDocument();
XmlDeclaration dec = xmldoc.CreateXmlDeclaration("1.0", "gb2312", null);
xmldoc.InsertBefore(dec, xmldoc.FirstChild);
XmlElement root = xmldoc.CreateElement("duxion");
xmldoc.AppendChild(root);
//显示表头
if (list_rows > 0)
{
XmlElement objtitle = xmldoc.CreateElement("object");
for (int k = 0; k {
listlable += "" + arrfield[k] + "";
if (k == arrfield.Length - 1)
break;
}
objtitle.SetAttribute("fullcontent", listlable);
root.AppendChild(objtitle);
}
//显示表头
//显示数据
for (int i = 0; i {
listlable = "";
DataRow drList = dtList.Rows[i];
XmlElement obj = xmldoc.CreateElement("object");
for (int j = 0; j {
obj.SetAttribute(dtList.Columns[j].ColumnName, drList[j].ToString());
if (j {
//listlable += "" + GetLeftString(drList[j].ToString(), Convert.ToInt16(arrwidth[j])) + "";
listlable += "" + formatXmlNode(dtList.Columns[j].DataType.ToString(), drList[j].ToString()) + "";
}
}
obj.SetAttribute("fullcontent", listlable);
root.AppendChild(obj);
}
//显示数据
//Response.ContentType = "text/xml;charset=utf-8";
//Response.ContentType = "text/xml;charset=gb2312";
Response.ContentEncoding = System.Text.Encoding.Default;
Response.ContentType = "text/xml";
Response.Clear();
Response.Write(xmldoc.OuterXml);
Response.End();
}
private string formatXmlNode(string field_type, string field_value)
{
string return_value = field_value.Trim();
switch (field_type)
{
case "System.Double":
case "System.Decimal":
return_value = string.Format("{0:0.###}", Convert.ToDouble(return_value));
break;
}
return return_value;
}
}
3.效果图:
4。 另外的.js以及.css文件见附件
上一篇: Oracle 对数据文件大小的限制
下一篇: 恢复SQLSERVER被误删除的数据
推荐阅读
-
JavaScript实现移动端页面按手机屏幕分辨率自动缩放的最强代码
-
JavaScript文件的同步和异步加载的实现代码
-
纯html+css+javascript实现楼层跳跃式的页面布局(实例代码)
-
JavaScript在ASP页面中实现掩码文本框效果代码
-
JavaScript实现星座查询功能 附详细代码
-
JavaScript中两种链式调用实现代码_javascript技巧
-
javascript算法学习实现代码_javascript技巧
-
google地图的路线实现代码_javascript技巧
-
通过正则格式化url查询字符串实现代码_javascript技巧
-
基于jquery的高性能td和input切换并可修改内容实现代码_javascript技巧