private void toolStripMenuItem_RowTransferToGXTheoryIssue_Click(object sender, EventArgs e)
{
Form_GXTheoryIssue_Query myForm = new Form_GXTheoryIssue_Query();
myForm.myClass_GXTheoryIssue = new Class_GXTheoryIssue();
if (!string.IsNullOrEmpty(this.str_IssueNo))
{
myForm.myClass_GXTheoryIssue.IssueNo = this.str_IssueNo;
myForm.myClass_GXTheoryIssue.FillData();
}
if (myForm.ShowDialog() == DialogResult.OK)
{
this.str_IssueNo = myForm.myClass_GXTheoryIssue.IssueNo;
}
else
{
return;
}
if (Class_GXTheoryIssue.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_GXTheoryStudent myClass_GXTheoryStudent = new Class_GXTheoryStudent();
myClass_GXTheoryStudent.IssueNo = this.str_IssueNo;
myClass_GXTheoryStudent.IdentificationCard = myClass_KindofEmployerWelder.IdentificationCard;
myClass_GXTheoryStudent.SubjectID = myClass_KindofEmployerStudent.ExamSubjectID;
Class_GXTheoryIssue myClass_GXTheoryIssue = new Class_GXTheoryIssue(myClass_GXTheoryStudent.IssueNo);
myClass_GXTheoryStudent.KindofExam = myClass_GXTheoryIssue.KindofExam;
string str_ReturnMessage;
str_ReturnMessage = myClass_GXTheoryStudent.CheckField();
if (string.IsNullOrEmpty(str_ReturnMessage))
{
Class_KindofEmployerWelder.TransferWelder(myClass_KindofEmployerStudent.KindofEmployerWelderID);
myClass_GXTheoryStudent.AddAndModify(Enum_zwjKindofUpdate.Add);
if (string.IsNullOrEmpty(myClass_GXTheoryStudent.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_GXTheoryStudent.ExaminingNo));
}
}
else
{
MessageBox.Show(string.Format("编入理论班级失败，{0}！", str_ReturnMessage));
}
}
else
{
MessageBox.Show(string.Format("不存在理论班级编号为 {0} 的班级!", this.str_IssueNo));
}
}
private void button_OnOK_Click(object sender, EventArgs e)
{
this.userControl_KindofEmployerWelder_Base1.FillClass();
String str_ErrMessage;
str_ErrMessage = this.myClass_KindofEmployerWelder.CheckField();
if (!string.IsNullOrEmpty(str_ErrMessage))
{
this.DialogResult = DialogResult.None;
this.label_ErrMessage.Text = str_ErrMessage;
return;
}
if (this.bool_Add)
{
if (Class_KindofEmployerWelder.ExistSecond(this.myClass_KindofEmployerWelder.KindofEmployer, this.myClass_KindofEmployerWelder.IdentificationCard, 0, Enum_zwjKindofUpdate.Add))
{
this.DialogResult = DialogResult.None;
this.label_ErrMessage.Text = "身份证号码不能重复！";
return;
}
else
{
this.myClass_KindofEmployerWelder.AddAndModify(Enum_zwjKindofUpdate.Add);
if (!Class_Welder.ExistAndCanDeleteAndDelete(myClass_KindofEmployerWelder.IdentificationCard, Enum_zwjKindofUpdate.Exist))
{
Class_Welder myClass_Welder = new Class_Welder();
myClass_Welder.IdentificationCard = myClass_KindofEmployerWelder.IdentificationCard;
myClass_Welder.Schooling = myClass_KindofEmployerWelder.Schooling;
myClass_Welder.Sex = myClass_KindofEmployerWelder.Sex;
myClass_Welder.WelderName = myClass_KindofEmployerWelder.WelderName;
myClass_Welder.WeldingBeginning = myClass_KindofEmployerWelder.WeldingBeginning;
myClass_Welder.myClass_BelongUnit = myClass_KindofEmployerWelder.myClass_BelongUnit;
myClass_Welder.AddAndModify(Enum_zwjKindofUpdate.Add);
}
}
}
else
{
if (Class_KindofEmployerWelder.ExistSecond(this.myClass_KindofEmployerWelder.KindofEmployer, this.myClass_KindofEmployerWelder.IdentificationCard, this.myClass_KindofEmployerWelder.KindofEmployerWelderID, Enum_zwjKindofUpdate.Modify))
{
this.DialogResult = DialogResult.None;
this.label_ErrMessage.Text = "身份证号码不能重复！";
return;
}
else
{
this.myClass_KindofEmployerWelder.AddAndModify(Enum_zwjKindofUpdate.Modify);
}
}
}
/// <summary>
/// 删除数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void toolStripMenuItem_DataGridViewRowDelete_Click(object sender, EventArgs e)
{
if (Class_KindofEmployerWelder.ExistAndCanDeleteAndDelete((int)this.dataGridView_Data.CurrentRow.Cells["KindofEmployerWelderID"].Value, Enum_zwjKindofUpdate.CanDelete))
{
if (MessageBox.Show("确认删除吗？", "确认窗口", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
Class_KindofEmployerWelder.ExistAndCanDeleteAndDelete((int)this.dataGridView_Data.CurrentRow.Cells["KindofEmployerWelderID"].Value, Enum_zwjKindofUpdate.Delete);
this.RefreshData(false);
}
}
else
{
MessageBox.Show("不能删除！");
}
}
/// <summary>
/// 更新数据到对象中
/// </summary>
public void FillClass()
{
myClass_KindofEmployerWelder.IdentificationCard = this.MaskedTextBox_IdentificationCard.Text;
myClass_KindofEmployerWelder.WelderName = this.TextBox_WelderName.Text;
myClass_KindofEmployerWelder.WelderEnglishName = this.textBox_WelderEnglishName.Text;
myClass_KindofEmployerWelder.Sex = this.CheckBox_Sex.Checked ? "男" : "女";
myClass_KindofEmployerWelder.Schooling = this.ComboBox_Schooling.SelectedValue.ToString();
myClass_KindofEmployerWelder.WeldingBeginning = this.DateTimePicker_WeldingBeinning.Value;
myClass_KindofEmployerWelder.myClass_BelongUnit.EmployerHPID = this.ComboBox_Employer.SelectedValue.ToString();
if (this.CheckBox_Department.Checked && this.ComboBox_Department.SelectedValue != null)
{
myClass_KindofEmployerWelder.myClass_BelongUnit.DepartmentHPID = this.ComboBox_Department.SelectedValue.ToString();
if (this.CheckBox_WorkPlace.Checked && this.ComboBox_WorkPlace.SelectedValue != null)
{
myClass_KindofEmployerWelder.myClass_BelongUnit.WorkPlaceHPID = this.ComboBox_WorkPlace.SelectedValue.ToString();
}
else
{
myClass_KindofEmployerWelder.myClass_BelongUnit.WorkPlaceHPID = "";
}
}
else
{
myClass_KindofEmployerWelder.myClass_BelongUnit.DepartmentHPID = "";
}
if (this.CheckBox_LaborServiceTeam.Checked && this.ComboBox_LaborServiceTeam.SelectedValue != null)
{
myClass_KindofEmployerWelder.myClass_BelongUnit.LaborServiceTeamHPID = this.ComboBox_LaborServiceTeam.SelectedValue.ToString();
}
else
{
myClass_KindofEmployerWelder.myClass_BelongUnit.LaborServiceTeamHPID = "";
}
myClass_KindofEmployerWelder.myClass_BelongUnit.WorkerID = this.TextBox_WorkerID.Text;
myClass_KindofEmployerWelder.WelderRemark = this.TextBox_WelderRemark.Text;
if (myClass_KindofEmployerWelderDefault == null)
{
myClass_KindofEmployerWelderDefault = new Class_KindofEmployerWelder();
}
myClass_KindofEmployerWelderDefault.Schooling = myClass_KindofEmployerWelder.Schooling;
myClass_KindofEmployerWelderDefault.Sex = myClass_KindofEmployerWelder.Sex;
myClass_KindofEmployerWelderDefault.WeldingBeginning = myClass_KindofEmployerWelder.WeldingBeginning;
myClass_KindofEmployerWelderDefault.myClass_BelongUnit.EmployerHPID = myClass_KindofEmployerWelder.myClass_BelongUnit.EmployerHPID;
myClass_KindofEmployerWelderDefault.myClass_BelongUnit.DepartmentHPID = myClass_KindofEmployerWelder.myClass_BelongUnit.DepartmentHPID;
myClass_KindofEmployerWelderDefault.myClass_BelongUnit.WorkPlaceHPID = myClass_KindofEmployerWelder.myClass_BelongUnit.WorkPlaceHPID;
myClass_KindofEmployerWelderDefault.myClass_BelongUnit.LaborServiceTeamHPID = myClass_KindofEmployerWelder.myClass_BelongUnit.LaborServiceTeamHPID;
}
private void Form_KindofEmployerWelder_Update_Load(object sender, EventArgs e)
{
if (!(this.bool_Add || Class_KindofEmployerWelder.ExistAndCanDeleteAndDelete(myClass_KindofEmployerWelder.KindofEmployerWelderID, Enum_zwjKindofUpdate.Exist)))
{
MessageBox.Show("不存在该项，可能已删除！");
this.DialogResult = DialogResult.Cancel;
this.Close();
return;
}
this.label_ErrMessage.Text = "";
if (!Class_zwjPublic.myBackColor.IsEmpty)
{
this.BackColor = Class_zwjPublic.myBackColor;
}
this.userControl_KindofEmployerWelder_Base1.InitControl(this.myClass_KindofEmployerWelder, this.bool_Add);
}
public void InitControlWelder(Class_KindofEmployerWelder myClass_KindofEmployerWelder)
{
this.TextBox_WelderName.Text = myClass_KindofEmployerWelder.WelderName;
this.MaskedTextBox_IdentificationCard.Text = myClass_KindofEmployerWelder.IdentificationCard;
this.TextBox_Schooling.Text = myClass_KindofEmployerWelder.Schooling;
this.TextBox_KindofEmployerWelderID.Text = myClass_KindofEmployerWelder.KindofEmployerWelderID.ToString();
this.DateTimePicker_WeldingBeinning.Value = myClass_KindofEmployerWelder.WeldingBeginning;
this.TextBox_WorkerID.Text = myClass_KindofEmployerWelder.myClass_BelongUnit.WorkerID;
Class_Employer myClass_Employer = new Class_Employer(myClass_KindofEmployerWelder.myClass_BelongUnit.EmployerHPID);
this.TextBox_Employer.Text = myClass_Employer.Employer;
Class_Department myClass_Department = new Class_Department(myClass_KindofEmployerWelder.myClass_BelongUnit.DepartmentHPID);
this.TextBox_Department.Text = myClass_Department.Department;
Class_WorkPlace myClass_WorkPlace = new Class_WorkPlace(myClass_KindofEmployerWelder.myClass_BelongUnit.WorkPlaceHPID);
this.TextBox_WorkPlace.Text = myClass_WorkPlace.WorkPlace;
Class_LaborServiceTeam myClass_LaborServiceTeam = new Class_LaborServiceTeam(myClass_KindofEmployerWelder.myClass_BelongUnit.LaborServiceTeamHPID);
this.TextBox_LaborServiceTeam.Text = myClass_LaborServiceTeam.LaborServiceTeam;
this.CheckBox_Sex.Checked = myClass_KindofEmployerWelder.Sex == "男";
}
/// <summary>
/// 初始化数据
/// </summary>
/// <param name="myClass_KindofEmployerWelder"></param>
/// <param name="bool_Add"></param>
public void InitControl(Class_KindofEmployerWelder myClass_KindofEmployerWelder, bool bool_Add)
{
Class_Data myClass_Data;
myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.Employer.ToString()];
this.myDataView_Employer = new DataView(myClass_Data.myDataTable);
this.myDataView_Employer.Sort = myClass_Data.myDataView.Sort;
myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.Department.ToString()];
this.myDataView_Department = new DataView(myClass_Data.myDataTable);
this.myDataView_Department.Sort = myClass_Data.myDataView.Sort;
myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.WorkPlace.ToString()];
this.myDataView_WorkPlace = new DataView(myClass_Data.myDataTable);
this.myDataView_WorkPlace.Sort = myClass_Data.myDataView.Sort;
myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.LaborServiceTeam.ToString()];
this.myDataView_LaborServiceTeam = new DataView(myClass_Data.myDataTable);
this.myDataView_LaborServiceTeam.Sort = myClass_Data.myDataView.Sort;
Class_DataControlBind.InitializeComboBox(this.ComboBox_LaborServiceTeam, this.myDataView_LaborServiceTeam, "LaborServiceTeamHPID", "LaborServiceTeam");
Class_DataControlBind.InitializeComboBox(this.ComboBox_WorkPlace, this.myDataView_WorkPlace, "WorkPlaceHPID", "WorkPlace");
Class_DataControlBind.InitializeComboBox(this.ComboBox_Department, this.myDataView_Department, "DepartmentHPID", "Department");
Class_DataControlBind.InitializeComboBox(this.ComboBox_Employer, this.myDataView_Employer, "EmployerHPID", "Employer");
Class_Public.InitializeComboBox(this.ComboBox_Schooling, Enum_DataTable.Schooling.ToString(), "Schooling", "Schooling");
this.myClass_KindofEmployerWelder = myClass_KindofEmployerWelder;
this.textBox_KindofEmployer.Text = this.myClass_KindofEmployerWelder.KindofEmployer;
Class_KindofEmployer myClass_KindofEmployer = new Class_KindofEmployer(this.myClass_KindofEmployerWelder.KindofEmployer);
switch (myClass_KindofEmployer.KindofEmployerLevel)
{
case 0:
break;
case 1:
this.ComboBox_Employer.Enabled = false;
break;
case 2:
this.ComboBox_Employer.Enabled = false;
this.ComboBox_Department.Enabled = false;
this.CheckBox_Department.Enabled = false;
break;
case 3:
this.ComboBox_Employer.Enabled = false;
this.ComboBox_Department.Enabled = false;
this.CheckBox_Department.Enabled = false;
this.ComboBox_WorkPlace.Enabled = false;
this.CheckBox_WorkPlace.Enabled = false;
break;
case 4:
this.ComboBox_Employer.Enabled = false;
this.ComboBox_LaborServiceTeam.Enabled = false;
this.CheckBox_LaborServiceTeam.Enabled = false;
break;
}
if (bool_Add)
{
if (!string.IsNullOrEmpty(myClass_KindofEmployer.KindofEmployerEmployerHPID))
{
this.ComboBox_Employer.SelectedValue = myClass_KindofEmployer.KindofEmployerEmployerHPID;
if (!string.IsNullOrEmpty(myClass_KindofEmployer.KindofEmployerDepartmentHPID))
{
this.ComboBox_Department.SelectedValue = myClass_KindofEmployer.KindofEmployerDepartmentHPID;
if (!string.IsNullOrEmpty(myClass_KindofEmployer.KindofEmployerWorkPlaceHPID))
{
this.ComboBox_WorkPlace.SelectedValue = myClass_KindofEmployer.KindofEmployerWorkPlaceHPID;
}
}
if (!string.IsNullOrEmpty(myClass_KindofEmployer.KindofEmployerLaborServiceTeamHPID))
{
this.ComboBox_LaborServiceTeam.SelectedValue = myClass_KindofEmployer.KindofEmployerLaborServiceTeamHPID;
}
}
if (myClass_KindofEmployerWelderDefault != null)
{
this.CheckBox_Sex.Checked = myClass_KindofEmployerWelderDefault.Sex == "男";
this.DateTimePicker_WeldingBeinning.Value = myClass_KindofEmployerWelderDefault.WeldingBeginning;
this.ComboBox_Schooling.SelectedValue = myClass_KindofEmployerWelderDefault.Schooling;
this.ComboBox_Employer.SelectedValue = myClass_KindofEmployerWelderDefault.myClass_BelongUnit.EmployerHPID;
this.myDataView_Department.RowFilter = string.Format("EmployerHPID='{0}'", myClass_KindofEmployerWelderDefault.myClass_BelongUnit.EmployerHPID);
this.myDataView_LaborServiceTeam.RowFilter = string.Format("EmployerHPID='{0}'", myClass_KindofEmployerWelderDefault.myClass_BelongUnit.EmployerHPID);
if (string.IsNullOrEmpty(myClass_KindofEmployerWelderDefault.myClass_BelongUnit.DepartmentHPID))
{
this.CheckBox_Department.Checked = false;
}
else
{
this.ComboBox_Department.SelectedValue = myClass_KindofEmployerWelderDefault.myClass_BelongUnit.DepartmentHPID;
this.CheckBox_Department.Checked = true;
this.myDataView_WorkPlace.RowFilter = string.Format("DepartmentHPID='{0}'", myClass_KindofEmployerWelderDefault.myClass_BelongUnit.DepartmentHPID);
if (!string.IsNullOrEmpty(myClass_KindofEmployerWelderDefault.myClass_BelongUnit.WorkPlaceHPID))
{
this.ComboBox_WorkPlace.SelectedValue = myClass_KindofEmployerWelderDefault.myClass_BelongUnit.WorkPlaceHPID;
this.CheckBox_WorkPlace.Checked = true;
}
else
{
this.CheckBox_WorkPlace.Checked = false;
}
}
if (string.IsNullOrEmpty(myClass_KindofEmployerWelderDefault.myClass_BelongUnit.LaborServiceTeamHPID))
{
this.CheckBox_LaborServiceTeam.Checked = false;
}
else
{
this.ComboBox_LaborServiceTeam.SelectedValue = myClass_KindofEmployerWelderDefault.myClass_BelongUnit.LaborServiceTeamHPID;
this.CheckBox_LaborServiceTeam.Checked = true;
}
}
}
else
{
this.textBox_KindofEmployerWelderID.Text = this.myClass_KindofEmployerWelder.KindofEmployerWelderID.ToString();
this.Button_IdentificationCardConvert.Enabled = false;
this.MaskedTextBox_IdentificationCard.Text = myClass_KindofEmployerWelder.IdentificationCard;
this.TextBox_WelderName.Text = myClass_KindofEmployerWelder.WelderName;
this.textBox_WelderEnglishName.Text = myClass_KindofEmployerWelder.WelderEnglishName;
this.CheckBox_Sex.Checked = myClass_KindofEmployerWelder.Sex == "男";
this.DateTimePicker_WeldingBeinning.Value = myClass_KindofEmployerWelder.WeldingBeginning;
this.TextBox_WorkerID.Text = myClass_KindofEmployerWelder.myClass_BelongUnit.WorkerID;
this.TextBox_WelderRemark.Text = myClass_KindofEmployerWelder.WelderRemark;
this.ComboBox_Schooling.SelectedValue = myClass_KindofEmployerWelder.Schooling;
this.ComboBox_Employer.SelectedValue = myClass_KindofEmployerWelder.myClass_BelongUnit.EmployerHPID;
this.myDataView_Department.RowFilter = string.Format("EmployerHPID='{0}'", myClass_KindofEmployerWelder.myClass_BelongUnit.EmployerHPID);
this.myDataView_LaborServiceTeam.RowFilter = string.Format("EmployerHPID='{0}'", myClass_KindofEmployerWelder.myClass_BelongUnit.EmployerHPID);
if (string.IsNullOrEmpty(myClass_KindofEmployerWelder.myClass_BelongUnit.DepartmentHPID))
{
this.CheckBox_Department.Checked = false;
}
else
{
this.ComboBox_Department.SelectedValue = myClass_KindofEmployerWelder.myClass_BelongUnit.DepartmentHPID;
this.CheckBox_Department.Checked = true;
this.myDataView_WorkPlace.RowFilter = string.Format("DepartmentHPID='{0}'", myClass_KindofEmployerWelder.myClass_BelongUnit.DepartmentHPID);
if (!string.IsNullOrEmpty(myClass_KindofEmployerWelder.myClass_BelongUnit.WorkPlaceHPID))
{
this.ComboBox_WorkPlace.SelectedValue = myClass_KindofEmployerWelder.myClass_BelongUnit.WorkPlaceHPID;
this.CheckBox_WorkPlace.Checked = true;
}
else
{
this.CheckBox_WorkPlace.Checked = false;
}
}
if (string.IsNullOrEmpty(myClass_KindofEmployerWelder.myClass_BelongUnit.LaborServiceTeamHPID))
{
this.CheckBox_LaborServiceTeam.Checked = false;
}
else
{
this.ComboBox_LaborServiceTeam.SelectedValue = myClass_KindofEmployerWelder.myClass_BelongUnit.LaborServiceTeamHPID;
this.CheckBox_LaborServiceTeam.Checked = true;
}
}
}
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));
}
}
private void toolStripMenuItem_RowSynchronizationhdhr_Click(object sender, EventArgs e)
{
if (MessageBox.Show("确认同步用友数据吗？", "确认窗口", MessageBoxButtons.OKCancel) != DialogResult.OK)
{
return;
}
string str_SQL = "SELECT docname FROM [hdhr].[dbo].[v_defdoc_xueli]";
SqlDataAdapter myAdapter = new SqlDataAdapter(str_SQL, Properties.Settings.Default.zwjConnhdhr);
DataTable myDataTable_xueli = new DataTable();
myAdapter.Fill(myDataTable_xueli);
Class_Schooling myClass_Schooling = new Class_Schooling();
foreach (DataRow myDataRow in myDataTable_xueli.Rows)
{
if (!Class_Schooling.ExistAndCanDeleteAndDelete(myDataRow["docname"].ToString(), Enum_zwjKindofUpdate.Exist))
{
myClass_Schooling.Schooling = myDataRow["docname"].ToString();
myClass_Schooling.AddAndModify(Enum_zwjKindofUpdate.Add);
}
}
str_SQL = "SELECT [ryid],[ryxm],[ryxb],[xlmc],[rygh],[jcrq],[gsmc],[bmmc],[kscj],[lwgs] FROM [hdhr].[dbo].[v_psninfo_to_hangong]";
Class_KindofEmployer myClass_KindofEmployer = new Class_KindofEmployer(this.myEventArgs_KindofEmployer.str_KindofEmployer);
Class_Employer myClass_Employer = new Class_Employer(myClass_KindofEmployer.KindofEmployerEmployerHPID);
Class_Department myClass_Department = new Class_Department(myClass_KindofEmployer.KindofEmployerDepartmentHPID);
Class_WorkPlace myClass_WorkPlace = new Class_WorkPlace(myClass_KindofEmployer.KindofEmployerWorkPlaceHPID);
switch (myClass_KindofEmployer.KindofEmployerLevel)
{
case 1:
str_SQL += string.Format(" where gsmc='{0}'", myClass_Employer.Employer);
break;
case 2:
str_SQL += string.Format(" where gsmc='{0}' and bmmc='{1}'", myClass_Employer.Employer, myClass_Department.Department);
break;
case 3:
str_SQL += string.Format(" where gsmc='{0}' and bmmc='{1}' and kscj='{2}'", myClass_Employer.Employer, myClass_Department.Department, myClass_WorkPlace.WorkPlace);
break;
default:
return;
}
myAdapter = new SqlDataAdapter(str_SQL, Properties.Settings.Default.zwjConnhdhr);
DataTable myDataTable_hdhrhangong = new DataTable();
myAdapter.Fill(myDataTable_hdhrhangong);
Class_KindofEmployerWelder myClass_KindofEmployerWelder = new Class_KindofEmployerWelder();
myClass_KindofEmployerWelder.KindofEmployer = myClass_KindofEmployer.KindofEmployer;
string str_Err;
int i_success = 0;
int i_success_add = 0;
int i_success_modify = 0;
int i_success_delete = 0;
int i_fail = 0;
StringBuilder myStringBuilder_err = new StringBuilder();
foreach (DataRow myDataRow in this.myDataTable.Rows)
{
if (myDataTable_hdhrhangong.Select(string.Format("ryid='{0}'", myDataRow["IdentificationCard"])).GetLength(0) == 0)
{
Class_KindofEmployerWelder.ExistAndCanDeleteAndDelete((int)myDataRow["KindofEmployerWelderID"], Enum_zwjKindofUpdate.Delete);
i_success_delete++;
}
}
foreach (DataRow myDataRow in myDataTable_hdhrhangong.Rows)
{
myClass_KindofEmployerWelder.IdentificationCard = myDataRow["ryid"].ToString();
myClass_KindofEmployerWelder.WelderName = myDataRow["ryxm"].ToString();
myClass_KindofEmployerWelder.Sex = myDataRow["ryxb"].ToString();
myClass_KindofEmployerWelder.Schooling = myDataRow["xlmc"].ToString();
if (!DateTime.TryParse(myDataRow["jcrq"].ToString(), out myClass_KindofEmployerWelder.WeldingBeginning))
{
myClass_KindofEmployerWelder.WeldingBeginning = DateTime.Now;
}
myClass_KindofEmployerWelder.myClass_BelongUnit.WorkerID = myDataRow["rygh"].ToString();
myClass_KindofEmployerWelder.myClass_BelongUnit.EmployerHPID = Class_Employer.GetEmployerHPID(myDataRow["gsmc"].ToString());
if (string.IsNullOrEmpty(myClass_KindofEmployerWelder.myClass_BelongUnit.EmployerHPID))
{
i_fail++;
myStringBuilder_err.Append(string.Format("\n身份证号码：{0}, 错误信息：公司名称不符", myClass_KindofEmployerWelder.IdentificationCard));
continue;
}
else
{
myClass_KindofEmployerWelder.myClass_BelongUnit.DepartmentHPID = Class_Department.GetDepartmentHPID(myClass_KindofEmployerWelder.myClass_BelongUnit.EmployerHPID, myDataRow["bmmc"].ToString());
if (string.IsNullOrEmpty(myClass_KindofEmployerWelder.myClass_BelongUnit.DepartmentHPID))
{
myClass_KindofEmployerWelder.myClass_BelongUnit.WorkPlaceHPID = null;
}
else
{
myClass_KindofEmployerWelder.myClass_BelongUnit.WorkPlaceHPID = Class_WorkPlace.GetWorkPlaceHPID(myClass_KindofEmployerWelder.myClass_BelongUnit.DepartmentHPID, myDataRow["kscj"].ToString());
}
myClass_KindofEmployerWelder.myClass_BelongUnit.LaborServiceTeamHPID = Class_LaborServiceTeam.GetLaborServiceTeamHPID(myClass_KindofEmployerWelder.myClass_BelongUnit.EmployerHPID, myDataRow["lwgs"].ToString());
}
str_Err = myClass_KindofEmployerWelder.CheckField();
if (string.IsNullOrEmpty(str_Err))
{
if (Class_KindofEmployerWelder.ExistSecond(myClass_KindofEmployerWelder.KindofEmployer, myClass_KindofEmployerWelder.IdentificationCard, 0, Enum_zwjKindofUpdate.Add))
{
myClass_KindofEmployerWelder.KindofEmployerWelderID = Class_KindofEmployerWelder.GetKindofEmployerWelderID(myClass_KindofEmployerWelder.KindofEmployer, myClass_KindofEmployerWelder.IdentificationCard);
myClass_KindofEmployerWelder.AddAndModify(Enum_zwjKindofUpdate.Modify);
i_success_modify++;
i_success++;
}
else
{
myClass_KindofEmployerWelder.AddAndModify(Enum_zwjKindofUpdate.Add);
i_success_add++;
i_success++;
if (!Class_Welder.ExistAndCanDeleteAndDelete(myClass_KindofEmployerWelder.IdentificationCard, Enum_zwjKindofUpdate.Exist))
{
Class_Welder myClass_Welder = new Class_Welder();
myClass_Welder.IdentificationCard = myClass_KindofEmployerWelder.IdentificationCard;
myClass_Welder.Schooling = myClass_KindofEmployerWelder.Schooling;
myClass_Welder.Sex = myClass_KindofEmployerWelder.Sex;
myClass_Welder.WelderName = myClass_KindofEmployerWelder.WelderName;
myClass_Welder.WeldingBeginning = myClass_KindofEmployerWelder.WeldingBeginning;
myClass_Welder.myClass_BelongUnit = myClass_KindofEmployerWelder.myClass_BelongUnit;
myClass_Welder.AddAndModify(Enum_zwjKindofUpdate.Add);
}
}
}
else
{
i_fail++;
myStringBuilder_err.Append(string.Format("\n身份证号码：{0}, 错误信息：{1}", myClass_KindofEmployerWelder.IdentificationCard, str_Err));
}
}
this.RefreshData(false);
MessageBox.Show(string.Format("操作完成，其中同步成功{0}条，添加{1}条，删除{2}条，失败{3}条，失败原因如下：\n{4}", i_success, i_success_add, i_success_delete, i_fail, myStringBuilder_err.ToString()));
}
