XinYu_ZHBMES/Client/Core.XgMes.Client.JGKC.RollManager/报表/UCSendStatJB.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Text;
using System.Windows.Forms;

namespace Core.XgMes.Client.JGKC.RollManager
{
    public partial class UCSendStatJB : UserControl
    {
        public UCSendStatJB()
        {
            InitializeComponent();
        }
        #region "Property
        private string _SelectStr = "SELECT ZSLAB_WEIGHT WEIGHT  ,XJJL_WEIGHT ";//A.STEELTYPE
        private string _FromStr = " FROM KCJ3_TURNOFFSENDLIST_ZW A,TBA01_ORD_LINE B,tbz00_customer  C,tbz00_commcd D ,TBA01_ORD_COMM E "
                                 + " WHERE A.ISVALID<>'0'  AND A.ORD_NO  = E.ORD_NO  "
                                 + " AND E.CUST_CD = C.CUST_CD(+) AND B.DEST_PCD = D.SM_CD(+)   AND A.ORD_NO || A.ORD_SEQ=B.ORD_NO || B.ORD_SEQ  ";

        private string _GroupbyStr = " GROUP BY a.ZSLAB_WEIGHT,XJJL_WEIGHT";
        public System.Collections.ArrayList SendSelectStr
        {
            get
            {
                System.Collections.ArrayList rtnList = new System.Collections.ArrayList();
                string rtnStr = _SelectStr;


                if (this.chk_StatInceName.Checked)
                {
                    if (rtnStr.Length > 7)
                    {
                        rtnStr = rtnStr + ",C.CUST_NM INCEPTCORPNAME";
                    }
                    else
                    {
                        rtnStr = rtnStr + "C.CUST_NM INCEPTCORPNAME";
                    }
                }
                if (this.Chk_StatListCoding.Checked)
                {
                    if (rtnStr.Length > 7)
                    {
                        rtnStr = rtnStr + ",A.LISTNUMBER";
                    }
                    else
                    {
                        rtnStr = rtnStr + "A.LISTNUMBER";
                    }
                }
                if (this.chk_zl.Checked)
                {
                    if (rtnStr.Length > 7)
                    {
                        rtnStr = rtnStr + ",A.CAL_WGT";
                    }
                    else
                    {
                        rtnStr = rtnStr + "A.CAL_WGT";
                    }
                }
                if (this.Chk_StatVecihleNO.Checked)
                {
                    if (rtnStr.Length > 7)
                    {
                        rtnStr = rtnStr + ",A.TRANS_CAR_NO TRAINWAGON";
                    }
                    else
                    {
                        rtnStr = rtnStr + "A.TRANS_CAR_NO TRAINWAGON";
                    }
                }
             
                
             
                if (this.chk_StatStation.Checked)
                {
                    if (rtnStr.Length > 7)
                    {
                        rtnStr = rtnStr + ",D.SM_CFNM STATIONNAME";
                    }
                    else
                    {
                        rtnStr = rtnStr + "D.SM_CFNM STATIONNAME";
                    }
                }
                if (this.Chk_StatPactNO.Checked)
                {
                    if (rtnStr.Length > 7)
                    {
                        rtnStr = rtnStr + ",B.ORD_NO PACTNO";
                    }
                    else
                    {
                        rtnStr = rtnStr + "B.ORD_NO PACTNO";
                    }
                }
                if (this.chk_StatOrder.Checked)
                {
                    if (rtnStr.Length > 7)
                    {
                        rtnStr = rtnStr + ",A.ORD_NO || A.ORD_SEQ ORDERFORMNUMBER";
                    }
                    else
                    {
                        rtnStr = rtnStr + "A.ORD_NO || A.ORD_SEQ ORDERFORMNUMBER";
                    }
                }
                //钢卷号
                if (this.Chk_StatPlanNO.Checked)
                {
                    if (rtnStr.Length > 7)
                    {
                        rtnStr = rtnStr + ",A.OLD_SAMPL_NO";
                    }
                    else
                    {
                        rtnStr = rtnStr + "A.OLD_SAMPL_NO";
                    }
                }
                if (this.Chk_StatSteel.Checked)
                {
                    if (rtnStr.Length > 7)
                    {
                        rtnStr = rtnStr + ",A.STL_GRD STEELTYPE";
                    }
                    else
                    {
                        rtnStr = rtnStr + "A.STL_GRD STEELTYPE";
                    }
                }
                //钢卷包号
                if (this.Chk_StatRollNO.Checked)
                {
                    if (rtnStr.Length > 7)
                    {
                        rtnStr = rtnStr + ",A.COIL_NO_ID";
                    }
                    else
                    {
                        rtnStr = rtnStr + "A.COIL_NO_ID";
                    }
                }
                if (this.Chk_StatClassTeam.Checked)
                {
                    if (rtnStr.Length > 7)
                    {
                        rtnStr = rtnStr + ",(SELECT NAME_ FROM SCM_BASE_INFO WHERE ID_=A.CLASSTEAM) CLASSTEAM";
                    }
                    else
                    {
                        rtnStr = rtnStr + "(SELECT NAME_ FROM SCM_BASE_INFO WHERE ID_=A.CLASSTEAM) CLASSTEAM";
                    }
                }
                //if (this.Chk_StatDeteMar.Checked)
                //{
                //    if (rtnStr.Length > 7)
                //    {
                //        rtnStr = rtnStr + ",(SELECT NAME_ FROM SCM_BASE_INFO WHERE ID_=B.ISCHECKSCAR) ISCHECKSCAR,DECODE(B.ISHEAT,'1','√',NULL) ISHEAT";
                //    }
                //    else
                //    {
                //        rtnStr = rtnStr + "(SELECT NAME_ FROM SCM_BASE_INFO WHERE ID_=B.ISCHECKSCAR) ISCHECKSCAR,DECODE(B.ISHEAT,'1','√',NULL) ISHEAT";
                //    }
                //}
                //if (this.Chk_StatRole.Checked)
                //{
                //    if (rtnStr.Length > 7)
                //    {
                //        rtnStr = rtnStr + ",(SELECT NAME_ FROM SCM_BASE_INFO WHERE ID_=A.ROLE) ROLE";
                //    }
                //    else
                //    {
                //        rtnStr = rtnStr + "(SELECT NAME_ FROM SCM_BASE_INFO WHERE ID_=A.ROLE) ROLE";
                //    }
                //}
                //if (this.Chk_StatCondole.Checked)
                //{
                //    if (rtnStr.Length > 7)
                //    {
                //        rtnStr = rtnStr + ",A.CONDOLENUMBER";
                //    }
                //    else
                //    {
                //        rtnStr = rtnStr + "A.CONDOLENUMBER";
                //    }
                //}
                //if (this.Chk_StatResult.Checked)
                //{
                //    if (rtnStr.Length > 7)
                //    {
                //        rtnStr = rtnStr + ",(SELECT NAME_ FROM SCM_BASE_INFO WHERE ID_=A.DETERMINANTRESULT) DETERMINANTRESULT";
                //    }
                //    else
                //    {
                //        rtnStr = rtnStr + "(SELECT NAME_ FROM SCM_BASE_INFO WHERE ID_=A.DETERMINANTRESULT) DETERMINANTRESULT";
                //    }
                //}
                if (this.Chk_StatSendDate.Checked)
                {
                    if (rtnStr.Length > 7)
                    {
                        rtnStr = rtnStr + ",TO_CHAR(A.PICKSTORAGETIME,'YY-MM-DD') PICKSTORAGETIME";
                    }
                    else
                    {
                        rtnStr = rtnStr + "TO_CHAR(A.PICKSTORAGETIME,'YY-MM-DD') PICKSTORAGETIME";
                    }
                }
                if (this.Chk_StatBookInDate.Checked)
                {
                    if (rtnStr.Length > 7)
                    {
                        rtnStr = rtnStr + ",TO_CHAR(A.CREATETIME,'YY-MM-DD HH24:MI') CREATTIME";
                    }
                    else
                    {
                        rtnStr = rtnStr + "TO_CHAR(A.CREATETIME,'YY-MM-DD HH24:MI') CREATTIME";
                    }
                }
                if (this.Chk_StatBookInMan.Checked)
                {
                    if (rtnStr.Length > 7)
                    {
                        rtnStr = rtnStr + ",A.CREATOR";
                    }
                    else
                    {
                        rtnStr = rtnStr + "A.CREATOR";
                    }
                }
                if (this.Chk_StatSendMan.Checked)
                {
                    if (rtnStr.Length > 7)
                    {
                        rtnStr = rtnStr + ",A.PICKSTORAGEMAN";
                    }
                    else
                    {
                        rtnStr = rtnStr + "A.PICKSTORAGEMAN";
                    }
                }
               
                    rtnStr = rtnStr + _FromStr;
                    rtnList.Add(rtnStr);
                    return rtnList;
                
            //    if (this.Chk_StatBilletID.Checked)
            //    {
            //        if (rtnStr.Length > 7)
            //        {
            //            rtnStr = rtnStr + ",A.SERIALNUMBER,1 QUANTITY,A.WEIGHT,A.ADDWEIGHT,A.ACREAGE ";
            //        }
            //        else
            //        {
            //            rtnStr = rtnStr + "C.INCEPTCORPNAME,A.LISTNUMBER,A.STEELTYPE,TO_CHAR(A.PICKSTORAGETIME,'YY-MM-DD') PICKSTORAGETIME,A.SERIALNUMBER,1 QUANTITY,A.WEIGHT,A.ADDWEIGHT,A.ACREAGE ";
            //        }
            //        rtnStr = rtnStr + ",TO_CHAR(A.PLY)||'×'||TO_CHAR(A.WIDTH)||'×'||TO_CHAR(A.LENGTH) SPET";
            //        rtnStr = rtnStr + _FromStr;
            //        rtnList.Add(rtnStr);
            //        return rtnList;
            //    }
            //    else
            //    {
            //        if (rtnStr.Length > 7)
            //        {
            //            rtnStr = rtnStr + ",COUNT(A.SERIALNUMBER) QUANTITY,SUM(A.WEIGHT) WEIGHT,SUM(A.ADDWEIGHT) ADDWEIGHT,SUM(A.ACREAGE) ACREAGE ";
            //        }
            //        else
            //        {
            //            rtnStr = rtnStr + "C.INCEPTCORPNAME,A.LISTNUMBER,A.STEELTYPE,TO_CHAR(A.PICKSTORAGETIME,'YY-MM-DD') PICKSTORAGETIME,COUNT(A.SERIALNUMBER) QUANTITY,SUM(A.WEIGHT) WEIGHT,SUM(A.ADDWEIGHT) ADDWEIGHT,SUM(A.ACREAGE) ACREAGE ";
            //        }
            //    }
            //    if (this.Chk_StatRole.Checked)
            //    {
            //        string tmpstr = "";
            //        tmpstr = rtnStr + ",TO_CHAR(A.PLY)||'×'||TO_CHAR(A.LENGTH) SPET ";       //定长
            //        tmpstr = tmpstr + _FromStr + " AND A.ROLE='102201' ";
            //        rtnList.Add(tmpstr);
            //        tmpstr = rtnStr + ",TO_CHAR(A.PLY)||'×'||TO_CHAR(A.WIDTH) SPET ";      //定宽
            //        tmpstr = tmpstr + _FromStr + " AND (A.ROLE='102202' OR A.ROLE='102206') ";
            //        rtnList.Add(tmpstr);
            //        tmpstr = rtnStr + ",TO_CHAR(A.PLY)||'×'||TO_CHAR(A.WIDTH)||'×'||TO_CHAR(A.LENGTH) SPET ";      //双定
            //        tmpstr = tmpstr + _FromStr + " AND (A.ROLE='102203' OR A.ROLE IS NULL) ";
            //        rtnList.Add(tmpstr);
            //        tmpstr = rtnStr + ",TO_CHAR(A.PLY) SPET ";      //非定
            //        tmpstr = tmpstr + _FromStr + " AND (A.ROLE='102204' OR A.ROLE='102205') ";
            //        rtnList.Add(tmpstr);
            //        return rtnList;
            //    }
            //    else
            //    {
            //        if (this.Chk_StatSpet.Checked)
            //        {
            //            rtnStr = rtnStr + ",TO_CHAR(A.PLY) SPET ";
            //        }
            //        rtnStr = rtnStr + _FromStr;
            //        rtnList.Add(rtnStr);
            //        return rtnList;
            //    }
            }
        }
        public System.Collections.ArrayList SendGroupbyStr
        {
            get
            {
                System.Collections.ArrayList rtnList =new System.Collections.ArrayList();
                string rtnStr = _GroupbyStr;

               

                if (this.chk_StatInceName.Checked)
                {
                    if (rtnStr.Length > 10)
                    {
                        rtnStr = rtnStr + ",C.CUST_NM ";
                    }
                    else
                    {
                        rtnStr = rtnStr + "C.CUST_NM ";
                    }
                }
                if (this.Chk_StatListCoding.Checked)
                {
                    if (rtnStr.Length > 10)
                    {
                        rtnStr = rtnStr + ",A.LISTNUMBER";
                    }
                    else
                    {
                        rtnStr = rtnStr + "A.LISTNUMBER";
                    }
                }
             
                if (this.Chk_StatVecihleNO.Checked)
                {
                    if (rtnStr.Length > 10)
                    {
                        rtnStr = rtnStr + ",A.TRANS_CAR_NO";
                    }
                    else
                    {
                        rtnStr = rtnStr + "A.TRANS_CAR_NO";
                    }
                }
             
                if (this.chk_StatStation.Checked)
                {
                    if (rtnStr.Length > 10)
                    {
                        rtnStr = rtnStr + ",D.SM_CFNM ";
                    }
                    else
                    {
                        rtnStr = rtnStr + "D.SM_CFNM ";
                    }
                }
                if (this.chk_zl.Checked)
                {
                    if (rtnStr.Length > 7)
                    {
                        rtnStr = rtnStr + ",A.CAL_WGT";
                    }
                    else
                    {
                        rtnStr = rtnStr + "A.CAL_WGT";
                    }
                }
                if (this.Chk_StatPactNO.Checked)
                {
                    if (rtnStr.Length > 10)
                    {
                        rtnStr = rtnStr + ",B.ORD_NO  ";
                    }
                    else
                    {
                        rtnStr = rtnStr + "B.ORD_NO ";
                    }
                }
                if (this.chk_StatOrder.Checked)
                {
                    if (rtnStr.Length > 10)
                    {
                        rtnStr = rtnStr + ",A.ORD_NO || A.ORD_SEQ  ";
                    }
                    else
                    {
                        rtnStr = rtnStr + "A.ORD_NO || A.ORD_SEQ  ";
                    }
                }
                if (this.Chk_StatPlanNO.Checked)
                {
                    if (rtnStr.Length > 10)
                    {
                        rtnStr = rtnStr + ",A.OLD_SAMPL_NO";
                    }
                    else
                    {
                        rtnStr = rtnStr + "A.OLD_SAMPL_NO";
                    }
                }
                if (this.Chk_StatSteel.Checked)
                {
                    if (rtnStr.Length > 10)
                    {
                        rtnStr = rtnStr + ",A.STL_GRD ";
                    }
                    else
                    {
                        rtnStr = rtnStr + "A.STL_GRD ";
                    }
                }
                if (this.Chk_StatRollNO.Checked)
                {
                    if (rtnStr.Length > 10)
                    {
                        rtnStr = rtnStr + ",A.COIL_NO_ID";
                    }
                    else
                    {
                        rtnStr = rtnStr + "A.COIL_NO_ID";
                    }
                }
                if (this.Chk_StatClassTeam.Checked)
                {
                    if (rtnStr.Length > 10)
                    {
                        rtnStr = rtnStr + ",A.CLASSTEAM";
                    }
                    else
                    {
                        rtnStr = rtnStr + "A.CLASSTEAM";
                    }
                }
                //if (this.Chk_StatDeteMar.Checked)
                //{
                //    if (rtnStr.Length > 10)
                //    {
                //        rtnStr = rtnStr + ",B.ISCHECKSCAR,B.ISHEAT";
                //    }
                //    else
                //    {
                //        rtnStr = rtnStr + "B.ISCHECKSCAR,B.ISHEAT";
                //    }
                //}
                //if (this.Chk_StatRole.Checked)
                //{
                //    if (rtnStr.Length > 10)
                //    {
                //        rtnStr = rtnStr + ",A.ROLE";
                //    }
                //    else
                //    {
                //        rtnStr = rtnStr + "A.ROLE";
                //    }
                //}
                //if (this.Chk_StatCondole.Checked)
                //{
                //    if (rtnStr.Length > 10)
                //    {
                //        rtnStr = rtnStr + ",A.CONDOLENUMBER";
                //    }
                //    else
                //    {
                //        rtnStr = rtnStr + "A.CONDOLENUMBER";
                //    }
                //}
                //if (this.Chk_StatResult.Checked)
                //{
                //    if (rtnStr.Length > 10)
                //    {
                //        rtnStr = rtnStr + ",A.DETERMINANTRESULT";
                //    }
                //    else
                //    {
                //        rtnStr = rtnStr + "A.DETERMINANTRESULT";
                //    }
                //}
                if (this.Chk_StatSendDate.Checked)
                {
                    if (rtnStr.Length > 10)
                    {
                        rtnStr = rtnStr + ",TO_CHAR(A.PICKSTORAGETIME,'YY-MM-DD')";
                    }
                    else
                    {
                        rtnStr = rtnStr + "TO_CHAR(A.PICKSTORAGETIME,'YY-MM-DD')";
                    }
                }
                if (this.Chk_StatBookInDate.Checked)
                {
                    if (rtnStr.Length > 10)
                    {
                        rtnStr = rtnStr + ",TO_CHAR(A.CREATETIME,'YY-MM-DD HH24:MI')";
                    }
                    else
                    {
                        rtnStr = rtnStr + "TO_CHAR(A.CREATETIME,'YY-MM-DD HH24:MI')";
                    }
                }
                if (this.Chk_StatBookInMan.Checked)
                {
                    if (rtnStr.Length > 10)
                    {
                        rtnStr = rtnStr + ",A.CREATOR";
                    }
                    else
                    {
                        rtnStr = rtnStr + "A.CREATOR";
                    }
                }
                if (this.Chk_StatSendMan.Checked)
                {
                    if (rtnStr.Length > 10)
                    {
                        rtnStr = rtnStr + ",A.PICKSTORAGEMAN";
                    }
                    else
                    {
                        rtnStr = rtnStr + "A.PICKSTORAGEMAN";
                    }
                }
                    //rtnStr = rtnStr + _FromStr;
                    rtnList.Add(rtnStr);
                    return rtnList;
              
                //if (this.Chk_StatBilletID.Checked)
                //{
                //    rtnStr = "";
                //    rtnList.Add("");
                //    return rtnList;
                //}
                //else
                //{
                //    if (rtnStr.Length <= 10)
                //    {
                //        rtnStr = rtnStr + "C.INCEPTCORPNAME,A.LISTNUMBER,A.STEELTYPE,TO_CHAR(A.PICKSTORAGETIME,'YY-MM-DD')";
                //    }
                //}
                //if (this.Chk_StatRole.Checked)
                //{
                //    string tmpstr = "";
                //    tmpstr = rtnStr + ",A.PLY,A.LENGTH";
                //    rtnList.Add(tmpstr);
                //    tmpstr = rtnStr + ",A.PLY,A.WIDTH";
                //    rtnList.Add(tmpstr);
                //    tmpstr = rtnStr + ",A.PLY,A.WIDTH,A.LENGTH";
                //    rtnList.Add(tmpstr);
                //    tmpstr = rtnStr + ",A.PLY";
                //    rtnList.Add(tmpstr);
                //    return rtnList;
                //}
                //else
                //{
                //    if (this.Chk_StatSpet.Checked)
                //    {
                //        rtnStr = rtnStr + ",A.PLY";
                //    }
                //    rtnList.Add(rtnStr);
                //    return rtnList;
                //}
            }
        }
  
       
        #endregion
    }
}