private void Query2() { int selectedHandle = this.gv_GPKPJH.FocusedRowHandle;//获取焦点行索引 if (selectedHandle < 0) { return; } string grd = this.gv_GPKPJH.GetRowCellValue(selectedHandle, "C_STL_GRD").ToString(); //获取焦点行钢种 string std = this.gv_GPKPJH.GetRowCellValue(selectedHandle, "C_STD_CODE").ToString(); //获取焦点行执行标准 txt_JHZS.Text = this.gv_GPKPJH.GetRowCellValue(selectedHandle, "N_QTY").ToString(); //获取计划支数 planid = this.gv_GPKPJH.GetRowCellValue(selectedHandle, "C_PLAN_ID").ToString(); //获取计划号 string sta = this.gv_GPKPJH.GetRowCellValue(selectedHandle, "C_STA_ID").ToString(); //获取工序 string slabwh = ""; if (sta == "33AD76AADC184E1F9B8DD0539B09CDC6") { slabwh = "526"; } if (sta == "1ED8E5A18B854429B1246B4AFA8426FE") { slabwh = "530"; } DataTable dt = null; dt = bll_TSC_SLAB_MAIN.GetList("", "", "", "", "", grd, std, "E", slabwh).Tables[0]; this.gc_GP1.DataSource = dt; this.gv_GP1.OptionsView.ColumnAutoWidth = false; this.gv_GP1.OptionsSelection.MultiSelect = true; gv_GP1.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CheckBoxRowSelect; this.colC_STA_ID.ColumnEdit = sub.GetGWIdDescItemComboBox(); this.gv_GP1.BestFitColumns(); SetGridViewRowNum.SetRowNum(gv_GP1); }
private void Query() { if (cbo_FA.Text == "") { return; } DataTable dt = null; if (rbtn_N.Checked) { dt = bll_ini_order.ROLLGetIniOrderByIniID(cbo_FA.EditValue.ToString(), txt_GZ.Text.Trim(), txt_ZXBZ.Text.Trim(), cbo_GG1.EditValue.ToString(), cbo_GG2.EditValue.ToString(), cbo_GW1.EditValue.ToString(), 0); } if (rbtn_Y.Checked) { dt = bll_ini_order.ROLLGetIniOrderByIniID(cbo_FA.EditValue.ToString(), txt_GZ.Text.Trim(), txt_ZXBZ.Text.Trim(), cbo_GG1.EditValue.ToString(), cbo_GG2.EditValue.ToString(), cbo_GW1.EditValue.ToString(), 1); } this.gc_DDFA.DataSource = dt; this.gv_DDFA.OptionsView.ColumnAutoWidth = false; this.gv_DDFA.OptionsSelection.MultiSelect = true; this.gv_DDFA.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CheckBoxRowSelect; C_ROLL_STA_ID.ColumnEdit = commonSub.GetGWIdDescItemComboBox(); this.gv_DDFA.BestFitColumns(); SetGridViewRowNum.SetRowNum(gv_DDFA); gv_DDFA_Click(); }
private void Query() { DataTable dt = bll_TPB_STA_MOVETIME.GetListByGXGW(cbo_GX1.EditValue.ToString(), cbo_GW.EditValue.ToString(), "1").Tables[0]; this.gc_GWYDSJ.DataSource = dt; this.gv_GWYDSJ.OptionsView.ColumnAutoWidth = false; //不允许自动列宽 this.gv_GWYDSJ.OptionsSelection.MultiSelect = true; //允许多选 this.gv_GWYDSJ.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CheckBoxRowSelect; colC_STA_ID1.ColumnEdit = commonSub.GetGWIdDescItemComboBox(); colC_STA_ID2.ColumnEdit = commonSub.GetGWIdDescItemComboBox(); this.gv_GWYDSJ.BestFitColumns(); SetGridViewRowNum.SetRowNum(gv_GWYDSJ); }
private void Query() { DataTable dt = null; dt = bll_order.GetList(" C_SFPJ ='Y' ").Tables[0]; this.gc_DDFA.DataSource = dt; this.gv_DDFA.OptionsView.ColumnAutoWidth = false; this.gv_DDFA.OptionsSelection.MultiSelect = true; this.gv_DDFA.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CheckBoxRowSelect; colC_LINE_NO.ColumnEdit = commonSub.GetGWIdDescItemComboBox(); this.gv_DDFA.BestFitColumns(); SetGridViewRowNum.SetRowNum(gv_DDFA); }
private void Query() { this.lbl_id.Text = ""; DataTable dt = bll_TPB_STA_MOVETIME.GetList(cbo_QSGW2.EditValue.ToString(), cbo_JSGW2.EditValue.ToString(), this.rbtn_isty_gx.SelectedIndex.ToString() == "0" ? "1" : "0").Tables[0]; this.gc_GWYDSJ.DataSource = dt; this.gv_GWYDSJ.OptionsView.ColumnAutoWidth = false; //不允许自动列宽 this.gv_GWYDSJ.OptionsSelection.MultiSelect = true; //允许多选 this.gv_GWYDSJ.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CheckBoxRowSelect; colC_STA_ID1.ColumnEdit = commonSub.GetGWIdDescItemComboBox(); colC_STA_ID2.ColumnEdit = commonSub.GetGWIdDescItemComboBox(); this.gv_GWYDSJ.BestFitColumns(); GetFoucs(); SetGridViewRowNum.SetRowNum(gv_GWYDSJ); }
/// <summary> /// 查询 /// </summary> private void Query() { DataTable dt = null; string cx = strStaID; dt = bll_TPB_STA_HOOK_NO.GetListBySTA(cx, "", "").Tables[0]; this.gc_CXPG.DataSource = dt; this.vGridControl1.DataSource = dt; DataTable dtno = bll_TPB_STA_HOOK_NO.GetFreeNO(strStaID); if (dtno.Rows.Count > 0) { this.cbo_PGH.Text = ""; this.cbo_PGH.Properties.Items.Clear(); for (int i = 0; i < dtno.Rows.Count; i++) { this.cbo_PGH.Properties.Items.Add(dtno.Rows[i]["N_NO"].ToString()); } } else { this.cbo_PGH.Text = ""; this.cbo_PGH.Properties.Items.Clear(); } this.gv_CXPG.OptionsView.ColumnAutoWidth = false; this.colC_STA_ID.ColumnEdit = sub.GetGWIdDescItemComboBox(); this.gv_CXPG.BestFitColumns(); SetGridViewRowNum.SetRowNum(gv_CXPG); }
private void Query2() { try { WaitingFrom.ShowWait(""); DataTable alldt = null; alldt = bll_TPB_STATION_CAPACITY.GetList(1, cbo_GX2.EditValue.ToString(), cbo_GW2.EditValue.ToString(), txt_GZ2.Text, cbo_GG2.Text, "").Tables[0]; this.gc_GWJSCL.DataSource = alldt; this.gv_GWJSCL.OptionsView.ColumnAutoWidth = false; this.gv_GWJSCL.OptionsSelection.MultiSelect = true; this.gv_GWJSCL.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CheckBoxRowSelect; this.colC_STA_ID.ColumnEdit = sub.GetGWIdDescItemComboBox(); this.gv_GWJSCL.BestFitColumns(); SetGridViewRowNum.SetRowNum(gv_GWJSCL); //if (rbtn_isty.SelectedIndex == 0) //{ // this.btn_Stop.Enabled = true; //} //else //{ // this.btn_Stop.Enabled = false; //} WaitingFrom.CloseWait(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
/// <summary> /// 查询产线规格 /// </summary> private void QueryGG() { DataTable dt = null; if (this.rbtn_isty2.SelectedIndex == 0) { dt = bll_TPB_LINE_SPEC.GetSpecListBySTA(1, imgcbo_cx2.EditValue.ToString()).Tables[0]; } else { dt = bll_TPB_LINE_SPEC.GetSpecListBySTA(0, imgcbo_cx2.EditValue.ToString()).Tables[0]; } this.gc_ZGCXGG.DataSource = dt; this.gv_ZGCXGG.OptionsView.ColumnAutoWidth = false; this.gv_ZGCXGG.OptionsSelection.MultiSelect = true; this.gv_ZGCXGG.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CheckBoxRowSelect; colC_STA_ID.ColumnEdit = sub.GetGWIdDescItemComboBox(); this.gv_ZGCXGG.BestFitColumns(); SetGridViewRowNum.SetRowNum(gv_ZGCXGG); }
private void Query() { DataTable dt = bll_TPB_CC_CHANGE_TIME.GetListBySTA("").Tables[0]; this.gc_GWCN.DataSource = dt; this.gv_GWCN.OptionsView.ColumnAutoWidth = false; //不允许自动列宽 this.gv_GWCN.OptionsSelection.MultiSelect = true; //允许多选 gv_GWCN.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CheckBoxRowSelect; //加载checkBox colC_STA_ID.ColumnEdit = commonSub.GetGWIdDescItemComboBox(); this.gv_GWCN.BestFitColumns(); SetGridViewRowNum.SetRowNum(gv_GWCN); }
private void Query() { DataTable dt = bll.GetList(cbo_GX2.EditValue.ToString(), "", 1).Tables[0]; this.gc_GWCN.DataSource = dt; this.gv_GWCN.OptionsView.ColumnAutoWidth = false; //不允许自动列宽 this.gv_GWCN.OptionsSelection.MultiSelect = true; //允许多选 gv_GWCN.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CheckBoxRowSelect; //加载checkBox colC_PRO_ID.ColumnEdit = commonSub.GetGXIdDescItemComboBox(); colC_STA_ID.ColumnEdit = commonSub.GetGWIdDescItemComboBox(); this.gv_GWCN.BestFitColumns(); SetGridViewRowNum.SetRowNum(gv_GWCN); }
/// <summary> /// 查询产线不生产钢种 /// </summary> private void QueryBGZ() { DataTable dt = null; dt = bll_TPB_N_GRD.GetList(1, imgcbo_cx1.EditValue.ToString(), txtGZ1.Text, txtBZ1.Text).Tables[0]; this.gc_ZGBSCGZ.DataSource = dt; this.gv_ZZGBSCGZ.OptionsView.ColumnAutoWidth = false; this.gv_ZZGBSCGZ.OptionsSelection.MultiSelect = true; this.gv_ZZGBSCGZ.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CheckBoxRowSelect; gridColumn18.ColumnEdit = sub.GetGWIdDescItemComboBox(); this.gv_ZZGBSCGZ.BestFitColumns(); SetGridViewRowNum.SetRowNum(gv_ZZGBSCGZ); }
/// <summary> /// 查询生产影响记录 /// </summary> public void BindInfo() { WaitingFrom.ShowWait(""); lst = bll.GetModelList(cbo_GW.EditValue.ToString(), txt_stove.Text.Trim(), txt_grd.Text, dt_st.DateTime, dt_et.DateTime); this.gc_GP.DataSource = lst; this.gv_GP.OptionsView.ColumnAutoWidth = false; //不允许自动列宽 this.gv_GP.OptionsSelection.MultiSelect = true; //允许多选 gv_GP.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CheckBoxRowSelect; //加载checkBox gridColumn18.ColumnEdit = sub.GetGWIdDescItemComboBox(); this.gv_GP.BestFitColumns(); SetGridViewRowNum.SetRowNum(gv_GP); WaitingFrom.CloseWait(); }
/// <summary> /// 查询 /// </summary> private void Query() { DataTable dt = null; string cx = "";/* this.cbo_GW1.Properties.Items[this.cbo_GW1.SelectedIndex].Value.ToString();*/ dt = bll_TPB_STA_HOOK_NUM.GetListByStatus(1, cx).Tables[0]; this.gc_CXGS.DataSource = dt; this.gv_CXGS.OptionsView.ColumnAutoWidth = false; this.gv_CXGS.OptionsSelection.MultiSelect = true; //gv_CXGS.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CheckBoxRowSelect; this.colC_STA_ID.ColumnEdit = sub.GetGWIdDescItemComboBox(); this.gv_CXGS.BestFitColumns(); SetGridViewRowNum.SetRowNum(gv_CXGS); }
private void Query2() { DataTable dt = null; string gz = ""; string zxbz = ""; dt = bll_TPB_STEEL_SMELT_TIME.GetList(1, cbo_GX2.EditValue.ToString(), cbo_GW2.EditValue.ToString(), gz, zxbz).Tables[0]; this.gc_GWJSCL.DataSource = dt; this.gv_GWJSCL.OptionsView.ColumnAutoWidth = false; this.gv_GWJSCL.OptionsSelection.MultiSelect = true; this.gv_GWJSCL.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CheckBoxRowSelect; colC_STA_ID.ColumnEdit = sub.GetGWIdDescItemComboBox(); this.gv_GWJSCL.BestFitColumns(); SetGridViewRowNum.SetRowNum(gv_GWJSCL); }
private void Query2() { int selectedHandle = this.gv_GPXMJH.FocusedRowHandle;//获取焦点行索引 if (selectedHandle < 0) { return; } string grd = this.gv_GPXMJH.GetRowCellValue(selectedHandle, "C_STL_GRD").ToString(); //获取焦点行钢种 string std = this.gv_GPXMJH.GetRowCellValue(selectedHandle, "C_STD_CODE").ToString(); //获取焦点行执行标准 txt_XMZS.Text = this.gv_GPXMJH.GetRowCellValue(selectedHandle, "N_QTY").ToString(); //获取计划支数 planid = this.gv_GPXMJH.GetRowCellValue(selectedHandle, "C_ID").ToString(); //获取计划号 DataTable dt = null; dt = bll_TSC_SLAB_MAIN.GetList("", "", "", "", "", grd, std, "E", "570").Tables[0]; this.gc_GP1.DataSource = dt; this.gv_GP1.OptionsView.ColumnAutoWidth = false; this.gv_GP1.OptionsSelection.MultiSelect = true; gv_GP1.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CheckBoxRowSelect; this.colC_STA_ID.ColumnEdit = sub.GetGWIdDescItemComboBox(); this.gv_GP1.BestFitColumns(); SetGridViewRowNum.SetRowNum(gv_GP1); }
/// <summary> /// 轧钢计划 /// </summary> private void Query1() { if (cbo_QS.Text == "") { return; } DataTable dt = null; dt = bll_TRP_PLAN_ROLL.GetList(0, cbo_FA.EditValue.ToString(), cbo_GW1.EditValue.ToString()).Tables[0]; this.gc_ZGJH.DataSource = dt; this.gv_ZGJH.OptionsView.ColumnAutoWidth = false; colC_STA_ID.ColumnEdit = commonSub.GetGWIdDescItemComboBox(); this.gv_ZGJH.BestFitColumns(); SetGridViewRowNum.SetRowNum(gv_ZGJH); }
private void QueryMain() { WaitingFrom.ShowWait(""); DataTable dt = null; dt = bll_TPB_SLAB_CAPACITY.GetList(cbo_GW2.EditValue.ToString(), "", txt_GZ2.Text, 1, txt_ZXBZ.Text, cbo_YS2.EditValue.ToString()).Tables[0]; this.gc_GWJSCL.DataSource = dt; this.gv_GWJSCL.OptionsView.ColumnAutoWidth = false; this.gv_GWJSCL.OptionsSelection.MultiSelect = true; gv_GWJSCL.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CheckBoxRowSelect; this.colC_STA_ID.ColumnEdit = sub.GetGWIdDescItemComboBox(); this.gv_GWJSCL.BestFitColumns(); SetGridViewRowNum.SetRowNum(gv_GWJSCL); WaitingFrom.CloseWait(); }
private void Query2() { WaitingFrom.ShowWait(""); DataTable alldt = null; alldt = bll_TPB_CAST_STOVE.GetList(1, txt_GZ2.Text, txt_ZXBZ2.Text, cbo_GW2.EditValue.ToString()).Tables[0]; this.gc_ZJCLS.DataSource = alldt; this.gv_ZJCLS.OptionsView.ColumnAutoWidth = false; this.gv_ZJCLS.OptionsSelection.MultiSelect = true; this.gv_ZJCLS.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CheckBoxRowSelect; colC_STA_ID.ColumnEdit = sub.GetGWIdDescItemComboBox(); this.gv_ZJCLS.BestFitColumns(); SetGridViewRowNum.SetRowNum(gv_ZJCLS); //if (rbtn_isty.SelectedIndex == 0) //{ // this.btn_Stop.Enabled = true; //} //else //{ // this.btn_Stop.Enabled = false; //} WaitingFrom.CloseWait(); }
private void FrmPB_ZXHGGSJ_Load(object sender, EventArgs e) { try { UserButtonRight.GetBtnFun(this, RV.UI.UserInfo.menuID); strMenuName = RV.UI.UserInfo.menuName; cbo_CX1.EditValue = ""; cbo_CX2.EditValue = ""; cbo_GHQ.EditValue = ""; cbo_GHH.EditValue = ""; sub.ImageComboBoxEditBindGWByGX("ZX", this.cbo_CX1); cbo_CX1.SelectedIndex = 0; sub.ImageComboBoxEditBindGWByGX("ZX", this.cbo_CX2); cbo_CX2.Properties.Items.Add("全部", "", 0); cbo_CX2.SelectedIndex = cbo_CX2.Properties.Items.Count - 1; this.colC_STA_ID.ColumnEdit = sub.GetGWIdDescItemComboBox(); Query(); BindGWJSCL(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }