/// <summary> /// 添加角色 /// </summary> /// <param name="userInfo">用户</param> /// <param name="role">角色</param> /// <returns>主键</returns> public string AddRole(BaseUserInfo userInfo, string role) { // 加强安全验证防止未授权匿名调用 #if (!DEBUG) LogOnService.UserIsLogOn(userInfo); #endif string returnValue = string.Empty; using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType)) { try { dbHelper.Open(UserCenterDbConnection); BaseRoleManager roleManager = new BaseRoleManager(dbHelper, userInfo); string statusCode = string.Empty; BaseRoleEntity roleEntity = new BaseRoleEntity(); roleEntity.RealName = role; roleEntity.Enabled = 1; returnValue = roleManager.Add(roleEntity, out statusCode); } catch (Exception ex) { BaseExceptionManager.LogException(dbHelper, userInfo, ex); throw ex; } finally { dbHelper.Close(); } } return(returnValue); }
public BaseUserInfo ConvertToUserInfo(BaseUserEntity userEntity, BaseUserInfo userInfo) { userInfo.OpenId = userEntity.OpenId; userInfo.Id = userEntity.Id.ToString(); userInfo.Code = userEntity.Code; userInfo.UserName = userEntity.UserName; userInfo.RealName = userEntity.RealName; userInfo.RoleId = userEntity.RoleId; userInfo.CompanyId = userEntity.CompanyId; userInfo.CompanyName = userEntity.CompanyName; userInfo.SubCompanyId = userEntity.SubCompanyId; userInfo.SubCompanyName = userEntity.SubCompanyName; userInfo.DepartmentId = userEntity.DepartmentId; userInfo.DepartmentName = userEntity.DepartmentName; userInfo.WorkgroupId = userEntity.WorkgroupId; userInfo.WorkgroupName = userEntity.WorkgroupName; if (userEntity.SecurityLevel == null) { userEntity.SecurityLevel = 0; } userInfo.SecurityLevel = (int)userEntity.SecurityLevel; if (userEntity.RoleId != null) { // 获取角色名称 BaseRoleManager roleManager = new BaseRoleManager(DbHelper, UserInfo); BaseRoleEntity roleEntity = roleManager.GetEntity(userEntity.RoleId); if (roleEntity.Id > 0) { userInfo.RoleName = roleEntity.RealName; } } return(userInfo); }
/// <summary> /// 构造函数 /// </summary> /// <param name="dataRow">数据表</param> public FrmRoleEdit(DataRow dataRow) : this() { this.drRole = dataRow; roleEntity = new BaseRoleEntity(this.drRole); this.EntityId = roleEntity.Id.ToString(); }
private void btnCopy_Click(object sender, EventArgs e) { PermissionScopes permissionScopes = new PermissionScopes(); // 模块访问权限复制到剪切板 for (int i = 0; i < this.cklstUser.CheckedItems.Count; i++) { BaseUserEntity userEntity = new BaseUserEntity(((System.Data.DataRowView) this.cklstUser.CheckedItems[i]).Row); this.GrantUsers += userEntity.Id.ToString() + ";"; } string[] grantUserIds = this.GrantUsers.Split(';'); permissionScopes.GrantUserIds = grantUserIds; for (int i = 0; i < this.cklstRole.CheckedItems.Count; i++) { BaseRoleEntity roleEntity = new BaseRoleEntity(((System.Data.DataRowView) this.cklstRole.CheckedItems[i]).Row); this.GrantRoles += roleEntity.Id.ToString() + ";"; } string[] grantRoleIds = this.GrantRoles.Split(';'); permissionScopes.GrantRoleIds = grantRoleIds; string[] grantOrganizeIds = this.GetGrantOrganizeIds(); permissionScopes.GrantOrganizeIds = grantOrganizeIds; string[] grantModuleIds = this.GetGrantModuleIds(); permissionScopes.GrantModuleIds = grantModuleIds; string[] grantPermissionIds = this.GetGrantPermissionIds(); permissionScopes.GrantPermissionIds = grantPermissionIds; Clipboard.SetData("permissionScopes", permissionScopes); this.btnPaste.Enabled = true; }
private void btnRole_Click(object sender, EventArgs e) { string txtButton = ((Button)sender).Text; Button btnRole = (Button)sender; string roldId = GetRoleId(btnRole); if (string.IsNullOrEmpty(roldId)) { BaseRoleEntity roleEntity = new BaseRoleEntity(); roleEntity.OrganizeId = this.EntityId; roleEntity.Code = ((Button)sender).Name.Substring(3).Replace("Delete", ""); roleEntity.RealName = this.txtFullName.Text + "_" + txtButton; roleEntity.Description = ((Button)sender).Text; roleEntity.CategoryCode = "Duty"; roleEntity.Enabled = 1; roleEntity.DeletionStateCode = 0; BaseRoleManager roleManager = new BaseRoleManager(this.UserInfo); roldId = roleManager.Add(roleEntity); btnRole.Tag = roldId; } FrmRoleUserAdmin frmRoleUserAdmin = new FrmRoleUserAdmin(roldId); frmRoleUserAdmin.ShowDialog(this); this.GetRoleUser(btnRole); }
/// <summary> /// 批量保存 /// </summary> private int BatchSave() { this.btnBatchSave.Enabled = false; int returnValue = 0; // 这里需要把没有变动的数据删除掉,这样可以提高效率 // 去掉未修改的数据,提高运行速度 for (int i = this.DTRole.Rows.Count - 1; i >= 0; i--) { if (this.DTRole.Rows[i].RowState == DataRowState.Unchanged) { this.DTRole.Rows.RemoveAt(i); } } // 泛型化 List <BaseRoleEntity> roleEntites = new List <BaseRoleEntity>(); for (int i = 0; i < this.DTRole.Rows.Count; i++) { BaseRoleEntity roleEntity = new BaseRoleEntity(this.DTRole.Rows[i]); roleEntites.Add(roleEntity); } // 调用后台的批量保存功能 returnValue = DotNetService.Instance.RoleService.BatchSave(this.UserInfo, roleEntites); // 绑定屏幕数据 this.FormOnLoad(false); if (BaseSystemInfo.ShowInformation) { // 批量保存,进行提示 MessageBox.Show(AppMessage.MSG0011, AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information); } return(returnValue); }
private void btnLikeAdd_Click(object sender, EventArgs e) { BaseRoleEntity entity = GetEntity(); entity.Id = null; FrmRoleAdd frmRoleAdd = new FrmRoleAdd(entity); frmRoleAdd.ShowDialog(); }
/// <summary> /// 加载窗体 /// </summary> public override void FormOnLoad() { this.roleEntity = DotNetService.Instance.RoleService.GetEntity(UserInfo, this.EntityId); // 显示内容 this.ShowEntity(); // 焦点定位 this.ActiveControl = this.txtRealName; this.txtRealName.SelectAll(); this.txtRealName.Focus(); }
public bool IsAdministrator(string userId) { // 用户是超级管理员 if (userId.Equals("Administrator")) { return(true); } BaseUserEntity userEntity = this.GetEntity(userId); if (userEntity.Code != null && userEntity.Code.Equals("Administrator")) { return(true); } if (userEntity.UserName != null && userEntity.UserName.Equals("Administrator")) { return(true); } string tableName = BaseUserRoleEntity.TableName; if (!string.IsNullOrEmpty(BaseSystemInfo.SystemCode)) { tableName = BaseSystemInfo.SystemCode + "Role"; } // 用户的默认角色是超级管理员 BaseRoleManager roleManager = new BaseRoleManager(this.DbHelper, this.UserInfo, tableName); // 用户默认角色是否为超级管理员 BaseRoleEntity roleEntity = null; if (userEntity.RoleId != null) { roleEntity = roleManager.GetEntity(userEntity.RoleId); if (roleEntity.Code != null && roleEntity.Code.Equals(DefaultRole.Administrators.ToString())) { return(true); } } // 用户在超级管理员群里 string[] roleIds = this.GetAllRoleIds(userId); for (int i = 0; i < roleIds.Length; i++) { if (roleIds[i].Equals(DefaultRole.Administrators.ToString())) { return(true); } roleEntity = roleManager.GetEntity(roleIds[i]); if (roleEntity.Code != null && roleEntity.Code.Equals(DefaultRole.Administrators.ToString())) { return(true); } } return(false); }
/// <summary> /// 加载窗体 /// </summary> public override void FormOnLoad() { // 绑定下拉筐数据 this.BindItemDetails(); // 获取数据 if (this.roleEntity == null && !string.IsNullOrEmpty(this.EntityId)) { this.roleEntity = DotNetService.Instance.RoleService.GetEntity(this.UserInfo, this.EntityId); } // 显示实体 this.ShowEntity(); }
/// <summary> /// 显示用户信息 /// </summary> private void ShowUserEntity() { BaseUserEntity userEntity = DotNetService.Instance.UserService.GetEntity(this.UserInfo, this.TargetUserId); // 绑定用户信息 this.txtUserName.Text = userEntity.UserName; this.txtFullName.Text = userEntity.RealName; if (userEntity.RoleId != null) { BaseRoleEntity roleEntity = DotNetService.Instance.RoleService.GetEntity(this.UserInfo, userEntity.RoleId.ToString()); this.txtRole.Text = roleEntity.RealName; } }
/// <summary> /// 获得已被选择的权限主键数组 /// <param name="dataRow">数据行</param> /// </summary> private void GetSelectedId(DataRow dataRow) { // 获得当前选中的行 BaseRoleEntity roleEntity = new BaseRoleEntity(); roleEntity.GetFrom(dataRow); // 获得具体选中的内容 if (roleEntity.Id > 0) { this.SelectedId = roleEntity.Id.ToString(); this.SelectedFullName = roleEntity.RealName; } }
/// <summary> /// 新建用户角色 /// </summary> /// <param name="entity"></param> /// <returns></returns> public static bool InsertBaseRole(BaseRoleEntity entity) { return(utity.ExecuteNonQuerySp("usp_InsertBaseRole", new object[] { entity.ID, entity.RoleCode, entity.RoleName, entity.StoreID, entity.IsBackstage, entity.SortCode, entity.Description, entity.RecordStatus }) > 0); }
private void btnCopy_Click(object sender, EventArgs e) { // 读取数据 List <BaseRoleEntity> roleEntites = new List <BaseRoleEntity>(); for (int i = 0; i < this.cklstRole.CheckedItems.Count; i++) { BaseRoleEntity roleEntity = new BaseRoleEntity(((System.Data.DataRowView) this.cklstRole.CheckedItems[i]).Row); roleEntites.Add(roleEntity); } // 复制到剪切板 Clipboard.SetData("roleEntites", roleEntites); this.btnPaste.Enabled = true; }
private void btnCopy_Click(object sender, EventArgs e) { // 读取数据 List <BaseRoleEntity> roleEntites = new List <BaseRoleEntity>(); for (int i = 0; i < this.DTRole.Rows.Count; i++) { BaseRoleEntity roleEntity = new BaseRoleEntity(this.DTRole.Rows[i]); roleEntites.Add(roleEntity); } // 复制到剪切板 Clipboard.SetData("roleEntites", roleEntites); this.btnPaste.Enabled = true; }
/// <summary> /// 读取屏幕数据 /// </summary> /// <returns>岗位实体</returns> private BaseRoleEntity GetEntity() { roleEntity = new BaseRoleEntity(); roleEntity.OrganizeId = this.ucOrganize.SelectedId; roleEntity.Code = this.txtCode.Text; roleEntity.RealName = this.txtRealName.Text; roleEntity.CategoryCode = "Duty"; roleEntity.Description = this.txtDescription.Text; roleEntity.Enabled = this.chkEnabled.Checked ? 1 : 0; roleEntity.AllowDelete = 1; roleEntity.AllowEdit = 1; roleEntity.DeletionStateCode = 0; return(roleEntity); }
/// <summary> /// 读取屏幕数据 /// </summary> /// <returns>角色实体</returns> private BaseRoleEntity GetEntity() { roleEntity = new BaseRoleEntity(); roleEntity.RealName = this.txtRealName.Text; roleEntity.Code = this.txtCode.Text; roleEntity.Description = this.txtDescription.Text; roleEntity.Enabled = this.chkEnabled.Checked ? 1 : 0; roleEntity.CategoryCode = this.cmbRoleCategory.SelectedValue.ToString(); roleEntity.AllowDelete = 1; roleEntity.AllowEdit = 1; roleEntity.DeletionStateCode = 0; roleEntity.IsVisible = 1; return(roleEntity); }
/// <summary> /// 添加角色 /// </summary> /// <param name="userInfo">用户</param> /// <param name="roleEntity">实体</param> /// <param name="statusCode">返回状态码</param> /// <param name="statusMessage">返回状态信息</param> /// <returns>主键</returns> public string Add(BaseUserInfo userInfo, BaseRoleEntity roleEntity, out string statusCode, out string statusMessage) { // 写入调试信息 #if (DEBUG) int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod()); #endif // 加强安全验证防止未授权匿名调用 #if (!DEBUG) LogOnService.UserIsLogOn(userInfo); #endif string returnValue = string.Empty; using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType)) { try { dbHelper.Open(UserCenterDbConnection); dbHelper.BeginTransaction(); string tableName = BaseRoleEntity.TableName; if (!string.IsNullOrEmpty(BaseSystemInfo.SystemCode)) { tableName = BaseSystemInfo.SystemCode + "Role"; } BaseRoleManager roleManager = new BaseRoleManager(dbHelper, userInfo, tableName); returnValue = roleManager.Add(roleEntity, out statusCode); statusMessage = roleManager.GetStateMessage(statusCode); BaseLogManager.Instance.Add(dbHelper, userInfo, serviceName, AppMessage.RoleService_Add, MethodBase.GetCurrentMethod()); dbHelper.CommitTransaction(); } catch (Exception ex) { dbHelper.RollbackTransaction(); BaseExceptionManager.LogException(dbHelper, userInfo, ex); throw ex; } finally { dbHelper.Close(); } } // 写入调试信息 #if (DEBUG) BaseBusinessLogic.EndDebug(MethodBase.GetCurrentMethod(), milliStart); #endif return(returnValue); }
/// <summary> /// 设置实体 /// </summary> /// <param name="roleEntity">实体</param> private void SetEntity(SQLBuilder sqlBuilder, BaseRoleEntity roleEntity) { sqlBuilder.SetValue(BaseRoleEntity.FieldSystemId, roleEntity.SystemId); sqlBuilder.SetValue(BaseRoleEntity.FieldOrganizeId, roleEntity.OrganizeId); sqlBuilder.SetValue(BaseRoleEntity.FieldCode, roleEntity.Code); sqlBuilder.SetValue(BaseRoleEntity.FieldRealName, roleEntity.RealName); sqlBuilder.SetValue(BaseRoleEntity.FieldCategoryCode, roleEntity.CategoryCode); sqlBuilder.SetValue(BaseRoleEntity.FieldAllowEdit, roleEntity.AllowEdit); sqlBuilder.SetValue(BaseRoleEntity.FieldAllowDelete, roleEntity.AllowDelete); sqlBuilder.SetValue(BaseRoleEntity.FieldSortCode, roleEntity.SortCode); sqlBuilder.SetValue(BaseRoleEntity.FieldDeletionStateCode, roleEntity.DeletionStateCode); sqlBuilder.SetValue(BaseRoleEntity.FieldEnabled, roleEntity.Enabled); sqlBuilder.SetValue(BaseRoleEntity.FieldDescription, roleEntity.Description); SetEntityExpand(sqlBuilder, roleEntity); }
/// <summary> /// 更新实体 /// </summary> /// <param name="roleEntity">实体</param> public int UpdateEntity(BaseRoleEntity roleEntity) { SQLBuilder sqlBuilder = new SQLBuilder(DbHelper); sqlBuilder.BeginUpdate(this.CurrentTableName); this.SetEntity(sqlBuilder, roleEntity); if (UserInfo != null) { sqlBuilder.SetValue(BaseRoleEntity.FieldModifiedUserId, UserInfo.Id); sqlBuilder.SetValue(BaseRoleEntity.FieldModifiedBy, UserInfo.RealName); } sqlBuilder.SetDBNow(BaseRoleEntity.FieldModifiedOn); sqlBuilder.SetWhere(BaseRoleEntity.FieldId, roleEntity.Id); return(sqlBuilder.EndUpdate()); }
/// <summary> /// 获取实体 /// </summary> /// <param name="userInfo">用户</param> /// <param name="id">主键</param> /// <returns>实体</returns> public BaseRoleEntity GetEntity(BaseUserInfo userInfo, string id) { // 写入调试信息 #if (DEBUG) int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod()); #endif // 加强安全验证防止未授权匿名调用 #if (!DEBUG) LogOnService.UserIsLogOn(userInfo); #endif BaseRoleEntity roleEntity = null; using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType)) { try { dbHelper.Open(UserCenterDbConnection); string tableName = BaseRoleEntity.TableName; if (!string.IsNullOrEmpty(BaseSystemInfo.SystemCode)) { tableName = BaseSystemInfo.SystemCode + "Role"; } BaseRoleManager roleManager = new BaseRoleManager(dbHelper, userInfo, tableName); roleEntity = roleManager.GetEntity(id); BaseLogManager.Instance.Add(dbHelper, userInfo, serviceName, AppMessage.RoleService_GetEntity, MethodBase.GetCurrentMethod()); } catch (Exception ex) { BaseExceptionManager.LogException(dbHelper, userInfo, ex); throw ex; } finally { dbHelper.Close(); } } // 写入调试信息 #if (DEBUG) BaseBusinessLogic.EndDebug(MethodBase.GetCurrentMethod(), milliStart); #endif return(roleEntity); }
/// <summary> /// 加载窗体 /// </summary> public override void FormOnLoad() { // 获取分类列表 this.BindItemDetails(); // 获取数据 if (this.roleEntity == null && !string.IsNullOrEmpty(this.EntityId)) { this.roleEntity = DotNetService.Instance.RoleService.GetEntity(this.UserInfo, this.EntityId); } // 显示实体 this.ShowEntity(); // 表格显示序号的处理部分 this.DataGridViewOnLoad(grdUser); // 获得员工数据 if (this.roleEntity != null) { this.DTUser = DotNetService.Instance.UserService.GetDataTableByRole(UserInfo, this.EntityId); // 绑定屏幕数据 this.BindData(); } }
/// <summary> /// 保存数据 /// </summary> private void Save() { // 设置鼠标繁忙状态,并保留原先的状态 Cursor holdCursor = this.Cursor; this.Cursor = Cursors.WaitCursor; try { this.btnOK.Enabled = false; // 将原来的角色移出,获取当前角色中的用户 string[] roleIds = DotNetService.Instance.UserService.GetUserRoleIds(this.UserInfo, this.TargetUserId); DotNetService.Instance.UserService.RemoveUserFromRole(this.UserInfo, this.TargetUserId, roleIds); // 将新的角色添加到用户 List <BaseRoleEntity> roleEntites = new List <BaseRoleEntity>(); for (int i = 0; i < this.cklstRole.CheckedItems.Count; i++) { BaseRoleEntity roleEntity = new BaseRoleEntity(((System.Data.DataRowView) this.cklstRole.CheckedItems[i]).Row); roleEntites.Add(roleEntity); } string[] addRoleIds = new string[roleEntites.Count]; for (int i = 0; i < roleEntites.Count; i++) { addRoleIds[i] = roleEntites[i].Id.ToString(); } // 添加用户到角色 DotNetService.Instance.UserService.AddUserToRole(this.UserInfo, this.TargetUserId, addRoleIds); this.btnOK.Enabled = true; } catch (Exception ex) { this.ProcessException(ex); } finally { // 设置鼠标默认状态,原来的光标状态 this.Cursor = holdCursor; } }
/// <summary> /// 更新 /// </summary> /// <param name="roleEntity">实体</param> /// <param name="statusCode">返回状态码</param> /// <returns>影响行数</returns> public int Update(BaseRoleEntity roleEntity, out string statusCode) { int returnValue = 0; // 检查是否已被其他人修改 if (DbLogic.IsModifed(DbHelper, this.CurrentTableName, roleEntity.Id, roleEntity.ModifiedUserId, roleEntity.ModifiedOn)) { // 数据已经被修改 statusCode = StatusCode.ErrorChanged.ToString(); } else { // 检查名称是否重复 List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BaseRoleEntity.FieldSystemId, roleEntity.SystemId)); parameters.Add(new KeyValuePair <string, object>(BaseRoleEntity.FieldRealName, roleEntity.RealName)); parameters.Add(new KeyValuePair <string, object>(BaseRoleEntity.FieldDeletionStateCode, 0)); if (this.Exists(parameters, roleEntity.Id)) { // 名称已重复 statusCode = StatusCode.ErrorNameExist.ToString(); } else { returnValue = this.UpdateEntity(roleEntity); if (returnValue == 1) { statusCode = StatusCode.OKUpdate.ToString(); } else { statusCode = StatusCode.ErrorDeleted.ToString(); } } } return(returnValue); }
private void btnCopy_Click(object sender, EventArgs e) { UserPermission userPermission = new UserPermission(); // 读取角色数据 List <BaseRoleEntity> roleEntites = new List <BaseRoleEntity>(); for (int i = 0; i < this.cklstRole.CheckedItems.Count; i++) { BaseRoleEntity roleEntity = new BaseRoleEntity(((System.Data.DataRowView) this.cklstRole.CheckedItems[i]).Row); roleEntites.Add(roleEntity); } // 角色复制到剪切板 userPermission.RoleEntites = roleEntites; // 模块访问权限复制到剪切板 string[] grantModuleIds = this.GetGrantModuleIds(); userPermission.GrantModuleIds = grantModuleIds; // 操作权限复制到剪切板 string[] grantPermissionIds = this.GetGrantPermissionIds(); userPermission.GrantPermissionIds = grantPermissionIds; Clipboard.SetData("userPermission", userPermission); this.btnPaste.Enabled = true; }
/// <summary> /// 添加 /// </summary> /// <param name="roleEntity">实体</param> /// <param name="statusCode">返回状态码</param> /// <returns>主键</returns> public string Add(BaseRoleEntity roleEntity, out string statusCode) { string returnValue = string.Empty; // 检查名称是否重复 List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BaseRoleEntity.FieldSystemId, roleEntity.SystemId)); parameters.Add(new KeyValuePair <string, object>(BaseRoleEntity.FieldRealName, roleEntity.RealName)); parameters.Add(new KeyValuePair <string, object>(BaseRoleEntity.FieldDeletionStateCode, 0)); if (this.Exists(parameters)) { // 名称是否重复 statusCode = StatusCode.ErrorNameExist.ToString(); } else { returnValue = this.AddEntity(roleEntity); // 运行成功 statusCode = StatusCode.OKAdd.ToString(); } return(returnValue); }
/// <summary> /// 检查批量删除 /// </summary> /// <returns>允许删除</returns> public override bool CheckInput() { bool returnValue = true; foreach (DataGridViewRow dgvRow in grdRole.Rows) { DataRow dataRow = (dgvRow.DataBoundItem as DataRowView).Row; if ((System.Boolean)(dgvRow.Cells["colSelected"].Value ?? false)) { BaseRoleEntity roleEntity = new BaseRoleEntity(dataRow); if (roleEntity.AllowDelete == 0) { // 有不允许删除的数据 MessageBox.Show(AppMessage.Format(AppMessage.MSG0018, roleEntity.RealName), AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information); returnValue = false; break; } } } //foreach (DataRowView dataRowView in this.DTRole.DefaultView) //{ // if (dataRowView.Row[BaseBusinessLogic.SelectedColumn].ToString().ToUpper().Equals(true.ToString().ToUpper())) // { // BaseRoleEntity roleEntity = new BaseRoleEntity(dataRowView.Row); // if (roleEntity.AllowDelete == 0) // { // // 有不允许删除的数据 // MessageBox.Show(AppMessage.Format(AppMessage.MSG0018, roleEntity.RealName), AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information); // returnValue = false; // break; // } // } //} return(returnValue); }
/// <summary> /// 从Excel文件导入(角色) /// </summary> /// <param name="filePath"></param> /// <returns></returns> private bool DoImport(string filePath) { bool returnValue = false; // 鼠标忙碌状态 this.Cursor = Cursors.WaitCursor; try { //将Excel表转换为DataTable string error = ""; DataTable dataTable = new DataTable(); AsposeExcelTools.ExcelFileToDataTable(filePath, out dataTable, out error); //检查Excell转为DataTable是否成功 if (error != "") { MessageBox.Show(error, "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } //是否有记录 if (dataTable.Rows.Count > 0) { //将第一行数据给数据列置名称,以便于识别和调用数据。 int columnsCount = 0; for (columnsCount = 0; columnsCount < dataTable.Columns.Count; columnsCount++) { dataTable.Columns[columnsCount].ColumnName = dataTable.Rows[0][columnsCount].ToString().Trim(); } //循环处理每行数据 int rowsCount = 0; int errorCount = 0; BaseRoleEntity tempentity; string statusCode = string.Empty; string statusMessage = string.Empty; DataTable dt = DotNetService.Instance.RoleService.GetDataTable(UserInfo); for (rowsCount = 1; rowsCount < dataTable.Rows.Count; rowsCount++) { //角色名称不允许导入重复项 bool exists = BaseBusinessLogic.Exists(dt, BaseRoleEntity.FieldRealName, dataTable.Rows[rowsCount][BaseRoleEntity.FieldRealName].ToString()); if (!exists) { //清空实体 tempentity = new BaseRoleEntity(); //给实体赋值 tempentity.RealName = dataTable.Rows[rowsCount][BaseRoleEntity.FieldRealName].ToString(); tempentity.Code = dataTable.Rows[rowsCount][BaseRoleEntity.FieldCode].ToString(); tempentity.Description = dataTable.Rows[rowsCount][BaseRoleEntity.FieldDescription].ToString(); tempentity.Enabled = int.Parse(dataTable.Rows[rowsCount][BaseRoleEntity.FieldEnabled].ToString()); tempentity.CategoryCode = dataTable.Rows[rowsCount][BaseRoleEntity.FieldCategoryCode].ToString(); tempentity.AllowDelete = 1; tempentity.AllowEdit = 1; tempentity.DeletionStateCode = 0; tempentity.IsVisible = 1; DotNetService.Instance.RoleService.Add(UserInfo, tempentity, out statusCode, out statusMessage); } else { errorCount++; } } this.Changed = true; returnValue = true; MessageBox.Show("共有" + (dataTable.Rows.Count - 1) + "条记录," + (dataTable.Rows.Count - 1 - errorCount).ToString() + "条记录被成功导入!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { this.ProcessException(ex); } finally { // 设置鼠标默认状态 this.Cursor = Cursors.Default; } return(returnValue); }
/// <summary> /// 设置控件状态 /// </summary> public override void SetControlState() { this.SetSortButton(false); this.btnAdd.Enabled = false; this.btnEdit.Enabled = false; this.btnExport.Enabled = false; this.btnBatchDelete.Enabled = false; this.btnRoleUser.Enabled = false; this.btnBatchSave.Enabled = false; this.btnRoleUserBatchSet.Enabled = false; this.btnSelectAll.Enabled = false; this.btnInvertSelect.Enabled = false; // 检查添加组织机构 this.btnAdd.Enabled = this.permissionAdd; if ((this.DTRole.DefaultView.Count >= 1)) { this.btnEdit.Enabled = this.permissionEdit; this.btnExport.Enabled = this.permissionExport; this.btnBatchDelete.Enabled = this.permissionDelete; this.btnRoleUser.Enabled = this.permissionRoleUser; this.btnBatchSave.Enabled = this.permissionEdit; this.btnRoleUserBatchSet.Enabled = this.permissionEdit; } // 位置顺序改变按钮部分 if (this.DTRole.DefaultView.Count > 1) { this.SetSortButton(this.permissionEdit); } if (!this.permissionEdit) { // 只读属性设置 this.grdRole.Columns["colSelected"].ReadOnly = !this.permissionEdit; this.grdRole.Columns["colEnabled"].ReadOnly = !this.permissionEdit; this.grdRole.Columns["colDescription"].ReadOnly = !this.permissionEdit; // 修改背景颜色 this.grdRole.Columns["colEnabled"].DefaultCellStyle.BackColor = Color.White; this.grdRole.Columns["colDescription"].DefaultCellStyle.BackColor = Color.White; } // 用户组是不需要进行权限配置的 DataRow dataRow = BaseInterfaceLogic.GetDataGridViewEntity(this.grdRole); if (dataRow != null) { BaseRoleEntity roleEntity = new BaseRoleEntity(dataRow); // 超级管理员没必要设置权限,设置了权限反而增加误解了 if (roleEntity.Code != null && roleEntity.Code.Equals(DefaultRole.Administrators.ToString())) { this.btnEdit.Enabled = false; this.btnBatchDelete.Enabled = false; } } // 检查委托是否为空 if (OnButtonStateChange != null) { bool setTop = this.ucTableSort.SetTopEnabled; bool setUp = this.ucTableSort.SetUpEnabled; bool setDown = this.ucTableSort.SetDownEnabled; bool setBottom = this.ucTableSort.SetBottomEnabled; bool add = this.btnAdd.Enabled; bool edit = this.btnEdit.Enabled; bool batchDelete = this.btnBatchDelete.Enabled; bool batchSave = this.btnBatchSave.Enabled; OnButtonStateChange(setTop, setUp, setDown, setBottom, add, edit, batchDelete, batchSave); } if ((this.grdRole.RowCount >= 1)) { this.btnSelectAll.Enabled = this.permissionEdit || this.permissionDelete; this.btnInvertSelect.Enabled = this.permissionEdit || this.permissionDelete; } }
public FrmRoleWithUserEdit(BaseRoleEntity entity) : this() { this.roleEntity = entity; }