using System;
using System.Collections.Generic;
using System.Linq;
using HH.WCS.Mobox3.HD.util;
using SqlSugar;
using HH.WCS.Mobox3.HD.models;
using HH.WCS.Mobox3.HD.wms;
using static HH.WCS.Mobox3.HD.api.DigitHelper;
using static HH.WCS.Mobox3.HD.api.DigitHelper.GJSpecStatisticData;
using System.Reflection;
using HH.WCS.Mobox3.HD.device;
using static HH.WCS.Mobox3.HD.core.Monitor;
using Newtonsoft.Json;
using static HH.WCS.Mobox3.HD.api.WmsController;


namespace HH.WCS.Mobox3.HD.api
{
    public class DigitHelper
    {

        /// <summary>
        /// 1.查询当前备货区所有成品信息
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public static List<BaseItemInfo> queryAllFinishProduct(AreaModel model)
        {
            BaseItemInfo itemInfo = new BaseItemInfo();
            var db = new SqlHelper<object>().GetInstance();
            List<BaseItemInfo> itemInfoList = db.Queryable<Location>()
            .LeftJoin<LocCntrRel>((l, lc) => l.S_CODE == lc.S_LOC_CODE)
            .LeftJoin<CntrItemRel>((l, lc, ci) => lc.S_CNTR_CODE == ci.S_CNTR_CODE)
            .Where((l, lc, ci) => l.S_AREA_CODE == model.areaCode && l.N_CURRENT_NUM > 0)
                .Select(
                   (l, lc, ci) => new BaseItemInfo
                   {
                       areaCode = l.S_AREA_CODE,
                       trayCode = lc.S_CNTR_CODE,
                       locCode = l.S_CODE,
                       workNo = ci.S_WORK_NO,
                       workName = ci.S_WORK_NAME,
                       dePartNo = ci.S_DEPART_NO,
                       partDrawNo = ci.S_PARTDRAW_NO,
                       partName = ci.S_PART_NAME,
                       itemCode = ci.S_ITEM_CODE,
                       itemName = ci.S_ITEM_NAME,
                       weight = ci.F_WEIGHT,
                       quantity = ci.F_QTY,
                   }
                ).ToList();
            return itemInfoList;
        }

        /// <summary>
        /// 2.查询三个立体库的汇总数据
        /// </summary>
        /// <returns></returns>
        public static LTKSummaryData queryLTKSummaryData()
        {
            LTKSummaryData summaryData = new LTKSummaryData();
            var db = new SqlHelper<object>().GetInstance();
            List<string> areaCodes = Settings.getStoreAreaCodes(0, 1);
            var query = db.Queryable<Location>().Where(a => areaCodes.Contains(a.S_AREA_CODE));

            int sum = query.Count(); // 三个立体库总货位数
            int usageNum = query.Where(a => a.N_CURRENT_NUM > 0).Count(); // 三个立体库总共已使用库位数
            double usageRate = Math.Round((double)usageNum / sum * 100, 2); //三个立体库库位使用率（=已使用库位数/总库位数）

            int semiProdNum = 0;
            double semiProdProp = 0;
            {
                //三个立体库合计半成品所占库位数
                semiProdNum = db.Queryable<Location>()
                 .LeftJoin<LocCntrRel>((l, lc) => l.S_CODE == lc.S_LOC_CODE)
                 .LeftJoin<CntrItemRel>((l, lc, ci) => lc.S_CNTR_CODE == ci.S_CNTR_CODE)
                 .Where((l, lc, ci) => areaCodes.Contains(l.S_AREA_CODE) && l.N_CURRENT_NUM > 0 && ci.S_ITEM_TYPE == "半成品").Count();
                //个立体库合计半成品所占库位数在总体中占比
                semiProdProp = Math.Round((double)semiProdNum / sum * 100, 2);
            }

            int finishProdNum = 0;
            double finishProdProp;
            {
                //三个立体库合计成品所占库位数
                finishProdNum = db.Queryable<Location>()
                 .LeftJoin<LocCntrRel>((l, lc) => l.S_CODE == lc.S_LOC_CODE)
                 .LeftJoin<CntrItemRel>((l, lc, ci) => lc.S_CNTR_CODE == ci.S_CNTR_CODE)
                 .Where((l, lc, ci) => areaCodes.Contains(l.S_AREA_CODE) && l.N_CURRENT_NUM > 0 && ci.S_ITEM_TYPE == "成品").Count(); ;
                //三个立体库合计成品所占库位数在总体中占比
                finishProdProp = Math.Round((double)finishProdNum / sum * 100, 2);
            }

            summaryData.sum = sum;
            summaryData.usageNum = usageNum;
            summaryData.usageRate = usageRate + "%";
            summaryData.semiProdNum = semiProdNum;
            summaryData.semiProdProp = semiProdProp + "%";
            summaryData.finishProdNum = finishProdNum;
            summaryData.finishProdProp = finishProdProp + "%";
            return summaryData;
        }

        /// <summary>
        /// 3.按图号汇总成品、半成品所占库位数量列表
        /// </summary>
        /// <returns></returns>
        public static List<WorkNoSummaryData> queryLTKWorkNoSummaryData1(ItemTypeModel model)
        {
            var db = new SqlHelper<object>().GetInstance();
            // 三个立体库总货位数
            List<string> areaCodes = Settings.getStoreAreaCodes(0, 1);
            List<WorkNoSummaryData> workSummaryDatas = db.Queryable<Location>()
                        .LeftJoin<LocCntrRel>((l, lc) => l.S_CODE == lc.S_LOC_CODE)
                        .LeftJoin<CntrItemRel>((l, lc, ci) => lc.S_CNTR_CODE == ci.S_CNTR_CODE && ci.S_ITEM_TYPE == model.itemType)
                        .Where((l, lc, ci) => areaCodes.Contains(l.S_AREA_CODE) && l.N_CURRENT_NUM > 0 && ci.S_ITEM_TYPE == model.itemType)
                        .GroupBy((l, lc, ci) => new { ci.S_WORK_NO, ci.S_WORK_NAME })
                        .Select(
                            (l, lc, ci) => new WorkNoSummaryData()
                            {
                                workNo = ci.S_WORK_NO,
                                workName = ci.S_WORK_NAME,
                                amount = SqlFunc.AggregateCount(ci.S_WORK_NO)
                            }
                        )
                        .MergeTable()
                        .OrderByDescending(a => a.amount)
                        .Take(5)
                        .ToList();
            if (workSummaryDatas != null && workSummaryDatas.Count > 0)
            {
                float sum = workSummaryDatas.Sum(a => a.amount);
                foreach (var item in workSummaryDatas)
                {
                    item.proportion = Math.Round((double)item.amount / sum * 100, 2) + "%";
                }
            }
            return workSummaryDatas;
        }

