MES_Client/TGMES/Core.StlMes.Client.Sale.BLL.SaleBusinessMgt/StaticData/PublicStaticVariable.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using TbColumn = Core.StlMes.Client.Sale.Common.TbColumnDefine.TbColumnDefine;


namespace Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.StaticData
{
   public  class PublicStaticVariable
    {
       private  BaseData.SlmBaseCustomberBll _custBase = null;
       private BaseData.SlmBaseRegionBll _region = null;
       private Order.SlmOrderBll _order = null;
       private Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.BaseData.SlmBaseStation _slmBaseStation
               = null;
       private BaseData.SlmBaseSpclLn _slmBaseSpclLn = null;
       private BaseData.ComBaseInfoBll _comBaseInfo = null;
        public PublicStaticVariable(CoreFS.CA06.OpeBase ob)
        {
            _custBase = new Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.BaseData.SlmBaseCustomberBll(ob);
            _region = new Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.BaseData.SlmBaseRegionBll(ob);
            _order = new Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Order.SlmOrderBll(ob);
            _slmBaseStation
              = new Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.BaseData.SlmBaseStation(ob);
            _slmBaseSpclLn = new Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.BaseData.SlmBaseSpclLn(ob);
            _comBaseInfo = new Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.BaseData.ComBaseInfoBll(ob);

        }
       /// <summary>
       /// 获取客户名称和编码
       /// </summary>
       /// <param name="IsRefreshEveryTime"></param>
       /// <returns></returns>
        public  StaticDBStruct Static_CustomberName(bool IsRefreshEveryTime)
        {
            if (!IsRefreshEveryTime && _StacusCustomerName != null) return _StacusCustomerName;
            
            if (_StacusCustomerName == null)
                _StacusCustomerName = new StaticDBStruct();
            DataSet dsCust = _custBase.GetSlmBaseCustomberAll();
            if (dsCust == null || dsCust.Tables.Count == 0)
                return _StacusCustomerName;

            _StacusCustomerName.Clear();
            foreach (DataRow dr in dsCust.Tables[0].Rows)
            {
                try
                {
                    _StacusCustomerName.GetValueListDB.ValueListItems.Add(dr[TbColumn.SLM_BASE_CUSTOMER.CUSTOMER_NO].ToString()
                        , dr[TbColumn.SLM_BASE_CUSTOMER.CUSTOMER_NM].ToString());
                    _StacusCustomerName.GetDataTableDB.Rows.Add(new object[] { dr[TbColumn.SLM_BASE_CUSTOMER.CUSTOMER_NO].ToString() ,
                    dr[TbColumn.SLM_BASE_CUSTOMER.CUSTOMER_NM].ToString() });
                }
                catch { }
            }
            return _StacusCustomerName;
        }
        private  StaticDBStruct _StacusCustomerName = null;


       /// <summary>
        /// 行政区域等级
       /// </summary>
       /// <param name="IsRefreshEveryTime"></param>
       /// <returns></returns>
        public StaticDBStruct Static_Region_lvl_no(bool IsRefreshEveryTime)
        {
            if (!IsRefreshEveryTime && _StacusRegion_lvl_no != null) return _StacusRegion_lvl_no;

            if (_StacusRegion_lvl_no == null)
                _StacusRegion_lvl_no = new StaticDBStruct();
            DataSet region = _region.GetDistinctRegionTpe();
            if (region == null || region.Tables.Count == 0)
                return _StacusRegion_lvl_no;

            _StacusRegion_lvl_no.Clear();
            foreach (DataRow dr in region.Tables[0].Rows)
            {
                try
                {
                    _StacusRegion_lvl_no.GetValueListDB.ValueListItems.Add(dr["REGION_LVL_NO"].ToString()
                        , dr["REGION_LVL_NM"].ToString());
                    _StacusRegion_lvl_no.GetDataTableDB.Rows.Add(new object[] { dr["REGION_LVL_NO"].ToString() ,
                    dr["REGION_LVL_NM"].ToString(),"","","" });
                }
                catch { }
            }
            return _StacusRegion_lvl_no;
        }
        private StaticDBStruct _StacusRegion_lvl_no = null;

