/// <summary> /// 增加一条数据 /// </summary> /// <param name="entity">实体类</param> /// <returns></returns> public int Insert(BPMS_DataPermission entity) { int IsOk = DataFactory.DbUtils().Insert(entity); #region 写日操作日志 if (IsOk > 0) { BPMS_SysLogDAL.Instance.AddTaskLog <BPMS_DataPermission>(entity, RequestSession.GetSessionUser().UserId, RequestSession.GetSessionUser().UserName); } #endregion return(IsOk); }
/// <summary> /// 新建的项目数据,默认把数据权限设置了,,这样就别必要要去数据权限管理里面去打钩 /// </summary> /// <param name="RoleId">角色</param> /// <param name="ResourceId">对象</param> /// <param name="key">数据ID</param> /// <param name="UserId">当前用户</param> /// <param name="key"></param> public void AddItemDefault(string RoleId, string ResourceId, string key, string UserId) { Hashtable ht_Where = new Hashtable(); ht_Where["RoleId"] = RoleId; ht_Where["ResourceId"] = ResourceId; BPMS_DataPermission entity = DataFactory.DbUtils().GetModelById <BPMS_DataPermission>(ht_Where); entity.ObjectId = entity.ObjectId + ",'" + key + "'"; int IsOk = DataFactory.DbUtils().Update(entity, "DataPermissionId"); CacheHelper.RemoveAllCache("Data" + UserId); }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="entity">实体类</param> /// <returns></returns> public int Update(BPMS_DataPermission entity) { #region 获取旧值 var oldEntity = this.GetEntity(BPMS_SysLogDAL.Instance.GetKeyFieldValue <BPMS_DataPermission>(entity).ToString()); #endregion int IsOk = DataFactory.DbUtils().Update(entity, "DataPermissionId"); #region 写日操作日志 if (IsOk > 0) { BPMS_SysLogDAL.Instance.UpdateTaskLog <BPMS_DataPermission>(oldEntity, entity, RequestSession.GetSessionUser().UserId, RequestSession.GetSessionUser().UserName); } #endregion return(IsOk); }
/// <summary> /// 得到一个对象实体 /// </summary> /// <param name="KeyValue">主键</param> /// <returns></returns> public BPMS_DataPermission GetEntity(StringBuilder where, SqlParam[] param) { BPMS_DataPermission entity = new BPMS_DataPermission(); StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT * FROM BPMS_DataPermission WHERE 1=1"); strSql.Append(where); DataTable dt = DataFactory.SqlHelper().GetDataTableBySQL(strSql, param); if (dt.Rows.Count > 0) { return(DbReader.ReaderToModel <BPMS_DataPermission>(dt.Rows[0])); } else { return(entity); } }
/// <summary> /// 员工列表 /// </summary> /// <returns></returns> public string GetEmployeeList(string RoleId, string AuthorizationItemValue) { BPMS_DataPermission datapermission = bpms_datapermissionibll.GetEntity(RoleId, AuthorizationItemValue); string[] array = new string[0]; if (!string.IsNullOrEmpty(datapermission.ObjectId)) { array = datapermission.ObjectId.Replace("'", "").Split(','); } StringBuilder strHtml = new StringBuilder(); IList list = bpms_datapermissionibll.GetEmployeeList(); strHtml.Append("<li>"); strHtml.Append("<input style='vertical-align: middle;margin-bottom:2px;' type=\"checkbox\" name=\"checkbox\" /><img src='/Themes/images/16/spellcheck.png' style='vertical-align: middle;' alt=''/>所有员工"); if (list.Count > 0) { strHtml.Append("<ul>"); foreach (BPMS_Employee entity in list) { bool exists = ((IList)array).Contains(entity.EmployeeId); string Genderimg = "user_red.png"; var Gender = entity.Gender; if (Gender == "男") { Genderimg = "user_mature.png"; } strHtml.Append("<li>"); strHtml.Append("<input " + GetChecked(exists) + " style='vertical-align: middle;margin-bottom:2px;' type=\"checkbox\" value=\"" + entity.EmployeeId + "\" name=\"checkbox\" /><img src='/Themes/images/16/" + Genderimg + "' style='vertical-align: middle;' alt=''/>" + entity.Code + " - " + entity.RealName + ""); strHtml.Append("</li>"); } strHtml.Append("</ul>"); } else { strHtml.Append("<li><div><span style='color:red;'>暂无员工</span></div>"); } strHtml.Append("</li>"); return(strHtml.ToString()); }
/// <summary> /// 组织机构 /// </summary> public string GetOrgTree(string RoleId, string AuthorizationItemValue) { BPMS_DataPermission datapermission = bpms_datapermissionibll.GetEntity(RoleId, AuthorizationItemValue); string[] array = new string[0]; if (!string.IsNullOrEmpty(datapermission.ObjectId)) { array = datapermission.ObjectId.Replace("'", "").Split(','); } StringBuilder strHtml = new StringBuilder(); IList list = bpms_datapermissionibll.GetOrganizationList(); List <BPMS_Organization> itemNode = IListHelper.IListToList <BPMS_Organization>(list).FindAll(t => t.ParentId == "0"); foreach (BPMS_Organization entity in itemNode) { strHtml.Append("<li>"); bool exists = ((IList)array).Contains(entity.OrganizationId); strHtml.Append("<input " + GetChecked(exists) + " style='vertical-align: middle;margin-bottom:2px;' type=\"checkbox\" value=\"" + entity.OrganizationId + "\" name=\"checkbox\" /><img src='/Themes/images/16/house.png' style='vertical-align: middle;' alt=''/>" + entity.FullName + ""); //创建子节点 strHtml.Append(GeOrgtTreeNode(entity.OrganizationId, list, array)); strHtml.Append("</li>"); } return(strHtml.ToString()); }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="entity">实体类</param> /// <returns></returns> public bool Update(BPMS_DataPermission entity) { return(dal.Update(entity) >= 0 ? true : false); }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="entity">实体类</param> /// <returns></returns> public bool Insert(BPMS_DataPermission entity) { return(dal.Insert(entity) >= 0 ? true : false); }
public void LoadAction() { Response.Buffer = true; Response.ExpiresAbsolute = System.DateTime.Now.AddSeconds(-1); Response.Expires = 0; Response.CacheControl = "no-cache"; Response.AddHeader("Pragma", "No-Cache"); string active = HttpContext.Current.Request["action"]; //提交类型 string RoleId = HttpContext.Current.Request["RoleId"]; //角色主键 string AuthorizationItemValue = HttpContext.Current.Request["AuthorizationItemValue"]; //授权项目 string itemId = HttpContext.Current.Request["itemId"]; //授权项目对象Id switch (active) { case "LoadOrgTree": //组织机构 Response.Write(GetOrgTree(RoleId, AuthorizationItemValue)); Response.End(); break; case "LoadUserList": //用户列表 Response.Write(GetUserList(RoleId, AuthorizationItemValue)); Response.End(); break; case "LoadEmployeeList": //员工列表 Response.Write(GetEmployeeList(RoleId, AuthorizationItemValue)); Response.End(); break; case "AddDataPermission": //添加数据权限 bool IsOk = false; entity = bpms_datapermissionibll.GetEntity(RoleId, AuthorizationItemValue); if (entity.DataPermissionId == null) { entity.DataPermissionId = CommonHelper.GetGuid; entity.RoleId = RoleId; entity.ResourceId = AuthorizationItemValue; entity.ObjectId = itemId; entity.CreateUserId = RequestSession.GetSessionUser().UserId; entity.CreateUserName = RequestSession.GetSessionUser().UserName; IsOk = bpms_datapermissionibll.Insert(entity); } else { entity.RoleId = RoleId; entity.ResourceId = AuthorizationItemValue; entity.ObjectId = itemId; entity.CreateUserId = RequestSession.GetSessionUser().UserId; entity.CreateUserName = RequestSession.GetSessionUser().UserName; IsOk = bpms_datapermissionibll.Update(entity); } CacheHelper.RemoveAllCache(); Response.Write(IsOk); Response.End(); break; default: break; } }