        /// <summary>
        /// 4.按工作号汇总成品、半成品所占库位数量、占比
        /// </summary>
        /// <returns></returns>
        public static List<WorkNoSummaryData> queryLTKWorkNoSummaryData()
        {
            var db = new SqlHelper<object>().GetInstance();
            // 三个立体库总货位数
            List<string> areaCodes = Settings.getStoreAreaCodes(0, 1);
            List<WorkNoSummaryData> summaryDatas = db.Queryable<Location>()
             .LeftJoin<LocCntrRel>((l, lc) => l.S_CODE == lc.S_LOC_CODE)
             .LeftJoin<CntrItemRel>((l, lc, ci) => lc.S_CNTR_CODE == ci.S_CNTR_CODE)
             .Where((l, lc, ci) => areaCodes.Contains(l.S_AREA_CODE) && l.N_CURRENT_NUM > 0 )
             .GroupBy((l, lc, ci) => new { ci.S_WORK_NO, ci.S_WORK_NAME })
             .Select(
                 (l, lc, ci) => new WorkNoSummaryData()
                 {
                     workNo = ci.S_WORK_NO,
                     workName = ci.S_WORK_NAME,
                     amount = SqlFunc.AggregateCount(ci.S_PARTDRAW_NO)
                 }
             )
             .MergeTable()
             .OrderByDescending(a => a.amount)
             .Take(5)
             .ToList();

            if (summaryDatas != null && summaryDatas.Count > 0)
            {
                float sum = summaryDatas.Sum(a => a.amount);
                foreach (var item in summaryDatas)
                {
                    item.proportion = Math.Round((double)item.amount / sum * 100, 2) + "%";
                }
            }
            return summaryDatas;
        }

        /// <summary>
        /// 4.1.按工作号汇总成品、半成品所占库位数量、占比
        /// </summary>
        /// <returns></returns>
        public static List<WorkNoSummaryData> queryWorkNoAndItemTypeLTKSummaryData(AreaModel model)
        {
            var db = new SqlHelper<object>().GetInstance();
            // 三个立体库总货位数
            List<string> areaCodes = Settings.getStoreAreaCodes(0, 1);
            var queryable = db.Queryable<Location>()
             .LeftJoin<LocCntrRel>((l, lc) => l.S_CODE == lc.S_LOC_CODE)
             .LeftJoin<CntrItemRel>((l, lc, ci) => lc.S_CNTR_CODE == ci.S_CNTR_CODE)
             .Where((l, lc, ci) => l.N_CURRENT_NUM > 0);

            if (model.areaCode == null)
            {
                queryable = queryable.Where((l, lc, ci) => areaCodes.Contains(l.S_AREA_CODE));
            }
            else
            {
                queryable = queryable.Where((l, lc, ci) => l.S_AREA_CODE == model.areaCode);
            }

            List<WorkNoSummaryData> summaryDatas = queryable
            .GroupBy((l, lc, ci) => new { l.S_AREA_CODE, ci.S_WORK_NO, ci.S_ITEM_TYPE })
            .Select(
                (l, lc, ci) => new WorkNoSummaryData()
                {
                    areaCode = l.S_AREA_CODE,
                    workNo = ci.S_WORK_NO,
                    type = ci.S_ITEM_TYPE,
                    amount = SqlFunc.AggregateCount(ci.S_PARTDRAW_NO)
                }
            )
            .MergeTable()
            .OrderByDescending(a => a.amount)
            .ToList();

            if (summaryDatas != null && summaryDatas.Count > 0)
            {
                float sum = summaryDatas.Sum(a => a.amount);
                foreach (var item in summaryDatas)
                {
                    item.areaName = LocationHelper.GetArea(item.areaCode).S_NAME;
                    item.proportion = Math.Round((double)item.amount / sum * 100, 2) + "%";
                }
            }
            return summaryDatas;
        }

        /// <summary>
        /// 5.根据在库时长汇总成品、半成品的所占库位数量
        /// </summary>
        /// <returns></returns>
        public static StorageTimeSummaryData storageTimeSummary()
        {
            StorageTimeSummaryData summaryData = new StorageTimeSummaryData();
            var db = new SqlHelper<object>().GetInstance();
            // 三个立体库总货位数
            List<string> areaCodes = Settings.getStoreAreaCodes(0, 1);
            var query = db.Queryable<Location>()
            .LeftJoin<LocCntrRel>((l, lc) => l.S_CODE == lc.S_LOC_CODE)
            .LeftJoin<CntrItemRel>((l, lc, ci) => lc.S_CNTR_CODE == ci.S_CNTR_CODE)
            .Where((l, lc, ci) => areaCodes.Contains(l.S_AREA_CODE));

            int sum = query.Count(); // 总库位数
            int usageNum = query.Where((l, lc, ci) => l.N_CURRENT_NUM > 0 && (ci.S_ITEM_TYPE == "成品" || ci.S_ITEM_TYPE == "半成品")).Count(); // 使用数
            string usageRate = Math.Round((double)usageNum / sum * 100, 2) + "%";  // 使用率
            int amountA = 0;
            string proportionA = null;
            {
                var queryWrapper = db.Queryable<Location>()
                .LeftJoin<LocCntrRel>((l, lc) => l.S_CODE == lc.S_LOC_CODE)
                .LeftJoin<CntrItemRel>((l, lc, ci) => lc.S_CNTR_CODE == ci.S_CNTR_CODE)
                .Where((l, lc, ci) => areaCodes.Contains(l.S_AREA_CODE) && l.N_CURRENT_NUM > 0 && (ci.S_ITEM_TYPE == "成品" || ci.S_ITEM_TYPE == "半成品"));
                amountA = queryWrapper.Where("DATEDIFF(day, l.T_FULL_TIME, GETDATE()) <= 7").Count();
                proportionA = Math.Round((double)amountA / sum * 100, 2) + "%";
            }
            int amountB = 0;
            string proportionB = null;
            {
                var queryWrapper = db.Queryable<Location>()
                .LeftJoin<LocCntrRel>((l, lc) => l.S_CODE == lc.S_LOC_CODE)
                .LeftJoin<CntrItemRel>((l, lc, ci) => lc.S_CNTR_CODE == ci.S_CNTR_CODE)
                .Where((l, lc, ci) => areaCodes.Contains(l.S_AREA_CODE) && l.N_CURRENT_NUM > 0 && (ci.S_ITEM_TYPE == "成品" || ci.S_ITEM_TYPE == "半成品"));
                amountB = queryWrapper.Where("DATEDIFF(day, l.T_FULL_TIME, GETDATE()) > 7 and DATEDIFF(day, T_FULL_TIME, GETDATE()) <= 15").Count();
                proportionB = Math.Round((double)amountB / sum * 100, 2) + "%";
            }
            int amountC = 0;
            string proportionC = null;
            {
                var queryWrapper = db.Queryable<Location>()
                .LeftJoin<LocCntrRel>((l, lc) => l.S_CODE == lc.S_LOC_CODE)
                .LeftJoin<CntrItemRel>((l, lc, ci) => lc.S_CNTR_CODE == ci.S_CNTR_CODE)
                .Where((l, lc, ci) => areaCodes.Contains(l.S_AREA_CODE) && l.N_CURRENT_NUM > 0 && (ci.S_ITEM_TYPE == "成品" || ci.S_ITEM_TYPE == "半成品"));
                amountC = queryWrapper.Where("DATEDIFF(day, l.T_FULL_TIME, GETDATE()) > 15 and DATEDIFF(day, T_FULL_TIME, GETDATE()) <= 30").Count();
                proportionC = Math.Round((double)amountC / sum * 100, 2) + "%";
            }
            int amountD = 0;
            string proportionD = null;
            {
                var queryWrapper = db.Queryable<Location>()
                .LeftJoin<LocCntrRel>((l, lc) => l.S_CODE == lc.S_LOC_CODE)
                .LeftJoin<CntrItemRel>((l, lc, ci) => lc.S_CNTR_CODE == ci.S_CNTR_CODE)
                .Where((l, lc, ci) => areaCodes.Contains(l.S_AREA_CODE) && l.N_CURRENT_NUM > 0 && (ci.S_ITEM_TYPE == "成品" || ci.S_ITEM_TYPE == "半成品"));
                amountD = queryWrapper.Where("DATEDIFF(day, l.T_FULL_TIME, GETDATE()) > 30 and DATEDIFF(day, T_FULL_TIME, GETDATE()) <= 90").Count();
                proportionD = Math.Round((double)amountD / sum * 100, 2) + "%";
            }
            int amountE = 0;
            string proportionE = null;
            {
                var queryWrapper = db.Queryable<Location>()
                .LeftJoin<LocCntrRel>((l, lc) => l.S_CODE == lc.S_LOC_CODE)
                .LeftJoin<CntrItemRel>((l, lc, ci) => lc.S_CNTR_CODE == ci.S_CNTR_CODE)
                .Where((l, lc, ci) => areaCodes.Contains(l.S_AREA_CODE) && l.N_CURRENT_NUM > 0 && (ci.S_ITEM_TYPE == "成品" || ci.S_ITEM_TYPE == "半成品"));
                amountE = queryWrapper.Where("DATEDIFF(day, l.T_FULL_TIME, GETDATE()) > 90").Count();
                proportionE = Math.Round((double)amountE / sum * 100, 2) + "%";
            }
            summaryData.sum = sum;
            summaryData.usageNum = usageNum;
            summaryData.usageRate = usageRate;
            summaryData.amountA = amountA;
            summaryData.proportionA = proportionA;
            summaryData.amountB = amountB;
            summaryData.proportionB = proportionB;
            summaryData.amountC = amountC;
            summaryData.proportionC = proportionC;
            summaryData.amountD = amountD;
            summaryData.proportionD = proportionD;
            summaryData.amountE = amountE;
            summaryData.proportionE = proportionE;
            return summaryData;
        }