       /// <summary>
        /// 获取行政区域属性信息
       /// </summary>
       /// <param name="IsRefreshEveryTime"></param>
       /// <returns></returns>
        public StaticDBStruct Static_Region_Type(bool IsRefreshEveryTime)
        {
            if (!IsRefreshEveryTime && _StacusRegion_Type != null) return _StacusRegion_Type;

            if (_StacusRegion_Type == null)
                _StacusRegion_Type = new StaticDBStruct();
            DataSet region = _region.GetDistinctRegionType();
            if (region == null || region.Tables.Count == 0)
                return _StacusRegion_Type;

            _StacusRegion_Type.Clear();
            foreach (DataRow dr in region.Tables[0].Rows)
            {
                try
                {
                    _StacusRegion_Type.GetValueListDB.ValueListItems.Add(dr["REGION_TYPE_NO"].ToString()
                        , dr["REGION_TYPE_NM"].ToString());
                    _StacusRegion_Type.GetDataTableDB.Rows.Add(new object[] { dr["REGION_TYPE_NO"].ToString() ,
                    dr["REGION_TYPE_NM"].ToString(),dr["REGION_LVL_NO"].ToString() ,"","" });
                }
                catch { }
            }
            return _StacusRegion_Type;
        }
        private StaticDBStruct _StacusRegion_Type = null;

       /// <summary>
       /// 区域
       /// </summary>
       /// <param name="IsRefreshEveryTime"></param>
       /// <returns></returns>
        public StaticDBStruct Static_Region_Name(bool IsRefreshEveryTime)
        {
            if (!IsRefreshEveryTime && _StacusRegion_Name != null) return _StacusRegion_Name;

            if (_StacusRegion_Name == null)
                _StacusRegion_Name = new StaticDBStruct();
            DataSet region = _region.GetValidSlmBaseRegion();
            if (region == null || region.Tables.Count == 0)
                return _StacusRegion_Name;

            _StacusRegion_Name.Clear();
            foreach (DataRow dr in region.Tables[0].Rows)
            {
                try
                {
                    _StacusRegion_Name.GetValueListDB.ValueListItems.Add(dr["REGION_NO"].ToString()
                        , dr["REGION_NM"].ToString());
                    _StacusRegion_Name.GetDataTableDB.Rows.Add(new object[] { dr["REGION_NO"].ToString() ,
                    dr["REGION_NM"].ToString(),dr["P_REGION_NO"].ToString() ,"","" });
                }
                catch { }
            }
            return _StacusRegion_Name;
        }
        private StaticDBStruct _StacusRegion_Name = null;

       /// <summary>
       /// 0和1 的转换
       /// </summary>
       /// <param name="IsRefreshEveryTime"></param>
       /// <returns></returns>
        public StaticDBStruct Static_ZeroAndOne(bool IsRefreshEveryTime)
        {
            if (!IsRefreshEveryTime && _StacusZeroAndOne != null) return _StacusZeroAndOne;

            if (_StacusZeroAndOne == null)
                _StacusZeroAndOne = new StaticDBStruct();
            DataSet region = _region.GetValidSlmBaseRegion();
            if (region == null || region.Tables.Count == 0)
                return _StacusZeroAndOne;

            _StacusZeroAndOne.Clear();
            foreach (DataRow dr in region.Tables[0].Rows)
            {
                try
                {
                    _StacusZeroAndOne.GetValueListDB.ValueListItems.Add("0", "否");
                    _StacusZeroAndOne.GetValueListDB.ValueListItems.Add("1", "是");
                    _StacusZeroAndOne.GetDataTableDB.Rows.Add(new object[] { "0", "否", "", "","" });
                    _StacusZeroAndOne.GetDataTableDB.Rows.Add(new object[] { "1", "是", "", "", "" });
                }
                catch { }
            }
            return _StacusZeroAndOne;
        }
        private StaticDBStruct _StacusZeroAndOne = null;

        /// <summary>
        /// 0和1 的转换
        /// </summary>
        /// <param name="IsRefreshEveryTime"></param>
        /// <returns></returns>
        public StaticDBStruct Order_ZeroAndOne(bool IsRefreshEveryTime)
        {
            if (!IsRefreshEveryTime && _OrderFlZeroAndOne != null) return _OrderFlZeroAndOne;

            if (_OrderFlZeroAndOne == null)
                _OrderFlZeroAndOne = new StaticDBStruct();
            DataSet order = _order.GetSlmOrderHeadAll();
            if (order == null || order.Tables.Count == 0)
                return _OrderFlZeroAndOne;

            _OrderFlZeroAndOne.Clear();
            foreach (DataRow dr in order.Tables[0].Rows)
            {
                try
                {
                    _OrderFlZeroAndOne.GetValueListDB.ValueListItems.Add("0", "不锁价");
                    _OrderFlZeroAndOne.GetValueListDB.ValueListItems.Add("1", "锁价");
                    _OrderFlZeroAndOne.GetDataTableDB.Rows.Add(new object[] { "0", "不锁价", "", "", "" });
                    _OrderFlZeroAndOne.GetDataTableDB.Rows.Add(new object[] { "1", "锁价", "", "", "" });
                }
                catch { }
            }
            return _OrderFlZeroAndOne;
        }
        private StaticDBStruct _OrderFlZeroAndOne = null;

