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