        /// <summary>
        /// 6.按图号汇总三个立体库的出库（入库）数量和占比
        /// </summary>
        /// <returns></returns>
        public static List<DrawSummaryData> outInStockDrawNoSummary(ActModel actModel)
        {
            var db = new SqlHelper<object>().GetInstance();
            // 三个立体库总货位数
            List<string> areaCodes = Settings.getStoreAreaCodes(0, 1);
            var query = db.Queryable<StockRecord>().Where(a => areaCodes.Contains(a.S_AREA_CODE));
            DateTime date = DateTime.Parse(actModel.dataDate).Date;
            string sql = null;
            if (actModel.actType.Equals("入库"))
            {
                sql = "CONVERT(date, T_IN_TIME) = @date";
            }
            else
            {
                sql = "CONVERT(date, T_OUT_TIME) = @date";
            }
            List<DrawSummaryData> drawSummaryDatas = query.Where(sql, new { date }).GroupBy(a => new { a.S_PARTDRAW_NO, a.S_PART_NAME ,a.S_WORK_NO })
                .Select(
                    a => new DrawSummaryData()
                    {
                        partDrawNo = a.S_PARTDRAW_NO,
                        partName = a.S_PART_NAME,
                        workNo = a.S_WORK_NO,
                        amount = SqlFunc.AggregateCount(a.S_PARTDRAW_NO)
                    }
                ).OrderByDescending(a => a.amount).Take(5).ToList();
            if (drawSummaryDatas != null && drawSummaryDatas.Count > 0)
            {
                float sum = drawSummaryDatas.Sum(a => a.amount);
                foreach (var item in drawSummaryDatas)
                {
                    if (item.partDrawNo == null) { 
                        drawSummaryDatas.Remove(item);
                        continue;
                    }
                    item.proportion = Math.Round((double)item.amount / sum * 100, 2) + "%";
                }
            }
            return drawSummaryDatas;
        }

        /// <summary>
        /// 7.查询今日出厂的成品信息
        /// </summary>
        /// <returns></returns>
        public static List<WorkNoOutStockData> queryOutFactoryFinishProdList(DateModel model)
        {
            var db = new SqlHelper<object>().GetInstance();
            DateTime date = DateTime.Parse(model.dataDate).Date;
            List<string> areaCodes = Settings.getDispatchAreaCodes();
            var query = db.Queryable<StockRecord>().Where(a => areaCodes.Contains(a.S_AREA_CODE));
            List<WorkNoOutStockData> outStockDatas = new List<WorkNoOutStockData>();
            {
                outStockDatas = query.Where("CONVERT(date, T_OUT_TIME) = @date", new { date }).GroupBy(a => new { a.S_WORK_NO, a.S_WORK_NAME, a.S_DEPART_NO })
                .Select(
                    a => new WorkNoOutStockData()
                    {
                        workNo = a.S_WORK_NO,
                        workName = a.S_WORK_NAME,
                        dePartNo = a.S_DEPART_NO,
                        quantity = SqlFunc.AggregateSumNoNull(a.F_QTY),
                        weight = SqlFunc.AggregateSumNoNull(a.F_WEIGHT)
                    }
                ).ToList();
            }
            foreach (var item in outStockDatas)
            {
                item.accuQuantity = db.Queryable<StockRecord>().Where(a => areaCodes.Contains(a.S_AREA_CODE) && a.S_ACT_TYPE == "出库" && a.S_WORK_NO == item.workNo).Sum(a => a.F_QTY);
            }
            return outStockDatas;
        }

        /// <summary>
        /// 8.查询当前立体库汇总数据
        /// </summary>
        /// <returns></returns>
        public static AreaSummaryData queryLTKAreaSummaryData(AreaModel model)
        {
            AreaSummaryData areaSummaryData = new AreaSummaryData();
            var db = new SqlHelper<object>().GetInstance();
            var query = db.Queryable<Location>().Where(a => a.S_AREA_CODE == model.areaCode);
            {
                int sum = query.Count();
                int usageNum = query.Where(a => a.N_CURRENT_NUM > 0).Count();
                double usageRate = Math.Round((double)usageNum / sum * 100, 2);
                areaSummaryData.sum = sum;
                areaSummaryData.usageNum = usageNum;
                areaSummaryData.usageRate = usageRate.ToString();
            }
            List<WorkNoSummaryData> summaryDatas = db.Queryable<Location>()
            .LeftJoin<LocCntrRel>((l, lc) => l.S_CODE == lc.S_LOC_CODE)
            .LeftJoin<CntrItemRel>((l, lc, ci) => lc.S_CNTR_CODE == ci.S_CNTR_CODE)
            .Where((l, lc, ci) => l.N_CURRENT_NUM > 0 && ci.S_ITEM_TYPE == "成品" && l.S_AREA_CODE == model.areaCode)
            .GroupBy((l, lc, ci) => new { ci.S_WORK_NO, ci.S_WORK_NAME })
            .Select(
                    (l, lc, ci) => new WorkNoSummaryData()
                    {
                        workNo = ci.S_WORK_NO,
                        workName = ci.S_WORK_NAME,
                        amount = SqlFunc.AggregateCount(ci.S_PARTDRAW_NO)
                    }
            )
            .MergeTable()
            .OrderByDescending(a => a.amount)
            .Take(5)
            .ToList();

            areaSummaryData.workNoSummaryData = summaryDatas;
            return areaSummaryData;
        }

