public WarnTips GetMaterialDelayCount() { WarnTips wt = new WarnTips(); wt.TipsCountList = new List <TipsCount>(); string allowFactoryIDs = new TaskWarn().GetAllowedFactory(); if (string.IsNullOrEmpty(allowFactoryIDs)) { return(null); } int ottoffset = AMOData.Settings.SysSetting.PoOTTOffset; System.Data.SqlClient.SqlParameter[] parameters = { new System.Data.SqlClient.SqlParameter("@p_factoryids", allowFactoryIDs), new System.Data.SqlClient.SqlParameter("@p_ottoffset", ottoffset), new System.Data.SqlClient.SqlParameter("@p_currentdate", DateTime.Now) }; wt.TipsCountList = this.db.Database.SqlQuery <TipsCount>("exec app_main_mat_delay @p_factoryids,@p_ottoffset,@p_currentdate ", parameters).ToList(); return(wt); }
public WarnTips GetProcessDelayCount() { WarnTips wt = new WarnTips(); //var ls = this.db.Database.SqlQuery<TipsCount>("exec app_main_ProcessDelayCount").ToList(); var ls = db.PROCESSes.Select(p => new TipsCount() { Id = p.ID, Name = p.NAME, Amount = db.Processdailydata_ext.Count(c => c.Processid == p.ID && c.Type == 2 && (c.Troubletype == 2 || c.Troubletype == 3) && c.Processdate.Value == db.Processdailydata_ext.OrderByDescending(d => d.Processdate).FirstOrDefault().Processdate) }).OrderBy(c => c.Id).ToList(); if (ls != null) { wt.TipsCountList = ls.Where(c => c.Amount > 0).ToList(); } else { ls = new List <TipsCount>(); } return(wt); //wt.TipsCountList.Add(new TipsCount() { Id = 1, Name = "裁剪", Count = 9 }); //wt.TipsCountList.Add(new TipsCount() { Id = 2, Name = "装篮", Count = 14 }); //wt.TipsCountList.Add(new TipsCount() { Id = 3, Name = "钉纽", Count = 23 }); //wt.TipsCountList.Add(new TipsCount() { Id = 4, Name = "车缝", Count = 8 }); //wt.TipsCountList.Add(new TipsCount() { Id = 5, Name = "包装", Count = 21 }); //wt.TipsCountList.Add(new TipsCount() { Id = 6, Name = "入库", Count = 27 }); //return wt; }
public WarnTips GetEventsDelayCount() { WarnTips wt = new WarnTips(); var ls = this.db.Database.SqlQuery <TipsCount>("exec app_main_EventDelayCount").ToList(); wt.TipsCountList = ls.Where(c => c.Amount > 0).ToList(); //wt.TipsCountList.Add(new TipsCount() { Id = 1, Name = "PP办", Amount = 19 }); //wt.TipsCountList.Add(new TipsCount() { Id = 2, Name = "工艺制单", Amount = 4 }); //wt.TipsCountList.Add(new TipsCount() { Id = 3, Name = "纸样", Amount = 16 }); //wt.TipsCountList.Add(new TipsCount() { Id = 4, Name = "排麦架", Amount = 18 }); return(wt); }
public WarnTips GetDeliveryDelayCount() { WarnTips wt = new WarnTips(); string allowFactoryIDs = GetAllowedFactory(); if (string.IsNullOrEmpty(allowFactoryIDs)) { return(wt); } int jobAlertDays = AMOData.Settings.SysSetting.JA_JobAlertDays; System.Data.SqlClient.SqlParameter[] parameters = { new System.Data.SqlClient.SqlParameter("@p_factoryids", allowFactoryIDs), new System.Data.SqlClient.SqlParameter("@p_jobalertdays", jobAlertDays), new System.Data.SqlClient.SqlParameter("@p_currentdate", DateTime.Now.Date) }; wt.TipsCountList = this.db.Database.SqlQuery <ViewModels.TipsCount>("exec app_poDelivery_delay @p_factoryids,@p_jobalertdays,@p_currentdate ", parameters).ToList(); if (wt.TipsCountList == null) { wt.TipsCountList = new List <TipsCount>(); } if (!wt.TipsCountList.Exists(c => c.Id == 6)) { wt.TipsCountList.Add(new TipsCount() { Id = 6, Name = "", Amount = 0 }); } if (!wt.TipsCountList.Exists(c => c.Id == 8)) { wt.TipsCountList.Add(new TipsCount() { Id = 8, Name = "", Amount = 0 }); } if (!wt.TipsCountList.Exists(c => c.Id == 10)) { wt.TipsCountList.Add(new TipsCount() { Id = 10, Name = "", Amount = 0 }); } wt.TipsCountList = wt.TipsCountList.OrderBy(c => c.Id).ToList(); return(wt); }
public WarnTips GetTodayCount() { WarnTips wt = new WarnTips(); wt.TipsCountList = new List <TipsCount>(); wt.TipsCountList.Add(new TipsCount() { Id = 1, Name = "关键事件", Amount = 18 }); wt.TipsCountList.Add(new TipsCount() { Id = 2, Name = "生产", Amount = 23 }); wt.TipsCountList.Add(new TipsCount() { Id = 3, Name = "物料采购", Amount = 52 }); return(wt); }