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 CheckData_DataTable() { Class_Welder myClass_Welder; Class_Student myClass_Student; Class_Issue myClass_Issue = new Class_Issue(this.str_IssueNo); string str_ErrMessage; foreach (DataRow myDataRow in this.myDataTable.Rows) { myDataRow["ErrMessage"] = ""; str_ErrMessage = ""; myClass_Welder = new Class_Welder(); myClass_Welder.IdentificationCard = myDataRow["IdentificationCard"].ToString().Trim(); 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 = Class_Employer.GetEmployerHPID(myDataRow["WelderBelongEmployer"].ToString()); myClass_Welder.myClass_BelongUnit.EmployerHPID = Class_Employer.GetEmployerHPIDbyDataTable(myDataRow["WelderEmployer"].ToString().Trim()); myDataRow["WelderEmployerHPID"] = myClass_Welder.myClass_BelongUnit.EmployerHPID; if (string.IsNullOrEmpty(myClass_Welder.myClass_BelongUnit.EmployerHPID)) { str_ErrMessage = "公司数据有误!"; } else { if (!string.IsNullOrEmpty(myDataRow["WelderDepartment"].ToString().Trim())) { //myClass_Welder.myClass_BelongUnit.DepartmentHPID = Class_Department.GetDepartmentHPID(myClass_Welder.myClass_BelongUnit.EmployerHPID, myDataRow["WelderBelongDepartment"].ToString()); myClass_Welder.myClass_BelongUnit.DepartmentHPID = Class_Department.GetDepartmentHPIDbyDataTable(myClass_Welder.myClass_BelongUnit.EmployerHPID, myDataRow["WelderDepartment"].ToString().Trim()); myDataRow["WelderDepartmentHPID"] = myClass_Welder.myClass_BelongUnit.DepartmentHPID; if (string.IsNullOrEmpty(myClass_Welder.myClass_BelongUnit.DepartmentHPID)) { str_ErrMessage = "部门数据有误!"; } else { if (!string.IsNullOrEmpty(myDataRow["WelderWorkPlace"].ToString().Trim())) { //myClass_Welder.myClass_BelongUnit.WorkPlaceHPID = Class_WorkPlace.GetWorkPlaceHPID(myClass_Welder.myClass_BelongUnit.DepartmentHPID, myDataRow["WelderBelongWorkPlace"].ToString()); myClass_Welder.myClass_BelongUnit.WorkPlaceHPID = Class_WorkPlace.GetWorkPlaceHPIDbyDataTable(myClass_Welder.myClass_BelongUnit.DepartmentHPID, myDataRow["WelderWorkPlace"].ToString().Trim()); myDataRow["WelderWorkPlaceHPID"] = myClass_Welder.myClass_BelongUnit.WorkPlaceHPID; if (string.IsNullOrEmpty(myClass_Welder.myClass_BelongUnit.WorkPlaceHPID)) { str_ErrMessage = "作业区数据有误!"; } } } } if (!string.IsNullOrEmpty(myDataRow["WelderLaborServiceTeam"].ToString().Trim())) { //myClass_Welder.myClass_BelongUnit.LaborServiceTeamHPID = Class_LaborServiceTeam.GetLaborServiceTeamHPID(myClass_Welder.myClass_BelongUnit.EmployerHPID, myDataRow["WelderBelongLaborServiceTeam"].ToString()); myClass_Welder.myClass_BelongUnit.LaborServiceTeamHPID = Class_LaborServiceTeam.GetLaborServiceTeamHPIDbyDataTable(myClass_Welder.myClass_BelongUnit.EmployerHPID, myDataRow["WelderLaborServiceTeam"].ToString().Trim()); myDataRow["WelderLaborServiceTeamHPID"] = myClass_Welder.myClass_BelongUnit.LaborServiceTeamHPID; if (string.IsNullOrEmpty(myClass_Welder.myClass_BelongUnit.LaborServiceTeamHPID)) { str_ErrMessage = "劳务队数据有误!"; } } } if (!string.IsNullOrEmpty(str_ErrMessage)) { myDataRow["ErrMessage"] = str_ErrMessage; continue; } else { str_ErrMessage = myClass_Welder.CheckField(); if (!string.IsNullOrEmpty(str_ErrMessage)) { myDataRow["ErrMessage"] = str_ErrMessage; continue; } string str_WelderName_Temp = Class_Welder.GetWelderName(myClass_Welder.IdentificationCard); if (!string.IsNullOrEmpty(str_WelderName_Temp) && str_WelderName_Temp != myClass_Welder.WelderName) { myDataRow["ErrMessage"] = "姓名与数据库中该焊工不符!"; continue; } } 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; str_ErrMessage = myClass_Student.CheckField(); if (!string.IsNullOrEmpty(str_ErrMessage)) { myDataRow["ErrMessage"] = str_ErrMessage; continue; } } }
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)); } }