using System; using HcUtility.Core; using Newtonsoft.Json; namespace DSWeb.MvcShipping.Models.MsCwVouchers { [JsonObject] public class MsCwVouchers : ModelObjectBillHead { #region 读写属性 private string _ordno = ""; /// /// 唯一编码 /// [ModelDB(MDBType = ModelDBOprationType.All, IsPrimary = true)] public string ORDNO { get { return _ordno; } set { _ordno = value; } } private string _vouno = ""; /// /// 自动生成编号,月初清零 /// [ModelDB] public string VOUNO { get { return _vouno; } set { _vouno = value; } } private string _expvouno = ""; /// ///导出凭证号 /// public string EXPVOUNO { get { return _expvouno; } set { _expvouno = value; } } private string _vkno = ""; /// /// 凭证字 /// [ModelDB] public string VKNO { get { return _vkno; } set { _vkno = value; } } //private DateTime _voudate = DateTime.Now; ///// ///// 凭证日期 ///// //[ModelDB] //public DateTime VOUDATE //{ // get { return _voudate; } // set { _voudate = value; } //} private string _voudate = DateTime.Now.ToString(); /// /// 凭证日期 /// [ModelDB] public string VOUDATE { get { return _voudate; } set { _voudate = value; } } private string _accyear = ""; /// /// 年 /// [ModelDB] public string ACCYEAR { get { return _accyear; } set { _accyear = value; } } private string _accmonth = ""; /// /// 月 /// [ModelDB] public string ACCMONTH { get { return _accmonth; } set { _accmonth = value; } } private int _attachs = 1; /// /// 附件(单据)数 /// [ModelDB] public int ATTACHS { get { return _attachs; } set { _attachs = value; } } private decimal _amtdr = 0; /// /// 本位币借方 /// [ModelDB] public decimal AMTDR { get { return _amtdr; } set { _amtdr = value; } } private decimal _amtcr = 0; /// /// 本位币贷方 /// [ModelDB] public decimal AMTCR { get { return _amtcr; } set { _amtcr = value; } } private string _fcy = ""; /// /// 是否含有外币科目 /// [ModelDB] public string FCY { get { return _fcy; } set { _fcy = value; } } private string _qty = ""; /// /// 是否含有数量科目 /// [ModelDB] public string QTY { get { return _qty; } set { _qty = value; } } private string _vouprop = ""; /// /// 凭证属性 /// [ModelDB] public string VOUPROP { get { return _vouprop; } set { _vouprop = value; } } private string _prepared = ""; /// /// 制单人 /// [ModelDB] public string PREPARED { get { return _prepared; } set { _prepared = value; } } private string _checked = ""; /// /// 审核人 /// [ModelDB(MDBType = ModelDBOprationType.Insert)] public string CHECKED { get { return _checked; } set { _checked = value; } } private string _entered = ""; /// /// 记账人 /// [ModelDB] public string ENTERED { get { return _entered; } set { _entered = value; } } private string _errmsg = ""; /// /// 错误信息 /// [ModelDB] public string ERRMSG { get { return _errmsg; } set { _errmsg = value; } } private bool _isdelete = false; /// /// 是否废除 /// [ModelDB(MDBType = ModelDBOprationType.Insert)] public bool ISDELETE { get { return _isdelete; } set { _isdelete = value; } } private string _deleteuser = ""; /// /// 废除操作人 /// [ModelDB(MDBType = ModelDBOprationType.Insert)] public string DELETEUSER { get { return _deleteuser; } set { _deleteuser = value; } } private DateTime _deletetime = DateTime.Now; /// /// 废除时间 /// [ModelDB(MDBType = ModelDBOprationType.Insert)] public DateTime DELETETIME { get { return _deletetime; } set { _deletetime = value; } } private string _vouallno = ""; /// /// VOUALLNO /// [ModelDB] public string VOUALLNO { get { return _vouallno; } set { _vouallno = value; } } private bool _isexport = false; /// /// ISEXPORT /// [ModelDB] public bool ISEXPORT { get { return _isexport; } set { _isexport = value; } } private bool _ischecked = false; /// /// ISCHECKED /// [ModelDB(MDBType = ModelDBOprationType.Insert)] public bool ISCHECKED { get { return _ischecked; } set { _ischecked = value; } } private DateTime _checkedtime = DateTime.Now; /// /// CHECKEDTIME /// [ModelDB(MDBType = ModelDBOprationType.Insert)] public DateTime CHECKEDTIME { get { return _checkedtime; } set { _checkedtime = value; } } private string _carryovertype = ""; /// /// CarryOverType /// [ModelDB] public string CarryOverType { get { return _carryovertype; } set { _carryovertype = value; } } private string _MODIFIEDUSER = ""; /// /// 制单人 /// public string MODIFIEDUSER { get { return _MODIFIEDUSER; } set { _MODIFIEDUSER = value; } } #endregion public MsCwVouchers() { TableName = "cw_vouchers"; } override public string GetBillNoFieldName() { return "ORDNO"; } } // [JsonObject] public class MsCwVouitems : ModelObjectBillHead { #region 读写属性 private string _gid = ""; /// /// 唯一编码 /// [ModelDB(MDBType = ModelDBOprationType.All, IsPrimary = true)] public string GID { get { return _gid; } set { _gid = value; } } private string _ordno = ""; /// /// 关联cw_vouchers /// [ModelDB] public string ORDNO { get { return _ordno; } set { _ordno = value; } } private int _itemno = 0; /// /// 行号 /// [ModelDB] public int ITEMNO { get { return _itemno; } set { _itemno = value; } } private string _accid = ""; /// /// 科目代码 /// [ModelDB] public string ACCID { get { return _accid; } set { _accid = value; } } private string _paccid = ""; /// /// 父级科目代码 /// [ModelDB] public string PACCID { get { return _paccid; } set { _paccid = value; } } private string _accname = ""; /// /// 科目名称 /// [ModelDB] public string ACCNAME { get { return _accname; } set { _accname = value; } } private int _property = 0; /// /// 科目属性 /// [ModelDB] public int PROPERTY { get { return _property; } set { _property = value; } } private int _grade = 0; /// /// 科目级别 /// [ModelDB] public int GRADE { get { return _grade; } set { _grade = value; } } private string _dc = ""; /// /// 借贷方向 /// [ModelDB] public string DC { get { return _dc; } set { _dc = value; } } private decimal _amtdr = 0; /// /// 本位币借方金额(互斥) /// [ModelDB] public decimal AMTDR { get { return _amtdr; } set { _amtdr = value; } } private decimal _amtcr = 0; /// /// 本位币贷方金额(互斥) /// [ModelDB] public decimal AMTCR { get { return _amtcr; } set { _amtcr = value; } } private bool _isfcy = false; /// /// 是否外币 /// [ModelDB] public bool ISFCY { get { return _isfcy; } set { _isfcy = value; } } private string _fcyno = ""; /// /// 外币编号usd /// [ModelDB] public string FCYNO { get { return _fcyno; } set { _fcyno = value; } } private decimal _fcyexrate = 0; /// /// 汇率 /// [ModelDB] public decimal FCYEXRATE { get { return _fcyexrate; } set { _fcyexrate = value; } } private decimal _fcydr = 0; /// /// 外币借方金额 /// [ModelDB] public decimal FCYDR { get { return _fcydr; } set { _fcydr = value; } } private decimal _fcycr = 0; /// /// 外币贷方金额 /// [ModelDB] public decimal FCYCR { get { return _fcycr; } set { _fcycr = value; } } private string _qtyunit = ""; /// /// 数量包装单位 /// [ModelDB] public string QTYUNIT { get { return _qtyunit; } set { _qtyunit = value; } } private decimal _qtydr = 0; /// /// 借方数量 /// [ModelDB] public decimal QTYDR { get { return _qtydr; } set { _qtydr = value; } } private decimal _qtycr = 0; /// /// 贷方数量 /// [ModelDB] public decimal QTYCR { get { return _qtycr; } set { _qtycr = value; } } private string _explan = ""; /// /// 摘要,规则生成 /// [ModelDB] public string EXPLAN { get { return _explan; } set { _explan = value; } } private bool _isdeptacc = false; /// /// 核算部门,按规则设置生成 /// [ModelDB] public bool ISDEPTACC { get { return _isdeptacc; } set { _isdeptacc = value; } } private bool _isemplacc = false; /// /// 核算人员,按规则设置生成 /// [ModelDB] public bool ISEMPLACC { get { return _isemplacc; } set { _isemplacc = value; } } private bool _iscorpacc = false; /// /// 核算客户,按规则设置生成 /// [ModelDB] public bool ISCORPACC { get { return _iscorpacc; } set { _iscorpacc = value; } } private bool _isitemacc = false; /// /// 核算项目,按规则设置生成 /// [ModelDB] public bool ISITEMACC { get { return _isitemacc; } set { _isitemacc = value; } } private string _deptid = ""; /// /// 部门(系统) /// [ModelDB] public string DEPTID { get { return _deptid; } set { _deptid = value; } } private string _emplid = ""; /// /// 人员(系统) /// [ModelDB] public string EMPLID { get { return _emplid; } set { _emplid = value; } } private string _corpid = ""; /// /// 客户(系统) /// [ModelDB] public string CORPID { get { return _corpid; } set { _corpid = value; } } private int _pitemid = 0; /// /// 父级项目编号 /// [ModelDB] public int PITEMID { get { return _pitemid; } set { _pitemid = value; } } private string _itemid = ""; /// /// 项目编号 /// [ModelDB] public string ITEMID { get { return _itemid; } set { _itemid = value; } } private string _field10 = ""; /// /// 预留字段1 /// [ModelDB] public string FIELD10 { get { return _field10; } set { _field10 = value; } } private string _field9 = ""; /// /// 预留字段1 /// [ModelDB] public string FIELD9 { get { return _field9; } set { _field9 = value; } } private string _field8 = ""; /// /// 预留字段1 /// [ModelDB] public string FIELD8 { get { return _field8; } set { _field8 = value; } } private string _field7 = ""; /// /// 预留字段1 /// [ModelDB] public string FIELD7 { get { return _field7; } set { _field7 = value; } } private string _field6 = ""; /// /// 预留字段1 /// [ModelDB] public string FIELD6 { get { return _field6; } set { _field6 = value; } } private string _field5 = ""; /// /// 预留字段1 /// [ModelDB] public string FIELD5 { get { return _field5; } set { _field5 = value; } } private string _field4 = ""; /// /// 预留字段1 /// [ModelDB] public string FIELD4 { get { return _field4; } set { _field4 = value; } } private string _field3 = ""; /// /// 预留字段1 /// [ModelDB] public string FIELD3 { get { return _field3; } set { _field3 = value; } } private string _field2 = ""; /// /// 预留字段1 /// [ModelDB] public string FIELD2 { get { return _field2; } set { _field2 = value; } } private string _field1 = ""; /// /// 预留字段1 /// [ModelDB] public string FIELD1 { get { return _field1; } set { _field1 = value; } } private bool _issys = false; /// /// 是否手动录入 /// [ModelDB] public bool ISSYS { get { return _issys; } set { _issys = value; } } private string _fsettlcode = ""; /// /// 结算方式 /// [ModelDB] public string FSETTLCODE { get { return _fsettlcode; } set { _fsettlcode = value; } } private string _fsettleno = ""; /// /// 财务辅助编号 /// [ModelDB] public string FSETTLENO { get { return _fsettleno; } set { _fsettleno = value; } } private string _modifieduser = ""; /// /// 最后一次更新操作人 /// [ModelDB] public string MODIFIEDUSER { get { return _modifieduser; } set { _modifieduser = value; } } private DateTime _modifiedtime = DateTime.Now; /// /// 最后一次更新操作时间 /// [ModelDB] public DateTime MODIFIEDTIME { get { return _modifiedtime; } set { _modifiedtime = value; } } private string _customername = ""; /// /// CUSTOMERNAME /// [ModelDB] public string CUSTOMERNAME { get { return _customername; } set { _customername = value; } } private string _sale = ""; /// /// SALE /// [ModelDB] public string SALE { get { return _sale; } set { _sale = value; } } private string _blno = ""; /// /// BLNO /// [ModelDB] public string BLNO { get { return _blno; } set { _blno = value; } } private string _itemgid = ""; /// /// ITEMGID /// [ModelDB] public string ITEMGID { get { return _itemgid; } set { _itemgid = value; } } private string _deptgid = ""; /// /// DEPTGID /// [ModelDB] public string DEPTGID { get { return _deptgid; } set { _deptgid = value; } } private string _accall = ""; /// /// ACCALL /// [ModelDB] public string ACCALL { get { return _accall; } set { _accall = value; } } private string _ITEMNAME = ""; /// /// ITEMNAME /// public string ITEMNAME { get { return _ITEMNAME; } set { _ITEMNAME = value; } } private string _DEPTNAME = ""; /// /// DEPTNAME /// public string DEPTNAME { get { return _DEPTNAME; } set { _DEPTNAME = value; } } private decimal _FCYAMT = 0; /// /// 外币金额 /// public decimal FCYAMT { get { return _FCYAMT; } set { _FCYAMT = value; } } #endregion public MsCwVouitems() { TableName = "cw_vouitems"; } override public string GetBillNoFieldName() { return "GID"; } } // [JsonObject] public class MsCwVouchersVouitems : ModelObjectBillHead { #region 读写属性 private string _ordno = ""; /// /// ORDNO /// public string ORDNO { get { return _ordno; } set { _ordno = value; } } private string _vouno = ""; /// /// VOUNO /// public string VOUNO { get { return _vouno; } set { _vouno = value; } } private string _vkno = ""; /// /// VKNO /// public string VKNO { get { return _vkno; } set { _vkno = value; } } private string _voudate = ""; /// /// VOUDATE /// public string VOUDATE { get { return _voudate; } set { _voudate = value; } } private string _accyear = ""; /// /// ACCYEAR /// public string ACCYEAR { get { return _accyear; } set { _accyear = value; } } private string _accmonth = ""; /// /// ACCMONTH /// public string ACCMONTH { get { return _accmonth; } set { _accmonth = value; } } private int _attachs = 1; /// /// ATTACHS /// public int ATTACHS { get { return _attachs; } set { _attachs = value; } } private string _ACCDATE = ""; /// /// ACCDATE /// public string ACCDATE { get { return _ACCDATE; } set { _ACCDATE = value; } } private string _fcy = ""; /// /// FCY /// public string FCY { get { return _fcy; } set { _fcy = value; } } private string _qty = ""; /// /// QTY /// public string QTY { get { return _qty; } set { _qty = value; } } private string _vouprop = ""; /// /// VOUPROP /// public string VOUPROP { get { return _vouprop; } set { _vouprop = value; } } private string _prepared = ""; /// /// PREPARED /// public string PREPARED { get { return _prepared; } set { _prepared = value; } } private string _checked = ""; /// /// CHECKED /// public string CHECKED { get { return _checked; } set { _checked = value; } } private string _entered = ""; /// /// ENTERED /// public string ENTERED { get { return _entered; } set { _entered = value; } } private string _errmsg = ""; /// /// ERRMSG /// public string ERRMSG { get { return _errmsg; } set { _errmsg = value; } } private bool _isdelete = false; /// /// ISDELETE /// public bool ISDELETE { get { return _isdelete; } set { _isdelete = value; } } private string _deleteuser = ""; /// /// DELETEUSER /// public string DELETEUSER { get { return _deleteuser; } set { _deleteuser = value; } } private DateTime _deletetime = DateTime.Now; /// /// DELETETIME /// public DateTime DELETETIME { get { return _deletetime; } set { _deletetime = value; } } private string _vouallno = ""; /// /// VOUALLNO /// public string VOUALLNO { get { return _vouallno; } set { _vouallno = value; } } private string _mblno = ""; /// /// MBLNO /// public string MBLNO { get { return _mblno; } set { _mblno = value; } } private string _gid = ""; /// /// GID /// public string GID { get { return _gid; } set { _gid = value; } } private int _itemno = 0; /// /// ITEMNO /// public int ITEMNO { get { return _itemno; } set { _itemno = value; } } private string _accid = ""; /// /// ACCID /// public string ACCID { get { return _accid; } set { _accid = value; } } private string _paccid = ""; /// /// PACCID /// public string PACCID { get { return _paccid; } set { _paccid = value; } } private string _accname = ""; /// /// ACCNAME /// public string ACCNAME { get { return _accname; } set { _accname = value; } } private int _property = 0; /// /// PROPERTY /// public int PROPERTY { get { return _property; } set { _property = value; } } private int _grade = 0; /// /// GRADE /// public int GRADE { get { return _grade; } set { _grade = value; } } private string _dc = ""; /// /// DC /// public string DC { get { return _dc; } set { _dc = value; } } private decimal _amtdr = 0; /// /// AMTDR /// public decimal AMTDR { get { return _amtdr; } set { _amtdr = value; } } private decimal _amtcr = 0; /// /// AMTCR /// public decimal AMTCR { get { return _amtcr; } set { _amtcr = value; } } private bool _isfcy = false; /// /// ISFCY /// public bool ISFCY { get { return _isfcy; } set { _isfcy = value; } } private string _fcyno = ""; /// /// FCYNO /// public string FCYNO { get { return _fcyno; } set { _fcyno = value; } } private decimal _fcyexrate = 0; /// /// FCYEXRATE /// public decimal FCYEXRATE { get { return _fcyexrate; } set { _fcyexrate = value; } } private decimal _fcydr = 0; /// /// FCYDR /// public decimal FCYDR { get { return _fcydr; } set { _fcydr = value; } } private decimal _fcycr = 0; /// /// FCYCR /// public decimal FCYCR { get { return _fcycr; } set { _fcycr = value; } } private string _qtyunit = ""; /// /// QTYUNIT /// public string QTYUNIT { get { return _qtyunit; } set { _qtyunit = value; } } private decimal _qtydr = 0; /// /// QTYDR /// public decimal QTYDR { get { return _qtydr; } set { _qtydr = value; } } private decimal _qtycr = 0; /// /// QTYCR /// public decimal QTYCR { get { return _qtycr; } set { _qtycr = value; } } private string _explan = ""; /// /// EXPLAN /// public string EXPLAN { get { return _explan; } set { _explan = value; } } private bool _isdeptacc = false; /// /// ISDEPTACC /// public bool ISDEPTACC { get { return _isdeptacc; } set { _isdeptacc = value; } } private bool _isemplacc = false; /// /// ISEMPLACC /// public bool ISEMPLACC { get { return _isemplacc; } set { _isemplacc = value; } } private bool _iscorpacc = false; /// /// ISCORPACC /// public bool ISCORPACC { get { return _iscorpacc; } set { _iscorpacc = value; } } private bool _isitemacc = false; /// /// ISITEMACC /// public bool ISITEMACC { get { return _isitemacc; } set { _isitemacc = value; } } private string _deptid = ""; /// /// DEPTID /// public string DEPTID { get { return _deptid; } set { _deptid = value; } } private string _emplid = ""; /// /// EMPLID /// public string EMPLID { get { return _emplid; } set { _emplid = value; } } private string _corpid = ""; /// /// CORPID /// public string CORPID { get { return _corpid; } set { _corpid = value; } } private int _pitemid = 0; /// /// PITEMID /// public int PITEMID { get { return _pitemid; } set { _pitemid = value; } } private string _itemid = ""; /// /// ITEMID /// public string ITEMID { get { return _itemid; } set { _itemid = value; } } private string _field10 = ""; /// /// FIELD10 /// public string FIELD10 { get { return _field10; } set { _field10 = value; } } private string _field9 = ""; /// /// FIELD9 /// public string FIELD9 { get { return _field9; } set { _field9 = value; } } private string _field8 = ""; /// /// FIELD8 /// public string FIELD8 { get { return _field8; } set { _field8 = value; } } private string _field7 = ""; /// /// FIELD7 /// public string FIELD7 { get { return _field7; } set { _field7 = value; } } private string _field6 = ""; /// /// FIELD6 /// public string FIELD6 { get { return _field6; } set { _field6 = value; } } private string _field5 = ""; /// /// FIELD5 /// public string FIELD5 { get { return _field5; } set { _field5 = value; } } private string _field4 = ""; /// /// FIELD4 /// public string FIELD4 { get { return _field4; } set { _field4 = value; } } private string _field3 = ""; /// /// FIELD3 /// public string FIELD3 { get { return _field3; } set { _field3 = value; } } private string _field2 = ""; /// /// FIELD2 /// public string FIELD2 { get { return _field2; } set { _field2 = value; } } private string _field1 = ""; /// /// FIELD1 /// public string FIELD1 { get { return _field1; } set { _field1 = value; } } private bool _issys = false; /// /// ISSYS /// public bool ISSYS { get { return _issys; } set { _issys = value; } } private string _fsettlcode = ""; /// /// FSETTLCODE /// public string FSETTLCODE { get { return _fsettlcode; } set { _fsettlcode = value; } } private string _fsettleno = ""; /// /// FSETTLENO /// public string FSETTLENO { get { return _fsettleno; } set { _fsettleno = value; } } private string _modifieduser = ""; /// /// MODIFIEDUSER /// public string MODIFIEDUSER { get { return _modifieduser; } set { _modifieduser = value; } } private DateTime _modifiedtime = DateTime.Now; /// /// MODIFIEDTIME /// public DateTime MODIFIEDTIME { get { return _modifiedtime; } set { _modifiedtime = value; } } private string _customername = ""; /// /// CUSTOMERNAME /// public string CUSTOMERNAME { get { return _customername; } set { _customername = value; } } private string _sale = ""; /// /// SALE /// public string SALE { get { return _sale; } set { _sale = value; } } private string _blno = ""; /// /// BLNO /// public string BLNO { get { return _blno; } set { _blno = value; } } private string _deptacc = ""; /// /// DEPTACC /// public string DEPTACC { get { return _deptacc; } set { _deptacc = value; } } private string _emplacc = ""; /// /// EMPLACC /// public string EMPLACC { get { return _emplacc; } set { _emplacc = value; } } private string _corpacc = ""; /// /// CORPACC /// public string CORPACC { get { return _corpacc; } set { _corpacc = value; } } private string _expvouno = ""; /// /// CORPACC /// public string EXPVOUNO { get { return _expvouno; } set { _expvouno = value; } } private string _itemacc = ""; /// /// ITEMACC /// public string ITEMACC { get { return _itemacc; } set { _itemacc = value; } } private bool _isexport = false; /// /// ISEXPORT /// public bool ISEXPORT { get { return _isexport; } set { _isexport = value; } } private string _itemgid = ""; /// /// ITEMGID /// public string ITEMGID { get { return _itemgid; } set { _itemgid = value; } } private string _deptgid = ""; /// /// DEPTGID /// public string DEPTGID { get { return _deptgid; } set { _deptgid = value; } } private string _accall = ""; /// /// ACCALL /// public string ACCALL { get { return _accall; } set { _accall = value; } } private bool _ischecked = false; /// /// ISCHECKED /// public bool ISCHECKED { get { return _ischecked; } set { _ischecked = value; } } private DateTime _checkedtime = DateTime.Now; /// /// CHECKEDTIME /// public DateTime CHECKEDTIME { get { return _checkedtime; } set { _checkedtime = value; } } private string _carryovertype = ""; /// /// CarryOverType /// public string CarryOverType { get { return _carryovertype; } set { _carryovertype = value; } } #endregion public MsCwVouchersVouitems() { TableName = "VW_cw_vouchers_vouitems"; } override public string GetBillNoFieldName() { return "GID"; } } }