XinYu_ZHBMES/Client/.svn/pristine/02/02c8baf50c83481003ad22685af04ba99c601f8c.svn-base

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Text;
using System.Windows.Forms;
using Core.XgMes.Client.StorageBase;

namespace Core.XgMes.Client.JGKC.RollManager
{
    public partial class UCSendQueryJB : UserControl
    {
        public UCSendQueryJB()
        {
            InitializeComponent();
        }



        private string _WhereStr = "";
        public string WhereStr
        {
            get
            {
                _WhereStr = GetSteelCondition();
                _WhereStr = _WhereStr + GetPactNOCondition();
                _WhereStr = _WhereStr + GetSendDateCondition();
                _WhereStr = _WhereStr + GetBookInDateCondition();
                _WhereStr = _WhereStr + GetListCondingCondition();
                //_WhereStr = _WhereStr + GetIncpNameCondition();
                //_WhereStr = _WhereStr + GetStationNameCondition();
                _WhereStr = _WhereStr + GetRollNOCondition();
                _WhereStr = _WhereStr + GetPlyCondition();
                _WhereStr = _WhereStr + GetWidthCondition();
                _WhereStr = _WhereStr + GetLengthCondition();
                _WhereStr = _WhereStr + GetPlanNOCondition();
                _WhereStr = _WhereStr + GetVecihleNOCondition();
                _WhereStr = _WhereStr + GetClassTeamCondition();
                _WhereStr = _WhereStr + GetSendManCondition();
                _WhereStr = _WhereStr + GetSendType();
            
                _WhereStr = _WhereStr + GetCondole();
                _WhereStr = _WhereStr + GetBookInManCondition();
                _WhereStr = _WhereStr + GetGJH();
                //_WhereStr = _WhereStr + GetQuality();
                //_WhereStr = _WhereStr + GetPLCondition();
               // _WhereStr = _WhereStr + GetCutStateCondition();
                return _WhereStr;
            }
        }
        #region "Method"
     
        private string GetSteelCondition()
        {
            try
            {
                string rtnStr = "";
                if (this.Chk_SteelName.Checked && this.Cmb_SteelName.Text.Trim().Length > 0)
                {
                    rtnStr = " AND A.SPEC_STL_GRD LIKE '" + this.Cmb_SteelName.Text.Trim() + "%' ";
                }
                return rtnStr;
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                return "";
            }
        }
        //合同号B
        private string GetPactNOCondition()
        {
            try
            {
                string rtnStr = "";
                if (this.Chk_PactNO.Checked && this.txt_PactNO.Text.Trim().Length > 0)
                {
                    rtnStr = " AND B.ORD_NO LIKE '%" + this.txt_PactNO.Text.Trim() + "%' ";
                }
                return rtnStr;
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                return "";
            }
        }
        //发运日期A
        private string GetSendDateCondition()
        {
            try
            {
                string rtnStr = "";
                if (this.Chk_SendDate.Checked && this.Dte_SendBegin.Value != null)
                {
                    rtnStr = " AND TO_CHAR(A.PICKSTORAGETIME,'YY-MM-DD')>='" + Convert.ToDateTime(this.Dte_SendBegin.Value).ToString("yy-MM-dd") + "' "
                        + " AND TO_CHAR(A.PICKSTORAGETIME,'YY-MM-DD')<='" + Convert.ToDateTime(this.Dte_SendEnd.Value).ToString("yy-MM-dd") + "' ";
                }
                return rtnStr;
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                return "";
            }
        }
        //登记日期A
        private string GetBookInDateCondition()
        {
            try
            {
                string rtnStr = "";
                if (this.Chk_BookInDate.Checked && this.Dte_BookInBegin.Value != null)
                {
                    rtnStr = " AND TO_CHAR(A.CREATETIME,'YY-MM-DD')>='" + Convert.ToDateTime(this.Dte_BookInBegin.Value).ToString("yy-MM-dd") + "' "
                        + " AND TO_CHAR(A.CREATETIME,'YY-MM-DD')<='" + Convert.ToDateTime(this.Dte_BookInEnd.Value).ToString("yy-MM-dd") + "' ";
                }
                return rtnStr;
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                return "";
            }
        }
        //发运明细A
        private string GetListCondingCondition()
        {
            try
            {
                string rtnStr = "";
                if (this.Chk_ListCode.Checked && this.txt_ListCodingEnd.Text.Trim().Length > 0)
                {

                    rtnStr = " AND A.LISTNUMBER LIKE '%" + this.txt_ListCodingEnd.Text.Trim() + "%' ";
                }
               


                return rtnStr;
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                return "";
            }
        }
     