        /// <summary>
        /// 9.查询出入库信息汇总
        /// </summary>
        /// <returns></returns>
        public static List<DrawSummaryData> outInStackSummary(OutInStockModel model)
        {
            var db = new SqlHelper<object>().GetInstance();
            DateTime date = DateTime.Parse(model.dataDate).Date;
            var query = db.Queryable<StockRecord>().Where(a => a.S_AREA_CODE == model.areaCode && a.S_ACT_TYPE == model.actType);
            List<DrawSummaryData> outStockDatas = new List<DrawSummaryData>();
            {
                outStockDatas = query.Where("(CONVERT(date, T_OUT_TIME) = @date or CONVERT(date, T_IN_TIME) = @date)", new { date }).GroupBy(a => new { a.S_WORK_NO })
                .Where(a => a.S_WORK_NO != null)
                .Select(
                    a => new DrawSummaryData()
                    {
                        workNo = a.S_WORK_NO,
                        amount = SqlFunc.AggregateCount(a.S_CODE),
                    }
                ).ToList();
            }
            return outStockDatas;
        }

        /// <summary>
        /// 10.查询当前执行中和待执行任务列表汇总
        /// </summary>
        /// <returns></returns>
        public static List<ProceedTaskData> queryProceedTaskList(AreaModel model)
        {
            var db = new SqlHelper<object>().GetInstance();
            List<WCSTask> wcsTasks = db.Queryable<WCSTask>().Where(a => (a.S_START_AREA == model.areaCode || a.S_END_AREA == model.areaCode) && a.N_B_STATE < 3).OrderByDescending(a => a.T_CREATE).Take(10).ToList();

            List<ProceedTaskData> proceedTasks = new List<ProceedTaskData>();
            foreach (var item in wcsTasks)
            {
                ProceedTaskData proceedTask = new ProceedTaskData()
                {
                    taskType = item.S_TYPE,
                    taskStatus = item.S_B_STATE,
                };
                var cntrItemRels = ItemHelper.GetCntrItemByCntrCode(item.S_CNTR_CODE);
                if (cntrItemRels != null && cntrItemRels.Count > 0)
                {
                    proceedTask.prodName = cntrItemRels[0].S_WORK_NAME;
                    proceedTask.quantity = cntrItemRels[0].F_QTY;
                }
                proceedTasks.Add(proceedTask);
            }
            return proceedTasks;
        }

        /// <summary>
        /// 11.查询库位数据
        /// </summary>
        /// <returns></returns>
        public static AreaLocData queryAreaLocData(AreaModel model)
        {
            AreaLocData areaLocData = new AreaLocData();
            var db = new SqlHelper<object>().GetInstance();
            var rows = db.Queryable<Location>()
                    .Where(a => a.S_AREA_CODE == model.areaCode)
                    .GroupBy(l => new { l.N_ROW, l.N_LAYER })
                    .OrderBy(a => new { a.N_ROW, a.N_LAYER })
                            .Select(g => new
                            {
                                row = g.N_ROW,
                                layer = g.N_LAYER,
                            }).ToList();

            Dictionary<string, string> areaData = new Dictionary<string, string>();
            if (rows.Count > 0) 
            {
                rows.ForEach(it =>
                {
                    string locData = "";
                    List<Location> locList = db.Queryable<Location>()
                            .Where(a => a.S_AREA_CODE == model.areaCode && a.N_ROW == it.row && a.N_LAYER == it.layer)
                            .OrderBy(a => new { a.N_COL })
                            .ToList();
                    if (locList.Count > 0) 
                    {
                        foreach (var loc in locList)
                        {
                            if (loc.N_CURRENT_NUM > 0)
                            {
                                var locCntrs = LocationHelper.GetLocCntr(loc.S_CODE);
                                if (locCntrs.Count > 0)
                                {
                                    var cntrItemRels = ContainerHelper.GetCntrItemRel(locCntrs[0].S_CNTR_CODE);
                                    if (cntrItemRels.Count > 0)
                                    {
                                        string workNo = cntrItemRels[0].S_WORK_NO;
                                        if (workNo != null)
                                        {
                                            if (workNo.Contains("001"))
                                            {
                                                locData = locData + "4";
                                            }
                                            else if (workNo.Contains("002"))
                                            {
                                                locData = locData + "2";
                                            }
                                            else if (workNo.Contains("003"))
                                            {
                                                locData = locData + "3";
                                            }
                                            else 
                                            {
                                                locData = locData + "1";
                                            }
                                        }
                                        else 
                                        {
                                            locData = locData + "5";
                                        }
                                    }
                                    else
                                    {
                                        locData = locData + "5";
                                    }
                                }
                                else
                                {
                                    locData = locData + "1";
                                }

                            }
                            else
                            {
                                locData = locData + "0";
                            }
                        }
                        areaData.Add(it.row + "-" + it.layer, locData);
                    }
                });
                var area = db.Queryable<Area>().Where(a => a.S_CODE == model.areaCode).First();
                if (area != null) 
                {
                    areaLocData.areaCode = model.areaCode;
                    areaLocData.areaName = area.S_NAME;
                    areaLocData.areaData = areaData;
                }
            }
            return areaLocData;
        }

        /// <summary>
        /// 12.统计各库区库位总数、使用数量和使用率
        /// </summary>
        /// <returns></returns>
        public static List<AreaSummaryData> statisticsAllArea()
        {
            var db = new SqlHelper<object>().GetInstance();
            List<AreaSummaryData> areaSummaryDatas = db.Queryable<Location>().GroupBy(a => new { a.S_AREA_CODE })
                .Select(
                    a => new AreaSummaryData()
                    {
                        areaCode = a.S_AREA_CODE,
                        sum = SqlFunc.AggregateCount(a.S_CODE),
                    }
                ).ToList();
            if (areaSummaryDatas != null && areaSummaryDatas.Count > 0)
            {
                foreach (var item in areaSummaryDatas)
                {
                    var area = db.Queryable<Area>().Where(a => a.S_CODE == item.areaCode).First();
                    if (area == null) {
                        continue;
                    }
                    item.areaName = area.S_NAME;
                    item.usageNum = db.Queryable<Location>().Where(a => a.S_AREA_CODE == item.areaCode && a.N_CURRENT_NUM > 0).Count();
                    item.usageRate = Math.Round((double)item.usageNum / item.sum * 100, 2) + "%";
                }
            }
            return areaSummaryDatas;
        }

