网站的后台，多数是需要使用datatable来展示数据的，因为datatable的功能比较强大，可以更好的使用。

引用css

html代码

            
    
            
               
                 
     -            
                 
     搜索        
    
        
            
    
            
     
                      
                           
                                
编号
                                
手机号码
                                
真实姓名
                                
支付宝
                                
支付宝二维码
                                
微信
                                
微信二维码
                                
开户银行
                                
银行卡号
                                
开户人
                                
账户余额
                                
添加时间
                                
操作
                           
                      
                      
                 
        
    

js代码

服务端代码

private object data = "";        private object result = "";        private int sEcho, iDisplayStart, iDisplayLength, sortid, count;        private bool sorttype;        protected void Page_Load(object sender, EventArgs e)        {            string act = null;            try            {                act = Request["action"].ToString();                sEcho = Convert.ToInt32(Request["sEcho"]);                iDisplayStart = Convert.ToInt32(Request["iDisplayStart"]);//开始记录数                iDisplayLength = Convert.ToInt32(Request["iDisplayLength"]);//结束记录数                if (!int.TryParse(Request["iSortCol_0"], out sortid))//按哪列来排序                {                    sortid = -1;                }                sorttype = Request["sSortDir_0"] == "asc" ? false : true;//升序还是降序                if (!string.IsNullOrEmpty(act))                {                    switch (act)                    {                        case "GetWorkerData": GetWorkerData(); break;//获取工作人员信息                    }                }                result = data;            }            catch (Exception ex)            {                result = ReturnMsg(Enum_return.失败, ex.Message, null);            }            Response.Write(result);        }        #region 获取工作人员        private void GetWorkerData()        {            //按条件搜索            string mobile = Request["mobile"];//手机号码            string realname = Request["realname"];//用户类型            string logintimestart = Request["logintimestart"];//登录时间开始            string logintimeend = Request["logintimeend"];//登录时间结束            //获取所有数据            List
    
      list = null;            IQueryable
     
       result = Ctx.yw_houseAgent_worker;            #region 排序区分            switch (sortid)            {                case 0:                    if (sorttype) result = result.OrderByDescending(c => c.workerID);                    else result = result.OrderBy(c => c.workerID);                    break;                case 1:                    if (sorttype) result = result.OrderByDescending(c => c.mobile);                    else result = result.OrderBy(c => c.mobile);                    break;                case 2:                    if (sorttype) result = result.OrderByDescending(c => c.realName);                    else result = result.OrderBy(c => c.realName);                    break;                case 3:                    if (sorttype) result = result.OrderByDescending(c => c.alipay);                    else result = result.OrderBy(c => c.alipay);                    break;                case 5:                    if (sorttype) result = result.OrderByDescending(c => c.wechat);                    else result = result.OrderBy(c => c.wechat);                    break;                case 7:                    if (sorttype) result = result.OrderByDescending(c => c.bank);                    else result = result.OrderBy(c => c.bank);                    break;                case 8:                    if (sorttype) result = result.OrderByDescending(c => c.bankCardNumber);                    else result = result.OrderBy(c => c.bankCardNumber);                    break;                case 9:                    if (sorttype) result = result.OrderByDescending(c => c.bankCardName);                    else result = result.OrderBy(c => c.bankCardName);                    break;                case 10:                    if (sorttype) result = result.OrderByDescending(c => c.fund);                    else result = result.OrderBy(c => c.fund);                    break;                case 11:                    if (sorttype) result = result.OrderByDescending(c => c.addTime);                    else result = result.OrderBy(c => c.addTime);                    break;                default:                    if (sorttype) result = result.OrderByDescending(c => c.workerID);                    else result = result.OrderBy(c => c.workerID);                    break;            }            #endregion            if (!string.IsNullOrEmpty(mobile) || !string.IsNullOrEmpty(realname) || !string.IsNullOrEmpty(logintimestart) || !string.IsNullOrEmpty(logintimeend)) //搜索情况            {                #region 搜索情况                if (mobile.Trim().Length > 0)//手机号码                {                    result = result.Where(c => c.mobile.Contains(mobile));                }                if (realname.Trim().Length > 0)//姓名                {                    result = result.Where(c => c.realName.Contains(realname));                }                if (logintimestart.Trim().Length > 0 && logintimeend.Trim().Length > 0)//搜索查询时间                {                    DateTime bstart = Convert.ToDateTime(logintimestart);                    DateTime bend = Convert.ToDateTime(logintimeend);                    result = result.Where(c => c.addTime >= bstart && c.addTime <= bend);                }                #endregion            }            count = result.Where(c => c.serialID == CurrentSerialID && c.isDelete == false).Count();            list = result.Where(c => c.serialID == CurrentSerialID && c.isDelete == false).Skip(iDisplayStart).Take(iDisplayLength).ToList();            string str = SerializeTableData(sEcho, count, list);            Response.Write(str);            Response.End();        }        #endregion