/// <summary> /// 查询用户管理员分页 /// </summary> /// <param name="entity"></param> /// <param name="pageInfo"></param> /// <returns></returns> public List <AdminEntity> GetList(AdminEntity entity, ref PageInfo pageInfo) { entity.IncludeAll(); entity.Exclude(a => a.PassWord); entity.OrderBy(a => a.ID, EOrderBy.DESC); entity.Where(a => a.IsDelete == (int)EIsDelete.NotDelete); entity.And(a => a.CompanyID == entity.CompanyID); entity.And(item => item.UserCode != "DA_0000"); if (!entity.UserName.IsEmpty()) { entity.And("UserName", ECondition.Like, "%" + entity.UserName + "%"); } if (!entity.UserCode.IsEmpty()) { entity.And("UserCode", ECondition.Like, "%" + entity.UserCode + "%"); } if (!entity.RoleNum.IsEmpty()) { entity.And(a => a.RoleNum == entity.RoleNum); } if (!entity.DepartNum.IsEmpty()) { DepartProvider provider = new DepartProvider(this.CompanyID); List <SysDepartEntity> listDepart = provider.GetChildList(entity.DepartNum); string[] items = null; if (!listDepart.IsNullOrEmpty()) { items = listDepart.Select(item => item.SnNum).ToArray(); entity.And("DepartNum", ECondition.In, items); } } int rowCount = 0; List <AdminEntity> listResult = this.Admin.GetList(entity, pageInfo.PageSize, pageInfo.PageIndex, out rowCount); pageInfo.RowCount = rowCount; if (!listResult.IsNullOrEmpty()) { SysRoleProvider RoleProvider = new SysRoleProvider(this.CompanyID); DepartProvider DepartProvider = new DepartProvider(this.CompanyID); foreach (AdminEntity item in listResult) { if (item.RoleNum.IsNotEmpty()) { SysRoleEntity RoleEntity = RoleProvider.GetRoleEntity(item.RoleNum); item.RoleName = RoleEntity != null ? RoleEntity.RoleName : string.Empty; } if (item.DepartNum.IsNotEmpty()) { SysDepartEntity DepartEntity = DepartProvider.GetSingle(item.DepartNum); item.DepartName = DepartEntity != null ? DepartEntity.DepartName : string.Empty; } } } return(listResult); }
public ActionResult Add([ModelBinder(typeof(JsonBinder<SysRoleEntity>))] SysRoleEntity entity) { SysRoleProvider provider = new SysRoleProvider(); if (entity.RoleNum.IsEmpty()) { entity.RoleNum = SequenceProvider.GetSequence(typeof(SysRoleEntity)); entity.IsDelete = (int)EIsDelete.NotDelete; entity.CreateTime = DateTime.Now; int line = provider.AddRole(entity); if (line > 0) { this.ReturnJson.AddProperty("d", "success"); } } else { entity.IsDelete = (int)EIsDelete.NotDelete; int line = provider.UpdateRole(entity); if (line > 0) { this.ReturnJson.AddProperty("d", "success"); } } return Content(this.ReturnJson.ToString()); }
/// <summary> /// 使用工号扫描 /// </summary> /// <param name="UserCode"></param> /// <returns></returns> public AdminEntity Scan(string UserCode) { AdminEntity entity = new AdminEntity(); entity.IncludeAll(); entity.Exclude(a => a.PassWord); entity.Where(a => a.IsDelete == (int)EIsDelete.NotDelete) .And <AdminEntity>(a => a.CompanyID == CompanyID) .And(item => item.UserCode == UserCode) ; entity = this.Admin.GetSingle(entity); if (entity != null) { SysRoleProvider RoleProvider = new SysRoleProvider(this.CompanyID); DepartProvider DepartProvider = new DepartProvider(this.CompanyID); if (entity.RoleNum.IsNotEmpty()) { SysRoleEntity RoleEntity = RoleProvider.GetRoleEntity(entity.RoleNum); entity.RoleName = RoleEntity != null ? RoleEntity.RoleName : string.Empty; } if (entity.DepartNum.IsNotEmpty()) { SysDepartEntity DepartEntity = DepartProvider.GetSingle(entity.DepartNum); entity.DepartName = DepartEntity != null ? DepartEntity.DepartName : string.Empty; } } return(entity); }
public ActionResult AddRole() { string roleNum = WebUtil.GetQueryStringValue<string>("roleNum"); if (roleNum.IsEmpty()) { ViewBag.SysRole = new SysRoleEntity(); return View(); } else { SysRoleProvider provider = new SysRoleProvider(); SysRoleEntity entity = provider.GetRoleEntity(roleNum); entity = entity == null ? new SysRoleEntity() : entity; ViewBag.SysRole = entity; return View(); } }
public ActionResult BatchDel(string roleNum) { SysRoleProvider provider = new SysRoleProvider(); string[] list = roleNum.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); List<string> ls = new List<string>(); int line = 0; foreach (string t in list) { line += provider.DeleteRole(t); } if (line > 0) { this.ReturnJson.AddProperty("d", "success"); } else { this.ReturnJson.AddProperty("d", ""); } return Content(this.ReturnJson.ToString()); }
/// <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.Exclude(a => a.ParentName); entity.Where(a => a.UserName == userName) .And(a => a.PassWord == passWord) .And <AdminEntity>(a => a.CompanyID == CompanyID) .And(a => a.IsDelete == (int)EIsDelete.NotDelete) ; entity = this.Admin.GetSingle(entity); if (entity != null) { SysRoleProvider RoleProvider = new SysRoleProvider(this.CompanyID); DepartProvider DepartProvider = new DepartProvider(this.CompanyID); if (entity.RoleNum.IsNotEmpty()) { SysRoleEntity RoleEntity = RoleProvider.GetRoleEntity(entity.RoleNum); entity.RoleName = RoleEntity != null ? RoleEntity.RoleName : string.Empty; } if (entity.DepartNum.IsNotEmpty()) { SysDepartEntity DepartEntity = DepartProvider.GetSingle(entity.DepartNum); entity.DepartName = DepartEntity != null ? DepartEntity.DepartName : string.Empty; } Task.Factory.StartNew(() => { AdminEntity admin = new AdminEntity(); admin.LoginCount = entity.LoginCount + 1; admin.IncludeLoginCount(true); admin.Where(a => a.UserNum == entity.UserNum).And(item => item.CompanyID == this.CompanyID); this.Admin.Update(admin); }); } return(entity); }
public ActionResult Delete(string roleNum) { SysRoleProvider provider = new SysRoleProvider(); int line = provider.DeleteRole(roleNum); if (line > 0) { this.ReturnJson.AddProperty("d", "success"); } return Content(this.ReturnJson.ToString()); }
public ActionResult ToExcel() { PageInfo pageInfo = new Git.Framework.DataTypes.PageInfo() { PageIndex = 1, PageSize = Int32.MaxValue }; string roleName = WebUtil.GetFormValue<string>("roleName", string.Empty); SysRoleProvider provider = new SysRoleProvider(); SysRoleEntity entity = new SysRoleEntity(); List<SysRoleEntity> list = provider.GetList(); List<SysRoleEntity> listResult = new List<SysRoleEntity>(); if (!list.IsNullOrEmpty()) { listResult = list.Where(a => a.RoleNum.Contains(roleName) || a.RoleName.Contains(roleName)).OrderByDescending(a => a.ID).ToList(); } 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("创建时间")); dt.Columns.Add(new DataColumn("备注")); int count = 1; foreach (SysRoleEntity t in listResult) { DataRow row = dt.NewRow(); row[0] = count; row[1] = t.RoleNum; row[2] = t.RoleName; row[3] = t.CreateTime; row[4] = t.Remark; count++; 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 RoleList(int pageIndex, int pageSize, string roleName) { SysRoleProvider provider = new SysRoleProvider(); List<SysRoleEntity> list = provider.GetList(); List<SysRoleEntity> listResult = new List<SysRoleEntity>(); List<SysRoleEntity> returnList = new List<SysRoleEntity>(); if (!list.IsNullOrEmpty()) { listResult = list.Where(a => a.RoleNum.Contains(roleName) || a.RoleName.Contains(roleName)).ToList(); returnList = listResult.Skip((pageIndex - 1) * pageSize).Take(pageSize).OrderByDescending(a => a.ID).ToList(); } this.ReturnJson.AddProperty("Data", ConvertJson.ListToJson<SysRoleEntity>(returnList, "List")); this.ReturnJson.AddProperty("RowCount", listResult.Count); return Content(this.ReturnJson.ToString()); }
/// <summary> /// 获得角色的下拉列表 /// </summary> /// <param name="roleNum">角色编号</param> /// <returns></returns> public static string GetRoleList(string roleNum) { SysRoleProvider provider = new SysRoleProvider(); List<SysRoleEntity> list = provider.GetList(); StringBuilder sb = new StringBuilder(); string roleTemplate = "<option value='{0}' {1}>{2}</option>"; sb.AppendFormat(roleTemplate, "", "", "请选择角色"); if (!list.IsNullOrEmpty()) { foreach (SysRoleEntity role in list) { sb.AppendFormat(roleTemplate, role.RoleNum, role.RoleNum == roleNum ? "selected='selected'" : string.Empty, role.RoleName); } } return sb.ToString(); }