DEMOMySql/MicroServices/Business/Business.Application.Contracts/Dto/VSMDto.cs

using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Metadata.Internal;
using Org.BouncyCastle.Utilities.Collections;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Business.Dto
{
    public partial class ValueFrequencyDto
    {
        /// <summary>
        /// AR
        /// </summary>
        public string jzpc1 { get; set; }

        /// <summary>
        /// AM
        /// </summary>
        public string jzpc2 { get; set; }

        /// <summary>
        /// AF
        /// </summary>
        public string jzpc3 { get; set; }
        /// <summary>
        /// BR
        /// </summary>
        public string jzpc4 { get; set; }
        /// <summary>
        /// BM
        /// </summary>
        public string jzpc5 { get; set; }
        /// <summary>
        /// BF
        /// </summary>
        public string jzpc6 { get; set; }
        /// <summary>
        /// CR
        /// </summary>
        public string jzpc7 { get; set; }
        /// <summary>
        /// CM
        /// </summary>
        public string jzpc8 { get; set; }
        /// <summary>
        /// CF
        /// </summary>
        public string jzpc9 { get; set; }
    }

    public partial class ValueFrequencyDetailDto
    {
        /// <summary>
        /// 价值排序
        /// </summary>
        public int RowSeq { get; set; }

        /// <summary>
        /// ABC
        /// </summary>
        public string ItemABC { get; set; }

        /// <summary>
        /// FMR
        /// </summary>
        public string ItemFMR { get; set; }

        /// <summary>
        /// 物料编码
        /// </summary>
        public string ItemNum { get; set; }

        /// <summary>
        /// 物料名称
        /// </summary>
        public string ItemName { get; set; }

        /// <summary>
        /// 规格型号
        /// </summary>
        public string Model { get; set; }

        /// <summary>
        /// 金额
        /// </summary>
        public decimal Amount { get; set; }

        /// <summary>
        /// 优化后占用目标
        /// </summary>
        public decimal AmountFix { get; set; }

        /// <summary>
        /// 差额
        /// </summary>
        public decimal AmountDiff { get; set; }
    }

    public partial class ValueFrequencyKanBanDto
    {
        /// <summary>
        /// 价值流排序
        /// </summary>
        public int RowSeq { get; set; }

        /// <summary>
        /// 物料主键
        /// </summary>
        public long ItemId { get; set; }

        /// <summary>
        /// 物料编码
        /// </summary>
        public string ItemNumber { get; set; }

        /// <summary>
        /// 物料名称
        /// </summary>
        public string ItemName { get; set; }

        /// <summary>
        /// 单价
        /// </summary>
        public decimal NETPR { get; set; }

        /// <summary>
        /// 规格型号
        /// </summary>
        public string Model { get; set; }

        /// <summary>
        /// 总金额
        /// </summary>
        public decimal AmountTotal { get; set; }

        /// <summary>
        /// 金额占比
        /// </summary>
        public decimal Amount { get; set; }

        /// <summary>
        /// ABC分类
        /// </summary>
        public string ABC { get; set; }


        /// <summary>
        /// 出库数量汇总
        /// </summary>
        public decimal OutStockQty { get; set; }

        /// <summary>
        /// 移动次数
        /// </summary>
        public decimal MoveCount { get; set; }

        /// <summary>
        /// 移动频次
        /// </summary>
        public decimal MovePencent { get; set; }

        /// <summary>
        /// FMR分类
        /// </summary>
        public string FMR { get; set; }

        /// <summary>
        /// 采购提前期
        /// </summary>
        public decimal PLT { get; set; }

        /// <summary>
        /// 库存平均每日用量=选定周期内出库总数/库存天数
        /// </summary>
        public decimal ADU { get; set; }

        /// <summary>
        /// ADU* PLT(从货源清单取，没有默认14天)
        /// </summary>
        public decimal Kanban { get; set; }
    }

    [Keyless]
    public partial class ValueFrequencyChartDto
    {
        /// <summary>
        /// 日库存数
        /// </summary>
        public decimal StockQty { get; set; }

        /// <summary>
        /// 入库数
        /// </summary>
        public decimal InStockQty { get; set; }

        /// <summary>
        /// 出库数
        /// </summary>
        public decimal OutStockQty { get; set; }

        /// <summary>
        /// 推荐日库存数
        /// </summary>
        public decimal SuggestQty { get; set; }

        /// <summary>
        /// 日期
        /// </summary>
        public string Date { get; set; }
    }

    public partial class ModelMonthOutkDto
    {
        public string Month0 { get; set; }
        public decimal Month1 { get; set; }
        public decimal Month2 { get; set; }
        public decimal Month3 { get; set; }
        public decimal Month4 { get; set; }
        public decimal Month5 { get; set; }
        public decimal Month6 { get; set; }
        public decimal Month7 { get; set; }
        public decimal Month8 { get; set; }
        public decimal Month9 { get; set; }
        public decimal Month10 { get; set; }
        public decimal Month11 { get; set; }
        public decimal Month12 { get; set; }
        public decimal Month13 { get; set; }
        public decimal Month14 { get; set; }
    }

    [Keyless]
    public partial class ForecastActualDto
    {
        public string ItemNum { get; set; }
        public string GroupBy { get; set; }
        public decimal ThreeMonthSales { get; set; }
        public decimal StockTurnOver { get; set; }
        public decimal M1Plan { get; set; }
        public decimal M1Real { get; set; }
        public string M1Diff { get; set; }
        public decimal M2Plan { get; set; }
        public decimal M2Real { get; set; }
        public string M2Diff { get; set; }
    }
    [Keyless]
    public partial class InventoryDto
    {
        public string ItemNumber { get; set; }
        public string ItemName { get; set; }
        public string ProLine { get; set; }
        public string Series { get; set; }
        public string Model { get; set; }
        public decimal FactoryInv { get; set; }
        public decimal GKInv { get; set; }
        public decimal HWInv { get; set; }
        public decimal TotalInv { get; set; }
        public decimal T1MonthlyDemand { get; set; }
        public decimal HWMonthlyDemand { get; set; }
        public decimal GKMonthlyDemand { get; set; }
        public decimal TotalMonthlyDemand { get; set; }
        public decimal HWCoverageMonth { get; set; }
        public decimal GKCoverageMonth { get; set; }
        public decimal TotalCoverageMonth { get; set; }
    }
    [Keyless]
    public partial class DMSShippingDetailDto
    {
        public string ItemNum { get; set; }
        public string UPN { get; set; }
        public decimal Qty { get; set; }
    }
    [Keyless]
    public partial class LocationQtyDto
    {
        public int RowNum { get; set; }
        public string Location { get; set; }
        public string Shelf { get; set; }
        public string ItemNum { get; set; }
        public string LotSerial { get; set; }
        public decimal QtyOnHand { get; set; }
        public string LevelChar { get; set; }
        public decimal AvailStatusQty { get; set; }
        public decimal Assay { get; set; }
        public decimal FreezeQty { get; set; }
        public string LocType { get; set; }
        public string Supply { get; set; }
    }
}