格式化代码

啊鑫

4 天以前 ed05efdc17aab076146b134ebe105b6382f221d7

 MES.Service/Modes/SalesDeliveryNoticeDetail.cs

@@ -1,210 +1,238 @@
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_DETAIL")]
public class SalesDeliveryNoticeDetail
{
    /// <summary>
    /// 销售发货通知单明细表
    ///</summary>
    [SugarTable("SALES_DELIVERY_NOTICE_DETAIL")]
    public class SalesDeliveryNoticeDetail
    {
        /// <summary>
        ///  
        ///</summary>
         [SugarColumn(ColumnName="ID", OracleSequenceName = "SEQ_SALES", IsPrimaryKey = true)]
         public decimal? Id { get; set; }
        /// <summary>
        /// 销售订单号 
        ///</summary>
         [SugarColumn(ColumnName="SALES_ORDER_ID")]
         public string? SalesOrderId { get; set; }
        /// <summary>
        /// 物料编码 
        ///</summary>
         [SugarColumn(ColumnName="MATERIAL_ID")]
         public string? MaterialId { get; set; }
        /// <summary>
        /// 物料名称 
        ///</summary>
         [SugarColumn(ColumnName="MATERIAL_NAME")]
         public string? MaterialName { get; set; }
        /// <summary>
        /// 物料规格 
        ///</summary>
         [SugarColumn(ColumnName="MATERIAL_SPECIFICATION")]
         public string? MaterialSpecification { get; set; }
        /// <summary>
        /// 销售单位 
        ///</summary>
         [SugarColumn(ColumnName="SALES_UNIT_ID")]
         public string? SalesUnitId { get; set; }
        /// <summary>
        /// 销售数量 
        ///</summary>
         [SugarColumn(ColumnName="SALES_QUANTITY")]
         public decimal? SalesQuantity { get; set; }
        /// <summary>
        /// 是否赠品 
        ///</summary>
         [SugarColumn(ColumnName="IS_FREE")]
         public decimal IsFree { get; set; }
        /// <summary>
        /// 要货日期 
        ///</summary>
         [SugarColumn(ColumnName="DELIVERY_DATE")]
         public DateTime? DeliveryDate { get; set; }
        /// <summary>
        /// 出货仓库 
        ///</summary>
         [SugarColumn(ColumnName="WAREHOUSE")]
         public string? Warehouse { get; set; }
        /// <summary>
        /// 计划跟踪号 
        ///</summary>
         [SugarColumn(ColumnName="PLAN_TRACKING_NUMBER")]
         public string? PlanTrackingNumber { get; set; }
        /// <summary>
        /// 批号 
        ///</summary>
         [SugarColumn(ColumnName="LOT_NUMBER")]
         public string? LotNumber { get; set; }
        /// <summary>
        /// 源单编号 
        ///</summary>
         [SugarColumn(ColumnName="SRC_BILL_NO")]
         public string? SrcBillNo { get; set; }
        /// <summary>
        /// 计价数量 
        ///</summary>
         [SugarColumn(ColumnName="PRICE_QTY")]
         public decimal? PriceQty { get; set; }
        /// <summary>
        /// 货主 
        ///</summary>
         [SugarColumn(ColumnName="OWNER_ID")]
         public string? OwnerId { get; set; }
        /// <summary>
        /// 库存单位 
        ///</summary>
         [SugarColumn(ColumnName="INVENTORY_UNIT")]
         public string? InventoryUnit { get; set; }
        /// <summary>
        /// 库存数量 
        ///</summary>
         [SugarColumn(ColumnName="INVENTORY_QUANTITY")]
         public decimal? InventoryQuantity { get; set; }
        /// <summary>
        /// 物料类别 
        ///</summary>
         [SugarColumn(ColumnName="MATERIAL_CATEGORY")]
         public string? MaterialCategory { get; set; }
        /// <summary>
        /// 计划发货日期 
        ///</summary>
         [SugarColumn(ColumnName="PLAN_DELIVERY_DATE")]
         public DateTime? PlanDeliveryDate { get; set; }
        /// <summary>
        /// 超发控制单位 
        ///</summary>
         [SugarColumn(ColumnName="OUT_LMT_UNIT")]
         public string? OutLmtUnit { get; set; }
        /// <summary>
        /// 出库上限 
        ///</summary>
         [SugarColumn(ColumnName="OUT_MAX_QTY")]
         public decimal? OutMaxQty { get; set; }
        /// <summary>
        /// 出库下限 
        ///</summary>
         [SugarColumn(ColumnName="OUT_MIN_QTY")]
         public decimal? OutMinQty { get; set; }
        /// <summary>
        /// 交货地点 
        ///</summary>
         [SugarColumn(ColumnName="DELIVERY_LOC")]
         public string? DeliveryLoc { get; set; }
        /// <summary>
        /// 交货地址 
        ///</summary>
         [SugarColumn(ColumnName="DELIVERYL_ADDRESS")]
         public string? DeliverylAddress { get; set; }
        /// <summary>
        /// 源单单号 
        ///</summary>
         [SugarColumn(ColumnName="SOURCE_BILL_NO")]
         public string? SourceBillNo { get; set; }
        /// <summary>
        /// 订单单号 
        ///</summary>
         [SugarColumn(ColumnName="ORDER_BILL_NO")]
         public string? OrderBillNo { get; set; }
        /// <summary>
        /// 终止状态 
        ///</summary>
         [SugarColumn(ColumnName="TERMINATION_STATUS")]
         public string? TerminationStatus { get; set; }
        /// <summary>
        /// 终止日期 
        ///</summary>
         [SugarColumn(ColumnName="TERMINATION_DATE")]
         public DateTime? TerminationDate { get; set; }
        /// <summary>
        /// 累计出库数量 
        ///</summary>
         [SugarColumn(ColumnName="SUM_OUT_QTY")]
         public decimal? SumOutQty { get; set; }
        /// <summary>
        /// 未出库数量 
        ///</summary>
         [SugarColumn(ColumnName="REMAIN_OUT_QTY")]
         public decimal? RemainOutQty { get; set; }
        /// <summary>
        /// ERP行ID 
        ///</summary>
         [SugarColumn(ColumnName="ERP_LINE_ID")]
         public string? ErpLineId { get; set; }
        /// <summary>
        /// ERP头ID 
        ///</summary>
         [SugarColumn(ColumnName="ERP_HEAD_ID")]
         public string? ErpHeadId { get; set; }
        /// <summary>
        ///     销售订单号
        /// </summary>
        [SugarColumn(ColumnName = "SALES_ORDER")]
        public string? SalesOrder { get; set; }
 /// <summary>
 /// </summary>
 [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_SALES",
        IsPrimaryKey = true)]
    public decimal? Id { get; set; }

