public void InitControl(Class_Material myClass_Material, bool bool_Add) { Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.WeldingStandardAndGroup.ToString()]; DataView myDataView_WeldingStandardAndGroup = new DataView(myClass_Data.myDataTable); myDataView_WeldingStandardAndGroup.RowFilter = "WeldingStandardGroup='½ðÊô²ÄÁϱê×¼'"; Class_DataControlBind.InitializeComboBox(this.comboBox_MaterialDenominateWeldingStandard, myDataView_WeldingStandardAndGroup, "WeldingStandard", "WeldingStandard"); this.myClass_Material = myClass_Material; if (bool_Add) { if (myClass_MaterialDefault != null) { } } else { this.textBox_Material.ReadOnly = true; this.textBox_Material.Text = myClass_Material.Material; this.textBox_MaterialGBName.Text = myClass_Material.MaterialGBName; this.comboBox_MaterialDenominateWeldingStandard.SelectedValue = myClass_Material.MaterialDenominateWeldingStandard; this.textBox_MaterialCCSGroupAb.Text = myClass_Material.MaterialCCSGroupAb; this.textBox_MaterialISOGroupAb.Text = myClass_Material.MaterialISOGroupAb; this.textBox_MaterialRemark.Text = myClass_Material.MaterialRemark; this.numericUpDown_MaterialIndex.Value = myClass_Material.MaterialIndex; } }
private void InitTreeView() { this.treeView_Data.Nodes.Clear(); TreeNode myTreeNode; TreeNode myTreeNode_KindofEmployer; myTreeNode = new TreeNode(); myTreeNode.Text = "报考单位"; myTreeNode.Tag = "报考单位"; Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.KindofEmployer.ToString()]; foreach (DataRowView myDataRowView_KindofEmployer in myClass_Data.myDataView) { myTreeNode_KindofEmployer = new TreeNode(); myTreeNode_KindofEmployer.Text = myDataRowView_KindofEmployer["KindofEmployer"].ToString(); myTreeNode_KindofEmployer.Tag = myDataRowView_KindofEmployer["KindofEmployer"].ToString(); if (Class_CustomUser.GetSecurity(Class_zwjPublic.myClass_CustomUser.UserGUID, Class_CustomSecurity.GetSecurityGUID("焊工权限"), Enum_zwjKindofUpdate.Read)) { myTreeNode.Nodes.Add(myTreeNode_KindofEmployer); } else if (Class_CustomUser.GetSecurity(Class_zwjPublic.myClass_CustomUser.UserGUID, Class_CustomSecurity.GetSecurityGUID("报考权限"), Enum_zwjKindofUpdate.Read)) { Class_KindofEmployer myClass_KindofEmployer = new Class_KindofEmployer(myDataRowView_KindofEmployer["KindofEmployer"].ToString()); if (myClass_KindofEmployer.KindofEmployerManagerID.Equals(Class_zwjPublic.myClass_CustomUser.UserGUID)) { myTreeNode.Nodes.Add(myTreeNode_KindofEmployer); } } } this.treeView_Data.Nodes.Add(myTreeNode); this.label_Data.Text = string.Format("报考单位:({0})", myTreeNode.Nodes.Count); }
private void Form_WelderBelong_ImportFromExcel_Load(object sender, EventArgs e) { string str_ErrMessage; str_ErrMessage = this.CheckSchema_DataTable(); if (!string.IsNullOrEmpty(this.CheckSchema_DataTable())) { MessageBox.Show(str_ErrMessage); this.Close(); return; } DataRow[] myDataRow_Range; //myDataRow_Range = this.myDataTable.Select("(len(IdentificationCard)=15 or len(IdentificationCard)=18) and len(WelderName)>0 and (Sex='男' or Sex='女') and len(Schooling)>0 and len(WelderBelongEmployer)>0"); myDataRow_Range = this.myDataTable.Select("len(IdentificationCard)>0 and len(WelderName)>0 and len(Schooling)>0 and len(WelderBelongEmployer)>0"); DataTable myDataTable_Temp = this.myDataTable.Clone(); foreach (DataRow myDataRow in myDataRow_Range) { myDataTable_Temp.ImportRow(myDataRow); } this.myDataTable = myDataTable_Temp; if (Class_Data.GetDistinctField(this.myDataTable, "IdentificationCard").Rows.Count != this.myDataTable.Rows.Count) { MessageBox.Show("数据表中有重复的身份证号码!"); this.Close(); } DataColumn[] keys = new DataColumn[1]; keys[0] = this.myDataTable.Columns["IdentificationCard"]; this.myDataTable.PrimaryKey = keys; this.dataGridView_Data.DataSource = new DataView(this.myDataTable); 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_WeldingStandard e) { this.myEventArgs_WeldingStandard = e; Class_DataControlBind.InitializeDataGridView(this.dataGridView_Data, Enum_DataTable.WeldingSubject.ToString(), false); Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.WeldingSubject.ToString()]; if (this.myEventArgs_WeldingStandard.bool_JustFill) { myClass_Data.RefreshData(this.myEventArgs_WeldingStandard.bool_JustFill); } else { this.dataGridView_Data.DataSource = null; myClass_Data.RefreshData(this.myEventArgs_WeldingStandard.bool_JustFill); this.dataGridView_Data.DataSource = myClass_Data.myDataView; } if (string.IsNullOrEmpty(this.myEventArgs_WeldingStandard.str_WeldingStandard)) { myClass_Data.myDataView.RowFilter = e.str_Filter; } else { myClass_Data.myDataView.RowFilter = string.Format("WeldingStandard='{0}'", e.str_WeldingStandard); } if (this.dataGridView_Data.RowCount == 0) { EventArgs_WeldingSubject my_e = new EventArgs_WeldingSubject(null); Publisher_WeldingSubject.OnEventName(my_e); } this.label_Data.Text = string.Format("考试科目,({0}):", this.dataGridView_Data.RowCount); }
public void InitControl(Class_Employer myClass_Employer, bool bool_Add) { Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.EmployerGroup.ToString()]; Class_DataControlBind.InitializeComboBox(this.ComboBox_EmployerGroup, myClass_Data.myDataView, "EmployerGroup", "EmployerGroup"); this.myClass_Employer = myClass_Employer; if (bool_Add == false) { this.MaskedTextBox_EmployerHPID.ReadOnly = true; this.MaskedTextBox_EmployerHPID.Text = myClass_Employer.EmployerHPID; this.TextBox_Employer.Text = myClass_Employer.Employer; this.textBox_EmployerAddress.Text = myClass_Employer.EmployerAddress; this.textBox_EmployerAddressEnglish.Text = myClass_Employer.EmployerAddressEnglish; this.textBox_EmployerEmail.Text = myClass_Employer.EmployerEmail; this.TextBox_EmployerEnglish.Text = myClass_Employer.EmployerEnglish; this.textBox_EmployerFax.Text = myClass_Employer.EmployerFax; this.textBox_EmployerLinkman.Text = myClass_Employer.EmployerLinkman; this.textBox_EmployerMobile.Text = myClass_Employer.EmployerMobile; this.textBox_EmployerPostalcode.Text = myClass_Employer.EmployerPostalcode; this.textBox_EmployerCity.Text = myClass_Employer.EmployerCity; this.TextBox_EmployerRemark.Text = myClass_Employer.EmployerRemark; this.textBox_EmployerTel.Text = myClass_Employer.EmployerTel; this.TextBox_ShortenedEmployer.Text = myClass_Employer.ShortenedEmployer; this.ComboBox_EmployerGroup.SelectedValue = myClass_Employer.EmployerGroup; this.NumericUpDown_EmployerIndex.Value = myClass_Employer.EmployerIndex; } else { } }
/// <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 Form_StudentQC_ImportFromExcel_Load(object sender, EventArgs e) { string str_ErrMessage; str_ErrMessage = this.CheckSchema_DataTable(); if (!string.IsNullOrEmpty(this.CheckSchema_DataTable())) { MessageBox.Show(str_ErrMessage); this.Close(); return; } DataRow[] myDataRow_Range; //myDataRow_Range = this.myDataTable.Select("(len(IdentificationCard)=15 or len(IdentificationCard)=18) and len(WelderName)>0 and (Sex='男' or Sex='女') and len(Schooling)>0 and len(WelderEmployer)>0 and len(ExamSubjectID)=4"); myDataRow_Range = this.myDataTable.Select("len(IdentificationCard)>0 and len(WelderName)>0 and len(Schooling)>0 and len(WelderEmployer)>0"); DataTable myDataTable_Temp = this.myDataTable.Clone(); foreach (DataRow myDataRow in myDataRow_Range) { myDataTable_Temp.ImportRow(myDataRow); } this.myDataTable = myDataTable_Temp; string[] str_fieldNameArray = new string [2]; str_fieldNameArray[0] = "IssueNo"; str_fieldNameArray[1] = "IdentificationCard"; if (Class_Data.GetDistinctField(this.myDataTable, str_fieldNameArray).Rows.Count != this.myDataTable.Rows.Count) { MessageBox.Show("数据表中同一班级编号下有重复的身份证号码!"); this.Close(); } this.dataGridView_Data.DataSource = new DataView(this.myDataTable); this.label_Data.Text = string.Format("报名学员,({0}):", this.dataGridView_Data.RowCount); }
private void UserControl_WPSHeatTreatmentBase_Load(object sender, EventArgs e) { Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTableSecond.HeatTreatment.ToString()]; Class_DataControlBind.InitializeComboBox(this.comboBox_WPSHeatTreatment, myClass_Data.myDataView, "HeatTreatment", "HeatTreatment"); Class_Public.InitializeComboBox(this.comboBox_WPSHeatKindofLimit, Enum_DataTableSecond.KindofLimit.ToString(), "KindofLimit", "KindofLimit"); myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTableSecond.HeatMethod.ToString()]; Class_DataControlBind.InitializeComboBox(this.comboBox_WPSHeatMethod, myClass_Data.myDataView, "HeatMethod", "HeatMethod"); }
public List <int> promotion_bonuses(int class_id) { if (Class_Data != null && Class_Data.get_class(class_id) != null) { var promotion_class = Class_Data.get_class(class_id); return(Enumerable.Range(0, Generic_Stats[(int)Generic_Builds.Normal][0].Count) .Select(x => promotion_class.Generic_Stats[(int)Generic_Builds.Normal][0][x] - Generic_Stats[(int)Generic_Builds.Normal][0][x]) .ToList()); } return(null); }
private void Form_WeldingConsumableISOGroupQuery_Load(object sender, EventArgs e) { Class_DataControlBind.InitializeDataGridView(this.dataGridView_Query, Enum_DataTable.WeldingConsumableISOGroup.ToString(), false); Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.WeldingConsumableISOGroup.ToString()]; this.dataGridView_Query.DataSource = new DataView(myClass_Data.myDataTable); ((DataView)this.dataGridView_Query.DataSource).Sort = myClass_Data.myDataView.Sort; if (this.myClass_WeldingConsumableISOGroup.WeldingConsumableISOGroupAb != null) { Class_DataControlBind.SetDataGridViewSelectedPosition("WeldingConsumableISOGroupAb", this.myClass_WeldingConsumableISOGroup.WeldingConsumableISOGroupAb, this.dataGridView_Query); } }
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); }
private void UserControl_WPSSequenceBase_Load(object sender, EventArgs e) { this.textBox_WPSSequenceWeldingConsumable.BackColor = Properties.Settings.Default.textBoxDoubleClickColor; Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.WeldingProcess.ToString()]; Class_DataControlBind.InitializeComboBox(this.comboBox_WPSSequenceWeldingProcessAb, myClass_Data.myDataView, "WeldingProcessAb", "WeldingProcessAb"); myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.WeldingPosition.ToString()]; Class_DataControlBind.InitializeComboBox(this.comboBox_WPSSequenceWeldingPosition, myClass_Data.myDataView, "WeldingPosition", "WeldingPosition"); myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTableSecond.TypeofCurrentAndPolarity.ToString()]; Class_DataControlBind.InitializeComboBox(this.comboBox_WPSSequenceTypeofCurrentAndPolarity, myClass_Data.myDataView, "TypeofCurrentAndPolarity", "TypeofCurrentAndPolarity"); }
private void Form_KindofEmployerQuery_Load(object sender, EventArgs e) { Class_DataControlBind.InitializeDataGridView(this.dataGridView_Query, Enum_DataTable.KindofEmployer.ToString(), false); Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.KindofEmployer.ToString()]; this.dataGridView_Query.DataSource = new DataView(myClass_Data.myDataTable); ((DataView)this.dataGridView_Query.DataSource).Sort = myClass_Data.myDataView.Sort; if (this.myClass_KindofEmployer.KindofEmployer != null) { Class_DataControlBind.SetDataGridViewSelectedPosition("KindofEmployer", this.myClass_KindofEmployer.KindofEmployer, this.dataGridView_Query); } }
/// <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); }
private void Form_MaterialQuery_Load(object sender, EventArgs e) { Class_DataControlBind.InitializeDataGridView(this.dataGridView_Query, Enum_DataTable.Material.ToString(), false); Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.Material.ToString()]; this.dataGridView_Query.DataSource = new DataView(myClass_Data.myDataTable); ((DataView)this.dataGridView_Query.DataSource).Sort = myClass_Data.myDataView.Sort; if (this.myClass_Material.Material != null) { //object[] object_SortValue = new object[1] { this.myClass_Material.Material }; //Class_Public.myclass_DataControlBind.SetDataGridViewSelectedPosition("Material", object_SortValue, this.dataGridView_Query); Class_DataControlBind.SetDataGridViewSelectedPosition("Material", this.myClass_Material.Material, this.dataGridView_Query); } }
private void Form_ShipClassificationQuery_Load(object sender, EventArgs e) { Class_DataControlBind.InitializeDataGridView(this.dataGridView_Query, Enum_DataTable.ShipClassification.ToString(), false); Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.ShipClassification.ToString()]; this.dataGridView_Query.DataSource = new DataView(myClass_Data.myDataTable); ((DataView)this.dataGridView_Query.DataSource).Sort = myClass_Data.myDataView.Sort; if (!string.IsNullOrEmpty(this.myClass_ShipClassification.ShipClassificationAb)) { //object[] object_SortValue = new object[1] { this.myClass_ShipClassification.ShipClassificationAb }; //Class_Public.myclass_DataControlBind.SetDataGridViewSelectedPosition("ShipClassificationAb", object_SortValue, this.dataGridView_Query); Class_DataControlBind.SetDataGridViewSelectedPosition("ShipClassificationAb", this.myClass_ShipClassification.ShipClassificationAb, this.dataGridView_Query); } }
/// <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; }
private void Form_GasAndWeldingFluxQuery_Load(object sender, EventArgs e) { Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTableSecond.GasAndWeldingFluxGroup.ToString()]; Class_DataControlBind.InitializeComboBox(this.comboBox_GasAndWeldingFluxGroup, myClass_Data.myDataView, "GasAndWeldingFluxGroup", "GasAndWeldingFluxGroup"); Class_DataControlBind.InitializeDataGridView(this.dataGridView_Query, Enum_DataTableSecond.GasAndWeldingFlux.ToString(), false); myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTableSecond.GasAndWeldingFlux.ToString()]; this.dataGridView_Query.DataSource = new DataView(myClass_Data.myDataTable); ((DataView)this.dataGridView_Query.DataSource).Sort = myClass_Data.myDataView.Sort; if (this.myClass_GasAndWeldingFlux.GasAndWeldingFlux != null) { Class_DataControlBind.SetDataGridViewSelectedPosition("GasAndWeldingFlux", this.myClass_GasAndWeldingFlux.GasAndWeldingFlux, this.dataGridView_Query); } }
private void Form_EmployerQuery_Load(object sender, EventArgs e) { Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.EmployerGroup.ToString()]; Class_DataControlBind.InitializeComboBox(this.comboBox_EmployerGroup, myClass_Data.myDataView, "EmployerGroup", "EmployerGroup"); Class_DataControlBind.InitializeDataGridView(this.dataGridView_Employer, Enum_DataTable.Employer.ToString(), false); myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.Employer.ToString()]; this.dataGridView_Employer.DataSource = new DataView(myClass_Data.myDataTable); ((DataView)this.dataGridView_Employer.DataSource).Sort = myClass_Data.myDataView.Sort; if (!string.IsNullOrEmpty(this.myClass_Employer.EmployerHPID)) { //object[] object_SortValue = new object[1] { this.myClass_Employer.EmployerHPID }; //Class_Public.myclass_DataControlBind.SetDataGridViewSelectedPosition("EmployerHPID", object_SortValue, this.dataGridView_Employer); Class_DataControlBind.SetDataGridViewSelectedPosition("EmployerHPID", this.myClass_Employer.EmployerHPID, this.dataGridView_Employer); } }
/// <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_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(); }
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(); } }
/// <summary> /// 初始化数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void InitDataGridView(object sender, EventArgs_WeldingSubject e) { this.myEventArgs_WeldingSubject = e; Class_DataControlBind.InitializeDataGridView(this.dataGridView_Data, Enum_DataTable.WeldingSubjectPosition.ToString(), false); Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.WeldingSubjectPosition.ToString()]; if (this.myEventArgs_WeldingSubject.bool_JustFill) { myClass_Data.RefreshData(this.myEventArgs_WeldingSubject.bool_JustFill); } else { this.dataGridView_Data.DataSource = null; myClass_Data.RefreshData(this.myEventArgs_WeldingSubject.bool_JustFill); this.dataGridView_Data.DataSource = myClass_Data.myDataView; } myClass_Data.myDataView.RowFilter = string.Format("SubjectID='{0}'", this.myEventArgs_WeldingSubject.str_SubjectID); this.label_Data.Text = string.Format("考试项目,({0}):", this.dataGridView_Data.RowCount); }
/// <summary> /// 删除数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void toolStripMenuItem_DataGridViewRowDelete_Click(object sender, EventArgs e) { if (Class_WelderBelong.ExistAndCanDeleteAndDelete((long)this.dataGridView_Data.CurrentRow.Cells["WelderBelongID"].Value, Enum_zwjKindofUpdate.CanDelete)) { if (MessageBox.Show("确认删除吗?", "确认窗口", MessageBoxButtons.OKCancel) == DialogResult.OK) { Class_WelderBelong.ExistAndCanDeleteAndDelete((long)this.dataGridView_Data.CurrentRow.Cells["WelderBelongID"].Value, Enum_zwjKindofUpdate.Delete); Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.WelderBelong.ToString()]; this.dataGridView_Data.DataSource = null; myClass_Data.RefreshData(false, this.myDataTable); this.dataGridView_Data.DataSource = this.myDataView; this.RefreshData(false); } } else { MessageBox.Show("不能删除!"); } }
/// <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); } }
/// <summary> /// 初始化数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void InitDataGridView(object sender, EventArgs_ReviveQC e) { this.myEventArgs_ReviveQC = e; Class_DataControlBind.InitializeDataGridView(this.dataGridView_Data, Enum_DataTableSecond.ReviveQC.ToString(), false); Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTableSecond.ReviveQC.ToString()]; myClass_Data.myDataView.RowFilter = this.myEventArgs_ReviveQC.str_Filter; if (this.myEventArgs_ReviveQC.bool_JustFill) { myClass_Data.RefreshData(this.myEventArgs_ReviveQC.bool_JustFill); } else { this.dataGridView_Data.DataSource = null; myClass_Data.RefreshData(this.myEventArgs_ReviveQC.bool_JustFill); this.dataGridView_Data.DataSource = myClass_Data.myDataView; } this.label_Data.Text = string.Format("激活证书考试记录,({0}):", this.dataGridView_Data.RowCount); }
/// <summary> /// 修改数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void toolStripMenuItem_DataGridViewRowModify_Click(object sender, EventArgs e) { Form_WelderBelong_Update myForm = new Form_WelderBelong_Update(); myForm.myClass_WelderBelong = new Class_WelderBelong(); myForm.myClass_WelderBelong.WelderBelongID = (long )this.dataGridView_Data.CurrentRow.Cells["WelderBelongID"].Value; if (myForm.myClass_WelderBelong.FillData()) { myForm.bool_Add = false; if (myForm.ShowDialog() == DialogResult.OK) { Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.WelderBelong.ToString()]; myClass_Data.RefreshData(true, this.myDataTable); this.RefreshData(true); } } else { MessageBox.Show("该行数据已被删除!"); } }