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("[]");
}
}
