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));
}
}