        /// <summary>
        ///    客户订单号
        /// </summary>
        [SugarColumn(ColumnName = "CUST_ORDER")]
        public string? CustOrder { get; set; }
 /// <summary>
 ///     销售订单号
 /// </summary>
 [SugarColumn(ColumnName = "SALES_ORDER_ID")]
    public string? SalesOrderId { get; set; }

        /// <summary>
        ///    销售合同编号
        /// </summary>
        [SugarColumn(ColumnName = "SALES_CONTRACT_NO")]
        public string? SalesContractNo { get; set; }
 /// <summary>
 ///     物料编码
 /// </summary>
 [SugarColumn(ColumnName = "MATERIAL_ID")]
    public string? MaterialId { get; set; }

        /// <summary>
        ///    客户物料名称
        /// </summary>
        [SugarColumn(ColumnName = "F_KHWLMC")]
        public string? F_KHWLMC { get; set; }
 /// <summary>
 ///     物料名称
 /// </summary>
 [SugarColumn(ColumnName = "MATERIAL_NAME")]
    public string? MaterialName { get; set; }

        /// <summary>
        ///    客户物料编码
        /// </summary>
        [SugarColumn(ColumnName = "F_KHWLBM")]
        public string? F_KHWLBM { get; set; }
 /// <summary>
 ///     物料规格
 /// </summary>
 [SugarColumn(ColumnName = "MATERIAL_SPECIFICATION")]
    public string? MaterialSpecification { get; set; }

