MTP2.0_CSharp/Muchinfo.MTPClient/Fx4.0/Main/05.Services/Muchinfo.TASClient.Data/Model/Delivery/TakaDeliveryGoodsQueryModel.cs

using Muchinfo.MTPClient.Data.Enums;
using Muchinfo.MTPClient.Data.Helper;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Muchinfo.MTPClient.Data.Model.Delivery
{
    /// <summary>
    /// 交割提货查询
    /// </summary>
   public class TakaDeliveryGoodsQueryModel
    {
        #region SQL字段
    //<select id="SearchTakaDeliveryGoodsQuery" parameterType="java.util.Map"
    //    resultType="HashMap">
    //    SELECT 
    //      os.StoreOutId,
    //      os.StoreOutCode,
    //      os.WareHouseId,
    //      os.remark,
       //os.RECEIVEPERSON,
       //   os.RECEIVEADDRESS,
       //   os.PHONENUM,
    //    os.RequestTime,
    //    os.AuditStatus,
    //    os.AccountId,
    //   hos.wrid,--仓单ID
    //    nod.WRCodeGroup,
    //    nod.BrandGroup,
    //    nod.RankGroup,
    //    nod.SpecGroup,
    //    nod.WarehouseNameGroup,
    //    nod.DeliveryGoodsNameGroup,
    //    nod.StoreOutQtyGroup
    // from OutStoreRequest os
    // left join StoreOutRequestDetial srd on srd.storeoutid =os.storeoutid
    // left join WarehouseReciept hos on hos.wrid=srd.wrid
    // left join (select od.storeoutid, 
    // listagg(to_char(od.wrcode),',') within group (order by od.wrcode) WRCodeGroup,
    // listagg(to_char(od.brand),',') within group (order by od.brand) BrandGroup,
    // listagg(to_char(od.rank),',') within group (order by od.rank) RankGroup,
    // listagg(to_char(od.Spec),',') within group (order by od.Spec) SpecGroup,
    // listagg(to_char(od.warehousename),',') within group (order by od.warehousename) WarehouseNameGroup,
    // listagg(to_char(od.deliverygoodsname),',') within group (order by od.deliverygoodsname) DeliveryGoodsNameGroup,
    // listagg(to_char(od.StoreOutQty),',') within group (order by od.StoreOutQty) StoreOutQtyGroup 
    // from (select sor.storeoutqty,gs.deliverygoodsname,wh.warehousename,wr.Spec,wr.brand,wr.rank,wr.wrid,wr.wrcode,sor.storeoutid 
    // from StoreOutRequestDetial sor 
    // left join WarehouseReciept wr on wr.wrid=sor.wrid 
    // left join WareHouse wh on wh.warehouseid=wr.warehouseid
    // left join DeliveryGoods gs on gs.DeliveryGoodsId=wr.DeliveryGoodsId) od  
    // group by od.storeoutid) nod  on nod.StoreOutId=os.StoreOutId
    //    <where>
    //       os.AccountId =#{accountId}	 
    //            <if test="startDate != null">
    //                AND os.RequestTime &gt;=to_date(#{startDate},'yyyy-MM-dd hh24:mi:ss')
    //            </if>
    //            <if test="endDate != null">
    //                AND os.RequestTime &lt;=to_date(#{endDate},'yyyy-MM-dd hh24:mi:ss')
    //            </if>
    //        </where>
    //        order by os.RequestTime desc
    //</select>
        #endregion

        #region 仓单变更流水表WRChangeFlow
        /// <summary>
        /// 提货流水
        /// </summary>
        [PropertyDisc("autoidFlowNum")]
       public string autoidFlowNum { get; set; }

        #endregion

        #region 出库单表OutStoreRequest
        /// <summary>
        /// 出库ID
        /// </summary>
        [PropertyDisc("StoreOutId")]
       public long StoreOutId { get; set; }
        /// <summary>
        /// 出库单号
        /// </summary>
        [PropertyDisc("StoreOutCode")]
        public long StoreOutCode { get; set; }
        /// <summary>
        /// 出库仓库ID
        /// </summary>
        [PropertyDisc("WareHouseId")]
        public long WareHouseId { get; set; }

       /// <summary>
        /// 备注
        /// </summary>
        [PropertyDisc("Remark")]
        public string Remark { get; set; }
       /// <summary>
       /// 收货人
       /// </summary>
       [PropertyDisc("RECEIVEPERSON")]
        public string RecievePerson { get; set; }
       /// <summary>
       /// 收货地址
       /// </summary>
       [PropertyDisc("RECEIVEADDRESS")]
        public string RecieveAddress { get; set; }
       /// <summary>
       /// 联系电话
       /// </summary>
       [PropertyDisc("PHONENUM")]
        public string PhoneNum { get; set; }
    
        /// <summary>
        /// 申请时间
        /// </summary>
        [PropertyDisc("RequestTime")]
        public DateTime RequestTime { get; set; }
        /// <summary>
        /// 审核状态
        /// </summary>
        [PropertyDisc("AuditStatus")]
        public eAuditStatus AuditStatus { get; set; }
        /// <summary>
        /// 申请账户
        /// </summary>
        [PropertyDisc("AccountId")]
        public long AccountId { get; set; } 
        #endregion

        #region 出库单明细表StoreOutRequestDetial
        /// <summary>
        /// 出库数量组
        /// </summary>
        [PropertyDisc("StoreOutQtyGroup")]
        public string StoreOutQtyGroup { get; set; } 
        #endregion

        #region 仓库表WareHouse
        /// <summary>
        /// 仓库名称组
        /// </summary>
        [PropertyDisc("WarehouseNameGroup")]
        public string WarehouseNameGroup { get; set; }

        /// <summary>
        /// 仓库地址
        /// </summary>
        [PropertyDisc("WareHouseAddress")]
        public string WareHouseAddress { get; set; }


        /// <summary>
        /// 仓库地区
        /// </summary>
        [PropertyDisc("AreaAddress")]
        public string AreaAddress { get; set; }

        /// <summary>
        ///   仓库具体地址
        /// </summary>
        [PropertyDisc("detailAddress")]
        public string DetailAddress { get; set; }
        #endregion

        #region 仓单表WarehouseReciept
        /// <summary>
        /// 仓单ID
        /// </summary>
        [PropertyDisc("WRID")]
        public long WRID { get; set; }
        /// <summary>
        /// 仓单号组
        /// </summary>
        [PropertyDisc("WRCodeGroup")]
        public string WRCodeGroup { get; set; }
        /// <summary>
        /// 品牌组
        /// </summary>
        [PropertyDisc("BrandGroup")]
        public string BrandGroup { get; set; }
        /// <summary>
        /// 等级组
        /// </summary>
        [PropertyDisc("RankGroup")]
        public string RankGroup { get; set; }
        /// <summary>
        /// 规格组
        /// </summary>
        [PropertyDisc("SpecGroup")]
        public string SpecGroup { get; set; }
        /// <summary>
        /// 单位
        /// </summary>
        //[PropertyDisc("GoodsUnitId")]
        //public long GoodsUnitId { get; set; } 
        #endregion

        #region 交割商品DeliveryGoods
        /// <summary>
        /// 交割商品名称组
        /// </summary>
        [PropertyDisc("DeliveryGoodsNameGroup")]
        public string DeliveryGoodsNameGroup { get; set; }


       /// <summary>
        /// 交割商品代碼
       /// </summary>
          [PropertyDisc("DeliveryGoodscode")]
        public string DeliveryGoodsCode { get; set; }


          public string DisplayGoodsCodeName
          {
              get
              {
                  return string.Format("{0}/{1}", DeliveryGoodsCode, DeliveryGoodsNameGroup);
              }
          }

     
        #endregion


        //审核状态-转换显示
        public string AuditStatusDisplay 
        { 
            get 
            {
                return AuditStatus.Discription();
            } 
        }


        /// <summary>
        /// 身份证号
        /// </summary>
        [PropertyDisc("cardnum")]
        public string IdCardNum { get; set; }

        /// <summary>
        ///  
        /// </summary>
        [PropertyDisc("taketype")]
        public TakeGoodsWay TakeGoodsWay { get; set; }


        public string TakeGoodsWayDisplay
        {
            get
            {
                if (TakeGoodsWay == 0)
                {
                    return "--";
                }
                return TakeGoodsWay.Discription();
            }
        }

        /// <summary>
        /// 是否显示地址
        /// </summary>
        public bool IsShowAddress
        {
            get
            {
                return TakeGoodsWay == TakeGoodsWay.Express;
            }
        }

        /// <summary>
        /// 仓库名称组-转换显示
        /// </summary>
        public string WarehouseNameGroupDisplay
        {
            get
            {
                if (WarehouseNameGroup != null && WarehouseNameGroup != "")
                {
                    string[] tempWarehouseName = WarehouseNameGroup.Split(',');
                    if (tempWarehouseName.Length > 0)
                    {
                        return tempWarehouseName[0];
                    }
                    else
                    {
                        return WarehouseNameGroup;
                    }                

                }
                else
                {
                    return "-";
                }

            }
        }

       /// <summary>
        /// 仓单号组-转换显示
       /// </summary>
        public string WRCodeGroupDisplay
        {
            get
            {
                if (WRCodeGroup != null && WRCodeGroup != "")
                {
                    return WRCodeGroup;
                }
                else
                {
                    return "-";
                }
                
            }
        }

        /// <summary>
        /// 品牌组-转换显示
        /// </summary>
        public string BrandGroupDisplay
        {
            get
            {
                if (BrandGroup != null && BrandGroup != "")
                {
                    return BrandGroup;
                }
                else
                {
                    return "-";
                }

            }
        }

        /// <summary>
        /// 等级组-转换显示
        /// </summary>
        public string RankGroupDisplay
        {
            get
            {
                if (RankGroup != null && RankGroup != "")
                {
                    return RankGroup;
                }
                else
                {
                    return "-";
                }

            }
        }

        /// <summary>
        /// 规格组-转换显示
        /// </summary>
        public string SpecGroupDisplay
        {
            get
            {
                if (SpecGroup != null && SpecGroup != "")
                {
                    return SpecGroup;
                }
                else
                {
                    return "-";
                }

            }
        }

        /// <summary>
        /// 交割商品名称组-转换显示
        /// </summary>
        public string DeliveryGoodsNameGroupDisplay
        {
            get
            {
                if (DeliveryGoodsNameGroup != null && DeliveryGoodsNameGroup != "")
                {
                    return DisplayGoodsCodeName;
                }
                else
                {
                    return "-";
                }

            }
        }

        /// <summary>
        /// 出库数量组-转换显示
        /// </summary>
        public string StoreOutQtyGroupDisplay
        {
            get
            {
                if (StoreOutQtyGroup != null && StoreOutQtyGroup != "")
                {
                    return StoreOutQtyGroup;
                }
                else
                {
                    return "-";
                }

            }
        }
    }
}