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())); }
public JsonResult Save(SysRoleEntity newObj) { try { string Condition = " and RoleName='" + newObj.RoleName + "'"; int itemCount = roleLogic.Count(Condition); JsonResult result = new JsonResult(); if (itemCount > 0) { result.Data = new { status = 200, msg = "此名称已经存在" }; return(Json(result)); } newObj.RoleId = this.GetMaxRoleId(); bool isOK = roleLogic.Save(newObj); if (isOK == true) { result.Data = new { status = 100, msg = "" }; return(Json(result)); } else { result.Data = new { status = 200, msg = "保存失败" }; return(Json(result)); } } catch (Exception ex) { JsonResult result = new JsonResult(); result.Data = new { status = 200, msg = ex.Message }; return(Json(result)); } }
public ActionResult AddRole() { string RoleNum = WebUtil.GetQueryStringValue <string>("RoleNum", string.Empty); string CompanyID = this.CompanyID; SysRoleEntity entity = null; if (!RoleNum.IsEmpty()) { ITopClient client = new TopClientDefault(); Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("CompanyID", CompanyID); dic.Add("SnNum", RoleNum); string result = client.Execute(RoleApiName.RoleApiName_Single, dic); if (!result.IsEmpty()) { DataResult <SysRoleEntity> dataResult = JsonConvert.DeserializeObject <DataResult <SysRoleEntity> >(result); entity = dataResult.Result; } } entity = entity.IsNull() ? new SysRoleEntity() : entity; ViewBag.Entity = entity; return(View()); }
/// <summary> /// 编辑角色 /// </summary> /// <returns></returns> public ActionResult Edit() { string RoleName = WebUtil.GetFormValue <string>("RoleName"); string CompanyID = WebUtil.GetFormValue <string>("CompanyID"); string Remark = WebUtil.GetFormValue <string>("Remark"); string RoleNum = WebUtil.GetFormValue <string>("RoleNum"); string SnNum = WebUtil.GetFormValue <string>("SnNum"); SysRoleEntity entity = new SysRoleEntity(); entity.SnNum = SnNum; entity.RoleNum = RoleNum; entity.RoleName = RoleName; entity.CompanyID = CompanyID; entity.RoleNum = RoleNum; entity.IsDelete = (int)EIsDelete.NotDelete; entity.CreateTime = DateTime.Now; entity.Remark = Remark; SysRoleProvider provider = new SysRoleProvider(CompanyID); int line = provider.UpdateRole(entity); DataResult result = new DataResult(); if (line > 0) { result.Code = (int)EResponseCode.Success; result.Message = "角色修改成功"; } else { result.Code = (int)EResponseCode.Exception; result.Message = "角色修改失败"; } return(Content(JsonHelper.SerializeObject(result))); }
/// <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 int UpdateRoleMenu(SysRoleEntity model, List <SysRoleMenuEntity> listModel) { bool resulte = SqlHelper.ExecuteTranSql((con, tran) => { int r = 0; try { StringBuilder strsql = new StringBuilder(); strsql.Append("update sys_role set "); strsql.Append("rolecode=@rolecode,rolename=@rolename,roleseq=@roleseq,remark=@remark,createby=@createby,createdate=@createdate"); strsql.Append(" where id=@id "); r = SqlHelper.ExecuteCon(strsql.ToString(), model, tran, null, CommandType.Text, con); if (listModel != null && listModel.Count > 0) { string sqlrolemenu = "delete from sys_rolemenu where rolecode=@Rolecode"; r = SqlHelper.ExecuteCon(sqlrolemenu.ToString(), new { Rolecode = model.Rolecode }, tran, null, CommandType.Text, con); StringBuilder strsqlfun = new StringBuilder(); strsqlfun.Append("insert into sys_rolemenu(menucode,rolecode,funcode) "); strsqlfun.Append(" values(@menucode,@rolecode,@funcode)"); r = SqlHelper.ExecuteCon(strsqlfun.ToString(), listModel, tran, null, CommandType.Text, con); } } catch (Exception ex) { Log4NetHelper.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType).Debug(ex.Message); r = 0; } return(r); }); return(resulte ? 1 : 0); }
/// <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); }
/// <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 int Insert(SysRoleEntity model) { StringBuilder strsql = new StringBuilder(); strsql.Append("insert into sys_role(rolecode,rolename,roleseq,remark,createby,createdate) "); strsql.Append(" values(@rolecode,@rolename,@roleseq,@remark,@createby,@createdate)"); return(SqlHelper.Execute(strsql.ToString(), model)); }
public string SaveRoleFunRel(HttpContext context) { string status = "{\"status\":0;}"; int roleID = 0; string roleName = context.Request.Form["rname"]; string functionsid = context.Request.Form["functionsid"]; if (!int.TryParse(context.Request.Form["pid"], out roleID) || string.IsNullOrEmpty(functionsid) || string.IsNullOrEmpty(roleName)) { status = "{\"status\":-1}"; //传递参数不完整 } else { BCtrl_SysRole bllRole = new BCtrl_SysRole(); List <SysRoleFunctionRelEntity> roleFunlist = new List <SysRoleFunctionRelEntity>(); SysRoleEntity roleEntity = null; String[] funid = functionsid.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); foreach (String var in funid) { SysRoleFunctionRelEntity fe = new SysRoleFunctionRelEntity(); fe.RFRel_FunctionID = Convert.ToInt32(var); fe.RFRel_RoleID = roleID; roleFunlist.Add(fe); } if (roleID > 0) { //修改 roleEntity = bllRole.QueryEntity(roleID); roleEntity.Role_Name = roleName; if (roleEntity != null) { if (bllRole.Update(roleEntity, roleFunlist)) { status = "{\"status\":1}"; } } } else { //添加 roleEntity = new SysRoleEntity(); roleEntity.Role_Name = roleName; roleEntity.CreateTime = DateTime.Now; if (bllRole.Insert(roleEntity, roleFunlist)) { status = "{\"status\":1}"; } } } return(status); }
public int Update(SysRoleEntity model) { StringBuilder strsql = new StringBuilder(); strsql.Append("update sys_role set "); strsql.Append("rolecode=@rolecode,rolename=@rolename,roleseq=@roleseq,remark=@remark,createby=@createby,createdate=@createdate"); strsql.Append(" where id=@id "); return(SqlHelper.Execute(strsql.ToString(), model)); }
/// <summary> /// 编辑 /// </summary> /// <param name="orgid"></param> /// <returns></returns> public ActionResult Edit(string roleid) { if (!string.IsNullOrEmpty(roleid)) { SysRoleEntity entity = roleLogic.Load(roleid); return(View(entity)); } return(View(new OrganizationEntity())); }
public RoleOutputDto GetForm(string keyword) { SysRoleEntity userEntityList = _sysRoleRepository.Get(keyword); RoleDto RoleDtoList = AutoMapper.Mapper.Map <RoleDto>(userEntityList); RoleOutputDto outputDto = new RoleOutputDto(); outputDto.RoleDtoSingle = RoleDtoList; return(outputDto); }
public ActionResult CreateRole() { SysPower(SysMenuConstant.MENU_ROLE_MANAGE, SysMenuConstant.FUN_ADD, UserInfo.UserCode); var model = new SysRoleEntity(); ViewBag.MenuFunList = JsonConvert.SerializeObject(ISysFunctionService.Query(string.Empty)); return(View("EditRole", model)); }
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())); }
/// <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 SysRoleEntity Load(string code) { try { SysRoleEntity orgInfo = QueryForObject <SysRoleEntity>("SysRoleMap.Load", code); return(orgInfo); } catch (Exception) { throw; } }
public bool Update(SysRoleEntity obj) { try { Update("SysRoleMap.Update", obj); return(true); } catch { return(false); } }
/// <summary> /// 添加角色并和菜单关联 /// </summary> /// <param name="roleEntity"></param> /// <param name="roleFunRelList"></param> /// <returns></returns> public bool Insert(SysRoleEntity roleEntity, List <SysRoleFunctionRelEntity> roleFunRelList) { bool isSuccess = false; SqlTransaction trans = null; try { SqlParameter[] rolePrms = { new SqlParameter("@Role_Name", SqlDbType.NVarChar, 20), new SqlParameter("@CreateTime", SqlDbType.DateTime) }; rolePrms[0].Value = roleEntity.Role_Name; rolePrms[1].Value = roleEntity.CreateTime; string roleSql = " INSERT INTO M_System_Role(Role_Name, CreateTime) VALUES (@Role_Name, @CreateTime);SELECT @@IDENTITY; "; string roleFunRelSql = "INSERT INTO M_System_Role_Fun_Rel(RFRel_FunctionID, RFRel_RoleID) VALUES(@RFRel_FunctionID, @RFRel_RoleID)"; using (SqlConnection conn = new SqlConnection(SQlHelper.MyConnectStr)) { conn.Open(); trans = conn.BeginTransaction(); object result = SQlHelper.ExecuteScalar(trans, CommandType.Text, roleSql, rolePrms); int pkid = Convert.ToInt32(result); foreach (SysRoleFunctionRelEntity entity in roleFunRelList) { SqlParameter[] roleFunRelPrms = { new SqlParameter("@RFRel_FunctionID", entity.RFRel_FunctionID), new SqlParameter("@RFRel_RoleID", pkid) }; SQlHelper.ExecuteNonQuery(trans, CommandType.Text, roleFunRelSql, roleFunRelPrms); } trans.Commit(); isSuccess = true; } } catch (Exception ex) { if (trans != null) { trans.Rollback(); } LogUtil.WriteLog(ex); return(false); } return(isSuccess); }
/// <summary> /// 根据主键编号获得角色信息 /// </summary> /// <param name="id"></param> /// <returns></returns> public SysRoleEntity GetRoleEntity(int id) { List <SysRoleEntity> listSource = GetList(); if (listSource.IsNullOrEmpty()) { return(null); } SysRoleEntity entity = listSource.SingleOrDefault(item => item.ID == id); return(entity); }
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> /// <returns></returns> public ActionResult Single() { string CompanyID = WebUtil.GetFormValue <string>("CompanyID"); string SnNum = WebUtil.GetFormValue <string>("SnNum"); SysRoleProvider provider = new SysRoleProvider(CompanyID); SysRoleEntity entity = provider.GetRoleEntity(SnNum); DataResult <SysRoleEntity> result = new DataResult <SysRoleEntity>() { Code = (int)EResponseCode.Success, Message = "响应成功", Result = entity }; return(Content(JsonHelper.SerializeObject(result))); }
/// <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); }
/// <summary> /// 修改角色信息 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int UpdateRole(SysRoleEntity entity) { string key = string.Format(CacheKey.JOOSHOW_SYSROLE_CACHE, this.CompanyID); entity.IncludeRoleName(true).IncludeRemark(true); entity.Where(a => a.SnNum == entity.SnNum) .And(a => a.CompanyID == entity.CompanyID); int line = this.SysRole.Update(entity); if (line > 0) { CacheHelper.Remove(key); } return(line); }
/// <summary> /// 添加角色 /// </summary> /// <param name="entity"></param> public int AddRole(SysRoleEntity entity) { string key = string.Format(CacheKey.JOOSHOW_SYSROLE_CACHE, this.CompanyID); entity.SnNum = entity.SnNum.IsEmpty() ? ConvertHelper.NewGuid() : entity.SnNum; entity.RoleNum = entity.RoleNum.IsEmpty()? new TNumProvider(this.CompanyID).GetSwiftNum(typeof(SysRoleEntity), 5):entity.RoleNum; entity.IncludeAll(); int line = this.SysRole.Add(entity); if (line > 0) { CacheHelper.Remove(key); } return(line); }
/// <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="SnNum"></param> /// <returns></returns> public int DeleteRole(string SnNum) { string key = string.Format(CacheKey.JOOSHOW_SYSROLE_CACHE, this.CompanyID); SysRoleEntity roleEntity = new SysRoleEntity(); roleEntity.IsDelete = (int)EIsDelete.Deleted; roleEntity.IncludeIsDelete(true); roleEntity.Where(a => a.SnNum == SnNum); int line = this.SysRole.Update(roleEntity); if (line > 0) { CacheHelper.Remove(key); } return(line); }
/// <summary> /// 添加 /// </summary> /// <param name="entity"></param> /// <returns></returns> public bool Insert(SysRoleEntity entity) { try { string sql = " INSERT INTO M_System_Role(Role_Name, CreateTime) VALUES (@Role_Name, @CreateTime)"; using (SqlConnection conn = new SqlConnection(SQlHelper.MyConnectStr)) { conn.Execute(sql, new { Role_Name = entity.Role_Name, CreateTime = entity.CreateTime }); return(true); } } catch (Exception ex) { LogUtil.WriteLog(ex); return(false); } }
public bool Update(SysRoleEntity entity) { try { string sql = " UPDATE M_System_Role SET Role_Name=@Role_Name, CreateTime=@CreateTime WHERE Role_ID=@Role_ID"; using (SqlConnection conn = new SqlConnection(SQlHelper.MyConnectStr)) { conn.Execute(sql, new { Role_Name = entity.Role_Name, CreateTime = entity.CreateTime, Role_ID = entity.Role_ID }); return(true); } } catch (Exception ex) { LogUtil.WriteLog(ex); return(false); } }
/// <summary> /// 删除角色信息 /// </summary> /// <param name="list"></param> /// <param name="CompanyID"></param> /// <returns></returns> public int DeleteRole(IEnumerable <string> list) { string key = string.Format(CacheKey.JOOSHOW_SYSROLE_CACHE, this.CompanyID); SysRoleEntity roleEntity = new SysRoleEntity(); roleEntity.IsDelete = (int)EIsDelete.Deleted; roleEntity.IncludeIsDelete(true); roleEntity.Where("SnNum", ECondition.In, list.ToArray()); roleEntity.And(a => a.CompanyID == CompanyID); int line = this.SysRole.Update(roleEntity); if (line > 0) { CacheHelper.Remove(key); } return(line); }