        /// <summary>
        /// 0和1与-1 的转换
        /// </summary>
        /// <param name="IsRefreshEveryTime"></param>
        /// <returns></returns>
        public StaticDBStruct Declare_ZeroAndOne(bool IsRefreshEveryTime)
        {
            if (!IsRefreshEveryTime && _DeclareFlZeroAndOne != null) return _DeclareFlZeroAndOne;

            if (_DeclareFlZeroAndOne == null)
                _DeclareFlZeroAndOne = new StaticDBStruct();
            DataSet order = _order.GetSlmOrderLineAll();
            if (order == null || order.Tables.Count == 0)
                return _DeclareFlZeroAndOne;

            _DeclareFlZeroAndOne.Clear();
            foreach (DataRow dr in order.Tables[0].Rows)
            {
                try
                {
                    _DeclareFlZeroAndOne.GetValueListDB.ValueListItems.Add("0", "录入");
                    _DeclareFlZeroAndOne.GetValueListDB.ValueListItems.Add("1", "待评审");
                    _DeclareFlZeroAndOne.GetValueListDB.ValueListItems.Add("2", "已申报");
                    _DeclareFlZeroAndOne.GetValueListDB.ValueListItems.Add("3", "评审通过");
                    _DeclareFlZeroAndOne.GetValueListDB.ValueListItems.Add("-3", "评审未通过");
                    _DeclareFlZeroAndOne.GetValueListDB.ValueListItems.Add("5", "评审通过");
                    _DeclareFlZeroAndOne.GetValueListDB.ValueListItems.Add("-5", "评审未通过");
                    _DeclareFlZeroAndOne.GetValueListDB.ValueListItems.Add("6", "订单生效");
                    _DeclareFlZeroAndOne.GetValueListDB.ValueListItems.Add("7", "资源计划下发");
                    _DeclareFlZeroAndOne.GetValueListDB.ValueListItems.Add("8", "订单发运关闭");
                    _DeclareFlZeroAndOne.GetDataTableDB.Rows.Add(new object[] { "0", "录入", "", "", "" });
                    _DeclareFlZeroAndOne.GetDataTableDB.Rows.Add(new object[] { "1", "待评审", "", "", "" });
                    _DeclareFlZeroAndOne.GetDataTableDB.Rows.Add(new object[] { "2", "已申报", "", "", "" });
                    _DeclareFlZeroAndOne.GetDataTableDB.Rows.Add(new object[] { "3", "评审通过", "", "", "" });
                    _DeclareFlZeroAndOne.GetDataTableDB.Rows.Add(new object[] { "-3", "评审未通过", "", "", "" });
                    _DeclareFlZeroAndOne.GetDataTableDB.Rows.Add(new object[] { "5", "评审通过", "", "", "" });
                    _DeclareFlZeroAndOne.GetDataTableDB.Rows.Add(new object[] { "-5", "评审未通过", "", "", "" });
                    _DeclareFlZeroAndOne.GetDataTableDB.Rows.Add(new object[] { "6", "订单生效", "", "", "" });
                    _DeclareFlZeroAndOne.GetDataTableDB.Rows.Add(new object[] { "7", "资源计划下发", "", "", "" });
                    _DeclareFlZeroAndOne.GetDataTableDB.Rows.Add(new object[] { "8", "订单发运关闭", "", "", "" });
                }
                catch { }
            }
            return _DeclareFlZeroAndOne;
        }
        private StaticDBStruct _DeclareFlZeroAndOne = null;

