/// <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); }
private void button_Query_Click(object sender, EventArgs e) { if (this.dataGridView_Data.Tag == null) { return; } Form_QueryFilter myForm = new Form_QueryFilter(); myForm.InitControl(this.dataGridView_Data.Tag.ToString()); if (myForm.ShowDialog() == DialogResult.OK) { EventArgs_DataManager my_e = new EventArgs_DataManager(this.myEventArgs_DataManager.str_DataManagerText, this.myEventArgs_DataManager.str_DataManagerName, this.myEventArgs_DataManager.str_DataManagerTag); my_e.str_Filter = myForm.str_Filter; Publisher_DataManager.OnEventName(my_e); } }
private void toolStripMenuItem_RowAddByExcel_Click(object sender, EventArgs e) { DataTable myDataTable = Class_DataControlBind.ImportExcelToDataTable(); if (myDataTable != null) { StringBuilder myStringBuilder = new StringBuilder(); if (myDataTable.Columns.Contains("CertificateNo")) { DataRow[] myDataRow_Range; myDataRow_Range = myDataTable.Select("len(CertificateNo)>0"); myStringBuilder.Append("1=0"); foreach (DataRow myDataRow in myDataRow_Range) { myStringBuilder.Append(string.Format(" Or CertificateNo='{0}'", myDataRow["CertificateNo"].ToString())); } } else if (myDataTable.Columns.Contains("ExaminingNo")) { DataRow[] myDataRow_Range; myDataRow_Range = myDataTable.Select("len(ExaminingNo)>0"); myStringBuilder.Append("1=0"); foreach (DataRow myDataRow in myDataRow_Range) { myStringBuilder.Append(string.Format(" Or ExaminingNo='{0}'", myDataRow["ExaminingNo"].ToString())); } } else { MessageBox.Show("数据表中不存在 'CertificateNo'或'ExaminingNo' 列!"); return; } EventArgs_DataManager my_e = new EventArgs_DataManager(this.myEventArgs_DataManager.str_DataManagerText, this.myEventArgs_DataManager.str_DataManagerName, this.myEventArgs_DataManager.str_DataManagerTag); my_e.str_Filter = myStringBuilder.ToString(); Publisher_DataManager.OnEventName(my_e); } }
private void treeView_Data_AfterSelect(object sender, TreeViewEventArgs e) { EventArgs_DataManager my_e = new EventArgs_DataManager((string)this.treeView_Data.SelectedNode.Text, this.treeView_Data.SelectedNode.Name, this.treeView_Data.SelectedNode.Tag.ToString()); Publisher_DataManager.OnEventName(my_e); }