/// <summary>
/// 保存
/// </summary>
private void btnSave_Click(object sender, EventArgs e)
{
if (!CheckInput())
{
return;
}
if (_currentUserTable == null)
{
_currentUserTable = new BaseUserTable();
}
_currentUserTable.CODE = (txtCompanyCode.Text + txtCode.Text.Trim());
_currentUserTable.NAME = txtName.Text;
_currentUserTable.PASSWORD = DESEncrypt.Encrypt(txtPassword.Text);
_currentUserTable.PHONE = txtPhone.Text;
_currentUserTable.EMAIL = txtEmail.Text;
_currentUserTable.DEPARTMENT_CODE = txtDepartmentCode.Text;
_currentUserTable.COMPANY_CODE = txtCompanyCode.Text;
_currentUserTable.ROLES_CODE = txtRolesCode.Text;
//_currentUserTable.PHOTO = GetImageToByte(txtPhoto.Text);
_currentUserTable.PHOTO = null;
_currentUserTable.LAST_UPDATE_USER = _userInfo.CODE;
if (txtIntCommunityDate.Checked == true)
{
_currentUserTable.INT_COMMUNITY_DATE = CConvert.ToDateTime(txtIntCommunityDate.Text);
}
else
{
_currentUserTable.INT_COMMUNITY_DATE = null;
}
if (txtOutCommunityDate.Checked == true)
{
_currentUserTable.OUT_COMMUNITY_DATE = CConvert.ToDateTime(txtOutCommunityDate.Text);
}
else
{
_currentUserTable.OUT_COMMUNITY_DATE = null;
}
try
{
if (bUser.Exists(_currentUserTable.CODE, _currentUserTable.COMPANY_CODE))
{
bUser.Update(_currentUserTable);
}
else
{
_currentUserTable.CREATE_USER = _userInfo.CODE;
bUser.Add(_currentUserTable);
}
}
catch (Exception ex)
{
//log.error
MessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
result = DialogResult.OK;
this.Close();
}
/// <summary>
/// 当单击保存时，执行增加或更新
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_Save_Click(object sender, EventArgs e)
{
bool bl = GetControlData();
if (!bl)
{
return;
}
bool bol = buser.Exists(muser);
if (!bl)
{
int i = buser.Add(muser);
if (i > 0)
{
MessageBoxEx.Show("添加成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
FindData("");
btn_Clean_Click(null, null);
}
else
{
MessageBoxEx.Show("添加失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
int j = buser.Update(muser, " where DB_USER='******'");
if (j > 0)
{
MessageBoxEx.Show("修改成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
FindData("");
btn_Clean_Click(null, null);
}
else
{
MessageBoxEx.Show("修改失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
public override string[] doUpdateDB()
{
BaseUserTable UserTable = null;
BUser bUser = new BUser();
StringBuilder strError = new StringBuilder();
int successData = 0;
int failureData = 0;
string errorFilePath = "";
string backupFilePath = "";
//数据导入处理
foreach (DataRow dr in _csvDataTable.Rows)
{
StringBuilder str = new StringBuilder();
//编号
if (!string.IsNullOrEmpty(CConvert.ToString(GetValue(dr, "CODE"))))
{
str.Append(CheckString(GetValue(dr, "CODE"), 18, "编号"));
}
else
{
str.Append("编号不能为空!");
}
//名称
str.Append(CheckLenght(GetValue(dr, "NAME"), 100, "名称"));
//密码
if (!string.IsNullOrEmpty(CConvert.ToString(GetValue(dr, "PASSWORD"))))
{
str.Append(CheckString(GetValue(dr, "PASSWORD"), 50, "密码"));
}
//电话
str.Append(CheckLenght(GetValue(dr, "PHONE"), 20, "电话"));
//邮箱
str.Append(CheckLenght(GetValue(dr, "EMIAL"), 50, "邮箱"));
if (!string.IsNullOrEmpty(CConvert.ToString(GetValue(dr, "DEPARTMENT_CODE"))))
{
str.Append(CheckDepartment(CConvert.ToString(GetValue(dr, "DEPARTMENT_CODE")), "部门"));
}
str.Append(CheckCompany(CConvert.ToString(GetValue(dr, "COMPANY_CODE")), "公司"));
if (!string.IsNullOrEmpty(CConvert.ToString(GetValue(dr, "ROLES_CODE"))))
{
str.Append(CheckRoles(CConvert.ToString(GetValue(dr, "ROLES_CODE")), "角色"));
}
//状态
str.Append(CheckInt(GetValue(dr, "STATUS_FLAG", CConstant.NORMAL_STATUS), 9, "状态"));
if (str.ToString().Trim().Length > 0)
{
strError.Append(GetStringBuilder(dr, str.ToString().Trim()));
failureData++;
continue;
}
try
{
UserTable = new BaseUserTable();
UserTable.CODE = CConvert.ToString(GetValue(dr, "COMPANY_CODE")) + CConvert.ToString(GetValue(dr, "CODE"));
UserTable.NAME = CConvert.ToString(GetValue(dr, "NAME"));
UserTable.PASSWORD = CConvert.ToString(GetValue(dr, "PASSWORD"));
UserTable.PHONE = CConvert.ToString(GetValue(dr, "PHONE"));
UserTable.EMAIL = CConvert.ToString(GetValue(dr, "EMAIL"));
UserTable.DEPARTMENT_CODE = CConvert.ToString(GetValue(dr, "DEPARTMENT_CODE"));
UserTable.COMPANY_CODE = CConvert.ToString(GetValue(dr, "COMPANY_CODE"));
UserTable.ROLES_CODE = CConvert.ToString(GetValue(dr, "ROLES_CODE"));
UserTable.CREATE_USER = _userInfo.CODE;
UserTable.LAST_UPDATE_USER = _userInfo.CODE;
UserTable.STATUS_FLAG = CConvert.ToInt32(GetValue(dr, "STATUS_FLAG", CConstant.NORMAL_STATUS));
if (!bUser.Exists(UserTable.CODE, UserTable.COMPANY_CODE))
{
bUser.Add(UserTable);
}
else
{
bUser.Update(UserTable);
}
successData++;
}
catch
{
strError.Append(GetStringBuilder(dr, " 数据导入失败，请与系统管理员联系！").ToString());
failureData++;
}
}
//错误记录处理
if (strError.Length > 0)
{
errorFilePath = WriteFile(strError.ToString());
}
//备份处理
backupFilePath = BackupFile();
return(new string[] { successData.ToString(), failureData.ToString(), errorFilePath, backupFilePath });
}
