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);
}
}
