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("该行数据已被删除！");
}
}
