protected void ASPxGridView1_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e)
{
if (txtSN.Text.Trim() == "")
{
ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail");
ASPxGridView1.JSProperties.Add("cpCallbackRet", "流水号不能为空！");
return;
}
//下边调用存储过程生成一个中间表，保存发动机的实际扫描零件清单
dc.ExeSql("delete from DATA_SCAN_ITEM where machinename='" + MachineName + "'");
PL_INSERT_SJZJQD sp = new PL_INSERT_SJZJQD()
{
SN1 = txtSN.Text.Trim(),
MACHINENAME1 = MachineName
};
Procedure.run(sp);
setCondition();
}
//查询
protected void ASPxGridView1_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e)
{
if (txtLSH1.Text.Trim() == "")
{
ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail");
ASPxGridView1.JSProperties.Add("cpCallbackRet", "起始流水号不能为空！");
return;
}
else if (txtLSH2.Text.Trim() == "")
{
ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail");
ASPxGridView1.JSProperties.Add("cpCallbackRet", "截止流水号不能为空！");
return;
}
int lsh1 = Convert.ToInt32(txtLSH1.Text.Trim());
int lsh2 = Convert.ToInt32(txtLSH2.Text.Trim());
string Chsql1 = "select * from DATA_PRODUCT where SN='" + txtLSH1.Text.Trim() + "' ";
DataTable Chdt1 = dc.GetTable(Chsql1);
if (Chdt1.Rows.Count <= 0)
{
ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail");
ASPxGridView1.JSProperties.Add("cpCallbackRet", "起始流水号不存在，请您重新输入！");
return;
}
string Chsql2 = "select * from DATA_PRODUCT where SN='" + txtLSH2.Text.Trim() + "' ";
DataTable Chdt2 = dc.GetTable(Chsql2);
if (Chdt2.Rows.Count <= 0)
{
ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail");
ASPxGridView1.JSProperties.Add("cpCallbackRet", "截止流水号不存在，请您重新输入！");
return;
}
if (lsh1 > lsh2)
{
ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail");
ASPxGridView1.JSProperties.Add("cpCallbackRet", "起始流水号应小于截止流水号！");
return;
}
string ZD1 = txtSCode.Text.Trim();
string sql = "", sn = "";
if (ZD1 != "")
{
sql = " select sn from DATA_SN_BOM where STATION_NAME='" + ZD1 + "' AND SN>='" + txtLSH1.Text.Trim() + "' and SN <='" + txtLSH2.Text.Trim() + "' "
+ "union select sn from DATA_SN_BOM_TEMP where STATION_NAME='" + ZD1 + "' AND SN>='" + txtLSH1.Text.Trim() + "' and SN <='" + txtLSH2.Text.Trim() + "'order by SN";
}
else
{
sql = " select sn from DATA_SN_BOM where SN>='" + txtLSH1.Text.Trim() + "' and SN <='" + txtLSH2.Text.Trim() + "' "
+ " union select sn from DATA_SN_BOM where SN>='" + txtLSH1.Text.Trim() + "' and SN <='" + txtLSH2.Text.Trim() + "'order by SN";
}
DataTable dt = dc.GetTable(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)
{
dc.ExeSql("delete from DATA_SCAN_ITEM where machinename='" + MachineName + "'");
}
sn = dt.Rows[i][0].ToString();
//下边调用存储过程生成一个中间表，保存发动机的实际扫描零件清单
PL_INSERT_SJZJQD sp = new PL_INSERT_SJZJQD()
{
SN1 = sn,
MACHINENAME1 = MachineName
};
Procedure.run(sp);
}
setCondition();
ASPxGridView1.Selection.UnselectAll();
}
protected void ASPxGridView1_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e)
{
if (txtSN.Text.Trim() == "" && ASPxDateEdit1.Text.Trim() == "" && ASPxDateEdit2.Text.Trim() == "" && txtItem.Text.Trim() == "" && txtGYS.Text.Trim() == "" && txtPC.Text.Trim() == "" && txtSCode.Text.Trim() != "")
{
ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail");
ASPxGridView1.JSProperties.Add("cpCallbackRet", "请指定查询条件！");
return;
}
else
{
string sql = "", sn = "";
//string flag = dc.GetValue("select is_ENGoffline('" + txtSN.Text.Trim() + "') from dual");
//if (flag == "0")//未下线
//{
//}
//else { sql = "select a.* ,b.user_name from VW_DATA_SN_BOM a left join code_user b on a.create_userid=b.user_code where 1=1 "; }
sql = "(select distinct a.sn from DATA_SN_BOM a where 1=1 ";
if (txtSN.Text.Trim() != "")
{
sql = sql + " and sn='" + txtSN.Text.Trim().ToUpper() + "'";
}
if (txtItem.Text.Trim() != "")
{
sql = sql + " and item_code='" + txtItem.Text.Trim().ToUpper() + "'";
}
if (txtGYS.Text.Trim() != "")
{
sql = sql + " and vendor_code='" + txtGYS.Text.Trim() + "'";
}
if (txtPC.Text.Trim() != "")
{
sql = sql + " and item_batch='" + txtPC.Text.Trim() + "'";
}
if (txtSCode.Text.Trim() != "")
{
sql += "AND STATION_NAME= '" + txtSCode.Text.Trim() + "'";
}
if (ASPxDateEdit1.Text.Trim() != "")
{
sql = sql + " and CREATE_TIME>=to_date('" + ASPxDateEdit1.Text.Trim() + "','yyyy-mm-dd hh24:mi:ss')";
}
if (ASPxDateEdit2.Text.Trim() != "")
{
sql = sql + " and CREATE_TIME<=to_date('" + ASPxDateEdit2.Text.Trim() + "','yyyy-mm-dd hh24:mi:ss')";
}
sql = sql + ") union ";
sql = sql + "(select distinct c.sn from DATA_SN_BOM_TEMP c where 1=1 ";
if (txtSN.Text.Trim() != "")
{
sql = sql + " and sn='" + txtSN.Text.Trim().ToUpper() + "'";
}
if (txtItem.Text.Trim() != "")
{
sql = sql + " and item_code='" + txtItem.Text.Trim().ToUpper() + "'";
}
if (txtGYS.Text.Trim() != "")
{
sql = sql + " and vendor_code='" + txtGYS.Text.Trim() + "'";
}
if (txtPC.Text.Trim() != "")
{
sql = sql + " and item_batch='" + txtPC.Text.Trim() + "'";
}
if (txtSCode.Text.Trim() != "")
{
sql += "AND STATION_NAME= '" + txtSCode.Text.Trim() + "'";
}
if (ASPxDateEdit1.Text.Trim() != "")
{
sql = sql + " and CREATE_TIME>=to_date('" + ASPxDateEdit1.Text.Trim() + "','yyyy-mm-dd hh24:mi:ss')";
}
if (ASPxDateEdit2.Text.Trim() != "")
{
sql = sql + " and CREATE_TIME<=to_date('" + ASPxDateEdit2.Text.Trim() + "','yyyy-mm-dd hh24:mi:ss')";
}
sql = sql + " ) ORDER BY SN ";
DataTable dt = dc.GetTable(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)
{
dc.ExeSql("delete from DATA_SCAN_ITEM where machinename='" + MachineName + "'");
}
sn = dt.Rows[i][0].ToString();
//下边调用存储过程生成一个中间表，保存发动机的实际扫描零件清单
PL_INSERT_SJZJQD sp = new PL_INSERT_SJZJQD()
{
SN1 = sn,
MACHINENAME1 = MachineName
};
Procedure.run(sp);
}
}
setCondition();
ASPxGridView1.Selection.UnselectAll();
}
protected void ASPxGridView1_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e)
{
if (ASPxDateEdit1.Date.AddDays(31) < ASPxDateEdit2.Date)
{
ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail");
ASPxGridView1.JSProperties.Add("cpCallbackRet", "选择日期范围不能超过30天，请重新选择！");
return;
}
//判断是否改制发动机
if (txtSN.Text.Trim() != "")
{
string gzsql = "select a.plan_type from data_plan a left join data_plan_sn b on a.plan_code=b.plan_code where b.sn='" + txtSN.Text.Trim() + "'";
string type = dc.GetValue(gzsql);
if (type != "C" || type != "D")
{
//弹出提示框不是改制流水号
ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail");
ASPxGridView1.JSProperties.Add("cpCallbackRet", "该流水号不是改制流水号，请您重新输入！");
return;
}
//下边程序动态生成一个中间表，保存发动机的实际扫描零件清单
dc.ExeSql("delete from DATA_SCAN_ITEM where machinename='" + MachineName + "'");
PL_INSERT_SJZJQD sp = new PL_INSERT_SJZJQD()
{
SN1 = txtSN.Text.Trim(),
MACHINENAME1 = MachineName
};
Procedure.run(sp);
}
else
{
string datetime = ASPxDateEdit2.Date.ToShortDateString() + " 23:59:59";
string sql = " select sn from DATA_SN_BOM where sn in( select b.sn from data_plan a left join data_plan_sn b on a.plan_code=b.plan_code where (a.plan_type='C' or a.plan_type='D')) ";
if (ASPxDateEdit1.Text.Trim() != "")
{
sql = sql + " and CREATE_TIME>=to_date('" + ASPxDateEdit1.Text.Trim() + "','yyyy-mm-dd hh24:mi:ss')";
}
if (ASPxDateEdit2.Text.Trim() != "")
{
sql = sql + " and CREATE_TIME<=to_date('" + datetime + "','yyyy-mm-dd hh24:mi:ss')";
}
sql = sql + "union select sn from DATA_SN_BOM_TEMP where sn in( select sn from data_record )";
if (ASPxDateEdit1.Text.Trim() != "")
{
sql = sql + " and CREATE_TIME>=to_date('" + ASPxDateEdit1.Text.Trim() + "','yyyy-mm-dd hh24:mi:ss')";
}
if (ASPxDateEdit2.Text.Trim() != "")
{
sql = sql + " and CREATE_TIME<=to_date('" + datetime + "','yyyy-mm-dd hh24:mi:ss')";
}
sql = sql + " order by SN";
DataTable dt = dc.GetTable(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
//if (i == 0) { dc.ExeSql("delete from DATA_SCAN_ITEM where machinename='" + MachineName + "'"); }
string sn = dt.Rows[i][0].ToString();
//下边调用存储过程生成一个中间表，保存发动机的实际扫描零件清单
PL_INSERT_SJZJQD sp = new PL_INSERT_SJZJQD()
{
SN1 = sn,
MACHINENAME1 = MachineName
};
Procedure.run(sp);
}
}
setCondition();
}
