private void btnSubmit_Click(object sender, EventArgs e) { if (UserInputCheck()) { if (!_isModify) { if (OracleHelper.Exists(OracleHelper.conn, string.Format("SELECT COUNT(*) FROM SYS_USERINFO WHERE USERLOGINNAME='{0}'", this.txtLoginName.Text.ToLower().Trim()))) { XtraMessageBox.Show(string.Format("用户账号{0}已存在", this.txtLoginName.Text), "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } string OperatorName = this.txtName.Text.Trim(); string LoginName = this.txtLoginName.Text.Trim(); string strRoleID = string.Empty; foreach (System.Collections.DictionaryEntry de in htRole) { if (de.Value.ToString() == this.cbRole.Text.Trim()) { strRoleID = de.Key.ToString(); //得到key break; //退出foreach遍历 } } string DeptID = string.Empty; foreach (System.Collections.DictionaryEntry de in htDept) { if (de.Value.ToString() == this.cbDept.Text) { DeptID = de.Key.ToString(); //得到key break; //退出foreach遍历 } } string Phone = String.IsNullOrEmpty(this.txtPhone.Text) ? null : this.txtPhone.Text; string Email = String.IsNullOrEmpty(this.txtEmail.Text) ? null : this.txtEmail.Text; int status = this.chkState.Checked ? 0 : 1;//0有效1无效 if (string.IsNullOrEmpty(userId)) { userId = Guid.NewGuid().ToString(); } string Password = EncryptUtil.Md532(LoginName.ToLower().Trim()); //string.Empty;//初始密码跟账号保持一致 //新增 StringBuilder sbInsSQL = new StringBuilder(); sbInsSQL.Append("INSERT INTO SYS_USERINFO (ID,MODIFYTIME,USERDEPTID"); sbInsSQL.Append(",USEREMAIL,USERLOGINNAME,USERNAME,PWD,USERROLEID,USERTEL,STATUS) VALUES ('{0}',sysdate,'{1}','{2}','{3}','{4}','{5}','{6}','{7}',{8}) "); string strInsSQL = string.Format(sbInsSQL.ToString(), userId, DeptID, Email, LoginName.ToLower().Trim(), OperatorName, Password, strRoleID, Phone, status); //修改 StringBuilder sbUpdSQL = new StringBuilder(); sbUpdSQL.AppendFormat("UPDATE SYS_USERINFO SET MODIFYTIME=sysdate"); sbUpdSQL.AppendFormat(",USEREMAIL='{0}',USERLOGINNAME='{1}',USERNAME='******',USERDEPTID='{3}'", Email, LoginName, OperatorName, DeptID); sbUpdSQL.AppendFormat(",USERROLEID='{0}',USERTEL='{1}',STATUS={2} ", strRoleID, Phone, status); sbUpdSQL.AppendFormat("WHERE ID='{0}' ", userId); using (OracleConnection con = new OracleConnection(OracleHelper.conn)) { con.Open(); int count = OracleHelper.ExecuteNonQuery(con, _isModify ? sbUpdSQL.ToString() : strInsSQL, null); if (count > 0) { this.Close(); UserForm uf = new UserForm(); uf.SearchLocal(1); XtraMessageBox.Show("操作成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { XtraMessageBox.Show("操作失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } }