private void button_OnOK_Click(object sender, EventArgs e) { if (this.myDataTable == null) { this.DialogResult = DialogResult.None; this.label_ErrMessage.Text = "没有添加焊工!"; return; } string str_ErrMessage; Class_Student myClass_Student; foreach (DataRow myDataRow in this.myDataTable.Rows) { myDataRow["WelderRemark"] = ""; myClass_Student = new Class_Student(); myClass_Student.IssueNo = this.str_IssueNo; this.FillWeldingParameterClass(myClass_Student.myClass_WeldingParameter); myClass_Student.IdentificationCard = myDataRow["IdentificationCard"].ToString(); myClass_Student.ExamStatus = "顺利考试"; myClass_Student.SubjectID = this.TextBox_SubjectID.Text; if (Class_Student.ExistSecond(myClass_Student.IssueNo, myClass_Student.IdentificationCard, null, Enum_zwjKindofUpdate.Add)) { myDataRow["WelderRemark"] = "身份证号码不能重复!"; } else { str_ErrMessage = myClass_Student.CheckField(); if (string.IsNullOrEmpty(str_ErrMessage)) { if (!myClass_Student.AddAndModify(Enum_zwjKindofUpdate.Add)) { myDataRow["WelderRemark"] = "添加不成功,可能是考编号重复!"; } else { this.bool_Updated = true; } } else { myDataRow["WelderRemark"] = str_ErrMessage; } } } DataRow[] myDataRowRange = this.myDataTable.Select("WelderRemark = '' or WelderRemark is null"); if (myDataRowRange.Length < this.myDataTable.Rows.Count) { this.label_ErrMessage.Text = "有数据不合法!请查看备注信息"; this.DialogResult = DialogResult.None; } foreach (DataRow myDataRow in myDataRowRange) { myDataRow.Delete(); } this.myDataTable.AcceptChanges(); }
private void button_OnOK_Click(object sender, EventArgs e) { this.CheckData_DataTable(); if (this.myDataTable.Select("Len(ErrMessage)>0").Length > 0) { this.DialogResult = DialogResult.None; this.label_ErrMessage.Text = "有数据不合法,请查看 ErrMessage 字段返回信息! "; return; } else { if (MessageBox.Show("确认导入吗?", "确认窗口", MessageBoxButtons.OKCancel) != DialogResult.OK) { this.DialogResult = DialogResult.None; return; } } Class_Welder myClass_Welder; Class_Student myClass_Student; Class_Issue myClass_Issue = new Class_Issue(this.str_IssueNo); //string str_ErrMessage; bool bool_WelderFilled; foreach (DataRow myDataRow in this.myDataTable.Rows) { //myDataRow["ErrMessage"] = ""; //str_ErrMessage = ""; myClass_Welder = new Class_Welder(); myClass_Welder.IdentificationCard = myDataRow["IdentificationCard"].ToString().Trim(); bool_WelderFilled = myClass_Welder.FillData(); myClass_Welder.WelderName = myDataRow["WelderName"].ToString().Trim(); myClass_Welder.Schooling = myDataRow["Schooling"].ToString().Trim(); myClass_Welder.Sex = myDataRow["Sex"].ToString().Trim(); DateTime.TryParse(myDataRow["WeldingBeginning"].ToString().Trim(), out myClass_Welder.WeldingBeginning); myClass_Welder.myClass_BelongUnit.WorkerID = myDataRow["WelderWorkerID"].ToString().Trim(); myClass_Welder.myClass_BelongUnit.EmployerHPID = myDataRow["WelderEmployerHPID"].ToString(); myClass_Welder.myClass_BelongUnit.DepartmentHPID = myDataRow["WelderDepartmentHPID"].ToString(); myClass_Welder.myClass_BelongUnit.WorkPlaceHPID = myDataRow["WelderWorkPlaceHPID"].ToString(); myClass_Welder.myClass_BelongUnit.LaborServiceTeamHPID = myDataRow["WelderLaborServiceTeamHPID"].ToString(); //str_ErrMessage = myClass_Welder.CheckField(); //if (!string.IsNullOrEmpty(str_ErrMessage)) //{ // myDataRow["ErrMessage"] = str_ErrMessage; // continue; //} if (bool_WelderFilled) { myClass_Welder.AddAndModify(Enum_zwjKindofUpdate.Modify); } else { myClass_Welder.AddAndModify(Enum_zwjKindofUpdate.Add); } myClass_Student = new Class_Student(); myClass_Student.IdentificationCard = myClass_Welder.IdentificationCard; myClass_Student.IssueNo = this.str_IssueNo; myClass_Student.SubjectID = myDataRow["ExamSubjectID"].ToString().Trim(); myClass_Student.ExamStatus = "顺利考试"; myClass_Student.myClass_WeldingParameter = myClass_Issue.myClass_WeldingParameter; myClass_Student.AddAndModify(Enum_zwjKindofUpdate.Add); //str_ErrMessage = myClass_Student.CheckField(); //if (!string.IsNullOrEmpty(str_ErrMessage)) //{ // myDataRow["ErrMessage"] = str_ErrMessage; // continue; //} } this.DialogResult = DialogResult.OK; this.Close(); }
private void button_OnOK_Click(object sender, EventArgs e) { this.CheckData_DataTable(); if (this.myDataTable.Select("Len(ErrMessage)>0").Length > 0) { this.DialogResult = DialogResult.None; this.label_ErrMessage.Text = "有数据不合法,请查看 ErrMessage 字段返回信息! "; return; } else { if (MessageBox.Show("确认导入吗?", "确认窗口", MessageBoxButtons.OKCancel) != DialogResult.OK) { this.DialogResult = DialogResult.None; return; } } Class_Welder myClass_Welder; Class_Student myClass_Student; Class_Issue myClass_Issue; //string str_ErrMessage; bool bool_WelderFilled; foreach (DataRow myDataRow in this.myDataTable.Rows) { //myDataRow["ErrMessage"] = ""; //str_ErrMessage = ""; myClass_Issue = new Class_Issue(myDataRow["IssueNo"].ToString().Trim()); myClass_Welder = new Class_Welder(); myClass_Welder.IdentificationCard = myDataRow["IdentificationCard"].ToString().Trim(); bool_WelderFilled = myClass_Welder.FillData(); myClass_Welder.WelderName = myDataRow["WelderName"].ToString().Trim(); myClass_Welder.Schooling = myDataRow["Schooling"].ToString().Trim(); myClass_Welder.Sex = myDataRow["Sex"].ToString().Trim(); DateTime.TryParse(myDataRow["WeldingBeginning"].ToString().Trim(), out myClass_Welder.WeldingBeginning); myClass_Welder.myClass_BelongUnit.WorkerID = myDataRow["WelderWorkerID"].ToString().Trim(); myClass_Welder.myClass_BelongUnit.EmployerHPID = myDataRow["WelderEmployerHPID"].ToString(); myClass_Welder.myClass_BelongUnit.DepartmentHPID = myDataRow["WelderDepartmentHPID"].ToString(); myClass_Welder.myClass_BelongUnit.WorkPlaceHPID = myDataRow["WelderWorkPlaceHPID"].ToString(); myClass_Welder.myClass_BelongUnit.LaborServiceTeamHPID = myDataRow["WelderLaborServiceTeamHPID"].ToString(); //str_ErrMessage = myClass_Welder.CheckField(); //if (!string.IsNullOrEmpty(str_ErrMessage)) //{ // myDataRow["ErrMessage"] = str_ErrMessage; // continue; //} if (bool_WelderFilled) { myClass_Welder.AddAndModify(Enum_zwjKindofUpdate.Modify); } else { myClass_Welder.AddAndModify(Enum_zwjKindofUpdate.Add); } Class_ShipClassification myClass_ShipClassification = new Class_ShipClassification(myClass_Issue.ShipClassificationAb); if (!Class_TestCommitteeRegistrationNo.ExistSecond(myClass_ShipClassification.TestCommitteeID, myClass_Welder.IdentificationCard, Enum_zwjKindofUpdate.Exist)) { Class_TestCommittee myClass_TestCommittee = new Class_TestCommittee(myClass_ShipClassification.TestCommitteeID); if (System.Text.RegularExpressions.Regex.IsMatch(myDataRow["RegistrationNo"].ToString().Trim(), myClass_TestCommittee.RegistrationNoRegex)) { myClass_TestCommittee.NextRegistrationNo = myDataRow["RegistrationNo"].ToString().Trim(); myClass_TestCommittee.AddAndModify(Enum_zwjKindofUpdate.Modify); } } myClass_ShipClassification.NextExaminingNo = myDataRow["ExaminingNo"].ToString().Trim(); myClass_ShipClassification.NextCertificateNo = myDataRow["CertificateNo"].ToString().Trim(); myClass_ShipClassification.AddAndModify(Enum_zwjKindofUpdate.Modify); myClass_Student = new Class_Student(); myClass_Student.IdentificationCard = myClass_Welder.IdentificationCard; myClass_Student.IssueNo = myClass_Issue.IssueNo; myClass_Student.SubjectID = myDataRow["ExamSubjectID"].ToString().Trim(); myClass_Student.ExamStatus = "顺利考试"; int.TryParse(myDataRow["TheoryResult"].ToString(), out myClass_Student.TheoryResult); myClass_Student.SkillResult = true; myClass_Student.myClass_WeldingParameter = myClass_Issue.myClass_WeldingParameter; if (!string.IsNullOrEmpty(myDataRow["StudentMaterial"].ToString().Trim())) { myClass_Student.myClass_WeldingParameter.Material = myDataRow["StudentMaterial"].ToString().Trim(); } if (!string.IsNullOrEmpty(myDataRow["StudentWeldingConsumable"].ToString().Trim())) { myClass_Student.myClass_WeldingParameter.WeldingConsumable = myDataRow["StudentWeldingConsumable"].ToString().Trim(); } myClass_Student.AddAndModify(Enum_zwjKindofUpdate.Add); Class_QC myClass_QC = new Class_QC(); myClass_QC.ExaminingNo = myClass_Student.ExaminingNo; myClass_QC.isQCValid = true; DateTime.TryParse(myDataRow["IssuedOn"].ToString().Trim(), out myClass_QC.IssuedOn); int.TryParse(myDataRow["OriginalPeriod"].ToString(), out myClass_QC.OriginalPeriod); int.TryParse(myDataRow["PeriodofProlongation"].ToString(), out myClass_QC.PeriodofProlongation); myClass_QC.SupervisionPlace = "沪东造船"; myClass_QC.AddAndModify(Enum_zwjKindofUpdate.Add); //str_ErrMessage = myClass_Student.CheckField(); //if (!string.IsNullOrEmpty(str_ErrMessage)) //{ // myDataRow["ErrMessage"] = str_ErrMessage; // continue; //} } this.DialogResult = DialogResult.OK; this.Close(); }
private void toolStripMenuItem_RowTransferToIssue_Click(object sender, EventArgs e) { //Form_InputBox myForm = new Form_InputBox(); //myForm.str_DefaultResponse = this.str_IssueNo; //myForm.str_Prompt = "请输入班级编号:"; //myForm.str_Title = "输入班级编号"; //if (myForm.ShowDialog() == DialogResult.OK) //{ // this.str_IssueNo = myForm.str_DefaultResponse; //} //else //{ // return; //} Form_Issue_Query myForm = new Form_Issue_Query(); myForm.myClass_Issue = new Class_Issue(); if (!string.IsNullOrEmpty(this.str_IssueNo)) { myForm.myClass_Issue.IssueNo = this.str_IssueNo; myForm.myClass_Issue.FillData(); } if (myForm.ShowDialog() == DialogResult.OK) { this.str_IssueNo = myForm.myClass_Issue.IssueNo; } else { return; } if (Class_Issue.ExistAndCanDeleteAndDelete(this.str_IssueNo, Enum_zwjKindofUpdate.Exist)) { Class_KindofEmployerStudent myClass_KindofEmployerStudent = new Class_KindofEmployerStudent((int)this.dataGridView_Data.CurrentRow.Cells["KindofEmployerStudentID"].Value); Class_KindofEmployerWelder myClass_KindofEmployerWelder = new Class_KindofEmployerWelder(myClass_KindofEmployerStudent.KindofEmployerWelderID); Class_Student myClass_Student = new Class_Student(); myClass_Student.IssueNo = this.str_IssueNo; myClass_Student.IdentificationCard = myClass_KindofEmployerWelder.IdentificationCard; myClass_Student.SubjectID = myClass_KindofEmployerStudent.ExamSubjectID; Class_Issue myClass_Issue = new Class_Issue(myClass_Student.IssueNo); myClass_Student.myClass_WeldingParameter = myClass_Issue.myClass_WeldingParameter; myClass_Student.myClass_WeldingParameter.KindofExam = myClass_KindofEmployerStudent.StudentKindofExam; Class_KindofEmployerIssue myClass_KindofEmployerIssue = new Class_KindofEmployerIssue(myClass_KindofEmployerStudent.KindofEmployerIssueID); myClass_Student.WPSNo = myClass_KindofEmployerIssue.IssueWPSNo; string str_ReturnMessage; str_ReturnMessage = myClass_Student.CheckField(); if (string.IsNullOrEmpty(str_ReturnMessage)) { Class_KindofEmployerWelder.TransferWelder(myClass_KindofEmployerStudent.KindofEmployerWelderID); myClass_Student.AddAndModify(Enum_zwjKindofUpdate.Add); if (string.IsNullOrEmpty(myClass_Student.ExaminingNo)) { MessageBox.Show("编入班级失败,可能是下一个考编号设置错误!"); } else { Class_KindofEmployerStudent.ExistAndCanDeleteAndDelete(myClass_KindofEmployerStudent.KindofEmployerStudentID, Enum_zwjKindofUpdate.Delete); this.myEventArgs_KindofEmployerIssue.bool_JustFill = false; Publisher_KindofEmployerIssue.OnEventName(this.myEventArgs_KindofEmployerIssue); MessageBox.Show(string.Format("编入班级成功,班级编号为 {0},考编号为 {1}", this.str_IssueNo, myClass_Student.ExaminingNo)); } } else { MessageBox.Show(string.Format("编入班级失败,{0}!", str_ReturnMessage)); } } else { MessageBox.Show(string.Format("不存在班级编号为 {0} 的班级!", this.str_IssueNo)); } }