using System; using System.Data; using Core.Mes.ServerFrameWork; using Core.Mes.IBaseInterface; using System.Collections; using Core.XgMes.Server.StorageCommon; namespace Core.XgMes.Server.JGKC.SteelPlateManager { ///

/// SendListManager 的摘要说明。 ///

public class SendListManager:Core.Mes.ServerFrameWork.IComponent { public SendListManager() { // // TODO: 在此处添加构造函数逻辑 // } //获得库存的可发资源 public ReturnObject GetCanSendList(string where,string strRole) { try { string err = ""; string sql = ""; if (strRole == "bjbck") { sql = "SELECT 'FALSE' FLAG,C.PACTNO,C.PACTINDEX PLANNUMBER,TO_CHAR(C.SENDBEGINDATE,'YY-MM-DD') SENDBEGINDATE," + "A.ROLLNUMBER,A.ORDERNO,A.STOVENO,B.BUTTRESS,B.BUTTRESSLAYER,B.CONDOLENUMBER,B.CONDOLELAYER," + "A.BILLETID,A.INSTEEL,A.DETERMINANTCARDNUMBER,C.MULTISTEELNAME,A.PLY,A.WIDTH,A.LENGTH,A.THEORYWEIGHT," + "D.NAME_ RULE,E.NAME_ CUTSIDESTATE,F.NAME_ DETERMINANTRESULT,G.NAME_ JUDGEEASONCODE,A.DETERMINANTREASON," + "H.NAME_ ATTESTATIONORGAN,A.ATTESTATIONRESULT,I.NAME_ FACEQUALITY,J.NAME_ BUGREASON," + "K.NAME_ DEGRADEREASON,DECODE(A.HEATDEAL,'1','√',NULL) HEATDEAL,L.NAME_ DETECTMARBOOKIN," + "DECODE(A.STANDROLLERROLL,'1','√',NULL) STANDROLLERROLL,DECODE(A.TMCP,'1','√',NULL) TMCP," + "DECODE(A.HEATROLL,'1','√',NULL) HEATROLL,DECODE(A.CONTROLROLL,'1','√',NULL) CONTROLROLL," + "DECODE(A.ISHEATROLL,'1','√',NULL) ISHEATROLL,B.REMARK,C.STEELCODE OSTEEL,C.HEIGHT OPLY," + "C.WIDTH OWIDTH,C.LENGTH OLENGTH,C.FIXSIZE ORULE,C.SENDSTATUS OCUTSIDESTATE," + "DECODE(C.ISHEAT,'1','√',NULL) OHEATDEAL,C.ISCHECKSCAR ODETECT," + "DECODE(C.STANDROLLER,'1','√',NULL) OSTANDROLLERROLL,DECODE(C.TMCP,'1','√',NULL) OTMCP," + "DECODE(C.HEATROLL,'1','√',NULL) OHEATROLL,DECODE(C.CONTROLROLL,'1','√',NULL) OCONTROLROLL," + "DECODE(C.ISHEATROLL,'1','√',NULL) OISHEATROLL,A.DETERMINANTRESULT KDETERMINANTRESULT,A.DETECTMARBOOKIN KDETECT,'0' SENDFLAG," + "DECODE(A.ISCASTPROCESS,'1','√',NULL) ISCASTPROCESS,DECODE(A.ISPRINTPROCESS,'1','√',NULL) ISPRINTPROCESS," + "DECODE(A.MILLINGPROCESS,'1','√',NULL) MILLINGPROCESS," + "DECODE(M.ISD1,'1','√','×')||N.NAME_ SURFACETREATMENT," + "DECODE(M.ISD2,'1','√','×')||M.SURFACEROUGHNESS SURFACEROUGHNESS," + "DECODE(M.ISD3,'1','√','×')||M.COATTHICKNESS COATTHICKNESS," + "DECODE(M.ISD4,'1','√','×')||M.DRYINGTIME DRYINGTIME," + "M.VALIDTIME " + "FROM KCJ_TURNOFFLIST A,KCJ_TURNOFFBUTTRESSLIST B,SEL_PACTDETAIL C,SCM_BASE_INFO D," + "SCM_BASE_INFO E,SCM_BASE_INFO F,SCM_BASE_INFO G,SCM_BASE_INFO H,SCM_BASE_INFO I," + "SCM_BASE_INFO J,SCM_BASE_INFO K,SCM_BASE_INFO L,JGZJ_INSPECTIONINFO M,KCJ_BASEDATA N " + "WHERE B.BILLETID=A.BILLETID AND A.ORDERNO=C.ORDERNO(+) AND A.STORAGESTATUS='501602' " + "AND A.RULE=D.ID_(+) AND A.CLIPTYPEPROCESS=E.ID_(+) AND A.DETERMINANTRESULT=F.ID_(+) " + "AND A.JUDGEEASONCODE=G.ID_(+) AND C.CHECKORG=H.ID_(+) AND A.FACEQUALITY=I.ID_(+) " + "AND A.BUGREASON=J.ID_(+) AND A.DEGRADEREASON=K.ID_(+) AND A.DETECTMARBOOKIN=L.ID_(+) " + "AND A.INSPECTIONID=M.INSPECTIONID(+) AND M.SURFACETREATMENT=N.ID_(+) AND B.AREA IN ('北京办区域','北京办(长沙库)')" + where; } else { sql = "SELECT 'FALSE' FLAG,C.PACTNO,C.PACTINDEX PLANNUMBER,TO_CHAR(C.SENDBEGINDATE,'YY-MM-DD') SENDBEGINDATE," + "A.ROLLNUMBER,A.ORDERNO,A.STOVENO,B.BUTTRESS,B.BUTTRESSLAYER,B.CONDOLENUMBER,B.CONDOLELAYER," + "A.BILLETID,A.INSTEEL,A.DETERMINANTCARDNUMBER,C.MULTISTEELNAME,A.PLY,A.WIDTH,A.LENGTH,A.THEORYWEIGHT," + "D.NAME_ RULE,E.NAME_ CUTSIDESTATE,F.NAME_ DETERMINANTRESULT,G.NAME_ JUDGEEASONCODE,A.DETERMINANTREASON," + "H.NAME_ ATTESTATIONORGAN,A.ATTESTATIONRESULT,I.NAME_ FACEQUALITY,J.NAME_ BUGREASON," + "K.NAME_ DEGRADEREASON,DECODE(A.HEATDEAL,'1','√',NULL) HEATDEAL,L.NAME_ DETECTMARBOOKIN," + "DECODE(A.STANDROLLERROLL,'1','√',NULL) STANDROLLERROLL,DECODE(A.TMCP,'1','√',NULL) TMCP," + "DECODE(A.HEATROLL,'1','√',NULL) HEATROLL,DECODE(A.CONTROLROLL,'1','√',NULL) CONTROLROLL," + "DECODE(A.ISHEATROLL,'1','√',NULL) ISHEATROLL,B.REMARK,C.STEELCODE OSTEEL,C.HEIGHT OPLY," + "C.WIDTH OWIDTH,C.LENGTH OLENGTH,C.FIXSIZE ORULE,C.SENDSTATUS OCUTSIDESTATE," + "DECODE(C.ISHEAT,'1','√',NULL) OHEATDEAL,C.ISCHECKSCAR ODETECT," + "DECODE(C.STANDROLLER,'1','√',NULL) OSTANDROLLERROLL,DECODE(C.TMCP,'1','√',NULL) OTMCP," + "DECODE(C.HEATROLL,'1','√',NULL) OHEATROLL,DECODE(C.CONTROLROLL,'1','√',NULL) OCONTROLROLL," + "DECODE(C.ISHEATROLL,'1','√',NULL) OISHEATROLL,A.DETERMINANTRESULT KDETERMINANTRESULT,A.DETECTMARBOOKIN KDETECT,'0' SENDFLAG," + "DECODE(A.ISCASTPROCESS,'1','√',NULL) ISCASTPROCESS,DECODE(A.ISPRINTPROCESS,'1','√',NULL) ISPRINTPROCESS," + "DECODE(A.MILLINGPROCESS,'1','√',NULL) MILLINGPROCESS," + "DECODE(M.ISD1,'1','√','×')||N.NAME_ SURFACETREATMENT," + "DECODE(M.ISD2,'1','√','×')||M.SURFACEROUGHNESS SURFACEROUGHNESS," + "DECODE(M.ISD3,'1','√','×')||M.COATTHICKNESS COATTHICKNESS," + "DECODE(M.ISD4,'1','√','×')||M.DRYINGTIME DRYINGTIME," + "M.VALIDTIME " + "FROM KCJ_TURNOFFLIST A,KCJ_TURNOFFBUTTRESSLIST B,SEL_PACTDETAIL C,SCM_BASE_INFO D," + "SCM_BASE_INFO E,SCM_BASE_INFO F,SCM_BASE_INFO G,SCM_BASE_INFO H,SCM_BASE_INFO I," + "SCM_BASE_INFO J,SCM_BASE_INFO K,SCM_BASE_INFO L,JGZJ_INSPECTIONINFO M,KCJ_BASEDATA N " + "WHERE B.BILLETID=A.BILLETID AND A.ORDERNO=C.ORDERNO(+) AND A.STORAGESTATUS='501602' " + "AND A.RULE=D.ID_(+) AND A.CLIPTYPEPROCESS=E.ID_(+) AND A.DETERMINANTRESULT=F.ID_(+) " + "AND A.JUDGEEASONCODE=G.ID_(+) AND C.CHECKORG=H.ID_(+) AND A.FACEQUALITY=I.ID_(+) " + "AND A.BUGREASON=J.ID_(+) AND A.DEGRADEREASON=K.ID_(+) AND A.DETECTMARBOOKIN=L.ID_(+) " + "AND A.INSPECTIONID=M.INSPECTIONID(+) AND M.SURFACETREATMENT=N.ID_(+) AND B.AREA<>'北京办区域' " + where; } System.Data.DataSet rtndst = this.DBManager.ExecuteQuery(sql,out err); if(rtndst!=null && rtndst.Tables.Count==1 && rtndst.Tables[0].Rows.Count>0) { rtndst.Tables[0].TableName = "KCZ_TURNOFFBUTTRESSLIST_VIEW"; return new ReturnObject(rtndst); } else { return new ReturnObject(null); } } catch(System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return new ReturnObject(null,10000,ex.ToString()); } } public ReturnObject GetCanSendListYL(string where, string strRole) { try { string err = ""; string sql = ""; sql = "SELECT 'FALSE' FLAG,C.PACTNO,C.PACTINDEX PLANNUMBER,TO_CHAR(C.SENDBEGINDATE,'YY-MM-DD') SENDBEGINDATE," +"A.ROLLNUMBER,A.ORDERNO,A.STOVENO,B.BUTTRESS,B.BUTTRESSLAYER,B.CONDOLENUMBER,B.CONDOLELAYER," +"A.BILLETID,A.INSTEEL,A.DETERMINANTCARDNUMBER,C.MULTISTEELNAME,A.PLY,A.WIDTH,A.LENGTH,A.THEORYWEIGHT," +"D.NAME_ RULE,E.NAME_ CUTSIDESTATE,F.NAME_ DETERMINANTRESULT,G.NAME_ JUDGEEASONCODE,A.DETERMINANTREASON," +"H.NAME_ ATTESTATIONORGAN,A.ATTESTATIONRESULT,I.NAME_ FACEQUALITY,J.NAME_ BUGREASON," +"K.NAME_ DEGRADEREASON,DECODE(A.HEATDEAL,'1','√',NULL) HEATDEAL,L.NAME_ DETECTMARBOOKIN," +"DECODE(A.STANDROLL,'1','√',NULL) STANDROLLERROLL,DECODE(A.TMCP,'1','√',NULL) TMCP," +"DECODE(A.HEATROLL,'1','√',NULL) HEATROLL,DECODE(A.CONTROLROLL,'1','√',NULL) CONTROLROLL," +"DECODE(A.ISHEATROLL,'1','√',NULL) ISHEATROLL,B.REMARK,C.STEELCODE OSTEEL,C.HEIGHT OPLY," +"C.WIDTH OWIDTH,C.LENGTH OLENGTH,C.FIXSIZE ORULE,C.SENDSTATUS OCUTSIDESTATE," +"DECODE(C.ISHEAT,'1','√',NULL) OHEATDEAL,C.ISCHECKSCAR ODETECT," +"DECODE(C.STANDROLLER,'1','√',NULL) OSTANDROLLERROLL,DECODE(C.TMCP,'1','√',NULL) OTMCP," +"DECODE(C.HEATROLL,'1','√',NULL) OHEATROLL,DECODE(C.CONTROLROLL,'1','√',NULL) OCONTROLROLL," +"DECODE(C.ISHEATROLL,'1','√',NULL) OISHEATROLL,A.DETERMINANTRESULT KDETERMINANTRESULT,A.DETECTMARBOOKIN KDETECT,'0' SENDFLAG," +"DECODE(A.ISCASTPROCESS,'1','√',NULL) ISCASTPROCESS,DECODE(A.ISPRINTPROCESS,'1','√',NULL) ISPRINTPROCESS," +"DECODE(A.MILLINGPROCESS,'1','√',NULL) MILLINGPROCESS," +"''SURFACETREATMENT," +"'' SURFACEROUGHNESS," +"'' COATTHICKNESS," +"'' DRYINGTIME," +"'' VALIDTIME " +"FROM KCJ_STORAGELIST A,KCJ_STORAGEBUTTRESSLIST B,SEL_PACTDETAIL C,SCM_BASE_INFO D," +"SCM_BASE_INFO E,SCM_BASE_INFO F,SCM_BASE_INFO G,SCM_BASE_INFO H,SCM_BASE_INFO I," +"SCM_BASE_INFO J,SCM_BASE_INFO K,SCM_BASE_INFO L " +"WHERE B.BILLETID=A.BILLETID AND A.ORDERNO=C.ORDERNO(+) AND A.STORAGESTATUS='501002' " +"AND A.RULE=D.ID_(+) AND A.CLIPTYPEPROCESS=E.ID_(+) AND A.DETERMINANTRESULT=F.ID_(+) " + "AND A.JUDGEEASONCODE=G.ID_(+) AND C.CHECKORG=H.ID_(+) AND A.FACEQUALITY=I.ID_(+) " +" AND A.BUGREASON=J.ID_(+) AND A.DEGRADEREASON=K.ID_(+) AND A.DETECTMARBOOKIN=L.ID_(+) " + where +"UNION " +"SELECT 'FALSE' FLAG,C.PACTNO,C.PACTINDEX PLANNUMBER,TO_CHAR(C.SENDBEGINDATE,'YY-MM-DD') SENDBEGINDATE," +"A.ROLLNUMBER,A.ORDERNO,A.STOVENO,B.BUTTRESS,B.BUTTRESSLAYER,B.CONDOLENUMBER,B.CONDOLELAYER," +"A.BILLETID,A.INSTEEL,A.DETERMINANTCARDNUMBER,C.MULTISTEELNAME,A.PLY,A.WIDTH,A.LENGTH,A.THEORYWEIGHT," +"D.NAME_ RULE,E.NAME_ CUTSIDESTATE,F.NAME_ DETERMINANTRESULT,G.NAME_ JUDGEEASONCODE,A.DETERMINANTREASON," +"H.NAME_ ATTESTATIONORGAN,A.ATTESTATIONRESULT,I.NAME_ FACEQUALITY,J.NAME_ BUGREASON," +"K.NAME_ DEGRADEREASON,DECODE(A.HEATDEAL,'1','√',NULL) HEATDEAL,L.NAME_ DETECTMARBOOKIN," +"DECODE(A.STANDROLL,'1','√',NULL) STANDROLLERROLL,DECODE(A.TMCP,'1','√',NULL) TMCP," +"DECODE(A.HEATROLL,'1','√',NULL) HEATROLL,DECODE(A.CONTROLROLL,'1','√',NULL) CONTROLROLL," +"DECODE(A.ISHEATROLL,'1','√',NULL) ISHEATROLL,B.REMARK,C.STEELCODE OSTEEL,C.HEIGHT OPLY," +"C.WIDTH OWIDTH,C.LENGTH OLENGTH,C.FIXSIZE ORULE,C.SENDSTATUS OCUTSIDESTATE," +"DECODE(C.ISHEAT,'1','√',NULL) OHEATDEAL,C.ISCHECKSCAR ODETECT," +"DECODE(C.STANDROLLER,'1','√',NULL) OSTANDROLLERROLL,DECODE(C.TMCP,'1','√',NULL) OTMCP," +"DECODE(C.HEATROLL,'1','√',NULL) OHEATROLL,DECODE(C.CONTROLROLL,'1','√',NULL) OCONTROLROLL," +"DECODE(C.ISHEATROLL,'1','√',NULL) OISHEATROLL,A.DETERMINANTRESULT KDETERMINANTRESULT,A.DETECTMARBOOKIN KDETECT,'0' SENDFLAG," +"DECODE(A.ISCASTPROCESS,'1','√',NULL) ISCASTPROCESS,DECODE(A.ISPRINTPROCESS,'1','√',NULL) ISPRINTPROCESS," +"DECODE(A.MILLINGPROCESS,'1','√',NULL) MILLINGPROCESS," +"''SURFACETREATMENT," +"'' SURFACEROUGHNESS," +"'' COATTHICKNESS," +"'' DRYINGTIME," +"'' VALIDTIME " +"FROM KCP_STORAGELIST A,KCJ_STORAGEBUTTRESSLIST B,SEL_PACTDETAIL C,SCM_BASE_INFO D," +"SCM_BASE_INFO E,SCM_BASE_INFO F,SCM_BASE_INFO G,SCM_BASE_INFO H,SCM_BASE_INFO I," +"SCM_BASE_INFO J,SCM_BASE_INFO K,SCM_BASE_INFO L " +"WHERE B.BILLETID=A.BILLETID AND A.ORDERNO=C.ORDERNO(+) AND A.STORAGESTATUS='501002' " +"AND A.RULE=D.ID_(+) AND A.CLIPTYPEPROCESS=E.ID_(+) AND A.DETERMINANTRESULT=F.ID_(+) " + "AND A.JUDGEEASONCODE=G.ID_(+) AND C.CHECKORG=H.ID_(+) AND A.FACEQUALITY=I.ID_(+) " +" AND A.BUGREASON=J.ID_(+) AND A.DEGRADEREASON=K.ID_(+) AND A.DETECTMARBOOKIN=L.ID_(+) " + where; System.Data.DataSet rtndst = this.DBManager.ExecuteQuery(sql, out err); if (rtndst != null && rtndst.Tables.Count == 1 && rtndst.Tables[0].Rows.Count > 0) { rtndst.Tables[0].TableName = "KCZ_TURNOFFBUTTRESSLIST_VIEW"; return new ReturnObject(rtndst); } else { return new ReturnObject(null); } } catch (System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return new ReturnObject(null, 10000, ex.ToString()); } } public ReturnObject GETBALANCEINFOINIT(string where) { try { string err = ""; string sql = ""; sql = "select pactno,BUYERCODE,a.ASKPLAN_ID,MIN( billno) billno,INCEPTCORPCODE, STATIONCODE,INVOICENO,MIN(PRICE) PRICE, MIN(BASEPRICE) BASEPRICE," + "(SELECT B.UNLOADDOCK FROM SEL_STATIONINFO B WHERE A.DOCKCODE=B.STATIONCODE)DOCKCODE, min(a.PRODUCTLINE) PRODUCTLINE,BJ_AREA(A.LISTNUMBER,'1',SPETKEY)ACREAGE,BJ_AREA(A.LISTNUMBER,'2',SPETKEY)WORK_REQUIRE," + "(SELECT B.GLYF FROM SEL_STATIONINFO B WHERE A.DOCKCODE=B.STATIONCODE)GLYF," + "(SELECT B.ZZFY FROM SEL_STATIONINFO B WHERE A.DOCKCODE=B.STATIONCODE)ZZFY," + "(SELECT B.CYF FROM SEL_STATIONINFO B WHERE A.DOCKCODE=B.STATIONCODE)CYF," + "trunc(max(PICKSTORAGETIME)) PICKSTORAGETIME,sum(WEIGHT) WEIGHT,sum(quantity) QUANTITY,TO_NUMBER(NULL) CATCHMONEY," + "TRAINWAGON, VEHICLETYPE,LISTNUMBER, max(CASE WHEN PRODUCTLINE='4001ZB1' and remark is not null THEN 51||SUBSTR(remark,3) WHEN PRODUCTLINE='4001HB1'and remark is not null THEN 52||SUBSTR(remark,3) ELSE remark END ) remark, MIN(AREACODE) AREACODE,SPETKEY, MIN(STEELCODEKEY)STEELCODEKEY," + "max(transmoney) transmoney, decode(max(ISLOCKPRICE), '1', '是', '否') ISLOCKPRICE," + "forecorpcode, min(A.ISOVERLEN) ISOVERLEN ,MIN(MOTORMANNAME) MOTORMANNAME from SEL_BALANCEINFO_NEW@xgxs a where 1 = 1 "+where + " group by LISTNUMBER,pactno,BUYERCODE,a.askplan_id,inceptcorpcode,DOCKCODE,INVOICENO," + "stationcode,TRAINWAGON,VEHICLETYPE, forecorpcode,SPETKEY " + " order by buyercode, pactno, askplan_id"; System.Data.DataSet rtndst = this.DBManager.ExecuteQuery(sql, out err); if (rtndst != null && rtndst.Tables.Count == 1 && rtndst.Tables[0].Rows.Count > 0) { return new ReturnObject(rtndst); } else { return new ReturnObject(null); } } catch (System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return new ReturnObject(null, 10000, ex.ToString()); } } public ReturnObject GETBALANCEDETALINVO(string where) { try { string err = ""; string sql = ""; sql = "select orderno,askplan_id, STEELCODEKEY steelcode, spet, weight, quantity, price, money, baseprice," + "0 adjustprice, isheat, ischeckscar, listnumber,TO_CHAR(NVL(price,0)- NVL(baseprice,0))CJ," + "spetkey rowrelation, BASEPRICEFILE BASEFILEID, ADJUPRICEFILE ADJUFILEID," + "(SELECT NAME_ FROM SEL_BASEPRICEINFO WHERE ID_ = A.BASEPRICEFILE AND ISBASE = '0') BASEFILE," + "(SELECT NAME_ FROM SEL_BASEPRICEINFO WHERE ID_ = A.ADJUPRICEFILE AND ISBASE = '1') ADJUFILE," + "A.BALANCENO ,A.INVOICENO PH,to_char(A.INVOICEDATE,'yyyy-mm-dd') KPTIME " + " from SEL_BALANCEINFO_NEW_INVOICE@xgxs a where 1=1 "+ where; System.Data.DataSet rtndst = this.DBManager.ExecuteQuery(sql, out err); if (rtndst != null && rtndst.Tables.Count == 1 && rtndst.Tables[0].Rows.Count > 0) { return new ReturnObject(rtndst); } else { return new ReturnObject(null); } } catch (System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return new ReturnObject(null, 10000, ex.ToString()); } } public ReturnObject GETBALANCEDETAL(string where) { try { string err = ""; string sql = ""; sql = "select orderno,askplan_id, STEELCODEKEY steelcode, spet, weight, quantity, price, money, baseprice, to_char(ZYFMONEY)ZYFMONEY," + "TO_CHAR(NVL(price,0)- NVL(baseprice,0))CJ," + "0 adjustprice, isheat, ischeckscar, listnumber," + "spetkey rowrelation, BASEPRICEFILE BASEFILEID, ADJUPRICEFILE ADJUFILEID," + "(SELECT NAME_ FROM SEL_BASEPRICEINFO WHERE ID_ = A.BASEPRICEFILE AND ISBASE = '0') BASEFILE," + "(SELECT NAME_ FROM SEL_BASEPRICEINFO WHERE ID_ = A.ADJUPRICEFILE AND ISBASE = '1') ADJUFILE,A.BALANCENO " + " from SEL_BALANCEINFO_NEW@xgxs a where 1=1 " + where; System.Data.DataSet rtndst = this.DBManager.ExecuteQuery(sql, out err); if (rtndst != null && rtndst.Tables.Count == 1 && rtndst.Tables[0].Rows.Count > 0) { return new ReturnObject(rtndst); } else { return new ReturnObject(null); } } catch (System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return new ReturnObject(null, 10000, ex.ToString()); } } public ReturnObject GETBALANCEDETALC(string where) { try { string err = ""; string sql = ""; sql = "select a.orderno, a.SERIALNUMBER, a.weight, a.CUTSIDESTATE, a.PICKSTORAGETIME," + "a.stoveno, a.STEELCODE, a.listnumber, b.spetkey rowrelation ,A.BALANCENO from " + "SEL_BALANCEDETAIL_ALL@xgxs a, SEL_BALANCEINFO_NEW_INVOICE@xgxs b " + "where A.BALANCENO=B.BALANCENO " + where + "order by a.SERIALNUMBER" ; System.Data.DataSet rtndst = this.DBManager.ExecuteQuery(sql, out err); if (rtndst != null && rtndst.Tables.Count == 1 && rtndst.Tables[0].Rows.Count > 0) { return new ReturnObject(rtndst); } else { return new ReturnObject(null); } } catch (System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return new ReturnObject(null, 10000, ex.ToString()); } } public ReturnObject GETBALANCEDETAL_LIST(string where) { try { string err = ""; string sql = ""; sql = "select a.orderno, a.SERIALNUMBER, a.weight, a.CUTSIDESTATE, a.PICKSTORAGETIME," + "a.stoveno, a.STEELCODE, a.listnumber, b.spetkey rowrelation ,A.BALANCENO from " + " SEL_BALANCEDETAIL_ALL@xgxs a, SEL_BALANCEINFO_NEW@xgxs b " + "where A.BALANCENO=B.BALANCENO " + where + "order by a.SERIALNUMBER"; System.Data.DataSet rtndst = this.DBManager.ExecuteQuery(sql, out err); if (rtndst != null && rtndst.Tables.Count == 1 && rtndst.Tables[0].Rows.Count > 0) { return new ReturnObject(rtndst); } else { return new ReturnObject(null); } } catch (System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return new ReturnObject(null, 10000, ex.ToString()); } } public ReturnObject GETBALANCEINFO(string where) { try { string err = ""; string sql = ""; sql = "select pactno, BUYERCODE,a.ASKPLAN_ID,MIN( billno) billno,INCEPTCORPCODE, STATIONCODE,INVOICENO,MIN(PRICE) PRICE, MIN(BASEPRICE) BASEPRICE," + "(SELECT B.UNLOADDOCK FROM SEL_STATIONINFO B WHERE A.DOCKCODE=B.STATIONCODE)DOCKCODE, min(a.PRODUCTLINE) PRODUCTLINE,BJ_AREA(A.LISTNUMBER,'1',SPETKEY)ACREAGE,BJ_AREA(A.LISTNUMBER,'2',SPETKEY)WORK_REQUIRE," + "(SELECT B.GLYF FROM SEL_STATIONINFO B WHERE A.DOCKCODE=B.STATIONCODE)GLYF," + "(SELECT B.ZZFY FROM SEL_STATIONINFO B WHERE A.DOCKCODE=B.STATIONCODE)ZZFY," + "(SELECT B.CYF FROM SEL_STATIONINFO B WHERE A.DOCKCODE=B.STATIONCODE)CYF," + "trunc(max(PICKSTORAGETIME)) PICKSTORAGETIME,sum(WEIGHT) WEIGHT,sum(quantity) QUANTITY,TO_NUMBER(NULL) CATCHMONEY," + "TRAINWAGON, VEHICLETYPE,LISTNUMBER, max(CASE WHEN PRODUCTLINE='4001ZB1' and remark is not null THEN 51||SUBSTR(remark,3) WHEN PRODUCTLINE='4001HB1' and remark is not null THEN 52||SUBSTR(remark,3) ELSE remark END ) remark, MIN(AREACODE) AREACODE,SPETKEY SPETKEY, MIN(STEELCODEKEY)STEELCODEKEY," + "max(transmoney) transmoney, decode(max(ISLOCKPRICE), '1', '是', '否') ISLOCKPRICE," + "forecorpcode, min(A.ISOVERLEN) ISOVERLEN ,MIN(MOTORMANNAME) MOTORMANNAME from SEL_BALANCEINFO_NEW_INVOICE@xgxs a where 1 = 1 " + where + " group by LISTNUMBER,pactno,BUYERCODE,a.askplan_id,inceptcorpcode,DOCKCODE,INVOICENO," + "stationcode,TRAINWAGON,VEHICLETYPE, forecorpcode,SPETKEY " + " order by buyercode, pactno, askplan_id"; System.Data.DataSet rtndst = this.DBManager.ExecuteQuery(sql, out err); if (rtndst != null && rtndst.Tables.Count == 1 && rtndst.Tables[0].Rows.Count > 0) { return new ReturnObject(rtndst); } else { return new ReturnObject(null); } } catch (System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return new ReturnObject(null, 10000, ex.ToString()); } } public ReturnObject GetAskPlanData(string where,string strlx) { try { string PSql = ""; if (strlx == "1") { PSql = " SELECT T1.ASKPLAN_ID,T1.PACTNO,C.BUYERNAME BUYERCODE,B.INCEPTCORPNAME INCEPTCORPCODE,T1.INCEPTDATE,T1.WEIGHT,T1.TRANSNO,T1.REMARK " + " FROM KCJ_PLAN T1,SEL_INCEPTCORPINFO B,SEL_BUYERBASEINFO C WHERE T1.INCEPTCORPCODE=B.INCEPTCORPCODE(+) AND T1.=C.BUYERCODE(+) " + " AND T1.ISVALID='1' AND T1.PL='0' "+where; } else { PSql = " SELECT T1.ASKPLAN_ID,T1.PACTNO,C.BUYERNAME BUYERCODE,B.INCEPTCORPNAME INCEPTCORPCODE,T1.INCEPTDATE,T1.WEIGHT,T1.TRANSNO,T1.REMARK " + " FROM KCJ_PLAN T1,SEL_INCEPTCORPINFO B,SEL_BUYERBASEINFO C WHERE T1.INCEPTCORPCODE=B.INCEPTCORPCODE(+) AND T1.=C.BUYERCODE(+) " + " AND T1.ISVALID='1' AND T1.PL='1' " + where; } string err = ""; System.Data.DataSet rtndst = new DataSet(); System.Data.DataSet tmpdst = this.DBManager.ExecuteQuery(PSql, out err); if (tmpdst != null && tmpdst.Tables.Count == 1 && tmpdst.Tables[0].Rows.Count > 0) { return new ReturnObject(tmpdst); } else { return new ReturnObject(null); } } catch (System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return new ReturnObject(null); } } public ReturnObject GetAskPlanData_PS_BC(string where) { try { string PSql = "SELECT T1.INCEPTCORPCODE,T1.INCEPTCORPNAME,T1.STATIONCODE,T1.STATIONNAME,T1.PLANDATE,T1.PACTNO,MAX(T1.SPET)SPET," + "SUM(DECODE(T1.CARAFFIRM,'1',1,'2',1,'3',1,0)) PLANQUANTITY," + "SUM(DECODE(T1.CARAFFIRM,'1',T1.WEIGHT,'2',T1.WEIGHT,'3',T1.WEIGHT,0)) PLANWEIGHT," + "SUM(DECODE(T1.AFFIRMSTATUS,'1',1,0)) AFFIRMQUANTITY," + "SUM(DECODE(T1.AFFIRMSTATUS,'1',T1.WEIGHT,0)) AFFIRMWEIGHT " + "FROM " + "(" + "SELECT A.INCEPTCORPCODE,B.INCEPTCORPNAME,A.STATIONCODE,C.STATIONNAME,A.ASKPLAN_ID,A.SPET," + "TO_CHAR(A.PLANDATE,'YY-MM-DD') PLANDATE,A.CARAFFIRM,A.WEIGHT,A.AFFIRMSTATUS,A.PACTNO " + "FROM SEL_ASKVEHICLEPLANINFL A,SEL_INCEPTCORPINFO B,SEL_STATIONINFO C " + "WHERE (INSTR(A.LOADPOSITION, '1009JB') > 0 ) AND A.INCEPTCORPCODE=B.INCEPTCORPCODE AND A.STATIONCODE=C.STATIONCODE " + "AND A.CARAFFIRM NOT IN('4','5','0') " + where + ") T1 " + "GROUP BY T1.INCEPTCORPCODE,T1.INCEPTCORPNAME,T1.STATIONCODE,T1.STATIONNAME,T1.PLANDATE,T1.PACTNO"; string err = ""; System.Data.DataSet rtndst = new DataSet(); System.Data.DataSet tmpdst = this.DBManager.ExecuteQuery(PSql, out err); if (tmpdst != null && tmpdst.Tables.Count == 1 && tmpdst.Tables[0].Rows.Count > 0) { tmpdst.Tables[0].TableName = "SEL_ASKVEHICLEPLAN_P"; rtndst.Merge(tmpdst.Tables[0].Copy()); tmpdst = null; string CSql = "SELECT T1.* " + "FROM " + "(" + "SELECT A.INCEPTCORPCODE,B.INCEPTCORPNAME,A.STATIONCODE,C.STATIONNAME,A.ASKPLAN_ID,A.PACTINDEXDETAIL,A.SPET," + "TO_CHAR(A.PLANDATE,'YY-MM-DD') PLANDATE,A.CARAFFIRM,A.WEIGHT,A.STEELCODE,A.QUANTITY,A.ISCLEARSTORAGE," + "DECODE(A.AFFIRMSTATUS,'1','√',NULL) AFFIRMSTATUS,TO_CHAR(A.INPUTTIME,'YY-MM-DD HH24') INPUTTIME,A.TRANSNO VECIHLENO," + "TO_CHAR(A.AFFIRMTIME,'YY-MM-DD HH24') AFFIRMTIME,E.NAME_ CATEGORY,A.REMARK,A.PACTNO,G.NAME_ TRANSTYPE,H.NAME_ TRAINTYPE " + "FROM SEL_ASKVEHICLEPLANINFL A,SEL_INCEPTCORPINFO B,SEL_STATIONINFO C,SCM_BASE_INFO E,SCM_BASE_INFO G,SCM_BASE_INFO H " + "WHERE (INSTR(A.LOADPOSITION, '1009JB') > 0 ) AND A.INCEPTCORPCODE=B.INCEPTCORPCODE AND A.STATIONCODE=C.STATIONCODE AND A.CATEGORY=E.ID_(+) AND A.TRANSTYPE=G.ID_(+) AND A.TRAINTYPE=H.ID_(+) " + "AND A.CARAFFIRM NOT IN('4','5','0') " + where + ") T1 " ; tmpdst = this.DBManager.ExecuteQuery(CSql, out err); if (tmpdst != null && tmpdst.Tables.Count == 1 && tmpdst.Tables[0].Rows.Count > 0) { tmpdst.Tables[0].TableName = "SEL_ASKVEHICLEPLAN_C"; rtndst.Merge(tmpdst.Tables[0].Copy()); rtndst.Tables["SEL_ASKVEHICLEPLAN_P"].PrimaryKey = new System.Data.DataColumn[] { rtndst.Tables["SEL_ASKVEHICLEPLAN_P"].Columns["PLANDATE"], rtndst.Tables["SEL_ASKVEHICLEPLAN_P"].Columns["INCEPTCORPCODE"], rtndst.Tables["SEL_ASKVEHICLEPLAN_P"].Columns["PACTNO"], rtndst.Tables["SEL_ASKVEHICLEPLAN_P"].Columns["STATIONCODE"] }; rtndst.Relations.Add("SEL_ASKVEHICLEPLAN_C", new System.Data.DataColumn[] { rtndst.Tables["SEL_ASKVEHICLEPLAN_P"].Columns["PLANDATE"], rtndst.Tables["SEL_ASKVEHICLEPLAN_P"].Columns["INCEPTCORPCODE"], rtndst.Tables["SEL_ASKVEHICLEPLAN_P"].Columns["PACTNO"], rtndst.Tables["SEL_ASKVEHICLEPLAN_P"].Columns["STATIONCODE"] }, new System.Data.DataColumn[] { rtndst.Tables["SEL_ASKVEHICLEPLAN_C"].Columns["PLANDATE"], rtndst.Tables["SEL_ASKVEHICLEPLAN_C"].Columns["INCEPTCORPCODE"], rtndst.Tables["SEL_ASKVEHICLEPLAN_C"].Columns["PACTNO"], rtndst.Tables["SEL_ASKVEHICLEPLAN_C"].Columns["STATIONCODE"]}); return new ReturnObject(rtndst); } } return new ReturnObject(null); } catch (System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return new ReturnObject(null); } } public ReturnObject GetListCoding(string type, string Year) { try { string err = ""; Oracle.DataAccess.Client.OracleParameter ptype = new Oracle.DataAccess.Client.OracleParameter("vtype", Oracle.DataAccess.Client.OracleDbType.Varchar2); Oracle.DataAccess.Client.OracleParameter pYear = new Oracle.DataAccess.Client.OracleParameter("vYear", Oracle.DataAccess.Client.OracleDbType.Varchar2); Oracle.DataAccess.Client.OracleParameter pListCoding = new Oracle.DataAccess.Client.OracleParameter("vListCoding", Oracle.DataAccess.Client.OracleDbType.Varchar2); ptype.Direction = ParameterDirection.Input; pYear.Direction = ParameterDirection.Input; pListCoding.Direction = ParameterDirection.Output; ptype.Value = type; pYear.Value = Year; pListCoding.Size = 400; ((STMes.DBManager)DBManagerList["ODPDB"]).ExecuteNonQuery_NoDBSever("KCJ_GetListCoding", CommandType.StoredProcedure, new Oracle.DataAccess.Client.OracleParameter[] { ptype, pYear, pListCoding }, out err); return new ReturnObject(FixDBManager.CheckNullStr(pListCoding.Value)); } catch (System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return new ReturnObject(null); } } public ReturnObject GetListCodingTH(string type, string Year) { try { string err = ""; Oracle.DataAccess.Client.OracleParameter ptype = new Oracle.DataAccess.Client.OracleParameter("vtype", Oracle.DataAccess.Client.OracleDbType.Varchar2); Oracle.DataAccess.Client.OracleParameter pYear = new Oracle.DataAccess.Client.OracleParameter("vYear", Oracle.DataAccess.Client.OracleDbType.Varchar2); Oracle.DataAccess.Client.OracleParameter pListCoding = new Oracle.DataAccess.Client.OracleParameter("vListCoding", Oracle.DataAccess.Client.OracleDbType.Varchar2); ptype.Direction = ParameterDirection.Input; pYear.Direction = ParameterDirection.Input; pListCoding.Direction = ParameterDirection.Output; ptype.Value = type; pYear.Value = Year; pListCoding.Size = 400; ((STMes.DBManager)DBManagerList["ODPDB"]).ExecuteNonQuery_NoDBSever("KCJ_GetListCoding_TH", CommandType.StoredProcedure, new Oracle.DataAccess.Client.OracleParameter[] { ptype, pYear, pListCoding }, out err); return new ReturnObject(FixDBManager.CheckNullStr(pListCoding.Value)); } catch (System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return new ReturnObject(null); } } //获得排车计划 public ReturnObject GetAskPlanData(string where) { try { string err = ""; string MinAskPlanID = ""; string MaxAskPlanID = ""; string MinSql = "SELECT MIN(A.ASKPLAN_ID) FROM SEL_ASKVEHICLEPLANINFL A,SEL_INCEPTCORPINFO B," + "SEL_STATIONINFO C,SCM_BASE_INFO D,SCM_BASE_INFO G,SCM_BASE_INFO H " + "WHERE INSTR(A.LOADPOSITION, '1009JB') > 0 AND A.INCEPTCORPCODE = B.INCEPTCORPCODE " + "AND A.STATIONCODE = C.STATIONCODE AND A.CARAFFIRM NOT IN ('4', '5', '0') AND A.CATEGORY = D.ID_(+) " + "AND A.TRANSTYPE = G.ID_(+) AND A.TRAINTYPE = H.ID_(+) AND A.AFFIRMSTATUS = '1' " + where; System.Data.DataSet tmpMinDst = this.DBManager.ExecuteQuery(MinSql, out err); if (tmpMinDst != null && tmpMinDst.Tables.Count == 1 && tmpMinDst.Tables[0].Rows.Count > 0) { MinAskPlanID = tmpMinDst.Tables[0].Rows[0][0].ToString(); } else { return new ReturnObject(null); } string MaxSql = "SELECT MAX(A.ASKPLAN_ID) FROM SEL_ASKVEHICLEPLANINFL A,SEL_INCEPTCORPINFO B," + "SEL_STATIONINFO C,SCM_BASE_INFO D,SCM_BASE_INFO G,SCM_BASE_INFO H " + "WHERE INSTR(A.LOADPOSITION, '1009JB') > 0 AND A.INCEPTCORPCODE = B.INCEPTCORPCODE " + "AND A.STATIONCODE = C.STATIONCODE AND A.CARAFFIRM NOT IN ('4', '5', '0') AND A.CATEGORY = D.ID_(+) " + "AND A.TRANSTYPE = G.ID_(+) AND A.TRAINTYPE = H.ID_(+) AND A.AFFIRMSTATUS = '1' " + where; System.Data.DataSet tmpMaxDst = this.DBManager.ExecuteQuery(MaxSql, out err); if (tmpMaxDst != null && tmpMaxDst.Tables.Count == 1 && tmpMaxDst.Tables[0].Rows.Count > 0) { MaxAskPlanID = tmpMaxDst.Tables[0].Rows[0][0].ToString(); } else { return new ReturnObject(null); } string CSql = "SELECT T1.*," +"NVL(HSENDQUANTITY,0)+NVL(ZSENDQUANTITY,0)+NVL(JSENDQUANTITY,0) SENDQUANTITY," +"NVL(HSENDWEIGHT,0)+NVL(ZSENDWEIGHT,0)+NVL(JSENDWEIGHT,0) SENDWEIGHT," +"DECODE(T4.PLCOUNT,2,'√',1,NULL) ISHB," +"(CASE WHEN T4.CLEARCOUNT=0 THEN '正常' WHEN T4.ASKCOUNT=T4.CLEARCOUNT THEN '清库' WHEN T4.CLEARCOUNT>0 AND T4.ASKCOUNT>T4.CLEARCOUNT THEN '拼装' ELSE '正常' END) ISCLEAR " +"FROM " +"(" +"SELECT B.INCEPTCORPNAME,C.STATIONNAME,A.ASKPLAN_ID,A.PACTINDEXDETAIL," +"A.WEIGHT,A.STEELCODE," +"DECODE(A.AFFIRMSTATUS,'1','√',NULL) AFFIRMSTATUS,TO_CHAR(A.INPUTTIME,'YY-MM-DD HH24') INPUTTIME," +"TO_CHAR(A.AFFIRMTIME,'YY-MM-DD HH24') AFFIRMTIME,D.NAME_ CATEGORY,A.REMARK,A.PACTNO,G.NAME_ TRANSTYPE," +"H.NAME_ TRAINTYPE,A.TRANSNO VECIHLENO,C.LOADDOCK,C.UNLOADDOCK " + "FROM SEL_ASKVEHICLEPLANINFL A,SEL_INCEPTCORPINFO B,SEL_STATIONINFO C,SCM_BASE_INFO D," +"SCM_BASE_INFO G,SCM_BASE_INFO H " +"WHERE INSTR(A.LOADPOSITION,'1009JB')>0 AND A.INCEPTCORPCODE=B.INCEPTCORPCODE AND A.STATIONCODE=C.STATIONCODE " +"AND A.CARAFFIRM NOT IN('4','5','0') AND A.CATEGORY=D.ID_(+) AND A.TRANSTYPE=G.ID_(+) AND A.TRAINTYPE=H.ID_(+) AND A.AFFIRMSTATUS='1' " + where +") T1 " +"LEFT JOIN " +"(" +"SELECT D.PLANVEHICLEID,COUNT(D.SERIALNUMBER) HSENDQUANTITY,SUM(D.ADDWEIGHT) HSENDWEIGHT " +"FROM KCH_TURNOFFSENDLIST D WHERE D.ISVALID<>'0' AND D.DUMMYSENDFLAG<>'1' " +"AND D.PLANVEHICLEID BETWEEN '" + MinAskPlanID + "' AND '" + MaxAskPlanID + "' GROUP BY D.PLANVEHICLEID " +") T2 ON T1.ASKPLAN_ID=T2.PLANVEHICLEID " +"LEFT JOIN " +"(" +"SELECT E.PLANVEHICLEID,COUNT(E.SERIALNUMBER) ZSENDQUANTITY,SUM(E.ADDWEIGHT) ZSENDWEIGHT " +"FROM KCZ_TURNOFFSENDLIST E WHERE E.ISVALID<>'0' AND E.DUMMYSENDFLAG<>'1' " +"AND E.PLANVEHICLEID BETWEEN '" + MinAskPlanID + "' AND '" + MaxAskPlanID + "' GROUP BY E.PLANVEHICLEID " +") T3 ON T1.ASKPLAN_ID=T3.PLANVEHICLEID " +"LEFT JOIN " +"( " +"SELECT F.ASKPLAN_ID,COUNT(DISTINCT F.PL) PLCOUNT,COUNT(F.ASKPLAN_ID) ASKCOUNT,SUM(DECODE(F.ISCLEAR,'1',1,0)) CLEARCOUNT FROM SEL_ASKCARPLAN_ASS F " +"WHERE F.ASKPLAN_ID BETWEEN '" + MinAskPlanID + "' AND '" + MaxAskPlanID + "' GROUP BY F.ASKPLAN_ID " +") T4 ON T1.ASKPLAN_ID=T4.ASKPLAN_ID " +"LEFT JOIN " +"(" +"SELECT G.PLANVEHICLEID,COUNT(G.SERIALNUMBER) JSENDQUANTITY,SUM(G.ADDWEIGHT) JSENDWEIGHT " +"FROM KCJ_TURNOFFSENDLIST G WHERE G.ISVALID<>'0' AND G.DUMMYSENDFLAG<>'1' " +"AND G.PLANVEHICLEID BETWEEN '" + MinAskPlanID + "' AND '" + MaxAskPlanID + "' GROUP BY G.PLANVEHICLEID " +") T5 ON T1.ASKPLAN_ID=T5.PLANVEHICLEID"; System.Data.DataSet tmpdst = this.DBManager.ExecuteQuery(CSql,out err); if(tmpdst!=null && tmpdst.Tables.Count ==1 && tmpdst.Tables[0].Rows.Count>0) { tmpdst.Tables[0].TableName = "SEL_ASKVEHICLEPLAN_C"; return new ReturnObject(tmpdst); } return new ReturnObject(null); } catch(System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return new ReturnObject(null,10000,ex.ToString()); } } public ReturnObject GetAskPlanData_PSYL(string where) { try { string err = ""; string MinAskPlanID = ""; string MaxAskPlanID = ""; string MinSql = "SELECT MIN(A.ASKPLAN_ID) FROM SEL_ASKVEHICLEPLANINFL A,SEL_INCEPTCORPINFO B," + "SEL_STATIONINFO C,SCM_BASE_INFO D,SCM_BASE_INFO G,SCM_BASE_INFO H " + "WHERE A.INCEPTCORPCODE = B.INCEPTCORPCODE " + "AND A.STATIONCODE = C.STATIONCODE AND A.CARAFFIRM NOT IN ('4', '5', '0') AND A.CATEGORY = D.ID_(+) " + "AND A.TRANSTYPE = G.ID_(+) AND A.TRAINTYPE = H.ID_(+) AND A.AFFIRMSTATUS = '1' AND A.REMARK LIKE '配送中心%' " + where; System.Data.DataSet tmpMinDst = this.DBManager.ExecuteQuery(MinSql, out err); if (tmpMinDst != null && tmpMinDst.Tables.Count == 1 && tmpMinDst.Tables[0].Rows.Count > 0) { MinAskPlanID = tmpMinDst.Tables[0].Rows[0][0].ToString(); } else { return new ReturnObject(null); } string MaxSql = "SELECT MAX(A.ASKPLAN_ID) FROM SEL_ASKVEHICLEPLANINFL A,SEL_INCEPTCORPINFO B," + "SEL_STATIONINFO C,SCM_BASE_INFO D,SCM_BASE_INFO G,SCM_BASE_INFO H " + "WHERE A.INCEPTCORPCODE = B.INCEPTCORPCODE " + "AND A.STATIONCODE = C.STATIONCODE AND A.CARAFFIRM NOT IN ('4', '5', '0') AND A.CATEGORY = D.ID_(+) " + "AND A.TRANSTYPE = G.ID_(+) AND A.TRAINTYPE = H.ID_(+) AND A.AFFIRMSTATUS = '1' AND A.REMARK LIKE '配送中心%' " + where; System.Data.DataSet tmpMaxDst = this.DBManager.ExecuteQuery(MaxSql, out err); if (tmpMaxDst != null && tmpMaxDst.Tables.Count == 1 && tmpMaxDst.Tables[0].Rows.Count > 0) { MaxAskPlanID = tmpMaxDst.Tables[0].Rows[0][0].ToString(); } else { return new ReturnObject(null); } string CSql = "SELECT T1.*," + "NVL(HSENDQUANTITY,0)+NVL(ZSENDQUANTITY,0)+NVL(JSENDQUANTITY,0) SENDQUANTITY," + "NVL(HSENDWEIGHT,0)+NVL(ZSENDWEIGHT,0)+NVL(JSENDWEIGHT,0) SENDWEIGHT," + "DECODE(T4.PLCOUNT,2,'√',1,NULL) ISHB," + "(CASE WHEN T4.CLEARCOUNT=0 THEN '正常' WHEN T4.ASKCOUNT=T4.CLEARCOUNT THEN '清库' WHEN T4.CLEARCOUNT>0 AND T4.ASKCOUNT>T4.CLEARCOUNT THEN '拼装' ELSE '正常' END) ISCLEAR " + "FROM " + "(" + "SELECT B.INCEPTCORPNAME,C.STATIONNAME,A.ASKPLAN_ID,A.PACTINDEXDETAIL," + "A.WEIGHT,A.STEELCODE," + "DECODE(A.AFFIRMSTATUS,'1','√',NULL) AFFIRMSTATUS,TO_CHAR(A.INPUTTIME,'YY-MM-DD HH24') INPUTTIME," + "TO_CHAR(A.AFFIRMTIME,'YY-MM-DD HH24') AFFIRMTIME,D.NAME_ CATEGORY,A.REMARK,A.PACTNO,G.NAME_ TRANSTYPE," + "H.NAME_ TRAINTYPE,A.TRANSNO VECIHLENO,C.LOADDOCK,C.UNLOADDOCK " + "FROM SEL_ASKVEHICLEPLANINFL A,SEL_INCEPTCORPINFO B,SEL_STATIONINFO C,SCM_BASE_INFO D," + "SCM_BASE_INFO G,SCM_BASE_INFO H " + "WHERE A.INCEPTCORPCODE=B.INCEPTCORPCODE AND A.STATIONCODE=C.STATIONCODE " + "AND A.CARAFFIRM NOT IN('4','5','0') AND A.CATEGORY=D.ID_(+) AND A.TRANSTYPE=G.ID_(+) AND A.TRAINTYPE=H.ID_(+) AND A.AFFIRMSTATUS='1' AND A.REMARK LIKE '配送中心%' " + where + ") T1 " + "LEFT JOIN " + "(" + "SELECT D.PLANVEHICLEID,COUNT(D.SERIALNUMBER) HSENDQUANTITY,SUM(D.ADDWEIGHT) HSENDWEIGHT " + "FROM KCH_TURNOFFSENDLIST D WHERE D.ISVALID<>'0' AND D.DUMMYSENDFLAG<>'1' " + "AND D.PLANVEHICLEID BETWEEN '" + MinAskPlanID + "' AND '" + MaxAskPlanID + "' GROUP BY D.PLANVEHICLEID " + ") T2 ON T1.ASKPLAN_ID=T2.PLANVEHICLEID " + "LEFT JOIN " + "(" + "SELECT E.PLANVEHICLEID,COUNT(E.SERIALNUMBER) ZSENDQUANTITY,SUM(E.ADDWEIGHT) ZSENDWEIGHT " + "FROM KCZ_TURNOFFSENDLIST E WHERE E.ISVALID<>'0' AND E.DUMMYSENDFLAG<>'1' " + "AND E.PLANVEHICLEID BETWEEN '" + MinAskPlanID + "' AND '" + MaxAskPlanID + "' GROUP BY E.PLANVEHICLEID " + ") T3 ON T1.ASKPLAN_ID=T3.PLANVEHICLEID " + "LEFT JOIN " + "( " + "SELECT F.ASKPLAN_ID,COUNT(DISTINCT F.PL) PLCOUNT,COUNT(F.ASKPLAN_ID) ASKCOUNT,SUM(DECODE(F.ISCLEAR,'1',1,0)) CLEARCOUNT FROM SEL_ASKCARPLAN_ASS F " + "WHERE F.ASKPLAN_ID BETWEEN '" + MinAskPlanID + "' AND '" + MaxAskPlanID + "' GROUP BY F.ASKPLAN_ID " + ") T4 ON T1.ASKPLAN_ID=T4.ASKPLAN_ID " + "LEFT JOIN " + "(" + "SELECT G.PLANVEHICLEID,COUNT(G.SERIALNUMBER) JSENDQUANTITY,SUM(G.ADDWEIGHT) JSENDWEIGHT " + "FROM KCJ_TURNOFFSENDLIST G WHERE G.ISVALID<>'0' AND G.DUMMYSENDFLAG<>'1' " + "AND G.PLANVEHICLEID BETWEEN '" + MinAskPlanID + "' AND '" + MaxAskPlanID + "' GROUP BY G.PLANVEHICLEID " + ") T5 ON T1.ASKPLAN_ID=T5.PLANVEHICLEID"; System.Data.DataSet tmpdst = this.DBManager.ExecuteQuery(CSql, out err); if (tmpdst != null && tmpdst.Tables.Count == 1 && tmpdst.Tables[0].Rows.Count > 0) { tmpdst.Tables[0].TableName = "SEL_ASKVEHICLEPLAN_C"; return new ReturnObject(tmpdst); } return new ReturnObject(null); } catch (System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return new ReturnObject(null, 10000, ex.ToString()); } } public ReturnObject GetAskPlanData_BJB(string where) { try { string err = ""; string MinAskPlanID = ""; string MaxAskPlanID = ""; string MinSql = "SELECT MIN(A.DLIV_DIRNO) FROM OVS_DLIV_DIR@XGXS A,SEL_INCEPTCORPINFO B," + "SEL_STATIONINFO C,SCM_BASE_INFO D,SCM_BASE_INFO G,SCM_BASE_INFO H " + "WHERE CUST_CD='106' AND A.ACP_DEPT = B.INCEPTCORPCODE " + "AND A.DEST_PCD = C.STATIONCODE AND A.CATEGORY = D.ID_(+) " + "AND A.TRANSTYPE = G.ID_(+) AND A.TRAINTYPE = H.ID_(+) AND A.STATUS_CD = '3' " + where; System.Data.DataSet tmpMinDst = this.DBManager.ExecuteQuery(MinSql, out err); if (tmpMinDst != null && tmpMinDst.Tables.Count == 1 && tmpMinDst.Tables[0].Rows.Count > 0) { MinAskPlanID = tmpMinDst.Tables[0].Rows[0][0].ToString(); } else { return new ReturnObject(null); } string MaxSql = "SELECT MAX(A.DLIV_DIRNO) FROM OVS_DLIV_DIR@XGXS A,SEL_INCEPTCORPINFO B," + "SEL_STATIONINFO C,SCM_BASE_INFO D,SCM_BASE_INFO G,SCM_BASE_INFO H " + "WHERE CUST_CD='106' AND A.ACP_DEPT = B.INCEPTCORPCODE " + "AND A.DEST_PCD = C.STATIONCODE AND A.CATEGORY = D.ID_(+) " + "AND A.TRANSTYPE = G.ID_(+) AND A.TRAINTYPE = H.ID_(+) AND A.STATUS_CD = '3' " + where; System.Data.DataSet tmpMaxDst = this.DBManager.ExecuteQuery(MaxSql, out err); if (tmpMaxDst != null && tmpMaxDst.Tables.Count == 1 && tmpMaxDst.Tables[0].Rows.Count > 0) { MaxAskPlanID = tmpMaxDst.Tables[0].Rows[0][0].ToString(); } else { return new ReturnObject(null); } string CSql = "SELECT T1.*," + "NVL(HSENDQUANTITY,0)+NVL(ZSENDQUANTITY,0)+NVL(JSENDQUANTITY,0) SENDQUANTITY," + "NVL(HSENDWEIGHT,0)+NVL(ZSENDWEIGHT,0)+NVL(JSENDWEIGHT,0) SENDWEIGHT," + "DECODE(T4.PLCOUNT,2,'√',1,NULL) ISHB," + "(CASE WHEN T4.CLEARCOUNT=0 THEN '正常' WHEN T4.ASKCOUNT=T4.CLEARCOUNT THEN '清库' WHEN T4.CLEARCOUNT>0 AND T4.ASKCOUNT>T4.CLEARCOUNT THEN '拼装' ELSE '正常' END) ISCLEAR " + "FROM " + "(" + "SELECT B.INCEPTCORPNAME,C.STATIONNAME,A.DLIV_DIRNO ASKPLAN_ID,'' PACTINDEXDETAIL," + "A.WEIGHT,A.STEELCODE," + "DECODE(A.STATUS_CD,'3','√',NULL) AFFIRMSTATUS,A.REG_DTIME INPUTTIME," + "A.AFM_DTIME AFFIRMTIME,D.NAME_ CATEGORY,A.REMARK,A.ORD_NO PACTNO,G.NAME_ TRANSTYPE," + "H.NAME_ TRAINTYPE,A.TRAIN_DLIVNO VECIHLENO,C.LOADDOCK,C.UNLOADDOCK " + "FROM OVS_DLIV_DIR@XGXS A,SEL_INCEPTCORPINFO B,SEL_STATIONINFO C,SCM_BASE_INFO D," + "SCM_BASE_INFO G,SCM_BASE_INFO H " + "WHERE CUST_CD='106' AND A.ACP_DEPT=B.INCEPTCORPCODE AND A.DEST_PCD=C.STATIONCODE " + "AND A.CATEGORY=D.ID_(+) AND A.TRANSTYPE=G.ID_(+) AND A.TRAINTYPE=H.ID_(+) AND A.STATUS_CD = '3' " + where + ") T1 " + "LEFT JOIN " + "(" + "SELECT D.PLANVEHICLEID,COUNT(D.SERIALNUMBER) HSENDQUANTITY,SUM(D.ADDWEIGHT) HSENDWEIGHT " + "FROM KCH_TURNOFFSENDLIST D WHERE D.ISVALID<>'0' AND D.DUMMYSENDFLAG<>'1' " + "AND D.PLANVEHICLEID BETWEEN '" + MinAskPlanID + "' AND '" + MaxAskPlanID + "' GROUP BY D.PLANVEHICLEID " + ") T2 ON T1.ASKPLAN_ID=T2.PLANVEHICLEID " + "LEFT JOIN " + "(" + "SELECT E.PLANVEHICLEID,COUNT(E.SERIALNUMBER) ZSENDQUANTITY,SUM(E.ADDWEIGHT) ZSENDWEIGHT " + "FROM KCZ_TURNOFFSENDLIST E WHERE E.ISVALID<>'0' AND E.DUMMYSENDFLAG<>'1' " + "AND E.PLANVEHICLEID BETWEEN '" + MinAskPlanID + "' AND '" + MaxAskPlanID + "' GROUP BY E.PLANVEHICLEID " + ") T3 ON T1.ASKPLAN_ID=T3.PLANVEHICLEID " + "LEFT JOIN " + "( " + "SELECT F.ASKPLAN_ID,COUNT(DISTINCT F.PL) PLCOUNT,COUNT(F.ASKPLAN_ID) ASKCOUNT,SUM(DECODE(F.ISCLEAR,'1',1,0)) CLEARCOUNT FROM SEL_ASKCARPLAN_ASS@XGXS F " + "WHERE F.ASKPLAN_ID BETWEEN '" + MinAskPlanID + "' AND '" + MaxAskPlanID + "' GROUP BY F.ASKPLAN_ID " + ") T4 ON T1.ASKPLAN_ID=T4.ASKPLAN_ID " + "LEFT JOIN " + "(" + "SELECT G.PLANVEHICLEID,COUNT(G.SERIALNUMBER) JSENDQUANTITY,SUM(G.ADDWEIGHT) JSENDWEIGHT " + "FROM KCJ_TURNOFFSENDLIST G WHERE G.ISVALID<>'0' AND G.DUMMYSENDFLAG<>'1' " + "AND G.PLANVEHICLEID BETWEEN '" + MinAskPlanID + "' AND '" + MaxAskPlanID + "' GROUP BY G.PLANVEHICLEID " + ") T5 ON T1.ASKPLAN_ID=T5.PLANVEHICLEID"; System.Data.DataSet tmpdst = this.DBManager.ExecuteQuery(CSql, out err); if (tmpdst != null && tmpdst.Tables.Count == 1 && tmpdst.Tables[0].Rows.Count > 0) { tmpdst.Tables[0].TableName = "SEL_ASKVEHICLEPLAN_C"; return new ReturnObject(tmpdst); } return new ReturnObject(null); } catch (System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return new ReturnObject(null, 10000, ex.ToString()); } } //提交发运新增 public ReturnObject CommitAddSendList(System.Collections.ArrayList Billets,System.Collections.ArrayList SendInfo,string SendType,string SuperSend,string AutoMatch,string strlx,string strRole) { try { string err = ""; Oracle.DataAccess.Client.OracleParameter pBillets = new Oracle.DataAccess.Client.OracleParameter("vBillets", Oracle.DataAccess.Client.OracleDbType.Varchar2); Oracle.DataAccess.Client.OracleParameter pSendInfo = new Oracle.DataAccess.Client.OracleParameter("vSendInfo", Oracle.DataAccess.Client.OracleDbType.Varchar2); Oracle.DataAccess.Client.OracleParameter pSendType = new Oracle.DataAccess.Client.OracleParameter("vSendType", Oracle.DataAccess.Client.OracleDbType.Varchar2); Oracle.DataAccess.Client.OracleParameter pSuperSend = new Oracle.DataAccess.Client.OracleParameter("vSuperSend", Oracle.DataAccess.Client.OracleDbType.Varchar2); Oracle.DataAccess.Client.OracleParameter pAutoMatch = new Oracle.DataAccess.Client.OracleParameter("vAutoMatch", Oracle.DataAccess.Client.OracleDbType.Varchar2); Oracle.DataAccess.Client.OracleParameter pFaileInfo = new Oracle.DataAccess.Client.OracleParameter("vFaileInfo", Oracle.DataAccess.Client.OracleDbType.Varchar2); Oracle.DataAccess.Client.OracleParameter pSuccessFlag = new Oracle.DataAccess.Client.OracleParameter("vSuccessFlag", Oracle.DataAccess.Client.OracleDbType.Varchar2); pBillets.Direction = ParameterDirection.Input; pSendInfo.Direction = ParameterDirection.Input; pSendType.Direction = ParameterDirection.Input; pSuperSend.Direction = ParameterDirection.Input; pAutoMatch.Direction = ParameterDirection.Input; pFaileInfo.Direction = ParameterDirection.Output; pSuccessFlag.Direction = ParameterDirection.Output; pBillets.CollectionType = Oracle.DataAccess.Client.OracleCollectionType.PLSQLAssociativeArray; pSendInfo.CollectionType = Oracle.DataAccess.Client.OracleCollectionType.PLSQLAssociativeArray; pFaileInfo.CollectionType = Oracle.DataAccess.Client.OracleCollectionType.PLSQLAssociativeArray; pBillets.Value = Billets.ToArray(typeof(string)); pSendInfo.Value = SendInfo.ToArray(typeof(string)); pSendType.Value = SendType; pSuperSend.Value = SuperSend; pAutoMatch.Value = AutoMatch; int []OSizeInf = new int[Billets.Count]; for(int i =0;i< Billets.Count;i++) { OSizeInf[i ] = 200; } pBillets.Size = Billets.Count; pBillets.ArrayBindSize = OSizeInf; int []NSizeInf = new int[SendInfo.Count]; for(int i =0;i< SendInfo.Count;i++) { NSizeInf[i ] = 200; } pSendInfo.Size = SendInfo.Count; pSendInfo.ArrayBindSize = NSizeInf; int OutSize = 200; int []OutSizeInf = new int[OutSize]; for(int i =0;i< OutSize;i++) { OutSizeInf[i ] = 2000; } pFaileInfo.Size = OutSize; pFaileInfo.ArrayBindSize = OutSizeInf; pSuccessFlag.Size = 400; if (strlx == "YL" || strlx == "2") { if (strRole == "pszxck") { ((STMes.DBManager)DBManagerList["ODPDB"]).ExecuteNonQuery_NoDBSever("KCJ_TURNOFFSEND.ADDSENDLIST_YL_PS", CommandType.StoredProcedure, new Oracle.DataAccess.Client.OracleParameter[] { pBillets, pSendInfo, pSendType, pSuperSend, pAutoMatch, pFaileInfo, pSuccessFlag }, out err); } else { ((STMes.DBManager)DBManagerList["ODPDB"]).ExecuteNonQuery_NoDBSever("KCJ_TURNOFFSEND.ADDSENDLIST_YL", CommandType.StoredProcedure, new Oracle.DataAccess.Client.OracleParameter[] { pBillets, pSendInfo, pSendType, pSuperSend, pAutoMatch, pFaileInfo, pSuccessFlag }, out err); } } else if ( strlx == "3") { ((STMes.DBManager)DBManagerList["ODPDB"]).ExecuteNonQuery_NoDBSever("KCJ_TURNOFFSEND.ADDSENDLIST_PS", CommandType.StoredProcedure, new Oracle.DataAccess.Client.OracleParameter[] { pBillets, pSendInfo, pSendType, pSuperSend, pAutoMatch, pFaileInfo, pSuccessFlag }, out err); } else { ((STMes.DBManager)DBManagerList["ODPDB"]).ExecuteNonQuery_NoDBSever("KCJ_TURNOFFSEND.ADDSENDLIST_P", CommandType.StoredProcedure, new Oracle.DataAccess.Client.OracleParameter[] { pBillets, pSendInfo, pSendType, pSuperSend, pAutoMatch, pFaileInfo, pSuccessFlag }, out err); } if(FixDBManager.CheckNullStr(pSuccessFlag.Value).Length>0 | FixDBManager.CheckNullStr(err).Length>0) { return new ReturnObject(null,1,pSuccessFlag.Value.ToString()+err); } else { Oracle.DataAccess.Types.OracleString[] FaileInfo = (Oracle.DataAccess.Types.OracleString[])pFaileInfo.Value; System.Collections.ArrayList rtnList = new ArrayList(); if(FaileInfo.Length>0) { for(int i=0;i0) { return new ReturnObject(rtnList); } else { return new ReturnObject('1'); } } } catch(System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return new ReturnObject(null); } } //获得中板发运明细 public ReturnObject GetSendListData(string where) { try { string sql = "SELECT B.INCEPTCORPNAME,D.STATIONNAME,C.BUTTRESS,C.CONDOLENUMBER,C.SERIALNUMBER,C.CLASSORDER,E.NAME_ CLASSORDERNAME," +"C.CLASSTEAM,F.NAME_ CLASSTEAMNAME,C.TRAINWAGON,C.PLANVEHICLEID,C.ORDERFORMNUMBER,C.ROLLNO,C.PLANNO,C.STEELTYPE," +"C.PLY,C.WIDTH,C.LENGTH,C.WEIGHT,H.NAME_ DETERMINANTRESULT,I.NAME_ CUTSIDE,DECODE(C.ISHEAT,'1','√',NULL) ISHEAT," +"J.NAME_ DETECTMAR,DECODE(C.STANDROLL,'1','√',NULL) STANDROLL,G.NAME_ ROLE," +"C.STOVENO,DECODE(C.QUENCH,'1','√',NULL) QUENCH,DECODE(C.TMCP,'1','√',NULL) TMCP," +"DECODE(C.HEATROLL,'1','√',NULL) HEATROLL,DECODE(C.CONTROLROLL,'1','√',NULL) CONTROLROLL," +"C.ID,K.NAME_ USE,L.NAME_ STANDARDNO,M.NAME_ TRANSTYPE,N.NAME_ TRAINTYPE,C.PICKSTORAGEMAN," +"TO_CHAR(C.PICKSTORAGETIME,'YYYY-MM-DD HH24:MI:SS') PICKSTORAGETIME,C.LISTNUMBER," +"C.REMARK,DECODE(C.ISVALID,'2','√',NULL) ISVALID,C.ADDWEIGHT " + "FROM SEL_ASKVEHICLEPLANINFL A,SEL_INCEPTCORPINFO B,KCZ_TURNOFFSENDLIST C,SEL_STATIONINFO D," +"SCM_BASE_INFO E,SCM_BASE_INFO F,SCM_BASE_INFO G,SCM_BASE_INFO H,SCM_BASE_INFO I," +"SCM_BASE_INFO J,SCM_BASE_INFO K,SCM_BASE_INFO L,SCM_BASE_INFO M,SCM_BASE_INFO N " +"WHERE A.INCEPTCORPCODE=B.INCEPTCORPCODE(+) AND A.STATIONCODE=D.STATIONCODE(+) " +"AND A.ASKPLAN_ID(+)=C.PLANVEHICLEID AND C.ISVALID<>'0' AND C.DUMMYSENDFLAG<>'1' " +"AND C.CLASSORDER=E.ID_(+) AND C.CLASSTEAM=F.ID_(+) AND C.ROLE=G.ID_(+) AND C.DETERMINANTRESULT=H.ID_(+) " +"AND C.CUTSIDE=I.ID_(+) AND C.DETECTMAR=J.ID_(+) AND C.USE=K.ID_(+) AND C.STANDARDNO=L.ID_(+) " +"AND A.TRANSTYPE=M.ID_(+) AND A.TRAINTYPE=N.ID_(+) " +where; string err = ""; System.Data.DataSet dst = this.DBManager.ExecuteQuery(sql,out err); if(dst!=null && dst.Tables.Count==1 && dst.Tables[0].Rows.Count>0) { dst.Tables[0].TableName = "KCZ_TURNOFFSENDLIST"; return new ReturnObject(dst); } else { return new ReturnObject(null); } } catch(System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return new ReturnObject(null); } } //获得厚板发运明细 public ReturnObject GetHBSendListData(string where) { try { string sql = "SELECT B.INCEPTCORPNAME,D.STATIONNAME,C.BUTTRESS,C.CONDOLENUMBER,C.SERIALNUMBER,C.CLASSORDER,E.NAME_ CLASSORDERNAME," +"C.CLASSTEAM,F.NAME_ CLASSTEAMNAME,C.TRAINWAGON,C.PLANVEHICLEID,C.ORDERFORMNUMBER,C.ROLLNO,C.PLANNO,C.STEELTYPE," +"C.PLY,C.WIDTH,C.LENGTH,C.WEIGHT,H.NAME_ DETERMINANTRESULT,I.NAME_ CUTSIDE,DECODE(C.ISHEAT,'1','√',NULL) ISHEAT," +"J.NAME_ DETECTMAR,DECODE(C.STANDROLL,'1','√',NULL) STANDROLL,G.NAME_ ROLE," +"C.STOVENO,DECODE(C.QUENCH,'1','√',NULL) QUENCH,DECODE(C.TMCP,'1','√',NULL) TMCP," +"DECODE(C.HEATROLL,'1','√',NULL) HEATROLL,DECODE(C.CONTROLROLL,'1','√',NULL) CONTROLROLL," +"C.ID,K.NAME_ USE,L.NAME_ STANDARDNO,M.NAME_ TRANSTYPE,N.NAME_ TRAINTYPE,C.PICKSTORAGEMAN," +"TO_CHAR(C.PICKSTORAGETIME,'YYYY-MM-DD HH24:MI:SS') PICKSTORAGETIME,C.LISTNUMBER," +"C.REMARK,DECODE(C.ISVALID,'2','√',NULL) ISVALID,C.ADDWEIGHT " + "FROM SEL_ASKVEHICLEPLANINFL A,SEL_INCEPTCORPINFO B,KCH_TURNOFFSENDLIST C,SEL_STATIONINFO D," +"SCM_BASE_INFO E,SCM_BASE_INFO F,SCM_BASE_INFO G,SCM_BASE_INFO H,SCM_BASE_INFO I," +"SCM_BASE_INFO J,SCM_BASE_INFO K,SCM_BASE_INFO L,SCM_BASE_INFO M,SCM_BASE_INFO N " +"WHERE A.INCEPTCORPCODE=B.INCEPTCORPCODE(+) AND A.STATIONCODE=D.STATIONCODE(+) " +"AND A.ASKPLAN_ID(+)=C.PLANVEHICLEID AND C.ISVALID<>'0' AND C.DUMMYSENDFLAG<>'1' " +"AND C.CLASSORDER=E.ID_(+) AND C.CLASSTEAM=F.ID_(+) AND C.ROLE=G.ID_(+) AND C.DETERMINANTRESULT=H.ID_(+) " +"AND C.CUTSIDE=I.ID_(+) AND C.DETECTMAR=J.ID_(+) AND C.USE=K.ID_(+) AND C.STANDARDNO=L.ID_(+) " +"AND A.TRANSTYPE=M.ID_(+) AND A.TRAINTYPE=N.ID_(+) " +where; string err = ""; System.Data.DataSet dst = this.DBManager.ExecuteQuery(sql,out err); if(dst!=null && dst.Tables.Count==1 && dst.Tables[0].Rows.Count>0) { dst.Tables[0].TableName = "KCH_TURNOFFSENDLIST"; return new ReturnObject(dst); } else { return new ReturnObject(null); } } catch(System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return new ReturnObject(null); } } //获得板材加工发运明细 public ReturnObject GetJBSendListData(string where) { try { string sql = "SELECT B.INCEPTCORPNAME,D.STATIONNAME,C.BUTTRESS,C.CONDOLENUMBER,C.SERIALNUMBER,C.CLASSORDER,E.NAME_ CLASSORDERNAME," + "C.CLASSTEAM,F.NAME_ CLASSTEAMNAME,C.TRAINWAGON,C.PLANVEHICLEID,C.PACTNO,C.ORDERFORMNUMBER,C.ROLLNO,C.PLANNO,C.STEELTYPE," +"C.PLY,C.WIDTH,C.LENGTH,C.WEIGHT,H.NAME_ DETERMINANTRESULT,I.NAME_ CUTSIDE,DECODE(C.ISHEAT,'1','√',NULL) ISHEAT," +"J.NAME_ DETECTMAR,DECODE(C.STANDROLL,'1','√',NULL) STANDROLL,G.NAME_ ROLE," +"C.STOVENO,DECODE(C.QUENCH,'1','√',NULL) QUENCH,DECODE(C.TMCP,'1','√',NULL) TMCP," +"DECODE(C.HEATROLL,'1','√',NULL) HEATROLL,DECODE(C.CONTROLROLL,'1','√',NULL) CONTROLROLL," +"C.ID,K.NAME_ USE,L.NAME_ STANDARDNO,M.NAME_ TRANSTYPE,N.NAME_ TRAINTYPE,C.PICKSTORAGEMAN," +"TO_CHAR(C.PICKSTORAGETIME,'YYYY-MM-DD HH24:MI:SS') PICKSTORAGETIME,C.LISTNUMBER," +"C.REMARK,DECODE(C.ISVALID,'2','√',NULL) ISVALID,C.ADDWEIGHT," +"DECODE(C.ISCASTPROCESS,'1','√',NULL) ISCASTPROCESS,DECODE(C.ISPRINTPROCESS,'1','√',NULL) ISPRINTPROCESS," +"DECODE(C.MILLINGPROCESS,'1','√',NULL) MILLINGPROCESS," +"DECODE(O.ISD1,'1','√','×')||P.NAME_ SURFACETREATMENT," +"DECODE(O.ISD2,'1','√','×')||O.SURFACEROUGHNESS SURFACEROUGHNESS," +"DECODE(O.ISD3,'1','√','×')||O.COATTHICKNESS COATTHICKNESS," +"DECODE(O.ISD4,'1','√','×')||O.DRYINGTIME DRYINGTIME," + "O.VALIDTIME " + "FROM SEL_ASKVEHICLEPLANINFL A,SEL_INCEPTCORPINFO B,KCJ_TURNOFFSENDLIST C,SEL_STATIONINFO D," +"SCM_BASE_INFO E,SCM_BASE_INFO F,SCM_BASE_INFO G,SCM_BASE_INFO H,SCM_BASE_INFO I," +"SCM_BASE_INFO J,SCM_BASE_INFO K,SCM_BASE_INFO L,SCM_BASE_INFO M,SCM_BASE_INFO N," +"JGZJ_INSPECTIONINFO O,KCJ_BASEDATA P " +"WHERE A.INCEPTCORPCODE=B.INCEPTCORPCODE(+) AND A.STATIONCODE=D.STATIONCODE(+) " +"AND A.ASKPLAN_ID(+)=C.PLANVEHICLEID AND C.ISVALID<>'0' AND C.DUMMYSENDFLAG<>'1' " +"AND C.CLASSORDER=E.ID_(+) AND C.CLASSTEAM=F.ID_(+) AND C.ROLE=G.ID_(+) AND C.DETERMINANTRESULT=H.ID_(+) " +"AND C.CLIPTYPEPROCESS=I.ID_(+) AND C.DETECTMAR=J.ID_(+) AND C.USE=K.ID_(+) AND C.STANDARDNO=L.ID_(+) " +"AND A.TRANSTYPE=M.ID_(+) AND A.TRAINTYPE=N.ID_(+) AND C.INSPECTIONID=O.INSPECTIONID(+) " + "AND O.SURFACETREATMENT=P.ID_(+) AND C.LISTNUMBER NOT LIKE 'P%'" +where; string err = ""; System.Data.DataSet dst = this.DBManager.ExecuteQuery(sql,out err); if(dst!=null && dst.Tables.Count==1 && dst.Tables[0].Rows.Count>0) { dst.Tables[0].TableName = "KCJ_TURNOFFSENDLIST"; return new ReturnObject(dst); } else { return new ReturnObject(null); } } catch(System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return new ReturnObject(null); } } public ReturnObject GetYLSendListData(string where,string strRoleid) { try { string sql = ""; if (strRoleid == "pszxck") { sql = "SELECT B.INCEPTCORPNAME,D.STATIONNAME,C.BUTTRESS,C.CONDOLENUMBER,C.SERIALNUMBER,C.CLASSORDER,E.NAME_ CLASSORDERNAME," + "C.CLASSTEAM,F.NAME_ CLASSTEAMNAME,C.TRAINWAGON,C.PLANVEHICLEID,C.PACTNO,C.ORDERFORMNUMBER,C.ROLLNO,C.PLANNO,C.STEELTYPE," + "C.PLY,C.WIDTH,C.LENGTH,C.WEIGHT,H.NAME_ DETERMINANTRESULT,I.NAME_ CUTSIDE,DECODE(C.ISHEAT,'1','√',NULL) ISHEAT,Z.NAME_ BUSINESS_CATEGORY, " + "J.NAME_ DETECTMAR,DECODE(C.STANDROLL,'1','√',NULL) STANDROLL,G.NAME_ ROLE," + "C.STOVENO,DECODE(C.QUENCH,'1','√',NULL) QUENCH,DECODE(C.TMCP,'1','√',NULL) TMCP," + "DECODE(C.HEATROLL,'1','√',NULL) HEATROLL,DECODE(C.CONTROLROLL,'1','√',NULL) CONTROLROLL," + "C.ID,K.NAME_ USE,L.NAME_ STANDARDNO,M.NAME_ TRANSTYPE,N.NAME_ TRAINTYPE,C.PICKSTORAGEMAN," + "TO_CHAR(C.PICKSTORAGETIME,'YYYY-MM-DD HH24:MI:SS') PICKSTORAGETIME,C.LISTNUMBER," + "C.REMARK,DECODE(C.ISVALID,'2','√',NULL) ISVALID,C.ADDWEIGHT," + "DECODE(C.ISCASTPROCESS,'1','√',NULL) ISCASTPROCESS,DECODE(C.ISPRINTPROCESS,'1','√',NULL) ISPRINTPROCESS," + "DECODE(C.MILLINGPROCESS,'1','√',NULL) MILLINGPROCESS," + "DECODE(O.ISD1,'1','√','×')||P.NAME_ SURFACETREATMENT," + "DECODE(O.ISD2,'1','√','×')||O.SURFACEROUGHNESS SURFACEROUGHNESS," + "DECODE(O.ISD3,'1','√','×')||O.COATTHICKNESS COATTHICKNESS," + "DECODE(O.ISD4,'1','√','×')||O.DRYINGTIME DRYINGTIME," + "O.VALIDTIME " + "FROM SEL_ASKVEHICLEPLANINFL A,SEL_INCEPTCORPINFO B,KCJ_TURNOFFSENDLIST C,SEL_STATIONINFO D," + "SCM_BASE_INFO E,SCM_BASE_INFO F,SCM_BASE_INFO G,SCM_BASE_INFO H,SCM_BASE_INFO I," + "SCM_BASE_INFO J,SCM_BASE_INFO K,SCM_BASE_INFO L,SCM_BASE_INFO M,SCM_BASE_INFO N,KCJ_BASEDATA Z," + "JGZJ_INSPECTIONINFO O,KCJ_BASEDATA P " + "WHERE A.INCEPTCORPCODE=B.INCEPTCORPCODE(+) AND A.STATIONCODE=D.STATIONCODE(+) AND C.Business_Category=Z.ID_(+) " + "AND A.ASKPLAN_ID(+)=C.PLANVEHICLEID AND C.ISVALID<>'0' AND C.DUMMYSENDFLAG<>'1' " + "AND C.CLASSORDER=E.ID_(+) AND C.CLASSTEAM=F.ID_(+) AND C.ROLE=G.ID_(+) AND C.DETERMINANTRESULT=H.ID_(+) " + "AND C.CLIPTYPEPROCESS=I.ID_(+) AND C.DETECTMAR=J.ID_(+) AND C.USE=K.ID_(+) AND C.STANDARDNO=L.ID_(+) " + "AND A.TRANSTYPE=M.ID_(+) AND A.TRAINTYPE=N.ID_(+) AND C.INSPECTIONID=O.INSPECTIONID(+) " + "AND O.SURFACETREATMENT=P.ID_(+) AND C.Business_Category IS NOT NULL AND C.LISTNUMBER LIKE 'PC%' and C.SENDTYPE='0' " + where; } else { sql = "SELECT B.INCEPTCORPNAME,D.STATIONNAME,C.BUTTRESS,C.CONDOLENUMBER,C.SERIALNUMBER,C.CLASSORDER,E.NAME_ CLASSORDERNAME," + "C.CLASSTEAM,F.NAME_ CLASSTEAMNAME,C.TRAINWAGON,C.PLANVEHICLEID,C.PACTNO,C.ORDERFORMNUMBER,C.ROLLNO,C.PLANNO,C.STEELTYPE," + "C.PLY,C.WIDTH,C.LENGTH,C.WEIGHT,H.NAME_ DETERMINANTRESULT,I.NAME_ CUTSIDE,DECODE(C.ISHEAT,'1','√',NULL) ISHEAT,Z.NAME_ BUSINESS_CATEGORY, " + "J.NAME_ DETECTMAR,DECODE(C.STANDROLL,'1','√',NULL) STANDROLL,G.NAME_ ROLE," + "C.STOVENO,DECODE(C.QUENCH,'1','√',NULL) QUENCH,DECODE(C.TMCP,'1','√',NULL) TMCP," + "DECODE(C.HEATROLL,'1','√',NULL) HEATROLL,DECODE(C.CONTROLROLL,'1','√',NULL) CONTROLROLL," + "C.ID,K.NAME_ USE,L.NAME_ STANDARDNO,M.NAME_ TRANSTYPE,N.NAME_ TRAINTYPE,C.PICKSTORAGEMAN," + "TO_CHAR(C.PICKSTORAGETIME,'YYYY-MM-DD HH24:MI:SS') PICKSTORAGETIME,C.LISTNUMBER," + "C.REMARK,DECODE(C.ISVALID,'2','√',NULL) ISVALID,C.ADDWEIGHT," + "DECODE(C.ISCASTPROCESS,'1','√',NULL) ISCASTPROCESS,DECODE(C.ISPRINTPROCESS,'1','√',NULL) ISPRINTPROCESS," + "DECODE(C.MILLINGPROCESS,'1','√',NULL) MILLINGPROCESS," + "DECODE(O.ISD1,'1','√','×')||P.NAME_ SURFACETREATMENT," + "DECODE(O.ISD2,'1','√','×')||O.SURFACEROUGHNESS SURFACEROUGHNESS," + "DECODE(O.ISD3,'1','√','×')||O.COATTHICKNESS COATTHICKNESS," + "DECODE(O.ISD4,'1','√','×')||O.DRYINGTIME DRYINGTIME," + "O.VALIDTIME " + "FROM SEL_ASKVEHICLEPLANINFL A,SEL_INCEPTCORPINFO B,KCJ_TURNOFFSENDLIST C,SEL_STATIONINFO D," + "SCM_BASE_INFO E,SCM_BASE_INFO F,SCM_BASE_INFO G,SCM_BASE_INFO H,SCM_BASE_INFO I," + "SCM_BASE_INFO J,SCM_BASE_INFO K,SCM_BASE_INFO L,SCM_BASE_INFO M,SCM_BASE_INFO N,KCJ_BASEDATA Z," + "JGZJ_INSPECTIONINFO O,KCJ_BASEDATA P " + "WHERE A.INCEPTCORPCODE=B.INCEPTCORPCODE(+) AND A.STATIONCODE=D.STATIONCODE(+) AND C.Business_Category=Z.ID_(+) " + "AND A.ASKPLAN_ID(+)=C.PLANVEHICLEID AND C.ISVALID<>'0' AND C.DUMMYSENDFLAG<>'1' " + "AND C.CLASSORDER=E.ID_(+) AND C.CLASSTEAM=F.ID_(+) AND C.ROLE=G.ID_(+) AND C.DETERMINANTRESULT=H.ID_(+) " + "AND C.CLIPTYPEPROCESS=I.ID_(+) AND C.DETECTMAR=J.ID_(+) AND C.USE=K.ID_(+) AND C.STANDARDNO=L.ID_(+) " + "AND A.TRANSTYPE=M.ID_(+) AND A.TRAINTYPE=N.ID_(+) AND C.INSPECTIONID=O.INSPECTIONID(+) " + "AND O.SURFACETREATMENT=P.ID_(+) AND C.Business_Category IS NOT NULL AND C.LISTNUMBER LIKE 'PS%' and C.SENDTYPE='1' " + where; } string err = ""; System.Data.DataSet dst = this.DBManager.ExecuteQuery(sql, out err); if (dst != null && dst.Tables.Count == 1 && dst.Tables[0].Rows.Count > 0) { dst.Tables[0].TableName = "KCJ_TURNOFFSENDLIST"; return new ReturnObject(dst); } else { return new ReturnObject(null); } } catch (System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return new ReturnObject(null); } } public ReturnObject GetPSSendListData(string where) { try { //string sql = "SELECT B.INCEPTCORPNAME,D.STATIONNAME,C.BUTTRESS,C.CONDOLENUMBER,C.SERIALNUMBER,C.CLASSORDER,E.NAME_ CLASSORDERNAME," // + "C.CLASSTEAM,F.NAME_ CLASSTEAMNAME,C.TRAINWAGON,C.PLANVEHICLEID,C.PACTNO,C.ORDERFORMNUMBER,C.ROLLNO,C.PLANNO,C.STEELTYPE," // + "C.PLY,C.WIDTH,C.LENGTH,C.WEIGHT,H.NAME_ DETERMINANTRESULT,I.NAME_ CUTSIDE,DECODE(C.ISHEAT,'1','√',NULL) ISHEAT,Z.NAME_ BUSINESS_CATEGORY, " // + "J.NAME_ DETECTMAR,DECODE(C.STANDROLL,'1','√',NULL) STANDROLL,G.NAME_ ROLE," // + "C.STOVENO,DECODE(C.QUENCH,'1','√',NULL) QUENCH,DECODE(C.TMCP,'1','√',NULL) TMCP," // + "DECODE(C.HEATROLL,'1','√',NULL) HEATROLL,DECODE(C.CONTROLROLL,'1','√',NULL) CONTROLROLL," // + "C.ID,K.NAME_ USE,L.NAME_ STANDARDNO,M.NAME_ TRANSTYPE,N.NAME_ TRAINTYPE,C.PICKSTORAGEMAN," // + "TO_CHAR(C.PICKSTORAGETIME,'YYYY-MM-DD HH24:MI:SS') PICKSTORAGETIME,C.LISTNUMBER," // + "C.REMARK,DECODE(C.ISVALID,'2','√',NULL) ISVALID,C.ADDWEIGHT," // + "DECODE(C.ISCASTPROCESS,'1','√',NULL) ISCASTPROCESS,DECODE(C.ISPRINTPROCESS,'1','√',NULL) ISPRINTPROCESS," // + "DECODE(C.MILLINGPROCESS,'1','√',NULL) MILLINGPROCESS," // + "DECODE(O.ISD1,'1','√','×')||P.NAME_ SURFACETREATMENT," // + "DECODE(O.ISD2,'1','√','×')||O.SURFACEROUGHNESS SURFACEROUGHNESS," // + "DECODE(O.ISD3,'1','√','×')||O.COATTHICKNESS COATTHICKNESS," // + "DECODE(O.ISD4,'1','√','×')||O.DRYINGTIME DRYINGTIME," // + "O.VALIDTIME " // + "FROM SEL_ASKVEHICLEPLANINFL A,SEL_INCEPTCORPINFO B,KCJ_TURNOFFSENDLIST C,SEL_STATIONINFO D," // + "SCM_BASE_INFO E,SCM_BASE_INFO F,SCM_BASE_INFO G,SCM_BASE_INFO H,SCM_BASE_INFO I," // + "SCM_BASE_INFO J,SCM_BASE_INFO K,SCM_BASE_INFO L,SCM_BASE_INFO M,SCM_BASE_INFO N,KCJ_BASEDATA Z," // + "JGZJ_INSPECTIONINFO O,KCJ_BASEDATA P " // + "WHERE A.INCEPTCORPCODE=B.INCEPTCORPCODE(+) AND A.STATIONCODE=D.STATIONCODE(+) AND C.Business_Category=Z.ID_(+) " // + "AND A.ASKPLAN_ID(+)=C.PLANVEHICLEID AND C.ISVALID<>'0' AND C.DUMMYSENDFLAG<>'1' " // + "AND C.CLASSORDER=E.ID_(+) AND C.CLASSTEAM=F.ID_(+) AND C.ROLE=G.ID_(+) AND C.DETERMINANTRESULT=H.ID_(+) " // + "AND C.CLIPTYPEPROCESS=I.ID_(+) AND C.DETECTMAR=J.ID_(+) AND C.USE=K.ID_(+) AND C.STANDARDNO=L.ID_(+) " // + "AND A.TRANSTYPE=M.ID_(+) AND A.TRAINTYPE=N.ID_(+) AND C.INSPECTIONID=O.INSPECTIONID(+) " // + "AND O.SURFACETREATMENT=P.ID_(+) AND C.LISTNUMBER LIKE 'PC%' AND C.SERIALNUMBER NOT LIKE 'Y%' " // + where.Replace("A.DLIV_DIRNO", "A.ASKPLAN_ID") // +" UNION ALL " // +"SELECT B.INCEPTCORPNAME,D.STATIONNAME,C.BUTTRESS,C.CONDOLENUMBER,C.SERIALNUMBER,C.CLASSORDER,E.NAME_ CLASSORDERNAME," // + "C.CLASSTEAM,F.NAME_ CLASSTEAMNAME,C.TRAINWAGON,C.PLANVEHICLEID,C.PACTNO,C.ORDERFORMNUMBER,C.ROLLNO,C.PLANNO,C.STEELTYPE," // + "C.PLY,C.WIDTH,C.LENGTH,C.WEIGHT,H.NAME_ DETERMINANTRESULT,I.NAME_ CUTSIDE,DECODE(C.ISHEAT,'1','√',NULL) ISHEAT,'' BUSINESS_CATEGORY," // + "J.NAME_ DETECTMAR,DECODE(C.STANDROLL,'1','√',NULL) STANDROLL,G.NAME_ ROLE," // + "C.STOVENO,DECODE(C.QUENCH,'1','√',NULL) QUENCH,DECODE(C.TMCP,'1','√',NULL) TMCP," // + "DECODE(C.HEATROLL,'1','√',NULL) HEATROLL,DECODE(C.CONTROLROLL,'1','√',NULL) CONTROLROLL," // + "C.ID,K.NAME_ USE,L.NAME_ STANDARDNO,M.NAME_ TRANSTYPE,N.NAME_ TRAINTYPE,C.PICKSTORAGEMAN," // + "TO_CHAR(C.PICKSTORAGETIME,'YYYY-MM-DD HH24:MI:SS') PICKSTORAGETIME,C.LISTNUMBER," // + "C.REMARK,DECODE(C.ISVALID,'2','√',NULL) ISVALID,C.ADDWEIGHT," // + "DECODE(C.ISCASTPROCESS,'1','√',NULL) ISCASTPROCESS,DECODE(C.ISPRINTPROCESS,'1','√',NULL) ISPRINTPROCESS," // + "DECODE(C.MILLINGPROCESS,'1','√',NULL) MILLINGPROCESS," // + "DECODE(O.ISD1,'1','√','×')||P.NAME_ SURFACETREATMENT," // + "DECODE(O.ISD2,'1','√','×')||O.SURFACEROUGHNESS SURFACEROUGHNESS," // + "DECODE(O.ISD3,'1','√','×')||O.COATTHICKNESS COATTHICKNESS," // + "DECODE(O.ISD4,'1','√','×')||O.DRYINGTIME DRYINGTIME," // + "O.VALIDTIME " // + "FROM OVS_DLIV_DIR@XGXS A,SEL_INCEPTCORPINFO B,KCJ_TURNOFFSENDLIST C,SEL_STATIONINFO D," // + "SCM_BASE_INFO E,SCM_BASE_INFO F,SCM_BASE_INFO G,SCM_BASE_INFO H,SCM_BASE_INFO I," // + "SCM_BASE_INFO J,SCM_BASE_INFO K,SCM_BASE_INFO L,SCM_BASE_INFO M,SCM_BASE_INFO N," // + "JGZJ_INSPECTIONINFO O,KCJ_BASEDATA P " // + "WHERE A.ACP_DEPT=B.INCEPTCORPCODE(+) AND A.DEST_PCD=D.STATIONCODE(+) AND INSTR(A.DLIV_DIRNO,'Y')>0 " // + "AND A.DLIV_DIRNO(+)=C.PLANVEHICLEID AND C.ISVALID<>'0' AND C.DUMMYSENDFLAG<>'1' " // + "AND C.CLASSORDER=E.ID_(+) AND C.CLASSTEAM=F.ID_(+) AND C.ROLE=G.ID_(+) AND C.DETERMINANTRESULT=H.ID_(+) " // + "AND C.CLIPTYPEPROCESS=I.ID_(+) AND C.DETECTMAR=J.ID_(+) AND C.USE=K.ID_(+) AND C.STANDARDNO=L.ID_(+) " // + "AND A.TRANSTYPE=M.ID_(+) AND A.TRAINTYPE=N.ID_(+) AND C.INSPECTIONID=O.INSPECTIONID(+) " // + "AND O.SURFACETREATMENT=P.ID_(+) AND C.LISTNUMBER LIKE 'PC%' AND C.SERIALNUMBER NOT LIKE 'Y%' " // + where; string sql = "SELECT B.INCEPTCORPNAME,D.STATIONNAME,C.BUTTRESS,C.CONDOLENUMBER,C.SERIALNUMBER,C.CLASSORDER,E.NAME_ CLASSORDERNAME," + "C.CLASSTEAM,F.NAME_ CLASSTEAMNAME,C.TRAINWAGON,C.PLANVEHICLEID,C.PACTNO,C.ORDERFORMNUMBER,C.ROLLNO,C.PLANNO,C.STEELTYPE," + "C.PLY,C.WIDTH,C.LENGTH,C.WEIGHT,H.NAME_ DETERMINANTRESULT,I.NAME_ CUTSIDE,DECODE(C.ISHEAT,'1','√',NULL) ISHEAT,'' BUSINESS_CATEGORY," + "J.NAME_ DETECTMAR,DECODE(C.STANDROLL,'1','√',NULL) STANDROLL,G.NAME_ ROLE," + "C.STOVENO,DECODE(C.QUENCH,'1','√',NULL) QUENCH,DECODE(C.TMCP,'1','√',NULL) TMCP," + "DECODE(C.HEATROLL,'1','√',NULL) HEATROLL,DECODE(C.CONTROLROLL,'1','√',NULL) CONTROLROLL," + "C.ID,K.NAME_ USE,L.NAME_ STANDARDNO,M.NAME_ TRANSTYPE,N.NAME_ TRAINTYPE,C.PICKSTORAGEMAN," + "TO_CHAR(C.PICKSTORAGETIME,'YYYY-MM-DD HH24:MI:SS') PICKSTORAGETIME,C.LISTNUMBER," + "C.REMARK,DECODE(C.ISVALID,'2','√',NULL) ISVALID,C.ADDWEIGHT," + "DECODE(C.ISCASTPROCESS,'1','√',NULL) ISCASTPROCESS,DECODE(C.ISPRINTPROCESS,'1','√',NULL) ISPRINTPROCESS," + "DECODE(C.MILLINGPROCESS,'1','√',NULL) MILLINGPROCESS," + "DECODE(O.ISD1,'1','√','×')||P.NAME_ SURFACETREATMENT," + "DECODE(O.ISD2,'1','√','×')||O.SURFACEROUGHNESS SURFACEROUGHNESS," + "DECODE(O.ISD3,'1','√','×')||O.COATTHICKNESS COATTHICKNESS," + "DECODE(O.ISD4,'1','√','×')||O.DRYINGTIME DRYINGTIME," + "O.VALIDTIME " + "FROM OVS_DLIV_DIR@XGXS A,SEL_INCEPTCORPINFO B,KCJ_TURNOFFSENDLIST C,SEL_STATIONINFO D," + "SCM_BASE_INFO E,SCM_BASE_INFO F,SCM_BASE_INFO G,SCM_BASE_INFO H,SCM_BASE_INFO I," + "SCM_BASE_INFO J,SCM_BASE_INFO K,SCM_BASE_INFO L,SCM_BASE_INFO M,SCM_BASE_INFO N," + "JGZJ_INSPECTIONINFO O,KCJ_BASEDATA P " + "WHERE A.ACP_DEPT=B.INCEPTCORPCODE(+) AND A.DEST_PCD=D.STATIONCODE(+) AND INSTR(A.DLIV_DIRNO,'Y')>0 " + "AND A.DLIV_DIRNO(+)=C.PLANVEHICLEID AND C.ISVALID<>'0' AND C.DUMMYSENDFLAG<>'1' " + "AND C.CLASSORDER=E.ID_(+) AND C.CLASSTEAM=F.ID_(+) AND C.ROLE=G.ID_(+) AND C.DETERMINANTRESULT=H.ID_(+) " + "AND C.CLIPTYPEPROCESS=I.ID_(+) AND C.DETECTMAR=J.ID_(+) AND C.USE=K.ID_(+) AND C.STANDARDNO=L.ID_(+) " + "AND A.TRANSTYPE=M.ID_(+) AND A.TRAINTYPE=N.ID_(+) AND C.INSPECTIONID=O.INSPECTIONID(+) " + "AND O.SURFACETREATMENT=P.ID_(+) AND C.LISTNUMBER LIKE 'PC%' AND C.SERIALNUMBER NOT LIKE 'Y%' AND C.SERIALNUMBER NOT LIKE 'B%' AND C.SERIALNUMBER NOT LIKE 'E%' " + where; string err = ""; System.Data.DataSet dst = this.DBManager.ExecuteQuery(sql, out err); if (dst != null && dst.Tables.Count == 1 && dst.Tables[0].Rows.Count > 0) { dst.Tables[0].TableName = "KCJ_TURNOFFSENDLIST"; return new ReturnObject(dst); } else { return new ReturnObject(null); } } catch (System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return new ReturnObject(null); } } public ReturnObject GetPSSendListGXData(string where) { try { string sql = "SELECT B.INCEPTCORPNAME,D.STATIONNAME,C.BUTTRESS,C.CONDOLENUMBER,C.SERIALNUMBER,C.CLASSORDER,E.NAME_ CLASSORDERNAME," + "C.CLASSTEAM,F.NAME_ CLASSTEAMNAME,C.TRAINWAGON,C.PLANVEHICLEID,C.PACTNO,C.ORDERFORMNUMBER,C.ROLLNO,C.PLANNO,C.STEELTYPE," + "C.PLY,C.WIDTH,C.LENGTH,C.WEIGHT,H.NAME_ DETERMINANTRESULT,I.NAME_ CUTSIDE,DECODE(C.ISHEAT,'1','√',NULL) ISHEAT,Z.NAME_ BUSINESS_CATEGORY, " + "J.NAME_ DETECTMAR,DECODE(C.STANDROLL,'1','√',NULL) STANDROLL,G.NAME_ ROLE," + "C.STOVENO,DECODE(C.QUENCH,'1','√',NULL) QUENCH,DECODE(C.TMCP,'1','√',NULL) TMCP," + "DECODE(C.HEATROLL,'1','√',NULL) HEATROLL,DECODE(C.CONTROLROLL,'1','√',NULL) CONTROLROLL," + "C.ID,K.NAME_ USE,L.NAME_ STANDARDNO,M.NAME_ TRANSTYPE,N.NAME_ TRAINTYPE,C.PICKSTORAGEMAN," + "TO_CHAR(C.PICKSTORAGETIME,'YYYY-MM-DD HH24:MI:SS') PICKSTORAGETIME,C.LISTNUMBER," + "C.REMARK,DECODE(C.ISVALID,'2','√',NULL) ISVALID,C.ADDWEIGHT," + "DECODE(C.ISCASTPROCESS,'1','√',NULL) ISCASTPROCESS,DECODE(C.ISPRINTPROCESS,'1','√',NULL) ISPRINTPROCESS," + "DECODE(C.MILLINGPROCESS,'1','√',NULL) MILLINGPROCESS," + "DECODE(O.ISD1,'1','√','×')||P.NAME_ SURFACETREATMENT," + "DECODE(O.ISD2,'1','√','×')||O.SURFACEROUGHNESS SURFACEROUGHNESS," + "DECODE(O.ISD3,'1','√','×')||O.COATTHICKNESS COATTHICKNESS," + "DECODE(O.ISD4,'1','√','×')||O.DRYINGTIME DRYINGTIME," + "O.VALIDTIME " + "FROM SEL_ASKVEHICLEPLANINFL A,SEL_INCEPTCORPINFO B,KCJ_TURNOFFSENDLIST C,SEL_STATIONINFO D," + "SCM_BASE_INFO E,SCM_BASE_INFO F,SCM_BASE_INFO G,SCM_BASE_INFO H,SCM_BASE_INFO I," + "SCM_BASE_INFO J,SCM_BASE_INFO K,SCM_BASE_INFO L,SCM_BASE_INFO M,SCM_BASE_INFO N,KCJ_BASEDATA Z," + "JGZJ_INSPECTIONINFO O,KCJ_BASEDATA P " + "WHERE A.INCEPTCORPCODE=B.INCEPTCORPCODE(+) AND A.STATIONCODE=D.STATIONCODE(+) AND C.Business_Category=Z.ID_(+) " + "AND A.ASKPLAN_ID(+)=C.PLANVEHICLEID AND C.ISVALID<>'0' AND C.DUMMYSENDFLAG<>'1' " + "AND C.CLASSORDER=E.ID_(+) AND C.CLASSTEAM=F.ID_(+) AND C.ROLE=G.ID_(+) AND C.DETERMINANTRESULT=H.ID_(+) " + "AND C.CLIPTYPEPROCESS=I.ID_(+) AND C.DETECTMAR=J.ID_(+) AND C.USE=K.ID_(+) AND C.STANDARDNO=L.ID_(+) " + "AND A.TRANSTYPE=M.ID_(+) AND A.TRAINTYPE=N.ID_(+) AND C.INSPECTIONID=O.INSPECTIONID(+) " + "AND O.SURFACETREATMENT=P.ID_(+) AND (C.LISTNUMBER LIKE 'PC%' OR C.LISTNUMBER LIKE 'PL%' OR C.LISTNUMBER LIKE 'PX%') AND (C.SERIALNUMBER LIKE 'Y%' OR C.SERIALNUMBER LIKE 'E%' OR C.SERIALNUMBER LIKE 'B%') " + where; string err = ""; System.Data.DataSet dst = this.DBManager.ExecuteQuery(sql, out err); if (dst != null && dst.Tables.Count == 1 && dst.Tables[0].Rows.Count > 0) { dst.Tables[0].TableName = "KCJ_TURNOFFSENDLIST"; return new ReturnObject(dst); } else { return new ReturnObject(null); } } catch (System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return new ReturnObject(null); } } public ReturnObject GetBJBSendListData(string where) { try { string sql = "SELECT B.INCEPTCORPNAME,D.STATIONNAME,C.BUTTRESS,C.CONDOLENUMBER,C.SERIALNUMBER,C.CLASSORDER,E.NAME_ CLASSORDERNAME," + "C.CLASSTEAM,F.NAME_ CLASSTEAMNAME,C.TRAINWAGON,C.PLANVEHICLEID,C.PACTNO,C.ORDERFORMNUMBER,C.ROLLNO,C.PLANNO,C.STEELTYPE," + "C.PLY,C.WIDTH,C.LENGTH,C.WEIGHT,H.NAME_ DETERMINANTRESULT,I.NAME_ CUTSIDE,DECODE(C.ISHEAT,'1','√',NULL) ISHEAT," + "J.NAME_ DETECTMAR,DECODE(C.STANDROLL,'1','√',NULL) STANDROLL,G.NAME_ ROLE," + "C.STOVENO,DECODE(C.QUENCH,'1','√',NULL) QUENCH,DECODE(C.TMCP,'1','√',NULL) TMCP," + "DECODE(C.HEATROLL,'1','√',NULL) HEATROLL,DECODE(C.CONTROLROLL,'1','√',NULL) CONTROLROLL," + "C.ID,K.NAME_ USE,L.NAME_ STANDARDNO,M.NAME_ TRANSTYPE,N.NAME_ TRAINTYPE,C.PICKSTORAGEMAN," + "TO_CHAR(C.PICKSTORAGETIME,'YYYY-MM-DD HH24:MI:SS') PICKSTORAGETIME,C.LISTNUMBER," + "C.REMARK,DECODE(C.ISVALID,'2','√',NULL) ISVALID,C.ADDWEIGHT," + "DECODE(C.ISCASTPROCESS,'1','√',NULL) ISCASTPROCESS,DECODE(C.ISPRINTPROCESS,'1','√',NULL) ISPRINTPROCESS," + "DECODE(C.MILLINGPROCESS,'1','√',NULL) MILLINGPROCESS," + "DECODE(O.ISD1,'1','√','×')||P.NAME_ SURFACETREATMENT," + "DECODE(O.ISD2,'1','√','×')||O.SURFACEROUGHNESS SURFACEROUGHNESS," + "DECODE(O.ISD3,'1','√','×')||O.COATTHICKNESS COATTHICKNESS," + "DECODE(O.ISD4,'1','√','×')||O.DRYINGTIME DRYINGTIME," + "O.VALIDTIME " + "FROM OVS_DLIV_DIR@XGXS A,SEL_INCEPTCORPINFO B,KCJ_TURNOFFSENDLIST C,SEL_STATIONINFO D," + "SCM_BASE_INFO E,SCM_BASE_INFO F,SCM_BASE_INFO G,SCM_BASE_INFO H,SCM_BASE_INFO I," + "SCM_BASE_INFO J,SCM_BASE_INFO K,SCM_BASE_INFO L,SCM_BASE_INFO M,SCM_BASE_INFO N," + "JGZJ_INSPECTIONINFO O,KCJ_BASEDATA P " + "WHERE A.ACP_DEPT=B.INCEPTCORPCODE(+) AND A.DEST_PCD=D.STATIONCODE(+) AND INSTR(A.DLIV_DIRNO,'Y')>0 " + "AND A.DLIV_DIRNO(+)=C.PLANVEHICLEID AND C.ISVALID<>'0' AND C.DUMMYSENDFLAG<>'1' " + "AND C.CLASSORDER=E.ID_(+) AND C.CLASSTEAM=F.ID_(+) AND C.ROLE=G.ID_(+) AND C.DETERMINANTRESULT=H.ID_(+) " + "AND C.CLIPTYPEPROCESS=I.ID_(+) AND C.DETECTMAR=J.ID_(+) AND C.USE=K.ID_(+) AND C.STANDARDNO=L.ID_(+) " + "AND A.TRANSTYPE=M.ID_(+) AND A.TRAINTYPE=N.ID_(+) AND C.INSPECTIONID=O.INSPECTIONID(+) " + "AND O.SURFACETREATMENT=P.ID_(+) " + where; string err = ""; System.Data.DataSet dst = this.DBManager.ExecuteQuery(sql, out err); if (dst != null && dst.Tables.Count == 1 && dst.Tables[0].Rows.Count > 0) { dst.Tables[0].TableName = "KCJ_TURNOFFSENDLIST"; return new ReturnObject(dst); } else { return new ReturnObject(null); } } catch (System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return new ReturnObject(null); } } //获取板材加工打印明细的数据 public ReturnObject GetPrintData(string ListCoding,string strlx,string strRole) { try { System.Data.DataSet rtndst = new DataSet(); string tmpRollNO = ""; int tmpCount = 0; System.Decimal tmpWeight = 0; string SendType = ""; string JBFlag = ""; string err = ""; string sql = "SELECT SENDTYPE,ISCASTPROCESS||ISPRINTPROCESS FROM KCJ_TURNOFFSENDLIST WHERE ISVALID<>'0' AND DUMMYSENDFLAG<>'1' AND LISTNUMBER='"+ListCoding+"'"; System.Data.DataSet tmpdst = this.DBManager.ExecuteQuery(sql,out err); if(tmpdst!=null && tmpdst.Tables.Count==1 && tmpdst.Tables[0].Rows.Count>0) { SendType = FixDBManager.CheckNullStr(tmpdst.Tables[0].Rows[0][0]); JBFlag = FixDBManager.CheckNullStr(tmpdst.Tables[0].Rows[0][1]); } else { return new ReturnObject(null); } tmpdst = null; #region "形成打印头" string Top = GetPrintTopSql(SendType,JBFlag,ListCoding); tmpdst = this.DBManager.ExecuteQuery(Top,out err); if(tmpdst!=null && tmpdst.Tables.Count==1 && tmpdst.Tables[0].Rows.Count>0) { tmpdst.Tables[0].TableName = "TOP"; rtndst.Merge(tmpdst.Copy()); } else { return new ReturnObject(null); } #endregion #region "形成打印数据源" if (strlx != "YL") { string[] DataSql = new string [10]; if (strlx == "3") { DataSql = GetPrintDataSqlXC(JBFlag, ListCoding); } else if (strlx == "2") { DataSql = GetPrintDataSqlYL_PS(JBFlag, ListCoding); } else { DataSql = GetPrintDataSql(JBFlag, ListCoding); } for (int idx = 0; idx < DataSql.Length; idx++) { tmpdst = null; tmpdst = this.DBManager.ExecuteQuery(DataSql[idx], out err); if (tmpdst != null && tmpdst.Tables.Count == 1 && tmpdst.Tables[0].Rows.Count > 0) { tmpdst.Tables[0].TableName = "DATA"; rtndst.Merge(tmpdst.Copy()); if (idx == 0) { for (int i = 0; i < rtndst.Tables["DATA"].Rows.Count; i++) { if (tmpRollNO != "" && tmpRollNO != FixDBManager.CheckNullStr(rtndst.Tables["DATA"].Rows[i]["ROLLNO"])) { System.Data.DataRow nrow = rtndst.Tables["DATA"].NewRow(); nrow["SERIALNUMBER"] = "小计："; if (strlx == "3") { nrow["SPET"] = FixDBManager.CheckNullStr(tmpCount) + " 卷"; } else { nrow["SPET"] = FixDBManager.CheckNullStr(tmpCount) + " 张"; } nrow["WEIGHT"] = tmpWeight; rtndst.Tables["DATA"].Rows.InsertAt(nrow, i); i = i + 1; tmpRollNO = FixDBManager.CheckNullStr(rtndst.Tables["DATA"].Rows[i]["ROLLNO"]); tmpCount = 1; tmpWeight = FixDBManager.CheckNullDecimal(rtndst.Tables["DATA"].Rows[i]["WEIGHT"]); } else { tmpRollNO = FixDBManager.CheckNullStr(rtndst.Tables["DATA"].Rows[i]["ROLLNO"]); tmpCount = tmpCount + 1; tmpWeight = tmpWeight + FixDBManager.CheckNullDecimal(rtndst.Tables["DATA"].Rows[i]["WEIGHT"]); } } System.Data.DataRow nrow1 = rtndst.Tables["DATA"].NewRow(); nrow1["SERIALNUMBER"] = "小计："; if (strlx == "3") { nrow1["SPET"] = FixDBManager.CheckNullStr(tmpCount) + " 卷"; } else { nrow1["SPET"] = FixDBManager.CheckNullStr(tmpCount) + " 张"; } nrow1["WEIGHT"] = tmpWeight; rtndst.Tables["DATA"].Rows.InsertAt(nrow1, rtndst.Tables["DATA"].Rows.Count); System.Data.DataRow nrow2 = rtndst.Tables["DATA"].NewRow(); nrow2["STEELTYPE"] = "按规格"; nrow2["SERIALNUMBER"] = "分类统计"; rtndst.Tables["DATA"].Rows.Add(nrow2); } } else { if (idx == 0) return new ReturnObject(null); } } } else { string[] DataSql1; if (strRole == "pszxck") { DataSql1 = GetPrintDataSqlYL_PS(JBFlag, ListCoding); } else { DataSql1 = GetPrintDataSqlYL(JBFlag, ListCoding); } for (int idx = 0; idx < DataSql1.Length; idx++) { tmpdst = null; tmpdst = this.DBManager.ExecuteQuery(DataSql1[idx], out err); if (tmpdst != null && tmpdst.Tables.Count == 1 && tmpdst.Tables[0].Rows.Count > 0) { tmpdst.Tables[0].TableName = "DATA"; rtndst.Merge(tmpdst.Copy()); if (idx == 0) { for (int i = 0; i < rtndst.Tables["DATA"].Rows.Count; i++) { if (tmpRollNO != "" && tmpRollNO != FixDBManager.CheckNullStr(rtndst.Tables["DATA"].Rows[i]["ROLLNO"])) { System.Data.DataRow nrow = rtndst.Tables["DATA"].NewRow(); nrow["SERIALNUMBER"] = "小计："; if (strlx == "3") { nrow["SPET"] = FixDBManager.CheckNullStr(tmpCount) + " 卷"; } else { nrow["SPET"] = FixDBManager.CheckNullStr(tmpCount) + " 张"; } nrow["WEIGHT"] = tmpWeight; rtndst.Tables["DATA"].Rows.InsertAt(nrow, i); i = i + 1; tmpRollNO = FixDBManager.CheckNullStr(rtndst.Tables["DATA"].Rows[i]["ROLLNO"]); tmpCount = 1; tmpWeight = FixDBManager.CheckNullDecimal(rtndst.Tables["DATA"].Rows[i]["WEIGHT"]); } else { tmpRollNO = FixDBManager.CheckNullStr(rtndst.Tables["DATA"].Rows[i]["ROLLNO"]); tmpCount = tmpCount + 1; tmpWeight = tmpWeight + FixDBManager.CheckNullDecimal(rtndst.Tables["DATA"].Rows[i]["WEIGHT"]); } } System.Data.DataRow nrow1 = rtndst.Tables["DATA"].NewRow(); nrow1["SERIALNUMBER"] = "小计："; if (strlx == "3") { nrow1["SPET"] = FixDBManager.CheckNullStr(tmpCount) + " 卷"; } else { nrow1["SPET"] = FixDBManager.CheckNullStr(tmpCount) + " 张"; } nrow1["WEIGHT"] = tmpWeight; rtndst.Tables["DATA"].Rows.InsertAt(nrow1, rtndst.Tables["DATA"].Rows.Count); System.Data.DataRow nrow2 = rtndst.Tables["DATA"].NewRow(); nrow2["STEELTYPE"] = "按规格"; nrow2["SERIALNUMBER"] = "分类统计"; rtndst.Tables["DATA"].Rows.Add(nrow2); } } else { if (idx == 0) return new ReturnObject(null); } } } #endregion if(rtndst.Tables.Count == 2) return new ReturnObject(rtndst); return new ReturnObject(null); } catch(System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return new ReturnObject(null); } } public ReturnObject GetPrintData_BJB(string ListCoding) { try { System.Data.DataSet rtndst = new DataSet(); string tmpRollNO = ""; int tmpCount = 0; System.Decimal tmpWeight = 0; string SendType = ""; string JBFlag = ""; string err = ""; string sql = "SELECT SENDTYPE,ISCASTPROCESS||ISPRINTPROCESS FROM KCJ_TURNOFFSENDLIST WHERE ISVALID<>'0' AND DUMMYSENDFLAG<>'1' AND LISTNUMBER='" + ListCoding + "'"; System.Data.DataSet tmpdst = this.DBManager.ExecuteQuery(sql, out err); if (tmpdst != null && tmpdst.Tables.Count == 1 && tmpdst.Tables[0].Rows.Count > 0) { SendType = FixDBManager.CheckNullStr(tmpdst.Tables[0].Rows[0][0]); JBFlag = FixDBManager.CheckNullStr(tmpdst.Tables[0].Rows[0][1]); } else { return new ReturnObject(null); } tmpdst = null; #region "形成打印头" string Top = GetPrintTopSql_BJB(SendType, JBFlag, ListCoding); tmpdst = this.DBManager.ExecuteQuery(Top, out err); if (tmpdst != null && tmpdst.Tables.Count == 1 && tmpdst.Tables[0].Rows.Count > 0) { tmpdst.Tables[0].TableName = "TOP"; rtndst.Merge(tmpdst.Copy()); } else { return new ReturnObject(null); } #endregion #region "形成打印数据源" string[] DataSql = GetPrintDataSql_BJB(JBFlag, ListCoding); for (int idx = 0; idx < DataSql.Length; idx++) { tmpdst = null; tmpdst = this.DBManager.ExecuteQuery(DataSql[idx], out err); if (tmpdst != null && tmpdst.Tables.Count == 1 && tmpdst.Tables[0].Rows.Count > 0) { tmpdst.Tables[0].TableName = "DATA"; rtndst.Merge(tmpdst.Copy()); if (idx == 0) { for (int i = 0; i < rtndst.Tables["DATA"].Rows.Count; i++) { if (tmpRollNO != "" && tmpRollNO != FixDBManager.CheckNullStr(rtndst.Tables["DATA"].Rows[i]["ROLLNO"])) { System.Data.DataRow nrow = rtndst.Tables["DATA"].NewRow(); nrow["ROLLNO"] = "小计："; nrow["SPET"] = FixDBManager.CheckNullStr(tmpCount) + " 张"; nrow["WEIGHT"] = tmpWeight; rtndst.Tables["DATA"].Rows.InsertAt(nrow, i); i = i + 1; tmpRollNO = FixDBManager.CheckNullStr(rtndst.Tables["DATA"].Rows[i]["ROLLNO"]); tmpCount = 1; tmpWeight = FixDBManager.CheckNullDecimal(rtndst.Tables["DATA"].Rows[i]["WEIGHT"]); } else { tmpRollNO = FixDBManager.CheckNullStr(rtndst.Tables["DATA"].Rows[i]["ROLLNO"]); tmpCount = tmpCount + 1; tmpWeight = tmpWeight + FixDBManager.CheckNullDecimal(rtndst.Tables["DATA"].Rows[i]["WEIGHT"]); } } System.Data.DataRow nrow1 = rtndst.Tables["DATA"].NewRow(); nrow1["ROLLNO"] = "小计："; nrow1["SPET"] = FixDBManager.CheckNullStr(tmpCount) + " 张"; nrow1["WEIGHT"] = tmpWeight; rtndst.Tables["DATA"].Rows.InsertAt(nrow1, rtndst.Tables["DATA"].Rows.Count); System.Data.DataRow nrow2 = rtndst.Tables["DATA"].NewRow(); nrow2["STEELTYPE"] = "按规格"; nrow2["ROLLNO"] = "分类统计"; rtndst.Tables["DATA"].Rows.Add(nrow2); } } else { if (idx == 0) return new ReturnObject(null); } } #endregion if (rtndst.Tables.Count == 2) return new ReturnObject(rtndst); return new ReturnObject(null); } catch (System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return new ReturnObject(null); } } public ReturnObject DelSendList(System.Collections.ArrayList Billets,System.Collections.ArrayList SendInfo,string strlx,string strrole) { try { string err = ""; Oracle.DataAccess.Client.OracleParameter pBillets = new Oracle.DataAccess.Client.OracleParameter("vBillets", Oracle.DataAccess.Client.OracleDbType.Varchar2); Oracle.DataAccess.Client.OracleParameter pSendInfo = new Oracle.DataAccess.Client.OracleParameter("vSendInfo", Oracle.DataAccess.Client.OracleDbType.Varchar2); Oracle.DataAccess.Client.OracleParameter pSuccessFlag = new Oracle.DataAccess.Client.OracleParameter("vSuccessFlag", Oracle.DataAccess.Client.OracleDbType.Varchar2); pBillets.Direction = ParameterDirection.Input; pSendInfo.Direction = ParameterDirection.Input; pSuccessFlag.Direction = ParameterDirection.Output; pBillets.CollectionType = Oracle.DataAccess.Client.OracleCollectionType.PLSQLAssociativeArray; pSendInfo.CollectionType = Oracle.DataAccess.Client.OracleCollectionType.PLSQLAssociativeArray; pBillets.Value = Billets.ToArray(typeof(string)); pSendInfo.Value = SendInfo.ToArray(typeof(string)); int []OSizeInf = new int[Billets.Count]; for(int i =0;i< Billets.Count;i++) { OSizeInf[i ] = 200; } pBillets.Size = Billets.Count; pBillets.ArrayBindSize = OSizeInf; int []NSizeInf = new int[SendInfo.Count]; for(int i =0;i< SendInfo.Count;i++) { NSizeInf[i ] = 200; } pSendInfo.Size = SendInfo.Count; pSendInfo.ArrayBindSize = NSizeInf; pSuccessFlag.Size = 400; if (strlx == "YL" || strlx == "2") { ((STMes.DBManager)DBManagerList["ODPDB"]).ExecuteNonQuery_NoDBSever("KCJ_TURNOFFSEND.DELSENDLIST_YL", CommandType.StoredProcedure, new Oracle.DataAccess.Client.OracleParameter[] { pBillets, pSendInfo, pSuccessFlag }, out err); } else if ( strlx == "3") { ((STMes.DBManager)DBManagerList["ODPDB"]).ExecuteNonQuery_NoDBSever("KCJ_TURNOFFSEND.DELSENDLIST_PS", CommandType.StoredProcedure, new Oracle.DataAccess.Client.OracleParameter[] { pBillets, pSendInfo, pSuccessFlag }, out err); } else { ((STMes.DBManager)DBManagerList["ODPDB"]).ExecuteNonQuery_NoDBSever("KCJ_TURNOFFSEND.DELSENDLIST_P", CommandType.StoredProcedure, new Oracle.DataAccess.Client.OracleParameter[] { pBillets, pSendInfo, pSuccessFlag }, out err); } if(FixDBManager.CheckNullStr(pSuccessFlag.Value).Length>0 | FixDBManager.CheckNullStr(err).Length>0) { return new ReturnObject(null,1,pSuccessFlag.Value.ToString()+err); } else { return new ReturnObject('1'); } } catch(System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return new ReturnObject(null); } } public ReturnObject GetListData(string ListCoding) { try { string sql = "SELECT A.PLANVEHICLEID,A.TRAINWAGON,A.CERTIFICATENO,B.PACTNO,B.MATERIALNO,B.CUSTOMER,B.INCEPTCORPNAME," +"B.PRIMERSUPPLY,B.PRIMERNAME,B.PICKSTORAGETIME,A.CLASSORDER,A.CLASSTEAM,A.PICKSTORAGEMAN " +"FROM KCJ_TURNOFFSENDLIST A,KCJ_OTHERSENDINFO B WHERE A.CERTIFICATENO=B.CERTIFICATENO(+) AND A.LISTNUMBER='" + ListCoding + "' " +"AND A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND ROWNUM=1"; string err = ""; System.Data.DataSet rtndst = this.DBManager.ExecuteQuery(sql,out err); if(rtndst!=null && rtndst.Tables.Count==1 && rtndst.Tables[0].Rows.Count>0) { return new ReturnObject(rtndst); } return new ReturnObject(null); } catch(System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return new ReturnObject(null); } } public ReturnObject GetListOrderData(string BiletID) { try { string sql = "SELECT B.PACTNO ORDERNO FROM KCJ_TURNOFFLIST F, SEL_PACTDETAIL B WHERE F.ORDERNO = B.ORDERNO(+) AND BILLETID='" + BiletID + "'" + " AND ROWNUM=1"; string err = ""; System.Data.DataSet rtndst = this.DBManager.ExecuteQuery(sql, out err); if (rtndst != null && rtndst.Tables.Count == 1 && rtndst.Tables[0].Rows.Count > 0) { return new ReturnObject(rtndst); } return new ReturnObject(null); } catch (System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return new ReturnObject(null); } } public ReturnObject GetListOrderDataYL(string BiletID) { try { string sql = "SELECT B.PACTNO ORDERNO FROM KCJ_STORAGELIST F, SEL_PACTDETAIL B WHERE F.ORDERNO = B.ORDERNO(+) AND BILLETID='" + BiletID + "'" + " AND ROWNUM=1"; string err = ""; System.Data.DataSet rtndst = this.DBManager.ExecuteQuery(sql, out err); if (rtndst != null && rtndst.Tables.Count == 1 && rtndst.Tables[0].Rows.Count > 0) { return new ReturnObject(rtndst); } return new ReturnObject(null); } catch (System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return new ReturnObject(null); } } public ReturnObject EditVechileNO(string ListCoding,string VechileNO) { try { string err = ""; Oracle.DataAccess.Client.OracleParameter pListCoding = new Oracle.DataAccess.Client.OracleParameter("vListCoding", Oracle.DataAccess.Client.OracleDbType.Varchar2); Oracle.DataAccess.Client.OracleParameter pVechileNO = new Oracle.DataAccess.Client.OracleParameter("vVechileNO", Oracle.DataAccess.Client.OracleDbType.Varchar2); Oracle.DataAccess.Client.OracleParameter pSuccessFlag = new Oracle.DataAccess.Client.OracleParameter("vSuccessFlag", Oracle.DataAccess.Client.OracleDbType.Varchar2); pListCoding.Direction = ParameterDirection.Input; pVechileNO.Direction = ParameterDirection.Input; pSuccessFlag.Direction = ParameterDirection.Output; pListCoding.Value = ListCoding; pVechileNO.Value = VechileNO; pSuccessFlag.Size = 400; ((STMes.DBManager)DBManagerList["ODPDB"]).ExecuteNonQuery_NoDBSever("KCJ_TURNOFFSEND.EditVechihleNO", CommandType.StoredProcedure, new Oracle.DataAccess.Client.OracleParameter[] {pListCoding,pVechileNO,pSuccessFlag}, out err); if(FixDBManager.CheckNullStr(pSuccessFlag.Value).Length>0 | FixDBManager.CheckNullStr(err).Length>0) { return new ReturnObject(null,1,pSuccessFlag.Value.ToString()+err); } else { return new ReturnObject('1'); } } catch(System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return new ReturnObject(null); } } private string GetPrintTopSql(string SendType,string JBFlag,string ListCoding) { string tmpSql = "SELECT T1.*,T2.QUANTITY,T2.WEIGHT{0} FROM " +"(" +"SELECT B.PACTNO,B.BUYERCODE,A.PLANVEHICLEID ASKPLAN_ID,D.STATIONNAME,C.INCEPTCORPNAME," +"TO_CHAR(A.PICKSTORAGETIME,'YYYY-MM-DD') PICKSTORAGETIME,A.TRAINWAGON,E.BUYERNAME,A.LISTNUMBER,A.REMARK,NULL CREATOR " + "FROM KCJ_TURNOFFSENDLIST A,SEL_PACTDETAIL B,SEL_INCEPTCORPINFO C,SEL_STATIONINFO D,SEL_BUYERBASEINFO E " +"WHERE A.PACTNO=B.PACTNO(+) AND B.INCEPTCORPCODE=C.INCEPTCORPCODE(+) AND B.STATIONCODE=D.STATIONCODE(+) " +"AND B.BUYERCODE=E.BUYERCODE(+) AND A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND A.LISTNUMBER='" +ListCoding +"' AND ROWNUM=1 " +") T1 " +"LEFT JOIN " +"(" +"SELECT COUNT(SERIALNUMBER) QUANTITY,SUM(ADDWEIGHT) WEIGHT,LISTNUMBER{1} FROM KCJ_TURNOFFSENDLIST " +"WHERE ISVALID<>'0' AND DUMMYSENDFLAG<>'1' GROUP BY LISTNUMBER " +") T2 ON T1.LISTNUMBER=T2.LISTNUMBER"; //正式 string sql = "SELECT T1.*,T2.QUANTITY,T2.WEIGHT{0} FROM " +"(" +"SELECT B.PACTNO,B.BUYERCODE,C.ASKPLAN_ID,D.STATIONNAME,E.INCEPTCORPNAME,TO_CHAR(A.PICKSTORAGETIME,'YYYY-MM-DD') PICKSTORAGETIME," +"A.TRAINWAGON,F.BUYERNAME,A.LISTNUMBER,A.REMARK,NULL CREATOR " + "FROM KCJ_TURNOFFSENDLIST A,SEL_PACTDETAIL B,SEL_ASKVEHICLEPLANINFL C,SEL_STATIONINFO D,SEL_INCEPTCORPINFO E,SEL_BUYERBASEINFO F " +"WHERE A.PLANVEHICLEID=C.ASKPLAN_ID AND A.ORDERFORMNUMBER=B.ORDERNO AND C.INCEPTCORPCODE=E.INCEPTCORPCODE(+) AND C.STATIONCODE=D.STATIONCODE(+) " +"AND B.BUYERCODE=F.BUYERCODE(+) AND A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND A.LISTNUMBER='" +ListCoding +"' AND ROWNUM=1 " +"UNION " +"SELECT B.PACTNO,B.BUYERCODE,C.ASKPLAN_ID,D.STATIONNAME,E.INCEPTCORPNAME,TO_CHAR(A.PICKSTORAGETIME,'YYYY-MM-DD') PICKSTORAGETIME," +"A.TRAINWAGON,F.BUYERNAME,A.LISTNUMBER,A.REMARK,NULL CREATOR " + "FROM KCJ_TURNOFFSENDLIST A,SEL_PACTINFO_CLEAR B,SEL_ASKVEHICLEPLANINFL C,SEL_STATIONINFO D,SEL_INCEPTCORPINFO E,SEL_BUYERBASEINFO F " +"WHERE A.PLANVEHICLEID=C.ASKPLAN_ID AND A.ORDERFORMNUMBER=B.ORDERNO AND C.INCEPTCORPCODE=E.INCEPTCORPCODE(+) AND C.STATIONCODE=D.STATIONCODE(+) " +"AND B.BUYERCODE=F.BUYERCODE(+) AND A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND A.LISTNUMBER='" +ListCoding +"' AND ROWNUM=1 " +") T1 " +"LEFT JOIN " +"(" +"SELECT COUNT(SERIALNUMBER) QUANTITY,SUM(ADDWEIGHT) WEIGHT,LISTNUMBER{1} FROM KCJ_TURNOFFSENDLIST " +"WHERE ISVALID<>'0' AND DUMMYSENDFLAG<>'1' GROUP BY LISTNUMBER " +") T2 ON T1.LISTNUMBER=T2.LISTNUMBER"; //临时 // string sql=""; // if(!ListCoding.StartsWith("X")) // { // sql = "SELECT T1.*,T2.QUANTITY,T2.WEIGHT{0} FROM " // +"(" // +"SELECT B.PACTNO,B.BUYERCODE,C.ASKPLAN_ID,D.STATIONNAME,E.INCEPTCORPNAME,TO_CHAR(A.PICKSTORAGETIME,'YYYY-MM-DD') PICKSTORAGETIME," // +"A.TRAINWAGON,F.BUYERNAME,A.LISTNUMBER,A.REMARK,NULL CREATOR " // +"FROM KCJ_TURNOFFSENDLIST A,SEL_PACTDETAIL B,SEL_ASKVEHICLEPLANINFL C,SEL_STATIONINFO D,SEL_INCEPTCORPINFO E,SEL_BUYERBASEINFO F " // +"WHERE A.PLANVEHICLEID=C.ASKPLAN_ID AND A.ORDERFORMNUMBER=B.ORDERNO AND C.INCEPTCORPCODE=E.INCEPTCORPCODE(+) AND C.STATIONCODE=D.STATIONCODE(+) " // +"AND B.BUYERCODE=F.BUYERCODE(+) AND A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND A.LISTNUMBER='" +ListCoding +"' AND ROWNUM=1 " // +"UNION " // +"SELECT B.PACTNO,B.BUYERCODE,C.ASKPLAN_ID,D.STATIONNAME,E.INCEPTCORPNAME,TO_CHAR(A.PICKSTORAGETIME,'YYYY-MM-DD') PICKSTORAGETIME," // +"A.TRAINWAGON,F.BUYERNAME,A.LISTNUMBER,A.REMARK,NULL CREATOR " // +"FROM KCJ_TURNOFFSENDLIST A,SEL_PACTINFO_CLEAR B,SEL_ASKVEHICLEPLANINFL C,SEL_STATIONINFO D,SEL_INCEPTCORPINFO E,SEL_BUYERBASEINFO F " // +"WHERE A.PLANVEHICLEID=C.ASKPLAN_ID AND A.ORDERFORMNUMBER=B.ORDERNO AND C.INCEPTCORPCODE=E.INCEPTCORPCODE(+) AND C.STATIONCODE=D.STATIONCODE(+) " // +"AND B.BUYERCODE=F.BUYERCODE(+) AND A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND A.LISTNUMBER='" +ListCoding +"' AND ROWNUM=1 " // +") T1 " // +"LEFT JOIN " // +"(" // +"SELECT COUNT(SERIALNUMBER) QUANTITY,SUM(ADDWEIGHT) WEIGHT,LISTNUMBER{1} FROM KCJ_TURNOFFSENDLIST " // +"WHERE ISVALID<>'0' AND DUMMYSENDFLAG<>'1' GROUP BY LISTNUMBER " // +") T2 ON T1.LISTNUMBER=T2.LISTNUMBER"; // } // else // { // sql = "SELECT T1.*,T2.QUANTITY,T2.WEIGHT{0} FROM " // +"(" // +"SELECT A.PACTNO,B.BUYERCODE,C.ASKPLAN_ID,D.STATIONNAME,E.INCEPTCORPNAME,TO_CHAR(A.PICKSTORAGETIME,'YYYY-MM-DD') PICKSTORAGETIME," // +"A.TRAINWAGON,F.BUYERNAME,A.LISTNUMBER,A.REMARK,NULL CREATOR " // +"FROM KCJ_TURNOFFSENDLIST A,SEL_PACTDETAIL B,SEL_ASKVEHICLEPLANINFL C,SEL_STATIONINFO D,SEL_INCEPTCORPINFO E,SEL_BUYERBASEINFO F " // +"WHERE A.PLANVEHICLEID=C.ASKPLAN_ID AND A.ORDERFORMNUMBER=B.ORDERNO(+) AND C.INCEPTCORPCODE=E.INCEPTCORPCODE(+) AND C.STATIONCODE=D.STATIONCODE(+) " // +"AND B.BUYERCODE=F.BUYERCODE(+) AND A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND A.LISTNUMBER='" +ListCoding +"' AND ROWNUM=1 " // +"UNION " // +"SELECT A.PACTNO,B.BUYERCODE,C.ASKPLAN_ID,D.STATIONNAME,E.INCEPTCORPNAME,TO_CHAR(A.PICKSTORAGETIME,'YYYY-MM-DD') PICKSTORAGETIME," // +"A.TRAINWAGON,F.BUYERNAME,A.LISTNUMBER,A.REMARK,NULL CREATOR " // +"FROM KCJ_TURNOFFSENDLIST A,SEL_PACTINFO_CLEAR B,SEL_ASKVEHICLEPLANINFL C,SEL_STATIONINFO D,SEL_INCEPTCORPINFO E,SEL_BUYERBASEINFO F " // +"WHERE A.PLANVEHICLEID=C.ASKPLAN_ID AND A.ORDERFORMNUMBER=B.ORDERNO(+) AND C.INCEPTCORPCODE=E.INCEPTCORPCODE(+) AND C.STATIONCODE=D.STATIONCODE(+) " // +"AND B.BUYERCODE=F.BUYERCODE(+) AND A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND A.LISTNUMBER='" +ListCoding +"' AND ROWNUM=1 " // +") T1 " // +"LEFT JOIN " // +"(" // +"SELECT COUNT(SERIALNUMBER) QUANTITY,SUM(ADDWEIGHT) WEIGHT,LISTNUMBER{1} FROM KCJ_TURNOFFSENDLIST " // +"WHERE ISVALID<>'0' AND DUMMYSENDFLAG<>'1' GROUP BY LISTNUMBER " // +") T2 ON T1.LISTNUMBER=T2.LISTNUMBER"; // } string tfSql= @" SELECT T1.*, T2.QUANTITY, T2.WEIGHT " + " FROM (SELECT NULL PACTNO, " + " NULL BUYERCODE, " + " A.PLANVEHICLEID ASKPLAN_ID, " + " NULL STATIONNAME, " + " NULL INCEPTCORPNAME, " + " TO_CHAR(A.PICKSTORAGETIME, 'YYYY-MM-DD') PICKSTORAGETIME, " + " NULL TRAINWAGON, " + " NULL BUYERNAME, " + " A.LISTNUMBER, " + " A.REMARK, " + " NULL CREATOR " + " FROM KCJ_TURNOFFSENDLIST A " + " WHERE A.ISVALID <> '0' " + " AND A.DUMMYSENDFLAG <> '1' " + " AND A.LISTNUMBER = '" +ListCoding +"'" + " AND ROWNUM = 1)T1 " + " LEFT JOIN (SELECT COUNT(SERIALNUMBER) QUANTITY, " + " SUM(ADDWEIGHT) WEIGHT, " + " LISTNUMBER " + " FROM KCJ_TURNOFFSENDLIST " + " WHERE ISVALID <> '0' " + " AND DUMMYSENDFLAG <> '1' " + " GROUP BY LISTNUMBER) T2 ON T1.LISTNUMBER = T2.LISTNUMBER"; string rtnSql = ""; if(SendType =="1") { rtnSql = tmpSql; } else if(SendType =="7") { rtnSql = tfSql; } else { rtnSql = sql; } if(SendType != "7") { if(JBFlag!="00") { rtnSql = string.Format(rtnSql,",TO_CHAR(T2.AREA) AREA",",SUM(ACREAGE) AREA "); } else { rtnSql = string.Format(rtnSql,"",""); } } return rtnSql; } private string GetPrintTopSql_BJB(string SendType, string JBFlag, string ListCoding) { string tmpSql = "SELECT T1.*,T2.QUANTITY,T2.WEIGHT{0} FROM " + "(" + "SELECT C.ORD_NO PACTNO,C.CUST_CD BUYERCODE,C.DLIV_DIRNO ASKPLAN_ID,D.STATIONNAME,E.INCEPTCORPNAME," + "TO_CHAR(A.PICKSTORAGETIME, 'YYYY-MM-DD') PICKSTORAGETIME,A.TRAINWAGON,F.BUYERNAME,A.LISTNUMBER,A.REMARK,NULL CREATOR " + " FROM KCJ_TURNOFFSENDLIST A,OVS_DLIV_DIR@XGXS C,SEL_STATIONINFO D,SEL_INCEPTCORPINFO E,SEL_BUYERBASEINFO F " + "WHERE A.PLANVEHICLEID = C.DLIV_DIRNO AND C.ACP_DEPT = E.INCEPTCORPCODE(+) AND C.DEST_PCD = D.STATIONCODE(+) AND C.CUST_CD = F.BUYERCODE(+) " + "AND A.ISVALID <> '0' AND A.DUMMYSENDFLAG <> '1' AND A.LISTNUMBER='" + ListCoding + "' AND ROWNUM=1 " + ") T1 " + "LEFT JOIN " + "(" + "SELECT COUNT(SERIALNUMBER) QUANTITY,SUM(ADDWEIGHT) WEIGHT,LISTNUMBER{1} FROM KCJ_TURNOFFSENDLIST " + "WHERE ISVALID<>'0' AND DUMMYSENDFLAG<>'1' GROUP BY LISTNUMBER " + ") T2 ON T1.LISTNUMBER=T2.LISTNUMBER"; //正式 string sql = "SELECT T1.*,T2.QUANTITY,T2.WEIGHT{0} FROM " + "(" + "SELECT C.ORD_NO PACTNO,C.CUST_CD BUYERCODE,C.DLIV_DIRNO ASKPLAN_ID,D.STATIONNAME,E.INCEPTCORPNAME,TO_CHAR(A.PICKSTORAGETIME,'YYYY-MM-DD') PICKSTORAGETIME," + "A.TRAINWAGON,F.BUYERNAME,A.LISTNUMBER,A.REMARK,NULL CREATOR " + "FROM KCJ_TURNOFFSENDLIST A,OVS_DLIV_DIR@XGXS C,SEL_STATIONINFO D,SEL_INCEPTCORPINFO E,SEL_BUYERBASEINFO F " + "WHERE A.PLANVEHICLEID = C.DLIV_DIRNO AND C.ACP_DEPT = E.INCEPTCORPCODE(+) AND C.DEST_PCD = D.STATIONCODE(+) AND C.CUST_CD = F.BUYERCODE(+) " + " AND A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND A.LISTNUMBER='" + ListCoding + "' AND ROWNUM=1 " + ") T1 " + "LEFT JOIN " + "(" + "SELECT COUNT(SERIALNUMBER) QUANTITY,SUM(ADDWEIGHT) WEIGHT,LISTNUMBER{1} FROM KCJ_TURNOFFSENDLIST " + "WHERE ISVALID<>'0' AND DUMMYSENDFLAG<>'1' GROUP BY LISTNUMBER " + ") T2 ON T1.LISTNUMBER=T2.LISTNUMBER"; //临时 // string sql=""; // if(!ListCoding.StartsWith("X")) // { // sql = "SELECT T1.*,T2.QUANTITY,T2.WEIGHT{0} FROM " // +"(" // +"SELECT B.PACTNO,B.BUYERCODE,C.ASKPLAN_ID,D.STATIONNAME,E.INCEPTCORPNAME,TO_CHAR(A.PICKSTORAGETIME,'YYYY-MM-DD') PICKSTORAGETIME," // +"A.TRAINWAGON,F.BUYERNAME,A.LISTNUMBER,A.REMARK,NULL CREATOR " // +"FROM KCJ_TURNOFFSENDLIST A,SEL_PACTDETAIL B,SEL_ASKVEHICLEPLANINFL C,SEL_STATIONINFO D,SEL_INCEPTCORPINFO E,SEL_BUYERBASEINFO F " // +"WHERE A.PLANVEHICLEID=C.ASKPLAN_ID AND A.ORDERFORMNUMBER=B.ORDERNO AND C.INCEPTCORPCODE=E.INCEPTCORPCODE(+) AND C.STATIONCODE=D.STATIONCODE(+) " // +"AND B.BUYERCODE=F.BUYERCODE(+) AND A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND A.LISTNUMBER='" +ListCoding +"' AND ROWNUM=1 " // +"UNION " // +"SELECT B.PACTNO,B.BUYERCODE,C.ASKPLAN_ID,D.STATIONNAME,E.INCEPTCORPNAME,TO_CHAR(A.PICKSTORAGETIME,'YYYY-MM-DD') PICKSTORAGETIME," // +"A.TRAINWAGON,F.BUYERNAME,A.LISTNUMBER,A.REMARK,NULL CREATOR " // +"FROM KCJ_TURNOFFSENDLIST A,SEL_PACTINFO_CLEAR B,SEL_ASKVEHICLEPLANINFL C,SEL_STATIONINFO D,SEL_INCEPTCORPINFO E,SEL_BUYERBASEINFO F " // +"WHERE A.PLANVEHICLEID=C.ASKPLAN_ID AND A.ORDERFORMNUMBER=B.ORDERNO AND C.INCEPTCORPCODE=E.INCEPTCORPCODE(+) AND C.STATIONCODE=D.STATIONCODE(+) " // +"AND B.BUYERCODE=F.BUYERCODE(+) AND A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND A.LISTNUMBER='" +ListCoding +"' AND ROWNUM=1 " // +") T1 " // +"LEFT JOIN " // +"(" // +"SELECT COUNT(SERIALNUMBER) QUANTITY,SUM(ADDWEIGHT) WEIGHT,LISTNUMBER{1} FROM KCJ_TURNOFFSENDLIST " // +"WHERE ISVALID<>'0' AND DUMMYSENDFLAG<>'1' GROUP BY LISTNUMBER " // +") T2 ON T1.LISTNUMBER=T2.LISTNUMBER"; // } // else // { // sql = "SELECT T1.*,T2.QUANTITY,T2.WEIGHT{0} FROM " // +"(" // +"SELECT A.PACTNO,B.BUYERCODE,C.ASKPLAN_ID,D.STATIONNAME,E.INCEPTCORPNAME,TO_CHAR(A.PICKSTORAGETIME,'YYYY-MM-DD') PICKSTORAGETIME," // +"A.TRAINWAGON,F.BUYERNAME,A.LISTNUMBER,A.REMARK,NULL CREATOR " // +"FROM KCJ_TURNOFFSENDLIST A,SEL_PACTDETAIL B,SEL_ASKVEHICLEPLANINFL C,SEL_STATIONINFO D,SEL_INCEPTCORPINFO E,SEL_BUYERBASEINFO F " // +"WHERE A.PLANVEHICLEID=C.ASKPLAN_ID AND A.ORDERFORMNUMBER=B.ORDERNO(+) AND C.INCEPTCORPCODE=E.INCEPTCORPCODE(+) AND C.STATIONCODE=D.STATIONCODE(+) " // +"AND B.BUYERCODE=F.BUYERCODE(+) AND A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND A.LISTNUMBER='" +ListCoding +"' AND ROWNUM=1 " // +"UNION " // +"SELECT A.PACTNO,B.BUYERCODE,C.ASKPLAN_ID,D.STATIONNAME,E.INCEPTCORPNAME,TO_CHAR(A.PICKSTORAGETIME,'YYYY-MM-DD') PICKSTORAGETIME," // +"A.TRAINWAGON,F.BUYERNAME,A.LISTNUMBER,A.REMARK,NULL CREATOR " // +"FROM KCJ_TURNOFFSENDLIST A,SEL_PACTINFO_CLEAR B,SEL_ASKVEHICLEPLANINFL C,SEL_STATIONINFO D,SEL_INCEPTCORPINFO E,SEL_BUYERBASEINFO F " // +"WHERE A.PLANVEHICLEID=C.ASKPLAN_ID AND A.ORDERFORMNUMBER=B.ORDERNO(+) AND C.INCEPTCORPCODE=E.INCEPTCORPCODE(+) AND C.STATIONCODE=D.STATIONCODE(+) " // +"AND B.BUYERCODE=F.BUYERCODE(+) AND A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND A.LISTNUMBER='" +ListCoding +"' AND ROWNUM=1 " // +") T1 " // +"LEFT JOIN " // +"(" // +"SELECT COUNT(SERIALNUMBER) QUANTITY,SUM(ADDWEIGHT) WEIGHT,LISTNUMBER{1} FROM KCJ_TURNOFFSENDLIST " // +"WHERE ISVALID<>'0' AND DUMMYSENDFLAG<>'1' GROUP BY LISTNUMBER " // +") T2 ON T1.LISTNUMBER=T2.LISTNUMBER"; // } string tfSql = @" SELECT T1.*, T2.QUANTITY, T2.WEIGHT " + " FROM (SELECT NULL PACTNO, " + " NULL BUYERCODE, " + " A.PLANVEHICLEID ASKPLAN_ID, " + " NULL STATIONNAME, " + " NULL INCEPTCORPNAME, " + " TO_CHAR(A.PICKSTORAGETIME, 'YYYY-MM-DD') PICKSTORAGETIME, " + " NULL TRAINWAGON, " + " NULL BUYERNAME, " + " A.LISTNUMBER, " + " A.REMARK, " + " NULL CREATOR " + " FROM KCJ_TURNOFFSENDLIST A " + " WHERE A.ISVALID <> '0' " + " AND A.DUMMYSENDFLAG <> '1' " + " AND A.LISTNUMBER = '" + ListCoding + "'" + " AND ROWNUM = 1)T1 " + " LEFT JOIN (SELECT COUNT(SERIALNUMBER) QUANTITY, " + " SUM(ADDWEIGHT) WEIGHT, " + " LISTNUMBER " + " FROM KCJ_TURNOFFSENDLIST " + " WHERE ISVALID <> '0' " + " AND DUMMYSENDFLAG <> '1' " + " GROUP BY LISTNUMBER) T2 ON T1.LISTNUMBER = T2.LISTNUMBER"; string rtnSql = ""; if (SendType == "1") { rtnSql = tmpSql; } else if (SendType == "7") { rtnSql = tfSql; } else { rtnSql = sql; } if (SendType != "7") { if (JBFlag != "00") { rtnSql = string.Format(rtnSql, ",TO_CHAR(T2.AREA) AREA", ",SUM(ACREAGE) AREA "); } else { rtnSql = string.Format(rtnSql, "", ""); } } return rtnSql; } private string[] GetPrintDataSql(string JBFlag,string ListCoding) { string Sql = "SELECT (CASE WHEN A.DETERMINANTRESULT LIKE '401403%' AND A.CLIPTYPEPROCESS='103001' THEN '次品' ELSE A.STEELTYPE END) STEELTYPE," + "A.ORDERBUYER ROLLNO,TO_CHAR(A.PLY)||'×'||TO_CHAR(A.WIDTH)||'×'||TO_CHAR(A.LENGTH) SPET," +"A.ADDWEIGHT WEIGHT,A.SERIALNUMBER,"//SUBSTR(A.SERIALNUMBER,INSTR(A.SERIALNUMBER,'.',1)+1,LENGTH(A.SERIALNUMBER)-INSTR(A.SERIALNUMBER,'.',1)) +" '' PICKSTORAGETIME,(SELECT NAME_ FROM SCM_BASE_INFO WHERE ID_=A.CLIPTYPEPROCESS) CUTSIDE{0} " +"FROM KCJ_TURNOFFSENDLIST A,KCJ_TURNOFFLIST B WHERE A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND A.SERIALNUMBER=B.BILLETID " + "AND A.LISTNUMBER='" + ListCoding + "' ORDER BY A.STEELTYPE,A.ORDERBUYER,A.CREATTIME ASC "; //双定 string SSql = "SELECT (CASE WHEN A.DETERMINANTRESULT LIKE '401403%' AND A.CLIPTYPEPROCESS='103001' THEN '次品' ELSE A.STEELTYPE END) STEELTYPE," + "TO_CHAR(COUNT(A.SERIALNUMBER))||'张' SERIALNUMBER," +"TO_CHAR(A.PLY)||'×'||TO_CHAR(A.WIDTH)||'×'||TO_CHAR(A.LENGTH) SPET," +"SUM(A.ADDWEIGHT) WEIGHT,NULL SERIALNUMBER,NULL PICKSTORAGETIME,NULL CUTSIDE {0}" +"FROM KCJ_TURNOFFSENDLIST A " +"WHERE A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND A.ROLE='102203' AND A.LISTNUMBER='"+ListCoding+"' " +"GROUP BY A.STEELTYPE,A.PLY,A.WIDTH,A.LENGTH,A.DETERMINANTRESULT,A.CLIPTYPEPROCESS"; //定长 string CSql = "SELECT (CASE WHEN A.DETERMINANTRESULT LIKE '401403%' AND A.CLIPTYPEPROCESS='103001' THEN '次品' ELSE A.STEELTYPE END) STEELTYPE," + "TO_CHAR(COUNT(A.SERIALNUMBER))||'张' SERIALNUMBER," +"TO_CHAR(A.PLY)||'×'||TO_CHAR(A.LENGTH) SPET," +"SUM(A.ADDWEIGHT) WEIGHT,NULL SERIALNUMBER,NULL PICKSTORAGETIME,NULL CUTSIDE {0}" +"FROM KCJ_TURNOFFSENDLIST A " +"WHERE A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND A.ROLE='102201' AND A.LISTNUMBER='"+ListCoding+"' " +"GROUP BY A.STEELTYPE,A.PLY,A.LENGTH,A.DETERMINANTRESULT,A.CLIPTYPEPROCESS"; //定宽 string KSql = "SELECT (CASE WHEN A.DETERMINANTRESULT LIKE '401403%' AND A.CLIPTYPEPROCESS='103001' THEN '次品' ELSE A.STEELTYPE END) STEELTYPE," + "TO_CHAR(COUNT(A.SERIALNUMBER))||'张' SERIALNUMBER," +"TO_CHAR(A.PLY)||'×'||TO_CHAR(A.WIDTH) SPET," +"SUM(A.ADDWEIGHT) WEIGHT,NULL SERIALNUMBER,NULL PICKSTORAGETIME,NULL CUTSIDE {0}" +"FROM KCJ_TURNOFFSENDLIST A " +"WHERE A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND (A.ROLE='102202' OR A.ROLE='102206') AND A.LISTNUMBER='"+ListCoding+"' " +"GROUP BY A.STEELTYPE,A.PLY,A.WIDTH,A.DETERMINANTRESULT,A.CLIPTYPEPROCESS"; //非定 string FSql = "SELECT (CASE WHEN A.DETERMINANTRESULT LIKE '401403%' AND A.CLIPTYPEPROCESS='103001' THEN '次品' ELSE A.STEELTYPE END) STEELTYPE," + "TO_CHAR(COUNT(A.SERIALNUMBER))||'张' SERIALNUMBER," +"TO_CHAR(A.PLY)||'非' SPET," +"SUM(A.ADDWEIGHT) WEIGHT,NULL SERIALNUMBER,NULL PICKSTORAGETIME,NULL CUTSIDE {0}" +"FROM KCJ_TURNOFFSENDLIST A " +"WHERE A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND (A.ROLE='102204' OR A.ROLE='102205') AND A.LISTNUMBER='"+ListCoding+"' " +"GROUP BY A.STEELTYPE,A.PLY,A.DETERMINANTRESULT,A.CLIPTYPEPROCESS"; if(JBFlag=="11") { Sql = string.Format(Sql,",TO_CHAR(A.ACREAGE) AREA "); SSql = string.Format(SSql,",TO_CHAR(SUM(A.ACREAGE)) AREA "); KSql = string.Format(KSql,",TO_CHAR(SUM(A.ACREAGE)) AREA "); CSql = string.Format(CSql,",TO_CHAR(SUM(A.ACREAGE)) AREA "); FSql = string.Format(FSql,",TO_CHAR(SUM(A.ACREAGE)) AREA "); } else { Sql = string.Format(Sql," "); SSql = string.Format(SSql," "); KSql = string.Format(KSql," "); CSql = string.Format(CSql," "); FSql = string.Format(FSql," "); } //zw 2008-04-07 string[] rtnSql = new string[]{Sql,SSql,KSql,CSql,FSql};//,FSql return rtnSql; } private string[] GetPrintDataSqlXC(string JBFlag, string ListCoding) { string Sql = "SELECT (CASE WHEN A.DETERMINANTRESULT LIKE '401403%' AND A.CLIPTYPEPROCESS='103001' THEN '次品' ELSE A.STEELTYPE END) STEELTYPE," + "A.ORDERBUYER ROLLNO,TO_CHAR(A.PLY)||'×'||TO_CHAR(A.WIDTH)||'×'||TO_CHAR(A.LENGTH) SPET," + "A.ADDWEIGHT WEIGHT,A.SERIALNUMBER,"//SUBSTR(A.SERIALNUMBER,INSTR(A.SERIALNUMBER,'.',1)+1,LENGTH(A.SERIALNUMBER)-INSTR(A.SERIALNUMBER,'.',1)) + " '' PICKSTORAGETIME,(SELECT NAME_ FROM SCM_BASE_INFO WHERE ID_=A.CLIPTYPEPROCESS) CUTSIDE{0} " + "FROM KCJ_TURNOFFSENDLIST A,KCJ_TURNOFFLIST B WHERE A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND A.SERIALNUMBER=B.BILLETID " + "AND A.LISTNUMBER='" + ListCoding + "' ORDER BY A.STEELTYPE,A.ORDERBUYER"; //双定 string SSql = "SELECT (CASE WHEN A.DETERMINANTRESULT LIKE '401403%' AND A.CLIPTYPEPROCESS='103001' THEN '次品' ELSE A.STEELTYPE END) STEELTYPE," + "TO_CHAR(COUNT(A.SERIALNUMBER))||'捆' SERIALNUMBER," + "TO_CHAR(A.PLY)||'×'||TO_CHAR(A.WIDTH)||'×'||TO_CHAR(A.LENGTH) SPET," + "SUM(A.ADDWEIGHT) WEIGHT,NULL SERIALNUMBER,NULL PICKSTORAGETIME,NULL CUTSIDE {0}" + "FROM KCJ_TURNOFFSENDLIST A " + "WHERE A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND A.ROLE='102203' AND A.LISTNUMBER='" + ListCoding + "' " + "GROUP BY A.STEELTYPE,A.PLY,A.WIDTH,A.LENGTH,A.DETERMINANTRESULT,A.CLIPTYPEPROCESS"; //定长 string CSql = "SELECT (CASE WHEN A.DETERMINANTRESULT LIKE '401403%' AND A.CLIPTYPEPROCESS='103001' THEN '次品' ELSE A.STEELTYPE END) STEELTYPE," + "TO_CHAR(COUNT(A.SERIALNUMBER))||'捆' SERIALNUMBER," + "TO_CHAR(A.PLY)||'×'||TO_CHAR(A.LENGTH) SPET," + "SUM(A.ADDWEIGHT) WEIGHT,NULL SERIALNUMBER,NULL PICKSTORAGETIME,NULL CUTSIDE {0}" + "FROM KCJ_TURNOFFSENDLIST A " + "WHERE A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND A.ROLE='102201' AND A.LISTNUMBER='" + ListCoding + "' " + "GROUP BY A.STEELTYPE,A.PLY,A.LENGTH,A.DETERMINANTRESULT,A.CLIPTYPEPROCESS"; //定宽 string KSql = "SELECT (CASE WHEN A.DETERMINANTRESULT LIKE '401403%' AND A.CLIPTYPEPROCESS='103001' THEN '次品' ELSE A.STEELTYPE END) STEELTYPE," + "TO_CHAR(COUNT(A.SERIALNUMBER))||'捆' SERIALNUMBER," + "TO_CHAR(A.PLY)||'×'||TO_CHAR(A.WIDTH) SPET," + "SUM(A.ADDWEIGHT) WEIGHT,NULL SERIALNUMBER,NULL PICKSTORAGETIME,NULL CUTSIDE {0}" + "FROM KCJ_TURNOFFSENDLIST A " + "WHERE A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND (A.ROLE='102202' OR A.ROLE='102206') AND A.LISTNUMBER='" + ListCoding + "' " + "GROUP BY A.STEELTYPE,A.PLY,A.WIDTH,A.DETERMINANTRESULT,A.CLIPTYPEPROCESS"; //非定 string FSql = "SELECT (CASE WHEN A.DETERMINANTRESULT LIKE '401403%' AND A.CLIPTYPEPROCESS='103001' THEN '次品' ELSE A.STEELTYPE END) STEELTYPE," + "TO_CHAR(COUNT(A.SERIALNUMBER))||'捆' SERIALNUMBER," + "TO_CHAR(A.PLY)||'非' SPET," + "SUM(A.ADDWEIGHT) WEIGHT,NULL SERIALNUMBER,NULL PICKSTORAGETIME,NULL CUTSIDE {0}" + "FROM KCJ_TURNOFFSENDLIST A " + "WHERE A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND (A.ROLE='102204' OR A.ROLE='102205') AND A.LISTNUMBER='" + ListCoding + "' " + "GROUP BY A.STEELTYPE,A.PLY,A.DETERMINANTRESULT,A.CLIPTYPEPROCESS"; if (JBFlag == "11") { Sql = string.Format(Sql, ",TO_CHAR(A.ACREAGE) AREA "); SSql = string.Format(SSql, ",TO_CHAR(SUM(A.ACREAGE)) AREA "); KSql = string.Format(KSql, ",TO_CHAR(SUM(A.ACREAGE)) AREA "); CSql = string.Format(CSql, ",TO_CHAR(SUM(A.ACREAGE)) AREA "); FSql = string.Format(FSql, ",TO_CHAR(SUM(A.ACREAGE)) AREA "); } else { Sql = string.Format(Sql, " "); SSql = string.Format(SSql, " "); KSql = string.Format(KSql, " "); CSql = string.Format(CSql, " "); FSql = string.Format(FSql, " "); } //zw 2008-04-07 string[] rtnSql = new string[] { Sql, SSql, KSql, CSql, FSql };//,FSql return rtnSql; } private string[] GetPrintDataSqlYL(string JBFlag, string ListCoding) { string Sql = "SELECT (CASE WHEN A.DETERMINANTRESULT LIKE '401403%' AND A.CLIPTYPEPROCESS='103001' THEN '次品' ELSE A.STEELTYPE END) STEELTYPE," + "A.ORDERBUYER ROLLNO,TO_CHAR(A.PLY)||'×'||TO_CHAR(A.WIDTH)||'×'||TO_CHAR(A.LENGTH) SPET," + "A.ADDWEIGHT WEIGHT,A.SERIALNUMBER,"//SUBSTR(A.SERIALNUMBER,INSTR(A.SERIALNUMBER,'.',1)+1,LENGTH(A.SERIALNUMBER)-INSTR(A.SERIALNUMBER,'.',1)) + " '' PICKSTORAGETIME,(SELECT NAME_ FROM SCM_BASE_INFO WHERE ID_=A.CLIPTYPEPROCESS) CUTSIDE{0} " + "FROM KCJ_TURNOFFSENDLIST A,KCJ_STORAGELIST B WHERE A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND A.SERIALNUMBER=B.BILLETID " + "AND A.LISTNUMBER='" + ListCoding + "' ORDER BY A.STEELTYPE,A.ORDERBUYER"; //双定 string SSql = "SELECT (CASE WHEN A.DETERMINANTRESULT LIKE '401403%' AND A.CLIPTYPEPROCESS='103001' THEN '次品' ELSE A.STEELTYPE END) STEELTYPE," + "TO_CHAR(COUNT(A.SERIALNUMBER))||'张' SERIALNUMBER," + "TO_CHAR(A.PLY)||'×'||TO_CHAR(A.WIDTH)||'×'||TO_CHAR(A.LENGTH) SPET," + "SUM(A.ADDWEIGHT) WEIGHT,NULL SERIALNUMBER,NULL PICKSTORAGETIME,NULL CUTSIDE {0}" + "FROM KCJ_TURNOFFSENDLIST A " + "WHERE A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND A.ROLE='102203' AND A.LISTNUMBER='" + ListCoding + "' " + "GROUP BY A.STEELTYPE,A.PLY,A.WIDTH,A.LENGTH,A.DETERMINANTRESULT,A.CLIPTYPEPROCESS"; //定长 string CSql = "SELECT (CASE WHEN A.DETERMINANTRESULT LIKE '401403%' AND A.CLIPTYPEPROCESS='103001' THEN '次品' ELSE A.STEELTYPE END) STEELTYPE," + "TO_CHAR(COUNT(A.SERIALNUMBER))||'张' SERIALNUMBER," + "TO_CHAR(A.PLY)||'×'||TO_CHAR(A.LENGTH) SPET," + "SUM(A.ADDWEIGHT) WEIGHT,NULL SERIALNUMBER,NULL PICKSTORAGETIME,NULL CUTSIDE {0}" + "FROM KCJ_TURNOFFSENDLIST A " + "WHERE A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND A.ROLE='102201' AND A.LISTNUMBER='" + ListCoding + "' " + "GROUP BY A.STEELTYPE,A.PLY,A.LENGTH,A.DETERMINANTRESULT,A.CLIPTYPEPROCESS"; //定宽 string KSql = "SELECT (CASE WHEN A.DETERMINANTRESULT LIKE '401403%' AND A.CLIPTYPEPROCESS='103001' THEN '次品' ELSE A.STEELTYPE END) STEELTYPE," + "TO_CHAR(COUNT(A.SERIALNUMBER))||'张' SERIALNUMBER," + "TO_CHAR(A.PLY)||'×'||TO_CHAR(A.WIDTH) SPET," + "SUM(A.ADDWEIGHT) WEIGHT,NULL SERIALNUMBER,NULL PICKSTORAGETIME,NULL CUTSIDE {0}" + "FROM KCJ_TURNOFFSENDLIST A " + "WHERE A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND (A.ROLE='102202' OR A.ROLE='102206') AND A.LISTNUMBER='" + ListCoding + "' " + "GROUP BY A.STEELTYPE,A.PLY,A.WIDTH,A.DETERMINANTRESULT,A.CLIPTYPEPROCESS"; //非定 string FSql = "SELECT (CASE WHEN A.DETERMINANTRESULT LIKE '401403%' AND A.CLIPTYPEPROCESS='103001' THEN '次品' ELSE A.STEELTYPE END) STEELTYPE," + "TO_CHAR(COUNT(A.SERIALNUMBER))||'张' SERIALNUMBER," + "TO_CHAR(A.PLY)||'非' SPET," + "SUM(A.ADDWEIGHT) WEIGHT,NULL SERIALNUMBER,NULL PICKSTORAGETIME,NULL CUTSIDE {0}" + "FROM KCJ_TURNOFFSENDLIST A " + "WHERE A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND (A.ROLE='102204' OR A.ROLE='102205') AND A.LISTNUMBER='" + ListCoding + "' " + "GROUP BY A.STEELTYPE,A.PLY,A.DETERMINANTRESULT,A.CLIPTYPEPROCESS"; if (JBFlag == "11") { Sql = string.Format(Sql, ",TO_CHAR(A.ACREAGE) AREA "); SSql = string.Format(SSql, ",TO_CHAR(SUM(A.ACREAGE)) AREA "); KSql = string.Format(KSql, ",TO_CHAR(SUM(A.ACREAGE)) AREA "); CSql = string.Format(CSql, ",TO_CHAR(SUM(A.ACREAGE)) AREA "); FSql = string.Format(FSql, ",TO_CHAR(SUM(A.ACREAGE)) AREA "); } else { Sql = string.Format(Sql, " "); SSql = string.Format(SSql, " "); KSql = string.Format(KSql, " "); CSql = string.Format(CSql, " "); FSql = string.Format(FSql, " "); } //zw 2008-04-07 string[] rtnSql = new string[] { Sql, SSql, KSql, CSql, FSql };//,FSql return rtnSql; } private string[] GetPrintDataSqlYL_PS(string JBFlag, string ListCoding) { string Sql = "SELECT (CASE WHEN A.DETERMINANTRESULT LIKE '401403%' AND A.CLIPTYPEPROCESS='103001' THEN '次品' ELSE A.STEELTYPE END) STEELTYPE," + "A.ORDERBUYER ROLLNO,TO_CHAR(A.PLY)||'×'||TO_CHAR(A.WIDTH)||'×'||TO_CHAR(A.LENGTH) SPET," + "A.ADDWEIGHT WEIGHT,A.SERIALNUMBER,"//SUBSTR(A.SERIALNUMBER,INSTR(A.SERIALNUMBER,'.',1)+1,LENGTH(A.SERIALNUMBER)-INSTR(A.SERIALNUMBER,'.',1)) + " '' PICKSTORAGETIME,(SELECT NAME_ FROM SCM_BASE_INFO WHERE ID_=A.CLIPTYPEPROCESS) CUTSIDE{0} " + "FROM KCJ_TURNOFFSENDLIST A,KCP_STORAGELIST B WHERE A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND A.SERIALNUMBER=B.BILLETID(+) " + "AND A.LISTNUMBER='" + ListCoding + "' ORDER BY A.STEELTYPE,A.ORDERBUYER"; //双定 string SSql = "SELECT (CASE WHEN A.DETERMINANTRESULT LIKE '401403%' AND A.CLIPTYPEPROCESS='103001' THEN '次品' ELSE A.STEELTYPE END) STEELTYPE," + "TO_CHAR(COUNT(A.SERIALNUMBER))||'张' SERIALNUMBER," + "TO_CHAR(A.PLY)||'×'||TO_CHAR(A.WIDTH)||'×'||TO_CHAR(A.LENGTH) SPET," + "SUM(A.ADDWEIGHT) WEIGHT,NULL SERIALNUMBER,NULL PICKSTORAGETIME,NULL CUTSIDE {0}" + "FROM KCJ_TURNOFFSENDLIST A " + "WHERE A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND A.ROLE='102203' AND A.LISTNUMBER='" + ListCoding + "' " + "GROUP BY A.STEELTYPE,A.PLY,A.WIDTH,A.LENGTH,A.DETERMINANTRESULT,A.CLIPTYPEPROCESS"; //定长 string CSql = "SELECT (CASE WHEN A.DETERMINANTRESULT LIKE '401403%' AND A.CLIPTYPEPROCESS='103001' THEN '次品' ELSE A.STEELTYPE END) STEELTYPE," + "TO_CHAR(COUNT(A.SERIALNUMBER))||'张' SERIALNUMBER," + "TO_CHAR(A.PLY)||'×'||TO_CHAR(A.LENGTH) SPET," + "SUM(A.ADDWEIGHT) WEIGHT,NULL SERIALNUMBER,NULL PICKSTORAGETIME,NULL CUTSIDE {0}" + "FROM KCJ_TURNOFFSENDLIST A " + "WHERE A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND A.ROLE='102201' AND A.LISTNUMBER='" + ListCoding + "' " + "GROUP BY A.STEELTYPE,A.PLY,A.LENGTH,A.DETERMINANTRESULT,A.CLIPTYPEPROCESS"; //定宽 string KSql = "SELECT (CASE WHEN A.DETERMINANTRESULT LIKE '401403%' AND A.CLIPTYPEPROCESS='103001' THEN '次品' ELSE A.STEELTYPE END) STEELTYPE," + "TO_CHAR(COUNT(A.SERIALNUMBER))||'张' SERIALNUMBER," + "TO_CHAR(A.PLY)||'×'||TO_CHAR(A.WIDTH) SPET," + "SUM(A.ADDWEIGHT) WEIGHT,NULL SERIALNUMBER,NULL PICKSTORAGETIME,NULL CUTSIDE {0}" + "FROM KCJ_TURNOFFSENDLIST A " + "WHERE A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND (A.ROLE='102202' OR A.ROLE='102206') AND A.LISTNUMBER='" + ListCoding + "' " + "GROUP BY A.STEELTYPE,A.PLY,A.WIDTH,A.DETERMINANTRESULT,A.CLIPTYPEPROCESS"; //非定 string FSql = "SELECT (CASE WHEN A.DETERMINANTRESULT LIKE '401403%' AND A.CLIPTYPEPROCESS='103001' THEN '次品' ELSE A.STEELTYPE END) STEELTYPE," + "TO_CHAR(COUNT(A.SERIALNUMBER))||'张' SERIALNUMBER," + "TO_CHAR(A.PLY)||'非' SPET," + "SUM(A.ADDWEIGHT) WEIGHT,NULL SERIALNUMBER,NULL PICKSTORAGETIME,NULL CUTSIDE {0}" + "FROM KCJ_TURNOFFSENDLIST A " + "WHERE A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND (A.ROLE='102204' OR A.ROLE='102205') AND A.LISTNUMBER='" + ListCoding + "' " + "GROUP BY A.STEELTYPE,A.PLY,A.DETERMINANTRESULT,A.CLIPTYPEPROCESS"; if (JBFlag == "11") { Sql = string.Format(Sql, ",TO_CHAR(A.ACREAGE) AREA "); SSql = string.Format(SSql, ",TO_CHAR(SUM(A.ACREAGE)) AREA "); KSql = string.Format(KSql, ",TO_CHAR(SUM(A.ACREAGE)) AREA "); CSql = string.Format(CSql, ",TO_CHAR(SUM(A.ACREAGE)) AREA "); FSql = string.Format(FSql, ",TO_CHAR(SUM(A.ACREAGE)) AREA "); } else { Sql = string.Format(Sql, " "); SSql = string.Format(SSql, " "); KSql = string.Format(KSql, " "); CSql = string.Format(CSql, " "); FSql = string.Format(FSql, " "); } //zw 2008-04-07 string[] rtnSql = new string[] { Sql, SSql, KSql, CSql, FSql };//,FSql return rtnSql; } private string[] GetPrintDataSql_BJB(string JBFlag, string ListCoding) { string Sql = "SELECT (CASE WHEN A.DETERMINANTRESULT LIKE '401403%' AND A.CLIPTYPEPROCESS='103001' THEN '次品' ELSE A.STEELTYPE END) STEELTYPE," + "A.ROLLNO,TO_CHAR(A.PLY)||'×'||TO_CHAR(A.WIDTH)||'×'||TO_CHAR(A.LENGTH) SPET," + "A.ADDWEIGHT WEIGHT,SUBSTR(A.SERIALNUMBER,INSTR(A.SERIALNUMBER,'.',1)+1,LENGTH(A.SERIALNUMBER)-INSTR(A.SERIALNUMBER,'.',1)) SERIALNUMBER," + "TO_CHAR(B.PTIME,'MM.DD') PICKSTORAGETIME,(SELECT NAME_ FROM SCM_BASE_INFO WHERE ID_=A.CLIPTYPEPROCESS) CUTSIDE{0} " + "FROM KCJ_TURNOFFSENDLIST A,KCJ_TURNOFFLIST B WHERE A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND A.SERIALNUMBER=B.BILLETID " + "AND A.LISTNUMBER='" + ListCoding + "' ORDER BY A.STEELTYPE,A.ROLLNO"; //双定 string SSql = "SELECT (CASE WHEN A.DETERMINANTRESULT LIKE '401403%' AND A.CLIPTYPEPROCESS='103001' THEN '次品' ELSE A.STEELTYPE END) STEELTYPE," + "TO_CHAR(COUNT(A.SERIALNUMBER))||'张' ROLLNO," + "TO_CHAR(A.PLY)||'×'||TO_CHAR(A.WIDTH)||'×'||TO_CHAR(A.LENGTH) SPET," + "SUM(A.ADDWEIGHT) WEIGHT,NULL SERIALNUMBER,NULL PICKSTORAGETIME,NULL CUTSIDE {0}" + "FROM KCJ_TURNOFFSENDLIST A " + "WHERE A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND A.ROLE='102203' AND A.LISTNUMBER='" + ListCoding + "' " + "GROUP BY A.STEELTYPE,A.PLY,A.WIDTH,A.LENGTH,A.DETERMINANTRESULT,A.CLIPTYPEPROCESS"; //定长 string CSql = "SELECT (CASE WHEN A.DETERMINANTRESULT LIKE '401403%' AND A.CLIPTYPEPROCESS='103001' THEN '次品' ELSE A.STEELTYPE END) STEELTYPE," + "TO_CHAR(COUNT(A.SERIALNUMBER))||'张' ROLLNO," + "TO_CHAR(A.PLY)||'×'||TO_CHAR(A.LENGTH) SPET," + "SUM(A.ADDWEIGHT) WEIGHT,NULL SERIALNUMBER,NULL PICKSTORAGETIME,NULL CUTSIDE {0}" + "FROM KCJ_TURNOFFSENDLIST A " + "WHERE A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND A.ROLE='102201' AND A.LISTNUMBER='" + ListCoding + "' " + "GROUP BY A.STEELTYPE,A.PLY,A.LENGTH,A.DETERMINANTRESULT,A.CLIPTYPEPROCESS"; //定宽 string KSql = "SELECT (CASE WHEN A.DETERMINANTRESULT LIKE '401403%' AND A.CLIPTYPEPROCESS='103001' THEN '次品' ELSE A.STEELTYPE END) STEELTYPE," + "TO_CHAR(COUNT(A.SERIALNUMBER))||'张' ROLLNO," + "TO_CHAR(A.PLY)||'×'||TO_CHAR(A.WIDTH) SPET," + "SUM(A.ADDWEIGHT) WEIGHT,NULL SERIALNUMBER,NULL PICKSTORAGETIME,NULL CUTSIDE {0}" + "FROM KCJ_TURNOFFSENDLIST A " + "WHERE A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND (A.ROLE='102202' OR A.ROLE='102206') AND A.LISTNUMBER='" + ListCoding + "' " + "GROUP BY A.STEELTYPE,A.PLY,A.WIDTH,A.DETERMINANTRESULT,A.CLIPTYPEPROCESS"; //非定 string FSql = "SELECT (CASE WHEN A.DETERMINANTRESULT LIKE '401403%' AND A.CLIPTYPEPROCESS='103001' THEN '次品' ELSE A.STEELTYPE END) STEELTYPE," + "TO_CHAR(COUNT(A.SERIALNUMBER))||'张' ROLLNO," + "TO_CHAR(A.PLY)||'非' SPET," + "SUM(A.ADDWEIGHT) WEIGHT,NULL SERIALNUMBER,NULL PICKSTORAGETIME,NULL CUTSIDE {0}" + "FROM KCJ_TURNOFFSENDLIST A " + "WHERE A.ISVALID<>'0' AND A.DUMMYSENDFLAG<>'1' AND (A.ROLE='102204' OR A.ROLE='102205') AND A.LISTNUMBER='" + ListCoding + "' " + "GROUP BY A.STEELTYPE,A.PLY,A.DETERMINANTRESULT,A.CLIPTYPEPROCESS"; if (JBFlag == "11") { Sql = string.Format(Sql, ",TO_CHAR(A.ACREAGE) AREA "); SSql = string.Format(SSql, ",TO_CHAR(SUM(A.ACREAGE)) AREA "); KSql = string.Format(KSql, ",TO_CHAR(SUM(A.ACREAGE)) AREA "); CSql = string.Format(CSql, ",TO_CHAR(SUM(A.ACREAGE)) AREA "); FSql = string.Format(FSql, ",TO_CHAR(SUM(A.ACREAGE)) AREA "); } else { Sql = string.Format(Sql, " "); SSql = string.Format(SSql, " "); KSql = string.Format(KSql, " "); CSql = string.Format(CSql, " "); FSql = string.Format(FSql, " "); } //zw 2008-04-07 string[] rtnSql = new string[] { Sql, SSql, KSql, CSql, FSql };//,FSql return rtnSql; } public override int minValue { get { return 20; } } public override int maxValue { get { return 120; } } } }