using System; using SqlSugar; using System.ComponentModel; using Myshipping.Core.Entity; namespace Myshipping.Application.Entity { /// /// 客户订舱 /// [SugarTable("booking_customer_order")] [Description("客户订舱")] public class BookingCustomerOrder : DBEntityTenant { /// /// 其他业务系统ID /// public string BSNO { get; set; } /// /// 业务状态 /// public string BSSTATUS { get; set; } /// /// 业务日期 /// public DateTime? BSDATE { get; set; } /// /// 系统编号 /// public string BOOKINGNO { get; set; } /// /// 船名 /// public string VESSEL { get; set; } /// /// 海关航次 /// public string VOYNO { get; set; } /// /// 内部航次 /// public string VOYNOINNER { get; set; } /// /// 场站代码 /// public string YARDID { get; set; } /// /// 场站 /// public string YARD { get; set; } /// /// 开船日期 /// public DateTime? ETD { get; set; } /// /// 合约号 /// public string CONTRACTNO { get; set; } /// /// 发货人 /// public string SHIPPER { get; set; } /// /// 收货人 /// public string CONSIGNEE { get; set; } /// /// 通知人 /// public string NOTIFYPARTY { get; set; } /// /// 第二通知人 /// public string NOTIFYPARTY2 { get; set; } /// /// 起运港代码 /// public string PORTLOADID { get; set; } /// /// 起运港 /// public string PORTLOAD { get; set; } /// /// 卸货港代码 /// public string PORTDISCHARGEID { get; set; } /// /// 卸货港 /// public string PORTDISCHARGE { get; set; } /// /// 运输条款 /// public string SERVICE { get; set; } /// /// 付费方式 /// public string BLFRT { get; set; } /// /// HS代码 /// public string HSCODE { get; set; } /// /// 货描 /// public string DESCRIPTION { get; set; } /// /// 件数 /// public int? PKGS { get; set; } /// /// 包装 /// public string KINDPKGS { get; set; } /// /// 毛重 /// public decimal? KGS { get; set; } /// /// 尺码 /// public decimal? CBM { get; set; } /// /// 件数大写 /// public string TOTALNO { get; set; } /// /// 集装箱 /// public string CNTRTOTAL { get; set; } /// /// 船公司代号 /// public string CARRIERID { get; set; } /// /// 船公司 /// public string CARRIER { get; set; } /// /// 货物标识 /// public string CARGOID { get; set; } /// /// 危险品类别 /// public string DCLASS { get; set; } /// /// 危险品编号 /// public string DUNNO { get; set; } /// /// 危险品页号 /// public string DPAGE { get; set; } /// /// 危险品标签 /// public string DLABEL { get; set; } /// /// 危险品联系人 /// public string LINKMAN { get; set; } /// /// 危险品联系电话 /// public string DTEL { get; set; } /// /// 温度单位 /// public string TEMPID { get; set; } /// /// 设置温度 /// public string TEMPSET { get; set; } /// /// 通风度 /// public string REEFERF { get; set; } /// /// 湿度 /// public string HUMIDITY { get; set; } /// /// 最低温度 /// public string TEMPMIN { get; set; } /// /// 最高温度 /// public string TEMPMAX { get; set; } /// /// SO备注 /// public string SOREMARK { get; set; } /// /// 租户名称 /// public string TenantName { get; set; } /// /// 订舱台账ID /// public long BookingId { get; set; } /// /// 订舱租户id /// public long BookingTenantId { get; set; } /// /// 订舱租户名称 /// public string BookingTenantName { get; set; } /// /// 订舱租户大简云公司id /// public string BookingCompanyId { get; set; } /// /// 订舱用户id /// public long BookingUserId { get; set; } /// /// 订舱用户名称 /// public string BookingUserName { get; set; } /// /// 订舱大简云用户id /// public string BookingDjyUserId { get; set; } /// /// 箱长 /// public decimal CtrnLength { get; set; } /// /// 箱宽 /// public decimal CtrnWidth { get; set; } /// /// 箱高 /// public decimal CtrnHeight { get; set; } /// /// 销售代码 /// public string SaleCode { get; set; } /// /// 回推数据接口url /// public string FeedbackUrl { get; set; } /// /// 回推接口Key /// public string FeedbackKey { get; set; } /// /// 回推接口秘钥 /// public string FeedbackSecret { get; set; } /// /// 操作备注 /// public string CZRemark { get; set; } /// /// 目的地代码 /// public string DESTINATIONID { get; set; } /// /// 目的地 /// public string DESTINATION { get; set; } /// /// 附加数据 /// public string ExtendData { get; set; } /// /// 起运港唯一代码 /// public string PORTLOADCODE { get; set; } /// /// 目的港唯一代码 /// public string PORTDISCHARGECODE { get; set; } /// /// 目的地唯一代码 /// public string DESTINATIONCODE { get; set; } /// /// 付费方式代码 /// public string FRTCODE { get; set; } /// /// 运输条款代码 /// public string SERVICECODE { get; set; } /// /// 船公司航线代码 /// public string LANECODE { get; set; } /// /// 发货人名称 /// [SugarColumn(ColumnName = "ShipperName")] [Description("发货人名称")] public string ShipperName { get; set; } /// /// 发货人地址 /// [SugarColumn(ColumnName = "ShipperAddress")] [Description("发货人地址")] public string ShipperAddress { get; set; } /// /// 发货人国家 /// [SugarColumn(ColumnName = "ShipperCountry")] [Description("发货人国家")] public string ShipperCountry { get; set; } /// /// 发货人省份 /// [SugarColumn(ColumnName = "ShipperProvince")] [Description("发货人省份")] public string ShipperProvince { get; set; } /// /// 发货人城市 /// [SugarColumn(ColumnName = "ShipperCity")] [Description("发货人城市")] public string ShipperCity { get; set; } /// /// 发货人区县 /// [SugarColumn(ColumnName = "ShipperCounty")] [Description("发货人区县")] public string ShipperCounty { get; set; } /// /// 发货人邮政编码 /// [SugarColumn(ColumnName = "ShipperPostCode")] [Description("发货人邮政编码")] public string ShipperPostCode { get; set; } /// /// 发货人联系人名 /// [SugarColumn(ColumnName = "ShipperFirstName")] [Description("发货人联系人名")] public string ShipperFirstName { get; set; } /// /// 发货人联系人姓 /// [SugarColumn(ColumnName = "ShipperLastName")] [Description("发货人联系人姓")] public string ShipperLastName { get; set; } /// /// 发货人电话国家代码 /// [SugarColumn(ColumnName = "ShipperPhoneCountryCode")] [Description("发货人电话国家代码")] public string ShipperPhoneCountryCode { get; set; } /// /// 发货人电话区号 /// [SugarColumn(ColumnName = "ShipperPhoneCode")] [Description("发货人电话区号")] public string ShipperPhoneCode { get; set; } /// /// 发货人电话 /// [SugarColumn(ColumnName = "ShipperPhone")] [Description("发货人电话")] public string ShipperPhone { get; set; } /// /// 发货人分机号 /// [SugarColumn(ColumnName = "ShipperPhoneExtension")] [Description("发货人分机号")] public string ShipperPhoneExtension { get; set; } /// /// 收货人名称 /// [SugarColumn(ColumnName = "ConsigneeName")] [Description("收货人名称")] public string ConsigneeName { get; set; } /// /// 收货人地址 /// [SugarColumn(ColumnName = "ConsigneeAddress")] [Description("收货人地址")] public string ConsigneeAddress { get; set; } /// /// 收货人国家 /// [SugarColumn(ColumnName = "ConsigneeCountry")] [Description("收货人国家")] public string ConsigneeCountry { get; set; } /// /// 收货人省份 /// [SugarColumn(ColumnName = "ConsigneeProvince")] [Description("收货人省份")] public string ConsigneeProvince { get; set; } /// /// 收货人城市 /// [SugarColumn(ColumnName = "ConsigneeCity")] [Description("收货人城市")] public string ConsigneeCity { get; set; } /// /// 收货人区县 /// [SugarColumn(ColumnName = "ConsigneeCounty")] [Description("收货人区县")] public string ConsigneeCounty { get; set; } /// /// 收货人邮政编码 /// [SugarColumn(ColumnName = "ConsigneePostCode")] [Description("收货人邮政编码")] public string ConsigneePostCode { get; set; } /// /// 收货人联系人名 /// [SugarColumn(ColumnName = "ConsigneeFirstName")] [Description("收货人联系人名")] public string ConsigneeFirstName { get; set; } /// /// 收货人联系人姓 /// [SugarColumn(ColumnName = "ConsigneeLastName")] [Description("收货人联系人姓")] public string ConsigneeLastName { get; set; } /// /// 收货人电话国家代码 /// [SugarColumn(ColumnName = "ConsigneePhoneCountryCode")] [Description("收货人电话国家代码")] public string ConsigneePhoneCountryCode { get; set; } /// /// 收货人电话区号 /// [SugarColumn(ColumnName = "ConsigneePhoneCode")] [Description("收货人电话区号")] public string ConsigneePhoneCode { get; set; } /// /// 收货人电话 /// [SugarColumn(ColumnName = "ConsigneePhone")] [Description("收货人电话")] public string ConsigneePhone { get; set; } /// /// 收货人分机号 /// [SugarColumn(ColumnName = "ConsigneePhoneExtension")] [Description("收货人分机号")] public string ConsigneePhoneExtension { get; set; } /// /// 通知人名称 /// [SugarColumn(ColumnName = "NotifypartName")] [Description("通知人名称")] public string NotifypartName { get; set; } /// /// 通知人地址 /// [SugarColumn(ColumnName = "NotifypartAddress")] [Description("通知人地址")] public string NotifypartAddress { get; set; } /// /// 通知人国家 /// [SugarColumn(ColumnName = "NotifypartCountry")] [Description("通知人国家")] public string NotifypartCountry { get; set; } /// /// 通知人省份 /// [SugarColumn(ColumnName = "NotifypartProvince")] [Description("通知人省份")] public string NotifypartProvince { get; set; } /// /// 通知人城市 /// [SugarColumn(ColumnName = "NotifypartCity")] [Description("通知人城市")] public string NotifypartCity { get; set; } /// /// 通知人区县 /// [SugarColumn(ColumnName = "NotifypartCounty")] [Description("通知人区县")] public string NotifypartCounty { get; set; } /// /// 通知人邮政编码 /// [SugarColumn(ColumnName = "NotifypartPostCode")] [Description("通知人邮政编码")] public string NotifypartPostCode { get; set; } /// /// 通知人联系人名 /// [SugarColumn(ColumnName = "NotifypartFirstName")] [Description("通知人联系人名")] public string NotifypartFirstName { get; set; } /// /// 通知人联系人姓 /// [SugarColumn(ColumnName = "NotifypartLastName")] [Description("通知人联系人姓")] public string NotifypartLastName { get; set; } /// /// 通知人电话国家代码 /// [SugarColumn(ColumnName = "NotifypartPhoneCountryCode")] [Description("通知人电话国家代码")] public string NotifypartPhoneCountryCode { get; set; } /// /// 通知人电话区号 /// [SugarColumn(ColumnName = "NotifypartPhoneCode")] [Description("通知人电话区号")] public string NotifypartPhoneCode { get; set; } /// /// 通知人电话 /// [SugarColumn(ColumnName = "NotifypartPhone")] [Description("通知人电话")] public string NotifypartPhone { get; set; } /// /// 通知人分机号 /// [SugarColumn(ColumnName = "NotifypartPhoneExtension")] [Description("通知人分机号")] public string NotifypartPhoneExtension { get; set; } /// /// 订舱公司名称 /// [SugarColumn(ColumnName = "BookingName")] [Description("订舱公司名称")] public string BookingName { get; set; } /// /// 订舱公司地址 /// [SugarColumn(ColumnName = "BookingAddress")] [Description("订舱公司地址")] public string BookingAddress { get; set; } /// /// 订舱公司国家 /// [SugarColumn(ColumnName = "BookingCountry")] [Description("订舱公司国家")] public string BookingCountry { get; set; } /// /// 订舱公司省份 /// [SugarColumn(ColumnName = "BookingProvince")] [Description("订舱公司省份")] public string BookingProvince { get; set; } /// /// 订舱公司城市 /// [SugarColumn(ColumnName = "BookingCity")] [Description("订舱公司城市")] public string BookingCity { get; set; } /// /// 订舱公司区县 /// [SugarColumn(ColumnName = "BookingCounty")] [Description("订舱公司区县")] public string BookingCounty { get; set; } /// /// 订舱公司邮政编码 /// [SugarColumn(ColumnName = "BookingPostCode")] [Description("订舱公司邮政编码")] public string BookingPostCode { get; set; } /// /// 订舱公司联系人名 /// [SugarColumn(ColumnName = "BookingFirstName")] [Description("订舱公司联系人名")] public string BookingFirstName { get; set; } /// /// 订舱公司联系人姓 /// [SugarColumn(ColumnName = "BookingLastName")] [Description("订舱公司联系人姓")] public string BookingLastName { get; set; } /// /// 订舱公司电话国家代码 /// [SugarColumn(ColumnName = "BookingPhoneCountryCode")] [Description("订舱公司电话国家代码")] public string BookingPhoneCountryCode { get; set; } /// /// 订舱公司电话区号 /// [SugarColumn(ColumnName = "BookingPhoneCode")] [Description("订舱公司电话区号")] public string BookingPhoneCode { get; set; } /// /// 订舱公司电话 /// [SugarColumn(ColumnName = "BookingPhone")] [Description("订舱公司电话")] public string BookingPhone { get; set; } /// /// 订舱公司分机号 /// [SugarColumn(ColumnName = "BookingPhoneExtension")] [Description("订舱公司分机号")] public string BookingPhoneExtension { get; set; } /// /// 收货地 /// public string PLACERECEIPT { get; set; } /// /// 收货地唯一代码 /// public string PLACERECEIPTCODE { get; set; } /// /// 收货地代码 /// public string PLACERECEIPTID { get; set; } /// /// 订舱账号 /// [SugarColumn(ColumnName = "BookingAccount")] [Description("订舱账号")] public string BookingAccount { get; set; } /// /// 订舱密码 /// [SugarColumn(ColumnName = "BookingPassword")] [Description("订舱密码")] public string BookingPassword { get; set; } /// /// 操作邮箱 /// [SugarColumn(ColumnName = "OpMail")] [Description("操作邮箱")] public string OpMail { get; set; } /// /// 起始港名 /// [SugarColumn(ColumnName = "PolPortName")] [Description("起始港名")] public string PolPortName { get; set; } /// /// 目的港名 /// [SugarColumn(ColumnName = "PodPortName")] [Description("目的港名")] public string PodPortName { get; set; } /// /// 合约类型 /// [SugarColumn(ColumnName = "ContractType")] [Description("合约类型")] public string ContractType { get; set; } /// /// 运送方式 /// [SugarColumn(ColumnName = "ServiceType")] [Description("运送方式")] public string ServiceType { get; set; } /// /// 运送形态 /// [SugarColumn(ColumnName = "ServiceMode")] [Description("运送形态")] public string ServiceMode { get; set; } /// /// 联系人 /// [SugarColumn(ColumnName = "ContactName")] [Description("联系人")] public string ContactName { get; set; } /// /// 联系电话 /// [SugarColumn(ColumnName = "ContactTel")] [Description("联系电话")] public string ContactTel { get; set; } /// /// 订舱网点 /// [SugarColumn(ColumnName = "BookingAddr")] [Description("订舱网点")] public string BookingAddr { get; set; } /// /// 提单签发地 /// [SugarColumn(ColumnName = "BillSignLoc")] [Description("提单签发地")] public string BillSignLoc { get; set; } /// /// 提单数量 /// [SugarColumn(ColumnName = "BillCount")] [Description("提单数量")] public int? BillCount { get; set; } /// /// 是否接收订舱通知 /// [SugarColumn(ColumnName = "AcceptNotify")] [Description("是否接收订舱通知")] public bool AcceptNotify { get; set; } /// /// 发货人性别 /// [SugarColumn(ColumnName = "ShipperSex")] [Description("发货人性别")] public string ShipperSex { get; set; } /// /// 收货人性别 /// [SugarColumn(ColumnName = "ConsigneeSex")] [Description("收货人性别")] public string ConsigneeSex { get; set; } /// /// 通知人性别 /// [SugarColumn(ColumnName = "NotifypartSex")] [Description("通知人性别")] public string NotifypartSex { get; set; } /// /// 订舱公司性别 /// [SugarColumn(ColumnName = "BookingSex")] [Description("订舱公司性别")] public string BookingSex { get; set; } /// /// 发货人内参号码 /// [SugarColumn(ColumnName = "ShipperInnerCode")] [Description("发货人内参号码")] public string ShipperInnerCode { get; set; } /// /// 收货人内参号码 /// [SugarColumn(ColumnName = "ConsigneeInnerCode")] [Description("收货人内参号码")] public string ConsigneeInnerCode { get; set; } /// /// 通知人内参号码 /// [SugarColumn(ColumnName = "NotifypartInnerCode")] [Description("通知人内参号码")] public string NotifypartInnerCode { get; set; } /// /// 订舱公司内参号码 /// [SugarColumn(ColumnName = "BookingInnerCode")] [Description("订舱公司内参号码")] public string BookingInnerCode { get; set; } /// /// 订舱客户内参号码 /// [SugarColumn(ColumnName = "CustomerInnerCode")] [Description("订舱客户内参号码")] public string CustomerInnerCode { get; set; } /// /// 发货人邮箱 /// [SugarColumn(ColumnName = "ShipperEmail")] [Description("发货人邮箱")] public string ShipperEmail { get; set; } /// /// 收货人邮箱 /// [SugarColumn(ColumnName = "ConsigneeEmail")] [Description("收货人邮箱")] public string ConsigneeEmail { get; set; } /// /// 通知人邮箱 /// [SugarColumn(ColumnName = "NotifypartEmail")] [Description("通知人邮箱")] public string NotifypartEmail { get; set; } /// /// 订舱公司邮箱 /// [SugarColumn(ColumnName = "BookingEmail")] [Description("订舱公司邮箱")] public string BookingEmail { get; set; } /// /// 签约方 /// [SugarColumn(ColumnName = "SignType")] [Description("签约方")] public string SignType { get; set; } /// /// 复制数量 /// public int CopyNum { get; set; } /// /// 父级订单编号 /// public string ParentBookingNO { get; set; } /// /// 订舱编号 /// public string CustNO { get; set; } /// /// 约号对应的账户名 /// public string NamedAccount { get; set; } } /// /// 客户订舱 /// [SugarTable("booking_customer_order_template")] [Description("客户订舱模板")] public class BookingCustomerOrderTemplate : DBEntityTenant { /// /// 标题 /// public string Title { get; set; } /// /// 内容JSON /// public string JsonContent { get; set; } } }