asp.net与JQuery EasyUi DataGrid 服务器端分页，添加增加，修改，删除按钮

来源：互联网发布：淘宝上传图片尺寸大小编辑：程序博客网时间：2024/05/01 17:55

Html代码

js代码

columns: [[
{field: 'CompName', title: '公司名称' },
{ field: 'mailNum', title: '信箱号' },
{ field: 'ShowName', title: '显示方式' },
{ field: 'opt', title: '操作', formatter: formatData }
]]

});
//设置分页控件
var p = $('#ReceiveList').datagrid('getPager');
$(p).pagination({
beforePageText: '第',
afterPageText: '页共 {pages} 页',
displayMsg: '当前显示 {from} - {to} 条记录共 {total} 条记录'
});
});

//查询后重新设置url
function serachfun() {
var copmname = $.trim($('#compname').val());
$('#ReceiveList').datagrid({
                  url: 'DealData.ashx?r=' +Math.random,
               method: 'get',
               queryParams: { "action": "query","compname": $.trim($('#compname').val()) },              });
// alert('ok');
}

//每一行添加查看、编辑、删除按钮
function formatData (value, row, index) {
var s = '<a href="#" onclick="view(\'' + row.CompName + '\')">查看</a> ';
var e = '<a href="#" onclick="edit(\'' + row.CompName + '\')">编辑</a> ';
var d = '<a href="#" onclick="del(\'' + row.CompName + '\')">删除</a> ';
return s + e + d;
// var str = '<a href="#" class="easyui-linkbutton" onclick="serach(\'' + row.CompName + '\')">明细</a>';
// return str;
}

function view(compname) {
alert('查看');
}
function edit(compname) {
alert('编辑');
}
function del(compname) {
alert('删除');
}
</script>

后台代码

DealData.ashx

public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
int intPageSize = int.Parse(context.Request["rows"].ToString());
int intCurrentPage = int.Parse(context.Request["page"].ToString());
                      string strJson = "";
            if (context.Request["action"] == "query")
            {
                string compname = context.Request["compname"].ToString();
                int totalSize;
                DataTable dt = new AdvertInfoManager().getPartAdvert(compname, intPageSize, intCurrentPage, out totalSize);
                strJson = DataTableJson(dt, totalSize);
            }
            context.Response.Write(strJson);
        }

//返回json
public static string DataTableJson(DataTable dt, int totalSize)
{
StringBuilder jsonBuilder = new StringBuilder();
jsonBuilder.Append("{");
jsonBuilder.Append("\"total\":" + totalSize);
jsonBuilder.Append(",");
jsonBuilder.Append("\"rows\":[");
for (int i = 0; i < dt.Rows.Count; i++)
{
jsonBuilder.Append("{");
for (int j = 0; j < dt.Columns.Count; j++)
{
jsonBuilder.Append("\"");
jsonBuilder.Append(dt.Columns[j].ColumnName);
jsonBuilder.Append("\":\"");
jsonBuilder.Append(dt.Rows[i][j].ToString());
jsonBuilder.Append("\",");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("},");
} jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("]");
jsonBuilder.Append("}");
return jsonBuilder.ToString();
}

//数据库查询

public DataTable getPartAdvert(string compname,int intPageSize, int intCurrentPage, out int totalSize)
{
string sql = @"select RowNumber,CompName,ShowName,mailNum from ( SELECT ROW_NUMBER() OVER (ORDER BY CompName) AS RowNumber,CompName ,ShowName,b.mailNum FROM T_AdvertInfo a,T_MailToAdvert b,LedShowStyle c, LedFontStyle d,ColorStyle e where a.AdvGUID=b.AdvGUID and c.showstyle=a.showstyle and d.showFont=a.showFont and e.showColor=a.showColor) A where RowNumber>=" + (intPageSize * (intCurrentPage - 1) + 1) + " and RowNumber<=" + intPageSize * intCurrentPage;
string sql2 = "select count(*) from T_AdvertInfo where 1=1 ";
if (compname!="")
{
sql += " and CompName like '%"+compname+"%'";
sql2 += " and CompName like '%" + compname + "%'";
}
totalSize = Convert.ToInt32(DBHelper.getData(sql2).Rows[0][0].ToString());
return DBHelper.getData(sql);
}

asp.net与JQuery EasyUi DataGrid 服务器端分页，添加增加，修改，删除 按钮

Html代码

js代码

后台代码

asp.net与JQuery EasyUi DataGrid 服务器端分页，添加增加，修改，删除按钮