kxs-sp-net7/Model/Database/KxsTradeRecord.cs

using Mapster;


namespace Model
{
    /// <summary>
    /// 交易记录 kxs_trade_record
    /// </summary>
    [SplitTable(SplitType.Month)]
    [SugarTable("kxs_trade_record_{year}{month}{day}", "交易记录")]
    [Tenant("0")]
    public class KxsTradeRecord
    {
        /// <summary>
        /// 交易单号
        /// </summary>
        [SugarColumn(ColumnDescription = "交易单号", Length = 100, ColumnName = "trade_serial_no")]
        public string? tradeSerialNo { get; set; }


        /// <summary>
        /// 备用字段3
        /// </summary>
        [SugarColumn(ColumnDescription = "备用字段3", Length = 50, ColumnName = "field3")]
        public string? field3 { get; set; }


        /// <summary>
        /// 备用字段2
        /// </summary>
        [SugarColumn(ColumnDescription = "备用字段2", Length = 50, ColumnName = "field2")]
        public string? field2 { get; set; }


        /// <summary>
        /// 备用字段1
        /// </summary>
        [SugarColumn(ColumnDescription = "备用字段1", Length = 50, ColumnName = "field1")]
        public string? field1 { get; set; }


        /// <summary>
        /// 渠道流水号
        /// </summary>
        [SugarColumn(ColumnDescription = "渠道流水号", Length = 50, ColumnName = "channel_serial")]
        public string? channelSerial { get; set; }


        /// <summary>
        /// 代理商编号
        /// </summary>
        [SugarColumn(ColumnDescription = "代理商编号", Length = 32, ColumnName = "agent_no")]
        public string? agentNo { get; set; }


        /// <summary>
        /// 产品类型
        /// </summary>
        [SugarColumn(ColumnDescription = "产品类型", Length = 32, ColumnName = "product_type")]
        public string? productType { get; set; }


        /// <summary>
        /// 备注
        /// </summary>
        [SugarColumn(ColumnDescription = "备注", Length = 64, ColumnName = "remark")]
        public string? remark { get; set; }


        /// <summary>
        /// 出款方式
        /// </summary>
        [SugarColumn(ColumnDescription = "出款方式", Length = 16, ColumnName = "settle_method")]
        public string? settleMethod { get; set; }


        /// <summary>
        /// 出款手续费
        /// </summary>
        [SugarColumn(ColumnDescription = "出款手续费", ColumnName = "settle_fee")]
        public decimal settleFee { get; set; }


        /// <summary>
        /// 交易卡号
        /// </summary>
        [SugarColumn(ColumnDescription = "交易卡号", Length = 32, ColumnName = "bank_card_no")]
        public string? bankCardNo { get; set; }


        /// <summary>
        /// 设备类型
        /// </summary>
        [SugarColumn(ColumnDescription = "设备类型", Length = 16, ColumnName = "receipt_type")]
        public string? receiptType { get; set; }


        /// <summary>
        /// 店面收银交易标识
        /// </summary>
        [SugarColumn(ColumnDescription = "店面收银交易标识", Length = 16, ColumnName = "is_store_cashier")]
        public string? isStoreCashier { get; set; }


        /// <summary>
        /// 挖款金额
        /// </summary>
        [SugarColumn(ColumnDescription = "挖款金额", ColumnName = "dig_amt")]
        public decimal digAmt { get; set; }


        /// <summary>
        /// 挖款标识
        /// </summary>
        [SugarColumn(ColumnDescription = "挖款标识", Length = 4, ColumnName = "dig_amt_flag")]
        public string? digAmtFlag { get; set; }


        /// <summary>
        /// 商户手机号
        /// </summary>
        [SugarColumn(ColumnDescription = "商户手机号", Length = 11, ColumnName = "mer_mobile")]
        public string? merMobile { get; set; }


        /// <summary>
        /// 设备类型
        /// </summary>
        [SugarColumn(ColumnDescription = "设备类型", Length = 16, ColumnName = "device_type")]
        public string? deviceType { get; set; }


        /// <summary>
        /// 交易SN号
        /// </summary>
        [SugarColumn(ColumnDescription = "交易SN号", Length = 50, ColumnName = "trade_sn_no")]
        public string? tradeSnNo { get; set; }


