XinYu_ZHBMES_BJNEWS/Server/.svn/pristine/48/481f0c215d3712c4836e6d488b2e701152726bda.svn-base

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
{
	/// <summary>
	/// SendListManager 的摘要说明。
	/// </summary>
	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;i<FaileInfo.Length;i++)
						{	
							rtnList.Add(FaileInfo[i].Value);
						}
					}
					if(rtnList.Count>0)
					{
						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;
			}
		}
	}
}