格式化代码

啊鑫

18 小时以前 ed05efdc17aab076146b134ebe105b6382f221d7

 MES.Service/Modes/SalesReturnNotice.cs

@@ -1,214 +1,250 @@
using System;
using System.Collections.Generic;
using System.Linq;
using SqlSugar;
namespace MES.Service.Modes
using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     销售退货通知单表
/// </summary>
[SugarTable("SALES_RETURN_NOTICE")]
public class SalesReturnNotice
{
    /// <summary>
    /// 销售退货通知单表
    ///</summary>
    [SugarTable("SALES_RETURN_NOTICE")]
    public class SalesReturnNotice
    {
        /// <summary>
        ///  
        ///</summary>
        [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_sales", IsPrimaryKey = true)]
        public decimal? Id { get; set; }
        /// <summary>
        /// 单据类型 
        ///</summary>
        [SugarColumn(ColumnName = "BILL_TYPE")]
        public string BillType { get; set; }
        /// <summary>
        /// 单据编号 
        ///</summary>
        [SugarColumn(ColumnName = "BILL_NO")]
        public string BillNo { get; set; }
        /// <summary>
        /// 日期 
        ///</summary>
        [SugarColumn(ColumnName = "F_DATE")]
        public DateTime? FDate { get; set; }
        /// <summary>
        /// 结算币别 
        ///</summary>
        [SugarColumn(ColumnName = "CURRENCY")]
        public string Currency { get; set; }
        /// <summary>
        /// 销售组织 
        ///</summary>
        [SugarColumn(ColumnName = "SALES_ORG")]
        public string SalesOrg { get; set; }
        /// <summary>
        /// 销售部门 
        ///</summary>
        [SugarColumn(ColumnName = "SALES_DEPT")]
        public string SalesDept { get; set; }
        /// <summary>
        /// 客户订单 
        ///</summary>
        [SugarColumn(ColumnName = "CUSTOMER_ORDER_NO")]
        public string CustomerOrderNo { get; set; }
        /// <summary>
        /// 退货客户 
        ///</summary>
        [SugarColumn(ColumnName = "RETURN_CUSTOMER")]
        public string ReturnCustomer { get; set; }
        /// <summary>
        /// 淘宝客户备注 
        ///</summary>
        [SugarColumn(ColumnName = "TAOBAO_REMARK")]
        public string TaobaoRemark { get; set; }
        /// <summary>
        /// 退货原因 
        ///</summary>
        [SugarColumn(ColumnName = "RETURN_REASON")]
        public string ReturnReason { get; set; }
        /// <summary>
        /// 交货地点 
        ///</summary>
        [SugarColumn(ColumnName = "DELIVERY_LOCATION")]
        public string DeliveryLocation { get; set; }
        /// <summary>
        /// 库存组织 
        ///</summary>
        [SugarColumn(ColumnName = "INVENTORY_ORG")]
        public string InventoryOrg { get; set; }
        /// <summary>
        /// 库存部门 
        ///</summary>
        [SugarColumn(ColumnName = "INVENTORY_DEPT")]
        public string InventoryDept { get; set; }
        /// <summary>
        /// 库存组 
        ///</summary>
        [SugarColumn(ColumnName = "INVENTORY_GROUP")]
        public string InventoryGroup { get; set; }
        /// <summary>
        /// 仓管员 
        ///</summary>
        [SugarColumn(ColumnName = "WAREHOUSE_MANAGER")]
        public string WarehouseManager { get; set; }
        /// <summary>
        /// 销售组 
        ///</summary>
        [SugarColumn(ColumnName = "SALES_GROUP")]
        public string SalesGroup { get; set; }
        /// <summary>
        /// 销售员 
        ///</summary>
        [SugarColumn(ColumnName = "SALES_PERSON")]
        public string SalesPerson { get; set; }
        /// <summary>
        /// 快递单号 
        ///</summary>
        [SugarColumn(ColumnName = "EXPRESS_NO")]
        public string ExpressNo { get; set; }
        /// <summary>
        /// 收货方 
        ///</summary>
        [SugarColumn(ColumnName = "RECEIVER")]
        public string Receiver { get; set; }
        /// <summary>
        /// 收货方联系人 
        ///</summary>
        [SugarColumn(ColumnName = "RECEIVER_CONTACT")]
        public string ReceiverContact { get; set; }
        /// <summary>
        /// 收货方地址 
        ///</summary>
        [SugarColumn(ColumnName = "RECEIVER_ADDRESS")]
        public string ReceiverAddress { get; set; }
        /// <summary>
        /// 收货方姓名 
        ///</summary>
        [SugarColumn(ColumnName = "RECEIVER_NAME")]
        public string ReceiverName { get; set; }
        /// <summary>
        /// 结算方 
        ///</summary>
        [SugarColumn(ColumnName = "SETTLE_PARTY")]
        public string SettleParty { get; set; }
        /// <summary>
        /// 创建人 
        ///</summary>
        [SugarColumn(ColumnName = "CREATED_BY")]
        public string CreatedBy { get; set; }
        /// <summary>
        /// 创建时间 
        ///</summary>
        [SugarColumn(ColumnName = "CREATED_DATE")]
        public DateTime? CreatedDate { get; set; }
        /// <summary>
        /// 修改人 
        ///</summary>
        [SugarColumn(ColumnName = "MODIFIED_BY")]
        public string ModifiedBy { get; set; }
        /// <summary>
        /// 修改时间 
        ///</summary>
        [SugarColumn(ColumnName = "MODIFIED_DATE")]
        public DateTime? ModifiedDate { get; set; }
        /// <summary>
        /// 关闭人 
        ///</summary>
        [SugarColumn(ColumnName = "CLOSED_BY")]
        public string ClosedBy { get; set; }
        /// <summary>
        /// 关闭原因 
        ///</summary>
        [SugarColumn(ColumnName = "CLOSE_REASON")]
        public string CloseReason { get; set; }
        /// <summary>
        /// 关闭日期 
        ///</summary>
        [SugarColumn(ColumnName = "CLOSE_DATE")]
        public DateTime? CloseDate { get; set; }
        /// <summary>
        /// 审核人 
        ///</summary>
        [SugarColumn(ColumnName = "APPROVED_BY")]
        public string ApprovedBy { get; set; }
        /// <summary>
        /// 审核日期 
        ///</summary>
        [SugarColumn(ColumnName = "APPROVED_DATE")]
        public DateTime? ApprovedDate { get; set; }
        /// <summary>
        /// 作废状态 
        ///</summary>
        [SugarColumn(ColumnName = "CANCEL_STATUS")]
        public string CancelStatus { get; set; }
        /// <summary>
        /// 作废人 
        ///</summary>
        [SugarColumn(ColumnName = "CANCELLED_BY")]
        public string CancelledBy { get; set; }
        /// <summary>
        /// 作废日期 
        ///</summary>
        [SugarColumn(ColumnName = "CANCEL_DATE")]
        public DateTime? CancelDate { get; set; }
        /// <summary>
        /// 关闭状态 
        ///</summary>
        [SugarColumn(ColumnName = "CLOSE_STATUS")]
        public string CloseStatus { get; set; }
        /// <summary>
        /// 是否手动关闭 
        ///</summary>
        [SugarColumn(ColumnName = "MANUAL_CLOSE_FLAG")]
        public string ManualCloseFlag { get; set; }
        /// <summary>
        /// ERP头ID 
        ///</summary>
        [SugarColumn(ColumnName = "ERP_ID")]
        public string ErpId { get; set; }
        /// <summary>
        /// 单据状态 
        ///</summary>
        [SugarColumn(ColumnName = "BILL_STATUS")]
        public string BillStatus { get; set; }
    }
}
    /// </summary>
    [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_sales",
        IsPrimaryKey = true)]
    public decimal? Id { get; set; }

    /// <summary>
    ///     单据类型
    /// </summary>
    [SugarColumn(ColumnName = "BILL_TYPE")]
    public string BillType { get; set; }

    /// <summary>
    ///     单据编号
    /// </summary>
    [SugarColumn(ColumnName = "BILL_NO")]
    public string BillNo { get; set; }

    /// <summary>
    ///     日期
    /// </summary>
    [SugarColumn(ColumnName = "F_DATE")]
    public DateTime? FDate { get; set; }

    /// <summary>
    ///     结算币别
    /// </summary>
    [SugarColumn(ColumnName = "CURRENCY")]
    public string Currency { get; set; }

    /// <summary>
    ///     销售组织
    /// </summary>
    [SugarColumn(ColumnName = "SALES_ORG")]
    public string SalesOrg { get; set; }

    /// <summary>
    ///     销售部门
    /// </summary>
    [SugarColumn(ColumnName = "SALES_DEPT")]
    public string SalesDept { get; set; }

    /// <summary>
    ///     客户订单
    /// </summary>
    [SugarColumn(ColumnName = "CUSTOMER_ORDER_NO")]
    public string CustomerOrderNo { get; set; }

    /// <summary>
    ///     退货客户
    /// </summary>
    [SugarColumn(ColumnName = "RETURN_CUSTOMER")]
    public string ReturnCustomer { get; set; }

    /// <summary>
    ///     淘宝客户备注
    /// </summary>
    [SugarColumn(ColumnName = "TAOBAO_REMARK")]
    public string TaobaoRemark { get; set; }

    /// <summary>
    ///     退货原因
    /// </summary>
    [SugarColumn(ColumnName = "RETURN_REASON")]
    public string ReturnReason { get; set; }

    /// <summary>
    ///     交货地点
    /// </summary>
    [SugarColumn(ColumnName = "DELIVERY_LOCATION")]
    public string DeliveryLocation { get; set; }

    /// <summary>
    ///     库存组织
    /// </summary>
    [SugarColumn(ColumnName = "INVENTORY_ORG")]
    public string InventoryOrg { get; set; }

    /// <summary>
    ///     库存部门
    /// </summary>
    [SugarColumn(ColumnName = "INVENTORY_DEPT")]
    public string InventoryDept { get; set; }

    /// <summary>
    ///     库存组
    /// </summary>
    [SugarColumn(ColumnName = "INVENTORY_GROUP")]
    public string InventoryGroup { get; set; }

    /// <summary>
    ///     仓管员
    /// </summary>
    [SugarColumn(ColumnName = "WAREHOUSE_MANAGER")]
    public string WarehouseManager { get; set; }

    /// <summary>
    ///     销售组
    /// </summary>
    [SugarColumn(ColumnName = "SALES_GROUP")]
    public string SalesGroup { get; set; }

    /// <summary>
    ///     销售员
    /// </summary>
    [SugarColumn(ColumnName = "SALES_PERSON")]
    public string SalesPerson { get; set; }

    /// <summary>
    ///     快递单号
    /// </summary>
    [SugarColumn(ColumnName = "EXPRESS_NO")]
    public string ExpressNo { get; set; }

    /// <summary>
    ///     收货方
    /// </summary>
    [SugarColumn(ColumnName = "RECEIVER")]
    public string Receiver { get; set; }

    /// <summary>
    ///     收货方联系人
    /// </summary>
    [SugarColumn(ColumnName = "RECEIVER_CONTACT")]
    public string ReceiverContact { get; set; }

    /// <summary>
    ///     收货方地址
    /// </summary>
    [SugarColumn(ColumnName = "RECEIVER_ADDRESS")]
    public string ReceiverAddress { get; set; }

    /// <summary>
    ///     收货方姓名
    /// </summary>
    [SugarColumn(ColumnName = "RECEIVER_NAME")]
    public string ReceiverName { get; set; }

    /// <summary>
    ///     结算方
    /// </summary>
    [SugarColumn(ColumnName = "SETTLE_PARTY")]
    public string SettleParty { get; set; }

    /// <summary>
    ///     创建人
    /// </summary>
    [SugarColumn(ColumnName = "CREATED_BY")]
    public string CreatedBy { get; set; }

    /// <summary>
    ///     创建时间
    /// </summary>
    [SugarColumn(ColumnName = "CREATED_DATE")]
    public DateTime? CreatedDate { get; set; }

    /// <summary>
    ///     修改人
    /// </summary>
    [SugarColumn(ColumnName = "MODIFIED_BY")]
    public string ModifiedBy { get; set; }

    /// <summary>
    ///     修改时间
    /// </summary>
    [SugarColumn(ColumnName = "MODIFIED_DATE")]
    public DateTime? ModifiedDate { get; set; }

    /// <summary>
    ///     关闭人
    /// </summary>
    [SugarColumn(ColumnName = "CLOSED_BY")]
    public string ClosedBy { get; set; }

    /// <summary>
    ///     关闭原因
    /// </summary>
    [SugarColumn(ColumnName = "CLOSE_REASON")]
    public string CloseReason { get; set; }

    /// <summary>
    ///     关闭日期
    /// </summary>
    [SugarColumn(ColumnName = "CLOSE_DATE")]
    public DateTime? CloseDate { get; set; }

    /// <summary>
    ///     审核人
    /// </summary>
    [SugarColumn(ColumnName = "APPROVED_BY")]
    public string ApprovedBy { get; set; }

    /// <summary>
    ///     审核日期
    /// </summary>
    [SugarColumn(ColumnName = "APPROVED_DATE")]
    public DateTime? ApprovedDate { get; set; }

    /// <summary>
    ///     作废状态
    /// </summary>
    [SugarColumn(ColumnName = "CANCEL_STATUS")]
    public string CancelStatus { get; set; }

    /// <summary>
    ///     作废人
    /// </summary>
    [SugarColumn(ColumnName = "CANCELLED_BY")]
    public string CancelledBy { get; set; }

    /// <summary>
    ///     作废日期
    /// </summary>
    [SugarColumn(ColumnName = "CANCEL_DATE")]
    public DateTime? CancelDate { get; set; }

    /// <summary>
    ///     关闭状态
    /// </summary>
    [SugarColumn(ColumnName = "CLOSE_STATUS")]
    public string CloseStatus { get; set; }

    /// <summary>
    ///     是否手动关闭
    /// </summary>
    [SugarColumn(ColumnName = "MANUAL_CLOSE_FLAG")]
    public string ManualCloseFlag { get; set; }

    /// <summary>
    ///     ERP头ID
    /// </summary>
    [SugarColumn(ColumnName = "ERP_ID")]
    public string ErpId { get; set; }

    /// <summary>
    ///     单据状态
    /// </summary>
    [SugarColumn(ColumnName = "BILL_STATUS")]
    public string BillStatus { get; set; }
}