public static void AddVisit(string page, VisitChannel channel) { if (string.IsNullOrEmpty(page)) { return; } HlidacStatu.Lib.DirectDB.NoResult("AddVisit", System.Data.CommandType.StoredProcedure, new System.Data.SqlClient.SqlParameter("@page", page.ToLower()), new System.Data.SqlClient.SqlParameter("@date", DateTime.Now.Date), new System.Data.SqlClient.SqlParameter("@channel", (int)channel) ); }
public static string SetChartData(Dictionary <string, List <dynamic> > DataDic, DateTime begTime, DateTime endTime) { begTime = begTime.Date; endTime = endTime.Date; ServiceStatModel chartModel = new ServiceStatModel(); if (DataDic != null) { DateTime nowDay = DateTime.Now.Date; DateTime dayDate = new DateTime(1890, 1, 1); dayDate = begTime; while (dayDate <= endTime) { int newUsrCount = 0; int oldUsrCount = 0; VisitUserType dList = new VisitUserType(); dList.XLable = dayDate.ToString("yyyy-MM-dd"); List <dynamic> list = DataDic["UsrPer"].Where(x => x.insertTime.ToString() == dayDate.ToString("yyyy-MM-dd")).ToList(); foreach (dynamic dr in list) { if (dr.regTime != DateTime.MinValue) { DateTime dt = Convert.ToDateTime(dr.regTime); if (dt.Year == dayDate.Year && dt.Month == dayDate.Month) { newUsrCount++; } else { oldUsrCount++; } } } dList.date = dayDate; dList.newUsr = newUsrCount; dList.oldUsr = oldUsrCount; if (dList.date != DateTime.Now.Date) { chartModel.usrList.Add(dList); } dayDate = dayDate.AddDays(1); } //客服人员 foreach (dynamic dr in DataDic["ServPer"]) { if (dr.insertName != null) { ServPerson sp = new ServPerson(); sp.key = dr.insertName.ToString(); sp.value = Convert.ToInt32(dr.cnt); chartModel.servPersonPer.Add(sp); } } //渠道 foreach (dynamic dr in DataDic["ChannelPer"]) { if (dr.vm_name != null) { if (dr.vm_name.ToString() != "") { VisitChannel vc = new VisitChannel(); vc.key = dr.vm_name.ToString(); vc.value = Convert.ToInt32(dr.cnt); chartModel.channelPer.Add(vc); } } } return(CommonLib.Helper.JsonSerializeObject(chartModel)); } else { return("[]"); } }