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