// GET: Pin/TongJi public ActionResult Index(string act = "", int aId = 0, DateTime?q_begin_time = null, DateTime?q_end_time = null) { PinGoodsOrderBLL goodsOrderBLL = new PinGoodsOrderBLL(); string sql = $"SELECT sum(money) as money,DATE_FORMAT(addtime,'%Y-%m-%d') as addtime from pingoodsorder where state>0 and ordertype=0 and aid={aId} "; string whereSql = ""; string groupSql = "group by DATE_FORMAT(addtime,'%Y-%m-%d') order by DATE_FORMAT(addtime,'%Y-%m-%d') desc"; if (act == "7day") { sql = sql + groupSql + " limit 7 "; } else if (act == "30day") { sql = sql + groupSql + " limit 30 "; } else { if (q_end_time > q_begin_time) { whereSql = $" and addtime BETWEEN '{q_begin_time?.ToString("yyyy-MM-dd")} 00:00:00' and '{q_end_time?.ToString("yyyy-MM-dd")} 23:59:59' "; } sql = sql + whereSql + groupSql + " limit 30 "; } List <PinGoodsOrder> list = goodsOrderBLL.GetListBySql(sql); if (list != null && list.Count > 0) { ViewBag.NameList = string.Join(",", list.Select(p => $"'{p.addtime.ToString("yyyy-MM-dd")}'")); ViewBag.ValueList = string.Join(",", list.Select(p => p.money / 100)); } return(View()); }