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