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