Ajax异步刷新和.net后台进行交互

前台代码
<html>
<head>
<title>页面交互</title>
<script type="text/javascript">
function loadXMLDoc() {
var xmlhttp;

var txtQuery = document.getElementById("txtQuery").value;

//XMLHttpRequest 用于在后台与服务器交换数据
if (window.XMLHttpRequest) {
xmlhttp = new XMLHttpRequest();
}
else {
xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
}
//判断是否成功的状态
xmlhttp.onreadystatechange = function() {
//
if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
var data = xmlhttp.responseText;
var Content = "";
Content = "<select id='dllUserInfo'>";
var arr = new Array;
arr = data.split("<br/>");
for (var i = 0; i < arr.length; i++) {
Content += "<option>" + arr[i] + "<option>";
}
Content += "<select>"
document.getElementById("myDiv").innerHTML = Content;
}

}
//规定请求的类型,url及其是否异步处理
xmlhttp.open("GET", "/Test.aspx?UserId="+txtQuery+"", true);
//发送请求
xmlhttp.send();
}
</script>

</head>
<body>
<h2>
AJAX</h2>
用户名:
<input id="txtQuery" type="text" style=" border-bottom-color:Green" />
<input type="button" onclick="loadXMLDoc()" id="btn_Select" value="查询" style="background-color:Red; border:opx; border-color:Blue"/>
<div id="myDiv">
</div>
</body>
</html>

后台代码:
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using Model;
using BLL;
using System.Collections.Generic;

namespace AjaxTest
{
public partial class Test : System.Web.UI.Page
{
BLL.UserInfo us = new BLL.UserInfo();
Model.UserInfo u = new Model.UserInfo();
private string strContent = "";
protected void Page_Load(object sender, EventArgs e)
{
//用户ID
string strUserId = Request.QueryString["USERID"].ToString();
Response.Write(getUserInfo(strUserId));
}

/// <summary>
/// 获取用户信息
/// </summary>
/// <returns></returns>
public string getUserInfo(string strUserId)
{
List<Model.UserInfo> un = us.getUserInfo(strUserId);
strContent = "";
foreach(var i in un)
{
strContent += i.UserId + "<br/>" + i.UserCode + "<br/>" + i.UserName + "<br/>" + i.Content + "<br/>";
//strContent += "<tr><td>" + i.UserId + "</td><td>" + i.UserCode + "</td><td>" + i.UserCode + "</td><td>" + i.Content + "</td></tr>";
}

return strContent;
}
}
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using DAL;

namespace BLL
{
public class UserInfo
{
DAL.getUserinfo gs = new DAL.getUserinfo();

//获取用户信息
public List<Model.UserInfo> getUserInfo(string strUserId)
{
return gs.getUserInfo( strUserId);
}
}
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Collections;
using Model;
using Utility;
using System.Data;

namespace DAL
{
public class getUserinfo
{

List<UserInfo> li = new List<UserInfo>();

/// <summary>
/// 用户信息
/// </summary>
/// <param name="strUserId"></param>
/// <returns></returns>
public List<UserInfo> getUserInfo(string strUserId)
{
string strSql = string.Format(@"select * from USERINFO WHERE (USERID ='{0}' OR '{0}'='')",strUserId);

DataTable dt = SQLHelper.ExecuteDt(strSql);
IList<UserInfo> users = new List<UserInfo>();
return (List<UserInfo>)ConvertHelper.convertToList<UserInfo>(dt);
}

}
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Model
{
public class UserInfo
{
#region Model
private long _userid;
private string _usercode;
private string _username;
private string _content;
//构造函数
public UserInfo()
{
}

/// <summary>
///
/// </summary>
public long UserId
{
set { _userid = value; }
get { return _userid; }
}
/// <summary>
///
/// </summary>
public string UserCode
{
set { _usercode = value; }
get { return _usercode; }
}
/// <summary>
///
/// </summary>
public string UserName
{
set { _username = value; }
get { return _username; }
}

/// <summary>
///
/// </summary>
public string Content
{
set { _content = value; }
get { return _content; }
}

#endregion Model
}
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Reflection;

namespace Utility
{

/// <summary>
/// 将DataTable转换成泛型集合IList<>助手类
/// </summary>
public class ConvertHelper
{
/// <summary>
/// 单表查询结果转换成泛型集合
/// </summary>
/// <typeparam name="T">泛型集合类型</typeparam>
/// <param name="dt">查询结果DataTable</param>
/// <returns>以实体类为元素的泛型集合</returns>
public static IList<T> convertToList<T>(DataTable dt) where T : new()
{
// 定义集合
List<T> ts = new List<T>();

// 获得此模型的类型
Type type = typeof(T);
//定义一个临时变量
string tempName = string.Empty;
//遍历DataTable中所有的数据行
foreach (DataRow dr in dt.Rows)
{
T t = new T();
// 获得此模型的公共属性
PropertyInfo[] propertys = t.GetType().GetProperties();
//遍历该对象的所有属性
foreach (PropertyInfo pi in propertys)
{
tempName = pi.Name;//将属性名称赋值给临时变量
//检查DataTable是否包含此列(列名==对象的属性名)
if (dt.Columns.Contains(tempName))
{
// 判断此属性是否有Setter
if (!pi.CanWrite) continue;//该属性不可写,直接跳出
//取值
object value = dr[tempName];
//如果非空,则赋给对象的属性
if (value != DBNull.Value)
pi.SetValue(t, value, null);
}
}
//对象添加到泛型集合中
ts.Add(t);
}

return ts;
}
}

}

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值