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