public PageLayUI <SysLog> listPage(int page, int limit, Dictionary <string, object> conditions) { var skip = page == 1 ? 0 : (page - 1) * limit; Expression <Func <SysLog, bool> > exp = w => 1 == 1; if (!string.IsNullOrEmpty(conditions["searchLogMessage"].ToString())) { exp = exp.And(w => w.Message.Contains(conditions["searchLogMessage"].ToString())); } if (!string.IsNullOrEmpty(conditions["searchLogType"].ToString())) { exp = exp.And(w => w.LogType == conditions["searchLogType"].ToString()); } if (!string.IsNullOrEmpty(conditions["searchLogDateTime"].ToString())) { exp = exp.And(w => w.LogDate == Convert.ToDateTime(conditions["searchLogDateTime"].ToString())); } PageLayUI <SysLog> pageLayUI = new PageLayUI <SysLog>(); pageLayUI.count = _repo.GetList(exp).Count(); pageLayUI.data = _repo.GetList(exp).OrderByDescending(o => o.LogId).Skip(skip).Take(limit).ToList(); return(pageLayUI); }
public PageLayUI <RoleAuty> listPage(int page, int limit, Dictionary <string, object> conditions) { var skip = page == 1 ? 0 : (page - 1) * limit; int.TryParse(conditions["roleID"].ToString(), out int roleid); var auth = _repoAuth.GetList(w => w.AuthorityId > 0); var roleAuth = _repo.GetList(w => w.RoleId == roleid); var authList = from a in auth join r in roleAuth on a.AuthorityId equals r.AuthorityId select new RoleAuty { authorityID = a.AuthorityId, roleAuthorityID = r.RoleAuthorityId, authorityDescribe = a.AuthorityDescribe, authorityName = a.AuthorityName, authorityType = a.AuthorityType, conflictCode = a.ConflictCode }; PageLayUI <RoleAuty> pageLayUI = new PageLayUI <RoleAuty>(); pageLayUI.count = authList.Count(); pageLayUI.data = authList.OrderByDescending(o => o.roleAuthorityID).Skip(skip).Take(limit).ToList(); return(pageLayUI); }
/// <summary> /// 向数据库中插入100条测试数据 /// </summary> /// <returns></returns> public JsonResult List() { var skip = Request.Query["page"] == "1" ? 0 : (Convert.ToInt32(Request.Query["page"]) - 1) * Convert.ToInt32(Request.Query["limit"]); var take = Convert.ToInt32(Request.Query["limit"]); List <PlanReport> planReport = new List <PlanReport>(); for (int i = 1; i <= 100; i++) { planReport.Add(new PlanReport { PlanReportId = i , MaterialCode = ("编码" + i) , MaterialDesc = "描述" + i , MaterialCount = i , PlanReportDept = "部门 " + i , PlanReportPerson = "人员 " + i , MaterialAge = "账龄" + i }); } PageLayUI <PlanReport> pageLayUI = new PageLayUI <PlanReport>(); pageLayUI.count = planReport.Count; pageLayUI.data = planReport.Skip(skip).Take(take).ToList(); return(Json(pageLayUI)); }
public PageLayUI <ErpDetail> listPage(int page, int limit, Dictionary <string, object> conditions) { var skip = page == 1 ? 0 : (page - 1) * limit; var bwartList = new List <string> { " 201", " 301", " z03" }; Expression <Func <ErpDetail, bool> > exp = w => bwartList.Contains(w.Bwart); //if (!string.IsNullOrEmpty(conditions["searchLogMessage"].ToString())) //{ // exp = exp.And(w=>w.Message.Contains(conditions["searchLogMessage"].ToString())); //} //if (!string.IsNullOrEmpty(conditions["searchLogType"].ToString())) //{ // exp = exp.And(w => w.LogType == conditions["searchLogType"].ToString()); //} //if (!string.IsNullOrEmpty(conditions["searchLogDateTime"].ToString())) //{ // exp = exp.And(w=>w.LogDate==Convert.ToDateTime(conditions["searchLogDateTime"].ToString())); //} PageLayUI <ErpDetail> pageLayUI = new PageLayUI <ErpDetail>(); pageLayUI.count = _repo.GetList(exp).Count(); pageLayUI.data = _repo.GetList(exp).OrderByDescending(o => o.CreateTime).Skip(skip).Take(limit).ToList(); return(pageLayUI); }
public PageLayUI <PlanReport> list() { var planReport = _repo.GetList(); PageLayUI <PlanReport> pageLayUI = new PageLayUI <PlanReport>(); pageLayUI.count = planReport.Count(); pageLayUI.data = planReport.ToList(); return(pageLayUI); }
public PageLayUI <ViewMaterialBack> listPage(int page, int limit, Dictionary <string, object> conditions) { var skip = page == 1 ? 0 : (page - 1) * limit; var bwartList = new List <string> { " 202", " 302", " z04", " z79", " 282" }; Expression <Func <ErpDetail, bool> > exp = w => bwartList.Contains(w.Bwart); //if (!string.IsNullOrEmpty(conditions["searchLogMessage"].ToString())) //{ // exp = exp.And(w=>w.Message.Contains(conditions["searchLogMessage"].ToString())); //} //if (!string.IsNullOrEmpty(conditions["searchLogType"].ToString())) //{ // exp = exp.And(w => w.LogType == conditions["searchLogType"].ToString()); //} //if (!string.IsNullOrEmpty(conditions["searchLogDateTime"].ToString())) //{ // exp = exp.And(w=>w.LogDate==Convert.ToDateTime(conditions["searchLogDateTime"].ToString())); //} var backErp = _repo.GetList(exp); var userKq = _repoUserKq.GetList(w => 1 == 1); var result = from s in backErp join u in userKq on s.UserNum.Trim() equals u.UserNum select new ViewMaterialBack { ErpDetailId = s.ErpDetailId, Mblnr = s.Mblnr, Mjahr = s.Mjahr, Bldat = s.Bldat, Matnr = s.Matnr, Maktx = s.Maktx, LgortDesc = s.LgortDesc, LifnrDesc = s.LifnrDesc, Menge = s.Menge, Meins = s.Meins, Rsnum = s.Rsnum, Ktext = s.Ktext, Pspel = s.Pspel, GdNum = s.GdNum, Zthdw = s.Zthdw, UserNum = s.UserNum, CreateTime = s.CreateTime, userDept = u.UserDept, userName = u.UserName }; PageLayUI <ViewMaterialBack> pageLayUI = new PageLayUI <ViewMaterialBack>(); pageLayUI.count = result.Count(); pageLayUI.data = result.OrderByDescending(o => o.CreateTime).Skip(skip).Take(limit).ToList(); return(pageLayUI); }
public PageLayUI <PlanReport> listPage(int page, int limit) { var skip = page == 1 ? 0 : (page - 1) * limit; var planReport = _repo.GetList(); PageLayUI <PlanReport> pageLayUI = new PageLayUI <PlanReport>(); pageLayUI.count = planReport.Count(); pageLayUI.data = planReport.OrderBy(o => o.PlanReportID).Skip(skip).Take(limit).ToList(); return(pageLayUI); }
public PageLayUI <ViewErpStorage> listPage(int page, int limit, Dictionary <string, object> conditions) { var skip = page == 1 ? 0 : (page - 1) * limit; Expression <Func <ErpStorage, bool> > exp = w => 1 == 1; //if (!string.IsNullOrEmpty(conditions["searchLogMessage"].ToString())) //{ // exp = exp.And(w=>w.Message.Contains(conditions["searchLogMessage"].ToString())); //} //if (!string.IsNullOrEmpty(conditions["searchLogType"].ToString())) //{ // exp = exp.And(w => w.LogType == conditions["searchLogType"].ToString()); //} //if (!string.IsNullOrEmpty(conditions["searchLogDateTime"].ToString())) //{ // exp = exp.And(w=>w.LogDate==Convert.ToDateTime(conditions["searchLogDateTime"].ToString())); //} var stock = _repo.GetList(exp); var userKq = _repoUserKq.GetList(w => 1 == 1); var result = from s in stock join u in userKq on s.NameTextc.Trim() equals u.UserNum select new ViewErpStorage { ErpStorageId = s.ErpStorageId, Werks = s.Werks, Lgort = s.Lgort, Lgnum = s.Lgnum, Lgtyp = s.Lgtyp, Lgpla = s.Lgpla, Matnr = s.Matnr, Maktx = s.Maktx, Matkl = s.Matkl, Verme = s.Verme, Salk = s.Salk, Msehl = s.Msehl, Wdatu = s.Wdatu, NameTextc = s.NameTextc, Aging = s.Aging, userDept = u.UserDept, userName = u.UserName }; PageLayUI <ViewErpStorage> pageLayUI = new PageLayUI <ViewErpStorage>(); pageLayUI.count = result.Count(); pageLayUI.data = result.OrderByDescending(o => o.ErpStorageId).Skip(skip).Take(limit).ToList(); return(pageLayUI); }
public PageLayUI <UserInfo> listPage(int page, int limit, Dictionary <string, object> conditions) { var skip = page == 1 ? 0 : (page - 1) * limit; Expression <Func <SysUserInfo, bool> > exp = w => 1 == 1; if (!string.IsNullOrEmpty(conditions["searchUserName"].ToString())) { exp = exp.And(w => w.UserName.Contains(conditions["searchUserName"].ToString())); } //var deptList = conditions["searchUserName"].ToString().Split(','); //exp = exp.And(w => deptList.Contains(w.UserDeptId.ToString())); Expression <Func <SysDeptInfo, bool> > expDept = w => 1 == 1; if (!string.IsNullOrEmpty(conditions["selectDeptID"].ToString())) { expDept = expDept.And(w => w.DeptId == Convert.ToInt32(conditions["selectDeptID"].ToString())); } var user = _repoUser.GetList(exp); var dept = _repoDept.GetList(expDept); var userInfo = from u in user join d in dept on u.UserDeptId equals d.DeptId select new UserInfo { UserDeptName = d.DeptName, UserAuthorityList = u.UserAuthorityList, UserDeptCtrlList = u.UserDeptCtrlList, UserDeptId = u.UserDeptId, UserDuty = u.UserDuty, UserEmail = u.UserEmail, UserId = u.UserId, UserMobile = u.UserMobile, UserPhone = u.UserPhone, UserName = u.UserName, UserNum = u.UserNum, UserPwd = u.UserPwd, UserRemark = u.UserRemark, UserState = u.UserState }; PageLayUI <UserInfo> pageLayUI = new PageLayUI <UserInfo>(); pageLayUI.count = userInfo.Count(); pageLayUI.data = userInfo.OrderBy(o => o.UserId).Skip(skip).Take(limit).ToList(); return(pageLayUI); }
public PageLayUI <SysRoleInfo> listPage(int page, int limit, Dictionary <string, object> conditions) { var skip = page == 1 ? 0 : (page - 1) * limit; Expression <Func <SysRoleInfo, bool> > exp = w => 1 == 1; if (!string.IsNullOrEmpty(conditions["searchRoleName"].ToString())) { exp = exp.And(w => w.RoleName.Contains(conditions["searchRoleName"].ToString())); } PageLayUI <SysRoleInfo> pageLayUI = new PageLayUI <SysRoleInfo>(); pageLayUI.count = _repo.GetList(exp).Count(); pageLayUI.data = _repo.GetList(exp).OrderBy(o => o.RoleId).Skip(skip).Take(limit).ToList(); return(pageLayUI); }
public PageLayUI <PlanReport> listPage(int page, int limit, Dictionary <string, object> whereList) { var skip = page == 1 ? 0 : (page - 1) * limit; var planReport = _repo.GetEntities(w => w.PlanReportId > 0); if (!string.IsNullOrEmpty(whereList["tbxMaterialName"].ToString())) { planReport = planReport.Where(w => w.MaterialCode.Contains(whereList["tbxMaterialName"].ToString())); } if (!string.IsNullOrEmpty(whereList["tbxMaterialNum"].ToString())) { planReport = planReport.Where(w => w.MaterialDesc.Contains(whereList["tbxMaterialNum"].ToString())); } PageLayUI <PlanReport> pageLayUI = new PageLayUI <PlanReport>(); pageLayUI.count = planReport.Count(); pageLayUI.data = planReport.OrderBy(o => o.PlanReportId).Skip(skip).Take(limit).ToList(); return(pageLayUI); }
public PageLayUI <SysAuthorityInfo> listPage(int page, int limit, Dictionary <string, object> whereList) { var skip = page == 1 ? 0 : (page - 1) * limit; var info = _repo.GetEntities(w => w.AuthorityId > 0); if (!string.IsNullOrEmpty(whereList["searchAuthorityName"].ToString())) { info = info.Where(w => w.AuthorityName.Contains(whereList["searchAuthorityName"].ToString())); } if (!string.IsNullOrEmpty(whereList["searchAuthorityType"].ToString())) { info = info.Where(w => w.AuthorityType == whereList["searchAuthorityType"].ToString()); } PageLayUI <SysAuthorityInfo> pageLayUI = new PageLayUI <SysAuthorityInfo>(); pageLayUI.count = info.Count(); pageLayUI.data = info.OrderBy(o => o.AuthorityId).Skip(skip).Take(limit).ToList(); return(pageLayUI); }
public PageLayUI <SysAuthorityInfo> listPage(int page, int limit, Dictionary <string, object> whereList) { var skip = page == 1 ? 0 : (page - 1) * limit; //Expression<Func<SysAuthorityInfo, bool>> exp =null; Expression <Func <SysAuthorityInfo, bool> > exp = w => 1 == 1; if (!string.IsNullOrEmpty(whereList["searchAuthorityName"].ToString())) { exp = exp.And(w => w.AuthorityName.Contains(whereList["searchAuthorityName"].ToString())); } if (!string.IsNullOrEmpty(whereList["searchAuthorityType"].ToString())) { exp = exp.And(w => w.AuthorityType == whereList["searchAuthorityType"].ToString()); } PageLayUI <SysAuthorityInfo> pageLayUI = new PageLayUI <SysAuthorityInfo>(); pageLayUI.count = _repo.GetList(exp).Count(); pageLayUI.data = _repo.GetList(exp).OrderBy(o => o.AuthorityId).Skip(skip).Take(limit).ToList(); return(pageLayUI); }