public void ProcessRequest(HttpContext context) { try { context.Response.ContentType = "text/plain"; int PageSize = Convert.ToInt32(context.Request.Params["pagesize"]); int currentpage = Convert.ToInt32(context.Request.Params["page"]); string sWhere = ""; WhereFilter QF = null; //条件 if (context.Request.Params["where"] != null) { QF = new JavaScriptSerializer().Deserialize <WhereFilter>(context.Request.Params["where"]); //sWhere = QF.GetWhere(); } //排序 if (context.Request.Params["sortorder"] != null) { string sortname = context.Request.Params["sortname"]; string sortorder = context.Request.Params["sortorder"]; sWhere += " order by " + sortname + " " + sortorder; } M_Data_Paging <M_CustomerInfo> lstMCusPage = SQLDBHelper.CreateDBClass <M_CustomerInfo_DB>().Query(QF, (currentpage - 1) * PageSize, currentpage * PageSize); //分页 var griddata = new { Rows = lstMCusPage.lstTObj, Total = lstMCusPage.RowCount }; string str = new JavaScriptSerializer().Serialize(griddata); context.Response.Write(str); } catch (Exception ex) { } }
public M_Data_Paging <M_CustomerInfo> Query(WhereFilter wherefilter, int iSIndex, int iEIndex) { using (DBHelperContext dbcon = new DBHelperContext()) { //动态分配条件 var predicate = PredicateBuilder.True <M_CustomerInfo>(); if (wherefilter != null) { foreach (Rules rule in wherefilter.rules) { if (rule.field.Equals("CusCode")) { predicate = predicate.And(p => p.CusCode.Contains(rule.value)); } if (rule.field.Equals("CusName")) { predicate = predicate.And(p => p.CusName.Contains(rule.value)); } } } var mcus = dbcon.M_CustomerInfos.Where(predicate.Compile()); int iRowCount = mcus.Count(); var mcusb = mcus.OrderBy(p => p.CusCode).Skip(iSIndex).Take(iEIndex - iSIndex).ToList(); M_Data_Paging <M_CustomerInfo> mdp_Ccus = new M_Data_Paging <M_CustomerInfo>() { RowCount = iRowCount, lstTObj = mcusb, }; return(mdp_Ccus); } }
public void ProcessRequest(HttpContext context) { try { context.Response.ContentType = "text/plain"; int PageSize = Convert.ToInt32(context.Request.Params["pagesize"]); int currentpage = Convert.ToInt32(context.Request.Params["page"]); string sWhere = ""; WhereFilter QF = null; //条件 if (context.Request.Params["where"] != null) { QF = new JavaScriptSerializer().Deserialize <WhereFilter>(context.Request.Params["where"]); //sWhere = QF.GetWhere(); } //排序 if (context.Request.Params["sortorder"] != null) { string sortname = context.Request.Params["sortname"]; string sortorder = context.Request.Params["sortorder"]; sWhere += " order by " + sortname + " " + sortorder; } //M_User m = new M_User //{ // UserID = "a", // UserName = "******", // UserPwd = "s", // UserPermission = "1,2", // UserState = 1, // Remark = "abc", //}; //bool i = SQLDBHelper.CreateDBClass<M_User_DB>().Add(m); M_Data_Paging <M_User> lstMUserPage = SQLDBHelper.CreateDBClass <M_User_DB>().Query(QF, (currentpage - 1) * PageSize, currentpage * PageSize); //分页 var griddata = new { Rows = lstMUserPage.lstTObj, Total = lstMUserPage.RowCount }; string str = new JavaScriptSerializer().Serialize(griddata); context.Response.Write(str); } catch (Exception ex) { } }
public ActionResult Export(string id) { try { string sWhere = ""; //条件 WhereFilter QF = null; if (!string.IsNullOrEmpty(Request.Params["where"])) { QF = new JavaScriptSerializer().Deserialize <WhereFilter>(Request.Params["where"]); //sWhere = QF.GetWhere(); } //DataTable dt = SQLDBHelper.MUser.QueryDT(sWhere, 1, int.MaxValue); M_Data_Paging <M_User> lstMUserPage = SQLDBHelperClient.CreateUser().Query(QF, 1, int.MaxValue); Stream stream = NPOIExcel.RenderDataTableToExcelHSS(lstMUserPage.lstTObj); ViewBag.Succ = "1"; ViewBag.Msg = "数据下载成功!"; return(File(stream, "application/vnd.ms-excel", DateTime.Now.Ticks + ".xls")); } catch (Exception ex) { return(View("Query")); } }
public M_Data_Paging <M_User> Query(WhereFilter wherefilter, int iSIndex, int iEIndex) { using (DBHelperContext dbcon = new DBHelperContext()) { //动态分配条件 var predicate = PredicateBuilder.True <M_User>(); //List<MemberInfo> lstM =typeof(M_User).GetMembers().ToList(); //var lstC=(from c in lstM // select new { // colName=c.Name, // }).ToList(); //foreach (MemberInfo m in lstM) //{ // modifyEntity.Property(m.Name).IsModified = true; //} if (wherefilter != null) { foreach (Rules rule in wherefilter.rules) { if (rule.field.Equals("UserID")) { predicate = predicate.And(p => p.UserID.Contains(rule.value)); } if (rule.field.Equals("UserName")) { predicate = predicate.And(p => p.UserName.Contains(rule.value)); } } } //if (string.IsNullOrEmpty(wherefilter.UserID)) //{ // predicate = predicate.And(p => p.UserID.Contains(wherefilter.UserID)); //} //if (string.IsNullOrEmpty(wherefilter.UserName)) //{ // predicate = predicate.And(p => p.UserName.Contains(wherefilter.UserName)); //} //predicate = predicate.And(p => p.UserActive.Equals(wherefilter.UserActive)); //if (string.IsNullOrEmpty(wherefilter.Remark)) //{ // predicate = predicate.And(p => p.Remark.Contains(wherefilter.Remark)); //} var musers = dbcon.M_Users.Where(predicate.Compile()); int iRowCount = musers.Count(); var muserb = musers.OrderBy(p => p.UserID).Skip(iSIndex).Take(iEIndex - iSIndex).ToList(); M_Data_Paging <M_User> mdp_Users = new M_Data_Paging <M_User>() { RowCount = iRowCount, lstTObj = muserb, }; return(mdp_Users); } }