private void setCondition()
{
string chose = "";
if (txtChose.Text.Trim() != "")
{
chose = txtChose.Value.ToString();
string pmodel = "", so = "", plancode = "", plinecode = "", xl = "", scode = "", pos = "";
switch (chose)
{
case "A":
string sql = "SELECT product_model,plan_so,plan_code,pline_code FROM DATA_PRODUCT where sn='" + txtSN.Text.Trim() + "'";
DataTable dt = dc.GetTable(sql);
if (dt.Rows.Count <= 0)
{
return;
}
else
{
pmodel = dt.Rows[0][0].ToString();
so = dt.Rows[0][1].ToString();
plancode = dt.Rows[0][2].ToString();
plinecode = dt.Rows[0][3].ToString();
string sql2 = "select xl from copy_engine_property where so='" + so.ToUpper() + "' and rownum=1 ";
DataTable dt2 = dc.GetTable(sql2);
if (dt2.Rows.Count > 0)
{
xl = dt2.Rows[0][0].ToString();
}
if (plinecode == "E")
{
scode = "ZDE068";
}
if (plinecode == "W")
{
scode = "ZD910";
}
if (plinecode == "R")
{
scode = "RONE001";
}
//else
//{
// ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail");
// ASPxGridView1.JSProperties.Add("cpCallbackRet", "没有记录！");
//}
PL_QUERY_BOMZJTS3 sp = new PL_QUERY_BOMZJTS3()
{
SO1 = so,
ZDDM1 = scode,
GZDD1 = plinecode,
FDJXL1 = xl,
JHDM1 = plancode
};
Procedure.run(sp);
PL_UPDATE_BOMZJTS_CRM3 sp2 = new PL_UPDATE_BOMZJTS_CRM3()
{
SO1 = so,
ZDDM1 = scode,
JHDM1 = plancode,
GZDD1 = plinecode
};
Procedure.run(sp2);
PL_UPDATE_BOMLSHTS3 sp3 = new PL_UPDATE_BOMLSHTS3()
{
LSH1 = txtSN.Text.Trim(),
ZDDM1 = scode
};
Procedure.run(sp3);
PL_UPDATE_BOMSOTHTS3 sp4 = new PL_UPDATE_BOMSOTHTS3()
{
SO1 = so,
JHDM1 = plancode,
ZDDM1 = scode
};
Procedure.run(sp4);
}
string ChSql1 = "select gwmc 工位,comp 零件代码,udesc 描述,qty 数量,gxmc 工序,gysmc 供应商 from rstbomqd_CRM where zddm='" + scode + "' order by gwmc,gxmc";
DataTable dt1 = dc.GetTable(ChSql1);
ASPxGridView1.DataSource = dt1;
ASPxGridView1.DataBind();
ASPxGridView2.DataSource = null;
ASPxGridView2.DataBind();
break;
case "B":
//string sql22 = "SELECT ggxhmc,so,jhdm FROM SJSXB WHERE GHTM='" + txtSN.Text.Trim() + "' ";
//DataTable dt22 = dc.GetTable(sql22);
//pmodel = dt22.Rows[0][0].ToString();
//so = dt22.Rows[0][1].ToString();
//plancode = dt22.Rows[0][2].ToString();
string ChSql2 = " SELECT item_code 零件代码,item_name 零件名称,item_qty 数量,process_code 工序,location_code 工位 FROM vw_data_plan_standard_bom WHERE plan_code='" + txtPlanCode.Text.Trim() + "' AND plan_so='" + txtSO.Text.Trim() + "' ORDER BY location_code,process_code";
DataTable dt22 = dc.GetTable(ChSql2);
ASPxGridView1.DataSource = dt22;
ASPxGridView1.DataBind();
string Csql2 = "SELECT ljdm1,ljdm2,gwmc FROM sjbomsoth WHERE so='" + txtSO.Text.Trim() + "'and jhdm='" + txtPlanCode.Text.Trim() + "' and istrue=1 order by gwmc,ljdm1";
DataTable dt12 = dc.GetTable(Csql2);
ASPxGridView2.DataSource = dt12;
ASPxGridView2.DataBind();
break;
case "C":
//string ChSql3 = "select LOCATION_CODE 工位,ITEM_CODE 零件代码,ITEM_NAME 零件名称,ITEM_CODE 数量,PROCESS_CODE 工序,STATION_CODE 站点,VENDOR_NAME 供应商 from VW_rstlshbomqd where SN='" + txtSN.Text.Trim() + "' order by LOCATION_CODE,PROCESS_CODE";
//DataTable dt3 = dc.GetTable(ChSql3);
//ASPxGridView1.DataSource = dt3;
//ASPxGridView1.DataBind();
break;
default:
ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail");
ASPxGridView1.JSProperties.Add("cpCallbackRet", "查询方式有误！");
break;
}
}
}
public void ASPxGridView1_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
DateTime DT1 = Convert.ToDateTime(ASPxDateEdit1.Text.Trim());
DateTime DT2 = Convert.ToDateTime(ASPxDateEdit2.Text.Trim());
if (DT1.AddDays(31) < DT2)
{
ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail");
ASPxGridView1.JSProperties.Add("cpCallbackRet", "选择日期范围不能超过31天，请重新选择！");
return;
}
else if (ASPxListBoxUsed.Items.Count <= 0)
{
ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail");
ASPxGridView1.JSProperties.Add("cpCallbackRet", " 请选择要查询的零件！");
return;
}
DataTable Table1 = new DataTable();
//string iteam_code = "";
Table1.Columns.Add("日期");
Table1.Columns.Add("SO");
Table1.Columns.Add("计划");
for (int a = 0; a < ASPxListBoxUsed.Items.Count; a++)
{
string part = ASPxListBoxUsed.Items[a].ToString();
Table1.Columns.Add(part + "----数量");
//Table1.Columns.Add(part+'▍↔'+"数量");
}
string plancode = "", PlanSo = "", PlanCode = "", RQbegin = "", plinecode = "", xl = "", scode = "";
string snSql = "select lsh,ptime from ATPUDQYQDYB where PTIME>=to_date('" + ASPxDateEdit1.Text.Trim() + "', 'yyyy-mm-dd hh24:mi:ss') and PTIME<=to_date('" + ASPxDateEdit2.Text.Trim() + "', 'yyyy-mm-dd hh24:mi:ss') ";
DataTable sndt = dc.GetTable(snSql);
for (int j = 0; j < sndt.Rows.Count; j++)
{
RQbegin = sndt.Rows[j][1].ToString();
string soSql = "select plan_code from data_plan_sn where sn='" + sndt.Rows[j][0].ToString() + "'";
DataTable sodt = dc.GetTable(soSql);
if (sodt.Rows.Count > 0)
{
plancode = sodt.Rows[0][0].ToString();
}
string sql1 = "select distinct begin_date,plan_so from data_plan where pline_code='" + txtPCode.Value.ToString() + "' and plan_code='" + plancode + "' ";
DataTable dt1 = dc.GetTable(sql1);
if (dt1.Rows.Count > 0)
{
PlanSo = dt1.Rows[0][1].ToString();
//RQbegin = dt1.Rows[0][0].ToString();
}
plinecode = txtPCode.Value.ToString();
PlanCode = plancode;
DataRow dr = Table1.NewRow();
dr[0] = RQbegin;
dr[1] = PlanSo;
dr[2] = PlanCode;
for (int i = 0; i < ASPxListBoxUsed.Items.Count; i++)
{
string part2 = ASPxListBoxUsed.Items[i].ToString();
//string sql2 = "(select a.item_code,a.item_qty from data_sn_bom a left join data_plan b on a.plan_code=b.plan_code where a.plan_code='" + PlanCode + "' and b.plan_so='" + PlanSo + "' and a.item_name='" + part2 + "') union "
// + "select a.item_code,a.item_qty from data_sn_bom_temp a left join data_plan b on a.plan_code=b.plan_code where a.plan_code='" + PlanCode + "' and b.plan_so='" + PlanSo + "' and a.item_name='" + part2 + "'";
//DataTable dt2 = dc.GetTable(sql2);
string sql3 = "select xl from copy_engine_property where so='" + PlanSo.ToUpper() + "' and rownum=1 ";
DataTable dt3 = dc.GetTable(sql3);
if (dt3.Rows.Count > 0)
{
xl = dt3.Rows[0][0].ToString();
}
if (plinecode == "E")
{
scode = "ZF5";
}
if (plinecode == "W")
{
scode = "ATPU-T560";
}
//if (plinecode == "R")
//{
// scode = "RONE001";
//}
PL_QUERY_BOMZJTS3 sp = new PL_QUERY_BOMZJTS3()
{
SO1 = PlanSo,
ZDDM1 = scode,
GZDD1 = plinecode,
FDJXL1 = xl,
JHDM1 = PlanCode
};
Procedure.run(sp);
PL_UPDATE_BOMZJTS_CRM3 sp2 = new PL_UPDATE_BOMZJTS_CRM3()
{
SO1 = PlanSo,
ZDDM1 = scode,
JHDM1 = PlanCode,
GZDD1 = plinecode
};
Procedure.run(sp2);
//PL_UPDATE_BOMLSHTS3 sp3 = new PL_UPDATE_BOMLSHTS3()
//{
// LSH1 = txtSN.Text.Trim(),
// ZDDM1 = scode
//};
//Procedure.run(sp3);
PL_UPDATE_BOMSOTHTS3 sp4 = new PL_UPDATE_BOMSOTHTS3()
{
SO1 = PlanSo,
JHDM1 = PlanCode,
ZDDM1 = scode
};
Procedure.run(sp4);
string ChSql1 = "select comp ,qty from RSTBOMQD_CRM where udesc='" + part2 + "' and zddm='" + scode + "' ";
DataTable dt2 = dc.GetTable(ChSql1);
if (dt2.Rows.Count > 0)
{
string code = dt2.Rows[0][0].ToString();
string qty = dt2.Rows[0][1].ToString();
//iteam_code = iteam_code + '#' + code;
dr[i + 3] = code + "----" + qty;
//dr[i + 4] = qty;
}
}
Table1.Rows.Add(dr);
}
Session["rept3400table"] = Table1;
ASPxGridView1.DataSource = Table1;
ASPxGridView1.DataBind();
}