Revert "销售退货通知单完善、销售收货通知单增加"

zyf

2024-12-11 1afd9dafa4d1ec83f4f94c2ceae41b03179b533f

 MES.Service/Modes/SalesReturnNotice.cs

@@ -1,209 +1,162 @@
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 SalesReturn
{
    /// <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; }
    }
}
    ///     SEQ_sales
    /// </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 bool IsFree { get; set; }

    /// <summary>
    ///     退货日期
    /// </summary>
    [SugarColumn(ColumnName = "RETURN_DATE")]
    public DateTime? ReturnDate { 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 = "NOTE")]
    public string Note { get; set; }

    /// <summary>
    ///     退货类型
    /// </summary>
    [SugarColumn(ColumnName = "RETURN_TYPE")]
    public string ReturnType { get; set; }

    /// <summary>
    ///     跟单员
    /// </summary>
    [SugarColumn(ColumnName = "SALES_CLERK")]
    public string SalesClerk { 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 = "OWNER_TYPE_ID")]
    public string OwnerTypeId { get; set; }

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

    /// <summary>
    ///     源单类型
    /// </summary>
    [SugarColumn(ColumnName = "SOURCE_BILL_TYPE")]
    public string SourceBillType { 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>
    ///     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; }

}