private void changeFunc() { this.txtStatus.ForeColor = Color.Blue; this.txtStatus.Text = "修改信息:正在修改..."; Application.DoEvents(); RegexInfo myLoginInfo = new RegexInfo(); if (this.txtChangeTo.Text != "") { if (myLoginInfo.isMailAddress(this.txtChangeTo.Text)) { ManageDB myManageDB = new ManageDB(); myManageDB.UpdateDB("用户管理", "email", this.txtChangeTo); TimeDelay myTimeDelay = new TimeDelay(); this.btnOK.Enabled = false; this.btnCancel.Enabled = false; myTimeDelay.closingCurrentWindowDelay(3, this.txtStatus, this, "修改信息:修改成功!", ""); } else { this.txtStatus.ForeColor = Color.Red; this.txtStatus.Text = "修改信息:修改失败!邮箱地址不合法!"; } } else { this.txtStatus.ForeColor = Color.Red; this.txtStatus.Text = "修改信息:修改失败,所有项不能为空!"; } }
private void changeFunc() { this.txtStatus.ForeColor = Color.Blue; this.txtStatus.Text = "修改信息:正在修改..."; Application.DoEvents(); RegexInfo myLoginInfo = new RegexInfo(); if (this.txtPasswd.Text != "" && this.txtChangeTo.Text != "") { if (this.txtPasswd.Text == this.txtChangeTo.Text) { if (myLoginInfo.isPasswdSecurity(this.txtChangeTo.Text)) { ManageDB myManageDB = new ManageDB(); myManageDB.UpdateDB("用户管理", "[passWord]", this.txtChangeTo); TimeDelay myTimeDelay = new TimeDelay(); this.btnOK.Enabled = false; this.btnCancel.Enabled = false; myTimeDelay.restartDelay(3, this.txtStatus, "修改信息:修改成功!", "请重新登录!"); } else { this.txtStatus.ForeColor = Color.Red; this.txtStatus.Text = "修改信息:修改失败!密码为含数字、字母6位以上字符!"; } } else { this.txtStatus.ForeColor = Color.Red; this.txtStatus.Text = "修改信息:修改失败,密码输入不一致!"; } } else { this.txtStatus.ForeColor = Color.Red; this.txtStatus.Text = "修改信息:修改失败,所有项不能为空!"; } }
private void tsbSave_Click(object sender, EventArgs e) { try { myManageDB.UpdateDB("CaseManager", "ceProject", this.tb_Project.Text, "ceCaseNO", tcNO); myManageDB.UpdateDB("CaseManager", "ceStruct", this.cb_Struct.Text, "ceCaseNO", tcNO); myManageDB.UpdateDB("CaseManager", "ceSuiteNO", this.tb_SuiteNO.Text, "ceCaseNO", tcNO); myManageDB.UpdateDB("CaseManager", "ceSuiteName", this.tb_SuiteName.Text, "ceCaseNO", tcNO); myManageDB.UpdateDB("CaseManager", "ceCaseNO", this.tb_CaseNO.Text, "ceCaseNO", tcNO); myManageDB.UpdateDB("CaseManager", "ceCaseName", this.tb_CaseName.Text, "ceCaseNO", tcNO); myManageDB.UpdateDB("CaseManager", "ceReqNO", this.tb_ReqNO.Text, "ceCaseNO", tcNO); myManageDB.UpdateDB("CaseManager", "ceCaseLevel", this.cb_CaseLevel.Text, "ceCaseNO", tcNO); myManageDB.UpdateDB("CaseManager", "ceFatherModule", this.tb_FatherModule.Text, "ceCaseNO", tcNO); myManageDB.UpdateDB("CaseManager", "ceSubModule", this.tb_SubModule.Text, "ceCaseNO", tcNO); myManageDB.UpdateDB("CaseManager", "ceAuthor", this.tb_Author.Text, "ceCaseNO", tcNO); myManageDB.UpdateDB("CaseManager", "ceEditDate", this.tb_EditDate.Text, "ceCaseNO", tcNO); myManageDB.UpdateDB("CaseManager", "ceModifier", this.tb_Modifier.Text, "ceCaseNO", tcNO); myManageDB.UpdateDB("CaseManager", "ceModifyDate", this.dtpModifyDate.Text, "ceCaseNO", tcNO); myManageDB.UpdateDB("CaseManager", "ceTester", this.cb_Tester.Text, "ceCaseNO", tcNO); myManageDB.UpdateDB("CaseManager", "ceTestDate", this.dtpTestDate.Text, "ceCaseNO", tcNO); myManageDB.UpdateDB("CaseManager", "cePrecondition", this.rtb_Precondition.Text, "ceCaseNO", tcNO); myManageDB.UpdateDB("CaseManager", "ceSteps", this.rtb_Steps.Text, "ceCaseNO", tcNO); myManageDB.UpdateDB("CaseManager", "ceSamples", this.rtb_Samples.Text, "ceCaseNO", tcNO); myManageDB.UpdateDB("CaseManager", "ceExcept", this.rtb_Except.Text, "ceCaseNO", tcNO); myManageDB.UpdateDB("CaseManager", "ceActually", this.cb_Actually.Text, "ceCaseNO", tcNO); myManageDB.UpdateDB("CaseManager", "ceIfAuto", this.cb_IfAuto.Text, "ceCaseNO", tcNO); this.Visible = false; this.Close(); } catch (Exception exception) { MessageBox.Show(exception.Message, "异常消息提示:", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void tsbSave_Click(object sender, EventArgs e) { try { myManageDB.UpdateDB("ProjectManager", "proName", this.tb_ProjectName.Text, "proNO", proNO); myManageDB.UpdateDB("ProjectManager", "proShortName", this.tb_ShortName.Text, "proNO", proNO); myManageDB.UpdateDB("ProjectManager", "proNO", this.tb_ProjectNO.Text, "proNO", proNO); myManageDB.UpdateDB("ProjectManager", "proType", this.cb_Type.Text, "proNO", proNO); myManageDB.UpdateDB("ProjectManager", "proPriority", this.cb_Priority.Text, "proNO", proNO); myManageDB.UpdateDB("ProjectManager", "proDepartment", this.tb_Department.Text, "proNO", proNO); myManageDB.UpdateDB("ProjectManager", "proManager", this.tb_Manager.Text, "proNO", proNO); myManageDB.UpdateDB("ProjectManager", "proAssistant", this.tb_Assistant.Text, "proNO", proNO); myManageDB.UpdateDB("ProjectManager", "proSetUpTime", this.dtp_SetUpTime.Text, "proNO", proNO); myManageDB.UpdateDB("ProjectManager", "proClosedTime", this.dtp_ClosedTime.Text, "proNO", proNO); myManageDB.UpdateDB("ProjectManager", "proCustomer", this.tb_Customer.Text, "proNO", proNO); myManageDB.UpdateDB("ProjectManager", "proDevelopmentSite", this.tb_DevelopmentSite.Text, "proNO", proNO); myManageDB.UpdateDB("ProjectManager", "proAuthor", this.tb_Author.Text, "proNO", proNO); myManageDB.UpdateDB("ProjectManager", "proBuildTime", this.dtp_BuildTime.Text, "proNO", proNO); myManageDB.UpdateDB("ProjectManager", "proModifier", this.tb_Modifier.Text, "proNO", proNO); myManageDB.UpdateDB("ProjectManager", "proModifyTime", this.dtp_ModifyTime.Text, "proNO", proNO); myManageDB.UpdateDB("ProjectManager", "proDescribe", this.rtb_Describe.Text, "proNO", proNO); this.Visible = false; this.Close(); } catch (Exception exception) { MessageBox.Show(exception.Message, "异常消息提示:", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void addDataToDB() { ManageDB myManageDB = new ManageDB(); myManageDB.UpdateDB("insert into 用户管理(userName,[passWord],FullName,email,administrator) values ('" + UserRegister.userName + "','" + UserRegister.passwd + "','" + UserRegister.fullName + "','" + UserRegister.emailAddress + "','False')"); }
private void btnLaunch_Click(object sender, EventArgs e) { if (myManageDB.checkItem("revFullName", "用例评审", ManageDB.userFullName, "revEmail", ManageDB.userEmailAddress)) { MessageBox.Show("您已经发起了评审流程!", "消息提示:", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { myManageDB.InsertInto("insert into 用例评审(revFullName,revEmail) values('" + ManageDB.userFullName + "'," + "'" + ManageDB.userEmailAddress + "')"); string FilesPath = this.tbFilePath.Text; string[] excelFilesPath = FilesPath.Split(';'); foreach (string str in excelFilesPath) { if (str != "") { try { if (!Directory.Exists(testCasesPool())) { Directory.CreateDirectory(testCasesPool()); } File.Copy(str, testCasesPool() + Path.GetFileName(str), true); caseNameToReviewList.Add(Path.GetFileName(str) + "\r\n"); caseNameToReview = caseNameToReviewList.ToArray(); mailBody = Path.GetFileName(str) + "\r\n" + mailBody; } catch (Exception exception) { MessageBox.Show(exception.Message, "异常消息提示:", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } if ((cbIfAuto.Text != null) || (cbIfAuto.Text != "")) { this.cbIfCover.Enabled = true; string mailAddressStr = null; try { mailAddressStr = Regex.Match(cbIfAuto.Text.ToString(), @"(?<=\()[\s\S]*@sit.com.cn(?=\))").Value; } catch (ArgumentException exception) { MessageBox.Show(exception.Message, "异常消息提示:", MessageBoxButtons.OK, MessageBoxIcon.Error); } autoReviewerList.Add(mailAddressStr); autoReviewer = autoReviewerList.ToArray(); } if (autoReviewer != null) { sendMail("测试用例自动化评审流程", autoReviewer); } if (ifCoverReviewer != null) { sendMail("测试用例测试点覆盖评审流程", ifCoverReviewer); } foreach (string autoReviewTo in autoReviewer) { myManageDB.UpdateDB("用户管理", "autoReviewTo", "True", "email", autoReviewTo); } foreach (string coverReviewTo in ifCoverReviewer) { myManageDB.UpdateDB("用户管理", "coverReviewTo", "True", "email", coverReviewTo); } myManageDB.UpdateDB("用户管理", "reviewFrom", "True", "email", ManageDB.userEmailAddress); } }