        /// <summary>
        ///    是否完结
        /// </summary>
        [SugarColumn(ColumnName = "IS_FINISH")]
        public decimal? IsFinish { get; set; }
    }
 /// <summary>
 ///     销售单位
 /// </summary>
 [SugarColumn(ColumnName = "SALES_UNIT_ID")]
    public string? SalesUnitId { get; set; }

}
 /// <summary>
 ///     销售数量
 /// </summary>
 [SugarColumn(ColumnName = "SALES_QUANTITY")]
    public decimal? SalesQuantity { get; set; }

 /// <summary>
 ///     是否赠品
 /// </summary>
 [SugarColumn(ColumnName = "IS_FREE")]
    public decimal IsFree { get; set; }

 /// <summary>
 ///     要货日期
 /// </summary>
 [SugarColumn(ColumnName = "DELIVERY_DATE")]
    public DateTime? DeliveryDate { get; set; }

 /// <summary>
 ///     出货仓库
 /// </summary>
 [SugarColumn(ColumnName = "WAREHOUSE")]
    public string? Warehouse { get; set; }

 /// <summary>
 ///     计划跟踪号
 /// </summary>
 [SugarColumn(ColumnName = "PLAN_TRACKING_NUMBER")]
    public string? PlanTrackingNumber { get; set; }

 /// <summary>
 ///     批号
 /// </summary>
 [SugarColumn(ColumnName = "LOT_NUMBER")]
    public string? LotNumber { get; set; }

 /// <summary>
 ///     源单编号
 /// </summary>
 [SugarColumn(ColumnName = "SRC_BILL_NO")]
    public string? SrcBillNo { get; set; }

 /// <summary>
 ///     计价数量
 /// </summary>
 [SugarColumn(ColumnName = "PRICE_QTY")]
    public decimal? PriceQty { get; set; }

 /// <summary>
 ///     货主
 /// </summary>
 [SugarColumn(ColumnName = "OWNER_ID")]
    public string? OwnerId { get; set; }

 /// <summary>
 ///     库存单位
 /// </summary>
 [SugarColumn(ColumnName = "INVENTORY_UNIT")]
    public string? InventoryUnit { get; set; }

 /// <summary>
 ///     库存数量
 /// </summary>
 [SugarColumn(ColumnName = "INVENTORY_QUANTITY")]
    public decimal? InventoryQuantity { get; set; }

 /// <summary>
 ///     物料类别
 /// </summary>
 [SugarColumn(ColumnName = "MATERIAL_CATEGORY")]
    public string? MaterialCategory { get; set; }

 /// <summary>
 ///     计划发货日期
 /// </summary>
 [SugarColumn(ColumnName = "PLAN_DELIVERY_DATE")]
    public DateTime? PlanDeliveryDate { get; set; }

 /// <summary>
 ///     超发控制单位
 /// </summary>
 [SugarColumn(ColumnName = "OUT_LMT_UNIT")]
    public string? OutLmtUnit { get; set; }

 /// <summary>
 ///     出库上限
 /// </summary>
 [SugarColumn(ColumnName = "OUT_MAX_QTY")]
    public decimal? OutMaxQty { get; set; }

 /// <summary>
 ///     出库下限
 /// </summary>
 [SugarColumn(ColumnName = "OUT_MIN_QTY")]
    public decimal? OutMinQty { get; set; }

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

 /// <summary>
 ///     交货地址
 /// </summary>
 [SugarColumn(ColumnName = "DELIVERYL_ADDRESS")]
    public string? DeliverylAddress { get; set; }

 /// <summary>
 ///     源单单号
 /// </summary>
 [SugarColumn(ColumnName = "SOURCE_BILL_NO")]
    public string? SourceBillNo { get; set; }

 /// <summary>
 ///     订单单号
 /// </summary>
 [SugarColumn(ColumnName = "ORDER_BILL_NO")]
    public string? OrderBillNo { get; set; }

 /// <summary>
 ///     终止状态
 /// </summary>
 [SugarColumn(ColumnName = "TERMINATION_STATUS")]
    public string? TerminationStatus { get; set; }

 /// <summary>
 ///     终止日期
 /// </summary>
 [SugarColumn(ColumnName = "TERMINATION_DATE")]
    public DateTime? TerminationDate { get; set; }

 /// <summary>
 ///     累计出库数量
 /// </summary>
 [SugarColumn(ColumnName = "SUM_OUT_QTY")]
    public decimal? SumOutQty { get; set; }

 /// <summary>
 ///     未出库数量
 /// </summary>
 [SugarColumn(ColumnName = "REMAIN_OUT_QTY")]
    public decimal? RemainOutQty { get; set; }

 /// <summary>
 ///     ERP行ID
 /// </summary>
 [SugarColumn(ColumnName = "ERP_LINE_ID")]
    public string? ErpLineId { get; set; }

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

 /// <summary>
 ///     销售订单号
 /// </summary>
 [SugarColumn(ColumnName = "SALES_ORDER")]
    public string? SalesOrder { get; set; }

 /// <summary>
 ///     客户订单号
 /// </summary>
 [SugarColumn(ColumnName = "CUST_ORDER")]
    public string? CustOrder { get; set; }

 /// <summary>
 ///     销售合同编号
 /// </summary>
 [SugarColumn(ColumnName = "SALES_CONTRACT_NO")]
    public string? SalesContractNo { get; set; }

 /// <summary>
 ///     客户物料名称
 /// </summary>
 [SugarColumn(ColumnName = "F_KHWLMC")]
    public string? F_KHWLMC { get; set; }

 /// <summary>
 ///     客户物料编码
 /// </summary>
 [SugarColumn(ColumnName = "F_KHWLBM")]
    public string? F_KHWLBM { get; set; }

 /// <summary>
 ///     是否完结
 /// </summary>
 [SugarColumn(ColumnName = "IS_FINISH")]
    public decimal? IsFinish { get; set; }
}