        ////收货单位C
        private string GetIncpNameCondition()
        {
            try
            {
                string rtnStr = "";
                if (this.Chk_IncpName.Checked && this.txt_IncpName.Text.Trim().Length > 0)
                {
                    rtnStr = " AND C.CUST_CD LIKE '%" + this.txt_IncpName.Text.Trim() + "%' ";
                }
                return rtnStr;
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                return "";
            }
        }
        ////到站D
        private string GetStationNameCondition()
        {
            try
            {
                string rtnStr = "";
                if (this.Chk_StationName.Checked && this.txt_StationName.Text.Trim().Length > 0)
                {
                    rtnStr = " AND D.SM_CD LIKE '%" + this.txt_StationName.Text.Trim() + "%' ";
                }
                return rtnStr;
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                return "";
            }
        }
        //钢卷包号
        private string GetRollNOCondition()
        {
            try
            {
                string rtnStr = "";
                if (this.chk_RollNum.Checked && this.txt_BH.Text.Trim().Length > 0)
                {
                    rtnStr = " AND A.COIL_NO_ID LIKE '%" + this.txt_BH.Text.Trim() + "%' ";
                }
                return rtnStr;
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                return "";
            }
        }
        //厚度
        private string GetPlyCondition()
        {
            try
            {
                if (this.chk_Ply.Checked)
                {
                    string rtnStr = "";
                    if (StorageBaseClass.CheckDecimal(this.txt_PlyBegin.Value) > 0 && StorageBaseClass.CheckDecimal(this.txt_PlyEnd.Value) == 0)
                    {
                        rtnStr = " AND A.ZSLAB_PLY=" + StorageBaseClass.CheckNullStr(this.txt_PlyBegin.Value);
                        return rtnStr;
                    }
                    if (StorageBaseClass.CheckDecimal(this.txt_PlyBegin.Value) == 0 && StorageBaseClass.CheckDecimal(this.txt_PlyEnd.Value) > 0)
                    {
                        rtnStr = " AND A.ZSLAB_PLY<=" + StorageBaseClass.CheckNullStr(this.txt_PlyEnd.Value);
                        return rtnStr;
                    }
                    if (StorageBaseClass.CheckDecimal(this.txt_PlyBegin.Value) > 0 && StorageBaseClass.CheckDecimal(this.txt_PlyEnd.Value) > 0)
                    {
                        rtnStr = " AND A.ZSLAB_PLY>=" + StorageBaseClass.CheckNullStr(this.txt_PlyBegin.Value)
                            + " AND A.ZSLAB_PLY<=" + StorageBaseClass.CheckNullStr(this.txt_PlyEnd.Value);
                        return rtnStr;
                    }
                }
                return "";
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                return "";
            }
        }
        //宽度
        private string GetWidthCondition()
        {
            try
            {
                if (this.chk_Width.Checked)
                {
                    string rtnStr = "";
                    if (StorageBaseClass.CheckDecimal(this.txt_WidthBegin.Value) > 0 && StorageBaseClass.CheckDecimal(this.txt_WidthEnd.Value) == 0)
                    {
                        rtnStr = " AND A.ZSLAB_WIDTH=" + StorageBaseClass.CheckNullStr(this.txt_WidthBegin.Value);
                        return rtnStr;
                    }
                    if (StorageBaseClass.CheckDecimal(this.txt_WidthBegin.Value) == 0 && StorageBaseClass.CheckDecimal(this.txt_WidthEnd.Value) > 0)
                    {
                        rtnStr = " AND A.ZSLAB_WIDTH<=" + StorageBaseClass.CheckNullStr(this.txt_WidthEnd.Value);
                        return rtnStr;
                    }
                    if (StorageBaseClass.CheckDecimal(this.txt_WidthBegin.Value) > 0 && StorageBaseClass.CheckDecimal(this.txt_WidthEnd.Value) > 0)
                    {
                        rtnStr = " AND A.ZSLAB_WIDTH>=" + StorageBaseClass.CheckNullStr(this.txt_WidthBegin.Value)
                            + " AND A.ZSLAB_WIDTH<=" + StorageBaseClass.CheckNullStr(this.txt_WidthEnd.Value);
                        return rtnStr;
                    }
                }
                return "";
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                return "";
            }
        }
        //长度
        private string GetLengthCondition()
        {
            try
            {
                if (this.chk_Length.Checked)
                {
                    string rtnStr = "";
                    if (StorageBaseClass.CheckDecimal(this.txt_LenghtBegin.Value) > 0 && StorageBaseClass.CheckDecimal(this.txt_LengthEnd.Value) == 0)
                    {
                        rtnStr = " AND A.ZSLAB_LENGTH=" + StorageBaseClass.CheckNullStr(this.txt_LenghtBegin.Value);
                        return rtnStr;
                    }
                    if (StorageBaseClass.CheckDecimal(this.txt_LenghtBegin.Value) == 0 && StorageBaseClass.CheckDecimal(this.txt_LengthEnd.Value) > 0)
                    {
                        rtnStr = " AND A.ZSLAB_LENGTH<=" + StorageBaseClass.CheckNullStr(this.txt_LengthEnd.Value);
                        return rtnStr;
                    }
                    if (StorageBaseClass.CheckDecimal(this.txt_LenghtBegin.Value) > 0 && StorageBaseClass.CheckDecimal(this.txt_LengthEnd.Value) > 0)
                    {
                        rtnStr = " AND A.ZSLAB_LENGTH>=" + StorageBaseClass.CheckNullStr(this.txt_LenghtBegin.Value)
                            + " AND A.ZSLAB_LENGTH<=" + StorageBaseClass.CheckNullStr(this.txt_LengthEnd.Value);
                        return rtnStr;
                    }
                }
                return "";
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                return "";
            }
        }
        //批号
        private string GetPlanNOCondition()
        {
            try
            {
                string rtnStr = "";
                if (this.Chk_Condole.Checked && this.Txt_Condole.Text.Trim().Length > 0)
                {
                    rtnStr = " AND A.SLAB_NO LIKE '%" + this.Txt_Condole.Text.Trim() + "%' ";
                }
                return rtnStr;
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                return "";
            }
        }
        //车牌号
        private string GetVecihleNOCondition()
        {
            try
            {
                string rtnStr = "";
                if (this.Chk_VecihleNO.Checked && this.txt_VecihleNO.Text.Trim().Length > 0)
                {
                    rtnStr = " AND A.TRAINWAGON LIKE '%" + this.txt_VecihleNO.Text.Trim() + "%' ";
                }
                return rtnStr;
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                return "";
            }
        }
        //班组
        private string GetClassTeamCondition()
        {
            try
            {
                string rtnStr = "";
                if (this.Chk_ClassTeam.Checked && StorageBaseClass.CheckNullStr(this.Cmb_ClassTeam.Value).Length > 0)
                {
                    rtnStr = " AND A.CLASSTEAM='" + StorageBaseClass.CheckNullStr(this.Cmb_ClassTeam.Value) + "' ";
                }
                return rtnStr;
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                return "";
            }
        }
        //发运人
        private string GetSendManCondition()
        {
            try
            {
                string rtnStr = "";
                if (this.Chk_SendMan.Checked && this.txt_SendMan.Text.Trim().Length > 0)
                {
                    rtnStr = " AND A.PICKSTORAGEMAN='" + this.txt_SendMan.Text.Trim() + "' ";
                }
                return rtnStr;
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                return "";
            }
        }
        //发运明细的登记人
        private string GetBookInManCondition()
        {
            try
            {
                string rtnStr = "";
                if (this.Chk_BookInMan.Checked && this.txt_BookInMan.Text.Trim().Length > 0)
                {
                    rtnStr = " AND A.CREATOR='" + this.txt_BookInMan.Text.Trim() + "' ";
                }
                return rtnStr;
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                return "";
            }
        }
        //钢卷号
        private string GetGJH()
        {
            try
            {
                string rtnStr = "";
                if (this.ultChk_SampleNo.Checked && this.txt_SampleNo.Text.Trim().Length > 0)
                {
                    rtnStr = " AND A.OLD_SAMPL_NO LIKE '" + this.txt_SampleNo.Text.Trim() + "%' ";
                }
                
                return rtnStr;
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                return "";
            }
        }
        //获得发运类型的条件
        private string GetSendType()
        {
            try
            {
                string rtnStr = "";
                if (this.Chk_SendType.Checked && StorageBaseClass.CheckNullStr(this.Cmb_SendType.Value).Length > 0)
                {
                    rtnStr = " AND A.SENDTYPE='" + StorageBaseClass.CheckNullStr(this.Cmb_SendType.Value) + "' ";
                }
                return rtnStr;
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                return "";
            }
        }
        //发运号码
        private string GetCondole()
        {
            try
            {
                string rtnStr = "";
                if (this.chk_SendNo.Checked && this.txt_SendNo.Text.Length > 0)
                {
                    rtnStr = " AND A.PLANVEHICLEID LIKE '%" + this.txt_SendNo.Text + "%' ";
                }
                return rtnStr;
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                return "";
            }
        }

        private void UCSendQueryJB_Load(object sender, EventArgs e)
        {
            this.Cmb_SendType.Value = "0";
        }
        //获得是正品还是次品的条件
        //private string GetQuality()
        //{
        //    try
        //    {
        //        if ((this.Chk_IsGood.Checked && this.Chk_IsWaster.Checked) | (!this.Chk_IsGood.Checked && !this.Chk_IsWaster.Checked))
        //            return "";
        //        if (this.Chk_IsWaster.Checked)
        //            return " AND (A.CLIPTYPEPROCESS LIKE '10301%' OR A.DETERMINANTRESULT LIKE '401403%' OR A.DETERMINANTRESULT LIKE '401404%') ";
        //        if (this.Chk_IsGood.Checked)
        //            return " AND (A.CLIPTYPEPROCESS NOT LIKE '10301%'  AND A.DETERMINANTRESULT  LIKE '401401%') ";
        //        return "";
        //    }
        //    catch (System.Exception ex)
        //    {
        //        System.Diagnostics.Debug.WriteLine(ex.ToString());
        //        return "";
        //    }
        //}
        #endregion
    }
}