private void ShowChart(DateTime start, DateTime end)
{
//两个时间差
if (start > end)
{
Page.RegisterStartupScript("error", "<script>alert('时间选择有误!');</script>");
return;
}
TaoBaoGoodsOrderService tboDal = new TaoBaoGoodsOrderService();
IList <PingJiaInfo> list = tboDal.GetPingjiaTotal(start, end, HttpUtility.UrlDecode(Request.Cookies["nick"].Value));
SeriseText = "[{name:'好评', data:[";
string zhong = ",{name:'中评',data:[";
string cha = ",{name:'差评',data:[";
string nop = ",{name:'尚未评价',data:[";
DateText = "[";
for (DateTime i = start; i <= end; i = i.AddDays(1))
{
DateText += "'" + i.ToString("yyyyMMdd").Substring(6, 2) + "',";
IList <PingJiaInfo> mylist = list.Where(o => o.pdate == i.ToString("yyyyMMdd")).ToList();
if (mylist.Count > 0)
{
if (mylist.Where(o => o.result == "good").ToList().Count > 0)
{
SeriseText += mylist.Where(o => o.result == "good").ToList()[0].pcount + ",";
}
else
{
SeriseText += "0,";
}
if (mylist.Where(o => o.result == "neutral").ToList().Count > 0)
{
zhong += mylist.Where(o => o.result == "neutral").ToList()[0].pcount + ",";
}
else
{
zhong += "0,";
}
if (mylist.Where(o => o.result == "bad").ToList().Count > 0)
{
cha += mylist.Where(o => o.result == "bad").ToList()[0].pcount + ",";
}
else
{
cha += "0,";
}
if (mylist.Where(o => o.result == "").ToList().Count > 0)
{
nop += mylist.Where(o => o.result == "").ToList()[0].pcount + ",";
}
else
{
nop += "0,";
}
}
else
{
zhong += "0,";
SeriseText += "0,";
cha += "0,";
nop += "0,";
}
}
SeriseText = SeriseText.Substring(0, SeriseText.Length - 1);
SeriseText += "]}";
zhong = zhong.Substring(0, zhong.Length - 1);
zhong += "]}";
cha = zhong + cha.Substring(0, cha.Length - 1);
cha += "]}";
nop = cha + nop.Substring(0, nop.Length - 1);
SeriseText += nop + "]}]";
DateText = DateText.Substring(0, DateText.Length - 1);
DateText += "]";
TB_Start.Text = start.ToString("yyyy-MM-dd");
TB_End.Text = end.ToString("yyyy-MM-dd");
}
