/// <summary> /// 初始化数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void InitDataGridView(object sender, EventArgs_Welder e) { this.myEventArgs_Welder = e; Class_DataControlBind.InitializeDataGridView(this.dataGridView_Data, Enum_DataTable.IssueStudentQCRegistrationNo.ToString(), false); Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.ExamAll.ToString()]; myClass_Data.SetFilter(string.Format("IdentificationCard='{0}'", this.myEventArgs_Welder.str_IdentificationCard)); this.dataGridView_Data.DataSource = null; myClass_Data.RefreshData(false); this.dataGridView_Data.DataSource = new DataView(myClass_Data.myDataTable.Copy()); if (string.IsNullOrEmpty(((DataView)this.dataGridView_Data.DataSource).Sort)) { ((DataView)this.dataGridView_Data.DataSource).Sort = myClass_Data.myDataView.Sort; } if (this.checkBox_QC.Checked) { ((DataView)this.dataGridView_Data.DataSource).RowFilter = string.Format("ValidUntil >= '{0}' And isQCValid=1", DateTime.Today.ToShortDateString()); } else { ((DataView)this.dataGridView_Data.DataSource).RowFilter = null; } this.label_Data.Text = string.Format("考试记录,({0}):", this.dataGridView_Data.RowCount); this.pictureBox_Welder.Image = Class_Welder.GetWelderPicture(this.myEventArgs_Welder.str_IdentificationCard); this.userControl_WelderTestCommitteeRegistrationNoBase1.InitDataGridView(this.myEventArgs_Welder.str_IdentificationCard); if (this.dataGridView_Data.RowCount == 0) { EventArgs_StudentSecond my_e = new EventArgs_StudentSecond(null); Publisher_StudentSecond.OnEventName(my_e); } }
private void toolStripMenuItem_RowExportExcelofWelderBelongQC_Click(object sender, EventArgs e) { Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.WelderBelongQC.ToString()]; myClass_Data.SetFilter(this.str_Filter); myClass_Data.RefreshData(false); DataGridView myDataGridView = this.dataGridView_ExportExcelTemp; Class_DataControlBind.InitializeDataGridView(myDataGridView, Enum_DataTable.WelderBelongExam.ToString(), false); myDataGridView.DataSource = myClass_Data.myDataView; Class_DataControlBind.DataGridViewExportExcel(myDataGridView, true, true); }
/// <summary> /// 初始化数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void InitDataGridView(object sender, EventArgs_StudentSecond e) { this.str_ExaminingNo = e.str_ExaminingNo; Class_DataControlBind.InitializeDataGridView(this.dataGridView_Data, Enum_DataTable.SubjectPositionResult.ToString(), false); Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.SubjectPositionResultSecond.ToString()]; myClass_Data.SetFilter(string.Format("ExaminingNo='{0}'", this.str_ExaminingNo)); this.dataGridView_Data.DataSource = null; myClass_Data.RefreshData(false); this.dataGridView_Data.DataSource = new DataView(myClass_Data.myDataTable.Copy()); ((DataView)this.dataGridView_Data.DataSource).Sort = myClass_Data.myDataView.Sort; this.label_Data.Text = string.Format("考试项目,({0}):", this.dataGridView_Data.RowCount); }
/// <summary> /// 初始化数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void InitDataGridView(object sender, EventArgs_DataManager e) { this.myEventArgs_DataManager = e; if (!this.checkBox_All.Checked && string.IsNullOrEmpty(this.myEventArgs_DataManager.str_Filter)) { this.myEventArgs_DataManager.str_Filter = "1=0"; } Class_DataControlBind.InitializeDataGridView(this.dataGridView_Data, this.myEventArgs_DataManager.str_DataManagerTag, false); Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[this.myEventArgs_DataManager.str_DataManagerName]; if (this.myEventArgs_DataManager.str_DataManagerName == Enum_DataTable.WelderIssueStudentQCRegistrationNo.ToString()) { int i_SupervisionOffset = Class_ExamField.SupervisionOffset + 1; if (string.IsNullOrEmpty(this.myEventArgs_DataManager.str_Filter)) { //e.str_Filter = string.Format("CertificateNo is Not Null And ValidUntil>'{0}' And isQCValid=1",DateTime.Today); e.str_Filter = string.Format("ValidUntil>'{0}' And isQCValid=1 and (", DateTime.Today); e.str_Filter += string.Format(" (SupervisionFirst=1 and (IssuedOnMonth - SupervisionCycle*48 - {0})/6=1) ", i_SupervisionOffset); e.str_Filter += string.Format(" or (SupervisionSecond=1 and (IssuedOnMonth - SupervisionCycle*48 - {0})/6=2) ", i_SupervisionOffset); e.str_Filter += string.Format(" or (SupervisionThird=1 and (IssuedOnMonth - SupervisionCycle*48 - {0})/6=3) ", i_SupervisionOffset); e.str_Filter += string.Format(" or (SupervisionFourth=1 and (IssuedOnMonth - SupervisionCycle*48 - {0})/6=4) ", i_SupervisionOffset); e.str_Filter += string.Format(" or (SupervisionFifth=1 and (IssuedOnMonth - SupervisionCycle*48 - {0})/6=5) ", i_SupervisionOffset); e.str_Filter += string.Format(" or (SupervisionSixth=1 and (IssuedOnMonth - SupervisionCycle*48 - {0})/6=6) ", i_SupervisionOffset); e.str_Filter += string.Format(" or (SupervisionSeventh=1 and (IssuedOnMonth - SupervisionCycle*48 - {0})/6=7) ", i_SupervisionOffset); e.str_Filter += string.Format(" or ((SupervisionSeventh=1 or SupervisionEighth=1) and (IssuedOnMonth - SupervisionCycle*48 - {0})/6=8) ", i_SupervisionOffset); e.str_Filter += string.Format(" or ((IssuedOnMonth - SupervisionCycle*48 - {0})/6=0) ", i_SupervisionOffset); e.str_Filter += ")"; } else { //e.str_Filter = string.Format("({0}) And CertificateNo is Not Null And ValidUntil>'{1}' And isQCValid=1", this.myEventArgs_DataManager.str_Filter, DateTime.Today); e.str_Filter = string.Format("({0}) And ValidUntil>'{1}' And isQCValid=1 and (", this.myEventArgs_DataManager.str_Filter, DateTime.Today); e.str_Filter += string.Format(" (SupervisionFirst=1 and (IssuedOnMonth - SupervisionCycle*48 - {0})/6=1) ", i_SupervisionOffset); e.str_Filter += string.Format(" or (SupervisionSecond=1 and (IssuedOnMonth - SupervisionCycle*48 - {0})/6=2) ", i_SupervisionOffset); e.str_Filter += string.Format(" or (SupervisionThird=1 and (IssuedOnMonth - SupervisionCycle*48 - {0})/6=3) ", i_SupervisionOffset); e.str_Filter += string.Format(" or (SupervisionFourth=1 and (IssuedOnMonth - SupervisionCycle*48 - {0})/6=4) ", i_SupervisionOffset); e.str_Filter += string.Format(" or (SupervisionFifth=1 and (IssuedOnMonth - SupervisionCycle*48 - {0})/6=5) ", i_SupervisionOffset); e.str_Filter += string.Format(" or (SupervisionSixth=1 and (IssuedOnMonth - SupervisionCycle*48 - {0})/6=6) ", i_SupervisionOffset); e.str_Filter += string.Format(" or (SupervisionSeventh=1 and (IssuedOnMonth - SupervisionCycle*48 - {0})/6=7) ", i_SupervisionOffset); e.str_Filter += string.Format(" or ((SupervisionSeventh=1 or SupervisionEighth=1) and (IssuedOnMonth - SupervisionCycle*48 - {0})/6=8) ", i_SupervisionOffset); e.str_Filter += string.Format(" or ((IssuedOnMonth - SupervisionCycle*48 - {0})/6=0) ", i_SupervisionOffset); e.str_Filter += ")"; } } myClass_Data.SetFilter(this.myEventArgs_DataManager.str_Filter); myClass_Data.RefreshData(false); this.dataGridView_Data.DataSource = new DataView(myClass_Data.myDataTable.Copy()); ((DataView)this.dataGridView_Data.DataSource).Sort = myClass_Data.myDataView.Sort; this.label_Data.Text = string.Format("{0},({1}):", this.myEventArgs_DataManager.str_DataManagerText, this.dataGridView_Data.RowCount); }
/// <summary> /// 初始化数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void InitDataGridView(object sender, EventArgs_KindofEmployer e) { Class_DataControlBind.InitializeDataGridView(this.dataGridView_Exam, Enum_DataTable.IssueStudentQCRegistrationNo.ToString(), false); this.myEventArgs_KindofEmployer = e; Class_DataControlBind.InitializeDataGridView(this.dataGridView_Data, Enum_DataTable.KindofEmployerWelder.ToString(), false); Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.KindofEmployerWelder.ToString()]; myClass_Data.SetFilter(string.Format("KindofEmployer='{0}'", this.myEventArgs_KindofEmployer.str_KindofEmployer)); if (this.myEventArgs_KindofEmployer.bool_JustFill) { if (this.myDataTable.Rows.Count == 0) { this.dataGridView_Data.DataSource = null; myClass_Data.RefreshData(this.myEventArgs_KindofEmployer.bool_JustFill); this.myDataTable = myClass_Data.myDataTable.Copy(); this.myDataView = new DataView(this.myDataTable); this.dataGridView_Data.DataSource = this.myDataView; } else { myClass_Data.RefreshData(this.myEventArgs_KindofEmployer.bool_JustFill, this.myDataTable); } } else { this.dataGridView_Data.DataSource = null; myClass_Data.RefreshData(this.myEventArgs_KindofEmployer.bool_JustFill); this.myDataTable = myClass_Data.myDataTable.Copy(); this.myDataView = new DataView(this.myDataTable); this.dataGridView_Data.DataSource = this.myDataView; } if (string.IsNullOrEmpty(((DataView)this.dataGridView_Data.DataSource).Sort)) { ((DataView)this.dataGridView_Data.DataSource).Sort = myClass_Data.myDataView.Sort; } this.label_Data.Text = string.Format("报考单位焊工信息,({0}):", this.dataGridView_Data.RowCount); if (this.dataGridView_Data.CurrentRow == null) { this.dataGridView_Exam.DataSource = null; this.label_Exam.Text = "考试记录:"; this.userControl_WelderPictureBase1.InitWelderPicture(null); } Class_KindofEmployer myClass_KindofEmployer = new Class_KindofEmployer(e.str_KindofEmployer); this.userControl_WelderPictureBase1.button_UploadPicture.Visible = myClass_KindofEmployer.CanUpLoadWelderPicture; this.userControl_WelderPictureBase1.button_DeletePicture.Visible = myClass_KindofEmployer.CanDeleteWelderPicture; this.userControl_WelderPictureBase1.bool_CanModifyWelderPicture = myClass_KindofEmployer.CanModifyWelderPicture; }
/// <summary> /// 初始化数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void InitDataGridView(object sender, EventArgs_Welder e) { this.myEventArgs_Welder = e; Class_DataControlBind.InitializeDataGridView(this.dataGridView_Data, Enum_DataTable.BlackList.ToString(), false); Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.BlackList.ToString()]; myClass_Data.SetFilter(string.Format("IdentificationCard = '{0}'", this.myEventArgs_Welder.str_IdentificationCard)); this.dataGridView_Data.DataSource = null; myClass_Data.RefreshData(false); this.dataGridView_Data.DataSource = new DataView(myClass_Data.myDataTable.Copy()); if (string.IsNullOrEmpty(((DataView)this.dataGridView_Data.DataSource).Sort)) { ((DataView)this.dataGridView_Data.DataSource).Sort = myClass_Data.myDataView.Sort; } this.label_Data.Text = string.Format("黑名单记录,({0}):", this.dataGridView_Data.RowCount); }
private void toolStripMenuItem_RowExportReport_Click(object sender, EventArgs e) { Form_ReportSelect myForm = new Form_ReportSelect(); myForm.myClass_Report = new Class_Report(); myForm.myClass_Report.ReportGroup = "在册焊工持证信息"; if (myForm.ShowDialog() == DialogResult.OK) { Form_CrystalReport myForm_Report = new Form_CrystalReport(); string str_FileName = string.Format("{0}\\CrystalReports\\{1}", System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location), myForm.myClass_Report.ReportLocation); Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.WelderBelongQC.ToString()]; myClass_Data.SetFilter(this.str_Filter); myClass_Data.RefreshData(false); myForm_Report.InitCrystalReport(str_FileName, null, null, myClass_Data.myDataView, null); myForm_Report.ShowDialog(); } }
private void toolStripMenuItem_RowViewExam_Click(object sender, EventArgs e) { StringBuilder str_Filter = new StringBuilder(); str_Filter.Append("1=0"); foreach (DataGridViewRow myDataGridViewRow in this.dataGridView_Data.Rows) { str_Filter.Append(string.Format(" Or IdentificationCard='{0}'", myDataGridViewRow.Cells["IdentificationCard"].Value)); } Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.ExamAll.ToString()]; myClass_Data.SetFilter(str_Filter.ToString()); myClass_Data.RefreshData(false); ZCCL.Tools.Form_DataView myForm = new ZCCL.Tools.Form_DataView(); myForm.InitDataGridView("考试记录", new DataView(myClass_Data.myDataTable.Copy()), Enum_DataTable.WelderIssueStudentQCRegistrationNo.ToString()); myForm.ShowDialog(); }
/// <summary> /// 初始化数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void InitDataGridView(object sender, EventArgs_KindofEmployer e) { this.myEventArgs_KindofEmployer = e; Class_DataControlBind.InitializeDataGridView(this.dataGridView_Data, Enum_DataTable.KindofEmployerIssue.ToString(), false); Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.KindofEmployerIssue.ToString()]; myClass_Data.SetFilter(string.Format("KindofEmployer='{0}'", this.myEventArgs_KindofEmployer.str_KindofEmployer)); if (this.myEventArgs_KindofEmployer.bool_JustFill) { if (this.myDataTable.Rows.Count == 0) { this.dataGridView_Data.DataSource = null; myClass_Data.RefreshData(this.myEventArgs_KindofEmployer.bool_JustFill); this.myDataTable = myClass_Data.myDataTable.Copy(); this.myDataView = new DataView(this.myDataTable); this.dataGridView_Data.DataSource = this.myDataView; } else { myClass_Data.RefreshData(this.myEventArgs_KindofEmployer.bool_JustFill, this.myDataTable); } } else { this.dataGridView_Data.DataSource = null; myClass_Data.RefreshData(this.myEventArgs_KindofEmployer.bool_JustFill); this.myDataTable = myClass_Data.myDataTable.Copy(); this.myDataView = new DataView(this.myDataTable); this.dataGridView_Data.DataSource = this.myDataView; } if (string.IsNullOrEmpty(((DataView)this.dataGridView_Data.DataSource).Sort)) { ((DataView)this.dataGridView_Data.DataSource).Sort = myClass_Data.myDataView.Sort; } this.label_Data.Text = string.Format("报考单位班级信息,({0}):", this.dataGridView_Data.RowCount); if (this.dataGridView_Data.Rows.Count == 0) { EventArgs_KindofEmployerIssue myEventArgs_KindofEmployerIssue = new EventArgs_KindofEmployerIssue(); myEventArgs_KindofEmployerIssue.int_KindofEmployerIssueID = 0; Publisher_KindofEmployerIssue.OnEventName(myEventArgs_KindofEmployerIssue); } }
/// <summary> /// 初始化数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void InitDataGridView(object sender, EventArgs_KindofEmployerIssue e) { this.myEventArgs_KindofEmployerIssue = e; Class_DataControlBind.InitializeDataGridView(this.dataGridView_Data, Enum_DataTable.KindofEmployerStudent.ToString(), false); Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.KindofEmployerStudent.ToString()]; myClass_Data.SetFilter(string.Format("KindofEmployerIssueID={0}", this.myEventArgs_KindofEmployerIssue.int_KindofEmployerIssueID)); if (this.myEventArgs_KindofEmployerIssue.bool_JustFill) { if (this.myDataTable.Rows.Count == 0) { this.dataGridView_Data.DataSource = null; myClass_Data.RefreshData(this.myEventArgs_KindofEmployerIssue.bool_JustFill); this.myDataTable = myClass_Data.myDataTable.Copy(); this.myDataView = new DataView(this.myDataTable); this.dataGridView_Data.DataSource = this.myDataView; } else { myClass_Data.RefreshData(this.myEventArgs_KindofEmployerIssue.bool_JustFill, this.myDataTable); } } else { this.dataGridView_Data.DataSource = null; myClass_Data.RefreshData(this.myEventArgs_KindofEmployerIssue.bool_JustFill); this.myDataTable = myClass_Data.myDataTable.Copy(); this.myDataView = new DataView(this.myDataTable); this.dataGridView_Data.DataSource = this.myDataView; } if (string.IsNullOrEmpty(((DataView)this.dataGridView_Data.DataSource).Sort)) { ((DataView)this.dataGridView_Data.DataSource).Sort = myClass_Data.myDataView.Sort; } this.label_Data.Text = string.Format("班级编号为 {0} 的学员信息,({1}):", this.myEventArgs_KindofEmployerIssue.int_KindofEmployerIssueID, this.dataGridView_Data.RowCount); if (this.dataGridView_Data.RowCount == 0) { this.userControl_WelderExamBase1.InitDataGridView(null); } }
private void Form_Issue_Query_Load(object sender, EventArgs e) { Class_Public.InitializeComboBox(this.comboBox_KindofEmployer, Enum_DataTable.KindofEmployer.ToString(), "KindofEmployer", "KindofEmployer"); Class_Public.InitializeComboBox(this.comboBox_ShipClassificationAb, Enum_DataTable.ShipClassification.ToString(), "ShipClassificationAb", "ShipClassificationAb"); Class_Public.InitializeComboBox(this.comboBox_ShipboardNo, Enum_DataTable.Ship.ToString(), "ShipboardNo", "ShipboardNo"); this.comboBox_KindofEmployer.Text = ""; this.comboBox_ShipboardNo.Text = ""; this.comboBox_ShipClassificationAb.Text = ""; Class_DataControlBind.InitializeDataGridView(this.dataGridView_Query, Enum_DataTable.Issue.ToString(), false); Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.Issue.ToString()]; myClass_Data.SetFilter("1=1"); myClass_Data.RefreshData(false); this.dataGridView_Query.DataSource = new DataView(myClass_Data.myDataTable.Copy()); ((DataView)this.dataGridView_Query.DataSource).Sort = myClass_Data.myDataView.Sort; if (this.myClass_Issue.IssueNo != null) { Class_DataControlBind.SetDataGridViewSelectedPosition("IssueNo", this.myClass_Issue.IssueNo, this.dataGridView_Query); } }
private void InitDataGridView(object sender, EventArgs_WPS e) { Class_DataControlBind.InitializeDataGridView(this.dataGridView_WPSImage, Enum_DataTableSecond.WPSImage.ToString(), false); this.pictureBox_WPSImage.Image = null; this.myEventArgs_WPS = e; Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTableSecond.WPSImage.ToString()]; myClass_Data.SetFilter(string.Format("WPSID='{0}'", this.myEventArgs_WPS.str_WPSID)); if (this.myEventArgs_WPS.bool_JustFill) { if (this.myDataTable.Rows.Count == 0) { this.dataGridView_WPSImage.DataSource = null; myClass_Data.RefreshData(this.myEventArgs_WPS.bool_JustFill); this.myDataTable = myClass_Data.myDataTable.Copy(); this.myDataView = new DataView(this.myDataTable); this.dataGridView_WPSImage.DataSource = this.myDataView; } else { myClass_Data.RefreshData(this.myEventArgs_WPS.bool_JustFill, this.myDataTable); } } else { this.dataGridView_WPSImage.DataSource = null; myClass_Data.RefreshData(this.myEventArgs_WPS.bool_JustFill); this.myDataTable = myClass_Data.myDataTable.Copy(); this.myDataView = new DataView(this.myDataTable); this.dataGridView_WPSImage.DataSource = this.myDataView; } if (string.IsNullOrEmpty(((DataView)this.dataGridView_WPSImage.DataSource).Sort)) { ((DataView)this.dataGridView_WPSImage.DataSource).Sort = myClass_Data.myDataView.Sort; } this.label_WPSImage.Text = string.Format("附加图片({0}):", this.dataGridView_WPSImage.RowCount); }
/// <summary> /// 初始化数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void InitDataGridView(object sender, EventArgs_KindofEmployer e) { this.myEventArgs_KindofEmployer = e; Class_DataControlBind.InitializeDataGridView(this.dataGridView_Data, Enum_DataTable.KindofEmployerExam.ToString(), false); Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.KindofEmployerExam.ToString()]; if (this.myDataTable == null) { myClass_Data.SetFilter("1=1"); this.dataGridView_Data.DataSource = null; myClass_Data.RefreshData(this.myEventArgs_KindofEmployer.bool_JustFill); this.myDataTable = myClass_Data.myDataTable.Copy(); this.myDataView = new DataView(this.myDataTable); this.dataGridView_Data.DataSource = this.myDataView; } ((DataView)this.dataGridView_Data.DataSource).RowFilter = string.Format("KindofEmployer='{0}'", this.myEventArgs_KindofEmployer.str_KindofEmployer);; if (string.IsNullOrEmpty(((DataView)this.dataGridView_Data.DataSource).Sort)) { ((DataView)this.dataGridView_Data.DataSource).Sort = myClass_Data.myDataView.Sort; } this.label_Data.Text = string.Format("考试记录,({0}):", this.dataGridView_Data.RowCount); }
public void InitDataGridView(string str_IdentificationCard) { this.str_IdentificationCard = str_IdentificationCard; Class_DataControlBind.InitializeDataGridView(this.dataGridView_Data, Enum_DataTable.IssueStudentQCRegistrationNo.ToString(), false); Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.ExamAll.ToString()]; myClass_Data.SetFilter(string.Format("IdentificationCard='{0}'", this.str_IdentificationCard)); this.dataGridView_Data.DataSource = null; myClass_Data.RefreshData(false); this.dataGridView_Data.DataSource = new DataView(myClass_Data.myDataTable.Copy()); if (string.IsNullOrEmpty(((DataView)this.dataGridView_Data.DataSource).Sort)) { ((DataView)this.dataGridView_Data.DataSource).Sort = myClass_Data.myDataView.Sort; } if (this.checkBox_QC.Checked) { ((DataView)this.dataGridView_Data.DataSource).RowFilter = string.Format("ValidUntil >= '{0}' And isQCValid=1", DateTime.Today.ToShortDateString()); } else { ((DataView)this.dataGridView_Data.DataSource).RowFilter = null; } this.label_Data.Text = string.Format("考试记录,({0}):", this.dataGridView_Data.RowCount); }
private void dataGridView_Data_RowEnter(object sender, DataGridViewCellEventArgs e) { string str_IdentificationCard = this.dataGridView_Data.Rows[e.RowIndex].Cells["IdentificationCard"].Value.ToString(); Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.ExamAll.ToString()]; myClass_Data.SetFilter(string.Format("IdentificationCard='{0}'", str_IdentificationCard)); this.dataGridView_Exam.DataSource = null; myClass_Data.RefreshData(false); this.dataGridView_Exam.DataSource = new DataView(myClass_Data.myDataTable.Copy()); if (string.IsNullOrEmpty(((DataView)this.dataGridView_Exam.DataSource).Sort)) { ((DataView)this.dataGridView_Exam.DataSource).Sort = myClass_Data.myDataView.Sort; } if (this.checkBox_QC.Checked) { ((DataView)this.dataGridView_Exam.DataSource).RowFilter = string.Format("ValidUntil >= '{0}' And isQCValid = 1", DateTime.Today.ToShortDateString()); } else { ((DataView)this.dataGridView_Exam.DataSource).RowFilter = null; } this.label_Exam.Text = string.Format("身份证号码为 {0} 的考试记录,({1}):", str_IdentificationCard, this.dataGridView_Exam.RowCount); this.userControl_WelderPictureBase1.InitWelderPicture(str_IdentificationCard); }
private void InitDataGridView() { string str_Unit; string str_WelderBelongFilter; Class_Employer myClass_Employer; Class_Department myClass_Department; Class_WorkPlace myClass_WorkPlace; switch (this.myClass_KindofEmployer.KindofEmployerLevel) { case 1: myClass_Employer = new Class_Employer(this.myClass_KindofEmployer.KindofEmployerEmployerHPID); str_Unit = myClass_Employer.Employer; str_WelderBelongFilter = string.Format("WelderBelongEmployerHPID='{0}'", myClass_Employer.EmployerHPID); break; case 2: myClass_Department = new Class_Department(this.myClass_KindofEmployer.KindofEmployerDepartmentHPID); myClass_Employer = new Class_Employer(myClass_Department.EmployerHPID); str_Unit = string.Format("{0} , {1}", myClass_Employer.Employer, myClass_Department.Department); str_WelderBelongFilter = string.Format("WelderBelongDepartmentHPID='{0}'", myClass_Department.DepartmentHPID); break; case 3: myClass_WorkPlace = new Class_WorkPlace(this.myClass_KindofEmployer.KindofEmployerWorkPlaceHPID); myClass_Department = new Class_Department(myClass_WorkPlace.DepartmentHPID); myClass_Employer = new Class_Employer(myClass_Department.EmployerHPID); str_Unit = string.Format("{0} , {1} , {2}", myClass_Employer.Employer, myClass_Department.Department, myClass_WorkPlace.WorkPlace); str_WelderBelongFilter = string.Format("WelderBelongWorkPlaceHPID='{0}'", myClass_WorkPlace.WorkPlaceHPID); break; default: return; } Class_DataControlBind.InitializeDataGridView(this.dataGridView_WelderBelong, Enum_DataTable.WelderBelong.ToString(), false); Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.WelderBelong.ToString()]; myClass_Data.SetFilter(str_WelderBelongFilter); myClass_Data.RefreshData(false); this.myDataTable_WelderBelong = myClass_Data.myDataTable.Copy(); this.dataGridView_WelderBelong.DataSource = new DataView(this.myDataTable_WelderBelong); ((DataView)this.dataGridView_WelderBelong.DataSource).Sort = myClass_Data.myDataView.Sort; this.label_WelderBelong.Text = string.Format("本系统: {0},({1})", str_Unit, this.dataGridView_WelderBelong.RowCount); Class_DataControlBind.InitializeDataGridView(this.dataGridView_KindofEmployerWelder, Enum_DataTable.KindofEmployerWelder.ToString(), false); myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.KindofEmployerWelder.ToString()]; myClass_Data.SetFilter(string.Format("KindofEmployer='{0}'", this.myClass_KindofEmployer.KindofEmployer)); myClass_Data.RefreshData(false); this.myDataTable_KindofEmployerWelder = myClass_Data.myDataTable.Copy(); this.dataGridView_KindofEmployerWelder.DataSource = new DataView(this.myDataTable_KindofEmployerWelder); ((DataView)this.dataGridView_KindofEmployerWelder.DataSource).Sort = myClass_Data.myDataView.Sort; this.label_KindofEmployerWelder.Text = string.Format("报考单位: {0},({1})", this.myClass_KindofEmployer.KindofEmployer, this.dataGridView_KindofEmployerWelder.RowCount); if (this.comboBox_KindofSynchronization.SelectedIndex == 0) { this.label_KindofSynchronization.Text = string.Format("同步数据类型:{0} -> {1}", this.myClass_KindofEmployer.KindofEmployer, str_Unit); Class_DataControlBind.InitializeDataGridView(this.dataGridView_Add, Enum_DataTable.KindofEmployerWelder.ToString(), false); Class_DataControlBind.InitializeDataGridView(this.dataGridView_Modify, Enum_DataTable.KindofEmployerWelder.ToString(), false); Class_DataControlBind.InitializeDataGridView(this.dataGridView_Delete, Enum_DataTable.WelderBelong.ToString(), false); this.myDataTable_Add = myClass_KindofEmployer.GetDataTable_Synchronization(Enum_zwjKindofUpdate.Add, true, false); this.myDataTable_Modify = myClass_KindofEmployer.GetDataTable_Synchronization(Enum_zwjKindofUpdate.Modify, true, false); this.myDataTable_Delete = myClass_KindofEmployer.GetDataTable_Synchronization(Enum_zwjKindofUpdate.Delete, true, false); } else { this.label_KindofSynchronization.Text = string.Format("同步数据类型:{1} -> {0}", this.myClass_KindofEmployer.KindofEmployer, str_Unit); Class_DataControlBind.InitializeDataGridView(this.dataGridView_Add, Enum_DataTable.WelderBelong.ToString(), false); Class_DataControlBind.InitializeDataGridView(this.dataGridView_Modify, Enum_DataTable.WelderBelong.ToString(), false); Class_DataControlBind.InitializeDataGridView(this.dataGridView_Delete, Enum_DataTable.KindofEmployerWelder.ToString(), false); this.myDataTable_Add = myClass_KindofEmployer.GetDataTable_Synchronization(Enum_zwjKindofUpdate.Add, false, false); this.myDataTable_Modify = myClass_KindofEmployer.GetDataTable_Synchronization(Enum_zwjKindofUpdate.Modify, false, false); this.myDataTable_Delete = myClass_KindofEmployer.GetDataTable_Synchronization(Enum_zwjKindofUpdate.Delete, false, false); } this.dataGridView_Add.DataSource = new DataView(this.myDataTable_Add); this.label_Add.Text = string.Format("添加后的数据,({0}):", this.dataGridView_Add.RowCount); this.dataGridView_Modify.DataSource = new DataView(this.myDataTable_Modify); this.label_Modify.Text = string.Format("修改后的数据,({0}):", this.dataGridView_Modify.RowCount); this.dataGridView_Delete.DataSource = new DataView(this.myDataTable_Delete); this.label_Delete.Text = string.Format("删除前的数据,({0}):", this.dataGridView_Delete.RowCount); }
/// <summary> /// 初始化数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void InitDataGridView(object sender, EventArgs_Unit e) { this.str_Filter = null; this.myEventArgs_Unit = e; Class_DataControlBind.InitializeDataGridView(this.dataGridView_Data, Enum_DataTable.WelderBelong.ToString(), false); Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.WelderBelong.ToString()]; if (string.IsNullOrEmpty(this.myEventArgs_Unit.WorkPlaceHPID)) { if (string.IsNullOrEmpty(this.myEventArgs_Unit.DepartmentHPID)) { if (string.IsNullOrEmpty(this.myEventArgs_Unit.EmployerHPID)) { if (string.IsNullOrEmpty(this.myEventArgs_Unit.EmployerGroup)) { str_Filter = string.Format("1=1"); } else { str_Filter = string.Format("WelderBelongEmployerGroup='{0}'", this.myEventArgs_Unit.EmployerGroup); } } else { str_Filter = string.Format("WelderBelongEmployerHPID='{0}'", this.myEventArgs_Unit.EmployerHPID); } } else { str_Filter = string.Format("WelderBelongDepartmentHPID='{0}'", this.myEventArgs_Unit.DepartmentHPID); } } else { str_Filter = string.Format("WelderBelongWorkPlaceHPID='{0}'", this.myEventArgs_Unit.WorkPlaceHPID); } if (bool_Refresh) { myClass_Data.SetFilter(str_Filter); if (this.myEventArgs_Unit.bool_JustFill) { if (this.myDataTable.Rows.Count == 0) { this.dataGridView_Data.DataSource = null; myClass_Data.RefreshData(this.myEventArgs_Unit.bool_JustFill); this.myDataTable = myClass_Data.myDataTable.Copy(); this.myDataView = new DataView(this.myDataTable); this.dataGridView_Data.DataSource = this.myDataView; } else { myClass_Data.RefreshData(this.myEventArgs_Unit.bool_JustFill, this.myDataTable); } } else { this.dataGridView_Data.DataSource = null; myClass_Data.RefreshData(this.myEventArgs_Unit.bool_JustFill); this.myDataTable = myClass_Data.myDataTable.Copy(); this.myDataView = new DataView(this.myDataTable); this.dataGridView_Data.DataSource = this.myDataView; } } else { if (this.myDataTable == null) { myClass_Data.SetFilter("1=1"); this.dataGridView_Data.DataSource = null; myClass_Data.RefreshData(this.myEventArgs_Unit.bool_JustFill); this.myDataTable = myClass_Data.myDataTable.Copy(); this.myDataView = new DataView(this.myDataTable); this.dataGridView_Data.DataSource = this.myDataView; } else { } ((DataView)this.dataGridView_Data.DataSource).RowFilter = str_Filter; } if (string.IsNullOrEmpty(((DataView)this.dataGridView_Data.DataSource).Sort)) { ((DataView)this.dataGridView_Data.DataSource).Sort = myClass_Data.myDataView.Sort; } this.label_Data.Text = string.Format("焊工信息,({0}):", this.dataGridView_Data.RowCount); if (this.dataGridView_Data.RowCount == 0) { EventArgs_WelderBelong my_e = new EventArgs_WelderBelong(""); Publisher_WelderBelong.OnEventName(my_e); } }
/// <summary> /// 初始化数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void InitDataGridView(object sender, EventArgs_Unit e) { if (e == null) { return; } this.myEventArgs_Unit = e; Class_DataControlBind.InitializeDataGridView(this.dataGridView_Data, Enum_DataTable.WelderBelongExam.ToString(), false); Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.WelderBelongQC.ToString()]; string str_Filter; string str_FilterShipClassification; if (string.IsNullOrEmpty(this.myEventArgs_Unit.WorkPlaceHPID)) { if (string.IsNullOrEmpty(this.myEventArgs_Unit.DepartmentHPID)) { if (string.IsNullOrEmpty(this.myEventArgs_Unit.EmployerHPID)) { if (string.IsNullOrEmpty(this.myEventArgs_Unit.EmployerGroup)) { str_Filter = string.Format("1=1"); } else { str_Filter = string.Format("WelderBelongEmployerGroup='{0}'", this.myEventArgs_Unit.EmployerGroup); } } else { str_Filter = string.Format("WelderBelongEmployerHPID='{0}'", this.myEventArgs_Unit.EmployerHPID); } } else { str_Filter = string.Format("WelderBelongDepartmentHPID='{0}'", this.myEventArgs_Unit.DepartmentHPID); } } else { str_Filter = string.Format("WelderBelongWorkPlaceHPID='{0}'", this.myEventArgs_Unit.WorkPlaceHPID); } //str_Filter += string .Format (" And isQCValid =1");//已在数据库视图中设置 if (string.IsNullOrEmpty(this.str_ShipClassificationAb)) { str_FilterShipClassification = "1=1"; } else { str_FilterShipClassification = string.Format("ShipClassificationAb = '{0}'", this.str_ShipClassificationAb); if (string.IsNullOrEmpty(this.str_ShipboardNo)) { } else { str_FilterShipClassification += string.Format(" And ShipboardNo = '{0}'", this.str_ShipboardNo); } } DateTime myDataTime_Begin; switch (this.str_KindofQC) { case "全部证书": str_FilterShipClassification += string.Format(" And isQCValid=1 And ValidUntil>=#{0}#", DateTime.Now); break; case "签证证书": string str_FilterSupervision; str_FilterSupervision = string.Format("(IssuedOnMonth - SupervisionCycle*48 - {0})%6=0 and (IssuedOnMonth - {0}>0) And (not (ProlongQCContinuous=0 and PeriodofProlongation>0 and ValidUntil<#{1}#))", Class_ExamField.SupervisionOffset, DateTime.Today.AddMonths(3)); str_FilterShipClassification += string.Format(" And isQCValid=1 And ValidUntil>=#{0}# And ({1})", DateTime.Now.Date.AddDays(0 - DateTime.Now.Day).AddMonths(0 - Class_ExamField.SupervisionOffset), str_FilterSupervision); break; case "延期证书": myDataTime_Begin = DateTime.Now.Date.AddDays(1 - DateTime.Now.Day).AddMonths(0 - Class_ExamField.SupervisionOffset); str_FilterShipClassification += string.Format(" And isQCValid=1 And (ProlongQCContinuous=1 or (ProlongQCContinuous=0 and PeriodofProlongation=0)) And ValidUntil>=#{0}# And ValidUntil<#{1}#", myDataTime_Begin.AddDays(-1), myDataTime_Begin.AddMonths(1).AddDays(-1)); break; case "复训证书": myDataTime_Begin = DateTime.Now.Date.AddDays(1 - DateTime.Now.Day).AddMonths(0 - Class_ExamField.QCRegain); str_FilterShipClassification += string.Format(" And isQCValid=1 And ProlongQCContinuous=0 and PeriodofProlongation>0 And ValidUntil>=#{0}# And ValidUntil<#{1}#", myDataTime_Begin, myDataTime_Begin.AddMonths(1)); break; case "失效证书": str_FilterShipClassification += string.Format(" And ((ValidUntil>=#{0}# And ValidUntil<#{1}#) Or (isQCValid = 0 and ValidUntil>#{1}#))", DateTime.Now.AddMonths(-12), DateTime.Now); break; } str_Filter = string.Format("({0}) And ({1})", str_Filter, str_FilterShipClassification); if (bool_Refresh) { myClass_Data.SetFilter(str_Filter); if (this.myEventArgs_Unit.bool_JustFill) { if (this.myDataTable.Rows.Count == 0) { this.dataGridView_Data.DataSource = null; myClass_Data.RefreshData(this.myEventArgs_Unit.bool_JustFill); this.myDataTable = myClass_Data.myDataTable.Copy(); this.myDataView = new DataView(this.myDataTable); this.dataGridView_Data.DataSource = this.myDataView; } else { myClass_Data.RefreshData(this.myEventArgs_Unit.bool_JustFill, this.myDataTable); } } else { this.dataGridView_Data.DataSource = null; myClass_Data.RefreshData(this.myEventArgs_Unit.bool_JustFill); this.myDataTable = myClass_Data.myDataTable.Copy(); this.myDataView = new DataView(this.myDataTable); this.dataGridView_Data.DataSource = this.myDataView; } } else { if (this.myDataTable == null) { myClass_Data.SetFilter("1=1"); this.dataGridView_Data.DataSource = null; myClass_Data.RefreshData(this.myEventArgs_Unit.bool_JustFill); this.myDataTable = myClass_Data.myDataTable.Copy(); this.myDataView = new DataView(this.myDataTable); this.dataGridView_Data.DataSource = this.myDataView; } ((DataView)this.dataGridView_Data.DataSource).RowFilter = str_Filter; } if (string.IsNullOrEmpty(((DataView)this.dataGridView_Data.DataSource).Sort)) { ((DataView)this.dataGridView_Data.DataSource).Sort = myClass_Data.myDataView.Sort; } this.label_Data.Text = string.Format("焊工证书,({0}):", this.dataGridView_Data.RowCount); this.toolStripStatusLabel_ShipClassificationAb.Text = string.Format("船级社:{0}", this.str_ShipClassificationAb); this.toolStripStatusLabel_ShipboardNo.Text = string.Format("船舶系列:{0}", this.str_ShipboardNo); this.toolStripStatusLabel_KindofQC.Text = this.str_KindofQC; }
private void InitDataGridView(object sender, EventArgs_WPS e) { Class_DataControlBind.InitializeDataGridView(this.dataGridView_WPSWeldingSequence, Enum_DataTableSecond.WPSWeldingSequence.ToString(), false); Class_DataControlBind.InitializeDataGridView(this.dataGridView_WPSWeldingLayer, Enum_DataTableSecond.WPSWeldingLayer.ToString(), false); this.myEventArgs_WPS = e; Class_Data myClass_Data_WPSWeldingSequence = (Class_Data)Class_Public.myHashtable[Enum_DataTableSecond.WPSWeldingSequence.ToString()]; Class_Data myClass_Data_WPSWeldingLayer = (Class_Data)Class_Public.myHashtable[Enum_DataTableSecond.WPSWeldingLayer.ToString()]; myClass_Data_WPSWeldingSequence.SetFilter(string.Format("WPSID='{0}'", this.myEventArgs_WPS.str_WPSID)); myClass_Data_WPSWeldingLayer.SetFilter(string.Format("WPSID='{0}'", this.myEventArgs_WPS.str_WPSID)); if (this.myEventArgs_WPS.bool_JustFill) { if (this.myDataTable_WPSWeldingSequence.Rows.Count == 0) { this.dataGridView_WPSWeldingSequence.DataSource = null; myClass_Data_WPSWeldingSequence.RefreshData(this.myEventArgs_WPS.bool_JustFill); this.myDataTable_WPSWeldingSequence = myClass_Data_WPSWeldingSequence.myDataTable.Copy(); this.myDataView_WPSWeldingSequence = new DataView(this.myDataTable_WPSWeldingSequence); this.dataGridView_WPSWeldingSequence.DataSource = this.myDataView_WPSWeldingSequence; } else { myClass_Data_WPSWeldingSequence.RefreshData(this.myEventArgs_WPS.bool_JustFill, this.myDataTable_WPSWeldingSequence); } } else { this.dataGridView_WPSWeldingSequence.DataSource = null; myClass_Data_WPSWeldingSequence.RefreshData(this.myEventArgs_WPS.bool_JustFill); this.myDataTable_WPSWeldingSequence = myClass_Data_WPSWeldingSequence.myDataTable.Copy(); this.myDataView_WPSWeldingSequence = new DataView(this.myDataTable_WPSWeldingSequence); this.dataGridView_WPSWeldingSequence.DataSource = this.myDataView_WPSWeldingSequence; } if (string.IsNullOrEmpty(((DataView)this.dataGridView_WPSWeldingSequence.DataSource).Sort)) { ((DataView)this.dataGridView_WPSWeldingSequence.DataSource).Sort = myClass_Data_WPSWeldingSequence.myDataView.Sort; } if (this.myEventArgs_WPS.bool_JustFill) { if (this.myDataTable_WPSWeldingLayer.Rows.Count == 0) { this.dataGridView_WPSWeldingLayer.DataSource = null; myClass_Data_WPSWeldingLayer.RefreshData(this.myEventArgs_WPS.bool_JustFill); this.myDataTable_WPSWeldingLayer = myClass_Data_WPSWeldingLayer.myDataTable.Copy(); this.myDataView_WPSWeldingLayer = new DataView(this.myDataTable_WPSWeldingLayer); this.dataGridView_WPSWeldingLayer.DataSource = this.myDataView_WPSWeldingLayer; } else { myClass_Data_WPSWeldingLayer.RefreshData(this.myEventArgs_WPS.bool_JustFill, this.myDataTable_WPSWeldingLayer); } } else { this.dataGridView_WPSWeldingLayer.DataSource = null; myClass_Data_WPSWeldingLayer.RefreshData(this.myEventArgs_WPS.bool_JustFill); this.myDataTable_WPSWeldingLayer = myClass_Data_WPSWeldingLayer.myDataTable.Copy(); this.myDataView_WPSWeldingLayer = new DataView(this.myDataTable_WPSWeldingLayer); this.dataGridView_WPSWeldingLayer.DataSource = this.myDataView_WPSWeldingLayer; } if (string.IsNullOrEmpty(((DataView)this.dataGridView_WPSWeldingLayer.DataSource).Sort)) { ((DataView)this.dataGridView_WPSWeldingLayer.DataSource).Sort = myClass_Data_WPSWeldingLayer.myDataView.Sort; } this.label_WPSSequence.Text = string.Format("焊接工艺道次类别:({0})", this.dataGridView_WPSWeldingSequence.RowCount); this.label_WPSLayer.Text = string.Format("焊接层次分布:({0})", this.dataGridView_WPSWeldingLayer.RowCount); }