using System; using HcUtility.Core; using Newtonsoft.Json; namespace DSWeb.MvcShipping.Models.MsOpSeai { /// /// 海运进口的集装箱 /// [JsonObject] public class MsOpSeaiDetail : ModelObjectBillBody { #region 读写属性 private string _ctn_id = ""; /// /// 编号 /// [ModelDB(MDBType = ModelDBOprationType.All, IsPrimary = true)] public string CTN_ID { get { return _ctn_id; } set { _ctn_id = value; } } private string _BSNO = ""; /// /// 业务编号 /// [ModelDB(MDBType = ModelDBOprationType.All, IsPrimary = true)] public string BSNO { get { return _BSNO; } set { _BSNO = value; } } private string _ctncode = ""; /// /// 箱型代码 /// [ModelDB] public string CTNCODE { get { return _ctncode; } set { _ctncode = value; } } private string _size = ""; /// /// 尺寸 /// [ModelDB] public string SIZE { get { return _size; } set { _size = value; } } private string _ctn = ""; /// /// 箱型 /// [ModelDB] public string CTN { get { return _ctn; } set { _ctn = value; } } private int _ctnnum = 0; /// /// 箱量 /// [ModelDB] public int CTNNUM { get { return _ctnnum; } set { _ctnnum = value; } } private int _teu = 0; /// /// TEU /// [ModelDB] public int TEU { get { return _teu; } set { _teu = value; } } private string _ctnall = ""; /// /// 表现形式 /// [ModelDB] public string CTNALL { get { return _ctnall; } set { _ctnall = value; } } private string _cntrno = ""; /// /// 箱号 /// [ModelDB] public string CNTRNO { get { return _cntrno; } set { _cntrno = value; } } private string _sealno = ""; /// /// 封号 /// [ModelDB] public string SEALNO { get { return _sealno; } set { _sealno = value; } } private int _pkgs = 0; /// /// 件数 /// [ModelDB] public int PKGS { get { return _pkgs; } set { _pkgs = value; } } private decimal _kgs = 0; /// /// 重量 /// [ModelDB] public decimal KGS { get { return _kgs; } set { _kgs = value; } } private decimal _cbm = 0; /// /// 尺码 /// [ModelDB] public decimal CBM { get { return _cbm; } set { _cbm = value; } } private string _remark = ""; /// /// 备注 /// [ModelDB] public string REMARK { get { return _remark; } set { _remark = value; } } private string _kindpkgs = ""; /// /// KINDPKGS /// [ModelDB] public string KINDPKGS { get { return _kindpkgs; } set { _kindpkgs = value; } } private decimal _tareweight = 0; /// /// TAREWEIGHT /// [ModelDB] public decimal TAREWEIGHT { get { return _tareweight; } set { _tareweight = value; } } private string _goodsname = ""; /// /// GOODSNAME /// [ModelDB] public string GOODSNAME { get { return _goodsname; } set { _goodsname = value; } } private string _TRUCKER = ""; public string TRUCKER { get { return _TRUCKER; } set { _TRUCKER = value; } } private string _TRUCKNO= ""; public string TRUCKNO { get { return _TRUCKNO; } set { _TRUCKNO = value; } } private string _FREECTNDAY = "0"; /// /// public string FREECTNDAY { get { return _FREECTNDAY; } set { _FREECTNDAY = value; } } private string _CTNDAY = "0"; /// /// public string CTNDAY { get { return _CTNDAY; } set { _CTNDAY = value; } } private string _TRUCKFEE = "0"; /// /// public string TRUCKFEE { get { return _TRUCKFEE; } set { _TRUCKFEE = value; } } private string _CTNPRICE = "0"; /// /// public string CTNPRICE { get { return _CTNPRICE; } set { _CTNPRICE = value; } } private string _CTNFEE = "0"; /// /// public string CTNFEE { get { return _CTNFEE; } set { _CTNFEE = value; } } private string _ctnstatus = ""; public string CTNSTATUS { get { return _ctnstatus; } set { _ctnstatus = value; } } /// /// 码头信息 /// private string _MTMC = ""; [ModelDB] public string MTMC { get { return _MTMC; } set { _MTMC = value; } } /// /// 卸船时间 /// private string _SJRGSJ = ""; [ModelDB] public string SJRGSJ { get { return _SJRGSJ; } set { _SJRGSJ = value; } } /// /// 出港时间 /// private string _SJCGSJ = ""; [ModelDB] public string SJCGSJ { get { return _SJCGSJ; } set { _SJCGSJ = value; } } /// /// 入库时间 /// private string _WMSDATE = ""; [ModelDB] public string WMSDATE { get { return _WMSDATE; } set { _WMSDATE = value; } } /// /// 是否入库 /// private string _ISWMS = ""; [ModelDB] public string ISWMS { get { return _ISWMS; } set { _ISWMS = value; } } /// /// 储位 /// private string _AREANAME = ""; [ModelDB] public string AREANAME { get { return _AREANAME; } set { _AREANAME = value; } } /// /// 暂进 /// private string _ISTEMP = ""; [ModelDB] public string ISTEMP { get { return _ISTEMP; } set { _ISTEMP = value; } } private string _TIXIANGSHIJIAN = ""; [ModelDB] public string TIXIANGSHIJIAN { get { return _TIXIANGSHIJIAN; } set { _TIXIANGSHIJIAN = value; } } #endregion public MsOpSeaiDetail() { TableName = "op_ctn"; } } #region 参照部分 public class MsOpSeaiDetailRefMsOpSeai { public string BSNO { get; set; } } #endregion #region 提单箱导入EXCEL public class MsOpCtrnExcel { public string NO { get; set; } public string MBLNO { get; set; } public string WMSDate { get; set; } public string CtrnNo { get; set; } public string Pkgs { get; set; } public string Kgs { get; set; } public string AreaName { get; set; } public string INVOICENO { get; set; } public string GOODSMODEL{ get; set; } public string BZTCHNO { get; set; } public string PRODUCTIONDATE { get; set; } public string KINDPKGS { get; set; } public MsOpCtrnExcel() { CtrnNo = ""; Pkgs = "0"; Kgs = "0"; WMSDate = ""; MBLNO = ""; AreaName = ""; INVOICENO = ""; GOODSMODEL = ""; BZTCHNO = ""; PRODUCTIONDATE = ""; KINDPKGS = ""; } } #endregion }