        /// <summary>
        /// 13.查询立体库库位数据
        /// </summary>
        /// <returns></returns>
        public static LTKLocationData queryLTKLocData(LocModel model)
        {
            var db = new SqlHelper<object>().GetInstance();
            string areaName = db.Queryable<Area>().Where(a => a.S_CODE == model.areaCode).First().S_NAME;
            LTKLocationData locItemData = db.Queryable<Location>()
            .LeftJoin<LocCntrRel>((l, lc) => l.S_CODE == lc.S_LOC_CODE)
            .LeftJoin<CntrItemRel>((l, lc, ci) => lc.S_CNTR_CODE == ci.S_CNTR_CODE)
            .Where((l, lc, ci) => l.S_AREA_CODE == model.areaCode && l.S_CODE == model.locCode)
            .Select(
                (l, lc, ci) =>
                new LTKLocationData()
                {
                    areaName = areaName,
                    areaCode = l.S_AREA_CODE,
                    areaType = "立体库",
                    trayCode = lc.S_CNTR_CODE,
                    locCode = l.S_CODE,
                    inStockTime = l.T_FULL_TIME,
                    itemCode = ci.S_ITEM_CODE,
                    itemName = ci.S_ITEM_NAME,
                    itemType = ci.S_ITEM_TYPE,
                    workNo = ci.S_WORK_NO,
                    workName = ci.S_WORK_NAME,
                    dePartNo = ci.S_DEPART_NO,
                    partDrawNo = ci.S_PARTDRAW_NO,
                    partName = ci.S_PART_NAME,
                    weight = ci.F_WEIGHT,
                    quantity = ci.F_QTY
                }
                )
            .First();

            if (locItemData != null)
            {
                TimeSpan? storagDuration = DateTime.Now - locItemData.inStockTime;
                if (storagDuration != null)
                {
                    locItemData.storagDuration = ((TimeSpan)storagDuration).Hours + "h";
                }
            }
            return locItemData;
        }

        /// <summary>
        /// 14.查询钢卷库库位数据
        /// </summary>
        /// <returns></returns>
        public static GJKLocationData queryGJKLocData(LocModel model)
        {
            var db = new SqlHelper<object>().GetInstance();
            string areaName = db.Queryable<Area>().Where(a => a.S_CODE == model.areaCode).First().S_NAME;
            GJKLocationData locationData = db.Queryable<Location>()
            .LeftJoin<LocCntrRel>((l, lc) => l.S_CODE == lc.S_LOC_CODE)
            .LeftJoin<CntrItemRel>((l, lc, ci) => lc.S_CNTR_CODE == ci.S_CNTR_CODE)
            .Where((l, lc, ci) => l.S_AREA_CODE == model.areaCode && l.S_CODE == model.locCode)
            .Select(
                (l, lc, ci) => new GJKLocationData
                {
                    areaName = areaName,
                    areaCode = l.S_AREA_CODE,
                    areaType = "钢卷库",
                    locCode = l.S_CODE,
                    inStockTime = l.T_FULL_TIME,
                    itemCode = ci.S_ITEM_CODE,
                    itemName = ci.S_ITEM_NAME,
                    itemType = ci.S_ITEM_TYPE,
                    workNo = ci.S_WORK_NO,
                    workName = ci.S_WORK_NAME,
                    coilNo = ci.S_COIL_NO,
                    spec = ci.S_ITEM_SPEC,
                    width = ci.S_WIDTH,
                    heatNo = ci.S_HEAT_NO,
                    shootNo = ci.S_SHOOT_NO,
                    weight = ci.F_WEIGHT,
                    quantity = ci.F_QTY,
                    initWeight = ci.F_INIT_WEIGHT
                }
                ).First();
            return locationData;
        }

        /// <summary>
        /// 15.查询模具库库位数据
        /// </summary>
        /// <returns></returns>
        public static MJKLocationData queryMJKLocData(LocModel model)
        {
            MJKLocationData locationData = null;
            var db = new SqlHelper<object>().GetInstance();
            string areaName = db.Queryable<Area>().Where(a => a.S_CODE == model.areaCode).First().S_NAME;
            Location location = db.Queryable<Location>().Where(a => a.S_AREA_CODE == model.areaCode && a.S_CODE == model.locCode).Includes(a => a.LocCntrRel, a => a.CntrItemRel).First();

            if (location != null)
            {
                locationData = new MJKLocationData()
                {
                    areaName = areaName,
                    areaCode = model.areaCode,
                    areaType = "模具库",
                    locCode = location.S_CODE,
                };
                if (location.LocCntrRel != null)
                {
                    locationData.trayCode = location.LocCntrRel.S_CNTR_CODE;
                    var mouldCntr = MouldHelper.GetMouldCntr(new MouldCntr() { S_CNTR_CODE = location.LocCntrRel.S_CNTR_CODE });
                    if (mouldCntr != null)
                    {
                        locationData.mouldNo = mouldCntr.S_MOULD_NO;
                    }
                }
            }
            return locationData;
        }

        /// <summary>
        /// 16.查询钢卷库区汇总数据
        /// </summary>
        /// <returns></returns>
        public static List<GJKAreaSummaryData> queryGJKAreaSummaryData(AreaListModel model)
        {
            List<GJKAreaSummaryData> gjkAreaSummaryDatas = new List<GJKAreaSummaryData>();
            var db = new SqlHelper<object>().GetInstance();
            List<string> gjAreaCodes = model.areaCodes;
            if (gjAreaCodes == null)
            {
                gjAreaCodes = Settings.getStoreAreaCodes(1, 2);
            }
            foreach (var areaCode in gjAreaCodes)
            {
                int stockNum = db.Queryable<Location>()
                    .LeftJoin<LocCntrRel>((l, lc) => l.S_CODE == lc.S_LOC_CODE)
                    .LeftJoin<CntrItemRel>((l, lc, ci) => lc.S_CNTR_CODE == ci.S_CNTR_CODE)
                    .Where((l, lc, ci) => l.S_AREA_CODE == areaCode && l.N_CURRENT_NUM > 0 ).Count();
                int intactNum = db.Queryable<Location>()
                    .LeftJoin<LocCntrRel>((l, lc) => l.S_CODE == lc.S_LOC_CODE)
                    .LeftJoin<CntrItemRel>((l, lc, ci) => lc.S_CNTR_CODE == ci.S_CNTR_CODE)
                    .Where((l, lc, ci) => l.S_AREA_CODE == areaCode && l.N_CURRENT_NUM > 0 && ci.F_WEIGHT == ci.F_INIT_WEIGHT).Count();
                
                int noIntactNum = db.Queryable<Location>()
                    .LeftJoin<LocCntrRel>((l, lc) => l.S_CODE == lc.S_LOC_CODE)
                    .LeftJoin<CntrItemRel>((l, lc, ci) => lc.S_CNTR_CODE == ci.S_CNTR_CODE)
                    .Where((l, lc, ci) => l.S_AREA_CODE == areaCode && l.N_CURRENT_NUM > 0 && ci.F_WEIGHT != ci.F_INIT_WEIGHT).Count();
               
                // 按钢卷号分组查询今日出库的最大钢卷重量（去除剪切位出库）
                var outCoilNoList = db.Queryable<StockRecord>().Where(a => a.S_AREA_CODE == areaCode && a.S_LOC_CODE != "剪切货位" && a.S_ACT_TYPE == "出库").Where("(CONVERT(date, T_OUT_TIME) = @date)", new { DateTime.Parse(model.dataDate).Date })
                                .GroupBy(a => a.S_COIL_NO)
                                .Select(group => new
                                {
                                    S_COIL_NO = group.S_COIL_NO,
                                    F_WEIGHT = SqlFunc.AggregateMax(group.F_WEIGHT)
                                }).ToList();
               

                // 计算今日钢卷消耗量
                float consumeWeight = 0;
                foreach (var item in outCoilNoList)
                {
                    consumeWeight = consumeWeight + item.F_WEIGHT;
                }
                GJKAreaSummaryData locationData = new GJKAreaSummaryData()
                {
                    areaCode = areaCode,
                    stockNum = stockNum,
                    intactNum = intactNum,
                    noIntactNum = noIntactNum,
                    consumeWeight = consumeWeight,
                    dataDate = model.dataDate,
                };
                gjkAreaSummaryDatas.Add(locationData);
            }
            return gjkAreaSummaryDatas;
        }

