/// <summary>
/// 初始化数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void InitDataGridView(object sender, EventArgs_WelderFilter e)
{
Class_DataControlBind.InitializeDataGridView(this.dataGridView_Data, Enum_DataTable.Welder.ToString(), false);
SqlCommand myCmd_Temp = new SqlCommand("Person_Welder_Query", Class_zwjPublic.myClass_SqlConnection.mySqlConn);
myCmd_Temp.CommandType = CommandType.StoredProcedure;
myCmd_Temp.Parameters.Add("@IdentificationCard", SqlDbType.NChar, 18).Value = ZCCL.Tools.Class_DataValidateTool.CovertIdentificationCard(e.str_IdentificationCard);
myCmd_Temp.Parameters.Add("@WelderName", SqlDbType.NVarChar, 10).Value = e.str_WelderName;
myCmd_Temp.Parameters.Add("@WelderWorkerID", SqlDbType.NVarChar, 10).Value = e.str_WelderWorkerID;
myCmd_Temp.Parameters.Add("@RegistrationNo", SqlDbType.NVarChar, 20).Value = e.str_RegistrationNo;
myCmd_Temp.Parameters.Add("@ExaminingNo", SqlDbType.NVarChar, 20).Value = e.str_ExaminingNo;
myCmd_Temp.Parameters.Add("@CertificateNo", SqlDbType.NVarChar, 20).Value = e.str_CertificateNo;
myCmd_Temp.Parameters.Add("@IssueNo", SqlDbType.NVarChar, 20).Value = e.str_IssueNo;
if (!string.IsNullOrEmpty(e.str_Filter))
{
myCmd_Temp.Parameters.Add("@Filter", SqlDbType.NVarChar).Value = e.str_Filter;
}
SqlDataAdapter myAdapter = new SqlDataAdapter(myCmd_Temp);
DataTable myDataTable = new DataTable();
myAdapter.Fill(myDataTable);
this.dataGridView_Data.DataSource = new DataView(myDataTable);
this.label_Data.Text = string.Format("焊工，({0})：", this.dataGridView_Data.RowCount);
if (this.dataGridView_Data.RowCount == 0)
{
EventArgs_Welder my_e = new EventArgs_Welder(null);
Publisher_Welder.OnEventName(my_e);
MessageBox.Show("没有找到符合条件的焊工！");
}
}
public void InitDataGridView(DataTable myDataTable, bool bool_GXTheory, string str_IssueNo)
{
myDataTable.AcceptChanges();
this.myDataTable_Origin = myDataTable;
this.myDataTable_Modified = this.myDataTable_Origin.Copy();
if (this.myDataTable_Modified.Columns.Contains("Checked"))
{
this.myDataTable_Modified.Columns.Remove("Checked");
}
DataColumn myDataColumn_Checked = new DataColumn("Checked");
myDataColumn_Checked.DataType = System.Type.GetType("System.Boolean");
myDataColumn_Checked.DefaultValue = false;
this.myDataTable_Modified.Columns.Add(myDataColumn_Checked);
this.bool_GXTheory = bool_GXTheory;
this.str_IssueNo = str_IssueNo;
if (this.bool_GXTheory)
{
Class_DataControlBind.InitializeDataGridView(this.dataGridView_Origin, Enum_DataTable.GXTheoryWelderStudent.ToString(), false);
Class_DataControlBind.InitializeDataGridView(this.dataGridView_Modified, Enum_DataTable.GXTheoryWelderStudent.ToString(), true);
this.checkBox_Assemblage.Enabled = false;
this.checkBox_CoverWeldingRodDiameter.Enabled = false;
this.checkBox_DimensionofMaterial.Enabled = false;
this.checkBox_ExternalDiameter.Enabled = false;
this.checkBox_Material.Enabled = false;
this.checkBox_RenderWeldingRodDiameter.Enabled = false;
this.checkBox_Thickness.Enabled = false;
this.checkBox_WeldingConsumable.Enabled = false;
this.checkBox_WeldingRodDiameter.Enabled = false;
}
else
{
Class_DataControlBind.InitializeDataGridView(this.dataGridView_Origin, Enum_DataTable.WelderStudentQC.ToString(), false);
Class_DataControlBind.InitializeDataGridView(this.dataGridView_Modified, Enum_DataTable.WelderStudentQC.ToString(), true);
this.dataGridView_Modified.Columns["SkillResult"].ReadOnly = false;
this.dataGridView_Modified.Columns["SkillMakeupResult"].ReadOnly = false;
this.dataGridView_Modified.Columns["StudentMarked"].ReadOnly = false;
this.dataGridView_Modified.Columns["StudentAssemblage"].ReadOnly = false;
this.dataGridView_Modified.Columns["StudentMaterial"].ReadOnly = false;
this.dataGridView_Modified.Columns["StudentDimensionofMaterial"].ReadOnly = false;
this.dataGridView_Modified.Columns["StudentThickness"].ReadOnly = false;
this.dataGridView_Modified.Columns["StudentExternalDiameter"].ReadOnly = false;
}
this.dataGridView_Modified.Columns["Checked"].ReadOnly = false;
this.dataGridView_Modified.Columns["StudentKindofExam"].ReadOnly = false;
this.dataGridView_Modified.Columns["ExamStatus"].ReadOnly = false;
this.dataGridView_Modified.Columns["TheoryResult"].ReadOnly = false;
this.dataGridView_Modified.Columns["TheoryMakeupResult"].ReadOnly = false;
this.dataGridView_Modified.Columns["StudentRemark"].ReadOnly = false;
this.dataGridView_Origin.DataSource = new DataView(this.myDataTable_Origin);
this.dataGridView_Modified.DataSource = new DataView(this.myDataTable_Modified);
((DataView)this.dataGridView_Origin.DataSource).Sort = "ExaminingNo";
((DataView)this.dataGridView_Modified.DataSource).Sort = "ExaminingNo";
this.label_Origin.Text = string.Format("原始数据，({0})：", this.dataGridView_Origin.RowCount);
}
/// <summary>
/// 初始化数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void InitDataGridView(object sender, EventArgs_Student e)
{
this.myEventArgs_Student = e;
Class_DataControlBind.InitializeDataGridView(this.dataGridView_Data, Enum_DataTable.SubjectPositionResult.ToString(), false);
if (this.dataGridView_Data.DataSource != null)
{
if (this.myEventArgs_Student.bool_GXTheory == false)
{
((DataView)this.dataGridView_Data.DataSource).RowFilter = string.Format("ExaminingNo='{0}'", this.myEventArgs_Student.str_ExaminingNo);
}
else
{
}
}
this.label_Data.Text = string.Format("考试项目，({0})：", this.dataGridView_Data.RowCount);
if (this.tabControl_Auxiliary.SelectedTab.Text == "考试记录")
{
this.userControl_WelderExamBase1.InitDataGridView(this.myEventArgs_Student.str_IdentificationCard);
}
Class_Data myClass_Data;
Class_DataControlBind.InitializeDataGridView(this.dataGridView_TestCommitteeRegistrationNo, Enum_DataTable.WelderTestCommitteeRegistrationNo.ToString(), false);
myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.WelderTestCommitteeRegistrationNo.ToString()];
myClass_Data.SetFilter(string.Format("IdentificationCard ='{0}'", this.myEventArgs_Student.str_IdentificationCard));
this.dataGridView_TestCommitteeRegistrationNo.DataSource = null;
myClass_Data.RefreshData(false);
this.dataGridView_TestCommitteeRegistrationNo.DataSource = new DataView(myClass_Data.myDataTable.Copy());
((DataView)this.dataGridView_TestCommitteeRegistrationNo.DataSource).Sort = myClass_Data.myDataView.Sort;
this.label_TestCommitteeRegistrationNo.Text = string.Format("存档组织编号，({0})：", this.dataGridView_TestCommitteeRegistrationNo.RowCount);
this.pictureBox_Welder.Image = Class_Welder.GetWelderPicture(this.myEventArgs_Student.str_IdentificationCard);
}
/// <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);
}
}
/// <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);
}
private void Form_KindofEmployerStudent_AddBatch_Load(object sender, EventArgs e)
{
Class_DataControlBind.InitializeDataGridView(this.dataGridView_Data, Enum_DataTable.KindofEmployerWelder.ToString(), false);
Class_KindofEmployerIssue myClass_KindofEmployerIssue = new Class_KindofEmployerIssue(this.int_KindofEmployerIssueID);
this.TextBox_IssueNo.Text = myClass_KindofEmployerIssue.IssueNo;
this.MaskedTextBox_KindofEmployerIssueID.Text = myClass_KindofEmployerIssue.KindofEmployerIssueID.ToString();
}
public void InitDataGridView(DataTable myDataTable, string str_IssueNo)
{
Class_DataControlBind.InitializeDataGridView(this.dataGridView_Origin, Enum_DataTable.WelderStudentQC.ToString(), true);
Class_DataControlBind.InitializeDataGridView(this.dataGridView_Modified, Enum_DataTable.WelderStudentQC.ToString(), false);
if (this.myDataTable_Origin == null)
{
this.dataGridView_Origin.ReadOnly = false;
this.dataGridView_Origin.Columns["Checked"].ReadOnly = false;
myDataTable.AcceptChanges();
this.myDataTable_Origin = myDataTable;
if (this.myDataTable_Origin.Columns.Contains("Checked"))
{
this.myDataTable_Origin.Columns.Remove("Checked");
}
DataColumn myDataColumn_Checked = new DataColumn("Checked");
myDataColumn_Checked.DataType = System.Type.GetType("System.Boolean");
myDataColumn_Checked.DefaultValue = true;
this.myDataTable_Origin.Columns.Add(myDataColumn_Checked);
this.dataGridView_Origin.DataSource = new DataView(this.myDataTable_Origin);
((DataView)this.dataGridView_Origin.DataSource).Sort = "ExaminingNo";
this.label_Origin.Text = string.Format("原始数据，({0})：", this.dataGridView_Origin.RowCount);
}
this.myDataTable_Modified = this.myDataTable_Origin.Clone();
this.dataGridView_Modified.DataSource = new DataView(this.myDataTable_Modified);
((DataView)this.dataGridView_Modified.DataSource).Sort = "ExaminingNo";
this.str_IssueNo = str_IssueNo;
Class_Issue myClass_Issue = new Class_Issue(this.str_IssueNo);
this.TextBox_IssueNo.Text = myClass_Issue.IssueNo;
this.TextBox_WeldingProcessAb.Text = myClass_Issue.WeldingProcessAb;
if (myClass_Issue.IssueIssuedOn != DateTime.MinValue)
{
this.DateTimePicker_IssuedOn.Value = myClass_Issue.IssueIssuedOn;
}
else if (Properties.Settings.Default.IssuedOn != DateTime.MinValue)
{
this.DateTimePicker_IssuedOn.Value = Properties.Settings.Default.IssuedOn;
}
string str_CertificateNo;
Class_ShipClassification myClass_ShipClassification = new Class_ShipClassification(myClass_Issue.ShipClassificationAb);
if (myClass_ShipClassification.ShipRestrict)
{
Class_Ship myClass_Ship = new Class_Ship(myClass_Issue.ShipboardNo);
str_CertificateNo = myClass_Ship.NextCertificateNo;
}
else
{
str_CertificateNo = myClass_ShipClassification.NextCertificateNo;
}
this.MaskedTextBox_NextCertificateNo.Text = str_CertificateNo;
}
/// <summary>
/// 初始化数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void InitDataGridView(object sender, EventArgs_Issue e)
{
this.myEventArgs_Issue = e;
Class_DataControlBind.InitializeDataGridView(this.dataGridView_Data, Enum_DataTable.IssueProcess.ToString(), false);
Class_Data myClass_Data;
if (this.myEventArgs_Issue.bool_GXTheory == false)
{
myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.IssueProcess.ToString()];
}
else
{
myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.GXTheoryIssueProcess.ToString()];
}
myClass_Data.SetFilter(string.Format("IssueNo='{0}'", e.str_IssueNo));
if (this.myEventArgs_Issue.bool_JustFill)
{
if (this.myDataTable.Rows.Count == 0)
{
this.dataGridView_Data.DataSource = null;
myClass_Data.RefreshData(this.myEventArgs_Issue.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_Issue.bool_JustFill, this.myDataTable);
}
}
else
{
this.dataGridView_Data.DataSource = null;
myClass_Data.RefreshData(this.myEventArgs_Issue.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;
}
if (this.treeView_IssueProcess.SelectedNode == null || this.treeView_IssueProcess.SelectedNode.Level == 0)
{
((DataView)this.dataGridView_Data.DataSource).RowFilter = null;
this.label_Data.Text = string.Format("全部({0})：", this.dataGridView_Data.RowCount);
}
else
{
((DataView)this.dataGridView_Data.DataSource).RowFilter = string.Format("IssueProcessStatusGroup='{0}'", this.treeView_IssueProcess.SelectedNode.Tag.ToString());
this.label_Data.Text = string.Format("{0}({1})：", this.treeView_IssueProcess.SelectedNode.Text, this.dataGridView_Data.RowCount);
}
}
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);
}
}
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 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);
}
}
/// <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);
}
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_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>
public void InitDataGridView(string str_IdentificationCard)
{
this.str_IdentificationCard = str_IdentificationCard;
Class_Data myClass_Data;
Class_DataControlBind.InitializeDataGridView(this.dataGridView_Data, Enum_DataTable.WelderTestCommitteeRegistrationNo.ToString(), false);
myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.WelderTestCommitteeRegistrationNo.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());
((DataView)this.dataGridView_Data.DataSource).Sort = myClass_Data.myDataView.Sort;
this.label_Data.Text = string.Format("存档组织编号，({0})：", 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);
}
}
/// <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 InitDataGridView(object sender, EventArgs_WPSQuery e)
{
Class_DataControlBind.InitializeDataGridView(this.dataGridView_Data, Enum_DataTable.WPS.ToString(), false);
this.dataGridView_Data.Columns["isLocked"].DefaultCellStyle.ForeColor = Properties.Settings.Default.WPSLockedColor;
this.dataGridView_Data.Columns["isLocked"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
this.dataGridView_Data.Columns["WPSMaterialSecond"].DefaultCellStyle.ForeColor = Properties.Settings.Default.WPSLockedColor;
this.dataGridView_Data.Columns["WPSWorkPieceTypeSecond"].DefaultCellStyle.ForeColor = Properties.Settings.Default.WPSLockedColor;
this.dataGridView_Data.Columns["WPSThicknessSecond"].DefaultCellStyle.ForeColor = Properties.Settings.Default.WPSLockedColor;
this.dataGridView_Data.Columns["WPSExternalDiameterSecond"].DefaultCellStyle.ForeColor = Properties.Settings.Default.WPSLockedColor;
this.myEventArgs_WPSQuery = e;
Class_Data myClass_Data;
myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.WPS.ToString()];
myClass_Data.SetFilter(this.myEventArgs_WPSQuery.str_Filter);
if (this.myEventArgs_WPSQuery.bool_JustFill)
{
if (this.myDataTable.Rows.Count == 0)
{
this.dataGridView_Data.DataSource = null;
myClass_Data.RefreshData(this.myEventArgs_WPSQuery.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_WPSQuery.bool_JustFill, this.myDataTable);
}
}
else
{
this.dataGridView_Data.DataSource = null;
myClass_Data.RefreshData(this.myEventArgs_WPSQuery.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.RowCount == 0)
{
//EventArgs_Issue my_e = new EventArgs_Issue(null, this.myEventArgs_ShipClassification.bool_GXTheory);
//Publisher_Issue.OnEventName(my_e);
}
}
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);
}
}
/// <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 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);
}
}
private void Form_GXTheoryStudent_AddBatch_Load(object sender, EventArgs e)
{
Class_DataControlBind.InitializeDataGridView(this.dataGridView_Data, Enum_DataTable.Welder.ToString(), false);
this.TextBox_IssueNo.Text = this.str_IssueNo;
Class_GXTheoryIssue myClass_GXTheoryIssue = new Class_GXTheoryIssue(this.str_IssueNo);
Class_ShipClassification myClass_ShipClassification = new Class_ShipClassification(myClass_GXTheoryIssue.ShipClassificationAb);
if (myClass_ShipClassification.ShipRestrict)
{
Class_Ship myClass_Ship = new Class_Ship(myClass_GXTheoryIssue.ShipboardNo);
this.MaskedTextBox_ExaminingNo.Text = myClass_Ship.NextTheoryExaminingNo;
}
else
{
this.MaskedTextBox_ExaminingNo.Text = myClass_ShipClassification.NextExaminingNo;
}
}
/// <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 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);
}
}
/// <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);
}
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);
}
private void Form_WeldingSubject_Query_Load(object sender, EventArgs e)
{
DataView myDataView_WeldingStandard = new DataView(((Class_Data )Class_Public.myHashtable[Enum_DataTable.WeldingStandardAndGroup.ToString()]).myDataTable);
myDataView_WeldingStandard.RowFilter = "WeldingStandardGroup='焊工考试标准'";
Class_DataControlBind.InitializeComboBox(this.ComboBox_WeldingStandard, myDataView_WeldingStandard, "WeldingStandard", "WeldingStandard");
Class_Public.InitializeComboBox(this.ComboBox_JointType, Enum_DataTable.JointType.ToString(), "JointType", "JointType");
Class_Public.InitializeComboBox(this.ComboBox_WorkPieceType, Enum_DataTable.WorkPieceType.ToString(), "WorkPieceType", "WorkPieceType");
this.ComboBox_JointType.Text = "";
this.ComboBox_WeldingStandard.Text = "";
this.ComboBox_WorkPieceType.Text = "";
Class_DataControlBind.InitializeDataGridView(this.dataGridView_Query, Enum_DataTable.WeldingSubject.ToString(), false);
Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.WeldingSubject.ToString()];
this.dataGridView_Query.DataSource = new DataView(myClass_Data.myDataTable);
((DataView)this.dataGridView_Query.DataSource).RowFilter = this.str_FilterRestrict;
((DataView)this.dataGridView_Query.DataSource).Sort = myClass_Data.myDataView.Sort;
if (!string.IsNullOrEmpty(this.myClass_WeldingSubject.SubjectID))
{
Class_DataControlBind.SetDataGridViewSelectedPosition("SubjectID", this.myClass_WeldingSubject.SubjectID, this.dataGridView_Query);
}
}
