private void tsBtnDel_Click(object sender, EventArgs e) { if (MessageBox.Show(@"确认要删除用户信息吗?", "提示:", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { int n = GetTableRecordCount("T_USER_INFO_MANAGEMENT"); for (int i = n - 1; i >= 0; i--) { if (this.fpUserInfo.ActiveSheet.Cells[2 + i, 0].CellType is CheckBoxCellType) { if (this.fpUserInfo.ActiveSheet.Cells[2 + i, 0].Value != null) { if ((bool)this.fpUserInfo.ActiveSheet.Cells[2 + i, 0].Value) { this.fpUserInfo.ActiveSheet.Rows.Remove(2 + i, 1); } } } } foreach (string str in _userSel) { //string sqlDelete = "delete from T_USER_INFO_MANAGEMENT where USER_LOGIN_NAME ='" + str +"'"; //database.OperateDB(sqlDelete); UserInformationManagementBLL.DeleteUserInformationByLoginName(str); } fpUserInfo.ActiveSheet.RowCount = 500; fpUserInfo.Refresh(); } }
private void GetUsertInfo() { //string sql = "select USER_LOGIN_NAME,USER_PASSWORD,USER_UNDER_GROUP,USER_UNDER_DEPT,USER_NAME,USER_EMAIL,USER_TEL,USER_PHONE,USER_REMARKS,USER_PERMISSION from T_USER_INFO_MANAGEMENT"; //DataTable dt = database.ReturnDS(sql).Tables[0]; DataTable dt = UserInformationManagementBLL.sqlGetUserInformation(); if (dt != null) { int n = dt.Rows.Count; int k = dt.Columns.Count; for (int i = 0; i < n; i++) { for (int j = 0; j < k; j++) { this.fpUserInfo.Sheets[0].Cells[i + 2, j + 1].CellType = new FarPoint.Win.Spread.CellType.TextCellType(); this.fpUserInfo.Sheets[0].Cells[i + 2, j + 1].Locked = true; this.fpUserInfo.Sheets[0].Cells[i + 2, j + 1].Text = LibEncryptDecrypt.DWEncryptDecryptClass.DecryptString(dt.Rows[i][j].ToString()); this.fpUserInfo.Sheets[0].Cells[i + 2, j + 1].HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.fpUserInfo.Sheets[0].Cells[i + 2, j + 1].VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; } this.fpUserInfo.Sheets[0].Cells[i + 2, 0].CellType = new FarPoint.Win.Spread.CellType.CheckBoxCellType(); this.fpUserInfo.Sheets[0].Cells[i + 2, 0].HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpUserInfo.Sheets[0].Cells[i + 2, 0].VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; } } }
private int GetTableRecordCount(string tableName) { //int n = 0; //string sqlCount = "select count(*) from "+tableName; //string sqlCount = UserInformationManagementBLL.sqlGetRecordCountFromTable(tableName); //DataTable dt = database.ReturnDS(sqlCount).Tables[0]; //if (dt != null) //{ // string str = dt.Rows[0][0].ToString(); // int j = 0; // if (int.TryParse(str, out j)) // { // n = j; // } //} return(UserInformationManagementBLL.sqlGetRecordCountFromTable(tableName)); }
private void GetGroupName() { //_strGroupName.Clear(); //string sql = "select distinct USER_GROUP_NAME from T_USER_GROUP_INFO_MANAGEMENT"; //if (database.ReturnDS(sql).Tables[0] != null) //{ // int n = database.ReturnDS(sql).Tables[0].Rows.Count; // for (int i = 0; i < n; i++) // { // _strGroupName.Add(database.ReturnDS(sql).Tables[0].Rows[i][0].ToString()); // } //} string[] groupNames = UserInformationManagementBLL.sqlGetUserGroupName(); foreach (string name in groupNames) { _strGroupName.Add(name); } }
private void GetGroupName() { //string sql = "select distinct USER_GROUP_NAME from T_USER_GROUP_INFO_MANAGEMENT"; //if (database.ReturnDS(sql).Tables[0] != null) //{ // int n = database.ReturnDS(sql).Tables[0].Rows.Count; // for (int i = 0; i < n; i++) // { // _cboGroup.Items.Add(database.ReturnDS(sql).Tables[0].Rows[i][0].ToString()); // } // _cboGroup.SelectedIndex = 0; //} string[] groupName = UserInformationManagementBLL.sqlGetUserGroupName(); foreach (string str in groupName) { _cboGroup.Items.Add(str); } if (_cboGroup.Items.Count > 0) { _cboGroup.SelectedIndex = 0; } }
private void GetDepartmentName() { //string sql = "select distinct DEPT_NAME from T_DEPT_INFO_MANAGEMENT"; //if (database.ReturnDS(sql).Tables[0]!=null) //{ // int n = database.ReturnDS(sql).Tables[0].Rows.Count; // for (int i = 0; i < n;i++ ) // { // _cboDepartment.Items.Add(database.ReturnDS(sql).Tables[0].Rows[i][0].ToString()); // } // _cboDepartment.SelectedIndex = 0; //} string[] deptNames = UserInformationManagementBLL.sqlGetDepartmentName(); foreach (string str in deptNames) { _cboDepartment.Items.Add(str); } if (_cboDepartment.Items.Count > 0) { _cboDepartment.SelectedIndex = 0; } }
private void buttonOK_Click(object sender, EventArgs e) { string name = _txtLoginName.Text.ToString().Trim(); //DataTable dt = database.ReturnDS("select * from T_USER_INFO_MANAGEMENT where USER_LOGIN_NAME = '" + name + "'").Tables[0]; if (name == "" || UserInformationManagementBLL.FindTheSameLoginName(name)) { MessageBox.Show(@"登陆名不能为空且不能重复,请重新输入!", "提示:", MessageBoxButtons.OK, MessageBoxIcon.Warning); _txtLoginName.Focus(); return; } //string sql = "insert into T_USER_INFO_MANAGEMENT values ('" + _txtLoginName.Text.ToString().Trim() + "','" // + _txtPassWord.Text.ToString().Trim() + "','" // + _cboGroup.Text.ToString().Trim() + "','" // + _cboDepartment.Text.ToString().Trim() + "','" // + _txtName.Text.ToString().Trim() + "','" // + _txtEmail.Text.ToString().Trim() + "','" // + _txtTel.Text.ToString().Trim() + "','" // + _txtPhoneNumber.Text.ToString().Trim() + "','" // + _rtxtRemark.Text.ToString().Trim() + "','" // + _cboPromission.Text.ToString().Trim() + "')"; //database.OperateDB(sql); UserInformation ent = new UserInformation(); ent.LoginName = _txtLoginName.Text.ToString().Trim(); ent.PassWord = _txtPassWord.Text.ToString().Trim(); ent.Group = _cboGroup.Text.ToString().Trim(); ent.Department = _cboDepartment.Text.ToString().Trim(); ent.Name = _txtName.Text.ToString().Trim(); ent.Email = _txtEmail.Text.ToString().Trim(); ent.Tel = _txtTel.Text.ToString().Trim(); ent.Phone = _txtPhoneNumber.Text.ToString().Trim(); ent.Remark = _rtxtRemark.Text.ToString().Trim(); ent.Permission = _cboPromission.Text.ToString().Trim(); //添加用户信息实体到数据库中 UserInformationManagementBLL.InsertRecordIntoTableUserInformation(ent); //判断是否初次登陆 if (LibCommon.Const.FIRST_TIME_LOGIN) {//记录新注册的用户帐号密码 LibCommon.Const.FIRST_LOGIN_NAME = ent.LoginName; LibCommon.Const.FIRST_LOGIN_PASSWORD = ent.PassWord; if (ent.Permission == "普通用户") { LibCommon.Const.FIRST_LOGIN_PERMISSION = LibCommon.Permission.普通用户.ToString(); } if (ent.Permission == "管理员") { LibCommon.Const.FIRST_LOGIN_PERMISSION = LibCommon.Permission.管理员.ToString(); } this.Close(); return; } if (MessageBox.Show(@"添加新用户成功,是否继续添加?", "提示:", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { _txtLoginName.Text = ""; _txtLoginName.Focus(); _txtPassWord.Text = ""; _txtName.Text = ""; _txtEmail.Text = ""; _txtTel.Text = ""; _txtPhoneNumber.Text = ""; _rtxtRemark.Text = ""; } else { this.Close(); } }
private void _propInfo_PropertyValueChanged(object s, PropertyValueChangedEventArgs e) { int n = this.fpUserInfo.ActiveSheet.ActiveCell.Row.Index; string changeValue = ""; if (e.ChangedItem.Value != null) { string ss = e.ChangedItem.Label.ToString(); int columnIndex = this.fpUserInfo.ActiveSheet.Columns[ss].Index; changeValue = e.ChangedItem.Value.ToString(); this.fpUserInfo.ActiveSheet.Cells[n, columnIndex].Text = changeValue; if (ss == "所属用户组") { this.fpUserInfo.ActiveSheet.Cells[n, columnIndex].Text = _strGroupName[Convert.ToInt32(changeValue)].ToString(); } if (ss == "所属部门") { this.fpUserInfo.ActiveSheet.Cells[n, columnIndex].Text = _strDepartmentName[Convert.ToInt32(changeValue)].ToString(); } string loginname = ""; string password = ""; string group = ""; string department = ""; string name = ""; string tel = ""; string email = ""; string phone = ""; string permission = ""; string remark = ""; if (this.fpUserInfo.ActiveSheet.Cells[n, 1].Value != null) { loginname = this.fpUserInfo.ActiveSheet.Cells[n, 1].Value.ToString(); } if (this.fpUserInfo.ActiveSheet.Cells[n, 2].Value != null) { password = this.fpUserInfo.ActiveSheet.Cells[n, 2].Value.ToString(); } if (this.fpUserInfo.ActiveSheet.Cells[n, 3].Value != null) { group = this.fpUserInfo.ActiveSheet.Cells[n, 3].Value.ToString(); } if (this.fpUserInfo.ActiveSheet.Cells[n, 4].Value != null) { department = this.fpUserInfo.ActiveSheet.Cells[n, 4].Value.ToString(); } if (this.fpUserInfo.ActiveSheet.Cells[n, 5].Value != null) { name = this.fpUserInfo.ActiveSheet.Cells[n, 5].Value.ToString(); } if (this.fpUserInfo.ActiveSheet.Cells[n, 6].Value != null) { email = this.fpUserInfo.ActiveSheet.Cells[n, 6].Value.ToString(); } if (this.fpUserInfo.ActiveSheet.Cells[n, 7].Value != null) { tel = this.fpUserInfo.ActiveSheet.Cells[n, 7].Value.ToString(); } if (this.fpUserInfo.ActiveSheet.Cells[n, 8].Value != null) { phone = this.fpUserInfo.ActiveSheet.Cells[n, 8].Value.ToString(); } if (this.fpUserInfo.ActiveSheet.Cells[n, 9].Value != null) { remark = this.fpUserInfo.ActiveSheet.Cells[n, 9].Value.ToString(); } if (this.fpUserInfo.ActiveSheet.Cells[n, 10].Value != null) { permission = this.fpUserInfo.ActiveSheet.Cells[n, 10].Value.ToString().Trim(); } string oldName = loginname; if (ss == "登陆名") { oldName = e.OldValue.ToString(); } UserInformation userInfo = new UserInformation(); userInfo.LoginName = loginname; userInfo.PassWord = password; userInfo.Group = group; userInfo.Department = department; userInfo.Name = name; userInfo.Email = email; userInfo.Tel = tel; userInfo.Phone = phone; userInfo.Remark = remark; userInfo.Permission = permission; //string sqlUpdate = "update T_USER_INFO_MANAGEMENT set USER_LOGIN_NAME = '" + loginname +"'," // + "USER_PASSWORD = '******'," // + "USER_UNDER_GROUP = '" + group + "'," // + "USER_UNDER_DEPT = '" + department + "'," // + "USER_NAME = '" + name + "'," // + "USER_EMAIL = '" + email + "'," // + "USER_TEL = '" + tel + "'," // + "USER_PHONE = '" + phone + "'," // + "USER_REMARKS = '" + remark + "'," // + "USER_PERMISSION = '" + permission + "'" // + " where USER_LOGIN_NAME = '"+oldName+"'"; //database.OperateDB(sqlUpdate);数据库业务逻辑摘出前 //更新数据库 UserInformationManagementBLL.UpdateUserInfomationDatabase(userInfo, oldName); } }