/// <summary> /// 更新数据到对象中 /// </summary> public void FillClass() { this.myClass_QC.CertificateNo = this.MaskedTextBox_CertificateNo.Text; this.myClass_QC.SupervisionPlace = this.TextBox_SupervisionPlace.Text; this.myClass_QC.IssuedOn = this.dateTimePicker_IssuedOn.Value; this.myClass_QC.OriginalPeriod = (int)this.NumericUpDown_OriginalPeriod.Value; this.myClass_QC.PeriodofProlongation = (int)this.numericUpDown_PeriodofProlongation.Value; this.myClass_QC.QCRemark = this.TextBox_QCRemark.Text; this.myClass_QC.isQCValid = this.checkBox_isQCValid.Checked; this.myClass_QC.SupervisionCycle = (int)this.numericUpDown_SupervisionCycle.Value; this.myClass_QC.SupervisionFirst = this.checkBox_SupervisionFirst.Checked; this.myClass_QC.SupervisionSecond = this.checkBox_SupervisionSecond.Checked; this.myClass_QC.SupervisionThird = this.checkBox_SupervisionThird.Checked; this.myClass_QC.SupervisionFourth = this.checkBox_SupervisionFourth.Checked; this.myClass_QC.SupervisionFifth = this.checkBox_SupervisionFifth.Checked; this.myClass_QC.SupervisionSixth = this.checkBox_SupervisionSixth.Checked; this.myClass_QC.SupervisionSeventh = this.checkBox_SupervisionSeventh.Checked; this.myClass_QC.SupervisionEighth = this.checkBox_SupervisionEighth.Checked; if (myClass_QCDefault == null) { myClass_QCDefault = new Class_QC(); } Properties.Settings.Default.IssuedOn = this.dateTimePicker_IssuedOn.Value; }
/// <summary> /// 初始化数据 /// </summary> /// <param name="myClass_Template"></param> /// <param name="bool_Add"></param> public void InitControl(Class_ReviveQC myClass_ReviveQC, bool bool_Add) { Class_Public.InitializeComboBox(this.ComboBox_ExamStatus, Enum_DataTable.ExamStatus.ToString(), "ExamStatus", "ExamStatus"); Class_Public.InitializeComboBox(this.comboBox_Flaw, Enum_DataTableSecond.Flaw.ToString(), "Flaw", "Flaw"); this.ComboBox_ExamStatus.SelectedValue = "顺利考试"; this.comboBox_Flaw.SelectedValue = "-"; this.myClass_ReviveQC = myClass_ReviveQC; if (bool_Add) { this.button_StudentQuery.Visible = true; this.myClass_QC = new Class_QC(); if (myClass_ReviveQCDefault != null) { if (myClass_ReviveQCDefault.SkillTeacherID != null) { Class_CustomUser myClass_CustomUser = new Class_CustomUser(); myClass_CustomUser.UserGUID = myClass_ReviveQCDefault.SkillTeacherID; if (myClass_CustomUser.FillData()) { this.textBox_SkillTeacher.Text = string.Format("{0}:{1}", myClass_CustomUser.Name, myClass_CustomUser.UserGUID.ToString()); } } if (myClass_ReviveQCDefault.SkillExamDate > DateTime.MinValue) { this.dateTimePicker_SkillExamDate.Value = myClass_ReviveQCDefault.SkillExamDate; } } } else { this.button_StudentQuery.Visible = false; Class_Student myClass_Student = new Class_Student(this.myClass_ReviveQC.ExaminingNo); this.InitControlStudent(myClass_Student); this.textBox_ReviveQCID.Text = this.myClass_ReviveQC.ReviveQCID.ToString(); Class_CustomUser myClass_CustomUser = new Class_CustomUser(); myClass_CustomUser.UserGUID = this.myClass_ReviveQC.SkillTeacherID; if (myClass_CustomUser.FillData()) { this.textBox_SkillTeacher.Text = string.Format("{0}:{1}", myClass_CustomUser.Name, myClass_CustomUser.UserGUID.ToString()); } this.dateTimePicker_SkillExamDate.Value = this.myClass_ReviveQC.SkillExamDate; this.ComboBox_ExamStatus.SelectedValue = this.myClass_ReviveQC.ExamStatus; this.comboBox_Flaw.SelectedValue = this.myClass_ReviveQC.Flaw; this.textBox_ReviveQCRemark.Text = this.myClass_ReviveQC.ReviveQCRemark; this.CheckBox_isPassed.Checked = this.myClass_ReviveQC.isPassed; this.checkBox_FaceDT.Checked = this.myClass_ReviveQC.FaceDT; this.checkBox_RT.Checked = this.myClass_ReviveQC.RT; this.checkBox_BendDT.Checked = this.myClass_ReviveQC.BendDT; this.checkBox_DisjunctionDT.Checked = this.myClass_ReviveQC.DisjunctionDT; this.checkBox_MacroExamination.Checked = this.myClass_ReviveQC.MacroExamination; this.checkBox_Impact.Checked = this.myClass_ReviveQC.Impact; this.checkBox_OtherDT.Checked = this.myClass_ReviveQC.OtherDT; this.checkBox_UT.Checked = this.myClass_ReviveQC.UT; } }
public void InitControlStudent(Class_Student myClass_Student) { Class_Welder myClass_Welder = new Class_Welder(myClass_Student.IdentificationCard); this.TextBox_Welder.Text = string.Format("{0},{1},{2},{3}", myClass_Welder.WelderName, myClass_Welder.IdentificationCard, myClass_Welder.Sex, myClass_Welder.WelderEnglishName); Class_Employer myClass_Employer = new Class_Employer(myClass_Welder.myClass_BelongUnit.EmployerHPID); Class_Department myClass_Department = new Class_Department(myClass_Welder.myClass_BelongUnit.DepartmentHPID); Class_WorkPlace myClass_WorkPlace = new Class_WorkPlace(myClass_Welder.myClass_BelongUnit.WorkPlaceHPID); Class_LaborServiceTeam myClass_LaborServiceTeam = new Class_LaborServiceTeam(myClass_Welder.myClass_BelongUnit.LaborServiceTeamHPID); this.TextBox_Employer.Text = string.Format("{0}->{1}->{2},{3}", myClass_Employer.Employer, myClass_Department.Department, myClass_WorkPlace.WorkPlace, myClass_LaborServiceTeam.LaborServiceTeam); this.TextBox_WorkerID.Text = myClass_Welder.myClass_BelongUnit.WorkerID; this.TextBox_Schooling.Text = myClass_Welder.Schooling; this.textBox_WeldingBeginning.Text = myClass_Welder.WeldingBeginning.ToShortDateString(); Class_Issue myClass_Issue = new Class_Issue(myClass_Student.IssueNo); Class_WeldingSubject myClass_WeldingSubject = new Class_WeldingSubject(myClass_Student.SubjectID); this.textBox_ExaminingNo.Text = myClass_Student.ExaminingNo; this.textBox_IssueNo.Text = myClass_Student.IssueNo; this.textBox_TheoryResult.Text = string.Format("{0}/{1}", myClass_Student.TheoryResult, myClass_Student.TheoryMakeupResult); this.textBox_SkillResult.Text = string.Format("{0}/{1}", myClass_Student.SkillResult ? "√" : "×", myClass_Student.SkillMakeupResult ? "√" : "×"); this.textBox_WeldingProcess.Text = string.Format("{0}({1},{2},{3})", myClass_Issue.WeldingProcessAb, myClass_Student.myClass_WeldingParameter.Material, myClass_Student.myClass_WeldingParameter.WeldingConsumable, myClass_Student.myClass_WeldingParameter.Assemblage); this.TextBox_Subject.Text = string.Format("{0},{1},{2},{3},{4}({5})", myClass_WeldingSubject.Subject, myClass_WeldingSubject.WeldingClass, myClass_WeldingSubject.JointType, myClass_WeldingSubject.WorkPieceType, myClass_WeldingSubject.WeldingProject, myClass_WeldingSubject.SubjectID); this.TextBox_Thickness.Text = myClass_Student.myClass_WeldingParameter.Thickness.ToString(); this.TextBox_ExternalDiameter.Text = myClass_Student.myClass_WeldingParameter.ExternalDiameter.ToString(); this.TextBox_StudentRemark.Text = myClass_Student.StudentRemark; this.myClass_QC = new Class_QC(myClass_Student.ExaminingNo); this.textBox_CertificateNo.Text = myClass_QC.CertificateNo; this.textBox_IssuedOn.Text = myClass_QC.IssuedOn.ToShortDateString(); if ((int)this.NumericUpDown_OriginalPeriod.Minimum <= myClass_QC.OriginalPeriod && (int)this.NumericUpDown_OriginalPeriod.Maximum >= myClass_QC.OriginalPeriod) { this.NumericUpDown_OriginalPeriod.Value = myClass_QC.OriginalPeriod; } if ((int)this.numericUpDown_PeriodofProlongation.Minimum <= myClass_QC.PeriodofProlongation && (int)this.numericUpDown_PeriodofProlongation.Maximum >= myClass_QC.PeriodofProlongation) { this.numericUpDown_PeriodofProlongation.Value = myClass_QC.PeriodofProlongation; } if ((int)this.numericUpDown_SupervisionCycle.Minimum <= myClass_QC.SupervisionCycle && (int)this.numericUpDown_SupervisionCycle.Maximum >= myClass_QC.SupervisionCycle) { this.numericUpDown_SupervisionCycle.Value = myClass_QC.SupervisionCycle; } this.TextBox_QCRemark.Text = myClass_QC.QCRemark; this.checkBox_isQCValid.Checked = myClass_QC.isQCValid; this.checkBox_SupervisionFirst.Checked = myClass_QC.SupervisionFirst; this.checkBox_SupervisionSecond.Checked = myClass_QC.SupervisionSecond; this.checkBox_SupervisionThird.Checked = myClass_QC.SupervisionThird; this.checkBox_SupervisionFourth.Checked = myClass_QC.SupervisionFourth; this.checkBox_SupervisionFifth.Checked = myClass_QC.SupervisionFifth; this.checkBox_SupervisionSixth.Checked = myClass_QC.SupervisionSixth; this.checkBox_SupervisionSeventh.Checked = myClass_QC.SupervisionSeventh; this.checkBox_SupervisionEighth.Checked = myClass_QC.SupervisionEighth; }
private void toolStripMenuItem_RowSetQCValid_Click(object sender, EventArgs e) { Class_QC myClass_QC = new Class_QC(this.dataGridView_Data.CurrentRow.Cells["ExaminingNo"].Value.ToString()); Form_QC_Update myForm = new Form_QC_Update(); myForm.myClass_QC = myClass_QC; if (myForm.ShowDialog() == DialogResult.OK) { Publisher_Welder.OnEventName(this.myEventArgs_Welder); } }
private void Form_QC_Update_Load(object sender, EventArgs e) { if (this.bool_Add) { if (Class_QC.ExistAndCanDeleteAndDelete(myClass_QC.ExaminingNo, Enum_zwjKindofUpdate.Exist)) { MessageBox.Show("已存在证书,不能添加!"); this.DialogResult = DialogResult.Cancel; this.Close(); return; } else { Class_Student myClass_Student = new Class_Student(); myClass_Student.ExaminingNo = this.myClass_QC.ExaminingNo; if (myClass_Student.FillData()) { if (!myClass_Student.isPassed) { MessageBox.Show("该学员不合格!"); this.DialogResult = DialogResult.Cancel; this.Close(); return; } } else { MessageBox.Show("不存在该项,可能已删除!"); this.DialogResult = DialogResult.Cancel; this.Close(); return; } } } else { if (!Class_QC.ExistAndCanDeleteAndDelete(myClass_QC.ExaminingNo, 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_QCBase1.InitControl(this.myClass_QC, this.bool_Add); }
private void button_OnOK_Click(object sender, EventArgs e) { this.userControl_QCBase1.FillClass(); String str_ErrMessage; str_ErrMessage = this.myClass_QC.CheckField(); if (str_ErrMessage != null) { this.DialogResult = DialogResult.None; this.label_ErrMessage.Text = str_ErrMessage; return; } if (this.bool_Add) { if (Class_QC.ExistAndCanDeleteAndDelete(this.myClass_QC.ExaminingNo, Enum_zwjKindofUpdate.Exist)) { this.label_ErrMessage.Text = "证书已添加!"; this.DialogResult = DialogResult.None; return; } if ((!string.IsNullOrEmpty(this.myClass_QC.CertificateNo)) && Class_QC.ExistSecond(this.myClass_QC.CertificateNo, null, Enum_zwjKindofUpdate.Exist)) { this.label_ErrMessage.Text = "证号不能重复!"; this.DialogResult = DialogResult.None; return; } if (!this.myClass_QC.AddAndModify(Enum_zwjKindofUpdate.Add)) { this.label_ErrMessage.Text = "添加不成功,可能是证号重复!"; this.DialogResult = DialogResult.None; return; } } else { if (Class_QC.ExistSecond(this.myClass_QC.CertificateNo, this.myClass_QC.ExaminingNo, Enum_zwjKindofUpdate.Modify)) { this.DialogResult = DialogResult.None; this.label_ErrMessage.Text = "证号不能重复!"; return; } this.myClass_QC.AddAndModify(Enum_zwjKindofUpdate.Modify); } }
private void button_OnOK_Click(object sender, EventArgs e) { Class_Issue myClass_Issue = new Class_Issue(this.str_IssueNo); Class_ShipClassification myClass_ShipClassification = new Class_ShipClassification(myClass_Issue.ShipClassificationAb); Class_Ship myClass_Ship = new Class_Ship(); Class_TestCommittee myClass_TestCommittee = new Class_TestCommittee(); if (myClass_ShipClassification.ShipRestrict) { myClass_Ship = new Class_Ship(myClass_Issue.ShipboardNo); myClass_TestCommittee.TestCommitteeID = myClass_Ship.TestCommitteeID; } else { myClass_TestCommittee.TestCommitteeID = myClass_ShipClassification.TestCommitteeID; } myClass_TestCommittee.FillData(); Class_QC myClass_QC; DataView myDataView_Temp = new DataView(this.myDataTable_Modified); myDataView_Temp.Sort = "ExaminingNo"; foreach (DataRowView myDataRowView in myDataView_Temp) { myClass_QC = new Class_QC(); myClass_QC.ExaminingNo = myDataRowView["ExaminingNo"].ToString(); myClass_QC.IssuedOn = (DateTime)myDataRowView["IssuedOn"]; int.TryParse(myDataRowView["OriginalPeriod"].ToString(), out myClass_QC.OriginalPeriod); myClass_QC.PeriodofProlongation = 0; myClass_QC.QCSubjectID = myDataRowView["ExamSubjectID"].ToString(); myClass_QC.SupervisionPlace = myDataRowView["SupervisionPlace"].ToString(); myClass_QC.AddAndModify(Enum_zwjKindofUpdate.Add); } string str_RegistrationNoRange; str_RegistrationNoRange = string.Format("初始存档号码为:{0}\n下一个存档号码为:", myClass_TestCommittee.NextRegistrationNo); myClass_TestCommittee.FillData(); str_RegistrationNoRange += myClass_TestCommittee.NextRegistrationNo; MessageBox.Show(str_RegistrationNoRange); this.DialogResult = System.Windows.Forms.DialogResult.OK; this.Close(); }
private void button_OnOK_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(this.TextBox_SupervisionPlace.Text)) { MessageBox.Show("必须输入考察地点!"); this.DialogResult = DialogResult.None; return; } if (this.myDataTable_NotValid.Rows.Count > 0) { if (MessageBox.Show("有数据不能导入,是否只导入合格的数据?", "确认窗口", MessageBoxButtons.OKCancel) == DialogResult.OK) { } else { this.DialogResult = DialogResult.None; return; } } Class_QC myClass_QC; foreach (DataRow myDataRow in this.myDataTable.Rows) { myClass_QC = new Class_QC(); myClass_QC.ExaminingNo = myDataRow["WelderMarkNo"].ToString(); myClass_QC.CertificateNo = myDataRow["CerNo"].ToString(); myClass_QC.isQCValid = true; DateTime.TryParse(myDataRow["IssuedOn"].ToString(), out myClass_QC.IssuedOn); DateTime.TryParse(myDataRow["ValidDate"].ToString(), out myClass_QC.ValidUntil); if (myClass_QC.ValidUntil.Year - myClass_QC.IssuedOn.Year > 20) { myClass_QC.OriginalPeriod = 100; } else { myClass_QC.OriginalPeriod = myClass_QC.ValidUntil.Year - myClass_QC.IssuedOn.Year; } myClass_QC.SupervisionPlace = this.TextBox_SupervisionPlace.Text; myClass_QC.AddAndModify(Enum_zwjKindofUpdate.Add); } }
private void button_StudentQuery_Click(object sender, EventArgs e) { string str_ExaminingNo = ""; Form_InputBox myForm = new Form_InputBox(); myForm.str_DefaultResponse = this.textBox_ExaminingNo.Text; myForm.str_Prompt = "请输入考试编号:"; myForm.str_Title = "输入考试编号"; if (myForm.ShowDialog() == DialogResult.OK) { str_ExaminingNo = myForm.str_DefaultResponse; } else { return; } Class_QC myClass_QC = new Class_QC(); myClass_QC.ExaminingNo = str_ExaminingNo; if (myClass_QC.FillData()) { if (myClass_QC.ValidUntil > DateTime.Today) { Class_Student myClass_Student = new Class_Student(str_ExaminingNo); this.InitControlStudent(myClass_Student); } else { MessageBox.Show(string.Format("考试编号为“{0}”的焊工证书已过有效期,不能重新启用!", str_ExaminingNo)); } } else { MessageBox.Show(string.Format("没有找到考试编号为“{0}”焊工证书!", str_ExaminingNo)); } }
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_RowExportSupervisionExcel_Click(object sender, EventArgs e) { Class_QC.ExportSupervision(this.myDataView.ToTable()); }
private void InitDataGridView2015() { OpenFileDialog myForm = new OpenFileDialog(); myForm.Filter = "data files (*.data)|*.data|All files (*.*)|*.*"; myForm.RestoreDirectory = true; if (myForm.ShowDialog() != DialogResult.OK) { return; } DataTable myDataTable_Temp = new DataTable(); ADODB.Recordset rs = new ADODB.Recordset(); rs.Open(myForm.FileName, Type.Missing, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockReadOnly, 0); OleDbDataAdapter myAdapter = new OleDbDataAdapter(); myAdapter.Fill(myDataTable_Temp, rs); rs.Close(); this.myDataTable = myDataTable_Temp.Clone(); this.myDataTable_NotValid = myDataTable_Temp.Clone(); bool bool_Valid; foreach (DataRow myDataRow in myDataTable_Temp.Rows) { bool_Valid = true; if (string.IsNullOrEmpty(myDataRow["CerNo"].ToString())) { bool_Valid = false; } if (!Class_Student.ExistAndCanDeleteAndDelete(myDataRow["WelderMarkNo"].ToString(), Enum_zwjKindofUpdate.Exist)) { bool_Valid = false; } else { if (Class_QC.ExistAndCanDeleteAndDelete(myDataRow["WelderMarkNo"].ToString(), Enum_zwjKindofUpdate.Exist)) { bool_Valid = false; } else { if (Class_QC.ExistSecond(myDataRow["CerNo"].ToString(), null, Enum_zwjKindofUpdate.Add)) { bool_Valid = false; } else { } } } if (bool_Valid) { this.myDataTable.ImportRow(myDataRow); } else { this.myDataTable_NotValid.ImportRow(myDataRow); } } this.dataGridView_Data.DataSource = this.myDataTable; this.dataGridView_NotValid.DataSource = this.myDataTable_NotValid; this.label_Data.Text = string.Format("可以导入的数据,{0}", this.dataGridView_Data.RowCount); this.label_NotValid.Text = string.Format("不能导入的数据,{0}", this.dataGridView_NotValid.RowCount); }
private void InitDataGridView() { OpenFileDialog myForm = new OpenFileDialog(); myForm.Filter = "Access files (*.mdb)|*.mdb"; myForm.RestoreDirectory = true; if (myForm.ShowDialog() != DialogResult.OK) { return; } string str_Conn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + myForm.FileName + ";Persist Security Info=True"; string str_SQL; str_SQL = "Select * From TB_Certificate_Info"; DataTable myDataTable_Temp = new DataTable(); OleDbDataAdapter myAdapter = new OleDbDataAdapter(str_SQL, str_Conn); myAdapter.Fill(myDataTable_Temp); this.myDataTable = myDataTable_Temp.Clone(); this.myDataTable_NotValid = myDataTable_Temp.Clone(); bool bool_Valid; foreach (DataRow myDataRow in myDataTable_Temp.Rows) { bool_Valid = true; if (string.IsNullOrEmpty(myDataRow["CerNo"].ToString())) { bool_Valid = false; } if (!Class_Student.ExistAndCanDeleteAndDelete(myDataRow["WelderMarkNo"].ToString(), Enum_zwjKindofUpdate.Exist)) { bool_Valid = false; } else { if (Class_QC.ExistAndCanDeleteAndDelete(myDataRow["WelderMarkNo"].ToString(), Enum_zwjKindofUpdate.Exist)) { bool_Valid = false; } else { if (Class_QC.ExistSecond(myDataRow["CerNo"].ToString(), null, Enum_zwjKindofUpdate.Add)) { bool_Valid = false; } else { } } } if (bool_Valid) { this.myDataTable.ImportRow(myDataRow); } else { this.myDataTable_NotValid.ImportRow(myDataRow); } } this.dataGridView_Data.DataSource = this.myDataTable; this.dataGridView_NotValid.DataSource = this.myDataTable_NotValid; this.label_Data.Text = string.Format("可以导入的数据,{0}", this.dataGridView_Data.RowCount); this.label_NotValid.Text = string.Format("不能导入的数据,{0}", this.dataGridView_NotValid.RowCount); }
private void button_Modify_Click(object sender, EventArgs e) { if (this.myDataTable_Modified.Rows.Count > 0) { MessageBox.Show("请先重置后再进行填充操作!"); return; } if (string.IsNullOrEmpty(this.MaskedTextBox_NextCertificateNo.Text)) { MessageBox.Show("证号起始不能为空!"); return; } if (string.IsNullOrEmpty(this.TextBox_SupervisionPlace.Text)) { MessageBox.Show("考察地点不能为空!"); return; } Class_Issue myClass_Issue = new Class_Issue(this.str_IssueNo); Class_ShipClassification myClass_ShipClassification = new Class_ShipClassification(myClass_Issue.ShipClassificationAb); Class_Ship myClass_Ship = new Class_Ship(); if (myClass_ShipClassification.ShipRestrict) { myClass_Ship = new Class_Ship(myClass_Issue.ShipboardNo); } DataRow myDataRow; DataRow myNewRow; DataView myDataView_Temp = new DataView(this.myDataTable_Origin); myDataView_Temp.RowFilter = "Checked = true and ((TheoryResultNeed=true and (TheoryResult>=PassScore or TheoryMakeupResult>=PassScore)) or TheoryResultNeed=false) and ((SkillResultNeed=true and (SkillResult Or SkillMakeupResult)) or SkillResultNeed=false) And CertificateNo is Null"; myDataView_Temp.Sort = "ExaminingNo"; foreach (DataRowView myDataRowView in myDataView_Temp) { //if (Class_QC.ExistAndCanDeleteAndDelete (this.MaskedTextBox_NextCertificateNo.Text, Enum_zwjKindofUpdate.Exist)) //{ // MessageBox.Show("该证号已使用!"); // return; //} if (Class_QC.ExistSecond(this.MaskedTextBox_NextCertificateNo.Text, null, Enum_zwjKindofUpdate.Add)) { MessageBox.Show("该证号已使用!"); return; } myDataRow = myDataTable_Origin.Rows.Find(myDataRowView["ExaminingNo"].ToString()); this.myDataTable_Modified.ImportRow(myDataRow); myNewRow = myDataTable_Modified.Rows.Find(myDataRowView["ExaminingNo"].ToString()); myNewRow["CertificateNo"] = this.MaskedTextBox_NextCertificateNo.Text; myNewRow["SupervisionPlace"] = this.TextBox_SupervisionPlace.Text; myNewRow["OriginalPeriod"] = this.NumericUpDown_OriginalPeriod.Value; myNewRow["PeriodofValidity"] = this.NumericUpDown_OriginalPeriod.Value; myNewRow["IssuedOn"] = this.DateTimePicker_IssuedOn.Value; if (myClass_ShipClassification.ShipRestrict) { this.MaskedTextBox_NextCertificateNo.Text = Class_Tools.GetNextSequence(this.MaskedTextBox_NextCertificateNo.Text, myClass_Ship.CertificateNoSignificantDigit); } else { this.MaskedTextBox_NextCertificateNo.Text = Class_Tools.GetNextSequence(this.MaskedTextBox_NextCertificateNo.Text, myClass_ShipClassification.CertificateNoSignificantDigit); } } this.label_Modified.Text = string.Format("新证书:({0})", this.dataGridView_Modified.RowCount); MessageBox.Show("填充完毕!"); }
/// <summary> /// 初始化数据 /// </summary> /// <param name="myClass_QC"></param> /// <param name="bool_Add"></param> public void InitControl(Class_QC myClass_QC, bool bool_Add) { this.myClass_QC = myClass_QC; Class_Public.InitializeComboBox(this.ComboBox_Assemblage, Enum_DataTable.Assemblage.ToString(), "Assemblage", "Assemblage"); Class_Public.InitializeComboBox(this.ComboBox_KindofExam, Enum_DataTable.KindofExam.ToString(), "KindofExam", "KindofExam"); Class_Public.InitializeComboBox(this.ComboBox_WeldingProcess, Enum_DataTable.WeldingProcess.ToString(), "WeldingProcessAb", "WeldingProcess"); Class_Public.InitializeComboBox(this.ComboBox_ExamStatus, Enum_DataTable.ExamStatus.ToString(), "ExamStatus", "ExamStatus"); Class_Student myClass_Student = new Class_Student(myClass_QC.ExaminingNo); this.TextBox_IssueNo.Text = myClass_Student.IssueNo; this.TextBox_StudentRemark.Text = myClass_Student.StudentRemark; this.MaskedTextBox_ExaminingNo.Text = myClass_Student.ExaminingNo; this.ComboBox_ExamStatus.SelectedValue = myClass_Student.ExamStatus; this.NumericUpDown_TheoryResult.Value = myClass_Student.TheoryResult; this.NumericUpDown_TheoryMakeupResult.Value = myClass_Student.TheoryMakeupResult; this.CheckBox_SkillResult.Checked = myClass_Student.SkillResult; this.CheckBox_SkillMakeupResult.Checked = myClass_Student.SkillMakeupResult; Class_Issue myClass_Issue = new Class_Issue(myClass_Student.IssueNo); this.ComboBox_WeldingProcess.SelectedValue = myClass_Issue.WeldingProcessAb; this.InitControlWelder(new Class_Welder(myClass_Student.IdentificationCard)); this.InitControlWeldingParameter(myClass_Student.myClass_WeldingParameter); this.InitControlWeldingSubject(new Class_WeldingSubject(myClass_Student.SubjectID)); if (string.IsNullOrEmpty(this.myClass_QC.QCSubjectID)) { this.myClass_QC.QCSubjectID = myClass_Student.SubjectID; } if (bool_Add) { if (myClass_Issue.IssueIssuedOn != DateTime.MinValue) { this.dateTimePicker_IssuedOn.Value = myClass_Issue.IssueIssuedOn; } else if (Properties.Settings.Default.IssuedOn != DateTime.MinValue) { this.dateTimePicker_IssuedOn.Value = Properties.Settings.Default.IssuedOn; } string str_CertificateNo; Class_ShipClassification myClass_ShipClassification = new Class_ShipClassification(myClass_Issue.ShipClassificationAb); if (myClass_ShipClassification.ShipRestrict) { Class_Ship myClass_Ship = new Class_Ship(myClass_Issue.ShipboardNo); str_CertificateNo = myClass_Ship.NextCertificateNo; } else { str_CertificateNo = myClass_ShipClassification.NextCertificateNo; } this.Button_CertificateNoModify.Visible = false; this.MaskedTextBox_CertificateNo.ReadOnly = !string.IsNullOrEmpty(str_CertificateNo); this.MaskedTextBox_CertificateNo.Text = str_CertificateNo; if (myClass_QCDefault != null) { } } else { this.Button_CertificateNoModify.Visible = true; this.MaskedTextBox_CertificateNo.ReadOnly = true; this.MaskedTextBox_CertificateNo.Text = this.myClass_QC.CertificateNo; this.TextBox_SupervisionPlace.Text = this.myClass_QC.SupervisionPlace; this.dateTimePicker_IssuedOn.Value = this.myClass_QC.IssuedOn; if (this.myClass_QC.OriginalPeriod > 0) { this.NumericUpDown_OriginalPeriod.Value = this.myClass_QC.OriginalPeriod; } if ((int)this.numericUpDown_PeriodofProlongation.Minimum <= this.myClass_QC.PeriodofProlongation && (int)this.numericUpDown_PeriodofProlongation.Maximum >= this.myClass_QC.PeriodofProlongation) { this.numericUpDown_PeriodofProlongation.Value = this.myClass_QC.PeriodofProlongation; } this.TextBox_QCRemark.Text = this.myClass_QC.QCRemark; if ((int)this.numericUpDown_SupervisionCycle.Minimum <= this.myClass_QC.SupervisionCycle && (int)this.numericUpDown_SupervisionCycle.Maximum >= this.myClass_QC.SupervisionCycle) { this.numericUpDown_SupervisionCycle.Value = this.myClass_QC.SupervisionCycle; } this.checkBox_isQCValid.Checked = this.myClass_QC.isQCValid; this.checkBox_SupervisionFirst.Checked = this.myClass_QC.SupervisionFirst; this.checkBox_SupervisionSecond.Checked = this.myClass_QC.SupervisionSecond; this.checkBox_SupervisionThird.Checked = this.myClass_QC.SupervisionThird; this.checkBox_SupervisionFourth.Checked = this.myClass_QC.SupervisionFourth; this.checkBox_SupervisionFifth.Checked = this.myClass_QC.SupervisionFifth; this.checkBox_SupervisionSixth.Checked = this.myClass_QC.SupervisionSixth; this.checkBox_SupervisionSeventh.Checked = this.myClass_QC.SupervisionSeventh; this.checkBox_SupervisionEighth.Checked = this.myClass_QC.SupervisionEighth; } }