public JsonResult FindUseInfo() { StuInfoDBContext stuContext = new StuInfoDBContext(); List <useInfo> stuLis = stuContext.Database.SqlQuery <useInfo>("SELECT * FROM Bas_WS").ToList(); return(Json(stuLis)); }
public JsonResult FindSqlList(string where) { var cache = CacheHelper.GetCache("mydata"); object obj = null; if (cache == null) { StuInfoDBContext stuContext = new StuInfoDBContext(); StringBuilder strSql = new StringBuilder(); StringBuilder whereStr = new StringBuilder(); for (int i = 0; i < where.Split(',').Length; i++) { whereStr.Append(" and a.WSID<>'" + where.Split(',')[i].ToString() + "'"); } strSql.Append(@"select a.AreaName,a.WSID,a.WSName, min(c.onlineDate) as onlineDate, max(c.noLoginWebDay) as noLoginWebDay, max(c.noLoginAppDay) as noLoginAppDay, max(f.RecTimestamp) as RecTimestamp, max(g.VisitDate) as VisitDate, max(h.RecTimeStamp) as OrderDate, datediff(day,max(c.noLoginWebDay),GETDATE()) as noLoginWebDayNums, datediff(day,max(c.noLoginAppDay),GETDATE()) as noLoginAppDayNums, datediff(day,max(f.RecTimestamp),GETDATE()) as noInputFyDayNums, datediff(day,max(g.VisitDate),GETDATE()) as noBfDayNums, datediff(day,max(h.RecTimeStamp),GETDATE()) as noOrderDayNums, max(c.oneWebDay) as oneWebDay, max(c.oneWebWeek) as oneWebWeek, max(c.oneWebMonth) as oneWebMonth, max(c.oneAppDay) as oneAppDay, max(c.oneAppWeek) as oneAppWeek, max(c.oneAppMonth) as oneAppMonth, isnull(i.custCount,0) as custCount, isnull(j.newCustCount,0) as newCustCount, d.userCount, isnull(e.vehCount,0) as vehCount, d.xsdbCount, d.xszgCount, d.xsjlCount, d.xszjCount, d.cxywyCount, d.sjCount, d.qtCount, max(h.orderUserCount) as orderUserCount, max(g.visitUserCount) as visitUserCount from (select t1.WSID,t1.WSName,t1.WSType,t1.IsValid,t3.AreaName+'/'+t2.AreaName as AreaName from Bas_WS t1 left join Bas_Area t2 on t1.AreaCode=t2.AreaCode left join Bas_Area t3 on t2.ParentCode=t3.AreaCode ) a left join (select WSID,UserID from sys_user where left(UserName,5)<>'admin') b on b.WSID=a.WSID left join ( select userid, min(logintime) as onlineDate, max(case when workstation='Mobile APP' then logintime end) as noLoginAppDay, max(case when workstation='DMS WEB' then logintime end) as noLoginWebDay, count(DISTINCT case when workstation='DMS WEB' and logintime >= DATEADD(dd,0, DATEADD(DD, DATEDIFF(DD, 0, GETDATE()), 0)) then Convert(VARCHAR(30),logintime,112) end ) AS oneWebDay, count(DISTINCT case when workstation='DMS WEB' and logintime >= DATEADD(dd,-6, DATEADD(DD, DATEDIFF(DD, 0, GETDATE()), 0)) then Convert(VARCHAR(30),logintime,112) end ) AS oneWebWeek, count(DISTINCT case when workstation='DMS WEB' and logintime >= DATEADD(dd,-29, DATEADD(DD, DATEDIFF(DD, 0, GETDATE()), 0)) then Convert(VARCHAR(30),logintime,112) end ) AS oneWebMonth, count(DISTINCT case when workstation='Mobile APP' and logintime >= DATEADD(dd,0, DATEADD(DD, DATEDIFF(DD, 0, GETDATE()), 0)) then Convert(VARCHAR(30),logintime,112) end ) AS oneAppDay, count(DISTINCT case when workstation='Mobile APP' and logintime >= DATEADD(dd,-6, DATEADD(DD, DATEDIFF(DD, 0, GETDATE()), 0)) then Convert(VARCHAR(30),logintime,112) end ) AS oneAppWeek, count(DISTINCT case when workstation='Mobile APP' and logintime >= DATEADD(dd,-29, DATEADD(DD, DATEDIFF(DD, 0, GETDATE()), 0)) then Convert(VARCHAR(30),logintime,112) end ) AS oneAppMonth from SYS_USERLOG group by userid ) c on b.UserID=c.userid left join ( select wsid, count(UserID) as userCount, count(case when UserType='0001' then UserID end) as xsdbCount, count(case when UserType='0002' then UserID end) as xszgCount, count(case when UserType='0003' then UserID end) as xsjlCount, count(case when UserType='0004' then UserID end) as xszjCount, count(case when UserType='0006' then UserID end) as sjCount, count(case when UserType='0007' then UserID end) as cxywyCount, count(case when isnull(UserType,'')<>'0001' and isnull(UserType,'')<>'0002' and isnull(UserType,'')<>'0003' and isnull(UserType,'')<>'0004' and isnull(UserType,'')<>'0006' and isnull(UserType,'')<>'0007' then UserID end) as qtCount from sys_user where isnull(IsValid,1)=1 and left(UserName,5)<>'admin' group by wsid ) d on a.wsid=d.wsid left join (select WSID,count(VehID) as vehCount from Bas_Vehicle where isnull(IsValid,1)=1 and isnull(GpsID,'')<>'' group by WSID) e on a.WSID=e.WSID left join (select WSID,max(RecTimestamp) as RecTimestamp from view_TMS_Car_Cost group by WSID) f on a.WSID=f.WSID left join ( select WSID, count(distinct case when RecTimeStamp >= DATEADD(dd,-30, DATEADD(DD, DATEDIFF(DD, 0, GETDATE()), 0)) then UserID end) as visitUserCount, max(VisitDate) as VisitDate from SFA_Visit group by WSID ) g on a.WSID=g.WSID left join ( select WSID, count(distinct case when (SaleSourceID=4 or SaleSourceID=5) and RecTimeStamp >= DATEADD(dd,-30, DATEADD(DD, DATEDIFF(DD, 0, GETDATE()), 0)) then RecUserID end) as orderUserCount, max(RecTimeStamp) as RecTimeStamp from SFA_Order_Header group by WSID ) h on a.WSID=h.WSID left join (select WSID,count(CustomerID) as custCount from Bas_Customer group by WSID) i on i.WSID=a.WSID left join (select WSID,count(CustomerID) as newCustCount from Bas_NewCustomer where AuditStatus=0 group by WSID) j on j.WSID=a.WSID where a.WSType=1 and isnull(a.IsValid,1)=1 and d.userCount is not null {0} group by a.AreaName,a.WSID,a.WSName,e.vehCount,d.userCount,d.xsdbCount,d.xszgCount,d.xsjlCount,d.xszjCount,d.cxywyCount,d.sjCount,d.qtCount,i.custCount,j.newCustCount order by oneWebMonth desc"); string str = String.Format(strSql.ToString(), whereStr.ToString()); var userLis = stuContext.Database.SqlQuery <useInfo>(str).ToList(); var totalWsCount = userLis.Count <useInfo>(); var totalUserCount = userLis.Sum <useInfo>(t => t.userCount); var totalVehCount = userLis.Sum <useInfo>(t => t.vehCount); strSql.Clear(); strSql.Append(@"select c.ApplicationType,count(distinct a.UserID) as moduleCount from sys_User a left join Sys_user_role b on a.UserID=b.UserID inner join ( select r1.RoleID,r1.ModuleID,r3.ApplicationType from Sys_RoleRight r1 inner join Sys_Role r2 on r1.RoleID=r2.RoleID inner join (select ModuleID,ApplicationType,ModuleName from Sys_Module) r3 on r1.ModuleID=r3.ModuleID where isnull(r2.IsValid,1)=1 and (len(r1.ModuleID)=2 or left(r1.ModuleID,2)='53')and r3.ApplicationType is not null and r3.ApplicationType<>'9' and r3.ApplicationType<>'0' ) c on c.RoleID=a.RoleID inner join (select WSID,WSName,WSType,IsValid from Bas_WS) d on a.WSID=d.WSID where d.WSType=1 and isnull(d.IsValid,1)=1 and left(a.UserName,5)<>'admin' {0} group by c.ApplicationType order by moduleCount desc"); str = String.Format(strSql.ToString(), whereStr.ToString()); var moduleLis = stuContext.Database.SqlQuery <moduleInfo>(str).ToList(); obj = new { rows = userLis, totalWsCount = totalWsCount, totalUserCount = totalUserCount, totalVehCount = totalVehCount, moduleLis = moduleLis }; //插入cache 缓存12小时 double tt = 12 * 60 * 60; CacheHelper.SetCache("mydata", obj, DateTime.Now.AddSeconds(tt), TimeSpan.Zero); } else { obj = (object)cache; } return(Json(obj)); }
private string GetEmailData(bool IsSend) { var hour = Convert.ToInt16(Request.QueryString["hour"] == null ? "0" : Request.QueryString["hour"].ToString()); if ((DateTime.Now.Hour == hour && DateTime.Now.Hour != 0) || IsSend == false) { try { string toMails = ConfigurationManager.AppSettings["toMails"].ToString(); string smtpEmail = ConfigurationManager.AppSettings["smtpEmail"].ToString(); string fromEmail = ConfigurationManager.AppSettings["fromEmail"].ToString(); string fromEmailPassword = ConfigurationManager.AppSettings["fromEmailPassword"].ToString(); EmailParameterSet model = new EmailParameterSet(); model.SendEmail = fromEmail; model.SendPwd = fromEmailPassword; //密码 model.SendSetSmtp = smtpEmail; //发送的SMTP服务地址 ,每个邮箱的是不一样的。。根据发件人的邮箱来定 model.ConsigneeAddress = toMails; model.ConsigneeTheme = "EPM-U+经销商使用情况"; model.ConsigneeHand = "实施部门"; model.ConsigneeName = "邹智勇"; string thStr = @"<th style='width:50px;'>序号</th> <th style='width:60px;'>经销商ID</th> <th style='width:250px;'>经销商名称</th> <th style='width:55px;'>客户数量</th> <th style='width:48px;'>采购订单数量</th> <th style='width:60px;'>采购退货单数量</th> <th style='width:55px;'>销售订单<br>(未发货)</th> <th style='width:100px;'>销售订单数量<br>(有发货)</th> <th style='width:55px;'>销售退货单数量</th> <th style='width:75px;'>上线日期</th> <th style='width:100px;'>状态</th> <th style='width:48px;'>顾问负责人</th> <th style='width:200px;'>顾问邮箱</th> <th style='width:85px;'>顾问手机号</th>"; string labelStr = @"<div style=""font-family:'Microsoft Yahei';font-size:12px;text-align:left;"">当天订单数量如下:</div>"; string strStyle = @"<style>table{border-collapse:collapse;font-family:'Microsoft Yahei';font-size:12px;}table,th,td{border:1px solid #eee;}th{text-align:center;}th,td{padding:3px;} thead{background-color:#350a4d;color:#fff;}tr:nth-child(even){background-color:#eaf1fb;}</style>"; string headStr = @"<div style=""width:100%;overflow-x:auto""> <table style=""width:1241px;""> <thead> <tr> {0} </tr> </thead> </table> </div>"; headStr = String.Format(headStr.ToString(), thStr); string bodyStr = @"<div style=""width:100%;overflow-x:auto""> <table style=""width:1241px;""> <thead> <tr> {0} </tr> </thead> <tbody> {1} </tbody> </table> </div>"; TestDBContext testContext = new TestDBContext(); var wsList = testContext.Database.SqlQuery <wsinfo>(@"SELECT a.wsid as wsid, a.WSCompany as WSCompany, CONVERT(varchar(100), a.goLiveDate, 23) goLiveDate, a.wsname as wsname, b.T_Name as gwname1, b.T_Email as gwemail1, b.T_Mobile as gwmobile1, c.T_Name as gwname2, c.T_Email as gwemail2, c.T_Mobile as gwmobile2, d.name as status from t_ws a left join T_ImplementPersonnel b on a.Personnel1 = b.T_Id and ISNULL(a.IsValid, 1) = 1 left join T_ImplementPersonnel c on a.Personnel2 = c.T_Id and ISNULL(a.IsValid, 1) = 1 left join t_status d on a.status=d.id" ); List <string> list = new List <string>(); foreach (var item in wsList) { list.Add(item.wsid); } var where = string.Join(", ", list.ToArray()); StringBuilder whereStr = new StringBuilder(); whereStr.Append(where); StringBuilder strSql = new StringBuilder(); strSql.Append(@" SELECT wsid as wsid, WSName as wsname, (select count(0) from Bas_Customer where a.WSID=WSID and isnull(isvalid,1)=1) as custsl, (select count(0) from DMS_pur_bill where a.WSID=WSID and PurType='41' and DateDiff(dd,purdate,getdate())=0 and status>1) as cgddsl, (select count(0) from DMS_pur_bill where a.WSID=WSID and PurType='43' and DateDiff(dd,purdate,getdate())=0 and status>1) as cgddsl, (select count(0) from SFA_Order_Header where a.WSID=WSID and OrderType='51' and DateDiff(dd,OrderDate,getdate())=0 and (status=1 or status=2)) as xsddwfh, (select count(0) from SFA_Order_Header where a.WSID=WSID and OrderType='51' and DateDiff(dd,OrderDate,getdate())=0 and (status=3 or status=4)) as xsddsl, (select count(0) from SFA_Order_Header where a.WSID=WSID and OrderType='53' and DateDiff(dd,OrderDate,getdate())=0 and (status=3 or status=4)) as xsthsl FROM Bas_WS a where a.wsid in ({0}) "); string str = String.Format(strSql.ToString(), whereStr.ToString()); StuInfoDBContext stuContext = new StuInfoDBContext(); var wsinfoTemp = stuContext.Database.SqlQuery <wsinfo>(str).ToList(); //将上线日期赋值后再排序 foreach (var item in wsinfoTemp) { var wsItem = wsList.Where(w => w.wsid == item.wsid).FirstOrDefault(); item.goLiveDate = (wsItem != null ? wsItem.goLiveDate : ""); } var wsinfo = wsinfoTemp.OrderBy(t => t.goLiveDate).ToList(); //生成表格内容 StringBuilder tempStr = new StringBuilder(); for (int i = 0; i < wsinfo.Count; i++) { var wsItem = wsList.Where(w => w.wsid == wsinfo[i].wsid).FirstOrDefault(); string _str = @"<tr> <td style='text-align:center;'>{0}</td> <td style='text-align:left;'>{1}</td> <td style='text-align:left;'>{2}</td> <td style='text-align:center;'>{3}</td> <td style='text-align:center;'>{4}</td> <td style='text-align:center;'>{5}</td> <td style='text-align:center;background-color:#d9d9d8;'>{6}</td> <td style='text-align:center;background-color:{8};color:#fff;'>{7}</td> <td style='text-align:center;'>{9}</td> <td style='text-align:left;'>{10}</td> <td style='text-align:left;'>{11}</td> <td style='text-align:left;'>{12}</td> <td style='text-align:left;'>{13}</td> <td style='text-align:left;'>{14}</td> </tr>"; string wsid = wsinfo[i].wsid; string wsname = wsList.Where(w => w.WSCompany == wsItem.WSCompany).Count() > 1? wsinfo[i].wsname + "<br>【" + wsItem.WSCompany + "】" : wsinfo[i].wsname; string custsl = wsinfo[i].custsl == 0 ? "" : wsinfo[i].custsl.ToString(); string cgddsl = wsinfo[i].cgddsl == 0 ? "" : wsinfo[i].cgddsl.ToString(); string cgthsl = wsinfo[i].cgthsl == 0 ? "" : wsinfo[i].cgthsl.ToString(); string xsddwfh = wsinfo[i].xsddwfh == 0 ? "" : wsinfo[i].xsddwfh.ToString(); string xsddsl = wsinfo[i].xsddsl == 0 ? "" : wsinfo[i].xsddsl.ToString(); string xsthsl = wsinfo[i].xsthsl == 0 ? "" : wsinfo[i].xsthsl.ToString(); string bgcolor = wsinfo[i].xsddsl == 0 ? "red" : "#1d6c09"; string goLiveDate = (wsItem != null ? wsItem.goLiveDate : ""); string status = (wsItem != null ? wsItem.status : ""); string gwname1 = (wsItem != null ? wsItem.gwname1 : ""); string gwemail1 = (wsItem != null ? wsItem.gwemail1 : ""); string gwmobile1 = (wsItem != null ? wsItem.gwmobile1 : ""); string gwname2 = (wsItem != null ? wsItem.gwname2 : ""); string gwemail2 = (wsItem != null ? wsItem.gwemail2 : ""); string gwmobile2 = (wsItem != null ? wsItem.gwmobile2 : ""); string temp = String.Format(_str.ToString(), i + 1, wsid, wsname, custsl, cgddsl, cgthsl, xsddwfh, xsddsl, bgcolor, xsthsl, goLiveDate, status, gwname1 + "<br>" + gwname2, gwemail1 + "<br>" + gwemail2, gwmobile1 + "<br>" + gwmobile2); tempStr.Append(temp); } StringBuilder sqlQueryStr = new StringBuilder(); sqlQueryStr.Append(strStyle); sqlQueryStr.Append(labelStr); //sqlQueryStr.Append(headStr); bodyStr = String.Format(bodyStr.ToString(), thStr, tempStr); sqlQueryStr.Append(bodyStr); //是否发送 if (IsSend == true) { model.SendContent = sqlQueryStr.ToString(); MailSend(model, true); } return(sqlQueryStr.ToString()); } catch (Exception ex) { return(ex.Message); } } else { return(null); } }
public object findWsInfo() { StuInfoDBContext stuContext = new StuInfoDBContext(); TestDBContext testContext = new TestDBContext(); var wsList = testContext.T_WS.Where(t => t.IsValid != 0).OrderByDescending(o => new { o.City, o.WSCompany, o.goLiveDate }).ToList(); var implementItemList = testContext.T_ImplementPersonnel.Where(t => t.IsValid != 0).ToList(); var statusItemList = testContext.T_Status.Where(t => 1 == 1).ToList(); foreach (var item in wsList) { var implementItem1 = implementItemList.Where(t => t.T_Id == item.Personnel1).FirstOrDefault(); var implementItem2 = implementItemList.Where(t => t.T_Id == item.Personnel2).FirstOrDefault(); var statusItem = statusItemList.Where(t => t.Id == item.status).FirstOrDefault(); item.Personnel1Name = implementItem1 == null ? "" : implementItem1.T_Name; item.Personnel1Email = implementItem1 == null ? "" : implementItem1.T_Email; item.Personnel1Mobile = implementItem1 == null ? "" : implementItem1.T_Mobile; item.Personnel2Name = implementItem2 == null ? "" : implementItem2.T_Name; item.Personnel2Email = implementItem2 == null ? "" : implementItem2.T_Email; item.Personnel2Mobile = implementItem2 == null ? "" : implementItem2.T_Mobile; item.statusName = statusItem == null ? "" : statusItem.name; item.sszStatus = item.researchBeginDate.Value.CompareTo(Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))) <= 0 && item.goLiveDate.Value.CompareTo(Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))) > 0 ? 1 : 0; item.ysxStatus = item.goLiveDate.Value.CompareTo(Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))) <= 0 ? 1 : 0; item.wsxStatus = item.goLiveDate.Value.CompareTo(Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))) > 0 ? 1 : 0; item.planStatus = 1; ////获取工作日 //if(DateTime.Now.ToString("yyyy-MM")== item.goLiveDate.Value.ToString("yyyy-MM")) //{ // string str1 = DateTime.Now.ToString("yyyy-MM-dd"); // string str2 = item.goLiveDate.Value.ToString("yyyy-MM-dd"); // DateTime d1 = Convert.ToDateTime(str1); // DateTime d2 = Convert.ToDateTime(str2); // DateTime d3 = Convert.ToDateTime(string.Format("{0}-{1}-{2}", d1.Year, d1.Month, d1.Day)); // DateTime d4 = Convert.ToDateTime(string.Format("{0}-{1}-{2}", d2.Year, d2.Month, d2.Day)); // int days = (d3 - d4).Days; // item.gzrCount = days; //}else //{ // item.gzrCount = 30; //} } var sszWsNumber = wsList.Where(t => t.researchBeginDate.Value.CompareTo(Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))) <= 0 && t.goLiveDate.Value.CompareTo(Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))) > 0).Count(); var ysxWsNumber = wsList.Where(t => t.goLiveDate.Value.CompareTo(Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))) <= 0).Count(); var wsxWsNumber = wsList.Where(t => t.goLiveDate.Value.CompareTo(Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))) > 0).Count(); var planWsNumber = wsList.Count(); //获取正式库销量数据 StringBuilder strSql = new StringBuilder(); strSql.Append(@" select a.WSID, b.WSName, (select count(0) from Bas_Customer where isnull(isvalid,1)=1 and wsid=a.wsid) as custCount, count(distinct case when convert(varchar(6),a.OrderDate,112)='{1}01'then CONVERT(char(10),a.OrderDate,120) end) as xsCount1, count(distinct case when convert(varchar(6),a.OrderDate,112)='{1}02'then CONVERT(char(10),a.OrderDate,120) end) as xsCount2, count(distinct case when convert(varchar(6),a.OrderDate,112)='{1}03'then CONVERT(char(10),a.OrderDate,120) end) as xsCount3, count(distinct case when convert(varchar(6),a.OrderDate,112)='{1}04'then CONVERT(char(10),a.OrderDate,120) end) as xsCount4, count(distinct case when convert(varchar(6),a.OrderDate,112)='{1}05'then CONVERT(char(10),a.OrderDate,120) end) as xsCount5, count(distinct case when convert(varchar(6),a.OrderDate,112)='{1}06'then CONVERT(char(10),a.OrderDate,120) end) as xsCount6, count(distinct case when convert(varchar(6),a.OrderDate,112)='{1}07'then CONVERT(char(10),a.OrderDate,120) end) as xsCount7, count(distinct case when convert(varchar(6),a.OrderDate,112)='{1}08'then CONVERT(char(10),a.OrderDate,120) end) as xsCount8, count(distinct case when convert(varchar(6),a.OrderDate,112)='{1}09'then CONVERT(char(10),a.OrderDate,120) end) as xsCount9, count(distinct case when convert(varchar(6),a.OrderDate,112)='{1}10'then CONVERT(char(10),a.OrderDate,120) end) as xsCount10, count(distinct case when convert(varchar(6),a.OrderDate,112)='{1}11'then CONVERT(char(10),a.OrderDate,120) end) as xsCount11, count(distinct case when convert(varchar(6),a.OrderDate,112)='{1}12'then CONVERT(char(10),a.OrderDate,120) end) as xsCount12 from SFA_Order_Header a left join Bas_WS b on a.WSID=b.WSID and isnull(b.isvalid,1)=1 where a.OrderType='51' and (a.status=3 or a.status=4) and a.wsid in ({0}) group by a.WSID,b.WSName "); List <string> list = new List <string>(); foreach (var item in wsList) { list.Add(item.WSID); } var whereStr = string.Join(",", list.ToArray()); string str = String.Format(strSql.ToString(), whereStr.ToString(), DateTime.Now.ToString("yyyy")); var wsinfoTemp = stuContext.Database.SqlQuery <T_WS>(str).ToList(); foreach (var item in wsList) { var wsItem = wsinfoTemp.Where(w => w.WSID == item.WSID).FirstOrDefault(); if (wsItem != null) { item.WSName = wsItem.WSName; item.custCount = wsItem.custCount; item.xsCount1Name = wsItem.xsCount1 == 0 || item.goLiveDate.Value.Month > 1 ? "-" : wsItem.xsCount1.ToString() + " / " + getDays(item.goLiveDate, 1); item.xsCount2Name = wsItem.xsCount2 == 0 || item.goLiveDate.Value.Month > 2 ? "-" : wsItem.xsCount2.ToString() + " / " + getDays(item.goLiveDate, 2); item.xsCount3Name = wsItem.xsCount3 == 0 || item.goLiveDate.Value.Month > 3 ? "-" : wsItem.xsCount3.ToString() + " / " + getDays(item.goLiveDate, 3); item.xsCount4Name = wsItem.xsCount4 == 0 || item.goLiveDate.Value.Month > 4 ? "-" : wsItem.xsCount4.ToString() + " / " + getDays(item.goLiveDate, 4); item.xsCount5Name = wsItem.xsCount5 == 0 || item.goLiveDate.Value.Month > 5 ? "-" : wsItem.xsCount5.ToString() + " / " + getDays(item.goLiveDate, 5); item.xsCount6Name = wsItem.xsCount6 == 0 || item.goLiveDate.Value.Month > 6 ? "-" : wsItem.xsCount6.ToString() + " / " + getDays(item.goLiveDate, 6); item.xsCount7Name = wsItem.xsCount7 == 0 || item.goLiveDate.Value.Month > 7 ? "-" : wsItem.xsCount7.ToString() + " / " + getDays(item.goLiveDate, 7); item.xsCount8Name = wsItem.xsCount8 == 0 || item.goLiveDate.Value.Month > 8 ? "-" : wsItem.xsCount8.ToString() + " / " + getDays(item.goLiveDate, 8); item.xsCount9Name = wsItem.xsCount9 == 0 || item.goLiveDate.Value.Month > 9 ? "-" : wsItem.xsCount9.ToString() + " / " + getDays(item.goLiveDate, 9); item.xsCount10Name = wsItem.xsCount10 == 0 || item.goLiveDate.Value.Month > 10 ? "-" : wsItem.xsCount10.ToString() + " / " + getDays(item.goLiveDate, 10); item.xsCount11Name = wsItem.xsCount11 == 0 || item.goLiveDate.Value.Month > 11 ? "-" : wsItem.xsCount11.ToString() + " / " + getDays(item.goLiveDate, 11); item.xsCount12Name = wsItem.xsCount12 == 0 || item.goLiveDate.Value.Month > 12 ? "-" : wsItem.xsCount12.ToString() + " / " + getDays(item.goLiveDate, 12); } } var obj = new { rows = wsList, sszWsNumber = sszWsNumber, ysxWsNumber = ysxWsNumber, wsxWsNumber = wsxWsNumber, planWsNumber = planWsNumber }; return(Json(obj)); }