public string GetVipTotal(string pRequest) { //var rp = pRequest.DeserializeJSONTo<APIRequest<EmptyRequestParameter>>(); //var loggingSessionInfo = Default.GetBSLoggingSession(rp.CustomerID, "1"); //var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo; var rp = pRequest.DeserializeJSONTo <APIRequest <EmptyRequestParameter> >(); var loggingSessionInfo = Default.GetBSLoggingSession(rp.CustomerID, rp.UserID); var rd = new GetVipTotalRD(); var vipBll = new VipBLL(loggingSessionInfo); var ds = vipBll.VipLandingPage(loggingSessionInfo.ClientID); if (ds.Tables[0].Rows.Count > 0) { var temp = ds.Tables[0].AsEnumerable().Select(t => new ThatDayAndMonthVipInfo { TodayVipCount = Convert.ToInt32(t["NewMemberCountToday"]),//今天新增vip AddRatioByDay = t["NewMemberPercentByDay"].ToString(), MonthVipCount = Convert.ToInt32(t["NewMemberCountThisMonth"]), AddRatioByMonth = t["NewMemberPercentByMonth"].ToString(), CashOnDeliveryCount = Convert.ToInt32(t["CashOnDeliveryCount"]), OffShelfCount = Convert.ToInt32(t["OffShelfCount"]), OnlineUnitCount = Convert.ToInt32(t["OnlineUnitCount"]), PaidNotSentCount = Convert.ToInt32(t["PaidNotSentCount"]), SentCount = Convert.ToInt32(t["SentCount"]), UpShelfCount = Convert.ToInt32(t["UpShelfCount"]) }).FirstOrDefault(); rd.VipInfo = temp; } if (ds.Tables[1].Rows.Count > 0) { var tmp = ds.Tables[1].AsEnumerable().Select(t => new AttentionVipInfo { Date = Convert.ToDateTime(t["PDate"]).ToShortDateString(),// t["PDate"].ToString(), CumulativeNo = Convert.ToInt32(t["VipNumber"]) }); rd.AttentionVipList = tmp.ToArray(); } //if (ds.Tables[2].Rows.Count > 0) //{ // var eventList = ds.Tables[2].AsEnumerable().Select(t => new EventAnalysisInfo // { // //EventID,Title,EventPeriod,QRCodeVipAmount,SaleAmount,TransferAmount, // //RecommendedAmount,RegisteredAmount,PurchasedAmount // EventId = t["EventID"].ToString(), // Title = t["Title"].ToString(), // EventTime = t["EventPeriod"].ToString(), // DecodeNo = Convert.ToInt32(t["QRCodeVipAmount"]), // VipNo = Convert.ToInt32(t["RegisteredAmount"]), // ForwardingNo = Convert.ToInt32(t["TransferAmount"]), // ForwardingSignNo = Convert.ToInt32(t["RecommendedAmount"]), // SalesVipNo = Convert.ToInt32(t["PurchasedAmount"]), // SalesNo = Convert.ToInt32(t["SaleAmount"]), // }); // rd.EventAnalysisList = eventList.ToArray(); //} var rsp = new SuccessResponse <IAPIResponseData>(rd); return(rsp.ToJSON()); }