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);
}
