private void RefreshData(bool bool_JustFill)
{
if (this.myEventArgs_WPSQuery == null)
{
this.myEventArgs_WPSQuery = new EventArgs_WPSQuery(null);
}
this.myEventArgs_WPSQuery.bool_JustFill = bool_JustFill;
Publisher_WPSQuery.OnEventName(this.myEventArgs_WPSQuery);
}
private void UserControl_WPSDataGridView_Load(object sender, EventArgs e)
{
Publisher_WPSQuery.EventName += new EventHandler_WPSQuery(InitDataGridView);
if (this.myEventArgs_WPSQuery == null)
{
this.myEventArgs_WPSQuery = new EventArgs_WPSQuery(null);
}
Publisher_WPSQuery.OnEventName(this.myEventArgs_WPSQuery);
}
private void button_pWPSQueryAdvance_Click(object sender, EventArgs e)
{
Form_QueryFilter myForm = new Form_QueryFilter();
myForm.InitControl(Enum_DataTable.WPS.ToString());
if (myForm.ShowDialog() == DialogResult.OK)
{
EventArgs_WPSQuery g = new EventArgs_WPSQuery(myForm.str_Filter);
Publisher_WPSQuery.OnEventName(g);
}
}
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 button_pWPSQuery_Click(object sender, EventArgs e)
{
string str_Filter = "1=1";
if (this.checkBox_Mistiness.Checked)
{
if (this.textBox_pWPSIDBegin.Text.Length > 0)
{
if (string.IsNullOrEmpty(this.textBox_pWPSIDEnd.Text))
{
str_Filter = str_Filter + string.Format(" And WPSID like '%{0}%'", this.textBox_pWPSIDBegin.Text);
}
else
{
str_Filter = str_Filter + string.Format(" And (WPSID >= '{0}' And WPSID <= '{1}')", this.textBox_pWPSIDBegin.Text, this.textBox_pWPSIDEnd.Text);
}
}
if (this.textBox_pWPSDenomination.Text.Length > 0)
{
str_Filter = str_Filter + string.Format(" And WPSDenomination like '%{0}%'", this.textBox_pWPSDenomination.Text);
}
if (this.textBox_pWPSWeldingProcessAb.Text.Length > 0)
{
str_Filter = str_Filter + string.Format(" And WPSWeldingProcessAb like '%{0}%'", this.textBox_pWPSWeldingProcessAb.Text);
}
if (this.textBox_pWPSMaterial.Text.Length > 0)
{
str_Filter = str_Filter + string.Format(" And (WPSMaterial like '%{0}%' Or WPSMaterialSecond like '%{0}%')", this.textBox_pWPSMaterial.Text);
}
if (this.textBox_pWPSWeldingConsumable.Text.Length > 0)
{
str_Filter = str_Filter + string.Format(" And WPSWeldingConsumable like '%{0}%'", this.textBox_pWPSWeldingConsumable.Text);
}
if (this.textBox_pWPSWeldingPosition.Text.Length > 0)
{
str_Filter = str_Filter + string.Format(" And WPSWeldingPosition like '%{0}%'", this.textBox_pWPSWeldingPosition.Text);
}
if (this.comboBox_pWPSGrooveType.Text.Length > 0)
{
str_Filter = str_Filter + string.Format(" And WPSGrooveType like '%{0}%'", this.comboBox_pWPSGrooveType.Text);
}
if (this.comboBox_pWPSJointType .Text.Length > 0)
{
str_Filter = str_Filter + string.Format(" And WPSJointType like '%{0}%'", this.comboBox_pWPSJointType.Text);
}
double dbl_pWPSThickness=0;
double.TryParse(this.textBox_pWPSThickness.Text, out dbl_pWPSThickness);
if (dbl_pWPSThickness > 0)
{
str_Filter = str_Filter + string.Format(" And (WPSThickness = {0} or WPSThicknessSecond = {0})", dbl_pWPSThickness);
}
}
else
{
if (this.textBox_pWPSIDBegin.Text.Length > 0)
{
str_Filter = str_Filter + string.Format(" And WPSID = '{0}'", this.textBox_pWPSIDBegin.Text);
}
if (this.textBox_pWPSDenomination.Text.Length > 0)
{
str_Filter = str_Filter + string.Format(" And WPSDenomination = '{0}'", this.textBox_pWPSDenomination.Text);
}
if (this.textBox_pWPSWeldingProcessAb.Text.Length > 0)
{
str_Filter = str_Filter + string.Format(" And WPSWeldingProcessAb = '{0}'", this.textBox_pWPSWeldingProcessAb.Text);
}
if (this.textBox_pWPSMaterial.Text.Length > 0)
{
str_Filter = str_Filter + string.Format(" And (WPSMaterial = '{0}' Or WPSMaterialSecond = '{0}')", this.textBox_pWPSMaterial.Text);
}
if (this.textBox_pWPSWeldingConsumable.Text.Length > 0)
{
str_Filter = str_Filter + string.Format(" And WPSWeldingConsumable = '{0}'", this.textBox_pWPSWeldingConsumable.Text);
}
if (this.textBox_pWPSWeldingPosition.Text.Length > 0)
{
str_Filter = str_Filter + string.Format(" And WPSWeldingPosition = '{0}'", this.textBox_pWPSWeldingPosition.Text);
}
if (this.comboBox_pWPSGrooveType.Text.Length > 0)
{
str_Filter = str_Filter + string.Format(" And WPSGrooveType = '{0}'", this.comboBox_pWPSGrooveType.Text);
}
if (this.comboBox_pWPSJointType.Text.Length > 0)
{
str_Filter = str_Filter + string.Format(" And WPSJointType = '{0}'", this.comboBox_pWPSJointType.Text);
}
double dbl_pWPSThickness = 0;
double.TryParse(this.textBox_pWPSThickness.Text, out dbl_pWPSThickness);
if (dbl_pWPSThickness > 0)
{
str_Filter = str_Filter + string.Format(" And (WPSThickness = {0} or WPSThicknessSecond = {0})", dbl_pWPSThickness);
}
}
EventArgs_WPSQuery g = new EventArgs_WPSQuery(str_Filter);
Publisher_WPSQuery.OnEventName(g);
}
