/// <summary> /// 添加角色 /// </summary> /// <param name="entity"></param> public int AddRole(SysRoleEntity entity) { entity.IncludeAll(); int line = this.SysRole.Add(entity); if (line > 0) { CacheHelper.Remove(CacheKey.JOOSHOW_SYSROLE_CACHE); } return line; }
public static SysRole_CE ToCE(SysRoleEntity item) { SysRole_CE target = new SysRole_CE(); target.ID=item.ID; target.RoleNum=item.RoleNum; target.RoleName=item.RoleName; target.IsDelete=item.IsDelete; target.CreateTime=item.CreateTime; target.Remark=item.Remark; return target; }
/// <summary> /// 删除角色 /// </summary> /// <param name="roleNum"></param> /// <returns></returns> public int DeleteRole(string roleNum) { SysRoleEntity roleEntity = new SysRoleEntity(); roleEntity.IsDelete = (int)EIsDelete.Deleted; roleEntity.IncludeIsDelete(true); roleEntity.Where(a => a.RoleNum == roleNum); int line = this.SysRole.Update(roleEntity); if (line > 0) { CacheHelper.Remove(CacheKey.JOOSHOW_SYSROLE_CACHE); } 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="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; }
/// <summary> /// 获得所有角色信息 /// </summary> /// <returns></returns> public List<SysRoleEntity> GetList() { List<SysRoleEntity> list = CacheHelper.Get(CacheKey.JOOSHOW_SYSROLE_CACHE) as List<SysRoleEntity>; if (!list.IsNullOrEmpty()) { return list; } SysRoleEntity sysRole = new SysRoleEntity(); sysRole.IncludeAll(); int isDelete = (int)EIsDelete.NotDelete; sysRole.Where(a => a.IsDelete == isDelete); list = this.SysRole.GetList(sysRole); if (!list.IsNullOrEmpty()) { CacheHelper.Insert(CacheKey.JOOSHOW_SYSROLE_CACHE, list); } return list; }
/// <summary> /// 修改角色信息 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int UpdateRole(SysRoleEntity entity) { entity.IncludeRoleName(true).IncludeIsDelete(true).IncludeRemark(true) .Where(a => a.RoleNum == entity.RoleNum) ; int line = this.SysRole.Update(entity); if (line > 0) { CacheHelper.Remove(CacheKey.JOOSHOW_SYSROLE_CACHE); } return line; }
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()); }