public JsonResult DoUpdateUserGroupInfo() { string message = "操作失败,请与管理员联系"; UserGroupInfoModel groupInfo = new UserGroupInfoModel(); groupInfo.UserGroupId = GetFormData("groupId"); groupInfo.GroupName = GetFormData("groupName"); groupInfo.Description = GetFormData("groupDesc"); List <string> premissionList = (Request.Form["wopBox"] != null) ? Request.Form.GetValues("wopBox").ToList() : null; //List<string> premissionList = Request.Form.GetValues("wopBox").ToList(); if (premissionList == null) { return(FailedJson("请选择相相对应权限")); } if (UserGroupInfoService.Instance.UpdateUserGroupInfo(groupInfo, premissionList, out message)) { return(SuccessedJson(message, "UserMgr_UserGroupMgr", "UserMgr_UserGroupMgr", "forward", "/UserMgr/usergroupmgr?gid" + groupInfo.UserGroupId)); } else { return(FailedJson(message)); } }
/// <summary> /// 删除 /// </summary> /// <param name="pc">pc</param> /// <returns>影响的记录行数</returns> public int DeleteMultiple(ParameterCollection pc) { int ret = 0; UserGroupInfoModel usergroupinfo = new UserGroupInfoModel(); ret = DbUtil.Current.DeleteMultiple(usergroupinfo, pc); return(ret); }
/// <summary> /// 更新 /// </summary> /// <param name="usergroupinfo">实体</param> /// <param name="pc">pc</param> /// <returns>影响的记录行数</returns> public int UpdateMultiple(UserGroupInfoModel usergroupinfo, ParameterCollection pc) { int ret = 0; usergroupinfo.ModifiedBy = SessionUtil.Current.UserId; usergroupinfo.ModifiedOn = DateTime.Now; ret = DbUtil.Current.UpdateMultiple(usergroupinfo, pc); return(ret); }
/// <summary> /// 更新 /// </summary> /// <param name="usergroupinfo">实体</param> /// <returns>影响的记录行数</returns> public int Update(UserGroupInfoModel usergroupinfo) { int ret = 0; usergroupinfo.ModifiedBy = SessionUtil.Current.UserId; usergroupinfo.ModifiedOn = DateTime.Now; ret = DbUtil.Current.Update(usergroupinfo); return(ret); }
/// <summary> /// 删除 /// </summary> /// <param name="usergroupid"></param> /// <returns>影响的记录行数</returns> public int Delete(string usergroupid) { int ret = 0; UserGroupInfoModel usergroupinfo = new UserGroupInfoModel(); usergroupinfo.UserGroupId = usergroupid; ret = DbUtil.Current.Delete(usergroupinfo); return(ret); }
/// <summary> /// 根据条件获取实体集合 /// </summary> /// <param name="pc">pc</param> /// <param name="obc">obc</param> /// <returns>实体</returns> public List <UserGroupInfoModel> RetrieveMultiple(ParameterCollection pc, OrderByCollection obc) { List <UserGroupInfoModel> usergroupinfos = new List <UserGroupInfoModel>(); UserGroupInfoModel usergroupinfo = new UserGroupInfoModel(); DataTable dt = DbUtil.Current.RetrieveMultiple(usergroupinfo, pc, obc); for (int i = 0; i < dt.Rows.Count; i++) { usergroupinfo = new UserGroupInfoModel(); usergroupinfo.ConvertFrom(dt, i); usergroupinfos.Add(usergroupinfo); } return(usergroupinfos); }
/// <summary> /// 根据主键获取实体 /// </summary> /// <param name="usergroupid"></param> /// <returns>实体</returns> public UserGroupInfoModel Retrieve(string usergroupid) { UserGroupInfoModel usergroupinfo = new UserGroupInfoModel(); usergroupinfo.UserGroupId = usergroupid; DataTable dt = DbUtil.Current.Retrieve(usergroupinfo); if (dt.Rows.Count < 1) { return(null); } usergroupinfo.ConvertFrom(dt); return(usergroupinfo); }
public UserGroupPremissionDomainModel GetUserGroupDomainByGroupIdFromDatabase(string userGroupId) { if (userGroupId == null) { return(null); } UserGroupPremissionDomainModel result = null; UserGroupInfoModel groupInfo = Retrieve(userGroupId); if (groupInfo != null) { result = new UserGroupPremissionDomainModel(); result.WorkOrderPremissionList = new Dictionary <string, RelUsergroupPremissionModel>(); result.UserGroupInfo = groupInfo; #region 获取工单权限 string GetWorkOrderPremissionSQL = "SELECT * FROM rel_usergroup_premission WHERE premission_type = 'WORKORDER' AND usergroup_id = $groupId$"; ParameterCollection pc = new ParameterCollection(); pc.Add("groupId", userGroupId); DataTable WOPremissin = ExecuteDataTable(GetWorkOrderPremissionSQL, pc); if (WOPremissin != null && WOPremissin.Rows.Count > 0) { RelUsergroupPremissionModel pre = null; for (int i = 0; i < WOPremissin.Rows.Count; i++) { pre = new RelUsergroupPremissionModel(); ModelConvertFrom(pre, WOPremissin, i); result.WorkOrderPremissionList[pre.WorkorderTypeId] = pre; } } #endregion } return(result); }
public bool UpdateUserGroupInfo(UserGroupInfoModel groupInfo, List <string> premissionList, out string message) { bool result = false; message = "操作失败,请与管理员联系"; if (groupInfo == null) { message = "参数错误,请与管理员联系"; return(false); } Dictionary <string, UserGroupInfoModel> groupList = GetUserGroupList(false); if (groupList.ContainsKey(groupInfo.UserGroupId) == false) { message = "操作失败,不存在的用户组ID"; return(false); } try { BeginTransaction(); if (Update(groupInfo) == 1) { string[] preArr = null; #region 生成工单权限实体列表 Dictionary <string, WorkorderTypeInfoModel> WorkOrderTypeList = WorkorderTypeInfoService.Instance.GetWorkOrderDictionary(false); Dictionary <string, RelUsergroupPremissionModel> WorkOrderPremissionList = new Dictionary <string, RelUsergroupPremissionModel>(); foreach (WorkorderTypeInfoModel item in WorkOrderTypeList.Values) { RelUsergroupPremissionModel pre = new RelUsergroupPremissionModel(); pre.UsergroupId = groupInfo.UserGroupId; pre.WorkorderTypeId = item.WorkorderTypeId; pre.PremissionType = "WORKORDER"; pre.Status = 0; pre.CanSelect = 1; pre.CanProcess = 1; pre.CanClose = 1; pre.CanDelete = 1; pre.IsManage = 1; WorkOrderPremissionList[pre.WorkorderTypeId] = pre; } #endregion foreach (string premission in premissionList) { preArr = premission.Split('_'); #region 处理工单权限 if (preArr[0].ToUpper() == "WORKORDER") { switch (preArr[2]) { case "SELECT": WorkOrderPremissionList[preArr[1]].CanSelect = 0; break; case "PROCESS": WorkOrderPremissionList[preArr[1]].CanProcess = 0; break; case "CLOSE": WorkOrderPremissionList[preArr[1]].CanClose = 0; break; case "DELETE": WorkOrderPremissionList[preArr[1]].CanDelete = 0; break; case "MANAGE": WorkOrderPremissionList[preArr[1]].IsManage = 0; break; default: break; } } #endregion } #region 更新工单权限至数据库 string DeleteWorkOrderPremissionSQL = "DELETE FROM rel_usergroup_premission WHERE usergroup_id = $usergroup_id$ AND premission_type = $premission_type$"; ParameterCollection pc = new ParameterCollection(); pc.Add("usergroup_id", groupInfo.UserGroupId); pc.Add("premission_type", "WORKORDER"); if (ExecuteNonQuery(DeleteWorkOrderPremissionSQL, pc) >= 0) { foreach (RelUsergroupPremissionModel item in WorkOrderPremissionList.Values) { if (RelUsergroupPremissionService.Instance.Create(item) != 1) { RollbackTransaction(); message = "更新工单权限信息失败"; return(false); } } } #endregion CommitTransaction(); GetUserGroupList(true); GetUserGroupDomainByGroupId(groupInfo.UserGroupId, true); message = "成功更新用户组信息"; result = true; } else { RollbackTransaction(); message = "更新用户组基本信息失败"; result = false; } } catch (Exception ex) { RollbackTransaction(); LogUtil.Error("更新用户组信息异常", ex); throw ex; } return(result); }