        /// <summary>
        /// 商户编号
        /// </summary>
        [SugarColumn(ColumnDescription = "商户编号", Length = 50, ColumnName = "mer_no")]
        public string? merNo { get; set; }


        /// <summary>
        /// 商户名称
        /// </summary>
        [SugarColumn(ColumnDescription = "商户名称", Length = 50, ColumnName = "mer_name")]
        public string? merName { get; set; }


        /// <summary>
        /// 交易金额
        /// </summary>
        [SugarColumn(ColumnDescription = "交易金额", ColumnName = "trade_amount")]
        public decimal tradeAmount { get; set; }


        /// <summary>
        /// 交易参考号
        /// </summary>
        [SugarColumn(ColumnDescription = "交易参考号", Length = 32, ColumnName = "trade_refer_no")]
        public string? tradeReferNo { get; set; }


        /// <summary>
        /// 银行授权码
        /// </summary>
        [SugarColumn(ColumnDescription = "银行授权码", Length = 32, ColumnName = "bank_auth_code")]
        public string? bankAuthCode { get; set; }


        /// <summary>
        /// 优惠费率标识
        /// </summary>
        [SugarColumn(ColumnDescription = "优惠费率标识", Length = 16, ColumnName = "discount_rate_flag")]
        public string? discountRateFlag { get; set; }


        /// <summary>
        /// 备用字段4
        /// </summary>
        [SugarColumn(ColumnDescription = "备用字段4", Length = 50, ColumnName = "field4")]
        public string? field4 { get; set; }


        /// <summary>
        /// 交易状态
        /// </summary>
        [SugarColumn(ColumnDescription = "交易状态", Length = 16, ColumnName = "trade_status")]
        public string? tradeStatus { get; set; }


        /// <summary>
        /// 错误信息
        /// </summary>
        [SugarColumn(ColumnDescription = "错误信息", Length = 32, ColumnName = "error_msg")]
        public string? errorMsg { get; set; }


        /// <summary>
        /// 交易日期
        /// </summary>
        [SugarColumn(ColumnDescription = "交易日期", Length = 8, ColumnName = "trade_date")]
        public string? tradeDate { get; set; }


        /// <summary>
        /// 交易时间
        /// </summary>
        [SugarColumn(ColumnDescription = "交易时间", Length = 8, ColumnName = "trade_time")]
        public string? tradeTime { get; set; }


        /// <summary>
        /// 交易类型
        /// </summary>
        [SugarColumn(ColumnDescription = "交易类型", Length = 32, ColumnName = "trade_type")]
        public string? tradeType { get; set; }


        /// <summary>
        /// 输入模式
        /// </summary>
        [SugarColumn(ColumnDescription = "输入模式", Length = 32, ColumnName = "ser_entry_mode")]
        public string? serEntryMode { get; set; }


        /// <summary>
        /// 银行卡类型
        /// </summary>
        [SugarColumn(ColumnDescription = "银行卡类型", Length = 16, ColumnName = "bank_card_type")]
        public string? bankCardType { get; set; }


        /// <summary>
        /// 错误码
        /// </summary>
        [SugarColumn(ColumnDescription = "错误码", Length = 16, ColumnName = "error_code")]
        public string? errorCode { get; set; }


        /// <summary>
        /// 备用字段5
        /// </summary>
        [SugarColumn(ColumnDescription = "备用字段5", Length = 50, ColumnName = "field5")]
        public string? field5 { get; set; }


        /// <summary>
        /// 更新时间
        /// </summary>
        [SugarColumn(ColumnDescription = "更新时间", ColumnName = "update_time")]
        public DateTime? updateTime { get; set; }


        /// <summary>
        /// 创建时间
        /// </summary>
        [SplitField]
        [SugarColumn(ColumnDescription = "创建时间", ColumnName = "create_time")]
        public DateTime? createTime { get; set; }


        /// <summary>
        /// 删除标记
        /// </summary>
        [SugarColumn(ColumnDescription = "删除标记", ColumnName = "del_flag")]
        public int delFlag { get; set; }


        /// <summary>
        /// 版本号
        /// </summary>
        [SugarColumn(ColumnDescription = "版本号", ColumnName = "version")]
        public int version { get; set; }


        /// <summary>
        /// ID
        /// </summary>
        [SugarColumn(ColumnDescription = "ID", IsPrimaryKey = true, ColumnName = "id")]
        public long id { get; set; }



    }
}