private void gv_HG_Click(object sender, EventArgs e)
{
try
{
int row = gv_HG.FocusedRowHandle;
DataRow dr = gv_HG.GetDataRow(row);
DataTable dt = null;
dt = bll_TPP_HJXQ.GetXQList(dr["c_alloy_code"].ToString(), dt_Start.DateTime, dt_End.DateTime).Tables[0];
this.gc_XQ.DataSource = dt;
this.gv_XQ.OptionsView.ColumnAutoWidth = false;
this.gv_XQ.OptionsSelection.MultiSelect = true;
gv_XQ.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CheckBoxRowSelect;
SetGridViewRowNum.SetRowNum(gv_XQ);
}
catch (Exception ex)
{
}
}
/// <summary>
/// 绑定物理性能分组信息
/// </summary>
private void BindWL()
{
try
{
WaitingFrom.ShowWait("");
gc_Wl.DataSource = null;
DataTable dt = bllTqbPhysicsGroup.GetAllList().Tables[0];
gc_Wl.DataSource = dt;
SetGridViewRowNum.SetRowNum(gv_Wl);
WaitingFrom.CloseWait();
}
catch
{
}
}
private void NewMethod1()
{
try
{
WaitingFrom.ShowWait("");
DataTable dt = bllReheting.Getlist_Query(txt_GZ.Text.Trim()).Tables[0];
this.gc_Time.DataSource = dt;
gv_Time.BestFitColumns();
SetGridViewRowNum.SetRowNum(gv_Time);
WaitingFrom.CloseWait();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 执行标准明细 取样信息
/// </summary>
/// <param name="str"></param>
private void NewMethod3(string str)
{
try
{
Bll_TQB_STD_SAMPLING bll_stdSampaing = new Bll_TQB_STD_SAMPLING();
DataTable dt_stdSampaning = bll_stdSampaing.GetList("C_STD_MAIN_ID='" + str + "'").Tables[0];
//冻结有焦点的列
gv_StdQY.Columns[0].Fixed = DevExpress.XtraGrid.Columns.FixedStyle.Left;
gv_StdQY.Columns[1].Fixed = DevExpress.XtraGrid.Columns.FixedStyle.Left;
this.gc_StdQY.DataSource = dt_stdSampaning;
gv_StdQY.BestFitColumns();
SetGridViewRowNum.SetRowNum(gv_StdQY);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_Query_Click(object sender, EventArgs e)
{
try
{
WaitingFrom.ShowWait("");
DataTable dt = bll.Get_Slab_List(txt_Mat_Code.Text, txt_Mat_Name.Text, txt_GRD.Text, txt_Slab_Size.Text).Tables[0];
gc_Matrl.DataSource = dt;
gv_Matrl.BestFitColumns();
SetGridViewRowNum.SetRowNum(gv_Matrl);
WaitingFrom.CloseWait();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btn_TB_Click(object sender, EventArgs e)
{
int selectedPlanHandle = this.gv_ZGSJ.FocusedRowHandle; //获取计划焦点行索引
string id = this.gv_ZGSJ.GetRowCellValue(selectedPlanHandle, "C_ID").ToString(); //获取焦点主键
if (bll_TB_AUTO_SYNC_USER.UpdateUser(id, txt_num.Text.Trim()))
{
MessageBox.Show("操作成功");
DataTable dt = bll_TB_AUTO_SYNC_USER.GetList("").Tables[0];
this.gc_ZGSJ.DataSource = dt;
this.gv_ZGSJ.OptionsView.ColumnAutoWidth = false;
SetGridViewRowNum.SetRowNum(gv_ZGSJ);
}
else
{
MessageBox.Show("操作失败");
}
}
private void BindMain()
{
try
{
WaitingFrom.ShowWait("");
gc_Main.DataSource = null;
DataTable dt = bllTqbSampModle.GetList(txt_BZ.Text.Trim(), txt_GZ.Text.Trim()).Tables[0];
gc_Main.DataSource = dt;
SetGridViewRowNum.SetRowNum(gv_Main);
WaitingFrom.CloseWait();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void BindInfo()
{
try
{
WaitingFrom.ShowWait("");
DataTable dt = bllTrpPlanReason.Get_List(dt_Start.Text.Trim(), dt_End.Text.Trim(), txt_Grd.Text.Trim(), txt_Std.Text.Trim(), txt_Spec.Text.Trim()).Tables[0];
gc_Log.DataSource = dt;
SetGridViewRowNum.SetRowNum(gv_Log);
WaitingFrom.CloseWait();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btn_Query_Click(object sender, EventArgs e)
{
try
{
WaitingFrom.ShowWait("");
DataTable dt = bllLog.Get_List(txt_BatchNo.Text.Trim(), dt_Start.Text.Trim(), dt_End.Text.Trim()).Tables[0];
gc_Log.DataSource = dt;
SetGridViewRowNum.SetRowNum(gv_Log);
WaitingFrom.CloseWait();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void gridView1_Click(object sender, EventArgs e)
{
try
{
int selectedHandle;
selectedHandle = this.gridView1.FocusedRowHandle;
string C_ID = this.gridView1.GetRowCellValue(selectedHandle, "计划订单号").ToString();
DataTable dt = bllTrpPlanRoll.GetOrderProInfoByOrderNo(C_ID);
this.gridControl2.DataSource = dt;
this.gridView2.OptionsView.ColumnAutoWidth = false;
SetGridViewRowNum.SetRowNum(gridView2);
this.gridView2.BestFitColumns();
}
catch (Exception)
{
}
}
private void NewMethod()
{
try
{
WaitingFrom.ShowWait("");
DataTable dt = bll_StdMain.GetList_GroupStlGrd(txt_Grd.Text.Trim(), txt_STD_CODE.Text.Trim()).Tables[0];
this.gc_StdMain.DataSource = dt;
gv_StdMain.BestFitColumns();
SetGridViewRowNum.SetRowNum(gv_StdMain);
WaitingFrom.CloseWait();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 物理检验项目配置查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void NewMethod()
{
try
{
string str = "";
DataRow dr_wljyfz = this.gv_wljyfz.GetDataRow(this.gv_wljyfz.FocusedRowHandle);
if (dr_wljyfz != null)
{
str = dr_wljyfz["C_ID"].ToString();
}
DataTable dt_wljyxmpz = bll_PHYSICS_CONFIGURE.GetList("a.C_PHYSICS_GROUP_ID = '" + str + "' and a.N_STATUS =1 ").Tables[0];
string row = "";
for (int i = 0; i < dt_wljyxmpz.Rows.Count; i++)
{
row += "'" + dt_wljyxmpz.Rows[i]["C_CODE"].ToString() + "',";
}
DataTable dt_jcsj = new DataTable();
if (row.Length > 0)
{
row = row.Substring(0, row.Length - 1);
dt_jcsj = bll_CHARACTER.GetCharacterList(row, txt_Name1.Text.Trim()).Tables[0];
}
else
{
dt_jcsj = bll_CHARACTER.GetCharacterList("", txt_Name1.Text.Trim()).Tables[0];
}
gc_wljyxmpz.DataSource = dt_wljyxmpz;
gc_jcsj.DataSource = dt_jcsj;
gv_wljyxmpz.BestFitColumns();
gv_jcsj.BestFitColumns();
SetGridViewRowNum.SetRowNum(gv_wljyxmpz);
SetGridViewRowNum.SetRowNum(gv_jcsj);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void BindItem(string str_id)
{
DataTable dt = bllTqcPhysicsResult.Get_XNList(strPhyCode, str_id).Tables[0];
gc_ITEM.DataSource = dt;
SetGridViewRowNum.SetRowNum(gv_ITEM);
Mod_TQC_PHYSICS_RESULT_MAIN mod = bllTqcPhyResultMain.GetModel(str_id);
if (mod != null)
{
cbo_SB.Text = mod.C_EQ_NAME;
if (!string.IsNullOrEmpty(mod.C_TEMP))
{
txt_WD.Text = mod.C_TEMP;
}
if (!string.IsNullOrEmpty(mod.C_HUMIDITY))
{
txt_SD.Text = mod.C_HUMIDITY;
}
if (!string.IsNullOrEmpty(mod.C_BC))
{
icbo_BC.Text = mod.C_BC;
}
if (!string.IsNullOrEmpty(mod.C_BZ))
{
icbo_BZ.Text = mod.C_BZ;
}
if (!string.IsNullOrEmpty(mod.C_CHECK_USER))
{
icbo_User.Text = mod.C_CHECK_USER;
}
else
{
icbo_User.Text = "";
}
}
}
/// <summary>
/// 查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_Query_Click(object sender, EventArgs e)
{
try
{
WaitingFrom.ShowWait("");
gc_StdMain.DataSource = null;
DataTable dt = bllMatrlMain.GetList_DFPCD(txt_CD.Text.Trim()).Tables[0];
gc_StdMain.DataSource = dt;
gv_StdMain.BestFitColumns();
SetGridViewRowNum.SetRowNum(gv_StdMain);
WaitingFrom.CloseWait();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 查询批号信息
/// </summary>
private void BindBatchList()
{
try
{
WaitingFrom.ShowWait("");
gc_Batch.DataSource = null;
DataTable dt = bllTrcRollProdcut.GetList_TB(dt_Start.Text.Trim(), dt_End.Text.Trim(), txt_BatchNo.Text.Trim()).Tables[0];
gc_Batch.DataSource = dt;
SetGridViewRowNum.SetRowNum(gv_Batch);
WaitingFrom.CloseWait();
}
catch
{
}
}
private void BindItemNC(string C_BATCH_NO, string C_MAT_CODE)
{
string batch_head = C_BATCH_NO.Substring(0, 1);
string strMATTYPE = C_MAT_CODE.Substring(0, 3);
DataTable dt_item = new DataTable();;
if (strMATTYPE == "805" && batch_head != "3")
{
dt_item = bllTqcCompreItemResult.Get_NC_Item_List_WW(C_BATCH_NO).Tables[0];
}
else if (batch_head == "3" || strMATTYPE == "807" || strMATTYPE == "806")
{
dt_item = bllTqcCompreItemResult.Get_NC_Item_List_PT(C_BATCH_NO).Tables[0];
}
gc_Item_NC.DataSource = dt_item;
SetGridViewRowNum.SetRowNum(gv_Item_NC);
}
private void BindList()
{
try
{
WaitingFrom.ShowWait("");
DataTable dt = bllTspCastPlan.GetStopPlan(icbo_lz3.Properties.Items[this.icbo_lz3.SelectedIndex].Value.ToString(), dt_Start.Text.Trim(), dt_End.Text.Trim());
gc_Lgfx.DataSource = dt;
gv_Lgfx.BestFitColumns();
SetGridViewRowNum.SetRowNum(gv_Lgfx);
WaitingFrom.CloseWait();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_Query1_Click(object sender, EventArgs e)
{
try
{
WaitingFrom.ShowWait("");
DataTable dt = bll.GetList(dte_Begin.DateTime, dte_End.DateTime, txt_Stove1.Text.Trim()).Tables[0];
gc_GPGP.DataSource = dt;
gv_GPGP.BestFitColumns();
SetGridViewRowNum.SetRowNum(gv_GPGP);
WaitingFrom.CloseWait();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void QueryTS()
{
try
{
DataTable dt = null;
dt = bll_TQB_STD_MAIN.GetListByWWHTSTJ().Tables[0];
this.gc_TSTJ.DataSource = dt;
this.gv_TSTJ.OptionsView.ColumnAutoWidth = false;
this.gv_TSTJ.OptionsSelection.MultiSelect = true;
gv_TSTJ.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CheckBoxRowSelect;
//this.colC_STA_ID.ColumnEdit = sub.GetGWIdDescItemComboBox(); //翻译工位
this.gv_TSTJ.BestFitColumns();
SetGridViewRowNum.SetRowNum(gv_TSTJ);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void Query1()
{
try
{
WaitingFrom.ShowWait("");
DataTable dt = bll_roll_product.GetList_XL(dte_Begin1.DateTime, dte_End1.DateTime, txt_BatchNo1.Text.Trim()).Tables[0];
gc_SJXX.DataSource = dt;
gv_SJXX.BestFitColumns();
SetGridViewRowNum.SetRowNum(gv_SJXX);
WaitingFrom.CloseWait();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void NewMethod2()
{
try
{
DataRow dr = gv_std_main.GetDataRow(gv_std_main.FocusedRowHandle);
if (dr == null)
{
return;
}
DataTable dt = bll_GzCheck.Query(dr["C_ID"].ToString()).Tables[0];
gc_std_check.DataSource = dt;
gv_std_check.BestFitColumns();
SetGridViewRowNum.SetRowNum(gv_std_check);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btn_query_zg_Click(object sender, EventArgs e)
{
WaitingFrom.ShowWait("");
string strLineID = "";
if (this.icbo_zx4.SelectedIndex > 0)
{
strLineID = icbo_zx4.Properties.Items[this.icbo_zx4.SelectedIndex].Value.ToString();
}
string strSFZP = "";
int SFXF = 0;
if (this.rbtn_zg.SelectedIndex == 0)
{
SFXF = 0;
strSFZP = "";
}
if (this.rbtn_zg.SelectedIndex == 1)
{
SFXF = 1;
strSFZP = "";
}
if (this.rbtn_zg.SelectedIndex == 2)
{
SFXF = 1;
strSFZP = "Y";
}
DataTable dt = bll_plan.GetZGJH(strLineID, SFXF, txt_gz4.Text.Trim(), "", txt_bz4.Text.Trim(), strSFZP).Tables[0];
AutoSort(dt);
dt = bll_plan.GetZGJH(strLineID, this.rbtn_zg.SelectedIndex, txt_gz4.Text.Trim(), "", txt_bz4.Text.Trim(), strSFZP).Tables[0];
dtzgjh = dt;
this.gridControl1.DataSource = dt;
this.gridView1.OptionsView.ColumnAutoWidth = false;
this.gridView1.OptionsSelection.MultiSelect = true;
gridView1.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CheckBoxRowSelect;
SetGridViewRowNum.SetRowNum(gridView1);
this.gridView1.BestFitColumns();
WaitingFrom.CloseWait();
}
/// <summary>
/// 轧钢实绩查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_Query_Main_Click(object sender, EventArgs e)
{
try
{
WaitingFrom.ShowWait("");
string pland = imgcbo_CJ.EditValue.ToString();
string batch = txt_BatchNo.Text;
DataTable dt = bll_TRC_Roll_Product.GetList_Query(Convert.ToDateTime(dte_Begin.DateTime), Convert.ToDateTime(dte_End.DateTime), pland, batch).Tables[0];
this.gc_SJXX.DataSource = dt;
gv_SJXX.BestFitColumns();
SetGridViewRowNum.SetRowNum(gv_SJXX);
gv_SJXX_FocusedRowChanged(null, null);
WaitingFrom.CloseWait();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void FYDQuery()
{
try
{
DataTable dt = null;
dt = bll_TMD_DISPATCH.GetCPH(2, txt_CPH.Text).Tables[0];
this.gc_GP.DataSource = dt;
this.gv_GP.OptionsView.ColumnAutoWidth = false;
this.gv_GP.OptionsSelection.MultiSelect = true;
gv_GP.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CheckBoxRowSelect;
//this.colC_STA_ID.ColumnEdit = sub.GetGWIdDescItemComboBox(); //翻译工位
this.gv_GP.BestFitColumns();
SetGridViewRowNum.SetRowNum(gv_GP);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void BindList()
{
try
{
WaitingFrom.ShowWait("");
DataTable dt = bllLog.GetList(txt_Batch.Text.Trim(), dt_Start.Text.Trim(), dt_End.Text.Trim()).Tables[0];
gridControl1.DataSource = dt;
SetGridViewRowNum.SetRowNum(gridView1);
WaitingFrom.CloseWait();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 查询质量设计结果明细
/// </summary>
private void BindDesignItemRoll(string strDesignNo, string strStdCode, string strGrd)
{
try
{
gc_DesignItem.DataSource = null;
DataTable dt = bllDesign.GetDesignItemRoll(strDesignNo, strStdCode, strGrd, "1").Tables[0];
if (dt == null)
{
return;
}
gc_DesignItem.DataSource = dt;
gv_DesignItem.BestFitColumns();
SetGridViewRowNum.SetRowNum(gv_DesignItem);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_Query_Click(object sender, EventArgs e)
{
WaitingFrom.ShowWait("");
try
{
WaitingFrom.ShowWait("");
DataTable dt = bll_stdmain.GetList_QueryStdMatrl(txt_Std.Text.Trim(), txt_STL.Text.Trim()).Tables[0];
this.gc_Matrl.DataSource = dt;
gv_Matrl.BestFitColumns();
SetGridViewRowNum.SetRowNum(gv_Matrl);
WaitingFrom.CloseWait();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
WaitingFrom.CloseWait();
}
/// <summary>
/// 绑定制样主表信息
/// </summary>
private void BindZYXX()
{
WaitingFrom.ShowWait("");
gc_ZYXX.DataSource = null;
DataTable dt = bllTqcPhysicsResult.Get_XN_CWSX_List(dt_Start.Text.Trim(), dt_End.Text.Trim(), txt_BatchNo.Text.Trim()).Tables[0];
gc_ZYXX.DataSource = dt;
gv_ZYXX.BestFitColumns();
SetGridViewRowNum.SetRowNum(gv_ZYXX);
gv_ZYXX.Columns[13].Caption = "录入人";
gv_ZYXX.Columns[1].Visible = false;
gv_ZYXX.Columns[2].Visible = false;
WaitingFrom.CloseWait();
}
private void Query1()
{
try
{
WaitingFrom.ShowWait("");
DataTable dt = bll_Update.GetList_Query_date(dte_Begin1.DateTime, dte_End1.DateTime, txt_BatchNo1.Text.Trim(), "1", "3").Tables[0];
gc_XL.DataSource = dt;
gv_XL.BestFitColumns();
SetGridViewRowNum.SetRowNum(gv_XL);
WaitingFrom.CloseWait();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void BindList()
{
try
{
gc_Route.DataSource = null;
string RH = "";
string DHL = "";
string KP = "";
string HL = "";
string XM = "";
if (chk_RH1.Checked)
{
RH = "RH";
}
if (chk_DFPHL1.Checked)
{
DHL = "DHL";
}
if (chk_KP1.Checked)
{
KP = "KP";
}
if (chk_HL1.Checked)
{
HL = "HL";
}
if (chk_XM1.Checked)
{
XM = "XM";
}
WaitingFrom.ShowWait("");
DataTable dt = bllRoute.GetList(RH, DHL, KP, HL, XM, txt_Std_Query.Text.Trim(), txt_Grd1.Text.Trim(), strPhyCode).Tables[0];
gc_Route.DataSource = dt;
gv_Route.BestFitColumns();
SetGridViewRowNum.SetRowNum(gv_Route);
WaitingFrom.CloseWait();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
