SACenter/SA.Entity/zxdcrm_Models/WxSzzyorder.cs

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

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

        /// <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：成功，>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:0.00
        /// Nullable:True
        /// </summary>
        [SugarColumn(ColumnName = "balancepay")]
        public decimal? Balancepay { get; set; }

        /// <summary>
        /// Desc:订单原价
        /// Default:0.00
        /// Nullable:True
        /// </summary>
        [SugarColumn(ColumnName = "originpay")]
        public decimal? Originpay { 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:1：人工录音回访 2、视频 3：智能回访
        /// 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; }

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

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

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

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

        /// <summary>
        /// 回访开始时间
        /// </summary>
        [SugarColumn(ColumnName = "ai_hgrecord_stime")]
        public string? AiHgrecordStime { get; set; }

        /// <summary>
        /// 回访结束时间
        /// </summary>
        [SugarColumn(ColumnName = "ai_hgrecord_etime")]
        public string? AiHgrecordEtime { get; set; }

        /// <summary>
        /// 智能外呼状态
        /// -1、忽略不做智能外呼
        /// 0、尚未进行智能外呼
        /// 1、等待AI外呼
        /// 2、已提交AI外呼
        /// 3、AI外呼失败（未答完）
        /// 4、AI外呼未接通
        /// 5、AI外呼成功
        /// 6、等待AI重拨
        /// 7、AI外呼失败（挂断）
        /// </summary>
        [SugarColumn(ColumnName = "ai_hgrecord_status")]
        public int? AiHgrecordStatus { get; set; }

        /// <summary>
        /// 智能外呼状态名称
        /// </summary>
        [SugarColumn(ColumnName = "ai_hgrecord_statusname")]
        public string? AiHgrecordStatusname
        { get { return AiHgrecordStatusnameKV[AiHgrecordStatus.Value]; } }

        /// <summary>
        /// 是否有外呼录音
        /// </summary>
        [SugarColumn(ColumnName = "Hasaiaudio")]
        public int? Hasaiaudio { get; set; }

        private static Dictionary<int, string> GetAiHgrecordStatusnameKV()
        {
            Dictionary<int, string> Ai_hgrecord_statusnameKV = new()
            {
                {-2, "AI重拨失败" },
                { -1, "忽略不做AI外呼" },
                { 0, "尚未进行AI外呼" },
                { 1, "等待AI外呼" },
                { 2, "已提交AI外呼" },
                { 3, "AI外呼失败（未答完）" },
                { 4, "AI外呼未接通" },
                { 5, "AI外呼成功" },
                { 6, "等待AI重拨" },
                { 7, "AI外呼失败（挂断）" },
                { 8, "AI外呼取消" },
                { 9, "人工回访成功" }
        };
            return Ai_hgrecord_statusnameKV;
        }

        private static Dictionary<int, string> AiHgrecordStatusnameKV = GetAiHgrecordStatusnameKV();
    }
}