/// <summary> /// 删除 /// </summary> /// <param name="userCode"></param> /// <returns></returns> public int Delete(string userCode) { AdminEntity entity = new AdminEntity(); entity.IsDelete = (int)EIsDelete.Deleted; entity.IncludeIsDelete(true); entity.Where(a => a.UserCode == userCode); int line = this.Admin.Update(entity); return line; }
/// <summary> /// 根据用户编号获得用户信息 /// </summary> /// <param name="userCode"></param> /// <returns></returns> public AdminEntity GetAdmin(string userCode) { AdminEntity entity = new AdminEntity(); entity.Include(a => new { a.ID, a.UserCode, a.UserName, a.PassWord, a.Email, a.Phone, a.Mobile, a.RealName, a.RoleNum, a.DepartNum }); entity.Where(a => a.UserCode == userCode); entity = this.Admin.GetSingle(entity); return entity; }
/// <summary> /// 修改密码 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int UpdatePwd(AdminEntity entity) { entity.Include(a => a.PassWord); entity.Where(a => a.UserCode == entity.UserCode); int line = this.Admin.Update(entity); return line; }
/// <summary> /// 修改 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int Update(AdminEntity entity) { entity.Include(a => new { a.Phone, a.Email, a.Mobile, a.RealName, a.RoleNum, a.DepartNum, a.UserName, a.PassWord, a.UpdateTime }); entity.Where(a => a.UserCode == entity.UserCode); int line = this.Admin.Update(entity); return line; }
/// <summary> /// 修改员工登录次数 /// </summary> /// <param name="userName"></param> /// <param name="passWord"></param> /// <param name="loginCount"></param> /// <returns></returns> public int UpdateLoginCount(string userName, string passWord, int loginCount) { AdminEntity countEntity = new AdminEntity() { UserName = userName, PassWord = passWord }; countEntity.IncludeLoginCount(true); countEntity.LoginCount = loginCount + 1; countEntity.Where<AdminEntity>("UserName", ECondition.Eth).And<AdminEntity>("PassWord", ECondition.Eth); int line = this.Admin.Update(countEntity); return line; }
/// <summary> /// 登录 /// </summary> /// <param name="userName"></param> /// <param name="passWord"></param> /// <returns></returns> public AdminEntity Login(string userName, string passWord) { AdminEntity entity = new AdminEntity(); entity.IncludeAll(); entity.Where(a => a.UserName == userName).And(a => a.PassWord == passWord); SysRoleEntity roleEntity = new SysRoleEntity(); roleEntity.Include("RoleName", "RoleName"); entity.Left<SysRoleEntity>(roleEntity, new Params<string, string>() { Item1 = "RoleNum", Item2 = "RoleNum" }); entity = this.Admin.GetSingle(entity); if (entity != null) { AdminEntity admin = new AdminEntity(); admin.LoginCount = admin.LoginCount + 1; admin.IncludeLoginCount(true); admin.Where(a => a.UserCode == entity.UserCode); this.Admin.Update(admin); } return entity; }
/// <summary> /// 检查用户名是否存在 /// </summary> /// <param name="userName"></param> /// <returns></returns> public bool IsExist(string userName) { AdminEntity entity = new AdminEntity(); entity.Include(a => new { a.ID, a.UserCode, a.UserName, a.PassWord, a.Email, a.Phone, a.Mobile, a.RealName, a.RoleNum, a.DepartNum }); entity.Where(a => a.UserName == userName).And(a => a.IsDelete == (int)EIsDelete.NotDelete); entity = this.Admin.GetSingle(entity); if (entity.IsNotNull()) { return true; } return false; }
/// <summary> /// 查询用户管理员分页 /// </summary> /// <param name="entity"></param> /// <param name="pageInfo"></param> /// <returns></returns> public List<AdminEntity> GetList(AdminEntity entity, ref PageInfo pageInfo) { entity.IncludeAll(); entity.OrderBy(a => a.ID, EOrderBy.DESC); entity.Where(a => a.IsDelete == (int)EIsDelete.NotDelete); SysRoleEntity roleEntity = new SysRoleEntity(); roleEntity.Include("RoleName", "RoleName"); entity.Left<SysRoleEntity>(roleEntity, new Params<string, string>() { Item1 = "RoleNum", Item2 = "RoleNum" }); SysDepartEntity departEntity = new SysDepartEntity(); departEntity.Include("DepartName", "DepartName"); entity.Left<SysDepartEntity>(departEntity, new Params<string, string>() { Item1 = "DepartNum", Item2 = "DepartNum" }); int rowCount = 0; List<AdminEntity> listResult = this.Admin.GetList(entity, pageInfo.PageSize, pageInfo.PageIndex, out rowCount); pageInfo.RowCount = rowCount; return listResult; }
public ActionResult ToExcel() { PageInfo pageInfo = new Git.Framework.DataTypes.PageInfo() { PageIndex = 1, PageSize = Int32.MaxValue }; string userCode = WebUtil.GetFormValue<string>("userCode", string.Empty); string userName = WebUtil.GetFormValue<string>("userName", string.Empty); string roleNum = WebUtil.GetFormValue<string>("roleNum", string.Empty); string departNum = WebUtil.GetFormValue<string>("departNum", string.Empty); AdminProvider provider = new AdminProvider(); AdminEntity entity = new AdminEntity(); if (!userCode.IsEmpty()) { entity.Where("UserCode", ECondition.Like, userCode + "%"); } if (!userName.IsEmpty()) { entity.Where("UserName", ECondition.Like, userName + "%"); } if (!roleNum.IsEmpty()) { entity.And(a => a.RoleNum == roleNum); } if (!departNum.IsEmpty()) { entity.And(a => a.DepartNum == departNum); } List<AdminEntity> listResult = provider.GetList(entity, ref pageInfo); if (!listResult.IsNullOrEmpty()) { DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("用户名")); dt.Columns.Add(new DataColumn("编号")); dt.Columns.Add(new DataColumn("真名")); dt.Columns.Add(new DataColumn("Email")); dt.Columns.Add(new DataColumn("联系方式")); dt.Columns.Add(new DataColumn("登录次数")); dt.Columns.Add(new DataColumn("部门")); dt.Columns.Add(new DataColumn("角色")); foreach (AdminEntity t in listResult) { DataRow row = dt.NewRow(); row[0] = t.UserName; row[1] = t.UserCode; row[2] = t.RealName; row[3] = t.Email; row[4] = t.Mobile; row[5] = t.LoginCount; row[6] = t.DepartName; row[7] = t.RoleName; dt.Rows.Add(row); } string filePath = Server.MapPath("~/UploadFiles/"); if (!System.IO.Directory.Exists(filePath)) { System.IO.Directory.CreateDirectory(filePath); } string filename = string.Format("员工管理{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmss")); NPOIExcel excel = new NPOIExcel("员工管理", "员工", System.IO.Path.Combine(filePath, filename)); excel.ToExcel(dt); this.ReturnJson.AddProperty("Path", ("/UploadFiles/" + filename).Escape()); } else { this.ReturnJson.AddProperty("d", "无数据导出!"); } return Content(this.ReturnJson.ToString()); }
public ActionResult GetAdminList() { int pageIndex = WebUtil.GetFormValue<int>("pageIndex", 1); int pageSize = WebUtil.GetFormValue<int>("pageSize", 15); string userCode = WebUtil.GetFormValue<string>("userCode", string.Empty); string userName = WebUtil.GetFormValue<string>("userName", string.Empty); string roleNum = WebUtil.GetFormValue<string>("roleNum", string.Empty); string departNum = WebUtil.GetFormValue<string>("departNum", string.Empty); string search = WebUtil.GetFormValue<string>("search", string.Empty); PageInfo pageInfo = new PageInfo() { PageIndex = pageIndex, PageSize = pageSize }; AdminProvider provider = new AdminProvider(); AdminEntity entity = new AdminEntity(); if (!search.IsEmpty()) { entity.Where("UserCode", ECondition.Like, "%" + search + "%"); entity.Or("RealName", ECondition.Like, "%" + search + "%"); entity.Or("UserName", ECondition.Like, "%" + search + "%"); } else { if (!userCode.IsEmpty()) { entity.Where("UserCode", ECondition.Like, "%" + userCode + "%"); entity.Or("RealName", ECondition.Like, "%" + userCode + "%"); } if (!userName.IsEmpty()) { entity.Where("UserName", ECondition.Like, "%" + userName + "%"); } if (!roleNum.IsEmpty()) { entity.And(a => a.RoleNum == roleNum); } if (!departNum.IsEmpty()) { entity.And(a => a.DepartNum == departNum); } } List<AdminEntity> listResult = provider.GetList(entity, ref pageInfo); string json = ConvertJson.ListToJson<AdminEntity>(listResult, "List"); this.ReturnJson.AddProperty("Data", new JsonObject(json)); this.ReturnJson.AddProperty("RowCount", pageInfo.RowCount); return Content(this.ReturnJson.ToString()); }