protected void ASPxGridView1_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e)
{
string MachineName = Request.UserHostAddress;
string hostIPAddress = Page.Request.UserHostAddress;
//IPHostEntry hostInfo = System.Net.Dns.GetHostByAddress(hostIPAddress);
MachineName = hostIPAddress;
//删除原来记录
string sql = "DELETE FROM RST_QAD_BOMPART_LQ_TEMP where ABOM_USER='******'";
dc.ExeSql(sql);
//逐行显示 YXH2016/12/17 21:15
#region 逐行显示
DataTable dt1 = new DataTable();
dt1.Columns.Add("ABOM_JHDM");
dt1.Columns.Add("ABOM_COMP");
dt1.Columns.Add("ABOM_DESC");
dt1.Columns.Add("ABOM_WKCTR");
dt1.Columns.Add("ABOM_QTY");
dt1.Columns.Add("SJ_FLAG");
//批量生成
if (listPlan.Items.Count > 0)
{
for (int i = 0; i < listPlan.Items.Count; i++)
{
string str = listPlan.Items[i].Text;
BomReplaceFactory.QAD_CREATE_PRTPART_LQ(str, MachineName);
string sqlSo = "select t.plan_code,a.plan_so ABOM_COMP from ms_sfjit_plan_log t left join data_plan a on a.plan_code=t.plan_code where t.SF_JIT_ID='" + str + "' and t.PLAN_CODE IN (SELECT plan_code FROM data_plan WHERE LQ_FLAG='Y') ";
DataTable dt = dc.GetTable(sqlSo);
if (dt.Rows.Count < 1)
{
return;
}
for (int s = 0; s < dt.Rows.Count; s++)
{
dt1.Rows.Add(dt.Rows[s][0], dt.Rows[s][1], "", "", "", "");
string sqlSn = "select sn from data_product where plan_code='" + dt.Rows[s][0].ToString() + "'";
DataTable dt2 = dc.GetTable(sqlSn);
int integer = dt2.Rows.Count / 6;
for (int n = 0; n <= integer; n++)
{
DataRow dr2 = dt1.NewRow();
for (int m = 0; m < 6; m++)
{
dr2[m] = dt2.Rows[m + n * 6][0];
if (m > dt2.Rows.Count - 2 - 6 * n)
{
break;
}
}
dt1.Rows.Add(dr2);
}
}
string sqlDh = "select ABOM_JHDM ,ABOM_COMP ,ABOM_DESC ,ABOM_WKCTR ,ABOM_QTY ,SJ_FLAG from RST_QAD_BOMPART_LQ where ABOM_USER='******' order by SJ_FLAG DESC,ABOM_JHDM,ABOM_WKCTR";
DataTable dt3 = dc.GetTable(sqlDh);
if (dt3.Rows.Count < 1)
{
return;
}
dt1.Rows.Add("MES单号", "零件代码", "零件名称", "工位", "数量", "是否随机件");
for (int x = 0; x < dt3.Rows.Count; x++)
{
dt1.Rows.Add(dt3.Rows[x][0], dt3.Rows[x][1], dt3.Rows[x][2], dt3.Rows[x][3], dt3.Rows[x][4], dt3.Rows[x][5]);
}
}
}
#endregion
Session["MaterialSend_YXH"] = dt1;
ASPxGridView1.DataSource = dt1;
ASPxGridView1.DataBind();
}
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("计划");
Table1.Columns.Add("流水号");
for (int a = 0; a < ASPxListBoxUsed.Items.Count; a++)
{
string part = ASPxListBoxUsed.Items[a].ToString();
string delsql = "delete from RSTBOMQD_ITEM8 where udesc='" + part + "'";
dc.ExeSql(delsql);
Table1.Columns.Add(part);
Table1.Columns.Add(part + "数量");
//Table1.Columns.Add(part+'▍↔'+"数量");
}
string plancode = "", PlanSo = "", PlanCode = "", RQbegin = "", plinecode = "", xl = "", scode = "", PlanQty = "";
int PlanSl = 0;
string snSql = "select lsh,max(ptime) 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') group by lsh order by ptime,lsh";
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() + "' and pline_code='" + txtPCode.Value.ToString() + "' ";
plancode = dc.GetValue(soSql);
//DataTable sodt = dc.GetTable(soSql);
//if (sodt.Rows.Count > 0) { plancode = sodt.Rows[0][0].ToString(); }
string sql1 = "select distinct begin_date,plan_so,plan_qty from data_plan where pline_code='" + txtPCode.Value.ToString() + "' and plan_code='" + plancode + "' and plan_type<>'C' and plan_type<>'D' ";
DataTable dt1 = dc.GetTable(sql1);
if (dt1.Rows.Count <= 0)
{
continue;
}
PlanSo = dt1.Rows[0][1].ToString();
PlanQty = dt1.Rows[0][2].ToString();
PlanSl = Convert.ToInt32(PlanQty);
plinecode = txtPCode.Value.ToString();
PlanCode = plancode;
DataRow dr = Table1.NewRow();
dr[0] = RQbegin;
dr[1] = PlanSo;
dr[2] = PlanCode;
dr[3] = sndt.Rows[j][0].ToString();
for (int i = 0, m = 0; i < ASPxListBoxUsed.Items.Count; i++)
{
string part2 = ASPxListBoxUsed.Items[i].ToString();
if (plinecode == "E")
{
scode = "ZF5";
}
if (plinecode == "W")
{
scode = "ATPU-T560";
}
//string delsql = "delete from RSTBOMQD_ITEM8 where udesc='" + part2 + "'";
//dc.ExeSql(delsql);
PL_BOMZJTS_ITEM8 sp = new PL_BOMZJTS_ITEM8()
{
PLANSO1 = PlanSo,
SCODE1 = scode,
PLANCODE1 = PlanCode,
PART1 = part2,
MACHINENAME1 = MachineName
};
Procedure.run(sp);
PL_UPDATE_BOMZJTS_ITEM8 sp2 = new PL_UPDATE_BOMZJTS_ITEM8()
{
PLANSO1 = PlanSo,
SCODE1 = scode,
PLANCODE1 = PlanCode,
PLINECODE1 = plinecode,
MACHINENAME1 = MachineName
};
Procedure.run(sp2);
PL_UPDATE_ITEM8 sp4 = new PL_UPDATE_ITEM8()
{
PLANSO1 = PlanSo,
PLANCODE1 = PlanCode,
SCODE1 = scode
};
Procedure.run(sp4);
//string ChSql22 = "select comp ,qty from RSTBOMQD_ITEM8 where udesc='" + part2 + "' and zddm='" + scode + "' ";
string ChSql1 = "select replace ( a.comp,'#','') comp ,a.qty,a.gysmc from RSTBOMQD_ITEM8 a where a.udesc='" + part2 + "' and a.zddm='" + scode + "' and a.plan_Code='" + PlanCode + "' ";
if (PlanSo != "")
{
ChSql1 = ChSql1 + " and a.plan_so='" + PlanSo + "'";
}
DataTable dt2 = dc.GetTable(ChSql1);
string code = "", qty = "";
int sl;
if (dt2.Rows.Count > 0)
{
code = dt2.Rows[0][0].ToString();
qty = dt2.Rows[0][1].ToString();
sl = Convert.ToInt32(qty);
//dr[m + 4] = code;
//dr[m + 5] = sl * PlanSl;
//m = m + 2;
dr[m + 4] = code;
dr[m + 5] = sl;
m = m + 2;
}
else
{
dr[m + 4] = code;
dr[m + 5] = "";
m = m + 2;
}
}
Table1.Rows.Add(dr);
}
Session["rept3400table"] = Table1;
ASPxGridView1.DataSource = Table1;
ASPxGridView1.DataBind();
}
public void GetClassification(string group)
{
try
{
if (ASPxComboBox1.Value != null)
{
if (ASPxComboBox1.Value.ToString() == "USER_ROLE")
{
ASPxMenu3.Items.FindByName("btnNew").Enabled = false;
ASPxMenu3.Items.FindByName("btnDelete").Enabled = false;
}
else
{
ASPxMenu3.Items.FindByName("btnNew").Enabled = true;
ASPxMenu3.Items.FindByName("btnDelete").Enabled = true;
}
}
ASPxGridView1.Columns["VALUE_TEXT_CLASSIFICATION"].Caption = "Valor Texto";
ASPxGridView1.Columns["MPC01"].Caption = "Tipo Interface";
switch (group)
{
case "SKU":
ASPxGridView1.Caption = "Clasificaciones SKU";
break;
case "WEATHER":
ASPxGridView1.Caption = "Clasificaciones Clima";
break;
case "LOCATION":
ASPxGridView1.Caption = "Clasificaciones Ubicacion";
break;
case "CUSTOMER":
ASPxGridView1.Caption = "Clasificaciones Cliente";
break;
case "PROVIDER":
ASPxGridView1.Caption = "Clasificaciones Proveedor";
break;
case "VEHICLE":
ASPxGridView1.Caption = "Clasificaciones Vehículo";
break;
case "RECEPTION":
ASPxGridView1.Caption = "Clasificaciones Recepción";
break;
case "USER_ROLE":
ASPxGridView1.Caption = "Roles de Usuario";
break;
case "BANK_ACCOUNTS":
ASPxGridView1.Caption = "Bancos";
ASPxGridView1.Columns["VALUE_TEXT_CLASSIFICATION"].Caption = "Número de Cuenta";
ASPxGridView1.Columns["MPC01"].Caption = "Nombre del Banco";
break;
case "VOID_REASONS":
ASPxGridView1.Caption = "Razones de anulación";
break;
case "ALL":
ASPxGridView1.Caption = "Clasificaciones";
break;
default:
ASPxGridView1.Caption = "Clasificaciones";
break;
}
if (group == "ALL")
{
var pResult = "";
var ds = _objClassification.GetAllClassification(Session["connectionString"].ToString(), ref pResult);
if (pResult == "")
{
ASPxGridView1.DataSource = ds;
ASPxGridView1.DataBind();
Session["dsClassification"] = ds;
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true);
}
}
else
{
var pResult = "";
var ds = _objClassification.GetClassification(Session["connectionString"].ToString(), group, ref pResult);
if (pResult == "")
{
ASPxGridView1.DataSource = ds;
ASPxGridView1.DataBind();
Session["selectedClassification"] = group;
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true);
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
ASPxGridView1.DataSource = Enumerable.Range(0, 10).Select(i => new { Col1 = i, Col2 = i * 2 });
ASPxGridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
ASPxGridView1.DataSource = GridData;
ASPxGridView1.DataBind();
ASPxGridView1.SettingsEditing.BatchEditSettings.AllowRegularDataItemTemplate = supportDataItemTemplate.Checked;
}
private void setCondition()
{
string sql = "select * from dp_kcb where ";
if (txtPCode.Text.Trim() != "")
{
sql = sql + " gzdd = '" + txtPCode.Value.ToString() + "'";
}
else
{
sql = sql + " gzdd in (select pline_code from vw_user_role_program where user_id='" + theUserId + "' and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "') ";
}
if (ASPxDateEdit1.Text.Trim() != "")
{
sql = sql + " AND to_date(gzrq,'yyyy-mm-dd hh24:mi:ss')>= to_date('" + ASPxDateEdit1.Text.Trim() + "', 'yyyy-mm-dd hh24:mi:ss') ";
}
if (ASPxDateEdit2.Text.Trim() != "")
{
sql = sql + " AND to_date(gzrq,'yyyy-mm-dd hh24:mi:ss')<= to_date('" + ASPxDateEdit2.Text.Trim() + "', 'yyyy-mm-dd hh24:mi:ss')";
}
if (textSO.Text.Trim() != "")
{
sql = sql + " AND so like '%" + textSO.Text.Trim() + "%'";
}
if (txtPc.Text.Trim() != "")
{
sql = sql + " AND gzrq like '%" + txtPc.Text.Trim() + "%'";
}
sql = sql + " order by so,ghtm";
DataTable dt = dc.GetTable(sql);
ASPxGridView1.DataSource = dt;
ASPxGridView1.DataBind();
string sql2 = "select SO,COUNT(*) SL from dp_kcb where ";
if (txtPCode.Text.Trim() != "")
{
sql2 = sql2 + " gzdd = '" + txtPCode.Value.ToString() + "'";
}
else
{
sql2 = sql2 + " gzdd in (select pline_code from vw_user_role_program where user_id='" + theUserId + "' and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "') ";
}
if (ASPxDateEdit1.Text.Trim() != "")
{
sql2 = sql2 + " AND to_date(gzrq,'yyyy-mm-dd hh24:mi:ss')>= to_date('" + ASPxDateEdit1.Text.Trim() + "', 'yyyy-mm-dd hh24:mi:ss')";
}
if (ASPxDateEdit2.Text.Trim() != "")
{
sql2 = sql2 + " AND to_date(gzrq,'yyyy-mm-dd hh24:mi:ss')<= to_date('" + ASPxDateEdit2.Text.Trim() + "', 'yyyy-mm-dd hh24:mi:ss')";
}
if (textSO.Text.Trim() != "")
{
sql2 = sql2 + " AND so like '%" + textSO.Text.Trim() + "%'";
}
if (txtPc.Text.Trim() != "")
{
sql2 = sql2 + " AND gzrq like '%" + txtPc.Text.Trim() + "%'";
}
sql2 = sql2 + " GROUP BY SO order by So";
DataTable dt2 = dc.GetTable(sql2);
ASPxGridView2.DataSource = dt2;
ASPxGridView2.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
ASPxGridView1.DataBind();
}
//初始化gridview
//private void setCondition()
//{
// string sql = "";
// //查询发动机状态，不随出入库删除
// sql = "select A.ROWID,a.ghtm,b.PLAN_CODE,a.so,a.rqsj,a.ggxhmc,a.zdmc,a.bcmc,a.bzmc,a.ygmc "
// + " from sjcbb_ndel a "
// + " left join data_product b on b.SN=a.ghtm "
// + " left join code_station c on c.STATION_NAME=a.zdmc "
// + " left join data_plan d on d.PLAN_CODE=b.PLAN_CODE "
// + " where 1=1 ";
// //+" where 1=" + m_show + " ";
// if (txtPCode.Text.Trim() != "")
// {
// sql += " AND b.PLINE_CODE = '" + txtPCode.Value.ToString() + "' ";
// }
// //if (cmbJhdm.Text.Trim() != "" && Check1.Value.ToString() == "true")
// //{
// // sql += " AND b.PLAN_CODE = '" + cmbJhdm.Text.Trim() + "' ";
// // if (txtSO.Text.Trim() != "")
// // {
// // sql += " AND a.so = '" + txtSO.Text.Trim() + "' ";
// // }
// //}
// //如果列表中没有条件，则查询的数据为空
// if (List1.Items.Count < 1)
// {
// sql += " AND b.PLAN_CODE = '' ";
// }
// //？？取不到选中的列，怎么设置只能选一行
// if (List1.Items.Count == 1 && Check1.Checked == true)
// {
// int listindex = List1.Items.IndexOfText("--");
// //这里只取一行吗？
// string planCode = List1.SelectedItems[0].ToString().Substring(0, listindex);
// sql += " AND B.PLAN_CODE = '" + planCode + "' ";
// if (txtSO.Text.Trim() != "")
// {
// sql += " AND A.SO = '" + txtSO.Text.Trim() + "' ";
// }
// }
// if (Check1.Checked == false && List1.Items.Count >= 1)
// {
// //为什么获取不到，因为IndexOfText取的是文本对应item在items中的位置
// //int listindex = List1.Items.IndexOfText("2016P0926-01--SO22064");
// //test
// string item = List1.Items[0].ToString();
// int listindex = item.IndexOf("--");
// if (listindex >= 0)
// {
// //不能用SelectedItems，好像取不到，待测试
// sql += " AND ( b.PLAN_CODE = '" + List1.Items[0].ToString().Substring(0, List1.Items[0].ToString().IndexOf("--")) + "' ";
// for (int i = 2; i <= List1.Items.Count; i++)
// {
// listindex = List1.Items[i - 1].ToString().IndexOf("--");
// sql += " OR B.PLAN_CODE = '" + List1.Items[i - 1].ToString().Substring(0, listindex) + "' ";
// }
// sql += ") ";
// }
// }
// //if (cmbJhdm.Text.Trim() != "")
// //{
// // sql += " AND b.PLAN_CODE = '" + cmbJhdm.Text.Trim() + "' ";
// //}
// if (cmbzd.Text.Trim() != "")
// {
// sql += " AND a.ZDMC = '" + cmbzd.Text.Trim() + "' ";
// }
// if (cmbqy.Text.Trim() != "")
// {
// sql += " AND a.ZDQY = '" + cmbqy.Text.Trim() + "' ";
// }
// if (cmbfl.Text.Trim() != "")
// {
// sql += " AND a.ZDFL = '" + cmbfl.Text.Trim() + "' ";
// }
// if (txtGhtm.Text.Trim() != "")
// {
// sql += " AND a.GHTM = '" + txtGhtm.Text.Trim() + "' ";
// }
// //数据量太大，先取前二十条数据
// //sql += " AND ROWNUM <= 20 ";
// sql += " ORDER BY A.GHTM,A.RQSJ ";
// DataTable dt = dc.GetTable(sql);
// ASPxGridView1.DataSource = dt;
// ASPxGridView1.DataBind();
//}
//初始化gridview
private void setCondition()
{
string sql = "";
//查询发动机状态，不随出入库删除
sql = " SELECT A.ROWID,A.SN,A.PLAN_CODE,A.PLAN_SO,A.START_TIME,A.PRODUCT_MODEL,B.STATION_NAME,C.SHIFT_NAME,D.TEAM_NAME,E.USER_NAME "
+ " FROM DATA_STORE_NDEL A "
+ " LEFT JOIN CODE_STATION B ON B.STATION_CODE = A.STATION_CODE "
+ " LEFT JOIN CODE_SHIFT C ON C.SHIFT_CODE = A.SHIFT_CODE "
+ " LEFT JOIN CODE_TEAM D ON D.TEAM_CODE = A.TEAM_CODE "
+ " LEFT JOIN CODE_USER E ON E.USER_NAME = A.USER_ID "
+ " WHERE 1=1 ";
//若生产线为空，则取生产线为空的值
if (txtPCode.Text.Trim() == "")
{
sql += " AND A.PLINE_CODE = '' ";
}
if (txtPCode.Text.Trim() != "")
{
sql += " AND A.PLINE_CODE = '" + txtPCode.Value.ToString() + "' ";
}
//如果列表中没有条件，则查询的数据为空
if (List1.Items.Count < 1)
{
sql += " AND A.PLAN_CODE = '' ";
}
//？？取不到选中的列，怎么设置只能选一行
if (List1.Items.Count == 1 && Check1.Checked == true)
{
int listindex = List1.Items.IndexOfText("--");
//这里只取一行吗？
string planCode = List1.SelectedItems[0].ToString().Substring(0, listindex);
sql += " AND A.PLAN_CODE = '" + planCode + "' ";
if (txtSO.Text.Trim() != "")
{
sql += " AND A.SO = '" + txtSO.Text.Trim() + "' ";
}
}
if (Check1.Checked == false && List1.Items.Count >= 1)
{
//为什么获取不到，因为IndexOfText取的是文本对应item在items中的位置
//int listindex = List1.Items.IndexOfText("2016P0926-01--SO22064");
//test
string item = List1.Items[0].ToString();
int listindex = item.IndexOf("--");
if (listindex >= 0)
{
//不能用SelectedItems，好像取不到，待测试
sql += " AND ( A.PLAN_CODE = '" + List1.Items[0].ToString().Substring(0, List1.Items[0].ToString().IndexOf("--")) + "' ";
for (int i = 2; i <= List1.Items.Count; i++)
{
listindex = List1.Items[i - 1].ToString().IndexOf("--");
sql += " OR A.PLAN_CODE = '" + List1.Items[i - 1].ToString().Substring(0, listindex) + "' ";
}
sql += ") ";
}
}
if (cmbzd.Text.Trim() != "")
{
sql += " AND B.STATION_NAME = '" + cmbzd.Text.Trim() + "' ";
}
//if (cmbqy.Text.Trim() != "")
//{
// sql += " AND A.ZDQY = '" + cmbqy.Text.Trim() + "' ";
//}
//if (cmbfl.Text.Trim() != "")
//{
// sql += " AND A.ZDFL = '" + cmbfl.Text.Trim() + "' ";
//}
//if (txtGhtm.Text.Trim() != "")
//{
// sql += " AND A.GHTM = '" + txtGhtm.Text.Trim() + "' ";
//}
sql += " ORDER BY A.SN,A.START_TIME ";
DataTable dt = dc.GetTable(sql);
ASPxGridView1.DataSource = dt;
ASPxGridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
ASPxGridView1.DataBind();
Session["FocusedRow"] = ASPxGridView1.GetRowValues(ASPxGridView1.FocusedRowIndex, new string[] { ASPxGridView1.KeyFieldName });
}
protected void Page_Init(object sender, EventArgs e)
{
ASPxGridView1.DataSource = DataProvider.GetData();
ASPxGridView1.DataBind();
}
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;
}
}
}
protected void ToSelect(object sender, EventArgs e)
{
YxBtn.SetViewState(divSel);
ASPxGridView1.DataBind();
}
private void setCondition()
{
//绑定表数据
ASPxGridView1.DataSource = DepartmentFactory.GetAll();
ASPxGridView1.DataBind();
}
private void setCondition()
{
string m_YearStr, m_MonthStr, m_FromrqStr, m_TorqStr, m_MonthDateStr, m_SO;
m_YearStr = ASPxDateEdit1.Date.Year.ToString();
m_MonthStr = ASPxDateEdit2.Date.Month.ToString();
m_FromrqStr = ASPxDateEdit1.Text.Trim();
m_TorqStr = ASPxDateEdit2.Text.Trim();
if (ASPxDateEdit1.Date.AddDays(31) < ASPxDateEdit2.Date)
{
ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail");
ASPxGridView1.JSProperties.Add("cpCallbackRet", "选择日期范围不能超过31天，请重新选择！");
return;
}
string sql = "DELETE FROM DP_REPORTSOTEMP WHERE MACHINENAME='" + MachineName + "'";
dc.ExeSql(sql);
string Insql1 = " insert into dp_reportsotemp(so,Machinename) select distinct so,'" + MachineName + "' from dp_monthkcb where year='" + m_YearStr + "' and month='" + m_MonthStr + "' and periodline='Begin' and gzdd='" + txtPCode.Value.ToString() + "'";
dc.ExeSql(Insql1);
string ChSql = "select monthdate from dp_monthkcb where year='" + m_YearStr + "' and month='" + m_MonthStr + "' and periodline='Begin' and gzdd='" + txtPCode.Value.ToString() + "' order by monthdate desc";
DataTable dt = dc.GetTable(ChSql);
if (dt.Rows.Count <= 0)
{
ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail");
ASPxGridView1.JSProperties.Add("cpCallbackRet", "没有期初库存数据！");
return;
}
else
{
string strMonD = dt.Rows[0][0].ToString();
m_MonthDateStr = strMonD;
}
string Insql2 = " insert into dp_reportsotemp(so,Machinename) select distinct so,'" + MachineName + "' from dp_rckwcb where gzrq>='" + m_MonthDateStr + "' and gzrq<='" + m_TorqStr + "' and gzdd='" + txtPCode.Value.ToString() + "' and so not in (select so from dp_reportsotemp where MachineName='" + MachineName + "')";
dc.ExeSql(Insql2);
string ChSql2 = "select SO from dp_reportsotemp where machinename='" + MachineName + "' order by So";
DataTable dt2 = dc.GetTable(ChSql2);
DataTable Table = new DataTable();
Table.Columns.Add("SO");
Table.Columns.Add("QCKC");
Table.Columns.Add("RK1");
Table.Columns.Add("CK1");
Table.Columns.Add("RK0");
Table.Columns.Add("RK2");
Table.Columns.Add("RK3");
Table.Columns.Add("RK4");
Table.Columns.Add("RK5");
Table.Columns.Add("RK6");
Table.Columns.Add("RK7");
Table.Columns.Add("RK8");
Table.Columns.Add("RK9");
Table.Columns.Add("RK10");
Table.Columns.Add("RKHJ");
Table.Columns.Add("WXK");
Table.Columns.Add("SYK");
Table.Columns.Add("QT");
Table.Columns.Add("CKHJ");
Table.Columns.Add("KC");
Table.TableName = "报表";
for (int i = 0; i < dt2.Rows.Count; i++)
{
m_SO = dt2.Rows[i][0].ToString();
string outstr;
PL_CREATE_REPORT sp = new PL_CREATE_REPORT()
{
SO1 = m_SO,
YEAR1 = m_YearStr,
MONTH1 = m_MonthStr,
GZDD1 = txtPCode.Value.ToString(),
FROMRQ1 = m_FromrqStr,
TORQ1 = m_TorqStr,
MONTHDATE1 = m_MonthDateStr,
OUTSTR1 = ""
};
Procedure.run(sp);
//ProductDataFactory.PL_CREATE_REPORT(m_SO, m_YearStr, m_MonthStr, txtPCode.Value.ToString(), m_FromrqStr, m_TorqStr, m_MonthDateStr, out outstr);
outstr = sp.OUTSTR1;
string[] param = outstr.Split('#');
if (param.Length < 19)
{
ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail");
ASPxGridView1.JSProperties.Add("cpCallbackRet", "查询失败！");
return;
}
else
{
Table.Rows.Add(m_SO, param[0], param[1], param[2], param[3], param[4], param[5], param[6], param[7], param[8], param[9], param[10], param[11], param[12], param[13], param[14], param[15], param[16], param[17], param[18]);
}
}
ASPxGridView1.DataSource = Table;
ASPxGridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!ValidarConexionYUsuarioLogueado(sender))
{
return;
}
LookupWarehouse.GridView.Width = 300;
LookupRoles.GridView.Width = 300;
ASPxTextBox5.Enabled = true;
ASPxMenu3.Items.FindByName("btnAgregarCliente").Visible = AgregarCliente();
if (!Page.IsPostBack)
{
GetUsers();
GetUserRole();
GetSellers();
GetWarehouseNotAsign("");
GetWarehousePreSale();
GetAllZones();
//UsuarioSeleccionoUsuario?.Invoke(this,new RutaArgumento{ Data = new Ruta{CODE_ROUTE = "" }, Usuario = new Usuario{ LOGIN = ""}});
return;
}
Connection = Session["connectionString"].ToString();
if (!Page.IsPostBack)
{
Session["ACTION"] = "UPDATE";
Session["base64Profile"] = null;
}
if (Page.IsPostBack)
{
ReportView();
}
if (Session["DS_USER"] != null)
{
ASPxGridView1.DataSource = Session["DS_USER"];
ASPxGridView1.DataBind();
}
else
{
GetUsers();
}
if (Session["DS_USER_ROLE"] != null)
{
CmbUserRole.DataSource = Session["DS_USER_ROLE"];
CmbUserRole.ValueField = "NAME_CLASSIFICATION";
CmbUserRole.TextField = "VALUE_TEXT_CLASSIFICATION";
CmbUserRole.DataBind();
}
else
{
GetUserRole();
}
if (Session["DS_SELLER_USER"] != null)
{
LookupSeller.DataSource = Session["DS_SELLER_USER"];
LookupSeller.DataBind();
}
else
{
GetSellers();
}
if (Session["DS_WAREHOUSE_NOTASIGN"] != null)
{
LookupWarehouse.DataSource = Session["DS_WAREHOUSE_NOTASIGN"];
LookupWarehouse.DataBind();
}
else
{
if (!Page.IsPostBack)
{
GetWarehouseNotAsign("");
}
}
if (Session["DS_WAREHOUSE_PRESALE"] != null)
{
LookupWarehousePre.DataSource = Session["DS_WAREHOUSE_PRESALE"];
LookupWarehousePre.DataBind();
}
else
{
GetWarehousePreSale();
}
if (Session["UiVistaPoligonosDeRuta"] != null)
{
UiVistaPoligonosDeRuta.DataSource = Session["UiVistaPoligonosDeRuta"];
UiVistaPoligonosDeRuta.DataBind();
}
if (Session["ListaRuta"] != null)
{
UiListaRuta.DataSource = Session["ListaRuta"];
UiListaRuta.DataBind();
}
if (Session["UiListaZona"] != null)
{
UiListaZona.DataSource = Session["UiListaZona"];
UiListaZona.DataBind();
}
}
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();
}
