public ActionResult InStorageReportDetail() { int queryTime = WebUtil.GetFormValue<int>("QueryTime", 0); int pageIndex = WebUtil.GetFormValue<int>("pageIndex", 0); int pageSize = WebUtil.GetFormValue<int>("pageSize", 0); string storageNum = this.DefaultStore; PageInfo procPageInfo = new PageInfo() { PageIndex = pageIndex, PageSize = pageSize }; InStorageProvider provider = new InStorageProvider(); List<Proc_InStorageReportEntity> detailList = provider.GetList(queryTime, ref procPageInfo, storageNum); detailList = detailList == null ? new List<Proc_InStorageReportEntity>() : detailList; detailList.ForEach(a => { a.Amount = a.Amount / 10000; }); string jsonDetail = ConvertJson.ListToJson<Proc_InStorageReportEntity>(detailList, "List"); this.ReturnJson.AddProperty("Data", new JsonObject(jsonDetail)); this.ReturnJson.AddProperty("RowCount", procPageInfo.RowCount); return Content(this.ReturnJson.ToString()); }
public ActionResult InStorageAmpie() { int queryTime = WebUtil.GetFormValue<int>("QueryTime", 0); int pageIndex = WebUtil.GetFormValue<int>("pageIndex", 0); int pageSize = 10; string storageNum = this.DefaultStore; PageInfo procPageInfo = new PageInfo() { PageIndex = pageIndex, PageSize = pageSize }; InStorageProvider provider = new InStorageProvider(); List<Proc_InStorageReportEntity> detailList = provider.GetList(queryTime, ref procPageInfo, storageNum); detailList = detailList == null ? new List<Proc_InStorageReportEntity>() : detailList; StringBuilder sb = new StringBuilder(); sb.Append("<chart>"); sb.Append("<series>"); int index = 0; detailList.ForEach(a => { //日期 sb.AppendFormat("<value xid=\"{0}\">{1}</value>", index.ToString(), a.CreateTime.ToString("MM-dd")); index++; }); index = 0; sb.Append("</series>"); sb.Append("<graphs>"); sb.Append("<graph gid=\"1\">"); detailList.ForEach(a => { //数量 sb.AppendFormat("<value xid=\"{0}\">{1}</value>", index.ToString(), a.Num.ToString()); index++; }); index = 0; sb.Append("</graph>"); sb.Append("<graph gid=\"2\">"); detailList.ForEach(a => { //数量 sb.AppendFormat("<value xid=\"{0}\">{1}</value>", index.ToString(), (a.Amount / 10000).ToString()); index++; }); sb.Append("</graph>"); sb.Append("</graphs>"); sb.Append("</chart>"); this.ReturnJson.AddProperty("InStorageData", sb.ToString()); this.ReturnJson.AddProperty("RowCount", procPageInfo.RowCount); return Content(this.ReturnJson.ToString()); }