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