格式化代码

啊鑫

18 小时以前 ed05efdc17aab076146b134ebe105b6382f221d7

 MES.Service/Modes/SalesDeliveryNotice.cs

@@ -1,236 +1,274 @@
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_DELIVERY_NOTICE")]
public class SalesDeliveryNotice
{
    /// <summary>
    /// 销售发货通知单
    ///</summary>
    [SugarTable("SALES_DELIVERY_NOTICE")]
    public class SalesDeliveryNotice
    {
        /// <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="CUSTOMER"    )]
         public string? Customer { get; set; }
        /// <summary>
        /// 淘宝客户备注 
        ///</summary>
         [SugarColumn(ColumnName="TAOBAO_REMARK"    )]
         public string? TaobaoRemark { get; set; }
        /// <summary>
        /// 交货方式 
        ///</summary>
         [SugarColumn(ColumnName="DELIVERY_METHOD"    )]
         public string? DeliveryMethod { get; set; }
        /// <summary>
        /// 交货地点 
        ///</summary>
         [SugarColumn(ColumnName="DELIVERY_LOCATION"    )]
         public string? DeliveryLocation { get; set; }
        /// <summary>
        /// 承运商 
        ///</summary>
         [SugarColumn(ColumnName="CARRIER"    )]
         public string? Carrier { get; set; }
        /// <summary>
        /// 运输单号 
        ///</summary>
         [SugarColumn(ColumnName="TRANSPORT_NO"    )]
         public string? TransportNo { get; set; }
        /// <summary>
        /// 单据状态 
        ///</summary>
         [SugarColumn(ColumnName="BILL_NO_TYPE"    )]
         public string? BillNoType { get; set; }
        /// <summary>
        /// 发货组织 
        ///</summary>
         [SugarColumn(ColumnName="DELIVERY_ORG"    )]
         public string? DeliveryOrg { get; set; }
        /// <summary>
        /// 发货部门 
        ///</summary>
         [SugarColumn(ColumnName="DELIVERY_DEPT"    )]
         public string? DeliveryDept { 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="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="LINK_PHONE"    )]
         public string? LinkPhone { get; set; }
        /// <summary>
        /// 结算方 
        ///</summary>
         [SugarColumn(ColumnName="SETTLE_PARTY"    )]
         public string? SettleParty { get; set; }
        /// <summary>
        /// 付款方 
        ///</summary>
         [SugarColumn(ColumnName="PAYER_PARTY"    )]
         public string? PayerParty { 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 = "ID", OracleSequenceName = "SEQ_SALES",
        IsPrimaryKey = true)]
    public decimal? Id { get; set; }

        /// <summary>
        /// 单据状态 
        ///</summary>
        [SugarColumn(ColumnName = "BILL_STATUS")]
        public string? BillStatus { 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 = "CUSTOMER")]
    public string? Customer { get; set; }

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

 /// <summary>
 ///     交货方式
 /// </summary>
 [SugarColumn(ColumnName = "DELIVERY_METHOD")]
    public string? DeliveryMethod { get; set; }

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

 /// <summary>
 ///     承运商
 /// </summary>
 [SugarColumn(ColumnName = "CARRIER")]
    public string? Carrier { get; set; }

 /// <summary>
 ///     运输单号
 /// </summary>
 [SugarColumn(ColumnName = "TRANSPORT_NO")]
    public string? TransportNo { get; set; }

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

 /// <summary>
 ///     发货组织
 /// </summary>
 [SugarColumn(ColumnName = "DELIVERY_ORG")]
    public string? DeliveryOrg { get; set; }

 /// <summary>
 ///     发货部门
 /// </summary>
 [SugarColumn(ColumnName = "DELIVERY_DEPT")]
    public string? DeliveryDept { 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 = "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 = "LINK_PHONE")]
    public string? LinkPhone { get; set; }

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

 /// <summary>
 ///     付款方
 /// </summary>
 [SugarColumn(ColumnName = "PAYER_PARTY")]
    public string? PayerParty { 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; }
}