public ActionResult GetUserInfoList()
{
int pageIndex = Request["page"] != null?int.Parse(Request["page"]) : 1;
int pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 5;
//接收搜索条件
string userName = Request["name"];
string userRemark = Request["remark"];
int totalCount = 0;
//构建搜索条件
UserInfoSearch userInfoSearch = new UserInfoSearch
{
UserName = userName,
UserRemark = userRemark,
PageIndex = pageIndex,
PageSize = pageSize,
TotalCount = totalCount
};
short delFlag = (short)DeleteEnumType.Normarl;
var userInfoList = UserInfoService.LoadSeachEntities(userInfoSearch, delFlag);
var temp = from u in userInfoList
select new
{
u.ID,
u.UName,
u.UPwd,
u.Remark,
u.SubTime
};
return(Json(new { rows = temp, total = userInfoSearch.TotalCount }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 加载用户收据
/// </summary>
/// <returns></returns>
public ActionResult GetUserInfo()
{
int pageIndex = Request["page"] != null?int.Parse(Request["page"]) : 1;
int pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 5;
//接受的搜索条件
string uName = Request["name"];
string uRemark = Request["remark"];
int totalCount = 0;
//构建搜索的条件
UserInfoSearch userInfoSearch = new UserInfoSearch()
{
UName = uName,
URemark = uRemark,
PageIndex = pageIndex,
PageSize = pageSize,
TotalCount = totalCount
};
short delFlag = (short)DelFlagEnum.Normal;
var userInfoList = UserInfoService.LoadSearchEntities(userInfoSearch); //搜索
//var userList = UserInfoService.LoadPageEntities<int>(pageIndex, pageSize, out totalCount, u => u.DelFlag == delFlag, u => u.ID, true);
var temp = from u in userInfoList
select new { u.ID, UserName = u.UName, UserPwd = u.UPwd, u.SubTime, u.Remark };
return(Json(new { rows = temp, total = userInfoSearch.TotalCount }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 展示数据
/// </summary>
/// <returns></returns>
public ActionResult GetUserInfoList()
{
//请求报文里有两个参数:page和rows
int pageIndex = Request["page"] == null ? 1 : int.Parse(Request["page"]);
int pageSize = Request["rows"] == null ? 5 : int.Parse(Request["rows"]);
//var temp = Bll.LoadPageEntities<int>(pageIndex, pageSize, out int pageCount, true, u => u.DelFlag == (short)DeleteEnumType.Normal, u => u.ID);
UserInfoSearch userInfoSearch = new UserInfoSearch()
{
PageIndex = pageIndex,
PageSize = pageSize,
UserName = Request["name"],
UserRemark = Request["remark"]
};
//执行完下面这个方法后userInfoSearch.PageCount才有值
var temp = UserInfoBll.LoadSearchEntities(userInfoSearch, DeleteEnumType.Normal);
var userInfoList = from u in temp
select new
{
//下面可以注释的原因：自己看吧
/*ID = */
u.ID,
/*UName = */
u.UName,
/*UPwd = */
u.UPwd,
/*Remark = */
u.Remark,
SubTime = u.SubTime
};
return(Json(new { total = userInfoSearch.PageCount, rows = userInfoList }));
}
public ActionResult GetAllUserItem(UserInfoSearch search, int currRoleId, string currUserIds)
{
ViewBag.RoleId = currRoleId;
ViewBag.CurrUserIds = currUserIds;
BL.UserInfo userBL = new BL.UserInfo();
UserInfoModel usermodel = new Model.SystemMaint.UserInfo.UserInfoModel();
usermodel.List = userBL.GetAllItemById(search);
usermodel.Search = search;
return(PartialView("_UserSelectDialog", usermodel));
}
// GET: UserInfo
public ActionResult Index(UserInfoSearch userInfoSearch, int?page)
{
int pageIndex = page ?? 1;
int totalCount = 0;
var dd = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"];
IEnumerable <UserInfo> list = _UserInfoService.GetPagedList(userInfoSearch, out totalCount);
ViewBag.List = list.ToPagedList(1, 10);
//var usersAsIPagedList = new StaticPagedList<UserInfo>(list, pageIndex, 10, totalCount);
return(View(userInfoSearch));
}
public PagedResponse <UserInfoDto> Execute(UserInfoSearch search)
{
var query = _context.Users.AsQueryable();
if (!string.IsNullOrEmpty(search.Username) || !string.IsNullOrWhiteSpace(search.Username))
{
query = query.Where(u => u.Username.ToLower().Contains(search.Username.ToLower()));
}
if (!string.IsNullOrEmpty(search.Name) || !string.IsNullOrWhiteSpace(search.Name))
{
query = query.Where(u => u.Name.ToLower().Contains(search.Name.ToLower()));
}
if (!string.IsNullOrEmpty(search.Surname) || !string.IsNullOrWhiteSpace(search.Surname))
{
query = query.Where(u => u.Surname.ToLower().Contains(search.Surname.ToLower()));
}
if (search.Birthdate != null)
{
query = query.Where(u => u.Birthdate < search.Birthdate);
}
if (search.RoleId != null)
{
query = query.Where(u => u.RoleId == search.RoleId);
}
var currentPage = search.Page;
var perPage = search.PerPage;
var skip = perPage * (currentPage - 1);
return(new PagedResponse <UserInfoDto>
{
CurrentPage = currentPage,
ItemsPerPage = perPage,
TotalCount = query.Count(),
Items = query.Skip(skip).Take(perPage).Select(x => new UserInfoDto
{
Id = x.Id,
Username = x.Username,
Name = x.Name,
Surname = x.Surname,
Email = x.Email,
Phone = (int)x.Phone,
Birthdate = x.Birthdate,
CvPath = x.CvPath,
AvatarPath = x.AvatarPath,
AvatarAlt = x.AvatarAlt
})
});
}
public IQueryable <UserInfo> LoadSearchPageEntities(UserInfoSearch us)
{
var temp = LoadEntities(c => true);
if (!string.IsNullOrEmpty(us.Name))
{
temp = temp.Where(w => w.Name.Contains(us.Name));
}
if (!string.IsNullOrEmpty(us.Remark))
{
temp = temp.Where(w => w.Remark.Contains(us.Name));
}
us.TotalCount = temp.Count();
return(temp.OrderBy <UserInfo, string>(o => o.Name).Skip <UserInfo>((us.PageIndex - 1) * us.PageSize).Take <UserInfo>(us.PageSize).OrderBy(s => s.ID));
}
//public override void GetCurrentDAL()
//{
// this.CurrentDAL = this.DbSession.UserInfoDAL;
//}
public IQueryable <UserInfo> LoadSearchPage(UserInfoSearch userInfoSearch)
{
IQueryable <UserInfo> list = CurrentDAL.LoadEntity(u => u.DelFlag == 0);
if (!string.IsNullOrEmpty(userInfoSearch.UserName))
{
list = list.Where(u => u.UName.Contains(userInfoSearch.UserName));
}
if (!string.IsNullOrEmpty(userInfoSearch.Remark))
{
list = list.Where(u => u.Remark.Contains(userInfoSearch.Remark));
}
userInfoSearch.TotalCount = list.Count();
return(list.OrderBy <UserInfo, int>(u => u.ID).Skip <UserInfo>((userInfoSearch.PageIndex - 1) * userInfoSearch.PageSize).Take <UserInfo>(userInfoSearch.PageSize));
}
public IQueryable <UserInfo> LoadSerachEntities(UserInfoSearch userInfoSearch, short delFlag)
{
var temp = CurrentDal.LoadEntities(u => u.DelFlag == delFlag);
if (!string.IsNullOrEmpty(userInfoSearch.UName))
{
temp = temp.Where(u => u.UName.Contains(userInfoSearch.UName));
}
if (!string.IsNullOrEmpty(userInfoSearch.Remark))
{
temp = temp.Where(u => u.Remark.Contains(userInfoSearch.Remark));
}
userInfoSearch.TotalCount = temp.Count();
return(temp.OrderBy(u => u.ID).Skip((userInfoSearch.PageIndex - 1) * userInfoSearch.PageSize).Take(userInfoSearch.PageSize));
}
/// <summary>
/// 完成用户信息搜索
/// </summary>
/// <param name="userInfoSearch"></param>
/// <returns></returns>
public IQueryable <UserInfo> LoadSearchEntities(UserInfoSearch userInfoSearch)
{
var temp = this.DbSession.UserInfoDal.LoadEntities(u => u.DelFlag == 0);
if (!string.IsNullOrEmpty(userInfoSearch.UName))
{
temp = temp.Where <UserInfo>(u => u.UName.Contains(userInfoSearch.UName));
}
if (!string.IsNullOrEmpty(userInfoSearch.URemark))
{
temp = temp.Where <UserInfo>(u => u.Remark.Contains(userInfoSearch.URemark));
}
userInfoSearch.TotalCount = temp.Count();
return(temp.OrderBy <UserInfo, int>(u => u.ID).Skip <UserInfo>((userInfoSearch.PageIndex - 1) * userInfoSearch.PageSize).Take <UserInfo>(userInfoSearch.PageSize));
}
/// <summary>
/// 完成用户信息的搜索
/// </summary>
/// <param name="userInfoSearch">封装的搜索条件数据</param>
/// <returns></returns>
public IQueryable <UserInfo> LoadSearchEntities(UserInfoSearch userInfoSearch, byte state)
{
var temp = CurrentDbSession.UserInfoDal.LoadEntities(o => o.StateFlag == state);
//根据用户名来搜索
if (!string.IsNullOrEmpty(userInfoSearch.UserName))
{
temp = temp.Where(o => o.UserName.Contains(userInfoSearch.UserName));
}
else if (!string.IsNullOrEmpty(userInfoSearch.Remark))
{
temp = temp.Where(o => o.Remark.Contains(userInfoSearch.Remark));
}
return(temp.OrderBy(o => o.Id).Skip((userInfoSearch.PageIndex - 1) * userInfoSearch.PageSize).Take(userInfoSearch.PageSize));
}
//获取用户信息
public ActionResult GetUserInfoList()
{
int pageIndex = int.Parse(Request["page"]);
int pageSize = int.Parse(Request["rows"]);
int totalCount = 0;
string name = Request["name"];
string remark = Request["remark"];
UserInfoSearch userInfoSearch = new UserInfoSearch()
{
PageIndex = pageIndex, PageSize = pageSize, Name = name, Remark = remark, TotalCount = totalCount
};
var userInfoList = userInfoService.LoadSearchPageEntities(userInfoSearch);
var temp = from a in userInfoList select new { ID = a.ID, UName = a.Name, UPwd = a.Pwd, Remark = a.Remark, SubTime = a.SubTime };
return(Json(new { rows = temp, total = userInfoSearch.TotalCount }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 完成用户信息的搜索
/// </summary>
/// <param name="userInfoSearch"></param>
/// <param name="delFlag"></param>
/// <returns></returns>
public IQueryable <UserInfo> LoadSearchEntities(UserInfoSearch userInfoSearch, short delFlag)
{
var temp = this.CurrentDBSession.UserInfoDal.LoadEntities(c => c.DelFlag == delFlag);
//根据用户名来搜索
if (!string.IsNullOrEmpty(userInfoSearch.UserName))
{
temp = temp.Where <UserInfo>(u => u.UName.Contains(userInfoSearch.UserName));
}
if (!string.IsNullOrEmpty(userInfoSearch.UserRemark))
{
temp = temp.Where <UserInfo>(u => u.Remark.Contains(userInfoSearch.UserRemark));
}
userInfoSearch.TotalCount = temp.Count();
return(temp.OrderBy <UserInfo, int>(u => u.ID).Skip <UserInfo>((userInfoSearch.PageIndex - 1) * userInfoSearch.PageSize).Take <UserInfo>(userInfoSearch.PageSize));
}
public ActionResult GetUserInfoList(int page, int rows, string UName, string Remark)
{
//int totalCount = 0;
UserInfoSearch userInfoSearch = new UserInfoSearch()
{
PageIndex = page,
PageSize = rows,
UName = UName,
Remark = Remark,
//TotalCount = totalCount
};
var userInfoList = userInfoService.LoadSerachEntities(userInfoSearch, delFlag).Select(u => new { ID = u.ID, UName = u.UName, UPwd = u.UPwd, SubTime = u.SubTime, Remark = u.Remark });
//var userInfoList = userInfoService.LoadPageEntities(page, rows, out totalCount, u => u.DelFlag == delFlag, u => u.ID).Select(u => new { ID = u.ID, UName = u.UName, UPwd = u.UPwd, SubTime = u.SubTime, Remark = u.Remark });
string data = WebCommon.GetJsonList(userInfoSearch.TotalCount, userInfoList);
return(Content(data));
}
/// <summary>
/// 搜索数据
/// </summary>
/// <param name="userInfoSearch">封装的搜索条件数据</param>
/// <param name="delFlag">删除标记</param>
/// <returns></returns>
public IQueryable <UserInfo> LoadSearchEntities(UserInfoSearch userInfoSearch, DeleteEnumType delFlag)
{
//拿到所有标记为delFlag的数据（z-index:1）
var temp = this.LoadEntities(u => u.DelFlag == (short)delFlag);
//拿到所有名称为UserName的数据（z:2）
if (!string.IsNullOrEmpty(userInfoSearch.UserName))
{
temp = this.LoadEntities(u => u.UName == userInfoSearch.UserName);
}
//拿到所有备注为UserRemark的数据（z:3）
if (!string.IsNullOrEmpty(userInfoSearch.UserRemark))
{
temp = this.LoadEntities(u => u.Remark == userInfoSearch.UserRemark);
}
userInfoSearch.PageCount = temp.Count();
return(temp.OrderBy(u => u.ID).Skip((userInfoSearch.PageIndex - 1) * userInfoSearch.PageSize).Take(userInfoSearch.PageSize));
}
public IEnumerable <UserInfo> GetPagedList(UserInfoSearch userInfoSearch, out int totalCount)
{
Expression <Func <UserInfo, bool> > search = Predicates.Begin <UserInfo>(true);
if (!string.IsNullOrEmpty(userInfoSearch.Name))
{
search.And(m => m.Name.Contains(userInfoSearch.Name));
}
if (userInfoSearch.CreateTimeStart != null)
{
search.And(m => m.CreateTime > userInfoSearch.CreateTimeStart);
}
if (userInfoSearch.CreateTimeEnd != null)
{
search.And(m => m.CreateTime < userInfoSearch.CreateTimeEnd);
}
return(_UserInfoRepository.GetPagedList(search, m => m.CreateTime, true, 1, 10, out totalCount).ToList());
}
/// <summary>
/// 加载用户数据
/// </summary>
/// <returns></returns>
public ActionResult GetUserInfo()
{
int pageIndex = Request["page"] != null?int.Parse(Request["page"]) : 1; //当前页码。
int pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 5; //每页显示记录数。
UserInfoSearch userInfoSearch = new UserInfoSearch()
{
PageSize = pageSize,
PageIndex = pageIndex,
Remark = Request["remark"],
UserName = Request["name"]
};
IQueryable <UserInfo> list = UserInfoBLL.LoadSearchPage(userInfoSearch);
var temp = from u in list
select new { ID = u.ID, UName = u.UName, UPwd = u.UPwd, Remark = u.Remark };
return(Json(new { rows = temp, total = userInfoSearch.TotalCount }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 加载用户管理页面
/// </summary>
/// <returns></returns>
public ActionResult GetUserInfoList()
{
int pageIndex = Request["page"] != null?int.Parse(Request["page"]) : 1;
int pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 5;
string userName = Request["name"];
string userRemark = Request["remark"];
int totalCount = 0;
var userInfoSearch = new UserInfoSearch()
{
UserName = userName, UserRemark = userRemark, PageIndex = pageIndex, PageSize = pageSize, TotalCount = totalCount
};
var delFlag = (short)DeleteEnumType.Normal;
//var userInfoList = bll.LoadPageEntities(pageIndex, pageSize, out totalCount, c => c.DelFlag == delFlag, c => c.Id,true).ToList();
var userInfoList = UserInfoService.LoadSearchEntities(userInfoSearch, delFlag).ToList();
var temp = userInfoList.Select(x => new { ID = x.Id, UName = x.Name, UPwd = x.Pwd, Remark = x.Remark, SunTime = x.SubTime });
return(Json(new { rows = temp.ToList(), total = userInfoSearch.TotalCount }));
}
public ActionResult GetUserInfoList()
{
//获取页码
int pageIndex = Request["page"] != null?int.Parse(Request["page"]) : 1;
int pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 5;
//接受搜索条件
string userName = Request["name"];
string userRemark = Request["remark"];
int totalCount = 0;
//构建搜索条件
UserInfoSearch userInfoSearch = new UserInfoSearch()
{
UserName = userName,
UserRemark = userRemark,
PageIndex = pageIndex,
PageSize = pageSize,
TotalCount = totalCount
};
short delFlag = (short)DeleteEnumType.Normal;
var userinfoList = UserInfoService.LoadSearchEntities(userInfoSearch, delFlag);
// var UserInfoList = UserInfoService.LoadPageEntities<int>(pageIndex, pageSize, out totalCount, c => c.DelFlag == delFlag, c => c.ID, true);
var temp = from u in userinfoList
select new
{
ID = u.ID,
UName = u.UName,
UPwd = u.UPwd,
Remark = u.Remark,
SubTime = u.SubTime
};
//JSon 固定要求
return(Json(new { rows = temp, total = userInfoSearch.TotalCount }, JsonRequestBehavior.AllowGet));//属性名师固定的
}
public JsonResult ListDlzh(FormCollection form)
{
UserInfoSearch search = new UserInfoSearch();
search.ORG_ID = base.CurrentUserOrgId;
search.USER_NO = form["USER_NO1"].ToString();
search.USER_TYPE = form["USER_TYPES"].ToString();//当前用户的用户类型 STORE_ID
search.STORE_ID = form["STORE_IDS"] == null ? 0 : int.Parse(form["STORE_IDS"].ToString());
search.CUUSER_ID = base.CurrentLoginUserId;
PageView view = new PageView(form);
search.ORG_ID = base.CurrentUserOrgId;
string colkey = form["colkey"];
string colsinfo = form["colsinfo"];
//账户列表
PagedList <USER_INFO_EX> pList = _eservice.QueryUSER_INFO_EXList(search, view);
JsonQTable fdata = JsonQTable.ConvertFromPagedList <USER_INFO_EX>(pList, colkey, colsinfo.Split(','));
return(Json(fdata));
}
/// <summary>
/// 获取用户列表数据
/// </summary>
/// <returns></returns>
public ActionResult GetUserInfoList()
{
string value = Request["page"];
int pageIndex = value != null?int.Parse(value) : 1;
value = Request["rows"];
int pageSize = value != null?int.Parse(value) : 5;
string userName = Request["name"];
string remark = Request["remark"];
int totalCount = 0;
//构建搜索条件.
UserInfoSearch userInfoSearch = new UserInfoSearch()
{
UserName = userName,
Remark = remark,
PageIndex = pageIndex,
PageSize = pageSize,
TotalCount = totalCount
};
byte delFlag = (byte)DeleteTypeEnum.Normarl;
//根据构建好的搜索条件完成搜索
var userInfoList = UserInfoService.LoadSearchEntities(userInfoSearch, delFlag);
////获取分页数据。
//var userInfoList = UserInfoService.LoadPageEntities(pageIndex, pageSize, out totalCount, o => o.State == (int)DeleteEnumType.Normarl, o => o.Sort, true);
var temp = from u in userInfoList
select new
{
u.Id,
u.UserName,
u.UserPassword,
u.Remark,
u.CreateTime,
};
return(Json(new { rows = temp, total = totalCount }));
}
public IActionResult Get([FromServices] IGetAllUsers query, [FromQuery] UserInfoSearch search)
{
return(Ok(_executor.ExecuteQuery(query, search)));
}
public IQueryable <UserInfo> LoadSearchPageEntities(UserInfoSearch us)
{
return(this.DbSession.UserInfoDal.LoadSearchPageEntities(us));
}
