110,536
社区成员
发帖
与我相关
我的任务
分享
public ActionResult GetVipInfo()
{
UserBLL bll = new UserBLL();
var dt = bll.GetUserInfoALL();
var a = bll.GetUserCount();//获取表行数
string dtt = "["; foreach (DataRow dr in dt.Rows)
dtt += "{UserID:'" + dr["UserID"].ToString() + "',UserName:'" + dr["UserName"].ToString() + "',UsrePass:'" + dr["UserPass"].ToString().Replace("'", "\\'") + "'},"; dtt = dtt.Trim(',') + "]";//去掉最后一个逗号并且闭合json对象数组
return Json(new { Rows = dtt }, JsonRequestBehavior.AllowGet);
}
$.ajax({
url: '/VipList/GetVipInfo',
type: "get",
datatype: "json",
success: function (data) {
alert(JSON.stringify(data))
},
error: function (message) {
alert("查询失败");
// LG.tip(message);
}
});
function finitGrid() {
var ajaxurl = document.location.serach;
debugger;
var gridparms = [];
gridparms.push({ name: "UserID", display: "主键" });
gridparms.push({ name: "UserName", display: "姓名" });
gridparms.push({ name: "UserPass",display:"密码"})
grid = $("#maingrid").ligerGrid({
columns: GetListColumns(),
checkbox: false,
url:ajaxurl,
height:'100%',
heightDiff:-5,
dataAction: 'server',
usePager: false,
rownumbers: true,
frozenRownumbers: false,
fixedCellHeight:false
});
}
})