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