        /// <summary>
        /// 17.查询模具库区汇总数据
        /// </summary>
        /// <returns></returns>
        public static MJKAreaSummaryData queryMJKAreaSummaryData(AreaModel model)
        {

            var db = new SqlHelper<object>().GetInstance();
            int stockMouldNum = db.Queryable<Location>().Where(a => a.S_AREA_CODE == model.areaCode && a.N_CURRENT_NUM > 0).Count();
            int lendMouldNum = db.Queryable<MouldCntr>().Where(a => a.S_ABLE_FLAG == "否").Count();
            MJKAreaSummaryData areaSummaryData = new MJKAreaSummaryData()
            {
                stockMouldNum = stockMouldNum,
                lendMouldNum = lendMouldNum
            };
            return areaSummaryData;
        }

        /* /// <summary>
         /// 18.查询发货库区汇总数据
         /// </summary>
         /// <returns></returns>
         public static FHQAreaSummaryData queryFHQAreaSummaryData(AreaModel model)
         {

             var db = new SqlHelper<object>().GetInstance();
             int finishProdNum = db.Queryable<Location>().Where(a => a.S_AREA_CODE == model.areaCode && a.N_CURRENT_NUM > 0).Count();
             int lendMouldNum = db.Queryable<MouldCntr>().Where(a => a.S_ABLE_FLAG == "否").Count();
             FHQAreaSummaryData areaSummaryData = new FHQAreaSummaryData()
             {
                 finishProdNum = finishProdNum,
                 occupyLocNum = lendMouldNum,
                 leisureLocNum = lendMouldNum
             };
             return areaSummaryData;
         }*/

        /// <summary>
        /// 18.钢卷按规格分类统计
        /// </summary>
        /// <returns></returns>
        public static GJSpecStatisticData steelCoilSpecStatistic(AreaModel model)
        {
            GJSpecStatisticData gJSpecStatisticData = new GJSpecStatisticData();
            var db = new SqlHelper<object>().GetInstance();
            List<string> gjAreaCodes = new List<string>();
            if (model.areaCode == null)
            {
                gjAreaCodes = Settings.getStoreAreaCodes(1, 2);
            }
            else
            {
                gjAreaCodes.Add(model.areaCode);
            }

            int stockNum = db.Queryable<Location>().Where(a => gjAreaCodes.Contains(a.S_AREA_CODE) && a.N_CURRENT_NUM > 0).Count();
            List<GJSpecTypeStatistic> gJSpecStatisticList = db.Queryable<Location>()
            .LeftJoin<LocCntrRel>((l, lc) => l.S_CODE == lc.S_LOC_CODE)
            .LeftJoin<CntrItemRel>((l, lc, ci) => lc.S_CNTR_CODE == ci.S_CNTR_CODE)
            .Where((l, lc, ci) => gjAreaCodes.Contains(l.S_AREA_CODE) && l.N_CURRENT_NUM > 0)
            .GroupBy((l, lc, ci) => ci.S_ITEM_SPEC)
            .Select(
                (l, lc, ci) => new GJSpecTypeStatistic
                {
                    coilSpec = ci.S_ITEM_SPEC,
                    weight = SqlFunc.AggregateSum(ci.F_WEIGHT),
                    proportion = SqlFunc.AggregateCount(l.S_CODE).ToString(),
                }
            ).ToList();
            foreach (var item in gJSpecStatisticList)
            {
                item.proportion = Math.Round(double.Parse(item.proportion) / stockNum * 100, 2) + "%";
            }
            gJSpecStatisticData.dataDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
            gJSpecStatisticData.coilSpecTypeList = gJSpecStatisticList;
            return gJSpecStatisticData;
        }

        /// <summary>
        /// 查询堆垛机状态信息
        /// </summary>
        /// <returns></returns>
        public static List<DDJStatusInfo> getDDJStatusInfos() {
            var ddjPlcInfos = Settings.devicePlcInfos.Where(a => a.deviceType == 1).ToList();
            List<DDJStatusInfo> dDJStatusInfos = new List<DDJStatusInfo>();
            foreach (var item in ddjPlcInfos)
            {
                LogHelper.Info("读取堆垛机 " + item.deviceNo, "数字孪生");
                short[] resSignal1 = S7Helper.ReadInt(item.deviceNo, 551, 0, 8);
                int resSignal2 = S7Helper.ReadDint(item.deviceNo, 551, 16);
                short[] resSignal3 = S7Helper.ReadInt(item.deviceNo, 551, 20, 3);
                LogHelper.Info("读取堆垛机 " + item.deviceNo + " 信号:  resSignal1：" + JsonConvert.SerializeObject(resSignal1) + "  resSignal2(任务号):" + JsonConvert.SerializeObject(resSignal2) + "  resSignal3:" + JsonConvert.SerializeObject(resSignal3), "数字孪生");
                if (resSignal1 != null && resSignal2 != 0 && resSignal3 != null)
                {
                    ResSignalInfo resSignalInfo = new ResSignalInfo()
                    {
                        HandShake = resSignal1[0],
                        SRM_Num = resSignal1[1],
                        Auto = resSignal1[2],
                        Alarm_Code = resSignal1[3],
                        State = resSignal1[4],
                        TaskStatus1 = resSignal1[5],
                        Loaded1 = resSignal1[6],
                        Busines1 = resSignal1[7],
                        TaskId1 = resSignal2,
                        Row = resSignal3[0],
                        Layer = resSignal3[1],
                        b_Fork1Pos = resSignal3[2],
                    };
                    LogHelper.Info("查询堆垛机信息："+ JsonConvert.SerializeObject(resSignalInfo), "数字孪生");

                    // FromWcs（DB550）下发任务数据
                    short[] resSignal = S7Helper.ReadInt(item.deviceNo, 550, 8, 8);
                   
                    DDJStatusInfo info = new DDJStatusInfo()
                    {
                        deviceNo = resSignalInfo.SRM_Num.ToString(),
                        auto = resSignalInfo.Auto.ToString(),
                        status = resSignalInfo.State.ToString(),
                        alertorInfo = resSignalInfo.Alarm_Code.ToString(),
                        Loaded1 = resSignalInfo.Loaded1.ToString(),
                        Busines1 = resSignalInfo.Busines1.ToString(),
                        Row = resSignalInfo.Row.ToString(),
                        Layer = resSignalInfo.Layer.ToString(),
                        b_Fork1Pos = resSignalInfo.b_Fork1Pos.ToString(),
                        TaskId1 = resSignalInfo.TaskId1.ToString(),
                        dataDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
                    };

                    if (resSignal != null)
                    {
                        info.Source_Z_S1 = resSignal[0].ToString();
                        info.Source_X_S1 = resSignal[1].ToString();
                        info.Source_Y_S1 = resSignal[2].ToString();
                        info.Dest_Z_S1 = resSignal[4].ToString();
                        info.Dest_X_S1 = resSignal[5].ToString();
                        info.Dest_Y_S1 = resSignal[6].ToString();
                    }

                    dDJStatusInfos.Add(info);
                }
            }
            return dDJStatusInfos;
        }

