using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.SqlCollection
{
    public class BaseData
    {
        /// <summary>
        /// 查询客户基础信息
        /// </summary>
        public static string _QUERYSLMBASECUSTOMER = @"select  
                                                    customer_no,
                                                    customer_nm,
                                                    forecorpcode,
                                                    forecorpname,
                                                    region_nm,
                                                    sale_org,
                                                    bigarea,
                                                    region_no,
                                                    custm_lvl,
                                                    market_sys,
                                                    abrvition,
                                                    org,
                                                    py,
                                                    validflag,
                                                    create_name,
                                                    to_char(create_time,'{1}') create_time,
                                                    update_name,
                                                    to_char(update_time,'{1}') update_time,
                                                    delete_name,
                                                    to_char(delete_time,'{1}') delete_time  
                                                from  slm_base_customer  
                                                where 1 = 1 {0} ";

        /// <summary>
        /// 查询扩展信息SQL
        /// </summary>
        public static string _QUERYSLMBASECUSTMUNITIF = @"select
                                                            custm_ctgry,
                                                            cust_seq,
                                                            custm_prpty,
                                                            legal_psn,
                                                            agent,
                                                            address,
                                                            zip_code,
                                                            bank,
                                                            account,
                                                            tax_id,
                                                            phone,
                                                            salecard,
                                                            fax,
                                                            create_name,
                                                            to_char(create_time,'{1}') create_time
                                                            from slm_base_custm_unit where 1 = 1 {0} ";

        public static string _QUERYSLMBASECUSTFERINFO = @"select 
                                                            customer_no,
                                                            sale_org,
                                                            address,
                                                            region_no,
                                                            station_no,
                                                            spcl_ln_no,
                                                            trans_typ,
                                                            isownedcar,
                                                            isshipping,
                                                            incerptcode,
                                                            loaddock,
                                                            unloaddock,
                                                            ship_destination,
                                                            memo,
                                                            validflag,
                                                            create_name,
                                                            to_char(create_time,'{1}') create_time,
                                                            update_name,
                                                            to_char(update_time,'{1}') update_time,
                                                            delete_name,
                                                            to_char(delete_time,'{1}') delete_time,
                                                            forecorpcode,
                                                            freight_no,
                                                            station_nm
                                                        from slm_base_custm_freight
                                                        where 1 = 1 {0}";

        /// <summary>
        /// 查询子公司信息
        /// </summary>
        public  static string _QUERYSLMFORECORPINFO = @"select  
                                                    forecorpcode ,
                                                    forecorpname ,
                                                    principal ,
                                                    address ,
                                                    validflag ,
                                                    fore_tp ,
                                                    create_name,
                                                    to_char(create_time,'{1}') create_time,
                                                    update_name,
                                                    to_char(update_time,'{1}') update_time,
                                                    delete_name,
                                                    to_char(delete_time,'{1}') delete_time  
                                                from  slm_base_forecorpinfo  
                                                where 1 = 1 {0} ";

        /// <summary>
        /// 查询运输信息
        /// </summary>
        public  static string _QUERYSLMBASESTATION = @"select  
                                                        station_no,
                                                        station_nm, 
                                                        loaddock,
                                                        unloaddock,
                                                        transfee,
                                                        accept_person, 
                                                        telcode, 
                                                        percode, 
                                                        owned_city, 
                                                        remark
                                                     from  slm_base_station where 1 = 1 {0} ";

        /// <summary>
        /// 查询区域信息
        /// </summary>
        public static string _QUERYSLMBASEREGION = @"select 
                                                        region_no,
                                                        region_nm,
                                                        p_region_no,
                                                        region_type,
                                                        capital_fl,
                                                        pr_capital_fl,
                                                        region_seq,
                                                        fl,
                                                        reg_id,
                                                        reg_dtime,
                                                        mod_id,
                                                        mod_dtime
                                                     from slm_base_region where 1 = 1 {0}";

        /// <summary>
        /// 查询区域类型信息
        /// </summary>
        public static string _QUERYSLMBASEREGIONTYPE = @"select
                                                            region_lvl_no,
                                                            region_lvl_nm,
                                                            region_type_no,
                                                            region_type_nm,
                                                            fl,
                                                            reg_id,
                                                            reg_dtime,
                                                            mod_id,
                                                            mod_dtime
                                                      from slm_base_region_type where 1 = 1 {0}";

        /// <summary>
        /// 获取行政区域级别信息
        /// </summary>
        public static string _GETDISTINCTREGIONTPE = @"select 
                                                            distinct region_lvl_no, 
                                                            region_lvl_nm
                                                       from slm_base_region_tpe
                                                       order by region_lvl_no";

        /// <summary>
        /// 获取行政区域级别信息
        /// </summary>
        public static string _GETDISTINCTREGIONTYPE = @"select 
                                                            distinct region_lvl_no,
                                                            region_lvl_nm,
                                                            region_type_no,
                                                            region_type_nm
                                                       from slm_base_region_tpe
                                                       order by region_lvl_no";
    }
}