        /// <summary>
        /// 0和1 的转换
        /// </summary>
        /// <param name="IsRefreshEveryTime"></param>
        /// <returns></returns>
        public StaticDBStruct CustFreight_ZeroAndOne(bool IsRefreshEveryTime)
        {
            if (!IsRefreshEveryTime && _CustFreightZeroAndOne != null) return _CustFreightZeroAndOne;

            if (_CustFreightZeroAndOne == null)
                _CustFreightZeroAndOne = new StaticDBStruct();
            DataSet cust = _custBase.GetSlmBaseCustmFreightAll();
            if (cust == null || cust.Tables.Count == 0)
                return _CustFreightZeroAndOne;

            _CustFreightZeroAndOne.Clear();
            foreach (DataRow dr in cust.Tables[0].Rows)
            {
                try
                {
                    _CustFreightZeroAndOne.GetValueListDB.ValueListItems.Add("0", "非自提");
                    _CustFreightZeroAndOne.GetValueListDB.ValueListItems.Add("1", "自提");
                    _CustFreightZeroAndOne.GetDataTableDB.Rows.Add(new object[] { "0", "非自提", "", "", "" });
                    _CustFreightZeroAndOne.GetDataTableDB.Rows.Add(new object[] { "1", "自提", "", "", "" });
                }
                catch { }
            }
            return _CustFreightZeroAndOne;
        }
        private StaticDBStruct _CustFreightZeroAndOne = null;

       /// <summary>
       /// 到站
       /// </summary>
       /// <param name="IsRefreshEveryTime"></param>
       /// <returns></returns>
        public StaticDBStruct Static_StationNoAndName_Tg(bool IsRefreshEveryTime)
        {
            if (!IsRefreshEveryTime && _StationTg != null) return _StationTg;

           

            if (_StationTg == null)
                _StationTg = new StaticDBStruct();
            DataSet station = this._slmBaseStation.GetSlmBaseStationAll();
            if (station == null || station.Tables.Count == 0)
                return _StationTg;
          

            _StationTg.Clear();
            foreach (DataRow dr in station.Tables[0].Rows)
            {
                try
                {
                    _StationTg.GetValueListDB.ValueListItems.Add(dr["STATION_NO"].ToString()
                       , dr["STATION_NM"].ToString());
                    _StationTg.GetDataTableDB.Rows.Add(new object[] { dr["STATION_NO"].ToString() ,
                    dr["STATION_NM"].ToString() });
                   
                }
                catch { }
            }
            return _StationTg;
        }
        private StaticDBStruct _StationTg = null;

        public StaticDBStruct Static_SpecLine_Tg(bool IsRefreshEveryTime)
        {
            if (!IsRefreshEveryTime && _SpclLn != null) return _SpclLn;
            if (_SpclLn == null)
                _SpclLn = new StaticDBStruct();
            DataSet station = this._slmBaseSpclLn.GetSlmBaseSpclLnAll();
            if (station == null || station.Tables.Count == 0)
                return _SpclLn;

            _SpclLn.Clear();
            foreach (DataRow dr in station.Tables[0].Rows)
            {
                try
                {
                    _SpclLn.GetValueListDB.ValueListItems.Add(dr["SPCL_LN_NO"].ToString()
                       , dr["SPCL_LN_NM"].ToString());
                    _SpclLn.GetDataTableDB.Rows.Add(new object[] { dr["SPCL_LN_NO"].ToString() ,
                    dr["SPCL_LN_NM"].ToString() });

                }
                catch { }
            }
            return _SpclLn;
        }
        private StaticDBStruct _SpclLn = null;

        public StaticDBStruct Static_TransType_Tg(bool IsRefreshEveryTime)
        {
            if (!IsRefreshEveryTime && _TransType_Tg != null) return _TransType_Tg;
            if (_TransType_Tg == null)
                _TransType_Tg = new StaticDBStruct();
            DataSet station = _comBaseInfo.GetComBaseInfoBySortCode("1105");
            if (station == null || station.Tables.Count == 0)
                return _TransType_Tg;

            _TransType_Tg.Clear();

            station.Tables[0].Columns[_BASECODE].ColumnName = "TRANS_TYPE";
            foreach (DataRow dr in station.Tables[0].Rows)
            {
                try
                {
                    _TransType_Tg.GetValueListDB.ValueListItems.Add(dr["TRANS_TYPE"].ToString()
                       , dr[_BASENAME].ToString());
                    _TransType_Tg.GetDataTableDB.Rows.Add(new object[] { dr["TRANS_TYPE"].ToString() ,
                    dr[_BASENAME].ToString() });

                }
                catch { }
            }
            return _TransType_Tg;
        }
        private string _BASECODE = "BASECODE";
        private string _BASENAME = "BASENAME";
        private StaticDBStruct _TransType_Tg = null;
    }
}