using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Web;

namespace DSWeb.Common.DB
{
    [Table("code_FtpSet")]
    public class code_FtpSet_md
    {
        [Key]
        public string GID { get; set; }
        public string EDINAME { get; set; }
        public string SERVERIP { get; set; }
        public string FOLDERNAME { get; set; }
        public string USERNAME { get; set; }
        public string PASSWORD { get; set; }
        public string CORPID { get; set; }
        public string SENDCODE { get; set; }
        public string RECEIVECODE { get; set; }
        public string SENDNAME { get; set; }
        public string SENDATTN { get; set; }
        public string SENDTEL { get; set; }
        public string SENDEMAIL { get; set; }
        public string RECEIVEOP { get; set; }
        public string RECEIVESALE { get; set; }
        public string RECEIVEDEPT { get; set; }
        public string SENDCOMPANYCODE { get; set; }
        public string SENDSUBCOMPANYCODE { get; set; }
        public string CARRIERID { get; set; }
        public string RECEIVEEMAIL { get; set; }
        public string RECEIVESIEMAIL { get; set; }
        public string SHIPPERTEL { get; set; }
        public string CONSIGNEETEL { get; set; }
        public string NOTIFYPARTYTEL { get; set; }
        public string ISUSETEL { get; set; }
        public string SERVERIP2 { get; set; }
        public string FOLDERNAME2 { get; set; }
        public string USERNAME2 { get; set; }
        public string PASSWORD2 { get; set; }
        public string ALIASSENDCODE { get; set; }
        public string SFTPPORT { get; set; }
        public bool? ISSSL { get; set; }

        public string TMPFOLDERNAME { get; set; }
        public string SFTPCERFILENAME { get; set; }
   
    }

    [Table("OP_LOGICINFO")]

    public class OP_LOGICINFO_md
    {
        [Key]
        public Guid GID { get; set; }
        public string BSNO { get; set; }
        public string PROPNAME { get; set; }
        public string PROPVALUE { get; set; }

        public OP_LOGICINFO_md() {
            GID =  Guid.NewGuid();
        }
    }

    [Table("op_ctn")]
    public class op_ctn_md
    {
        [Key]
        public string CTN_ID { get; set; }
        public string BSNO { get; set; }
        public string CTNCODE { get; set; }
        public string SIZE { get; set; }
        public string CTN { get; set; }
        public int? CTNNUM { get; set; } 
        public int? TEU { get; set; }
        public string CTNALL { get; set; }
        public string CNTRNO { get; set; }
        public string SEALNO { get; set; }
        public int PKGS { get; set; }
        public decimal? KGS { get; set; }
        public decimal? CBM { get; set; }
        public string REMARK { get; set; }
        public string KINDPKGS { get; set; }
        public decimal? TAREWEIGHT { get; set; }
        public string GOODSNAME { get; set; }
        public string CTNSTATUS { get; set; }
        public string WEIGHTYPE { get; set; }
        public decimal? WEIGHKGS { get; set; }
        public string WEIGHATTN { get; set; }
        public string WEIGHTEL { get; set; }
        public string WEIGHSIGN { get; set; }
        public string WEIGHDATE { get; set; }
        public string MASTERNO { get; set; }
        public string TRUCKER { get; set; }
        public decimal? TRUCKFEE { get; set; }
        public int? FREESTORAGEDAY { get; set; }
        public int? STORAGEDAY { get; set; }
        public decimal? STORAGEPRICE { get; set; }
        public decimal? STORAGEFEE { get; set; }
        public int? FREECTNDAY { get; set; }
        public int? CTNDAY { get; set; }
        public decimal? CTNPRICE { get; set; }
        public decimal? CTNFEE { get; set; }
        public string TRUCKNO { get; set; }
        public string vgmconncom { get; set; } = "";
        public string VGMADDR { get; set; }
        public string VGMEMAIL { get; set; }
        public string MTMC { get; set; }
        public DateTime? SJRGSJ { get; set; }
        public DateTime? SJCGSJ { get; set; }
        public bool? ISWMS { get; set; }
        public DateTime? WMSDATE { get; set; }
        public string TiXiangShiJian { get; set; }
        public string FanChangShiJian { get; set; }
        public string JiGangShiJian { get; set; }
        public string AREANAME { get; set; }
        public string DaoGangShiJian { get; set; }
        public string TiHuoShiJian { get; set; }
        public string FanKongShiJian { get; set; }
        public string PCTN_ID { get; set; }
        public string ISTEMP { get; set; }
        public long? DJYCTNID { get; set; }

        public op_ctn_md() { }

        public op_ctn_md(string _BSNO) 
        {
            CTN_ID = Guid.NewGuid().ToString();
            BSNO= _BSNO;
            CTNNUM = 0;
            TEU = 0;
            PKGS = 0;
            KGS = 0;
            CBM = 0;
            TAREWEIGHT = 0;
            WEIGHKGS = 0;
            TRUCKFEE = 0;
            STORAGEPRICE = 0;
            STORAGEFEE = 0;
            FREECTNDAY = 0;
            CTNDAY = 0;
            CTNPRICE = 0;
            CTNFEE = 0;
            ISWMS = false;
            DJYCTNID = 0;
        }
    }


    [Table("tSysEnumValue")]
    public class tSysEnumValue_md
    {
        
        public decimal LangID { get; set; } = 0;
        [Key, Column(Order = 0)]
        public decimal EnumTypeID { get; set; }
        [Key, Column(Order = 1)]
        public string EnumValueID { get; set; }
        public string EnumValueName { get; set; }
        public string IsDefault { get; set; } = "0";
        public decimal DispIndex { get; set; }
        public string VerNo { get; set; } = "1.00";
        public string EnumValueName_2 { get; set; }
    }

}