Example #1
0
        /// <summary>
        /// 根据flowchart masteruid 查询计划数据
        /// </summary>
        /// <param name="masterUID"></param>
        /// <returns></returns>
        public PagedListModel <FlPlanManagerVM> QueryProcessMGData(int masterUID, DateTime date)
        {
            var totalCount = 0;

            var flChartList = flowChartMasterRepository.QueryFlowMGData(masterUID, date, out totalCount);
            var result      = new List <FlPlanManagerVM>();

            foreach (var item in flChartList)
            {
                var returnItem = new FlPlanManagerVM();
                returnItem.Detail_UID         = item.Detail_UID;
                returnItem.Process_seq        = item.Process_seq;
                returnItem.Process            = item.Process;
                returnItem.Place              = item.Place;
                returnItem.date               = item.date;
                returnItem.Color              = item.Color;
                returnItem.MondayProduct_Plan = item.MondayProduct_Plan;
                if (item.MondayTarget_Yield != null)
                {
                    returnItem.MondayTarget_Yield = item.MondayTarget_Yield * 100 + "%";
                }
                returnItem.MondayProper_WIP    = item.MondayProper_WIP;
                returnItem.TuesdayProduct_Plan = item.TuesdayProduct_Plan;
                if (item.TuesdayTarget_Yield != null)
                {
                    returnItem.TuesdayTarget_Yield = item.TuesdayTarget_Yield * 100 + "%";
                }
                returnItem.TuesdayProper_WIP     = item.TuesdayProper_WIP;
                returnItem.WednesdayProduct_Plan = item.WednesdayProduct_Plan;
                if (item.WednesdayTarget_Yield != null)
                {
                    returnItem.WednesdayTarget_Yield = item.WednesdayTarget_Yield * 100 + "%";
                }
                returnItem.WednesdayProper_WIP  = item.WednesdayProper_WIP;
                returnItem.ThursdayProduct_Plan = item.ThursdayProduct_Plan;
                if (item.ThursdayTarget_Yield != null)
                {
                    returnItem.ThursdayTarget_Yield = item.ThursdayTarget_Yield * 100 + "%";
                }
                returnItem.ThursdayProper_WIP = item.ThursdayProper_WIP;
                returnItem.FridayProduct_Plan = item.FridayProduct_Plan;
                if (item.FridayTarget_Yield != null)
                {
                    returnItem.FridayTarget_Yield = item.FridayTarget_Yield * 100 + "%";
                }
                returnItem.FridayProper_WIP     = item.FridayProper_WIP;
                returnItem.SaterdayProduct_Plan = item.SaterdayProduct_Plan;
                if (item.SaterdayTarget_Yield != null)
                {
                    returnItem.SaterdayTarget_Yield = item.SaterdayTarget_Yield * 100 + "%";
                }
                returnItem.SaterdayProper_WIP = item.SaterdayProper_WIP;

                returnItem.SundayProduct_Plan = item.SundayProduct_Plan;
                if (item.SundayTarget_Yield != null)
                {
                    returnItem.SundayTarget_Yield = item.SundayTarget_Yield * 100 + "%";
                }
                returnItem.SundayProper_WIP = item.SundayProper_WIP;
                result.Add(returnItem);
            }

            return(new PagedListModel <FlPlanManagerVM>(totalCount, result));
        }