/// <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> /// Cập nhật thông tin User /// </summary> private void UpdateUser() { if (!IsUsernameValid()) { return; } BUser ctl = new BUser(); OUser obj; try { if (!string.IsNullOrEmpty(Username)) { obj = ctl.Get(Username)[0]; } else { obj = new OUser(); } }catch (Exception ex) { obj = new OUser(); } //-- gán thông tin cho đổi tượng người dùng obj.BirthDay = DateTime.ParseExact(txtBirthDay.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); obj.Email = txtEmail.Text.ToString(); obj.FullName = txtFullName.Text.Trim(); obj.Gender = ddlGender.SelectedValue; obj.IDDepartment = int.Parse(ddlDepartment.SelectedValue); obj.IDGroup = int.Parse(ddlGroup.SelectedValue); obj.PhoneNumber = txtPhoneNumber.Text.Trim(); obj.Tel = txtTel.Text.Trim(); obj.Address = txtAddress.Text.Trim(); obj.Position = txtPossition.Text.Trim(); obj.Status = ddlStatus.SelectedValue; //-- Cập nhật User if (obj.UserID > 0) { ctl.Update(obj.UserName, obj.FullName, obj.Email, obj.PhoneNumber, obj.Tel, obj.Gender, obj.BirthDay, obj.Address, obj.Position, "1", obj.IDDepartment); //RegisterClientScriptBlock("notifycation", "<script language='javascript'>alert('Cập nhật thành công.');</script>"); Response.Redirect("Default.aspx"); } //--Thêm mới User else { obj.UserName = txtUsername.Text.Trim(); obj.Password = Common.ECommon.GetMd5String(txtPassword.Text.Trim()); ctl.Add(obj); Response.Redirect("Default.aspx"); } }
/// <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 }); }