        /// <summary>
        /// 查询接驳位物料信息
        /// </summary>
        /// <param name="locCode"></param>
        public static JBItemInfo queryJBItemInfo(string locCode) {
            var db = new SqlHelper<object>().GetInstance();
            var location = LocationHelper.GetLoc(locCode);
            JBItemInfo jBItemInfo = new JBItemInfo()
            {
                locCode = locCode,
                isHave = location.N_CURRENT_NUM > 0 ? "是" : "否",
            };
            var itemInfo  = db.Queryable<LocCntrRel>()
                .LeftJoin<CntrItemRel>((a, b) => a.S_CNTR_CODE == b.S_CNTR_CODE )
                .Where((a,b)=> a.S_LOC_CODE == locCode)
                .GroupBy((a, b) => new { b.S_WORK_NO })
                .Select((a,b) => new
                {
                    workNo = b.S_WORK_NO,
                    weight = SqlFunc.AggregateSum(b.F_WEIGHT),
                })
                .First();
            if (itemInfo != null) {
                jBItemInfo.workNo = itemInfo.workNo;
                jBItemInfo.weight = itemInfo.weight;
            }
            return jBItemInfo;
        }

        /// <summary>
        /// 查询钢卷出入库记录
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public static List<GjOutInStockRecord> queryGjOutInStockRecord(AreaModel model) {
            var db = new SqlHelper<object>().GetInstance();
            var query = db.Queryable<StockRecord>().Where(a => a.S_AREA_CODE == model.areaCode && a.S_ACT_TYPE == model.actType);

            if (model.actType == "出库")
            {
                query = query.Where("(CONVERT(date, T_OUT_TIME) = @date)", new { DateTime.Parse(model.dataDate).Date });
            }
            else if (model.actType == "入库")
            {
                query = query.Where("(CONVERT(date, T_IN_TIME) = @date)", new { DateTime.Parse(model.dataDate).Date });
            }
            return query.Select(a => new GjOutInStockRecord {
                S_CODE = a.S_CODE,
                S_COIL_NO = a.S_COIL_NO,
                S_AREA_CODE = a.S_AREA_CODE,
                S_LOC_CODE = a.S_LOC_CODE,
                S_ACT_TYPE = a.S_ACT_TYPE,
                S_ITEM_CODE = a.S_ITEM_CODE,
                S_ITEM_NAME = a.S_ITEM_NAME,
                S_WORK_NO = a.S_WORK_NO,
                S_WORK_NAME = a.S_WORK_NAME,
                F_WEIGHT = a.F_WEIGHT,
                F_QTY = a.F_QTY,
                T_IN_TIME = a.T_IN_TIME,
                T_OUT_TIME = a.T_OUT_TIME,
            }).ToList();
        }

        /// <summary>
        /// 查询汇总的钢卷重量数据
        /// </summary>
        /// <returns></returns>
        public static ResponseResult querySummaryGJKWeightData() { 
            ResponseResult result = new ResponseResult();
            var db = new SqlHelper<object>().GetInstance();
            var gjAreaCodes = Settings.getStoreAreaCodes(1, 2);
            // 按钢卷号分组查询今日出库的最大钢卷重量（去除剪切位出库）
            var coilWeightSummary = db.Queryable<Location>()
                    .LeftJoin<LocCntrRel>((a, b) => a.S_CODE == b.S_LOC_CODE)
                    .LeftJoin<CntrItemRel>((a, b, c) => b.S_CNTR_CODE == c.S_CNTR_CODE)
                    .Where((a, b, c) => gjAreaCodes.Contains(a.S_AREA_CODE) && a.N_CURRENT_NUM > 0 && c.S_CNTR_CODE != null)
                            .GroupBy((a, b, c) => c.S_WORK_NO)
                            .Select((a, b, c) => new
                            {
                                workNo = c.S_WORK_NO.Trim(),
                                weight = SqlFunc.AggregateMax(c.F_WEIGHT)
                            }).ToList();
            result.result= coilWeightSummary;
            return result;
        }

        public class GjOutInStockRecord
        {
            public string S_CODE { get; set; } //记录编码
            public string S_COIL_NO { get; set; } // 钢卷号
            public string S_AREA_CODE { get; set; } //库区编码
            public string S_LOC_CODE { get; set; } //库位编码
            public string S_ACT_TYPE { get; set; } //行为类型 入库、出库
            public string S_ITEM_CODE { get; set; } //物料编码
            public string S_ITEM_NAME { get; set; } //物料名称
            public string S_WORK_NO { get; set; } //工作号
            public string S_WORK_NAME { get; set; } //工作名称
            public float F_WEIGHT { get; set; } //重量
            public float F_QTY { get; set; } //数量
            public DateTime? T_IN_TIME { get; set; } //入库时间
            public DateTime? T_OUT_TIME { get; set; } // 出库时间
        }


        public class JBItemInfo {
            public string locCode { get; set; }  // 接驳位编码
            public string isHave { get; set; }  // 是否有货 是/否
            public string workNo { get; set; }  // 工作号
            public float weight { get; set; }  // 货物重量

        }

        public class DDJStatusInfo
        {
            public string deviceNo { get; set; }  // 设备号
            public string auto { get; set; }  // 堆垛机当前模式指示  1 联机自动;2手动;3半自动;4维修;
            public string status { get; set; }  //  1：状态正常，允许任务下发
            public string alertorInfo { get; set; }  // 堆垛机报警代码 0:默认;1:正常 ;其他数字故障信息
            public string Loaded1 { get; set; }  // 载货台有无货 1:有货；0:无货
            public string Busines1 { get; set; }   // 工位1特殊业务状态反馈 [1：满入，2.空取，3：放货阻塞，4：取货阻塞]
            public string Row { get; set; }   // 堆垛机当前列（行走方向）
            public string Layer { get; set; }   // 堆垛机当前层（升降方向）
            public string b_Fork1Pos { get; set; }   // 堆垛机货叉1位置 [1：左远，2.左近，3：居中，4：右近，5：右远]
            public string TaskId1 { get; set; }      // 任务号
            public string Source_Z_S1 { get; set; }  // 取货排 1/2/3/4
            public string Source_X_S1 { get; set; }  // 取货列
            public string Source_Y_S1 { get; set; }  // 取货层
            public string Dest_Z_S1 { get; set; }  // 放货排
            public string Dest_X_S1 { get; set; }  // 放货列
            public string Dest_Y_S1 { get; set; } // 放货层
            public string dataDate { get; set; }  // 数据日期
        }


