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); } }