public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { UserRoleVo inVo = (UserRoleVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Delete from m_mes_user_role"); sqlQuery.Append(" Where "); sqlQuery.Append(" user_cd = :usercd "); sqlQuery.Append(" and "); sqlQuery.Append(" role_cd = :rolecd ;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("usercd", inVo.UserCode); sqlParameter.AddParameterString("rolecd", inVo.RoleCode); UserRoleVo outVo = new UserRoleVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
/// <summary> /// Checks user is admin /// </summary> /// <returns></returns> private bool IsAdminUser() { bool isAdmin = false; UserRoleVo userRoleOutVo = new UserRoleVo(); UserRoleVo userRoleInVo = new UserRoleVo { UserCode = UserData.GetUserData().UserCode }; try { userRoleOutVo = (UserRoleVo)base.InvokeCbm(new GetUserRoleMasterMntCbm(), userRoleInVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } List <UserRoleVo> userRoleList = userRoleOutVo.UserRoleListVo.Where(t => t.RoleCode == ADMIN).ToList(); if (userRoleList.Count > 0) { isAdmin = true; } return(isAdmin); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { UserRoleVo inVo = (UserRoleVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Select mur.user_cd,mur.role_cd from m_mes_user_role mur"); sqlQuery.Append(" inner join m_mes_user mu "); sqlQuery.Append(" on mur.user_cd = mu.user_cd "); sqlQuery.Append(" inner join m_mes_role mr "); sqlQuery.Append(" on mur.role_cd = mr.role_cd "); sqlQuery.Append(" where 1 = 1 "); if (inVo.RoleCode != null) { sqlQuery.Append(" and mur.role_cd = :rolecd "); } if (inVo.UserCode != null) { sqlQuery.Append(" and mur.user_cd = :usercd "); } sqlQuery.Append(" order by mu.user_cd"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); if (inVo.RoleCode != null) { sqlParameter.AddParameterString("rolecd", inVo.RoleCode); } if (inVo.UserCode != null) { sqlParameter.AddParameterString("usercd", inVo.UserCode); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); UserRoleVo outVo = new UserRoleVo(); while (dataReader.Read()) { UserRoleVo currOutVo = new UserRoleVo { RoleCode = dataReader["role_cd"].ToString(), UserCode = dataReader["user_cd"].ToString() }; outVo.UserRoleListVo.Add(currOutVo); } dataReader.Close(); return(outVo); }
private void BtnDelUser_Click(object sender, EventArgs e) { UserRoleVo vo = (UserRoleVo)this.gridView2.GetRow(this.gridView2.FocusedRowHandle); if (vo == null) { return; } if (DeleteDao.DeleteByID(vo.Id, typeof(UserRoleVo)) > 0) { XtraMessageBox.Show("删除成功!"); FillUser(); } }
/// <summary> /// Updates user role /// </summary> private void UpdateUserRole() { string userCode; string roleCode; TreeNodeCollection nodes = UserRoleDetails_tv.Nodes; UserRoleVo userRoleCheckVo = new UserRoleVo(); try { userRoleCheckVo = (UserRoleVo)base.InvokeCbm(new GetUserRoleMasterMntCbm(), new UserRoleVo(), false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); Logger.Error(exception.GetMessageData()); return; } foreach (TreeNode tn in nodes) { foreach (TreeNode child in tn.Nodes) { userCode = tn.Tag.ToString(); roleCode = child.Tag.ToString(); var userRoleCount = userRoleCheckVo.UserRoleListVo.Count(t => t.UserCode == userCode && t.RoleCode == roleCode); if (child.Checked) { if (userRoleCount == 0) { AddUserRole(userCode, roleCode); } } else { if (userRoleCount == 1) { DeleteUserRole(userCode, roleCode); } } } } messageData = new MessageData("mmci00002", Properties.Resources.mmci00002, null); Logger.Info(messageData); popUpMessage.Information(messageData, Text); }
private void BtnUpdateUser_Click(object sender, EventArgs e) { UserRoleVo vo = (UserRoleVo)this.gridView2.GetRow(this.gridView2.FocusedRowHandle); if (vo == null) { return; } UserForm form = new UserForm(vo); if (form.ShowDialog() == DialogResult.OK) { FillUser(); } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { UserRoleVo inVo = (UserRoleVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_mes_user_role"); sqlQuery.Append(" ( "); sqlQuery.Append(" user_cd, "); sqlQuery.Append(" role_cd, "); sqlQuery.Append(" registration_user_cd, "); sqlQuery.Append(" registration_date_time, "); sqlQuery.Append(" factory_cd "); sqlQuery.Append(" ) "); sqlQuery.Append("VALUES "); sqlQuery.Append(" ( "); sqlQuery.Append(" :usercd ,"); sqlQuery.Append(" :rolecd ,"); sqlQuery.Append(" :registrationusercode ,"); sqlQuery.Append(" now() ,"); sqlQuery.Append(" :factorycode "); sqlQuery.Append(" ); "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("rolecd", inVo.RoleCode); sqlParameter.AddParameterString("usercd", inVo.UserCode); sqlParameter.AddParameterString("registrationusercode", inVo.RegistrationUserCode); //sqlParameter.AddParameterDateTime("registrationdatetime", inVo.RegistrationDateTime); sqlParameter.AddParameterString("factorycode", inVo.FactoryCode); UserRoleVo outVo = new UserRoleVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
/// <summary> /// Deletes user role /// </summary> /// <param name="userCode"></param> /// <param name="roleCode"></param> private void DeleteUserRole(string userCode, string roleCode) { UserRoleVo userRoleInVo = new UserRoleVo { UserCode = userCode, RoleCode = roleCode }; UserRoleVo userRoleOutVo = new UserRoleVo(); try { userRoleOutVo = (UserRoleVo)base.InvokeCbm(new DeleteUserRoleMasterMntCbm(), userRoleInVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); Logger.Error(exception.GetMessageData()); return; } }
private void BtnAdd_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(this.textUserName.Text) || string.IsNullOrWhiteSpace(this.comMode.Text) || string.IsNullOrWhiteSpace(this.textPassword.Text)) { XtraMessageBox.Show("请填写完整信息!"); } else { //更新 if (userVo != null) { userVo.Name = this.textUserName.Text; userVo.Role = this.comMode.Text; userVo.Psword = this.textPassword.Text; UpdateDao.UpdateByID(userVo); XtraMessageBox.Show("保存成功!"); this.DialogResult = DialogResult.OK; return; } //新增 UserRoleVo vo = new UserRoleVo() { Name = this.textUserName.Text, Role = this.comMode.Text, Psword = this.textPassword.Text, CompanyId = SystemConst.companyId }; if (SelectDao.IsUserExist(vo.Name)) { XtraMessageBox.Show("该用户已经存在!"); return; } if (InsertDao.InsertData(vo, typeof(UserRoleVo)) > 0) { XtraMessageBox.Show("保存成功!"); this.DialogResult = DialogResult.OK; return; } } }
/// <summary> /// Adds new user role /// </summary> /// <param name="userCode"></param> /// <param name="roleCode"></param> private void AddUserRole(string userCode, string roleCode) { UserRoleVo userRoleInVo = new UserRoleVo { UserCode = userCode, RoleCode = roleCode, //RegistrationDateTime = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), RegistrationUserCode = UserData.GetUserData().UserCode, FactoryCode = UserData.GetUserData().FactoryCode }; UserRoleVo userRoleOutVo = new UserRoleVo(); try { userRoleOutVo = (UserRoleVo)base.InvokeCbm(new AddUserRoleMasterMntCbm(), userRoleInVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); Logger.Error(exception.GetMessageData()); return; } }
public UserForm(UserRoleVo userVo = null) { InitializeComponent(); InitEvents(); this.userVo = userVo; }
/// <summary> /// Binds tree view with role /// </summary> /// <param name="userList"></param> private void PopulateTreeView(List <UserVo> userList) { RoleVo roleOutVo = new RoleVo(); AuthorityControlVo authorityOutVo = new AuthorityControlVo(); try { roleOutVo = (RoleVo)base.InvokeCbm(new GetRoleMasterMntCbm(), roleInVo, false); AuthorityControlVo authorityInVo = new AuthorityControlVo(); authorityOutVo = (AuthorityControlVo)base.InvokeCbm(new GetAuthorityControlMasterMntCbm(), authorityInVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); Logger.Error(exception.GetMessageData()); return; } UserRoleDetails_tv.Nodes.Clear(); TreeNode[] headerNode = new TreeNode[userList.Count]; int i = 0; foreach (UserVo user in userList) { TreeNode child = new TreeNode { Text = user.UserCode + ": " + user.UserName, Tag = user.UserCode }; headerNode[i] = child; int childNodes = roleOutVo.RoleListVo.Count; TreeNode[] rootNodes = new TreeNode[childNodes]; int node = 0; //UserRoleVo userRoleInVo = new UserRoleVo(); UserRoleVo userRoleOutVo = new UserRoleVo(); try { userRoleOutVo = (UserRoleVo)base.InvokeCbm(new GetUserRoleMasterMntCbm(), new UserRoleVo(), false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); Logger.Error(exception.GetMessageData()); return; } foreach (RoleVo role in roleOutVo.RoleListVo) { TreeNode rootChild = new TreeNode { Text = role.RoleCode + ": " + role.RoleName, Tag = role.RoleCode }; List <UserRoleVo> userRoleList = userRoleOutVo.UserRoleListVo.Where(t => t.UserCode == child.Tag.ToString()).ToList(); foreach (UserRoleVo userRole in userRoleList) { if (userRole.RoleCode == rootChild.Tag.ToString()) { rootChild.Checked = true; } } rootNodes[node] = rootChild; headerNode[i].Nodes.Add(rootNodes[node]); RoleAuthorityControlVo roleAuthorityOutVo = new RoleAuthorityControlVo(); try { roleAuthorityOutVo = (RoleAuthorityControlVo)base.InvokeCbm(new GetRoleAuthorityControlMasterMntCbm(), new RoleAuthorityControlVo(), false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); Logger.Error(exception.GetMessageData()); return; } List <RoleAuthorityControlVo> roleAuthorityList = roleAuthorityOutVo.RoleAuthorityControlListVo.Where(t => t.RoleCode == rootChild.Tag.ToString()).ToList(); int authorityNodes = roleAuthorityList.Count; TreeNode[] authorityRootNodes = new TreeNode[authorityNodes]; int subnode = 0; foreach (RoleAuthorityControlVo roleAuth in roleAuthorityList) { AuthorityControlVo authVo = authorityOutVo.AuthorityControlListVo.Where(t => t.AuthorityControlCode == roleAuth.AuthorityControlCode).ToList().First(); TreeNode authorityChild = new TreeNode { Text = authVo.AuthorityControlCode + ": " + authVo.AuthorityControlName, Tag = authVo.AuthorityControlCode }; authorityRootNodes[subnode] = authorityChild; rootNodes[node].Nodes.Add(authorityRootNodes[subnode]); subnode += 1; } node += 1; } UserRoleDetails_tv.Nodes.Add(headerNode[i]); i += 1; } }
/// <summary> /// Binds data for excel export /// </summary> /// <returns></returns> private DataTable BindDataForExcel() { AuthorityControlVo authorityOutVo = null; UserVo userOutVo = null; UserRoleVo userRoleOutVo = null; try { authorityOutVo = (AuthorityControlVo)DefaultCbmInvoker.Invoke(new GetAuthorityControlMasterMntCbm(), new AuthorityControlVo()); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } try { userOutVo = (UserVo)DefaultCbmInvoker.Invoke(new GetUserMasterMntCbm(), new UserVo()); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } try { userRoleOutVo = (UserRoleVo)DefaultCbmInvoker.Invoke(new GetUserAuthorityCbm(), new UserRoleVo()); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } DataTable dt = new DataTable(); DataRow dr; dt.Columns.Add("AuthorityName"); dt.Columns.Add("SubAuthorityName"); dt.Columns.Add("FormName"); if (userOutVo != null && userOutVo.UserListVo.Count > 0) { foreach (UserVo user in userOutVo.UserListVo) { dt.Columns.Add(user.UserCode); } //dr = dt.NewRow(); //dr["AuthorityName"] = "Authority Name"; //dr["SubAuthorityName"] = "SubAuthority Name"; //dr["FormName"] = "Form Name"; //foreach (UserVo user in userOutVo.UserListVo) //{ // dr[user.UserCode] = user.UserName; //} //dt.Rows.Add(dr); } if (authorityOutVo != null && authorityOutVo.AuthorityControlListVo.Count > 0) { foreach (AuthorityControlVo authorityVo in authorityOutVo.AuthorityControlListVo) { if (string.IsNullOrWhiteSpace(authorityVo.ParentControlCode)) { dr = dt.NewRow(); dr["AuthorityName"] = authorityVo.AuthorityControlName; dt.Rows.Add(dr); List <AuthorityControlVo> controlList = authorityOutVo.AuthorityControlListVo. Where(t => t.ParentControlCode == authorityVo.AuthorityControlCode).ToList(); if (controlList != null && controlList.Count > 0) { foreach (AuthorityControlVo controlVo in controlList) { dr = dt.NewRow(); dr["SubAuthorityName"] = controlVo.AuthorityControlName; dt.Rows.Add(dr); List <AuthorityControlVo> childControlList = authorityOutVo.AuthorityControlListVo. Where(t => t.ParentControlCode == controlVo.AuthorityControlCode).ToList(); if (childControlList != null && childControlList.Count > 0) { foreach (AuthorityControlVo childControlVo in childControlList) { dr = dt.NewRow(); dr["FormName"] = childControlVo.AuthorityControlName; List <UserRoleVo> userRoleList = userRoleOutVo.UserRoleListVo. Where(t => t.AuthorityControlCode == childControlVo.AuthorityControlCode).ToList(); foreach (UserRoleVo userRole in userRoleList) { dr[userRole.UserCode] = ((char)0x221A).ToString(); } dt.Rows.Add(dr); } } } } } } } return(dt); }