using System;
using System.Linq;
using System.Text;
using SqlSugar;

namespace SA.Entity.zxdcrm_Models
{
    ///<summary>
    ///上证综研订单表
    ///</summary>
    [SugarTable("new_order_user")]
    public partial class NewOrderUser
    {
           public NewOrderUser(){


           }
           /// <summary>
           /// Desc:订单号
           /// Default:
           /// Nullable:False
           /// </summary>           
           [SugarColumn(IsPrimaryKey=true,ColumnName="orderid")]
           public int Orderid {get;set;}

           /// <summary>
           /// Desc:分公司号
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="employeeid")]
           public string? Employeeid {get;set;}

           /// <summary>
           /// Desc:分公司密码
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="password")]
           public string? Password {get;set;}

           /// <summary>
           /// Desc:分公司用户ID
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="userid")]
           public string? Userid {get;set;}

           /// <summary>
           /// Desc:产品ID
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="productid")]
           public int? Productid {get;set;}

           /// <summary>
           /// Desc:产品名称
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="productname")]
           public string? Productname {get;set;}

           /// <summary>
           /// Desc:子产品ID
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="subproductid")]
           public int? Subproductid {get;set;}

           /// <summary>
           /// Desc:子产品名称
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="subproductname")]
           public string? Subproductname {get;set;}

           /// <summary>
           /// Desc:订单类型（默认为1）	1：普通订单	2：续费订单	3：升级订单
           /// Default:1
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="ordertype")]
           public int? Ordertype {get;set;}

           /// <summary>
           /// Desc:订单升级源订单号列表（以逗号分隔，当OrderType=3时有效）
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="upgradeorderids")]
           public string? Upgradeorderids {get;set;}

           /// <summary>
           /// Desc:升级补差总额（当OrderType=3时有效）
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="totalupgradevalue")]
           public int? Totalupgradevalue {get;set;}

           /// <summary>
           /// Desc:应付金额（默认为子产品原价）	当OrderType=3时，NeedPay + TotalUpgradeValue应接近于产品原价
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="needpay")]
           public decimal? Needpay {get;set;}

           /// <summary>
           /// Desc:是否同时开通订单（默认为0，需要开通订单权限）	0：否	1：是
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="openorder")]
           public int? Openorder {get;set;}

           /// <summary>
           /// Desc:订单号（上海CRM系统生成）
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="szzyorderid")]
           public long? Szzyorderid {get;set;}

           /// <summary>
           /// Desc:订单状态：新订单180、已开通220、已退款90、已过期80、已取消70，（已支付200、已升级210、已关闭60）
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="orderstatus")]
           public string? Orderstatus {get;set;}

           /// <summary>
           /// Desc:接口返回下单时间
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="ctime")]
           public DateTime? Ctime {get;set;}

           /// <summary>
           /// Desc:下单时产品金额
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="returnneedpay")]
           public int? Returnneedpay {get;set;}

           /// <summary>
           /// Desc:合同编号
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="contractcode")]
           public string? Contractcode {get;set;}

           /// <summary>
           /// Desc:是否打折（>0 就时有打折）
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="ret")]
           public int? Ret {get;set;}

           /// <summary>
           /// Desc:错误信息（当ret>0时有效）
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="msg")]
           public string? Msg {get;set;}

           /// <summary>
           /// Desc:接口返回详情
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="returndetail")]
           public string? Returndetail {get;set;}

           /// <summary>
           /// Desc:操作人
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="inneruserid")]
           public int? Inneruserid {get;set;}

           /// <summary>
           /// Desc:订单开通时间
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="otime")]
           public DateTime? Otime {get;set;}

           /// <summary>
           /// Desc:资源ID
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="resid")]
           public string? Resid {get;set;}

           /// <summary>
           /// Desc:请求订单接口状态，1：成功，0：失败
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="requeststatus")]
           public int? Requeststatus {get;set;}

           /// <summary>
           /// Desc:是否月结
           /// Default:0
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="isfinancepay")]
           public int? Isfinancepay {get;set;}

           /// <summary>
           /// Desc:月结日期
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="finacepaydate")]
           public DateTime? Finacepaydate {get;set;}

           /// <summary>
           /// Desc:订单修改备注
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="remark")]
           public string? Remark {get;set;}

           /// <summary>
           /// Desc:实际支付金额
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="finalpay")]
           public decimal? Finalpay {get;set;}

           /// <summary>
           /// Desc:订单状态名称
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="orderstatusname")]
           public string? Orderstatusname {get;set;}

           /// <summary>
           /// Desc:客服操作时间
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="operatetime")]
           public DateTime? Operatetime {get;set;}

           /// <summary>
           /// Desc:订单暂停结束时间
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="stime")]
           public string? Stime {get;set;}

           /// <summary>
           /// Desc:订单暂停结束时间
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="etime")]
           public string? Etime {get;set;}

           /// <summary>
           /// Desc:订单暂停权限备注说明
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="suspendcomment")]
           public string? Suspendcomment {get;set;}

           /// <summary>
           /// Desc:更新订单时间
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="updateordertime")]
           public DateTime? Updateordertime {get;set;}

           /// <summary>
           /// Desc:是否开通
           /// Default:0
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="isopen")]
           public int? Isopen {get;set;}

           /// <summary>
           /// Desc:到期时间
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="endtime")]
           public DateTime? Endtime {get;set;}

           /// <summary>
           /// Desc:售后服务归属（默认按上海CRM中配置的对应分公司的默认售后服务归属）	0：总公司负责售后服务	1：分公司负责售后服务
           /// Default:0
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="teamserve")]
           public int? Teamserve {get;set;}

           /// <summary>
           /// Desc:分成比例文本
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="fctext")]
           public string? Fctext {get;set;}

           /// <summary>
           /// Desc:客户微信用户名
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="customerusername")]
           public string? Customerusername {get;set;}

           /// <summary>
           /// Desc:到账金额
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="arrivalpay")]
           public decimal? Arrivalpay {get;set;}

           /// <summary>
           /// Desc:到账时间
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="arrivaltime")]
           public DateTime? Arrivaltime {get;set;}

           /// <summary>
           /// Desc:客户来源。1：推广资源，2：线下资源，3：自找资源
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="source")]
           public string? Source {get;set;}

           /// <summary>
           /// Desc:姓名
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="cname")]
           public string? Cname {get;set;}

           /// <summary>
           /// Desc:开通天数
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="opendays")]
           public int? Opendays {get;set;}

           /// <summary>
           /// Desc:订单用户归类
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="customerclassify")]
           public string? Customerclassify {get;set;}

           /// <summary>
           /// Desc:订单部门
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="saledeptid")]
           public int? Saledeptid {get;set;}

           /// <summary>
           /// Desc:软件用户名
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="softusername")]
           public string? Softusername {get;set;}

           /// <summary>
           /// Desc:渠道 
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="channel")]
           public int? Channel {get;set;}

           /// <summary>
           /// Desc:套数
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="booknum")]
           public int? Booknum {get;set;}

           /// <summary>
           /// Desc:开通用户
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="openuser")]
           public string? Openuser {get;set;}

           /// <summary>
           /// Desc:子类代码
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="productcode")]
           public string? Productcode {get;set;}

           /// <summary>
           /// Desc:大类代码
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="bigproductcode")]
           public string? Bigproductcode {get;set;}

           /// <summary>
           /// Desc:是否支付，0：未支付，1：已经支付
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="ispayed")]
           public int? Ispayed {get;set;}

           /// <summary>
           /// Desc:支付类型。1：支付宝，2：财富通，3：银行转账，4：网银支付，5：微信支付，6：支付宝银联
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="paytype")]
           public int? Paytype {get;set;}

           /// <summary>
           /// Desc:用户名
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="username")]
           public string? Username {get;set;}

           /// <summary>
           /// Desc:客户端IP地址
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="sIP")]
           public string? SIP {get;set;}

           /// <summary>
           /// Desc:风控状态：1 通过，0 未通过
           /// Default:0
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="riskctrlstatus")]
           public int? Riskctrlstatus {get;set;}

           /// <summary>
           /// Desc:
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="appusername")]
           public string? Appusername {get;set;}

           /// <summary>
           /// Desc:营业部编码
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="companycode")]
           public string? Companycode {get;set;}

           /// <summary>
           /// Desc:合同状态：0 新建 1：已签合同
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="contractstatus")]
           public int? Contractstatus {get;set;}

           /// <summary>
           /// Desc:合同签订时间
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="contractctime")]
           public DateTime? Contractctime {get;set;}

           /// <summary>
           /// Desc:
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="qywxstatus")]
           public int? Qywxstatus {get;set;}

           /// <summary>
           /// Desc:
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="qywxopendate")]
           public DateTime? Qywxopendate {get;set;}

           /// <summary>
           /// Desc:活动产品code
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="activeproductcode")]
           public string? Activeproductcode {get;set;}

           /// <summary>
           /// Desc:活动产品信息
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="activeproductext")]
           public string? Activeproductext {get;set;}

           /// <summary>
           /// Desc:
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="istest")]
           public int? Istest {get;set;}

           /// <summary>
           /// Desc:
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="hashgrecord")]
           public int? Hashgrecord {get;set;}

           /// <summary>
           /// Desc:身份证
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="idcard")]
           public string? Idcard {get;set;}

           /// <summary>
           /// Desc:***第三方平台订单号***
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="outorderno")]
           public string? Outorderno {get;set;}

           /// <summary>
           /// Desc:订单时间戳字段
           /// Default:CURRENT_TIMESTAMP
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="utime")]
           public DateTime? Utime {get;set;}

           /// <summary>
           /// Desc:赠送天数
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="giftdays")]
           public int? Giftdays {get;set;}

           /// <summary>
           /// Desc:合规驳回说明
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="rejectremark")]
           public string? Rejectremark {get;set;}

           /// <summary>
           /// Desc:赠送第二产品天数
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="giftdays2")]
           public int? Giftdays2 {get;set;}

           /// <summary>
           /// Desc:企业微信外部联系人的userid
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="external_userid")]
           public string? External_userid {get;set;}

           /// <summary>
           /// Desc:企业微信好友ID
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="wework_remoteid")]
           public string? Wework_remoteid {get;set;}

           /// <summary>
           /// Desc:结算方式
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="settletype")]
           public int? Settletype {get;set;}

           /// <summary>
           /// Desc:附件名称
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="fujian")]
           public string? Fujian {get;set;}

           /// <summary>
           /// Desc:微信小店单号
           /// Default:
           /// Nullable:True
           /// </summary>           
           [SugarColumn(ColumnName="wXShopOrderNo")]
           public string? WXShopOrderNo {get;set;}

    }
}