GetUserLoginInformationByID(int id) { UserInformationDetails ent = null; StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT * FROM "); strSql.Append(UserInformationDetailsManagementDbConstNames.TABLE_NAME); strSql.Append(" WHERE "); strSql.Append(UserInformationDetailsManagementDbConstNames.ID); strSql.Append(" = "); strSql.Append(id); ManageDataBase database = new ManageDataBase(DATABASE_TYPE.WarningManagementDB); DataTable dt = database.ReturnDS(strSql.ToString()).Tables[0]; if (dt != null) { int n = dt.Rows.Count; for (int i = 0; i < n; i++) { ent = new UserInformationDetails(); ent.Id = (int)dt.Rows[i][0]; ent.Name = dt.Rows[i][1].ToString(); ent.PhoneNumber = dt.Rows[i][2].ToString(); ent.TelePhoneNumber = dt.Rows[i][3].ToString(); ent.Email = dt.Rows[i][4].ToString(); ent.Depratment = dt.Rows[i][5].ToString(); ent.Position = dt.Rows[i][6].ToString(); ent.Remarks = dt.Rows[i][7].ToString(); ent.IsInform = Convert.ToInt16(dt.Rows[i][8]); } } return(ent); }
/// <summary> /// 传入实体,用于实例化时判断为添加、修改。若实体为空,则认为是添加。 /// </summary> /// <param name="ent">用户详细信息实体</param> public UserInformationDetailsInput(UserInformationDetails ent) { InitializeComponent(); //添加部门名称 SetComboxDepartment(); if (ent == null) { //标记字符,用于告知”确定“执行何种操作 _strIsAddOrModify = "add"; //设置窗体格式 LibCommon.FormDefaultPropertiesSetter.SetEnteringFormDefaultProperties(this, LibCommon.LibFormTitles.USER_INFO_DETAILS_ADD); } else { //姓名 _txtName.Text = ent.Name; //手机号码 _txtPhoneNumber.Text = ent.PhoneNumber; //电话 _txtTel.Text = ent.TelePhoneNumber; //邮箱 _txtEmail.Text = ent.Email; //部门 if (_cboDepartment.Items.Count != 0)//解决部门中无值时的报错问题 { _cboDepartment.SelectedIndex = GetDepartmentIndex(ent.Depratment); } //职位 _txtPosition.Text = ent.Position; //备注 _rtxtRemark.Text = ent.Remarks; if (ent.IsInform == 0) { rbtnInformNo.Checked = true; rbtnInformYes.Checked = false; } else { rbtnInformNo.Checked = false; rbtnInformYes.Checked = true; } //标记字符,用于告知”确定“执行何种操作 _strIsAddOrModify = "modify"; //设置窗体格式 LibCommon.FormDefaultPropertiesSetter.SetEnteringFormDefaultProperties(this, LibCommon.LibFormTitles.USER_INFO_DETAILS_MOD); } }
/// <summary> /// 修改 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void tsBtnModify_Click(object sender, EventArgs e) { if (_userSel.Count == 0) { //管理界面没有选择时,返回 return; } //定义用户登录信息实体,接收旧值,添加到窗体中。旧值来源于管理界面的选择值。可以直接取值,也可从数据库取值,暂不考虑效率,以下代码从数据库取值。 UserInformationDetails ent = UserInformationDetailsManagementBLL.GetUserLoginInformationByID(_userSel[0]); //修改 UserInformationDetailsInput uidi = new UserInformationDetailsInput(ent); uidi.ShowDialog(); //刷新显示的用户信息 GetUsersInfoDetails(); }
InsertUserInformationDetailsIntoTable(UserInformationDetails ent) { StringBuilder strSql = new StringBuilder(); strSql.Append("INSERT INTO "); strSql.Append(UserInformationDetailsManagementDbConstNames.TABLE_NAME); strSql.Append(" VALUES("); strSql.Append("'" + ent.Name + "',"); strSql.Append("'" + ent.PhoneNumber + "',"); strSql.Append("'" + ent.TelePhoneNumber + "',"); strSql.Append("'" + ent.Email + "',"); strSql.Append("'" + ent.Depratment + "',"); strSql.Append("'" + ent.Position + "',"); strSql.Append("'" + ent.Remarks + "',"); strSql.Append("'" + ent.IsInform + "')"); ManageDataBase database = new ManageDataBase(DATABASE_TYPE.WarningManagementDB); return(database.OperateDB(strSql.ToString())); }
/// <summary> /// 获取所有登录用户信息 /// </summary> /// <returns>用户登录信息实体数组,无用户信息时返回NULL</returns> public static UserInformationDetails[] GetUserInformationDetails() { UserInformationDetails[] infos = null; StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT * FROM "); strSql.Append(UserInformationDetailsManagementDbConstNames.TABLE_NAME); ManageDataBase database = new ManageDataBase(DATABASE_TYPE.WarningManagementDB); DataTable dt = database.ReturnDS(strSql.ToString()).Tables[0]; if (dt != null) { int n = dt.Rows.Count; if (n > 0) { infos = new UserInformationDetails[n]; } else { return(null); } for (int i = 0; i < n; i++) { UserInformationDetails info = new UserInformationDetails(); info.Id = (int)dt.Rows[i][0]; info.Name = dt.Rows[i][1].ToString(); info.PhoneNumber = dt.Rows[i][2].ToString(); info.TelePhoneNumber = dt.Rows[i][3].ToString(); info.Email = dt.Rows[i][4].ToString(); info.Depratment = dt.Rows[i][5].ToString(); info.Position = dt.Rows[i][6].ToString(); info.Remarks = dt.Rows[i][7].ToString(); info.IsInform = Convert.ToInt16(dt.Rows[i][8]); infos[i] = info; } } return(infos); }
UpdataUserInformationDetails(UserInformationDetails ent, int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("UPDATE "); strSql.Append(UserInformationDetailsManagementDbConstNames.TABLE_NAME); strSql.Append(" SET "); strSql.Append(UserInformationDetailsManagementDbConstNames.USER_NAME + " = "); strSql.Append("'" + ent.Name + "',"); strSql.Append(UserInformationDetailsManagementDbConstNames.USER_PHONENUMBER + " = "); strSql.Append("'" + ent.PhoneNumber + "',"); strSql.Append(UserInformationDetailsManagementDbConstNames.USER_TELEPHONE + " = "); strSql.Append("'" + ent.TelePhoneNumber + "',"); strSql.Append(UserInformationDetailsManagementDbConstNames.USER_EMAIL + " = "); strSql.Append("'" + ent.Email + "',"); strSql.Append(UserInformationDetailsManagementDbConstNames.USER_DEPARTMENT + " = "); strSql.Append("'" + ent.Depratment + "',"); strSql.Append(UserInformationDetailsManagementDbConstNames.USER_POSITION + " = "); strSql.Append("'" + ent.Position + "',"); strSql.Append(UserInformationDetailsManagementDbConstNames.USER_REMARKS + " = "); strSql.Append("'" + ent.Remarks + "',"); strSql.Append(UserInformationDetailsManagementDbConstNames.USER_ISINFORM + " = "); strSql.Append("'" + ent.IsInform + "'"); strSql.Append(" WHERE "); strSql.Append(UserInformationDetailsManagementDbConstNames.ID + "="); strSql.Append(id); ManageDataBase database = new ManageDataBase(DATABASE_TYPE.WarningManagementDB); return(database.OperateDB(strSql.ToString())); }
/// <summary> /// 点击确定按钮出发的事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void buttonOK_Click(object sender, EventArgs e) { //定义接收界面信息的实体 UserInformationDetails ent = new UserInformationDetails(); //姓名 ent.Name = _txtName.Text; //手机号码 ent.PhoneNumber = _txtPhoneNumber.Text; //电话号码 ent.TelePhoneNumber = _txtTel.Text; //邮箱 ent.Email = _txtEmail.Text; ent.IsInform = rbtnInformNo.Checked == true ? 0 : 1; //部门 if (_cboDepartment.SelectedItem != null) { ent.Depratment = _cboDepartment.SelectedItem.ToString(); } //职称 ent.Position = _txtPosition.Text; //备注 ent.Remarks = _rtxtRemark.Text; //姓名不能存在特殊字符,且不能为空 if (LibCommon.Validator.checkSpecialCharacters(ent.Name) || LibCommon.Validator.IsEmptyOrBlank(ent.Name)) { Alert.alert(LibCommon.Const.NAME_IS_WRONG, LibCommon.Const.NOTES, MessageBoxButtons.OK, MessageBoxIcon.Warning); _txtName.Focus(); //解决return后,窗体消失的bug DialogResult = DialogResult.None; return; } //检查手机号码,可以为空但不能格式错误 //if (_txtPhoneNumber.Text != "") //{ // if (!LibCommon.Validator.checkIsPhoneNumber(_txtPhoneNumber.Text)) // { // Alert.alert(LibCommon.Const.PHONE_IS_WRONG, LibCommon.Const.NOTES, MessageBoxButtons.OK, MessageBoxIcon.Warning); // this._txtPhoneNumber.Focus(); // return; // } //} //检查电话号码,可以为空但不能格式错误 //if (_txtTel.Text != "") //{ // if (!LibCommon.Validator.checkIsIsTelePhone(_txtTel.Text)) // { // Alert.alert(LibCommon.Const.TEL_IS_WRONG, LibCommon.Const.NOTES, MessageBoxButtons.OK, MessageBoxIcon.Warning); // this._txtTel.Focus(); // return; // } //} //检查邮箱,可以为空但不能格式错误 if (_txtEmail.Text != "") { if (!LibCommon.Validator.checkIsEmailAddress(_txtEmail.Text)) { Alert.alert(LibCommon.Const.EMAIL_IS_WRONG, LibCommon.Const.NOTES, MessageBoxButtons.OK, MessageBoxIcon.Warning); this._txtEmail.Focus(); return; } } //添加 if (_strIsAddOrModify == "add") { //添加用户详细信息 UserInformationDetailsManagementBLL.InsertUserInformationDetailsIntoTable(ent); } //修改。操作是仍需记录管理界面赋值的Id,(_userSel[0])中存放 else if (_strIsAddOrModify == "modify") { //修改用户详细信息 UserInformationDetailsManagementBLL.UpdataUserInformationDetails(ent, UserInformationDetailsManagement._userSel[0]); } this.Close(); }