using System;
using HcUtility.Core;
using Newtonsoft.Json;
namespace DSWeb.Areas.Import.Models.XXH
{
[JsonObject]
public class XXHmb : ModelObjectBillHead
{
#region 变量
#region private Fields
private string _cgid = string.Empty;
private string _name = string.Empty;
private string _country = string.Empty;
private string _AppNo = string.Empty;
private string _ValidDate = string.Empty;
private string _weight_t = string.Empty;
private string _weight = string.Empty;
private string _printedRef = string.Empty;
private string _WriteoffsRef = string.Empty;
private string _AutoAPPRef = string.Empty;
private string _ShipCompanyRef = string.Empty;
private string _CIQ_canbesearchRef = string.Empty;
private string _ReceiptStatusRef = string.Empty;
private string _AppName = string.Empty;
private string _APPREMARK = string.Empty;
private string _ZHUANJIAN_DATE = string.Empty;
private string _AutoAPPApplyId = string.Empty;
private string _AutoAPPNum = string.Empty;
private string _CORPID = string.Empty;
private DateTime? _ApplyDate = null;
public string CORPID
{
get { return _CORPID; }
set { _CORPID = value; }
}
[ModelDB]
public string ZHUANJIAN_DATE
{
get { return _ZHUANJIAN_DATE; }
set { _ZHUANJIAN_DATE = value; }
}
private string _ywtype = "import_main";
public string ywtype
{
get { return _ywtype; }
set { _ywtype = value; }
}
public string CORPNAME { get; set; }
private decimal _id = 0;
protected string _ContractNo = string.Empty;
private string _HTH = string.Empty;
private string _seller = string.Empty;
private string _company = string.Empty;
private string _companyname = string.Empty;
private string _buyer = string.Empty;
private string _STT = string.Empty;
private string _countryid = string.Empty;
private string _creator = string.Empty;
private string _Auditor = string.Empty;
private string _AuditorREF = string.Empty;
private string _Mainstate = string.Empty;
private string _MainstateRef = string.Empty;
private string _Printed = string.Empty;
private string _AutoAPP = string.Empty;
private string _ShipCompany_id = string.Empty;
private string _BillNo = string.Empty;
private string _BillType = string.Empty;
private string _BilltypeREF = string.Empty;
private string _BillTime = string.Empty;
private string _Vessel = string.Empty;
private string _Voyage = string.Empty;
private string _Ex_sailingdate = string.Empty;
private string _Sailingdate = string.Empty;
private string _ArrivalDate = null;
private string _preArrivalDate = null;
private string _ContainerNo = string.Empty;
private string _SealNo = string.Empty;
private string _TransactionMethod = string.Empty;
private string _PaymentMethods = string.Empty;
private string _TransactionMethodRef = string.Empty;
private string _PaymentMethodsRef = string.Empty;
private string _SecurityDeposit = string.Empty;
private string _CustomsReleaseDate = null;
private string _InspectionReleaseDate = null;
private string _SamplingDate_Plan = null;
private string _SamplingDate_Act = null;
private string _inspection_Signup_date = null;
private string _inspection_no = string.Empty;
private string _inspection_date = null;
private decimal _TimeMark = 0;
private string _cicode = string.Empty;
private string _ciname = string.Empty;
private string _creattime = string.Empty;
private string _Audittime = string.Empty;
private string _CIQ_licence = string.Empty;
private string _CIQ_canbesearch = string.Empty;
private string _tax_date = string.Empty;
private string _tax_paydate = string.Empty;
private string _port = string.Empty;
private string _remark = string.Empty;
private string _portRef = string.Empty;
private string _Freetime = string.Empty;
private string _Writeoffs = string.Empty;
private string _Paydate = string.Empty;
private string _Prepaydate = string.Empty;
private string _E_Billtime = string.Empty;
private string _HDtime = string.Empty;
private string _FinanceStatus = string.Empty;
private string _FinanceStatusREF = string.Empty;
private string _remark_2 = string.Empty;
private string _remark_3 = string.Empty;
private string _remark_4 = string.Empty;
private string _Sampling_need = string.Empty;
private string _Sampling_needREF = string.Empty;
private string _DeclareNumber = string.Empty;
private string _Inspection_Storage = string.Empty;
private string _Inspection_StorageREF = string.Empty;
private string _DeliveryDate = string.Empty;
private string _DeliveryAddress = string.Empty;
private string _Contacter = string.Empty;
private string _Tel = string.Empty;
private string _Overfilled = string.Empty;
private string _OwnApp = string.Empty;
private string _ReceiptStatus = string.Empty;
private string _Receiptremark = string.Empty;
private string _TRADINGAGENCY = string.Empty;
private string _FactoryNo = string.Empty;
private string _ACCDATE = string.Empty;
private string _ContractStatus = string.Empty;
private string _KCClear = string.Empty;
private string _ISVOU = string.Empty;
private string _VOUCHERNO = string.Empty;
private string _RCVMode = string.Empty;
private string _RCVModeREF = string.Empty;
private string _OP = string.Empty;
private string _Maoli = string.Empty;
private string _FHPROFIT = string.Empty;
private string _LCPROFIT = string.Empty;
private string _OTPROFIT = string.Empty;
private string _ZMQ = string.Empty;
private string _MZBZ = string.Empty;
private string _MZBZREF = string.Empty;
private string _RecDate = string.Empty;
private string _PortDays = string.Empty;
private string _BUZTYPE = string.Empty;
private string _BUZTYPEREF = string.Empty;
private string _APPWEIGHT = string.Empty;
private string _SELLERFULLNAME = string.Empty;
private string _Exporter = string.Empty;
private string _Inspection_Buyer = string.Empty;
private string _Inspection_BuyerRef = string.Empty;
private string _Inspection_Contacter = string.Empty;
private string _Inspection_Tel = string.Empty;
private string _Inspection_Email = string.Empty;
private string _Inspection_Code = string.Empty;
private string _Inspection_DeliveryAddress = string.Empty;
private string _HaveContract = string.Empty; //是否有合同
private string _HaveCargoMark = string.Empty; //是否有商品标签
private string _Productiondate = string.Empty;
private string _BZTCHNO = string.Empty;
private string _appusedweight = string.Empty;
private string _HK_profit = string.Empty;
private string _RZ_profit = string.Empty;
private string _HAVESAMPLE = string.Empty;
private string _CHECKSAMPLE = string.Empty;
private string _price = string.Empty;
private string _price_agio = string.Empty;
private string _CTN = string.Empty;
private string _BILLTRANCNO = string.Empty;
private string _SBYS = string.Empty;
private string _BILL_RECEIVE_DATE = string.Empty;
private string _BILL_SEND_DATE = string.Empty;
private string _LOCK_EXCHANGERATE = string.Empty;
private string _EXCHANGERATE = string.Empty;
private string _Unsealdate = string.Empty;
private string _ISREFORM = string.Empty;
private string _InspectionNo = string.Empty;
private string _IsRongZi = string.Empty;
private string _MBLNOREPEAT = string.Empty;
private string _LOADFINISH = "1";
private string _TRADECOUNTRY = string.Empty;
private string _TRADECOUNTRY_REF = string.Empty;
private string _CIQDATE = "";
private string _VSIGN = "0";
private string _HTDATE = string.Empty;
#endregion
#region 公有函数
#region 查询用函数
[ModelDB]
public int? InventoryState { get; set; }
public string InventoryStateRef { get; set; }
public string country
{
get { return _country; }
set { _country = value; }
}
public string cgid
{
get { return _cgid; }
set { _cgid = value; }
}
public string name
{
get { return _name; }
set { _name = value; }
}
public string AppNo
{
get { return _AppNo; }
set { _AppNo = value; }
}
public string ValidDate
{
get { return _ValidDate; }
set { _ValidDate = value; }
}
public string weight_t
{
get { return _weight_t; }
set { _weight_t = value; }
}
public string weight
{
get { return _weight; }
set { _weight = value; }
}
public string AutoAPPRef
{
get { return _AutoAPPRef; }
set { _AutoAPPRef = value; }
}
public string printedRef
{
get { return _printedRef; }
set { _printedRef = value; }
}
public string WriteoffsRef
{
get { return _WriteoffsRef; }
set { _WriteoffsRef = value; }
}
public string AppName
{
get { return _AppName; }
set { _AppName = value; }
}
public string APPREMARK
{
get { return _APPREMARK; }
set { _APPREMARK = value; }
}
#endregion
[ModelDB(MDBType = ModelDBOprationType.EditDelete, IsPrimary = true)]
public decimal id
{
get { return _id; }
set { _id = value; }
}
[ModelDB]
public string ContractNo
{
get { return _ContractNo; }
set { _ContractNo = value; }
}
[ModelDB]
public string HTH
{
get { return _HTH; }
set { _HTH = value; }
}
[ModelDB]
public string HTDATE
{
get { return _HTDATE; }
set {
if (!string.IsNullOrEmpty(value))
{
_HTDATE = value;
}
else
{
_HTDATE = string.Empty;
}
}
}
[ModelDB]
public string company
{
get { return _company; }
set { _company = value; }
}
[ModelDB]
public string PORTLOAD { get; set; }
public string companyname
{
get { return _companyname; }
set { _companyname = value; }
}
[ModelDB]
public string seller
{
get { return _seller; }
set { _seller = value; }
}
[ModelDB]
public string buyer
{
get { return _buyer; }
set { _buyer = value; }
}
[ModelDB]
public string STT
{
get { return _STT; }
set { _STT = value; }
}
[ModelDB]
public string countryid
{
get { return _countryid; }
set { _countryid = value; }
}
//[ModelDB]
public string creator
{
get { return _creator; }
set { _creator = value; }
}
public string RECEIVE_MAN { get; set; }
//[ModelDB]
public string Auditor
{
get { return _Auditor; }
set { _Auditor = value; }
}
public string AuditorREF
{
get { return _AuditorREF; }
set { _AuditorREF = value; }
}
[ModelDB]
public string Mainstate
{
get { return _Mainstate; }
set { _Mainstate = value; }
}
public string MainstateRef
{
get { return _MainstateRef; }
set { _MainstateRef = value; }
}
[ModelDB]
public string Printed
{
get { return _Printed; }
set { _Printed = value; }
}
[ModelDB]
public string AutoAPP
{
get { return _AutoAPP; }
set { _AutoAPP = value; }
}
[ModelDB]
public string AutoAPPApplyId
{
get { return _AutoAPPApplyId; }
set { _AutoAPPApplyId = value; }
}
[ModelDB]
public string AutoAPPNum
{
get { return _AutoAPPNum; }
set { _AutoAPPNum = value; }
}
[ModelDB]
public DateTime? ApplyDate
{
get { return _ApplyDate; }
set { _ApplyDate = value; }
}
[ModelDB]
public string ShipCompany_id
{
get { return _ShipCompany_id; }
set { _ShipCompany_id = value; }
}
public string ShipCompanyRef
{
get { return _ShipCompanyRef; }
set { _ShipCompanyRef = value; }
}
[ModelDB]
public string BillNo
{
get { return _BillNo; }
set { _BillNo = value; }
}
[ModelDB]
public string BillType
{
get { return _BillType; }
set { _BillType = value; }
}
public string BillTypeREF
{
get { return _BilltypeREF; }
set { _BilltypeREF = value; }
}
[ModelDB]
public string BillTime
{
get { return _BillTime; }
set { _BillTime = value; }
}
[ModelDB]
public string Vessel
{
get { return _Vessel; }
set { _Vessel = value; }
}
[ModelDB]
public string Voyage
{
get { return _Voyage; }
set { _Voyage = value; }
}
[ModelDB]
public String Ex_sailingdate
{
get { return _Ex_sailingdate; }
set { _Ex_sailingdate = value; }
}
[ModelDB]
public String Sailingdate
{
get { return _Sailingdate; }
set { _Sailingdate = value; }
}
[ModelDB]
public String ArrivalDate
{
get { return _ArrivalDate; }
set { _ArrivalDate = value; }
}
[ModelDB]
public String preArrivalDate
{
get { return _preArrivalDate; }
set { _preArrivalDate = value; }
}
[ModelDB]
public string ContainerNo
{
get { return _ContainerNo; }
set { _ContainerNo = value; }
}
[ModelDB]
public string SealNo
{
get { return _SealNo; }
set { _SealNo = value; }
}
[ModelDB]
public string TransactionMethod
{
get { return _TransactionMethod; }
set { _TransactionMethod = value; }
}
[ModelDB]
public string PaymentMethods
{
get { return _PaymentMethods; }
set { _PaymentMethods = value; }
}
public string TransactionMethodRef
{
get { return _TransactionMethodRef; }
set { _TransactionMethodRef = value; }
}
public string PaymentMethodsRef
{
get { return _PaymentMethodsRef; }
set { _PaymentMethodsRef = value; }
}
[ModelDB]
public string SecurityDeposit
{
get { return _SecurityDeposit; }
set { _SecurityDeposit = value; }
}
[ModelDB]
public string CustomsReleaseDate
{
get { return _CustomsReleaseDate; }
set { _CustomsReleaseDate = value; }
}
[ModelDB]
public string InspectionReleaseDate
{
get { return _InspectionReleaseDate; }
set { _InspectionReleaseDate = value; }
}
[ModelDB]
public string SamplingDate_Plan
{
get { return _SamplingDate_Plan; }
set { _SamplingDate_Plan = value; }
}
[ModelDB]
public string SamplingDate_Act
{
get { return _SamplingDate_Act; }
set { _SamplingDate_Act = value; }
}
[ModelDB]
public string inspection_Signup_date
{
get { return _inspection_Signup_date; }
set { _inspection_Signup_date = value; }
}
[ModelDB]
public string inspection_no
{
get { return _inspection_no; }
set { _inspection_no = value; }
}
[ModelDB]
public string inspection_date
{
get { return _inspection_date; }
set { _inspection_date = value; }
}
[ModelDB]
public string creattime
{
get { return _creattime; }
set { _creattime = value; }
}
[ModelDB]
public string Audittime
{
get { return _Audittime; }
set { _Audittime = value; }
}
[ModelDB]
public string Freetime
{
get { return _Freetime; }
set { _Freetime = value; }
}
[ModelDB]
public string CIQ_licence
{
get { return _CIQ_licence; }
set { _CIQ_licence = value; }
}
[ModelDB]
public string CIQ_canbesearch
{
get { return _CIQ_canbesearch; }
set { _CIQ_canbesearch = value; }
}
[ModelDB]
public string tax_date
{
get { return _tax_date; }
set { _tax_date = value; }
}
[ModelDB]
public string tax_paydate
{
get { return _tax_paydate; }
set { _tax_paydate = value; }
}
//[ModelDB]
public string port
{
get { return _port; }
set { _port = value; }
}
[ModelDB]
public string remark
{
get { return _remark; }
set { _remark = value; }
}
[ModelDB]
public string Writeoffs
{
get { return _Writeoffs; }
set { _Writeoffs = value; }
}
///
/// /////////////
///
[ModelDB]
public string Paydate
{
get { return _Paydate; }
set { _Paydate = value; }
}
[ModelDB]
public string Prepaydate
{
get { return _Prepaydate; }
set { _Prepaydate = value; }
}
[ModelDB]
public string E_Billtime
{
get { return _E_Billtime; }
set { _E_Billtime = value; }
}
[ModelDB]
public string HDtime
{
get { return _HDtime; }
set { _HDtime = value; }
}
[ModelDB]
public string FinanceStatus
{
get { return _FinanceStatus; }
set { _FinanceStatus = value; }
}
public string FinanceStatusREF
{
get { return _FinanceStatusREF; }
set { _FinanceStatusREF = value; }
}
[ModelDB]
public string remark_2
{
get { return _remark_2; }
set { _remark_2 = value; }
}
[ModelDB]
public string remark_3
{
get { return _remark_3; }
set { _remark_3 = value; }
}
[ModelDB]
public string remark_4
{
get { return _remark_4; }
set { _remark_4 = value; }
}
[ModelDB]
public string Sampling_need
{
get { return _Sampling_need; }
set { _Sampling_need = value; }
}
public string Sampling_needREF
{
get { return _Sampling_needREF; }
set { _Sampling_needREF = value; }
}
[ModelDB]
public string DeclareNumber
{
get { return _DeclareNumber; }
set { _DeclareNumber = value; }
}
[ModelDB]
public string Inspection_Storage
{
get { return _Inspection_Storage; }
set { _Inspection_Storage = value; }
}
public string Inspection_StorageREF
{
get { return _Inspection_StorageREF; }
set { _Inspection_StorageREF = value; }
}
[ModelDB]
public string DeliveryDate
{
get { return _DeliveryDate; }
set { _DeliveryDate = value; }
}
[ModelDB]
public string DeliveryAddress
{
get { return _DeliveryAddress; }
set { _DeliveryAddress = value; }
}
[ModelDB]
public string Contacter
{
get { return _Contacter; }
set { _Contacter = value; }
}
[ModelDB]
public string Tel
{
get { return _Tel; }
set { _Tel = value; }
}
[ModelDB]
public string Overfilled
{
get { return _Overfilled; }
set { _Overfilled = value; }
}
[ModelDB]
public string ReceiptStatus
{
get { return _ReceiptStatus; }
set { _ReceiptStatus = value; }
}
[ModelDB]
public string Receiptremark
{
get { return _Receiptremark; }
set { _Receiptremark = value; }
}
[ModelDB]
public string TRADINGAGENCY
{
get { return _TRADINGAGENCY; }
set { _TRADINGAGENCY = value; }
}
[ModelDB]
public string KCClear
{
get { return _KCClear; }
set { _KCClear = value; }
}
[ModelDB]
public string RCVMode
{
get { return _RCVMode; }
set { _RCVMode = value; }
}
public string RCVModeREF
{
get { return _RCVModeREF; }
set { _RCVModeREF = value; }
}
//[ModelDB]
public string ACCDATE
{
get { return _ACCDATE; }
set { _ACCDATE = value; }
}
//[ModelDB]
public string ContractStatus
{
get { return _ContractStatus; }
set { _ContractStatus = value; }
}
public string ISVOU
{
get { return _ISVOU; }
set { _ISVOU = value; }
}
public string VOUCHERNO
{
get { return _VOUCHERNO; }
set { _VOUCHERNO = value; }
}
//[ModelDB]
public string OwnApp
{
get { return _OwnApp; }
set { _OwnApp = value; }
}
public string portRef
{
get { return _portRef; }
set { _portRef = value; }
}
public decimal TimeMark
{
get { return _TimeMark; }
set { _TimeMark = value; }
}
public string cicode
{
get { return _cicode; }
set { _cicode = value; }
}
public string ciname
{
get { return _ciname; }
set { _ciname = value; }
}
public string CIQ_canbesearchRef
{
get { return _CIQ_canbesearchRef; }
set { _CIQ_canbesearchRef = value; }
}
public string ReceiptStatusRef
{
get { return _ReceiptStatusRef; }
set { _ReceiptStatusRef = value; }
}
public string FactoryNo
{
get { return _FactoryNo; }
set { _FactoryNo = value; }
}
public string OP
{
get { return _OP; }
set { _OP = value; }
}
public string Maoli
{
get { return _Maoli; }
set { _Maoli = value; }
}
public string FHPROFIT
{
get { return _FHPROFIT; }
set { _FHPROFIT = value; }
}
public string LCPROFIT
{
get { return _LCPROFIT; }
set { _LCPROFIT = value; }
}
public string OTPROFIT
{
get { return _OTPROFIT; }
set { _OTPROFIT = value; }
}
public string HK_profit
{
get { return _HK_profit; }
set { _HK_profit = value; }
}
public string RZ_profit
{
get { return _RZ_profit; }
set { _RZ_profit = value; }
}
public string ZMQ
{
get { return _ZMQ; }
set { _ZMQ = value; }
}
[ModelDB]
public string MZBZ
{
get { return _MZBZ; }
set { _MZBZ = value; }
}
public string MZBZREF
{
get { return _MZBZREF; }
set { _MZBZREF = value; }
}
[ModelDB]
public string RecDate
{
get { return _RecDate; }
set { _RecDate = value; }
}
[ModelDB]
public string PortDays
{
get { return _PortDays; }
set { _PortDays = value; }
}
[ModelDB]
public string BUZTYPE
{
get { return _BUZTYPE; }
set { _BUZTYPE = value; }
}
public string BUZTYPEREF
{
get { return _BUZTYPEREF; }
set { _BUZTYPEREF = value; }
}
public string APPWEIGHT
{
get { return _APPWEIGHT; }
set { _APPWEIGHT = value; }
}
public string SELLERFULLNAME
{
get { return _SELLERFULLNAME; }
set { _SELLERFULLNAME = value; }
}
public string Exporter
{
get { return _Exporter; }
set { _Exporter = value; }
}
public string Exporter2
{
get { return _Exporter; }
set { _Exporter = value; }
}
//20150916 新协航要求 增加三个应对商检系统的数据项
[ModelDB]
public string Inspection_Buyer
{
get { return _Inspection_Buyer; }
set { _Inspection_Buyer = value; }
}
public string Inspection_BuyerRef
{
get { return _Inspection_BuyerRef; }
set { _Inspection_BuyerRef = value; }
}
public string Inspection_Contacter
{
get { return _Inspection_Contacter; }
set { _Inspection_Contacter = value; }
}
public string Inspection_Tel
{
get { return _Inspection_Tel; }
set { _Inspection_Tel = value; }
}
public string Inspection_DeliveryAddress
{
get { return _Inspection_DeliveryAddress; }
set { _Inspection_DeliveryAddress = value; }
}
public string Inspection_Email
{
get { return _Inspection_Email; }
set { _Inspection_Email = value; }
}
public string Inspection_Code
{
get { return _Inspection_Code; }
set { _Inspection_Code = value; }
}
public string HaveContract
{
get { return _HaveContract; }
set { _HaveContract = value; }
}
public string HaveCargoMark
{
get { return _HaveCargoMark; }
set { _HaveCargoMark = value; }
}
public string Productiondate
{
get { return _Productiondate; }
set { _Productiondate = value; }
}
public string BZTCHNO
{
get { return _BZTCHNO; }
set { _BZTCHNO = value; }
}
public string appusedweight
{
get { return _appusedweight; }
set { _appusedweight = value; }
}
public string HAVESAMPLE
{
get { return _HAVESAMPLE; }
set { _HAVESAMPLE = value; }
}
public string CHECKSAMPLE
{
get { return _CHECKSAMPLE; }
set { _CHECKSAMPLE = value; }
}
public string price
{
get { return _price; }
set { _price = value; }
}
public string price_agio
{
get { return _price_agio; }
set { _price_agio = value; }
}
[ModelDB]
public string CTN
{
get { return _CTN; }
set { _CTN = value; }
}
[ModelDB]
public string BILLTRANCNO
{
get { return _BILLTRANCNO; }
set { _BILLTRANCNO = value; }
}
public string SBYS
{
get { return _SBYS; }
set { _SBYS = value; }
}
public string BILL_RECEIVE_DATE
{
get { return _BILL_RECEIVE_DATE; }
set { _BILL_RECEIVE_DATE = value; }
}
public string BILL_SEND_DATE
{
get { return _BILL_SEND_DATE; }
set { _BILL_SEND_DATE = value; }
}
[ModelDB]
public string LOCK_EXCHANGERATE
{
get { return _LOCK_EXCHANGERATE; }
set { _LOCK_EXCHANGERATE = value; }
}
[ModelDB]
public string EXCHANGERATE
{
get { return _EXCHANGERATE; }
set { _EXCHANGERATE = value; }
}
[ModelDB]
public string Unsealdate
{
get { return _Unsealdate; }
set { _Unsealdate = value; }
}
[ModelDB]
public string ISREFORM
{
get { return _ISREFORM; }
set { _ISREFORM = value; }
}
public string InspectionNo
{
get { return _InspectionNo; }
set { _InspectionNo = value; }
}
public string IsRongZi
{
get { return _IsRongZi; }
set { _IsRongZi = value; }
}
public string MBLNOREPEAT
{
get { return _MBLNOREPEAT; }
set { _MBLNOREPEAT = value; }
}
public string LOADFINISH
{//永远都是1 用于在主表的编辑页面setvalues时最后触发change事件
get { return _LOADFINISH; }
set { _LOADFINISH = value; }
}
private string _Agent = string.Empty;
private string _Agent2 = string.Empty;
private string _Agent3 = string.Empty;
[ModelDB]
public string Agent
{
get { return _Agent; }
set { _Agent = value; }
}
public string Agent2
{
get { return _Agent2; }
set { _Agent2 = value; }
}
public string Agent3
{
get { return _Agent3; }
set { _Agent3 = value; }
}
private string _CreateTime_2 = string.Empty;
private string _ResendTime = string.Empty;
private string _Dock = string.Empty;
private string _Customs_broker = string.Empty;
private string _inspection_broker = string.Empty;
[ModelDB]
public string CreateTime_2
{
get { return _CreateTime_2; }
set { _CreateTime_2 = value; }
}
[ModelDB]
public string ResendTime
{
get { return _ResendTime; }
set { _ResendTime = value; }
}
[ModelDB]
public string Dock
{
get { return _Dock; }
set { _Dock = value; }
}
[ModelDB]
public string Customs_broker
{
get { return _Customs_broker; }
set { _Customs_broker = value; }
}
[ModelDB]
public string inspection_broker
{
get { return _inspection_broker; }
set { _inspection_broker = value; }
}
[ModelDB]
public string TRADECOUNTRY
{
get { return _TRADECOUNTRY; }
set { _TRADECOUNTRY = value; }
}
public string TRADECOUNTRY_REF
{
get { return _TRADECOUNTRY_REF; }
set { _TRADECOUNTRY_REF = value; }
}
[ModelDB]
public string CIQDATE
{
get { return _CIQDATE; }
set { _CIQDATE = value; }
}
[ModelDB]
public string VSIGN
{
get { return _VSIGN; }
set { _VSIGN = value; }
}
private string _UnitRef = string.Empty;
private string _U_weight = string.Empty;
public string UnitRef
{
get { return _UnitRef; }
set { _UnitRef = value; }
}
public string U_weight
{
get { return _U_weight; }
set { _U_weight = value; }
}
private string _MODIFIEDTIME = string.Empty;
public string MODIFIEDTIME
{
get { return _MODIFIEDTIME; }
set { _MODIFIEDTIME = value; }
}
private string _MODIFIEDUSER = string.Empty;
public string MODIFIEDUSER
{
get { return _MODIFIEDUSER; }
set { _MODIFIEDUSER = value; }
}
#endregion
#endregion
#region 后期添加
//20161219 新协航张翠 通关单号
private string _ClearanceNo = string.Empty;
[ModelDB]
public string ClearanceNo
{
get { return _ClearanceNo; }
set { _ClearanceNo = value; }
}
#endregion
public XXHmb()
{
// TableName = "tMsWlPcHead";
TableName = "Import_main";
}
public override string GetBillNoFieldName()
{
return "ContractNo";
}
}
[JsonObject]
public class XXHcountryDAL : ModelObjectBase
{
#region private Fields
private string _countryid = string.Empty;
private string _country = string.Empty;
[ModelDB]
public string countryid
{
get { return _countryid; }
set { _countryid = value; }
}
[ModelDB]
public string country
{
get { return _country; }
set { _country = value; }
}
#endregion
public XXHcountryDAL()
{
// TableName = "tMsWlPcHead";
TableName = "code_country";
}
}
#region 单据表 Receiptmb
[JsonObject]
public class Receiptmb : ModelObjectBillBody
{
#region private Fields
private string _id = string.Empty;
private string _ContractNo = string.Empty;
private string _Receiptid = string.Empty;
private string _ReceiptName = string.Empty;
private string _ReceiptNo = string.Empty;
private string _state = string.Empty;
private string _statename = string.Empty;
private string _Send_date = string.Empty;
private string _receive_date = string.Empty;
private string _repeat_date = string.Empty;
private string _trancer = string.Empty;
private string _trancNo = string.Empty;
private string _remark = string.Empty;
[ModelDB(MDBType = ModelDBOprationType.All, IsPrimary = true)]
public string id
{
get { return _id; }
set { _id = value; }
}
[ModelDB]
public string ContractNo
{
get { return _ContractNo; }
set { _ContractNo = value; }
}
[ModelDB]
public string Receiptid
{
get { return _Receiptid; }
set { _Receiptid = value; }
}
// [ModelDB]
public string ReceiptName
{
get { return _ReceiptName; }
set { _ReceiptName = value; }
}
[ModelDB]
public string ReceiptNo
{
get { return _ReceiptNo; }
set { _ReceiptNo = value; }
}
[ModelDB]
public string state
{
get { return _state; }
set { _state = value; }
}
public string statename
{
get { return _statename; }
set { _statename = value; }
}
[ModelDB]
public string Send_date
{
get { return _Send_date; }
set { _Send_date = value; }
}
[ModelDB]
public string receive_date
{
get { return _receive_date; }
set { _receive_date = value; }
}
[ModelDB]
public string repeat_date
{
get { return _repeat_date; }
set { _repeat_date = value; }
}
[ModelDB]
public string trancer
{
get { return _trancer; }
set { _trancer = value; }
}
[ModelDB]
public string trancNo
{
get { return _trancNo; }
set { _trancNo = value; }
}
[ModelDB]
public string remark
{
get { return _remark; }
set { _remark = value; }
}
#endregion
public Receiptmb()
{
TableName = "Import_Receipt";
}
public override string GetBillNoFieldName()
{
return "ContractNo";
}
}
#endregion
#region 新的单据表 RECEIPTmb
[JsonObject]
public class RECEIPTmb : ModelObjectBillBody
{
#region private Fields
private string _GID = string.Empty;
private string _BSNO = string.Empty;
private string _RECEIPTNO = string.Empty;
private string _RECEIPTTYPE = string.Empty;
private string _RECEIVE_MAN = string.Empty;
private string _RECEIVE_DATE = string.Empty;
private string _SEND_MAN = string.Empty;
private string _SEND_DATE = string.Empty;
private string _TRANCER = string.Empty;
private string _TRANCNO = string.Empty;
private string _ISREPEAT = string.Empty;
private string _REPEAT_MAN = string.Empty;
private string _REPEAT_DATE = string.Empty;
private string _ISRECEIVE = string.Empty;
private string _RETURN_MAN = string.Empty;
private string _RETURN_DATE = string.Empty;
private string _RETURN_TRANCER = string.Empty;
private string _RETURN_TRANCNO = string.Empty;
private string _REMARK = string.Empty;
private string _CORPID = string.Empty;
private string _CREATEUSER = string.Empty;
private string _CREATETIME = string.Empty;
private string _MODIFIEDUSER = string.Empty;
private string _MODIFIEDTIME = string.Empty;
[ModelDB(MDBType = ModelDBOprationType.EditDelete, IsPrimary = true)]
public string GID
{
get { return _GID; }
set { _GID = value; }
}
[ModelDB]
public string BSNO
{
get { return _BSNO; }
set { _BSNO = value; }
}
[ModelDB]
public string RECEIPTNO
{
get { return _RECEIPTNO; }
set { _RECEIPTNO = value; }
}
[ModelDB]
public string RECEIPTTYPE
{
get { return _RECEIPTTYPE; }
set { _RECEIPTTYPE = value; }
}
[ModelDB]
public string RECEIVE_MAN
{
get { return _RECEIVE_MAN; }
set { _RECEIVE_MAN = value; }
}
[ModelDB]
public string RECEIVE_DATE
{
get { return _RECEIVE_DATE; }
set { _RECEIVE_DATE = value; }
}
[ModelDB]
public string SEND_MAN
{
get { return _SEND_MAN; }
set { _SEND_MAN = value; }
}
[ModelDB]
public string SEND_DATE
{
get { return _SEND_DATE; }
set { _SEND_DATE = value; }
}
[ModelDB]
public string TRANCER
{
get { return _TRANCER; }
set { _TRANCER = value; }
}
[ModelDB]
public string TRANCNO
{
get { return _TRANCNO; }
set { _TRANCNO = value; }
}
[ModelDB]
public string ISREPEAT
{
get { return _ISREPEAT; }
set { _ISREPEAT = value; }
}
[ModelDB]
public string REPEAT_MAN
{
get { return _REPEAT_MAN; }
set { _REPEAT_MAN = value; }
}
[ModelDB]
public string REPEAT_DATE
{
get { return _REPEAT_DATE; }
set { _REPEAT_DATE = value; }
}
[ModelDB]
public string ISRECEIVE
{
get { return _ISRECEIVE; }
set { _ISRECEIVE = value; }
}
[ModelDB]
public string RETURN_MAN
{
get { return _RETURN_MAN; }
set { _RETURN_MAN = value; }
}
[ModelDB]
public string RETURN_DATE
{
get { return _RETURN_DATE; }
set { _RETURN_DATE = value; }
}
[ModelDB]
public string RETURN_TRANCER
{
get { return _RETURN_TRANCER; }
set { _RETURN_TRANCER = value; }
}
[ModelDB]
public string RETURN_TRANCNO
{
get { return _RETURN_TRANCNO; }
set { _RETURN_TRANCNO = value; }
}
[ModelDB]
public string REMARK
{
get { return _REMARK; }
set { _REMARK = value; }
}
[ModelDB]
public string CORPID
{
get { return _CORPID; }
set { _CORPID = value; }
}
[ModelDB]
public string CREATEUSER
{
get { return _CREATEUSER; }
set { _CREATEUSER = value; }
}
[ModelDB]
public string CREATETIME
{
get { return _CREATETIME; }
set { _CREATETIME = value; }
}
[ModelDB]
public string MODIFIEDUSER
{
get { return _MODIFIEDUSER; }
set { _MODIFIEDUSER = value; }
}
[ModelDB]
public string MODIFIEDTIME
{
get { return _MODIFIEDTIME; }
set { _MODIFIEDTIME = value; }
}
#endregion
public RECEIPTmb()
{
TableName = "OP_Receipt";
}
public override string GetBillNoFieldName()
{
return "BSNO";
}
}
#endregion
#region 货物表 Cargomb
[JsonObject]
public class Cargomb : ModelObjectBillBody
{
#region private Fields
private string _id = string.Empty;
private string _GID = string.Empty;
private string _ContractNo = string.Empty;
private string _cargoinfo_id = string.Empty;
private string _cargociq_id = string.Empty;
private string _name = string.Empty;
private string _Unit = string.Empty;
private string _UnitRate = string.Empty;
private string _U_PRICE = string.Empty;
private string _U_weight = string.Empty;
private string _weight = string.Empty;
private string _m_weight = string.Empty;
private string _price = string.Empty;
private string _price_agio = string.Empty;
private string _price_limit = string.Empty;
private string _Amount = string.Empty;
private string _tax_Amount = string.Empty;
private string _tax_Amount_RMB = string.Empty;
private string _pay_Amount = string.Empty;
private string _BoxCount = string.Empty;
private string _BoxWeight = string.Empty;
private string _Exporter = string.Empty;
private string _FactoryNo = string.Empty;
private string _ICP = string.Empty;
private string _Productiondate = string.Empty;
private string _currid = string.Empty;
private string _prepayments = string.Empty;
private string _balance = string.Empty;
private string _pay_prepayments = string.Empty;
private string _pay_balance = string.Empty;
private string _Paypart = string.Empty;
private string _baolv = string.Empty;
private string _tariff = string.Empty;
private string _tax = string.Empty;
private string _tax_zz = string.Empty;
private string _tax_cl = string.Empty;
private string _Declarenumber = string.Empty;
private string _Exchangerate = string.Empty;
private string _Exchangerate_Customs = string.Empty;
private string _tax_1 = string.Empty;
private string _tax_2 = string.Empty;
private string _tax_zz_1 = string.Empty;
private string _tax_zz_2 = string.Empty;
private string _PreProportion = "0";
private string _RecProportion = "0";
private string _AMOUNT_WRITEOFFS = string.Empty;
private string _NAME_REF = string.Empty;
private string _SEQUENCE = string.Empty;
private string _Ename = string.Empty;
private string _SBYS = string.Empty;
private string _BZTCHNO = string.Empty;
private string _CargoType = string.Empty;
private string _REMARK = string.Empty;
private string _cgid = string.Empty;
private string _SPECIFICATIONS = string.Empty;
private string _SHIJIGUANSHUI = string.Empty;
private string _SHIJIZENGZHISHUI = string.Empty;
private string _XIANJIAJINE = string.Empty;
private string _BAOZHENGJIN = string.Empty;
private string _ZHIBAOJIN = string.Empty;
private string _ZONGJINE = string.Empty;
//20191009 保质期 已经于北京二商项目实现
//private string _EXPIRATIONDATE = string.Empty;
#endregion
#region 访问方法
[ModelDB]
public string XIANJIAJINE
{
get { return _XIANJIAJINE; }
set { _XIANJIAJINE = value; }
}
[ModelDB]
public string AGENCRATE
{
get;
set;
}
[ModelDB]
public string BAOZHENGJIN
{
get { return _BAOZHENGJIN; }
set { _BAOZHENGJIN = value; }
}
[ModelDB]
public string t_weight { get; set; }
[ModelDB]
public string ZHIBAOJIN
{
get { return _ZHIBAOJIN; }
set { _ZHIBAOJIN = value; }
}
[ModelDB]
public string ZONGJINE
{
get { return _ZONGJINE; }
set { _ZONGJINE = value; }
}
[ModelDB]
public string SHIJIGUANSHUI
{
get { return _SHIJIGUANSHUI; }
set { _SHIJIGUANSHUI = value; }
}
[ModelDB]
public string SHIJIZENGZHISHUI
{
get { return _SHIJIZENGZHISHUI; }
set { _SHIJIZENGZHISHUI = value; }
}
[ModelDB(MDBType = ModelDBOprationType.EditDelete, IsPrimary = true)]
public string id
{
get { return _id; }
set { _id = value; }
}
public string cgid//仅用于解析将cgid当作import_cargo.id的数据结构
{
get { return _cgid; }
set { _cgid = value; }
}
[ModelDB]
public string GID
{
get { return _GID; }
set { _GID = value; }
}
[ModelDB]
public string ContractNo
{
get { return _ContractNo; }
set { _ContractNo = value; }
}
[ModelDB]
public string cargoinfo_id
{
get { return _cargoinfo_id; }
set { _cargoinfo_id = value; }
}
[ModelDB]
public string cargociq_id
{
get { return _cargociq_id; }
set { _cargociq_id = value; }
}
[ModelDB]
public string name
{
get { return _name; }
set { _name = value; }
}
[ModelDB]
public string Unit
{
get { return _Unit; }
set { _Unit = value; }
}
public string UnitRate
{
get { return _UnitRate; }
set { _UnitRate = value; }
}
[ModelDB]
public string U_PRICE
{
get { return _U_PRICE; }
set { _U_PRICE = value; }
}
[ModelDB]
public string U_weight
{
get { return _U_weight; }
set { _U_weight = value; }
}
[ModelDB]
public string weight
{
get { return _weight; }
set { _weight = value; }
}
[ModelDB]
public string m_weight
{
get { return _m_weight; }
set { _m_weight = value; }
}
[ModelDB]
public string price
{
get { return _price; }
set { _price = value; }
}
[ModelDB]
public string price_agio
{
get { return _price_agio; }
set { _price_agio = value; }
}
[ModelDB]
public string price_limit
{
get { return _price_limit; }
set { _price_limit = value; }
}
[ModelDB]
public string Amount
{
get { return _Amount; }
set { _Amount = value; }
}
[ModelDB]
public string tax_Amount
{
get { return _tax_Amount; }
set { _tax_Amount = value; }
}
public string tax_Amount_RMB
{
get { return _tax_Amount_RMB; }
set { _tax_Amount_RMB = value; }
}
[ModelDB]
public string pay_Amount
{
get { return _pay_Amount; }
set { _pay_Amount = value; }
}
[ModelDB]
public string BoxCount
{
get { return _BoxCount; }
set { _BoxCount = value; }
}
[ModelDB]
public string BoxWeight
{
get { return _BoxWeight; }
set { _BoxWeight = value; }
}
[ModelDB]
public string Exporter
{
get { return _Exporter; }
set { _Exporter = value; }
}
[ModelDB]
public string FactoryNo
{
get { return _FactoryNo; }
set { _FactoryNo = value; }
}
[ModelDB]
public string ICP
{
get { return _ICP; }
set { _ICP = value; }
}
[ModelDB]
public string Productiondate
{
get { return _Productiondate; }
set { _Productiondate = value; }
}
[ModelDB]
public string currid
{
get { return _currid; }
set { _currid = value; }
}
/* public string currRef
{
get { return _currRef; }
set { _currRef = value; }
} */
[ModelDB]
public string prepayments
{
get { return _prepayments; }
set { _prepayments = value; }
}
[ModelDB]
public string balance
{
get { return _balance; }
set { _balance = value; }
}
[ModelDB]
public string pay_prepayments
{
get { return _pay_prepayments; }
set { _pay_prepayments = value; }
}
[ModelDB]
public string pay_balance
{
get { return _pay_balance; }
set { _pay_balance = value; }
}
[ModelDB]
public string Paypart
{
get { return _Paypart; }
set { _Paypart = value; }
}
[ModelDB]
public string baolv
{
get { return _baolv; }
set { _baolv = value; }
}
[ModelDB]
public string tariff
{
get { return _tariff; }
set { _tariff = value; }
}
[ModelDB]
public string tax
{
get { return _tax; }
set { _tax = value; }
}
[ModelDB]
public string tax_zz
{
get { return _tax_zz; }
set { _tax_zz = value; }
}
[ModelDB]
public string tax_cl
{
get { return _tax_cl; }
set { _tax_cl = value; }
}
[ModelDB]
public string Declarenumber
{
get { return _Declarenumber; }
set { _Declarenumber = value; }
}
[ModelDB]
public string Exchangerate
{
get { return _Exchangerate; }
set { _Exchangerate = value; }
}
[ModelDB]
public string Exchangerate_Customs
{
get { return _Exchangerate_Customs; }
set { _Exchangerate_Customs = value; }
}//Exchangerate_Customs
[ModelDB]
public string tax_1
{
get { return _tax_1; }
set { _tax_1 = value; }
}//
[ModelDB]
public string tax_2
{
get { return _tax_2; }
set { _tax_2 = value; }
}//
[ModelDB]
public string tax_zz_1
{
get { return _tax_zz_1; }
set { _tax_zz_1 = value; }
}//
[ModelDB]
public string tax_zz_2
{
get { return _tax_zz_2; }
set { _tax_zz_2 = value; }
}//
[ModelDB]
public string PreProportion
{
get { return _PreProportion; }
set { _PreProportion = value; }
}
[ModelDB]
public string RecProportion
{
get { return _RecProportion; }
set { _RecProportion = value; }
}
[ModelDB]
public string AMOUNT_WRITEOFFS
{
get { return _AMOUNT_WRITEOFFS; }
set { _AMOUNT_WRITEOFFS = value; }
}
[ModelDB]
public string SEQUENCE
{
get { return _SEQUENCE; }
set { _SEQUENCE = value; }
}
public string NAME_REF
{
get { return _NAME_REF; }
set { _NAME_REF = value; }
}
[ModelDB]
public string Ename //英文品名
{
get { return _Ename; }
set { _Ename = value; }
}
[ModelDB]
public string SBYS //申报要素
{
get { return _SBYS; }
set { _SBYS = value; }
}
[ModelDB]
public string BZTCHNO //批次号
{
get { return _BZTCHNO; }
set { _BZTCHNO = value; }
}
[ModelDB]
public string CargoType //产品类别
{
get { return _CargoType; }
set { _CargoType = value; }
}
[ModelDB]
public string REMARK //批次号
{
get { return _REMARK; }
set { _REMARK = value; }
}
[ModelDB]
public string SPECIFICATIONS
{
get { return _SPECIFICATIONS; }
set { _SPECIFICATIONS = value; }
}
//[ModelDB]
//public string EXPIRATIONDATE
//{
// get {
// if (!string.IsNullOrEmpty(_EXPIRATIONDATE.Trim()))
// {
// return _EXPIRATIONDATE;
// }else return string.Empty;
// }
// set {
// if (!string.IsNullOrEmpty(value.Trim()))
// {
// _EXPIRATIONDATE = value;
// }
// else {
// _EXPIRATIONDATE = string.Empty;
// }
// }
//}
#endregion
/*
[ModelDB]
public string Financestatus
{
get { return _Financestatus; }
set { _Financestatus = value; }
}
public string FinancestatusRef
{
get { return _FinancestatusRef; }
set { _FinancestatusRef = value; }
} */
#region 以下是只读字段(来自于联合查询)
private string _cicode = string.Empty;
private string _ciname = string.Empty;
private string _cicodeandname = string.Empty;
private string _ciqcode = string.Empty;
private string _ciqname = string.Empty;
private string _ciqcodeandname = string.Empty;
private string _UnitRef = string.Empty;
private string _paypartRef = string.Empty;
private string _codename = string.Empty;
private string _defaultrate = string.Empty;
private string _TAGPICURL = string.Empty;
public string cicode
{
get { return _cicode; }
set { _cicode = value; }
}
public string ciname
{
get { return _ciname; }
set { _ciname = value; }
}
public string cicodeandname
{
get { return _cicodeandname; }
set { _cicodeandname = value; }
}
public string ciqcode
{
get { return _ciqcode; }
set { _ciqcode = value; }
}
public string ciqname
{
get { return _ciqname; }
set { _ciqname = value; }
}
public string ciqcodeandname
{
get { return _ciqcodeandname; }
set { _ciqcodeandname = value; }
}
public string UnitRef
{
get { return _UnitRef; }
set { _UnitRef = value; }
}
public string paypartRef
{
get { return _paypartRef; }
set { _paypartRef = value; }
}
public string codename
{
get { return _codename; }
set { _codename = value; }
}
public string defaultrate
{
get { return _defaultrate; }
set { _defaultrate = value; }
}
public string TAGPICURL
{
get { return _TAGPICURL; }
set { _TAGPICURL = value; }
}
#endregion
public Cargomb()
{
TableName = "Import_Cargo";
}
public override string GetBillNoFieldName()
{
return "ContractNo";
}
}
#endregion
[JsonObject]
public class XXH_singlemb : XXHmb {
private string _factoryno = string.Empty;
private string _boxcount = string.Empty;
private string _amount = string.Empty;
private string _weight = string.Empty;
private string _price = string.Empty;
private string _CreateTime_2 = string.Empty;
private string _ResendTime = string.Empty;
private string _BilltypeREF = string.Empty;
private string _OPBillTime = string.Empty;
private string _Dock = string.Empty;
private string _Customs_broker = string.Empty;
private string _inspection_broker = string.Empty;
private string _Shuidan_Time = string.Empty;
private string _Jianyizheng_Time = string.Empty;
private string _AutoAPP_Time = string.Empty;
private string _HXD_Time = string.Empty;
private string _Paydate = string.Empty;
private string _Prepaydate = string.Empty;
private string _Agent = string.Empty;
private string _AgentId = string.Empty;
public string AgentId
{
get { return _AgentId; }
set { _AgentId = value; }
}
private string _Agent2 = string.Empty;
private string _Agent3 = string.Empty;
private int _AllowOpenMark2;
public int AllowOpenMark2
{
get { return _AllowOpenMark2; }
set { _AllowOpenMark2 = value; }
}
public string FactoryNo
{
get { return _factoryno; }
set { _factoryno = value; }
}
public string boxcount
{
get { return _boxcount; }
set { _boxcount = value; }
}
public string amount
{
get { return _amount; }
set { _amount = value; }
}
public string weight
{
get { return _weight; }
set { _weight = value; }
}
public string price
{
get { return _price; }
set { _price = value; }
}
[ModelDB]
public string ResendTime
{
get { return _ResendTime; }
set { _ResendTime = value; }
}
[ModelDB]
public string CreateTime_2
{
get { return _CreateTime_2; }
set { _CreateTime_2 = value; }
}
public string BilltypeREF
{
get { return _BilltypeREF; }
set { _BilltypeREF = value; }
}
[ModelDB]
public string OPBillTime
{
get { return _OPBillTime; }
set { _OPBillTime = value; }
}
[ModelDB]
public string Dock
{
get { return _Dock; }
set { _Dock = value; }
}
[ModelDB]
public string Customs_broker
{
get { return _Customs_broker; }
set { _Customs_broker = value; }
}
[ModelDB]
public string inspection_broker
{
get { return _inspection_broker; }
set { _inspection_broker = value; }
}
public string Shuidan_Time
{
get { return _Shuidan_Time; }
set { _Shuidan_Time = value; }
}
public string Jianyizheng_Time
{
get { return _Jianyizheng_Time; }
set { _Jianyizheng_Time = value; }
}
public string AutoAPP_Time
{
get { return _AutoAPP_Time; }
set { _AutoAPP_Time = value; }
}
public string HXD_Time
{
get { return _HXD_Time; }
set { _HXD_Time = value; }
}
public string Paydate
{
get { return _Paydate; }
set { _Paydate = value; }
}
public string Prepaydate
{
get { return _Prepaydate; }
set { _Prepaydate = value; }
}
private string _MODIFIEDUSER = string.Empty;
private string _MODIFIEDTIME = string.Empty;
[ModelDB]
public string MODIFIEDUSER
{
get { return _MODIFIEDUSER; }
set { _MODIFIEDUSER = value; }
}
[ModelDB]
public string MODIFIEDTIME
{
get { return _MODIFIEDTIME; }
set { _MODIFIEDTIME = value; }
}
[ModelDB]
public string Agent
{
get { return _Agent; }
set { _Agent = value; }
}
[ModelDB]
public string Agent2
{
get { return _Agent2; }
set { _Agent2 = value; }
}
[ModelDB]
public string Agent3
{
get { return _Agent3; }
set { _Agent3 = value; }
}
private string _port = string.Empty;
public string port
{
get { return _port; }
set { _port = value; }
}
}
[JsonObject]
public class XXH_ALLmb : XXHmb
{
private string _m_weight = string.Empty;
private string _price = string.Empty;
private string _price_agio = string.Empty;
private string _price_limit = string.Empty;
private string _amount = string.Empty;
private string _tax_amount = string.Empty;
private string _pay_amount = string.Empty;
private string _codename = string.Empty;
private string _boxcount = string.Empty;
private string _boxweight = string.Empty;
private string _exporter = string.Empty;
private string _FactoryNo = string.Empty;
private string _productiondate = string.Empty;
private string _prepayments = string.Empty;
private string _balance = string.Empty;
private string _baolv = string.Empty;
private string _tariff = string.Empty;
private string _tax = string.Empty;
private string _tax_zz = string.Empty;
private string _exchangerate = string.Empty;
private string _exchangerate_customs = string.Empty;
private string _tax_1 = string.Empty;
private string _tax_zz_1 = string.Empty;
private string _tax_2 = string.Empty;
private string _tax_zz_2 = string.Empty;
private string _RMBAmount = string.Empty;
private string _BilltypeREF = string.Empty;
private string _tax_amount_RMB = string.Empty;
private string _DeliveryDate = string.Empty;
private string _DeliveryAddress = string.Empty;
private string _IsRongZi = string.Empty;
private string _Paydate = string.Empty;
private string _Prepaydate = string.Empty;
private string _TaxRecvRemark = string.Empty;
private string _TaxPayRemark = string.Empty;
public string InspectionReleaseDate { get; set; }
public string preArrivalDate { get; set; }
public int? InventoryState { get; set; }
public string InventoryStateRef { get; set; }
public string pay_prepayments { get; set; }
public string pay_balance { get; set; }
public string RECEIVE_MAN { get; set; }
public string TaxPayRemark
{
get { return _TaxPayRemark; }
set { _TaxPayRemark = value; }
}
public string TaxRecvRemark
{
get { return _TaxRecvRemark; }
set { _TaxRecvRemark = value; }
}
public string CORPNAME { get; set; }
public string m_weight
{
get { return _m_weight; }
set { _m_weight = value; }
}
public string price
{
get { return _price; }
set { _price = value; }
}
public string price_agio
{
get { return _price_agio; }
set { _price_agio = value; }
}
public string price_limit
{
get { return _price_limit; }
set { _price_limit = value; }
}
public string amount
{
get { return _amount; }
set { _amount = value; }
}
public string tax_amount
{
get { return _tax_amount; }
set { _tax_amount = value; }
}
public string tax_amount_RMB
{
get { return _tax_amount_RMB; }
set { _tax_amount_RMB = value; }
}
public string pay_amount
{
get { return _pay_amount; }
set { _pay_amount = value; }
}
public string codename
{
get { return _codename; }
set { _codename = value; }
}
public string boxcount
{
get { return _boxcount; }
set { _boxcount = value; }
}
public string boxweight
{
get { return _boxweight; }
set { _boxweight = value; }
}
public string exporter
{
get { return _exporter; }
set { _exporter = value; }
}
public string FactoryNo
{
get { return _FactoryNo; }
set { _FactoryNo = value; }
}
public string productiondate
{
get { return _productiondate; }
set { _productiondate = value; }
}
public string prepayments
{
get { return _prepayments; }
set { _prepayments = value; }
}
public string balance
{
get { return _balance; }
set { _balance = value; }
}
public string baolv
{
get { return _baolv; }
set { _baolv = value; }
}
public string tariff
{
get { return _tariff; }
set { _tariff = value; }
}
public string tax
{
get { return _tax; }
set { _tax = value; }
}
public string tax_zz
{
get { return _tax_zz; }
set { _tax_zz = value; }
}
public string exchangerate
{
get { return _exchangerate; }
set { _exchangerate = value; }
}
public string exchangerate_customs
{
get { return _exchangerate_customs; }
set { _exchangerate_customs = value; }
}
public string tax_1
{
get { return _tax_1; }
set { _tax_1 = value; }
}
public string tax_zz_1
{
get { return _tax_zz_1; }
set { _tax_zz_1 = value; }
}
public string tax_2
{
get { return _tax_2; }
set { _tax_2 = value; }
}
public string tax_zz_2
{
get { return _tax_zz_2; }
set { _tax_zz_2 = value; }
}
public string RMBAmount
{
get { return _RMBAmount; }
set { _RMBAmount = value; }
}
public string BilltypeREF
{
get { return _BilltypeREF; }
set { _BilltypeREF = value; }
}
public string DeliveryDate
{
get { return _DeliveryDate; }
set { _DeliveryDate = value; }
}
public string DeliveryAddress
{
get { return _DeliveryAddress; }
set { _DeliveryAddress = value; }
}
public string IsRongZi
{
get { return _IsRongZi; }
set { _IsRongZi = value; }
}
public string Paydate
{
get { return _Paydate; }
set { _Paydate = value; }
}
public string Prepaydate
{
get { return _Prepaydate; }
set { _Prepaydate = value; }
}
//20161111 天津誉恒模块增加
private string _Supplier_Billno = string.Empty;
private string _ResendTime = string.Empty;
private string _ResendTime2 = string.Empty;
private string _ShipAgent = string.Empty;
private string _BillReleaseDate = string.Empty;
private string _IsLBill = string.Empty;
private string _LBillShipAgent = string.Empty;
private string _IsInnerLine = string.Empty;
private string _InnerLinePort = string.Empty;
private string _YARD = string.Empty;
private string _PriceLimitDate = string.Empty;
private string _PriceLimitRemark = string.Empty;
private string _ClearanceNo = string.Empty;
private string _ClearanceDate = string.Empty;
private string _TaxRecvDate = string.Empty;
private string _GetBoxDate = string.Empty;
private string _IsRec = string.Empty;
private string _FUNDDATE_1 = string.Empty;
public string Supplier_Billno
{
get { return _Supplier_Billno; }
set { _Supplier_Billno = value; }
}
public string ResendTime
{
get { return _ResendTime; }
set { _ResendTime = value; }
}
public string ResendTime2
{
get { return _ResendTime2; }
set { _ResendTime2 = value; }
}
public string ShipAgent
{
get { return _ShipAgent; }
set { _ShipAgent = value; }
}
public string BillReleaseDate
{
get { return _BillReleaseDate; }
set { _BillReleaseDate = value; }
}
public string IsLBill
{
get { return _IsLBill; }
set { _IsLBill = value; }
}
public string LBillShipAgent
{
get { return _LBillShipAgent; }
set { _LBillShipAgent = value; }
}
public string IsInnerLine
{
get { return _IsInnerLine; }
set { _IsInnerLine = value; }
}
public string InnerLinePort
{
get { return _InnerLinePort; }
set { _InnerLinePort = value; }
}
public string YARD
{
get { return _YARD; }
set { _YARD = value; }
}
public string PriceLimitDate
{
get { return _PriceLimitDate; }
set { _PriceLimitDate = value; }
}
public string PriceLimitRemark
{
get { return _PriceLimitRemark; }
set { _PriceLimitRemark = value; }
}
public string ClearanceNo
{
get { return _ClearanceNo; }
set { _ClearanceNo = value; }
}
public string ClearanceDate
{
get { return _ClearanceDate; }
set { _ClearanceDate = value; }
}
public string TaxRecvDate
{
get { return _TaxRecvDate; }
set { _TaxRecvDate = value; }
}
public string GetBoxDate
{
get { return _GetBoxDate; }
set { _GetBoxDate = value; }
}
public string IsRec
{
get { return _IsRec; }
set { _IsRec = value; }
}
public string FUNDDATE_1
{
get { return _FUNDDATE_1; }
set { _FUNDDATE_1 = value; }
}
private string _TAGPICURL { get; set; }
public string TAGPICURL
{
get { return _TAGPICURL; }
set { _TAGPICURL = value; }
}
}
[JsonObject]
public class XXH_ALLEditmb : XXH_ALLmb
{
private string _RCVMode = string.Empty;
[ModelDB(MDBType = ModelDBOprationType.Delete)]
public string RCVMode
{
get { return _RCVMode; }
set { _RCVMode = value; }
}
private string _KCClear = string.Empty;
[ModelDB(MDBType = ModelDBOprationType.Delete)]
public string KCClear
{
get { return _KCClear; }
set { _KCClear = value; }
}
private string _CTN = string.Empty;
[ModelDB(MDBType = ModelDBOprationType.Delete)]
public string CTN
{
get { return _CTN; }
set { _CTN = value; }
}
private string _m_weight = string.Empty;
private string _price = string.Empty;
private string _price_agio = string.Empty;
private string _price_limit = string.Empty;
private string _amount = string.Empty;
private string _tax_amount = string.Empty;
private string _pay_amount = string.Empty;
private string _codename = string.Empty;
private string _boxcount = string.Empty;
private string _boxweight = string.Empty;
private string _exporter = string.Empty;
private string _FactoryNo = string.Empty;
private string _productiondate = string.Empty;
private string _prepayments = string.Empty;
private string _balance = string.Empty;
private string _baolv = string.Empty;
private string _tariff = string.Empty;
private string _tax = string.Empty;
private string _tax_zz = string.Empty;
private string _exchangerate = string.Empty;
private string _exchangerate_customs = string.Empty;
private string _tax_1 = string.Empty;
private string _tax_zz_1 = string.Empty;
private string _tax_2 = string.Empty;
private string _tax_zz_2 = string.Empty;
private string _RMBAmount = string.Empty;
private string _BilltypeREF = string.Empty;
private string _tax_amount_RMB = string.Empty;
private string _DeliveryDate = string.Empty;
private string _DeliveryAddress = string.Empty;
private string _IsRongZi = string.Empty;
private string _Paydate = string.Empty;
private string _Prepaydate = string.Empty;
public string m_weight
{
get { return _m_weight; }
set { _m_weight = value; }
}
public string price
{
get { return _price; }
set { _price = value; }
}
public string price_agio
{
get { return _price_agio; }
set { _price_agio = value; }
}
public string price_limit
{
get { return _price_limit; }
set { _price_limit = value; }
}
public string amount
{
get { return _amount; }
set { _amount = value; }
}
public string tax_amount
{
get { return _tax_amount; }
set { _tax_amount = value; }
}
public string tax_amount_RMB
{
get { return _tax_amount_RMB; }
set { _tax_amount_RMB = value; }
}
public string pay_amount
{
get { return _pay_amount; }
set { _pay_amount = value; }
}
public string codename
{
get { return _codename; }
set { _codename = value; }
}
public string boxcount
{
get { return _boxcount; }
set { _boxcount = value; }
}
public string boxweight
{
get { return _boxweight; }
set { _boxweight = value; }
}
public string exporter
{
get { return _exporter; }
set { _exporter = value; }
}
public string FactoryNo
{
get { return _FactoryNo; }
set { _FactoryNo = value; }
}
public string productiondate
{
get { return _productiondate; }
set { _productiondate = value; }
}
public string prepayments
{
get { return _prepayments; }
set { _prepayments = value; }
}
public string balance
{
get { return _balance; }
set { _balance = value; }
}
public string baolv
{
get { return _baolv; }
set { _baolv = value; }
}
public string tariff
{
get { return _tariff; }
set { _tariff = value; }
}
public string tax
{
get { return _tax; }
set { _tax = value; }
}
public string tax_zz
{
get { return _tax_zz; }
set { _tax_zz = value; }
}
public string exchangerate
{
get { return _exchangerate; }
set { _exchangerate = value; }
}
public string exchangerate_customs
{
get { return _exchangerate_customs; }
set { _exchangerate_customs = value; }
}
public string tax_1
{
get { return _tax_1; }
set { _tax_1 = value; }
}
public string tax_zz_1
{
get { return _tax_zz_1; }
set { _tax_zz_1 = value; }
}
public string tax_2
{
get { return _tax_2; }
set { _tax_2 = value; }
}
public string tax_zz_2
{
get { return _tax_zz_2; }
set { _tax_zz_2 = value; }
}
public string RMBAmount
{
get { return _RMBAmount; }
set { _RMBAmount = value; }
}
public string BilltypeREF
{
get { return _BilltypeREF; }
set { _BilltypeREF = value; }
}
public string DeliveryDate
{
get { return _DeliveryDate; }
set { _DeliveryDate = value; }
}
public string DeliveryAddress
{
get { return _DeliveryAddress; }
set { _DeliveryAddress = value; }
}
public string IsRongZi
{
get { return _IsRongZi; }
set { _IsRongZi = value; }
}
public string Paydate
{
get { return _Paydate; }
set { _Paydate = value; }
}
public string Prepaydate
{
get { return _Prepaydate; }
set { _Prepaydate = value; }
}
}
[JsonObject]
public class XXH_ALLEditmb2 : ModelObjectBillHead
{
#region private field
private string _ContractNo = string.Empty;
private string _STT = string.Empty;
private string _Printed = string.Empty;
private string _AutoAPP = string.Empty;
private string _Ex_sailingdate = string.Empty;
private string _Sailingdate = string.Empty;
private string _ArrivalDate = string.Empty;
private string _tax_date = string.Empty;
private string _tax_paydate = string.Empty;
private string _E_Billtime = string.Empty;
private string _BillTime = string.Empty;
private string _HDtime = string.Empty;
private string _Vessel = string.Empty;
private string _Voyage = string.Empty;
private string _CIQ_canbesearch = string.Empty;
private string _inspection_Signup_date = string.Empty;
private string _inspection_no = string.Empty;
private string _SamplingDate_Plan = string.Empty;
private string _SamplingDate_Act = string.Empty;
private string _CustomsReleaseDate = string.Empty;
private string _DeclareNumber = string.Empty;
private string _Paydate = string.Empty;
private string _Prepaydate = string.Empty;
private string _BillType = string.Empty;
private string _Inspection_Storage = string.Empty;
private string _inspection_date = string.Empty;
private string _RecDate = string.Empty;
private string _PortDays = string.Empty;
private string _DeliveryDate = string.Empty;
private string _DeliveryAddress = string.Empty;
private string _Contacter = string.Empty;
private string _Tel = string.Empty;
private string _remark = string.Empty;
private string _remark_2 = string.Empty;
private string _remark_3 = string.Empty;
private string _remark_4 = string.Empty;
private string _Overfilled = string.Empty;
private string _Inspection_Buyer = string.Empty;
private string _Freetime = string.Empty;
private string _BILLTRANCNO = string.Empty;
private string _Unsealdate = string.Empty;
private string _MODIFIEDUSER = string.Empty;
private string _MODIFIEDTIME = string.Empty;
private string _m_weight = string.Empty;
private string _price = string.Empty;
private string _price_agio = string.Empty;
private string _price_limit = string.Empty;
private string _amount = string.Empty;
private string _tax_amount = string.Empty;
private string _pay_amount = string.Empty;
private string _codename = string.Empty;
private string _boxcount = string.Empty;
private string _boxweight = string.Empty;
private string _exporter = string.Empty;
private string _FactoryNo = string.Empty;
private string _productiondate = string.Empty;
private string _prepayments = string.Empty;
private string _balance = string.Empty;
private string _baolv = string.Empty;
private string _tariff = string.Empty;
private string _tax = string.Empty;
private string _tax_zz = string.Empty;
private string _exchangerate = string.Empty;
private string _exchangerate_customs = string.Empty;
private string _tax_1 = string.Empty;
private string _tax_zz_1 = string.Empty;
private string _tax_2 = string.Empty;
private string _tax_zz_2 = string.Empty;
private string _RMBAmount = string.Empty;
private string _BilltypeREF = string.Empty;
private string _tax_amount_RMB = string.Empty;
private string _IsRongZi = string.Empty;
private decimal _TimeMark = 0;
private string _Receiptremark = string.Empty;
private string _InspectionReleaseDate = string.Empty;
#endregion
public string m_weight
{
get { return _m_weight; }
set { _m_weight = value; }
}
public string price
{
get { return _price; }
set { _price = value; }
}
public string price_agio
{
get { return _price_agio; }
set { _price_agio = value; }
}
public string price_limit
{
get { return _price_limit; }
set { _price_limit = value; }
}
public string amount
{
get { return _amount; }
set { _amount = value; }
}
public string tax_amount
{
get { return _tax_amount; }
set { _tax_amount = value; }
}
public string tax_amount_RMB
{
get { return _tax_amount_RMB; }
set { _tax_amount_RMB = value; }
}
public string pay_amount
{
get { return _pay_amount; }
set { _pay_amount = value; }
}
public string codename
{
get { return _codename; }
set { _codename = value; }
}
public string boxcount
{
get { return _boxcount; }
set { _boxcount = value; }
}
public string boxweight
{
get { return _boxweight; }
set { _boxweight = value; }
}
public string exporter
{
get { return _exporter; }
set { _exporter = value; }
}
public string FactoryNo
{
get { return _FactoryNo; }
set { _FactoryNo = value; }
}
public string productiondate
{
get { return _productiondate; }
set { _productiondate = value; }
}
public string prepayments
{
get { return _prepayments; }
set { _prepayments = value; }
}
public string balance
{
get { return _balance; }
set { _balance = value; }
}
public string baolv
{
get { return _baolv; }
set { _baolv = value; }
}
public string tariff
{
get { return _tariff; }
set { _tariff = value; }
}
public string tax
{
get { return _tax; }
set { _tax = value; }
}
public string tax_zz
{
get { return _tax_zz; }
set { _tax_zz = value; }
}
public string exchangerate
{
get { return _exchangerate; }
set { _exchangerate = value; }
}
public string exchangerate_customs
{
get { return _exchangerate_customs; }
set { _exchangerate_customs = value; }
}
public string tax_1
{
get { return _tax_1; }
set { _tax_1 = value; }
}
public string tax_zz_1
{
get { return _tax_zz_1; }
set { _tax_zz_1 = value; }
}
public string tax_2
{
get { return _tax_2; }
set { _tax_2 = value; }
}
public string tax_zz_2
{
get { return _tax_zz_2; }
set { _tax_zz_2 = value; }
}
public string RMBAmount
{
get { return _RMBAmount; }
set { _RMBAmount = value; }
}
public string BilltypeREF
{
get { return _BilltypeREF; }
set { _BilltypeREF = value; }
}
public string IsRongZi
{
get { return _IsRongZi; }
set { _IsRongZi = value; }
}
[ModelDB(MDBType = ModelDBOprationType.EditDelete, IsPrimary = true)]
public string ContractNo
{
get { return _ContractNo; }
set { _ContractNo = value; }
}
[ModelDB]
public string STT
{
get { return _STT; }
set { _STT = value; }
}
[ModelDB]
public string Printed
{
get { return _Printed; }
set { _Printed = value; }
}
[ModelDB]
public string AutoAPP
{
get { return _AutoAPP; }
set { _AutoAPP = value; }
}
[ModelDB]
public string Ex_sailingdate
{
get { return _Ex_sailingdate; }
set { _Ex_sailingdate = value; }
}
[ModelDB]
public string Sailingdate
{
get { return _Sailingdate; }
set { _Sailingdate = value; }
}
[ModelDB]
public string ArrivalDate
{
get { return _ArrivalDate; }
set { _ArrivalDate = value; }
}
[ModelDB]
public string tax_date
{
get { return _tax_date; }
set { _tax_date = value; }
}
[ModelDB]
public string tax_paydate
{
get { return _tax_paydate; }
set { _tax_paydate = value; }
}
[ModelDB]
public string E_Billtime
{
get { return _E_Billtime; }
set { _E_Billtime = value; }
}
[ModelDB]
public string BillTime
{
get { return _BillTime; }
set { _BillTime = value; }
}
[ModelDB]
public string HDtime
{
get { return _HDtime; }
set { _HDtime = value; }
}
[ModelDB]
public string Vessel
{
get { return _Vessel; }
set { _Vessel = value; }
}
[ModelDB]
public string Voyage
{
get { return _Voyage; }
set { _Voyage = value; }
}
[ModelDB]
public string CIQ_canbesearch
{
get { return _CIQ_canbesearch; }
set { _CIQ_canbesearch = value; }
}
[ModelDB]
public string inspection_Signup_date
{
get { return _inspection_Signup_date; }
set { _inspection_Signup_date = value; }
}
[ModelDB]
public string inspection_no
{
get { return _inspection_no; }
set { _inspection_no = value; }
}
[ModelDB]
public string SamplingDate_Plan
{
get { return _SamplingDate_Plan; }
set { _SamplingDate_Plan = value; }
}
[ModelDB]
public string SamplingDate_Act
{
get { return _SamplingDate_Act; }
set { _SamplingDate_Act = value; }
}
[ModelDB]
public string CustomsReleaseDate
{
get { return _CustomsReleaseDate; }
set { _CustomsReleaseDate = value; }
}
[ModelDB]
public string DeclareNumber
{
get { return _DeclareNumber; }
set { _DeclareNumber = value; }
}
[ModelDB]
public string Paydate
{
get { return _Paydate; }
set { _Paydate = value; }
}
[ModelDB]
public string Prepaydate
{
get { return _Prepaydate; }
set { _Prepaydate = value; }
}
[ModelDB]
public string BillType
{
get { return _BillType; }
set { _BillType = value; }
}
[ModelDB]
public string Inspection_Storage
{
get { return _Inspection_Storage; }
set { _Inspection_Storage = value; }
}
[ModelDB]
public string inspection_date
{
get { return _inspection_date; }
set { _inspection_date = value; }
}
[ModelDB]
public string RecDate
{
get { return _RecDate; }
set { _RecDate = value; }
}
[ModelDB]
public string PortDays
{
get { return _PortDays; }
set { _PortDays = value; }
}
[ModelDB]
public string DeliveryDate
{
get { return _DeliveryDate; }
set { _DeliveryDate = value; }
}
[ModelDB]
public string DeliveryAddress
{
get { return _DeliveryAddress; }
set { _DeliveryAddress = value; }
}
[ModelDB]
public string Contacter
{
get { return _Contacter; }
set { _Contacter = value; }
}
[ModelDB]
public string Tel
{
get { return _Tel; }
set { _Tel = value; }
}
[ModelDB]
public string remark
{
get { return _remark; }
set { _remark = value; }
}
[ModelDB]
public string remark_2
{
get { return _remark_2; }
set { _remark_2 = value; }
}
[ModelDB]
public string remark_3
{
get { return _remark_3; }
set { _remark_3 = value; }
}
[ModelDB]
public string remark_4
{
get { return _remark_4; }
set { _remark_4 = value; }
}
[ModelDB]
public string Overfilled
{
get { return _Overfilled; }
set { _Overfilled = value; }
}
[ModelDB]
public string Inspection_Buyer
{
get { return _Inspection_Buyer; }
set { _Inspection_Buyer = value; }
}
[ModelDB]
public string Freetime
{
get { return _Freetime; }
set { _Freetime = value; }
}
[ModelDB]
public string BILLTRANCNO
{
get { return _BILLTRANCNO; }
set { _BILLTRANCNO = value; }
}
[ModelDB]
public string Unsealdate
{
get { return _Unsealdate; }
set { _Unsealdate = value; }
}
[ModelDB]
public string MODIFIEDUSER
{
get { return _MODIFIEDUSER; }
set { _MODIFIEDUSER = value; }
}
[ModelDB]
public string MODIFIEDTIME
{
get { return _MODIFIEDTIME; }
set { _MODIFIEDTIME = value; }
}
public decimal TimeMark
{
get { return _TimeMark; }
set { _TimeMark = value; }
}
[ModelDB]
public string Receiptremark
{
get { return _Receiptremark; }
set { _Receiptremark = value; }
}
[ModelDB]
public string InspectionReleaseDate
{
get { return _InspectionReleaseDate; }
set { _InspectionReleaseDate = value; }
}
private string _preArrivalDate = string.Empty;
[ModelDB]
public string preArrivalDate
{
get { return _preArrivalDate; }
set { _preArrivalDate = value; }
}
public XXH_ALLEditmb2 ( )
{
// TableName = "tMsWlPcHead";
TableName = "Import_main";
}
public override string GetBillNoFieldName()
{
return "ContractNo";
}
}
[JsonObject]
public class CWLockmb : XXHmb
{
private string _ACCDATE = string.Empty;
private string _ContractStatus = string.Empty;
private string _Paydate = string.Empty;
private string _Prepaydate = string.Empty;
[ModelDB]
public string ACCDATE
{
get { return _ACCDATE; }
set { _ACCDATE = value; }
}
[ModelDB]
public string ContractStatus
{
get { return _ContractStatus; }
set { _ContractStatus = value; }
}
public string Paydate
{
get { return _Paydate; }
set { _Paydate = value; }
}
public string Prepaydate
{
get { return _Prepaydate; }
set { _Prepaydate = value; }
}
}
[JsonObject]
public class XXH_HDmb : ModelObjectBillHead
{
#region private Fields
private string _cgid = string.Empty;
private string _name = string.Empty;
private string _country = string.Empty;
private string _AppNo = string.Empty;
private string _ValidDate = string.Empty;
private string _weight_t = string.Empty;
private string _weight = string.Empty;
private string _printedRef = string.Empty;
private string _WriteoffsRef = string.Empty;
private string _AutoAPPRef = string.Empty;
private string _ShipCompanyRef = string.Empty;
private string _CIQ_canbesearchRef = string.Empty;
private string _ReceiptStatusRef = string.Empty;
private string _AppName = string.Empty;
private string _APPREMARK = string.Empty;
private string _ywtype = "import_main";
public string ywtype
{
get { return _ywtype; }
set { _ywtype = value; }
}
#region 私有变量
private decimal _id = 0;
protected string _ContractNo = string.Empty;
private string _HTH = string.Empty;
private string _seller = string.Empty;
private string _company = string.Empty;
private string _companyname = string.Empty;
private string _buyer = string.Empty;
private string _STT = string.Empty;
private string _countryid = string.Empty;
private string _creator = string.Empty;
private string _Auditor = string.Empty;
private string _AuditorREF = string.Empty;
private string _Mainstate = string.Empty;
private string _MainstateRef = string.Empty;
private string _Printed = string.Empty;
private string _AutoAPP = string.Empty;
private string _ShipCompany_id = string.Empty;
private string _BillNo = string.Empty;
private string _BillType = string.Empty;
private string _BilltypeREF = string.Empty;
private string _BillTime = string.Empty;
private string _Vessel = string.Empty;
private string _Voyage = string.Empty;
private string _Ex_sailingdate = string.Empty;
private string _Sailingdate = string.Empty;
private string _ArrivalDate = null;
private string _ContainerNo = string.Empty;
private string _SealNo = string.Empty;
private string _TransactionMethod = string.Empty;
private string _PaymentMethods = string.Empty;
private string _TransactionMethodRef = string.Empty;
private string _PaymentMethodsRef = string.Empty;
private string _SecurityDeposit = string.Empty;
private string _CustomsReleaseDate = null;
private string _SamplingDate_Plan = null;
private string _SamplingDate_Act = null;
private string _inspection_Signup_date = null;
private string _inspection_no = string.Empty;
private string _inspection_date = null;
private decimal _TimeMark = 0;
private string _cicode = string.Empty;
private string _ciname = string.Empty;
private string _creattime = string.Empty;
private string _Audittime = string.Empty;
private string _CIQ_licence = string.Empty;
private string _CIQ_canbesearch = string.Empty;
private string _tax_date = string.Empty;
private string _tax_paydate = string.Empty;
private string _port = string.Empty;
private string _remark = string.Empty;
private string _portRef = string.Empty;
private string _Freetime = string.Empty;
private string _Writeoffs = string.Empty;
private string _Paydate = string.Empty;
private string _Prepaydate = string.Empty;
private string _E_Billtime = string.Empty;
private string _HDtime = string.Empty;
private string _FinanceStatus = string.Empty;
private string _FinanceStatusREF = string.Empty;
private string _remark_2 = string.Empty;
private string _remark_3 = string.Empty;
private string _remark_4 = string.Empty;
private string _Sampling_need = string.Empty;
private string _Sampling_needREF = string.Empty;
private string _DeclareNumber = string.Empty;
private string _Inspection_Storage = string.Empty;
private string _Inspection_StorageREF = string.Empty;
private string _DeliveryDate = string.Empty;
private string _DeliveryAddress = string.Empty;
private string _Contacter = string.Empty;
private string _Tel = string.Empty;
private string _Overfilled = string.Empty;
private string _OwnApp = string.Empty;
private string _ReceiptStatus = string.Empty;
private string _Receiptremark = string.Empty;
private string _TRADINGAGENCY = string.Empty;
private string _FactoryNo = string.Empty;
private string _ACCDATE = string.Empty;
private string _ContractStatus = string.Empty;
private string _KCClear = string.Empty;
private string _ISVOU = string.Empty;
private string _VOUCHERNO = string.Empty;
private string _RCVMode = string.Empty;
private string _RCVModeREF = string.Empty;
private string _OP = string.Empty;
private string _Maoli = string.Empty;
private string _FHPROFIT = string.Empty;
private string _LCPROFIT = string.Empty;
private string _OTPROFIT = string.Empty;
private string _ZMQ = string.Empty;
private string _MZBZ = string.Empty;
private string _MZBZREF = string.Empty;
private string _RecDate = string.Empty;
private string _PortDays = string.Empty;
private string _BUZTYPE = string.Empty;
private string _BUZTYPEREF = string.Empty;
private string _APPWEIGHT = string.Empty;
private string _SELLERFULLNAME = string.Empty;
private string _Exporter = string.Empty;
private string _Inspection_Buyer = string.Empty;
private string _Inspection_BuyerRef = string.Empty;
private string _Inspection_Contacter = string.Empty;
private string _Inspection_Tel = string.Empty;
private string _Inspection_Email = string.Empty;
private string _Inspection_Code = string.Empty;
private string _Inspection_DeliveryAddress = string.Empty;
private string _HaveContract = string.Empty; //是否有合同
private string _HaveCargoMark = string.Empty; //是否有商品标签
private string _Productiondate = string.Empty;
private string _BZTCHNO = string.Empty;
private string _appusedweight = string.Empty;
private string _HK_profit = string.Empty;
private string _RZ_profit = string.Empty;
private string _HAVESAMPLE = string.Empty;
private string _CHECKSAMPLE = string.Empty;
private string _price = string.Empty;
private string _price_agio = string.Empty;
private string _CTN = string.Empty;
private string _BILLTRANCNO = string.Empty;
private string _SBYS = string.Empty;
private string _BILL_RECEIVE_DATE = string.Empty;
private string _BILL_SEND_DATE = string.Empty;
private string _LOCK_EXCHANGERATE = string.Empty;
private string _EXCHANGERATE = string.Empty;
private string _Unsealdate = string.Empty;
private string _ISREFORM = string.Empty;
private string _InspectionNo = string.Empty;
private string _IsRongZi = string.Empty;
private string _MBLNOREPEAT = string.Empty;
private string _LOADFINISH = "1";
#endregion
#region 公有函数
#region 查询用函数
public string country
{
get { return _country; }
set { _country = value; }
}
public string cgid
{
get { return _cgid; }
set { _cgid = value; }
}
public string name
{
get { return _name; }
set { _name = value; }
}
public string AppNo
{
get { return _AppNo; }
set { _AppNo = value; }
}
public string ValidDate
{
get { return _ValidDate; }
set { _ValidDate = value; }
}
public string weight_t
{
get { return _weight_t; }
set { _weight_t = value; }
}
public string weight
{
get { return _weight; }
set { _weight = value; }
}
public string AutoAPPRef
{
get { return _AutoAPPRef; }
set { _AutoAPPRef = value; }
}
public string printedRef
{
get { return _printedRef; }
set { _printedRef = value; }
}
public string WriteoffsRef
{
get { return _WriteoffsRef; }
set { _WriteoffsRef = value; }
}
public string AppName
{
get { return _AppName; }
set { _AppName = value; }
}
public string APPREMARK
{
get { return _APPREMARK; }
set { _APPREMARK = value; }
}
#endregion
[ModelDB(MDBType = ModelDBOprationType.EditDelete, IsPrimary = true)]
public decimal id
{
get { return _id; }
set { _id = value; }
}
[ModelDB]
public string ContractNo
{
get { return _ContractNo; }
set { _ContractNo = value; }
}
[ModelDB]
public string HTH
{
get { return _HTH; }
set { _HTH = value; }
}
[ModelDB]
public string company
{
get { return _company; }
set { _company = value; }
}
public string companyname
{
get { return _companyname; }
set { _companyname = value; }
}
[ModelDB]
public string seller
{
get { return _seller; }
set { _seller = value; }
}
[ModelDB]
public string buyer
{
get { return _buyer; }
set { _buyer = value; }
}
[ModelDB]
public string STT
{
get { return _STT; }
set { _STT = value; }
}
[ModelDB]
public string countryid
{
get { return _countryid; }
set { _countryid = value; }
}
//[ModelDB]
public string creator
{
get { return _creator; }
set { _creator = value; }
}
//[ModelDB]
public string Auditor
{
get { return _Auditor; }
set { _Auditor = value; }
}
public string AuditorREF
{
get { return _AuditorREF; }
set { _AuditorREF = value; }
}
[ModelDB]
public string Mainstate
{
get { return _Mainstate; }
set { _Mainstate = value; }
}
public string MainstateRef
{
get { return _MainstateRef; }
set { _MainstateRef = value; }
}
[ModelDB]
public string Printed
{
get { return _Printed; }
set { _Printed = value; }
}
[ModelDB]
public string AutoAPP
{
get { return _AutoAPP; }
set { _AutoAPP = value; }
}
[ModelDB]
public string ShipCompany_id
{
get { return _ShipCompany_id; }
set { _ShipCompany_id = value; }
}
public string ShipCompanyRef
{
get { return _ShipCompanyRef; }
set { _ShipCompanyRef = value; }
}
[ModelDB]
public string BillNo
{
get { return _BillNo; }
set { _BillNo = value; }
}
[ModelDB]
public string BillType
{
get { return _BillType; }
set { _BillType = value; }
}
public string BillTypeREF
{
get { return _BilltypeREF; }
set { _BilltypeREF = value; }
}
[ModelDB]
public string BillTime
{
get { return _BillTime; }
set { _BillTime = value; }
}
[ModelDB]
public string Vessel
{
get { return _Vessel; }
set { _Vessel = value; }
}
[ModelDB]
public string Voyage
{
get { return _Voyage; }
set { _Voyage = value; }
}
[ModelDB]
public String Ex_sailingdate
{
get { return _Ex_sailingdate; }
set { _Ex_sailingdate = value; }
}
[ModelDB]
public String Sailingdate
{
get { return _Sailingdate; }
set { _Sailingdate = value; }
}
[ModelDB]
public String ArrivalDate
{
get { return _ArrivalDate; }
set { _ArrivalDate = value; }
}
[ModelDB]
public string ContainerNo
{
get { return _ContainerNo; }
set { _ContainerNo = value; }
}
[ModelDB]
public string SealNo
{
get { return _SealNo; }
set { _SealNo = value; }
}
[ModelDB]
public string TransactionMethod
{
get { return _TransactionMethod; }
set { _TransactionMethod = value; }
}
[ModelDB]
public string PaymentMethods
{
get { return _PaymentMethods; }
set { _PaymentMethods = value; }
}
public string TransactionMethodRef
{
get { return _TransactionMethodRef; }
set { _TransactionMethodRef = value; }
}
public string PaymentMethodsRef
{
get { return _PaymentMethodsRef; }
set { _PaymentMethodsRef = value; }
}
[ModelDB]
public string SecurityDeposit
{
get { return _SecurityDeposit; }
set { _SecurityDeposit = value; }
}
[ModelDB]
public string CustomsReleaseDate
{
get { return _CustomsReleaseDate; }
set { _CustomsReleaseDate = value; }
}
[ModelDB]
public string SamplingDate_Plan
{
get { return _SamplingDate_Plan; }
set { _SamplingDate_Plan = value; }
}
[ModelDB]
public string SamplingDate_Act
{
get { return _SamplingDate_Act; }
set { _SamplingDate_Act = value; }
}
[ModelDB]
public string inspection_Signup_date
{
get { return _inspection_Signup_date; }
set { _inspection_Signup_date = value; }
}
[ModelDB]
public string inspection_no
{
get { return _inspection_no; }
set { _inspection_no = value; }
}
[ModelDB]
public string inspection_date
{
get { return _inspection_date; }
set { _inspection_date = value; }
}
[ModelDB]
public string creattime
{
get { return _creattime; }
set { _creattime = value; }
}
[ModelDB]
public string Audittime
{
get { return _Audittime; }
set { _Audittime = value; }
}
[ModelDB]
public string Freetime
{
get { return _Freetime; }
set { _Freetime = value; }
}
[ModelDB]
public string CIQ_licence
{
get { return _CIQ_licence; }
set { _CIQ_licence = value; }
}
[ModelDB]
public string CIQ_canbesearch
{
get { return _CIQ_canbesearch; }
set { _CIQ_canbesearch = value; }
}
[ModelDB]
public string tax_date
{
get { return _tax_date; }
set { _tax_date = value; }
}
[ModelDB]
public string tax_paydate
{
get { return _tax_paydate; }
set { _tax_paydate = value; }
}
[ModelDB]
public string port
{
get { return _port; }
set { _port = value; }
}
[ModelDB]
public string remark
{
get { return _remark; }
set { _remark = value; }
}
[ModelDB]
public string Writeoffs
{
get { return _Writeoffs; }
set { _Writeoffs = value; }
}
///
/// /////////////
///
[ModelDB]
public string Paydate
{
get { return _Paydate; }
set { _Paydate = value; }
}
[ModelDB]
public string Prepaydate
{
get { return _Prepaydate; }
set { _Prepaydate = value; }
}
[ModelDB]
public string E_Billtime
{
get { return _E_Billtime; }
set { _E_Billtime = value; }
}
[ModelDB]
public string HDtime
{
get { return _HDtime; }
set { _HDtime = value; }
}
[ModelDB]
public string FinanceStatus
{
get { return _FinanceStatus; }
set { _FinanceStatus = value; }
}
public string FinanceStatusREF
{
get { return _FinanceStatusREF; }
set { _FinanceStatusREF = value; }
}
[ModelDB]
public string remark_2
{
get { return _remark_2; }
set { _remark_2 = value; }
}
[ModelDB]
public string remark_3
{
get { return _remark_3; }
set { _remark_3 = value; }
}
[ModelDB]
public string remark_4
{
get { return _remark_4; }
set { _remark_4 = value; }
}
[ModelDB]
public string Sampling_need
{
get { return _Sampling_need; }
set { _Sampling_need = value; }
}
public string Sampling_needREF
{
get { return _Sampling_needREF; }
set { _Sampling_needREF = value; }
}
[ModelDB]
public string DeclareNumber
{
get { return _DeclareNumber; }
set { _DeclareNumber = value; }
}
[ModelDB]
public string Inspection_Storage
{
get { return _Inspection_Storage; }
set { _Inspection_Storage = value; }
}
public string Inspection_StorageREF
{
get { return _Inspection_StorageREF; }
set { _Inspection_StorageREF = value; }
}
[ModelDB]
public string DeliveryDate
{
get { return _DeliveryDate; }
set { _DeliveryDate = value; }
}
[ModelDB]
public string DeliveryAddress
{
get { return _DeliveryAddress; }
set { _DeliveryAddress = value; }
}
[ModelDB]
public string Contacter
{
get { return _Contacter; }
set { _Contacter = value; }
}
[ModelDB]
public string Tel
{
get { return _Tel; }
set { _Tel = value; }
}
[ModelDB]
public string Overfilled
{
get { return _Overfilled; }
set { _Overfilled = value; }
}
[ModelDB]
public string ReceiptStatus
{
get { return _ReceiptStatus; }
set { _ReceiptStatus = value; }
}
[ModelDB]
public string Receiptremark
{
get { return _Receiptremark; }
set { _Receiptremark = value; }
}
[ModelDB]
public string TRADINGAGENCY
{
get { return _TRADINGAGENCY; }
set { _TRADINGAGENCY = value; }
}
[ModelDB]
public string KCClear
{
get { return _KCClear; }
set { _KCClear = value; }
}
[ModelDB]
public string RCVMode
{
get { return _RCVMode; }
set { _RCVMode = value; }
}
public string RCVModeREF
{
get { return _RCVModeREF; }
set { _RCVModeREF = value; }
}
//[ModelDB]
public string ACCDATE
{
get { return _ACCDATE; }
set { _ACCDATE = value; }
}
//[ModelDB]
public string ContractStatus
{
get { return _ContractStatus; }
set { _ContractStatus = value; }
}
public string ISVOU
{
get { return _ISVOU; }
set { _ISVOU = value; }
}
public string VOUCHERNO
{
get { return _VOUCHERNO; }
set { _VOUCHERNO = value; }
}
//[ModelDB]
public string OwnApp
{
get { return _OwnApp; }
set { _OwnApp = value; }
}
public string portRef
{
get { return _portRef; }
set { _portRef = value; }
}
public decimal TimeMark
{
get { return _TimeMark; }
set { _TimeMark = value; }
}
public string cicode
{
get { return _cicode; }
set { _cicode = value; }
}
public string ciname
{
get { return _ciname; }
set { _ciname = value; }
}
public string CIQ_canbesearchRef
{
get { return _CIQ_canbesearchRef; }
set { _CIQ_canbesearchRef = value; }
}
public string ReceiptStatusRef
{
get { return _ReceiptStatusRef; }
set { _ReceiptStatusRef = value; }
}
public string FactoryNo
{
get { return _FactoryNo; }
set { _FactoryNo = value; }
}
public string OP
{
get { return _OP; }
set { _OP = value; }
}
public string Maoli
{
get { return _Maoli; }
set { _Maoli = value; }
}
public string FHPROFIT
{
get { return _FHPROFIT; }
set { _FHPROFIT = value; }
}
public string LCPROFIT
{
get { return _LCPROFIT; }
set { _LCPROFIT = value; }
}
public string OTPROFIT
{
get { return _OTPROFIT; }
set { _OTPROFIT = value; }
}
public string HK_profit
{
get { return _HK_profit; }
set { _HK_profit = value; }
}
public string RZ_profit
{
get { return _RZ_profit; }
set { _RZ_profit = value; }
}
public string ZMQ
{
get { return _ZMQ; }
set { _ZMQ = value; }
}
[ModelDB]
public string MZBZ
{
get { return _MZBZ; }
set { _MZBZ = value; }
}
public string MZBZREF
{
get { return _MZBZREF; }
set { _MZBZREF = value; }
}
[ModelDB]
public string RecDate
{
get { return _RecDate; }
set { _RecDate = value; }
}
[ModelDB]
public string PortDays
{
get { return _PortDays; }
set { _PortDays = value; }
}
[ModelDB]
public string BUZTYPE
{
get { return _BUZTYPE; }
set { _BUZTYPE = value; }
}
public string BUZTYPEREF
{
get { return _BUZTYPEREF; }
set { _BUZTYPEREF = value; }
}
public string APPWEIGHT
{
get { return _APPWEIGHT; }
set { _APPWEIGHT = value; }
}
public string SELLERFULLNAME
{
get { return _SELLERFULLNAME; }
set { _SELLERFULLNAME = value; }
}
public string Exporter
{
get { return _Exporter; }
set { _Exporter = value; }
}
public string Exporter2
{
get { return _Exporter; }
set { _Exporter = value; }
}
//20150916 新协航要求 增加三个应对商检系统的数据项
[ModelDB]
public string Inspection_Buyer
{
get { return _Inspection_Buyer; }
set { _Inspection_Buyer = value; }
}
public string Inspection_BuyerRef
{
get { return _Inspection_BuyerRef; }
set { _Inspection_BuyerRef = value; }
}
public string Inspection_Contacter
{
get { return _Inspection_Contacter; }
set { _Inspection_Contacter = value; }
}
public string Inspection_Tel
{
get { return _Inspection_Tel; }
set { _Inspection_Tel = value; }
}
public string Inspection_DeliveryAddress
{
get { return _Inspection_DeliveryAddress; }
set { _Inspection_DeliveryAddress = value; }
}
public string Inspection_Email
{
get { return _Inspection_Email; }
set { _Inspection_Email = value; }
}
public string Inspection_Code
{
get { return _Inspection_Code; }
set { _Inspection_Code = value; }
}
public string HaveContract
{
get { return _HaveContract; }
set { _HaveContract = value; }
}
public string HaveCargoMark
{
get { return _HaveCargoMark; }
set { _HaveCargoMark = value; }
}
public string Productiondate
{
get { return _Productiondate; }
set { _Productiondate = value; }
}
public string BZTCHNO
{
get { return _BZTCHNO; }
set { _BZTCHNO = value; }
}
public string appusedweight
{
get { return _appusedweight; }
set { _appusedweight = value; }
}
public string HAVESAMPLE
{
get { return _HAVESAMPLE; }
set { _HAVESAMPLE = value; }
}
public string CHECKSAMPLE
{
get { return _CHECKSAMPLE; }
set { _CHECKSAMPLE = value; }
}
public string price
{
get { return _price; }
set { _price = value; }
}
public string price_agio
{
get { return _price_agio; }
set { _price_agio = value; }
}
[ModelDB]
public string CTN
{
get { return _CTN; }
set { _CTN = value; }
}
[ModelDB]
public string BILLTRANCNO
{
get { return _BILLTRANCNO; }
set { _BILLTRANCNO = value; }
}
public string SBYS
{
get { return _SBYS; }
set { _SBYS = value; }
}
public string BILL_RECEIVE_DATE
{
get { return _BILL_RECEIVE_DATE; }
set { _BILL_RECEIVE_DATE = value; }
}
public string BILL_SEND_DATE
{
get { return _BILL_SEND_DATE; }
set { _BILL_SEND_DATE = value; }
}
[ModelDB]
public string LOCK_EXCHANGERATE
{
get { return _LOCK_EXCHANGERATE; }
set { _LOCK_EXCHANGERATE = value; }
}
[ModelDB]
public string EXCHANGERATE
{
get { return _EXCHANGERATE; }
set { _EXCHANGERATE = value; }
}
[ModelDB]
public string Unsealdate
{
get { return _Unsealdate; }
set { _Unsealdate = value; }
}
[ModelDB]
public string ISREFORM
{
get { return _ISREFORM; }
set { _ISREFORM = value; }
}
public string InspectionNo
{
get { return _InspectionNo; }
set { _InspectionNo = value; }
}
public string IsRongZi
{
get { return _IsRongZi; }
set { _IsRongZi = value; }
}
public string MBLNOREPEAT
{
get { return _MBLNOREPEAT; }
set { _MBLNOREPEAT = value; }
}
public string LOADFINISH
{//永远都是1 用于在主表的编辑页面setvalues时最后触发change事件
get { return _LOADFINISH; }
set { _LOADFINISH = value; }
}
private string _Agent = string.Empty;
private string _Agent2 = string.Empty;
private string _Agent3 = string.Empty;
public string Agent
{
get { return _Agent; }
set { _Agent = value; }
}
public string Agent2
{
get { return _Agent2; }
set { _Agent2 = value; }
}
public string Agent3
{
get { return _Agent3; }
set { _Agent3 = value; }
}
private string _CreateTime_2 = string.Empty;
private string _ResendTime = string.Empty;
private string _Dock = string.Empty;
private string _Customs_broker = string.Empty;
private string _inspection_broker = string.Empty;
[ModelDB]
public string CreateTime_2
{
get { return _CreateTime_2; }
set { _CreateTime_2 = value; }
}
[ModelDB]
public string ResendTime
{
get { return _ResendTime; }
set { _ResendTime = value; }
}
[ModelDB]
public string Dock
{
get { return _Dock; }
set { _Dock = value; }
}
[ModelDB]
public string Customs_broker
{
get { return _Customs_broker; }
set { _Customs_broker = value; }
}
[ModelDB]
public string inspection_broker
{
get { return _inspection_broker; }
set { _inspection_broker = value; }
}
#endregion
#endregion
#region private Fields
private string _Supplier_Billno = string.Empty;
private string _ShipAgent = string.Empty;
private string _BillReleaseDate = string.Empty;
private string _IsLBill = string.Empty;
private string _LBillShipAgent = string.Empty;
private string _IsInnerLine = string.Empty;
private string _InnerLinePort = string.Empty;
private string _YARD = string.Empty;
private string _PriceLimitDate = string.Empty;
private string _PriceLimitRemark = string.Empty;
private string _ClearanceNo = string.Empty;
private string _ClearanceDate = string.Empty;
private string _TaxRecvDate = string.Empty;
private string _GetBoxDate = string.Empty;
private string _IsRec = string.Empty;
[ModelDB]
public string Supplier_Billno
{
get { return _Supplier_Billno; }
set { _Supplier_Billno = value; }
}
[ModelDB]
public string ShipAgent
{
get { return _ShipAgent; }
set { _ShipAgent = value; }
}
[ModelDB]
public string BillReleaseDate
{
get { return _BillReleaseDate; }
set { _BillReleaseDate = value; }
}
[ModelDB]
public string IsLBill
{
get { return _IsLBill; }
set { _IsLBill = value; }
}
[ModelDB]
public string LBillShipAgent
{
get { return _LBillShipAgent; }
set { _LBillShipAgent = value; }
}
[ModelDB]
public string IsInnerLine
{
get { return _IsInnerLine; }
set { _IsInnerLine = value; }
}
[ModelDB]
public string InnerLinePort
{
get { return _InnerLinePort; }
set { _InnerLinePort = value; }
}
[ModelDB]
public string YARD
{
get { return _YARD; }
set { _YARD = value; }
}
[ModelDB]
public string PriceLimitDate
{
get { return _PriceLimitDate; }
set { _PriceLimitDate = value; }
}
[ModelDB]
public string PriceLimitRemark
{
get { return _PriceLimitRemark; }
set { _PriceLimitRemark = value; }
}
[ModelDB]
public string ClearanceNo
{
get { return _ClearanceNo; }
set { _ClearanceNo = value; }
}
[ModelDB]
public string ClearanceDate
{
get { return _ClearanceDate; }
set { _ClearanceDate = value; }
}
[ModelDB]
public string TaxRecvDate
{
get { return _TaxRecvDate; }
set { _TaxRecvDate = value; }
}
[ModelDB]
public string GetBoxDate
{
get { return _GetBoxDate; }
set { _GetBoxDate = value; }
}
[ModelDB]
public string IsRec
{
get { return _IsRec; }
set { _IsRec = value; }
}
private string _FUNDDATE_1 = string.Empty;
[ModelDB]
public string FUNDDATE_1
{
get { return _FUNDDATE_1; }
set { _FUNDDATE_1 = value; }
}
#endregion
public XXH_HDmb ( )
{
// TableName = "tMsWlPcHead";
TableName = "Import_main";
}
public override string GetBillNoFieldName ( )
{
return "ContractNo";
}
}
#region 许可证使用
[JsonObject]
public class Appstatemb : ModelObjectBillBody
{
#region private Fields
/*
id int 自增
APP_id int 许可证id
Cargo_id int 货物id
weight numeric(18, 3) 使用重量
*/
private string _id = string.Empty;
private string _ContractNo = string.Empty;
private string _appno = string.Empty;
private string _app_id = string.Empty;
private string _name = string.Empty;
private string _company = string.Empty;
private string _cargo_id = string.Empty;
private string _cargoname = string.Empty;
private string _appweight = string.Empty;
private string _appremain = string.Empty;
private string _canbeused = string.Empty;
private string _country = string.Empty;
private string _weight = string.Empty;
private string _validdate = string.Empty;
private string _info = string.Empty;
private string _cancellation = string.Empty;
private string _cancellation_date = string.Empty;
private string _cancellationRef = string.Empty;
private string _companyname = string.Empty;
private string _remark = string.Empty;
private string _SEQUENCE = string.Empty;
private string _REMARK = string.Empty;
[ModelDB(MDBType = ModelDBOprationType.EditDelete, IsPrimary = true)]
public string id
{
get { return _id; }
set { _id = value; }
}
[ModelDB(MDBType = ModelDBOprationType.All, IsPrimary = true)]
public string ContractNo
{
get { return _ContractNo; }
set { _ContractNo = value; }
}
public string appno
{
get { return _appno; }
set { _appno = value; }
}
[ModelDB]
public string app_id
{
get { return _app_id; }
set { _app_id = value; }
}
public string name
{
get { return _name; }
set { _name = value; }
}
public string company
{
get { return _company; }
set { _company = value; }
}
[ModelDB]
public string cargo_id
{
get { return _cargo_id; }
set { _cargo_id = value; }
}
public string cargoname
{
get { return _cargoname; }
set { _cargoname = value; }
}
public string appweight
{
get { return _appweight; }
set { _appweight = value; }
}
public string appremain
{
get { return _appremain; }
set { _appremain = value; }
}
public string canbeused
{
get { return _canbeused; }
set { _canbeused = value; }
}
public string validdate
{
get { return _validdate; }
set { _validdate = value; }
}
public string country
{
get { return _country; }
set { _country = value; }
}
public string info
{
get { return _info; }
set { _info = value; }
}
[ModelDB]
public string weight
{
get { return _weight; }
set { _weight = value; }
}
[ModelDB]
public string cancellation
{
get { return _cancellation; }
set { _cancellation = value; }
}
[ModelDB]
public string cancellation_date
{
get { return _cancellation_date; }
set { _cancellation_date = value; }
}
[ModelDB]
public string REMARK
{
get { return _REMARK; }
set { _REMARK = value; }
}
public string cancellationRef
{
get { return _cancellationRef; }
set { _cancellationRef = value; }
}
public string companyname
{
get { return _companyname; }
set { _companyname = value; }
}
public string remark
{
get { return _remark; }
set { _remark = value; }
}
public string SEQUENCE
{
get { return _SEQUENCE; }
set { _SEQUENCE = value; }
}
#endregion
public Appstatemb()
{
TableName = "Import_Appstate";
}
public override string GetBillNoFieldName()
{
return "ContractNo";
}
}
#endregion
#region 库存记录
[JsonObject]
public class KCmb : ModelObjectBillBody
{
#region private Fields
/*
select k.id,k.contractno,k.cargo_id,c.name,K.czstate,
k.innum,k.outnum,k.kfstate,k.czdate,k.[text]
*
*/
private string _id = string.Empty;
private string _ContractNo = string.Empty;
private string _cargo_id = string.Empty;
private string _cargoname = string.Empty;
private string _czstate = string.Empty;
private string _innum = string.Empty;
private string _outnum = string.Empty;
private string _kfstate = string.Empty;
private string _text = string.Empty;
private string _kfref = string.Empty;
private string _czref = string.Empty;
private string _czdate = string.Empty;
private string _days = string.Empty;
private string _FeeName = string.Empty;
private string _UnitPrice = string.Empty;
private string _Quantity = string.Empty;
private string _Amount = string.Empty;
private string _Sended = string.Empty;
private string _TRUCKNO = string.Empty;
private string _TRUCKTEL = string.Empty;
private string _CORPID = string.Empty;
private string _ENTEROPERATOR = string.Empty;
private string _PLEDGE = string.Empty;
private string _PLEDGEREF = string.Empty;
private string _OWNER = string.Empty;
private string _OWNERREF = string.Empty;
[ModelDB(MDBType = ModelDBOprationType.EditDelete, IsPrimary = true)]
public string id
{
get { return _id; }
set { _id = value; }
}
[ModelDB]
public string ContractNo
{
get { return _ContractNo; }
set { _ContractNo = value; }
}
[ModelDB]
public string cargo_id
{
get { return _cargo_id; }
set { _cargo_id = value; }
}
public string cargoname
{
get { return _cargoname; }
set { _cargoname = value; }
}
public string czref
{
get { return _czref; }
set { _czref = value; }
}
public string kfref
{
get { return _kfref; }
set { _kfref = value; }
}
[ModelDB]
public string czstate
{
get { return _czstate; }
set { _czstate = value; }
}
[ModelDB]
public string innum
{
get { return _innum; }
set { _innum = value; }
}
[ModelDB]
public string outnum
{
get { return _outnum; }
set { _outnum = value; }
}
[ModelDB]
public string kfstate
{
get { return _kfstate; }
set { _kfstate = value; }
}
[ModelDB]
public string czdate
{
get { return _czdate; }
set { _czdate = value; }
}
[ModelDB]
public string text
{
get { return _text; }
set { _text = value; }
}
[ModelDB]
public string days
{
get { return _days; }
set { _days = value; }
}
[ModelDB]
public string FeeName
{
get { return _FeeName; }
set { _FeeName = value; }
}
[ModelDB]
public string UnitPrice
{
get { return _UnitPrice; }
set { _UnitPrice = value; }
}
[ModelDB]
public string Quantity
{
get { return _Quantity; }
set { _Quantity = value; }
}
[ModelDB]
public string Amount
{
get { return _Amount; }
set { _Amount = value; }
}
[ModelDB]
public string Sended
{
get { return _Sended; }
set { _Sended = value; }
}
[ModelDB]
public string TRUCKNO
{
get { return _TRUCKNO; }
set { _TRUCKNO = value; }
}
[ModelDB]
public string TRUCKTEL
{
get { return _TRUCKTEL; }
set { _TRUCKTEL = value; }
}
[ModelDB]
public string CORPID
{
get { return _CORPID; }
set { _CORPID = value; }
}
[ModelDB]
public string ENTEROPERATOR
{
get { return _ENTEROPERATOR; }
set { _ENTEROPERATOR = value; }
}
[ModelDB]
public string PLEDGE
{
get { return _PLEDGE; }
set { _PLEDGE = value; }
}
public string PLEDGEREF
{
get { return _PLEDGEREF; }
set { _PLEDGEREF = value; }
}
#endregion
public KCmb()
{
TableName = "Import_KC";
}
public override string GetBillNoFieldName()
{
return "ContractNo";
}
}
#endregion
#region 合同号记录(防重复)
[JsonObject]
public class HTmb : ModelObjectBillHead
{
#region private Fields
/*
public decimal Id { get; set; }
public string ContractNo { get; set; }
public string HTH { get; set; } */
public string Count { get; set; }
#endregion
public HTmb()
{
// TableName = "tMsWlPcHead";
TableName = "Import_main";
}
}
#endregion
#region 商品信息与许可证的匹配情况 返回是或否 1/0
[JsonObject]
public class AppCargomb : ModelObjectBillHead
{
#region private Fields
public string Match { get; set; }
#endregion
}
#endregion
#region 最近一次入库/结费时间
[JsonObject]
public class CZmb : ModelObjectBillHead
{
#region private Fields
/*
public decimal Id { get; set; }
public string ContractNo { get; set; }
public string HTH { get; set; } */
public string CZDate { get; set; }
public string CZstate { get; set; }
#endregion
public CZmb()
{
// TableName = "tMsWlPcHead";
TableName = "Import_KC";
}
}
#endregion
#region 获取毛利（存储过程）
[JsonObject]
public class MLmb : ModelObjectBillHead
{
#region private Fields
public string RMBYS { get; set; }
public string RMBYF { get; set; }
public string RMBML { get; set; }
public string USDYS { get; set; }
public string USDYF { get; set; }
public string USDML { get; set; }
public string ML { get; set; }
public string FHPROFIT { get; set; }
public string LCPROFIT { get; set; }
public string OTPROFIT { get; set; }
#endregion
}
#endregion
#region 获取字段值列表，用于自定义过滤
[JsonObject]
public class Fieldmb : ModelObjectBillHead
{
#region private Fields
public string FieldId { get; set; }
public string FieldValue { get; set; }
#endregion
}
#endregion
#region 合同内许可证使用情况统计
[JsonObject]
public class HTStatemb : ModelObjectBillHead
{
#region private Fields
public string APPNO { get; set; }
public string USEDWEIGHT { get; set; }
#endregion
}
#endregion
#region ImportLogmb
[JsonObject]
public class ImportLogmb : ModelObjectBillHead
{
private string _GID = string.Empty;
private string _USERID = string.Empty;
private string _CDATE = string.Empty;
private string _LOGINFO = string.Empty;
[ModelDB]
public string GID
{
get { return _GID; }
set { _GID = value; }
}
[ModelDB]
public string USERID
{
get { return _USERID; }
set { _USERID = value; }
}
[ModelDB]
public string CDATE
{
get { return _CDATE; }
set { _CDATE = value; }
}
[ModelDB]
public string LOGINFO
{
get { return _LOGINFO; }
set { _LOGINFO = value; }
}
}
#endregion
}