        public class GJSpecStatisticData
        {
            public string dataDate { get; set; }
            public List<GJSpecTypeStatistic> coilSpecTypeList { get; set; }
            public class GJSpecTypeStatistic
            {
                public string coilSpec { get; set; }
                public float weight { get; set; }
                public string proportion { get; set; }
            }
        }
        public class FHQAreaSummaryData
        {
            public int finishProdNum { get; set; }
            public int occupyLocNum { get; set; }
            public int leisureLocNum { get; set; }
        }

        public class MJKAreaSummaryData
        {
            public int stockMouldNum { get; set; }
            public int lendMouldNum { get; set; }
        }

        public class GJKAreaSummaryData
        {
            public string areaCode { get; set; } // 库区编码
            public int stockNum { get; set; } // 在库数量
            public int intactNum { get; set; } // 完整数量
            public int noIntactNum { get; set; } // 非完整数量
            public float consumeWeight { get; set; } // 今日钢卷消耗量
            public string dataDate { get; set; }

        }

        /// <summary>
        /// 模具库货位数据
        /// </summary>
        public class MJKLocationData
        {
            public string areaName { get; set; }
            public string areaCode { get; set; }
            public string areaType { get; set; }
            public string locCode { get; set; }
            public string trayCode { get; set; }
            public string mouldNo { get; set; }

        }

        /// <summary>
        /// 钢卷库货位数据
        /// </summary>
        public class GJKLocationData
        {
            public string areaName { get; set; }
            public string areaCode { get; set; }
            public string areaType { get; set; }
            public string locCode { get; set; }
            public DateTime? inStockTime { get; set; }
            public string itemCode { get; set; }
            public string itemName { get; set; }
            public string itemType { get; set; }
            public string workNo { get; set; }
            public string workName { get; set; }
            public string coilNo { get; set; }
            public string spec { get; set; }
            public string width { get; set; }
            public string heatNo { get; set; }
            public string shootNo { get; set; }
            public float weight { get; set; }
            public float quantity { get; set; }
            public float initWeight { get; set; }
        }

        /// <summary>
        /// 立体库货位数据
        /// </summary>
        public class LTKLocationData
        {
            public string areaName { get; set; }
            public string areaCode { get; set; }
            public string areaType { get; set; }
            public string trayCode { get; set; }
            public string locCode { get; set; }
            public DateTime? inStockTime { get; set; }
            public string itemCode { get; set; }
            public string itemName { get; set; }
            public string itemType { get; set; }
            public string workNo { get; set; }
            public string workName { get; set; }
            public string dePartNo { get; set; }
            public string partDrawNo { get; set; }
            public string partName { get; set; }
            public float weight { get; set; }
            public float quantity { get; set; }
            public string storagDuration { get; set; }
        }

        public class LocModel
        {
            public string areaCode { get; set; }
            public string locCode { get; set; }
        }


        public class AreaLocData
        {
            public string areaCode { get; set; }
            public string areaName { get; set; }
            public object areaData { get; set; }
        }

        public class ProceedTaskData
        {
            public string taskType { get; set; }
            public string prodName { get; set; }
            public float quantity { get; set; }
            public string taskStatus { get; set; }
        }

        public class OutInStockModel
        {
            public string areaCode { get; set; }
            public string dataDate { get; set; }
            public string actType { get; set; }
        }

        public class AreaSummaryData
        {
            public string areaCode { get; set; }
            public string areaName { get; set; }
            public int sum { get; set; }
            public int usageNum { get; set; }
            public string usageRate { get; set; }
            public List<WorkNoSummaryData> workNoSummaryData { get; set; }

        }


        public class WorkNoOutStockData
        {
            public string workNo { get; set; }
            public string workName { get; set; }
            public string dePartNo { get; set; }
            public float quantity { get; set; }
            public float weight { get; set; }
            public float accuQuantity { get; set; } // 累计数量
        }

        public class DateModel
        {
            public string dataDate { get; set; } // 数据日期（yyyy-MM-dd）
        }

        public class ActModel
        {
            public string actType { get; set; } // 类型 入库 出库
            public string dataDate { get; set; } // 数据日期（yyyy-MM-dd）
        }

        public class StorageTimeSummaryData
        {
            public int amountA { get; set; } // 在库时长7日内数量
            public string proportionA { get; set; } // 在库时长7日内占比
            public int amountB { get; set; } // 在库时长8-15日数量
            public string proportionB { get; set; } // 在库时长8-15日占比
            public int amountC { get; set; } // 在库时长16-30日数量
            public string proportionC { get; set; } // 在库时长16-30日占比
            public int amountD { get; set; } // 在库时长30-90日数量
            public string proportionD { get; set; } // 在库时长30-90日占比
            public int amountE { get; set; } // 在库时长91日以上数量
            public string proportionE { get; set; } // 在库时长91日以上占比
            public int sum { get; set; } // 总库位数
            public int usageNum { get; set; } // 使用数
            public string usageRate { get; set; } // 使用率
        }

        public class WorkNoSummaryData
        {
            public string areaCode { get; set; }
            public string areaName { get; set; }
            public string workNo { get; set; }
            public string workName { get; set; }
            public string type { get; set; }
            public float amount { get; set; }
            public string proportion { get; set; }
        }

        public class DrawSummaryData
        {
            public string partDrawNo { get; set; }
            public string partName { get; set; }
            public string workNo { get; set; }
            public float amount { get; set; }
            public string proportion { get; set; }
        }

        public class LTKSummaryData
        {
            public int sum { get; set; }
            public int usageNum { get; set; }
            public string usageRate { get; set; }
            public int finishProdNum { get; set; }
            public string finishProdProp { get; set; }
            public int semiProdNum { get; set; }
            public string semiProdProp { get; set; }
        }


        public class AreaModel
        {
            public string areaCode { get; set; }
            public string dataDate { get; set; }// 数据日期（yyyy-MM-dd）
            public string actType { get; set; }
        }

        public class AreaListModel
        {
            public List<string> areaCodes { get; set; }
            public string dataDate { get; set; } // 数据日期（yyyy-MM-dd）
        }

        public class ItemTypeModel
        {
            public string itemType { get; set; }
        }

        /// <summary>
        /// 成品物料信息
        /// </summary>
        public class BaseItemInfo
        {
            public string areaCode { get; set; }
            public string trayCode { get; set; }
            public string locCode { get; set; }
            public string workNo { get; set; }
            public string workName { get; set; }
            public string dePartNo { get; set; }
            public string partDrawNo { get; set; }
            public string partName { get; set; }
            public string itemCode { get; set; }
            public string itemName { get; set; }
            public float weight { get; set; }
            public float quantity { get; set; }
        }
    }
}