protected void btnQryDetail_Click(object sender, EventArgs e)
{
string oldJhdm;
string oldSO;
string newJhdm;
string newSO;
string newGhtm;
string newGzdd;
if (listLsh.Items.Count >= 1)
{
string sql = " DELETE FROM RST_GHTM_BOM_COMP WHERE YHDM = '" + theUserCode + "' ";
dc.ExeSql(sql);
for (int i = 0; i < listLsh.Items.Count; i++)
{
//sql = " SELECT GHTM,JHDM,SO FROM RST_GHTM_GZ_LOG WHERE JHDM != NEW_JHDM AND GZRQ IS NOT NULL ";
//string[] str = listLsh.Items[i].ToString().Trim().Split("&".ToCharArray());
//string ghtm = str[0];
//sql += " AND GHTM = '" + ghtm + "' ";
//sql += " ORDER BY GZRQ DESC ";
//不从原来的RST_GHTM_GZ_LOG里取旧JHDM，从DATA_RECORD里取旧JHDM
string[] str = listLsh.Items[i].ToString().Trim().Split("&".ToCharArray());
string ghtm = str[0];
sql = " SELECT SN,PLAN_CODE,PLAN_SO FROM DATA_RECORD WHERE SN = '" + ghtm + "' ORDER BY WORK_DATE DESC ";
DataTable dt = dc.GetTable(sql);
if (dt.Rows.Count > 0)
{
oldJhdm = dt.Rows[0][1].ToString();
oldSO = dt.Rows[0][2].ToString();
}
else
{
oldJhdm = "";
oldSO = "";
}
newGhtm = ghtm;
newJhdm = str[1];
newSO = str[2];
newGzdd = str[3];
MW_COMPARE_GHTMBOM sp = new MW_COMPARE_GHTMBOM()
{
GHTM1 = newGhtm,
GZDD1 = newGzdd,
JHDM1 = oldJhdm,
JHSO1 = oldSO,
GZFLAG1 = "OLD",
GZDD2 = newGzdd,
JHDM2 = newJhdm,
JHSO2 = newSO,
GZFLAG2 = "NEW",
YHDM1 = theUserCode
};
Procedure.run(sp);
}
setCondition();
}
}
protected void btnQryDetail_Click(object sender, EventArgs e)
{
string oldJhdm = "";
string oldSO = "";
string newJhdm = "";
string newSO = "";
string newGhtm = "";
string newGzdd = "";
if (listLsh.Items.Count >= 1)
{
string sql = " DELETE FROM RST_GHTM_BOM_COMP WHERE YHDM = '" + theUserCode + "' ";
dc.ExeSql(sql);
for (int i = 0; i < listLsh.Items.Count; i++)
{
//sql = " SELECT GHTM,JHDM,SO FROM RST_GHTM_GZ_LOG WHERE JHDM != NEW_JHDM AND GZRQ IS NOT NULL ";
//string[] str = listLsh.Items[i].ToString().Trim().Split("&".ToCharArray());
//string ghtm = str[0];
//sql += " AND GHTM = '" + ghtm + "' ";
//sql += " ORDER BY GZRQ DESC ";
string[] str = listLsh.Items[i].ToString().Trim().Split("&".ToCharArray());
string ghtm = str[0];
newGhtm = ghtm;
newJhdm = str[1];
newSO = str[2];
newGzdd = str[3];
//string chsql = "SELECT B.ONLINE_QTY FROM DATA_PLAN_SN A , DATA_PLAN B WHERE A.SN = '" + ghtm + "'"
// + " AND (B.PLAN_TYPE='C' OR PLAN_TYPE ='D' ) AND A.IS_VALID='Y' AND A.PLAN_CODE=B.PLAN_CODE";
string chsql = "select sn from data_product where plan_code='" + newJhdm + "' and sn='" + ghtm + "'";
//string if_online = dc.GetValue(chsql);
int online_qty = dc.GetTable(chsql).Rows.Count;
if (online_qty > 0)//如果已经上线，去data_record表中取该流水号对应的最新计划
{
sql = " SELECT SN,PLAN_CODE,PLAN_SO FROM DATA_RECORD WHERE SN = '" + ghtm + "' ORDER BY WORK_DATE DESC ";
System.Data.DataTable dt = dc.GetTable(sql);
if (dt.Rows.Count > 0)
{
oldJhdm = dt.Rows[0][1].ToString();
oldSO = dt.Rows[0][2].ToString();
}
}
else//如果未上线，在产品定义表（DATA_PRODUCT）中取该流水号对应的计划
{
sql = " SELECT SN,PLAN_CODE,PLAN_SO FROM DATA_PRODUCT WHERE SN = '" + ghtm + "' ";
System.Data.DataTable dt2 = dc.GetTable(sql);
if (dt2.Rows.Count > 0)
{
oldJhdm = dt2.Rows[0][1].ToString();
oldSO = dt2.Rows[0][2].ToString();
}
}
MW_COMPARE_GHTMBOM sp = new MW_COMPARE_GHTMBOM()
{
GHTM1 = newGhtm,
GZDD1 = newGzdd,
JHDM1 = oldJhdm,
JHSO1 = oldSO,
GZFLAG1 = "OLD",
GZDD2 = newGzdd,
JHDM2 = newJhdm,
JHSO2 = newSO,
GZFLAG2 = "NEW",
YHDM1 = theUserCode
//test
//GHTM1 = newGhtm,
//GZDD1 = newGzdd,
//JHDM1 = oldJhdm,
//JHSO1 = oldSO,
//GZFLAG1 = "NEW",
//GZDD2 = newGzdd,
//JHDM2 = newJhdm,
//JHSO2 = newSO,
//GZFLAG2 = "OLD",
//YHDM1 = theUserCode
};
Procedure.run(sp);
}
setCondition();
}
}
public ctrl_fxbomcom(string sn1, string plancode1)
{
InitializeComponent();
SN = sn1;
planCode = plancode1;
dgv1.DataSource = null;
dgv2.DataSource = null;
dgv3.DataSource = null;
string usercode = LoginInfo.UserInfo.USER_CODE;
dataConn.ExeSql("delete from rst_ghtm_bom_comp where yhdm='" + LoginInfo.UserInfo.USER_CODE + "'");
string oldplancode1 = "", oldso1 = "", newplancode1 = "", newso1 = "", plinecode1 = "";
string sql = "";
sql = "select plan_code,plan_so,pline_code from data_product where sn='" + sn1 + "' ";
DataTable dt = dataConn.GetTable(sql);
if (dt.Rows.Count > 0)
{
newplancode1 = dt.Rows[0][0].ToString();
newso1 = dt.Rows[0][1].ToString();
plinecode1 = dt.Rows[0][2].ToString();
}
sql = "select plan_code,plan_so from data_record where sn='" + sn1 + "' order by work_time desc ";
dt = dataConn.GetTable(sql);
if (dt.Rows.Count > 0)
{
oldplancode1 = dt.Rows[0][0].ToString();
oldso1 = dt.Rows[0][1].ToString();
}
MW_COMPARE_GHTMBOM sp = new MW_COMPARE_GHTMBOM()
{
GHTM1 = sn1,
GZDD1 = plinecode1,
JHDM1 = oldplancode1,
JHSO1 = oldso1,
GZFLAG1 = "OLD",
GZDD2 = plinecode1,
JHDM2 = newplancode1,
JHSO2 = newso1,
GZFLAG2 = "NEW",
YHDM1 = usercode
};
Procedure.run(sp);
sql = "select GHTM ,ABOM_COMP ,ABOM_DESC ,ABOM_QTY ,ABOM_OP ,ABOM_WKCTR ,ABOM_JHDM ,ABOM_SO,GZDD ,ABOM_GYS ,case COMP_FLAG when '0' then '相同' when '1' then '原BOM有' when '2' then '新BOM有' end COMP_FLAG FROM RST_GHTM_BOM_COMP where YHDM='" + usercode + "' order by comp_flag desc,abom_comp asc";
DataTable dt1 = dataConn.GetTable(sql);
sql = "select sn,plan_code,station_name,location_code,process_code,item_code,item_name,item_qty,item_vendor,item_sn,to_char(create_time,'yyyy-mm-dd hh24:mi:ss') create_time from vw_data_sn_bom_temp where sn='" + sn1 + "' and plan_code='" + plancode1 + "' order by location_code,process_code,item_code,create_time desc";
DataTable dt2 = dataConn.GetTable(sql);
sql = "select sn,plan_code,station_name,location_code,detect_name,detect_value,user_id,to_char(work_time,'yyyy-mm-dd hh24:mi:ss') work_time from data_sn_detect_data_temp where sn='" + sn1 + "' and plan_code='" + plancode1 + "' order by work_time desc";
DataTable dt3 = dataConn.GetTable(sql);
dgv1.DataSource = dt1;
dgv2.DataSource = dt2;
dgv3.DataSource = dt3;
ShowQualityList();
timer1.Enabled = true;
}
