|
|
using System;
|
|
|
using HcUtility.Core;
|
|
|
using Newtonsoft.Json;
|
|
|
|
|
|
namespace DSWeb.MvcShipping.Models.MsOpBillProfit
|
|
|
{
|
|
|
[JsonObject]
|
|
|
public class MsOpBillProfit : ModelObjectBillBody
|
|
|
{
|
|
|
#region 读写属性
|
|
|
/// <summary>
|
|
|
/// 业务编号
|
|
|
/// </summary>
|
|
|
private string _BSNO ="";//业务编号
|
|
|
public string BSNO {get{return _BSNO ;}set { _BSNO = value;}}
|
|
|
|
|
|
/// <summary>
|
|
|
/// 业务状态
|
|
|
/// </summary>
|
|
|
private bool _BSSTATUS;//业务状态
|
|
|
private bool _FEESTATUS;//业务状态
|
|
|
///
|
|
|
public bool BSSTATUS { get { return _BSSTATUS; } set { _BSSTATUS = value; } }
|
|
|
public bool FEESTATUS { get { return _FEESTATUS; } set { _FEESTATUS = value; } }
|
|
|
private string _BSSTATUSREF;//业务状态
|
|
|
private string _FEESTATUSREF;//业务状态
|
|
|
public string BSSTATUSREF { get { return _BSSTATUSREF; } set { _BSSTATUSREF = value; } }
|
|
|
public string FEESTATUSREF { get { return _FEESTATUSREF; } set { _FEESTATUSREF = value; } }
|
|
|
|
|
|
private string _ISSALEFEE="未发放";//业务状态
|
|
|
public string ISSALEFEE { get { return _ISSALEFEE; } set { _ISSALEFEE = value; } }
|
|
|
|
|
|
/// <summary>
|
|
|
/// 会计期间
|
|
|
/// </summary>
|
|
|
|
|
|
private string _ACCDATE = "";//会计期间 ///
|
|
|
public string ACCDATE {get{return _ACCDATE ;}set { _ACCDATE = value;}}
|
|
|
|
|
|
private string _OPTYPE = "";//更改单
|
|
|
public string OPTYPE { get { return _OPTYPE; } set { _OPTYPE = value; } }
|
|
|
|
|
|
private string _OPLB = "";//业务类型
|
|
|
private string _OPLBNAME = "";//业务类型
|
|
|
public string OPLB { get { return _OPLB; } set { _OPLB = value; } }
|
|
|
public string OPLBNAME { get { return _OPLBNAME; } set { _OPLBNAME = value; } }
|
|
|
|
|
|
/// <summary>
|
|
|
/// 主提单号
|
|
|
/// </summary>
|
|
|
private string _MBLNO = "";//主提单号
|
|
|
public string MBLNO {get{return _MBLNO ;}set { _MBLNO = value;}}
|
|
|
|
|
|
/// <summary>
|
|
|
/// 分提单号
|
|
|
/// </summary>
|
|
|
private string _HBLNO = "";//分提单号 ///
|
|
|
public string HBLNO {get{return _HBLNO ;}set { _HBLNO = value;}}
|
|
|
|
|
|
/// <summary>
|
|
|
/// 委托编号
|
|
|
/// </summary>
|
|
|
private string _CUSTNO = "";//委托编号
|
|
|
///
|
|
|
public string CUSTNO {get{return _CUSTNO ;}set { _CUSTNO = value;}}
|
|
|
private string _CUSTOMNO = "";//报关单号
|
|
|
public string CUSTOMNO { get { return _CUSTOMNO; } set { _CUSTOMNO = value; } }
|
|
|
|
|
|
/// <summary>
|
|
|
/// 委托单位
|
|
|
/// </summary>
|
|
|
private string _CUSTOMERNAME = "";//委托单位
|
|
|
public string CUSTOMERNAME {get{return _CUSTOMERNAME ;}set { _CUSTOMERNAME = value;}}
|
|
|
|
|
|
/// <summary>
|
|
|
/// 船名
|
|
|
/// </summary>
|
|
|
private string _VESSEL = "";//船名
|
|
|
public string VESSEL {get{return _VESSEL ;}set { _VESSEL = value;}}
|
|
|
|
|
|
/// <summary>
|
|
|
/// 航次
|
|
|
/// </summary>
|
|
|
private string _VOYNO = "";//航次
|
|
|
public string VOYNO {get{return _VOYNO ;}set { _VOYNO = value;}}
|
|
|
|
|
|
/// <summary>
|
|
|
/// 船公司
|
|
|
/// </summary>
|
|
|
private string _CARRIER = "";//船公司
|
|
|
public string CARRIER { get { return _CARRIER; } set { _CARRIER = value; } }
|
|
|
|
|
|
/// <summary>
|
|
|
/// 货代
|
|
|
/// </summary>
|
|
|
private string _FORWARDER = "";//船公司
|
|
|
public string FORWARDER { get { return _FORWARDER; } set { _FORWARDER = value; } }
|
|
|
|
|
|
/// <summary>
|
|
|
/// 开船日期
|
|
|
/// </summary>
|
|
|
private string _ETD;//开船日期
|
|
|
public string ETD { get { return _ETD; } set { _ETD = value; } }
|
|
|
|
|
|
private string _STLDATE;//开船日期
|
|
|
public string STLDATE { get { return _STLDATE; } set { _STLDATE = value; } }
|
|
|
|
|
|
private string _STLNAME;//开船日期
|
|
|
public string STLNAME { get { return _STLNAME; } set { _STLNAME = value; } }
|
|
|
|
|
|
private string _OPDATE;//开船日期
|
|
|
public string OPDATE { get { return _OPDATE; } set { _OPDATE = value; } }
|
|
|
|
|
|
private string _CUSTOMDATE;//开船日期
|
|
|
public string CUSTOMDATE { get { return _CUSTOMDATE; } set { _CUSTOMDATE = value; } }
|
|
|
/// <summary>
|
|
|
/// 卸货港代码
|
|
|
/// </summary>
|
|
|
private string _PORTLOAD = "";//卸货港代码
|
|
|
public string PORTLOAD { get { return _PORTLOAD; } set { _PORTLOAD = value; } }
|
|
|
|
|
|
/// <summary>
|
|
|
/// 卸货港
|
|
|
/// </summary>
|
|
|
private string _PORTDISCHARGE = "";//卸货港
|
|
|
public string PORTDISCHARGE {get{return _PORTDISCHARGE ;}set { _PORTDISCHARGE = value;}}
|
|
|
|
|
|
/// <summary>
|
|
|
/// 航线
|
|
|
/// </summary>
|
|
|
private string _LANE = "";//航线
|
|
|
public string LANE { get { return _LANE; } set { _LANE = value; } }
|
|
|
private string _blfrt = "FREIGHT PREPAID";
|
|
|
/// <summary>
|
|
|
/// 付费方式
|
|
|
/// </summary>
|
|
|
public string BLFRT { get { return _blfrt; } set { _blfrt = value; } }
|
|
|
|
|
|
private decimal _kgs = 0;
|
|
|
/// <summary>
|
|
|
/// 毛重
|
|
|
/// </summary>
|
|
|
public decimal KGS { get { return _kgs; } set { _kgs = value; } }
|
|
|
|
|
|
|
|
|
private int _pkgs = 0;
|
|
|
/// <summary>
|
|
|
/// 件数
|
|
|
/// </summary>
|
|
|
public int PKGS { get { return _pkgs; } set { _pkgs = value; } }
|
|
|
|
|
|
private decimal _cbm = 0;
|
|
|
/// <summary>
|
|
|
/// 尺码
|
|
|
/// </summary>
|
|
|
public decimal CBM { get { return _cbm; } set { _cbm = value; } }
|
|
|
|
|
|
/// <summary>
|
|
|
/// 集装箱
|
|
|
/// </summary>
|
|
|
private string _CNTRTOTAL = "";//操作员
|
|
|
public string CNTRTOTAL { get { return _CNTRTOTAL; } set { _CNTRTOTAL = value; } }
|
|
|
|
|
|
/// <summary>
|
|
|
/// 录入人
|
|
|
/// </summary>
|
|
|
private string _INPUTBY = "";//操作员
|
|
|
public string INPUTBY {get{return _INPUTBY ;}set { _INPUTBY = value;}}
|
|
|
|
|
|
/// <summary>
|
|
|
/// 操作员
|
|
|
/// </summary>
|
|
|
private string _OP = "";//揽货人
|
|
|
public string OP {get{return _OP ;}set { _OP = value;}}
|
|
|
|
|
|
/// <summary>
|
|
|
/// 客服
|
|
|
/// </summary>
|
|
|
private string _CUSTSERVICE = "";//揽货人 ///
|
|
|
public string CUSTSERVICE {get{return _CUSTSERVICE ;}set { _CUSTSERVICE = value;}}
|
|
|
|
|
|
/// <summary>
|
|
|
/// 单证
|
|
|
/// </summary>
|
|
|
private string _DOC = "";//揽货人
|
|
|
public string DOC {get{return _DOC ;}set { _DOC = value;}}
|
|
|
|
|
|
/// <summary>
|
|
|
/// 揽货人
|
|
|
/// </summary>
|
|
|
private string _SALE = "";//揽货人
|
|
|
public string SALE {get{return _SALE ;}set { _SALE = value;}}
|
|
|
|
|
|
/// <summary>
|
|
|
/// 业务来源
|
|
|
/// </summary>
|
|
|
private string _BSSOURCE = "";//业务来源
|
|
|
public string BSSOURCE {get{return _BSSOURCE ;}set { _BSSOURCE = value;}}
|
|
|
|
|
|
/// <summary>
|
|
|
/// 来源明细
|
|
|
/// </summary>
|
|
|
private string _BSSOURCEDETAIL = "";//来源明细
|
|
|
public string BSSOURCEDETAIL {get{return _BSSOURCEDETAIL ;}set { _BSSOURCEDETAIL = value;}}
|
|
|
|
|
|
private string _CORPID = "";//分公司代码
|
|
|
public string CORPID {get{return _CORPID ;}set { _CORPID = value;}}
|
|
|
|
|
|
private decimal _RMBDR = 0;
|
|
|
public decimal RMBDR { get { return _RMBDR; } set { _RMBDR = value; } }
|
|
|
private decimal _RMBCR = 0;
|
|
|
public decimal RMBCR { get { return _RMBCR; } set { _RMBCR = value; } }
|
|
|
private decimal _STLRMBDR = 0;
|
|
|
public decimal STLRMBDR { get { return _STLRMBDR; } set { _STLRMBDR = value; } }
|
|
|
private decimal _STLRMBCR = 0;
|
|
|
public decimal STLRMBCR { get { return _STLRMBCR; } set { _STLRMBCR = value; } }
|
|
|
private decimal _RMBNODR = 0;
|
|
|
public decimal RMBNODR { get { return _RMBNODR; } set { _RMBNODR = value; } }
|
|
|
private decimal _RMBNOCR = 0;
|
|
|
public decimal RMBNOCR { get { return _RMBNOCR; } set { _RMBNOCR = value; } }
|
|
|
private decimal _RMBPROFIT = 0;
|
|
|
public decimal RMBPROFIT { get { return _RMBPROFIT; } set { _RMBPROFIT = value; } }
|
|
|
|
|
|
private decimal _USDDR = 0;
|
|
|
public decimal USDDR { get { return _USDDR; } set { _USDDR = value; } }
|
|
|
private decimal _USDCR = 0;
|
|
|
public decimal USDCR { get { return _USDCR; } set { _USDCR = value; } }
|
|
|
private decimal _STLUSDDR = 0;
|
|
|
public decimal STLUSDDR { get { return _STLUSDDR; } set { _STLUSDDR = value; } }
|
|
|
private decimal _STLUSDCR = 0;
|
|
|
public decimal STLUSDCR { get { return _STLUSDCR; } set { _STLUSDCR = value; } }
|
|
|
private decimal _USDNODR = 0;
|
|
|
public decimal USDNODR { get { return _USDNODR; } set { _USDNODR = value; } }
|
|
|
private decimal _USDNOCR = 0;
|
|
|
public decimal USDNOCR { get { return _USDNOCR; } set { _USDNOCR = value; } }
|
|
|
private decimal _USDPROFIT = 0;
|
|
|
public decimal USDPROFIT { get { return _USDPROFIT; } set { _USDPROFIT = value; } }
|
|
|
|
|
|
|
|
|
private decimal _OTDR = 0;
|
|
|
public decimal OTDR { get { return _OTDR; } set { _OTDR = value; } }
|
|
|
private decimal _OTCR = 0;
|
|
|
public decimal OTCR { get { return _OTCR; } set { _OTCR = value; } }
|
|
|
private decimal _STLOTDR = 0;
|
|
|
public decimal STLOTDR { get { return _STLOTDR; } set { _STLOTDR = value; } }
|
|
|
private decimal _STLOTCR = 0;
|
|
|
public decimal STLOTCR { get { return _STLOTCR; } set { _STLOTCR = value; } }
|
|
|
private decimal _OTNODR = 0;
|
|
|
public decimal OTNODR { get { return _OTNODR; } set { _OTNODR = value; } }
|
|
|
private decimal _OTNOCR = 0;
|
|
|
public decimal OTNOCR { get { return _OTNOCR; } set { _OTNOCR = value; } }
|
|
|
private decimal _OTPROFIT = 0;
|
|
|
public decimal OTPROFIT { get { return _OTPROFIT; } set { _OTPROFIT = value; } }
|
|
|
|
|
|
|
|
|
private decimal _TTLDR = 0;
|
|
|
public decimal TTLDR { get { return _TTLDR; } set { _TTLDR = value; } }
|
|
|
private decimal _TTLCR = 0;
|
|
|
public decimal TTLCR { get { return _TTLCR; } set { _TTLCR = value; } }
|
|
|
private decimal _STLTTLDR = 0;
|
|
|
public decimal STLTTLDR { get { return _STLTTLDR; } set { _STLTTLDR = value; } }
|
|
|
private decimal _MONTHSTLTTLDR = 0;
|
|
|
public decimal MONTHSTLTTLDR { get { return _MONTHSTLTTLDR; } set { _MONTHSTLTTLDR = value; } }
|
|
|
|
|
|
private decimal _STLTTLCR = 0;
|
|
|
public decimal STLTTLCR { get { return _STLTTLCR; } set { _STLTTLCR = value; } }
|
|
|
private decimal _TTLNODR = 0;
|
|
|
public decimal TTLNODR { get { return _TTLNODR; } set { _TTLNODR = value; } }
|
|
|
private decimal _TTLNOCR = 0;
|
|
|
public decimal TTLNOCR { get { return _TTLNOCR; } set { _TTLNOCR = value; } }
|
|
|
private decimal _TTLPROFIT = 0;
|
|
|
public decimal TTLPROFIT { get { return _TTLPROFIT; } set { _TTLPROFIT = value; } }
|
|
|
private decimal _INTEREST = 0;
|
|
|
public decimal INTEREST { get { return _INTEREST; } set { _INTEREST = value; } }
|
|
|
private decimal _PROFITSHARE = 0;
|
|
|
public decimal PROFITSHARE { get { return _PROFITSHARE; } set { _PROFITSHARE = value; } }
|
|
|
|
|
|
private string _PROFITRATE = "";
|
|
|
public string PROFITRATE { get { return _PROFITRATE; } set { _PROFITRATE = value; } }
|
|
|
private string _SETTLETIME = "";
|
|
|
public string SETTLETIME { get { return _SETTLETIME; } set { _SETTLETIME = value; } }
|
|
|
|
|
|
private string _SETTLETIME_T = "";//需求编号：SR2017072100012
|
|
|
public string SETTLETIME_T { get { return _SETTLETIME_T; } set { _SETTLETIME_T = value; } }
|
|
|
private string _SETTLETIME_Y = "";//需求编号：SR2017072100012
|
|
|
public string SETTLETIME_Y { get { return _SETTLETIME_Y; } set { _SETTLETIME_Y = value; } }
|
|
|
|
|
|
#region 用于业务员提成报表，自动计算的字段显示
|
|
|
private decimal _ShuiFei = 0;
|
|
|
/// <summary>
|
|
|
/// 税费
|
|
|
/// </summary>
|
|
|
public decimal ShuiFei { get { return _ShuiFei; } set { _ShuiFei = value; } }
|
|
|
|
|
|
private decimal _YeWuFeiYong = 0;
|
|
|
/// <summary>
|
|
|
/// 业务费用
|
|
|
/// </summary>
|
|
|
public decimal YeWuFeiYong { get { return _YeWuFeiYong; } set { _YeWuFeiYong = value; } }
|
|
|
|
|
|
private decimal _JingLiRun = 0;
|
|
|
/// <summary>
|
|
|
/// 净利润
|
|
|
/// </summary>
|
|
|
public decimal JingLiRun { get { return _JingLiRun; } set { _JingLiRun = value; } }
|
|
|
|
|
|
private decimal _TiChengJiShu = 0;
|
|
|
/// <summary>
|
|
|
/// 提成基数
|
|
|
/// </summary>
|
|
|
public decimal TiChengJiShu { get { return _TiChengJiShu; } set { _TiChengJiShu = value; } }
|
|
|
|
|
|
private decimal _GeRenFeiYong = 0;
|
|
|
/// <summary>
|
|
|
/// 个人费用
|
|
|
/// </summary>
|
|
|
public decimal GeRenFeiYong { get { return _GeRenFeiYong; } set { _GeRenFeiYong = value; } }
|
|
|
|
|
|
private decimal _TiChengQuJian = 0;
|
|
|
/// <summary>
|
|
|
/// 提成区间
|
|
|
/// </summary>
|
|
|
public decimal TiChengQuJian { get { return _TiChengQuJian; } set { _TiChengQuJian = value; } }
|
|
|
|
|
|
private decimal _TiChengBiLi = 0;
|
|
|
/// <summary>
|
|
|
/// 提成比例
|
|
|
/// </summary>
|
|
|
public decimal TiChengBiLi { get { return _TiChengBiLi; } set { _TiChengBiLi = value; } }
|
|
|
public string TiChengBiLiStr { get; set; }
|
|
|
|
|
|
private decimal _ShiJiTiChengBiLi = 0;
|
|
|
/// <summary>
|
|
|
/// 实际提成比例
|
|
|
/// </summary>
|
|
|
public decimal ShiJiTiChengBiLi { get { return _ShiJiTiChengBiLi; } set { _ShiJiTiChengBiLi = value; } }
|
|
|
|
|
|
private decimal _TiCheng = 0;
|
|
|
/// <summary>
|
|
|
/// 提成
|
|
|
/// </summary>
|
|
|
public decimal TiCheng { get { return _TiCheng; } set { _TiCheng = value; } }
|
|
|
|
|
|
private decimal _ShiFa = 0;
|
|
|
/// <summary>
|
|
|
/// 实发提成
|
|
|
/// </summary>
|
|
|
public decimal ShiFa { get { return _ShiFa; } set { _ShiFa = value; } }
|
|
|
|
|
|
private string _YingJieRiQi = "";
|
|
|
/// <summary>
|
|
|
/// 应结日期
|
|
|
/// </summary>
|
|
|
public string YingJieRiQi { get { return _YingJieRiQi; } set { _YingJieRiQi = value; } }
|
|
|
|
|
|
private string _ShiJieRiQi = "";
|
|
|
/// <summary>
|
|
|
/// 实结日期
|
|
|
/// </summary>
|
|
|
public string ShiJieRiQi { get { return _ShiJieRiQi; } set { _ShiJieRiQi = value; } }
|
|
|
#endregion
|
|
|
|
|
|
public int ACTUALDAY { get; set; }
|
|
|
public int NODAY { get; set; }
|
|
|
public int ACTNODAY { get; set; }
|
|
|
public int NOMONTH { get; set; }
|
|
|
public decimal COMPR { get; set; }
|
|
|
|
|
|
public string ETDMONTH { get; set;}
|
|
|
|
|
|
public string PRREMARK { get; set; }
|
|
|
|
|
|
public string FCOP { get; set; }
|
|
|
|
|
|
#endregion
|
|
|
|
|
|
public MsOpBillProfit()
|
|
|
{
|
|
|
TableName = "op_bill";
|
|
|
}
|
|
|
|
|
|
override public string GetBillNoFieldName()
|
|
|
{
|
|
|
return "BsNo";
|
|
|
}
|
|
|
}
|
|
|
|
|
|
public class MsSaleMonthProfit : ModelObjectBillBody
|
|
|
{
|
|
|
#region 读写属性
|
|
|
|
|
|
/// <summary>
|
|
|
/// 揽货人
|
|
|
/// </summary>
|
|
|
private string _SALE = "";//揽货人
|
|
|
public string SALE { get { return _SALE; } set { _SALE = value; } }
|
|
|
|
|
|
/// <summary>
|
|
|
/// 业务来源
|
|
|
/// </summary>
|
|
|
private string _ETDMONTH = "";//业务来源
|
|
|
public string ETDMONTH { get { return _ETDMONTH; } set { _ETDMONTH = value; } }
|
|
|
|
|
|
private decimal _TTLPROFIT = 0;
|
|
|
public decimal TTLPROFIT { get { return _TTLPROFIT; } set { _TTLPROFIT = value; } }
|
|
|
|
|
|
|
|
|
#endregion
|
|
|
|
|
|
public MsSaleMonthProfit()
|
|
|
{
|
|
|
TableName = "op_bill";
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
public class CustomerRefModel : ModelObjectBillBody
|
|
|
{
|
|
|
#region 读写属性
|
|
|
|
|
|
public string CUSTOMERNAME { get; set; }
|
|
|
private decimal _TICHENG = 0;
|
|
|
public decimal TICHENG { get { return _TICHENG; } set { _TICHENG = value; } }
|
|
|
|
|
|
private decimal _FENCHENG = 0;
|
|
|
public decimal FENCHENG { get { return _FENCHENG; } set { _FENCHENG = value; } }
|
|
|
|
|
|
#endregion
|
|
|
|
|
|
public CustomerRefModel()
|
|
|
{
|
|
|
TableName = "op_bill";
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
[JsonObject]
|
|
|
public class OpSaleTravelFee : ModelObjectBillHead
|
|
|
{
|
|
|
#region 私有成员
|
|
|
private string _GID = Guid.NewGuid().ToString();//业务编号
|
|
|
private string _ACCDATE;//
|
|
|
private string _SALE;//
|
|
|
private decimal _TRAVELFEEAMOUNT;//
|
|
|
private string _INPUTDATE;//
|
|
|
private string _INPUTBY;
|
|
|
private string _INPUTBYREF;
|
|
|
|
|
|
#endregion
|
|
|
|
|
|
public OpSaleTravelFee()
|
|
|
{
|
|
|
TableName = "op_sale_travelfee";
|
|
|
}
|
|
|
|
|
|
#region 读写属性
|
|
|
/// <summary>
|
|
|
/// 主键唯一值
|
|
|
/// </summary>
|
|
|
[ModelDB(MDBType = ModelDBOprationType.All, IsPrimary = true)]
|
|
|
public string GID
|
|
|
{
|
|
|
get { return _GID; }
|
|
|
set { _GID = value; }
|
|
|
}
|
|
|
[ModelDB]
|
|
|
public string ACCDATE
|
|
|
{
|
|
|
get { return _ACCDATE; }
|
|
|
set { _ACCDATE = value; }
|
|
|
}
|
|
|
|
|
|
[ModelDB]
|
|
|
public string SALE
|
|
|
{
|
|
|
get { return _SALE; }
|
|
|
set { _SALE = value; }
|
|
|
}
|
|
|
|
|
|
[ModelDB]
|
|
|
public decimal TRAVELFEEAMOUNT
|
|
|
{
|
|
|
get { return _TRAVELFEEAMOUNT; }
|
|
|
set { _TRAVELFEEAMOUNT = value; }
|
|
|
}
|
|
|
public string INPUTBYREF
|
|
|
{
|
|
|
get { return _INPUTBYREF; }
|
|
|
set { _INPUTBYREF = value; }
|
|
|
}
|
|
|
|
|
|
|
|
|
[ModelDB]
|
|
|
public string INPUTDATE
|
|
|
{
|
|
|
get { return _INPUTDATE; }
|
|
|
set { _INPUTDATE = value; }
|
|
|
}
|
|
|
|
|
|
|
|
|
[ModelDB]
|
|
|
public string INPUTBY
|
|
|
{
|
|
|
get { return _INPUTBY; }
|
|
|
set { _INPUTBY = value; }
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
#endregion
|
|
|
}
|
|
|
|
|
|
|
|
|
#region 参照部分
|
|
|
|
|
|
|
|
|
|
|
|
#endregion
|
|
|
}
|