using System;
using System.Linq;
using System.Text;
using SqlSugar;

namespace WMS.Core
{
    ///<summary>
    ///
    ///</summary>
    [SugarTable("BILL_ORDERGRP")]
    public partial class BILL_ORDERGRP
    {
           public BILL_ORDERGRP(){


           }
           /// <summary>
           /// Desc:订单编号
           /// Default:
           /// Nullable:False
           /// </summary>           
           [SugarColumn(IsPrimaryKey=true)]
           public string F_NO {get;set;}

           /// <summary>
           /// Desc:是否停用
           /// Default:
           /// Nullable:False
           /// </summary>           
           public int F_ISSTOP {get;set;}

           /// <summary>
           /// Desc:是否删除
           /// Default:
           /// Nullable:False
           /// </summary>           
           public int F_ISDELETE {get;set;}

           /// <summary>
           /// Desc:订单类型
           /// Default:
           /// Nullable:False
           /// </summary>           
           public int F_TYPENUM {get;set;}

           /// <summary>
           /// Desc:订单状态
           /// Default:
           /// Nullable:False
           /// </summary>           
           public int F_STATENUM {get;set;}

           /// <summary>
           /// Desc:车牌号
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string F_CARNO {get;set;}

           /// <summary>
           /// Desc:月台号
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string F_DOCKNO {get;set;}

           /// <summary>
           /// Desc:分配月台凭证
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string F_DOCKTOKENNO {get;set;}

           /// <summary>
           /// Desc:供应商编号
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string F_SUPPLIERNO {get;set;}

           /// <summary>
           /// Desc:客户编号
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string F_CUSTOMERNO {get;set;}

           /// <summary>
           /// Desc:发货方式
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string F_OUTWAY {get;set;}

           /// <summary>
           /// Desc:发货类型
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string F_OUTTYPE {get;set;}

           /// <summary>
           /// Desc:过账日期
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string F_POSTDATE {get;set;}

           /// <summary>
           /// Desc:外部系统单据类型
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string F_OSOTYPE {get;set;}

           /// <summary>
           /// Desc:外部系统建
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string F_OSOADDDATE {get;set;}

           /// <summary>
           /// Desc:备注
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string F_MEMO {get;set;}

           /// <summary>
           /// Desc:创建用户编号
           /// Default:
           /// Nullable:False
           /// </summary>           
           public string F_ADDUSERNO {get;set;}

           /// <summary>
           /// Desc:创建时间
           /// Default:
           /// Nullable:False
           /// </summary>           
           public DateTime F_ADDTIME {get;set;}

           /// <summary>
           /// Desc:编辑用户编号
           /// Default:
           /// Nullable:False
           /// </summary>           
           public string F_EDITUSERNO {get;set;}

           /// <summary>
           /// Desc:编辑时间
           /// Default:
           /// Nullable:False
           /// </summary>           
           public DateTime F_EDITTIME {get;set;}

           /// <summary>
           /// Desc:成品编号
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string F_DEFINE01 {get;set;}

           /// <summary>
           /// Desc:
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string F_DEFINE02 {get;set;}

           /// <summary>
           /// Desc:
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string F_DEFINE03 {get;set;}

           /// <summary>
           /// Desc:
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string F_DEFINE04 {get;set;}

           /// <summary>
           /// Desc:
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string F_DEFINE05 {get;set;}

           /// <summary>
           /// Desc:
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string F_DEFINE06 {get;set;}

           /// <summary>
           /// Desc:
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string F_DEFINE07 {get;set;}

           /// <summary>
           /// Desc:
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string F_DEFINE08 {get;set;}

           /// <summary>
           /// Desc:
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string F_DEFINE09 {get;set;}

           /// <summary>
           /// Desc:
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string F_DEFINE10 {get;set;}

           /// <summary>
           /// Desc:
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string F_DEFINE11 {get;set;}

           /// <summary>
           /// Desc:
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string F_DEFINE12 {get;set;}

           /// <summary>
           /// Desc:
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string F_DEFINE13 {get;set;}

           /// <summary>
           /// Desc:
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string F_DEFINE14 {get;set;}

           /// <summary>
           /// Desc:EXECL 导入时，返回的错误信息
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string F_DEFINE15 {get;set;}

           /// <summary>
           /// Desc:申请人
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string F_APPLYPEOPLE {get;set;}

           /// <summary>
           /// Desc:申请部门
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string F_APPLYDEP {get;set; }
         /// <summary>
       /// 待查询的物料状态
       /// </summary>
       [SugarColumn(IsIgnore = true)]
       public string F_MATSTATE
       {
           get
           {
               if (F_TYPENUM == 4)
               {
                   return "1,4";
               }
               else if (F_TYPENUM == 8)
               {
                   return "4,6";
               }
               else if (F_TYPENUM == 13)
               {
                   return "1,4";
               }
               else if (F_TYPENUM == 17)
               {
                   return "1";
               }
               else if (F_TYPENUM == 23)
               {
                   return "1,4";
               }
               else
               {
                   return "0";
               }
           }
       }
  }
}