protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["page"] != "" && Request.QueryString["page"] != null) { int userId = Convert.ToInt32(Session["UserID"]); string itemType = Request.QueryString["itemType"] ?? ""; string itemName = Request.QueryString["itemName"] ?? ""; int pageNumber = Convert.ToInt32(Request.QueryString["page"]); int pagePerNumber = Convert.ToInt32(WebConfiguration.PagePerNumber); int howManyItems = 0; decimal priceMax = 0m; StringBuilder items = new StringBuilder(); items.Append("["); MonthBLL bll = new MonthBLL(); DataTable dt = bll.GetJiaGeFenXiMingXiList(userId, itemType, itemName, pageNumber, pagePerNumber, out howManyItems, out priceMax); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { items.Append("{"); items.Append("\"RowNumber\":" + "\"" + dr["RowNumber"].ToString() + "\","); items.Append("\"ItemName\":" + "\"" + dr["ItemName"].ToString() + "\","); items.Append("\"ItemBuyDate\":" + "\"" + Convert.ToDateTime(dr["ItemBuyDate"]).ToString("yyyy-MM-dd") + "\","); items.Append("\"ItemPrice\":" + "\"" + Convert.ToDouble(dr["ItemPrice"]).ToString("0.0##") + "\""); items.Append("},"); } items.Remove(items.ToString().LastIndexOf(','), 1); } items.Append("]"); Response.Write(items.ToString()); Response.End(); } }
private void PopulateControls() { int userId = Convert.ToInt32(Session["UserID"]); string itemType = Request.QueryString["itemType"] ?? ""; string itemName = Request.QueryString["itemName"] ?? ""; int pageNumber = 1; int pagePerNumber = Convert.ToInt32(WebConfiguration.PagePerNumber); int howManyItems = 0; decimal priceMax = 0m; MonthBLL bll = new MonthBLL(); DataTable dt = bll.GetJiaGeFenXiMingXiList(userId, itemType, itemName, pageNumber, pagePerNumber, out howManyItems, out priceMax); string max = "1"; string step = "1"; string itemBuyDate = ""; string itemPrice = ""; if (dt.Rows.Count > 0) { max = Math.Floor(priceMax).ToString(); step = Math.Floor(Convert.ToDouble(max) / 10).ToString(); int i = 0; foreach (DataRow dr in dt.Rows) { if (i == 15) break; string dot = (i < 15 - 1 && i < dt.Rows.Count - 1 ? "," : ""); itemBuyDate += "{\"text\":\"" + Convert.ToDateTime(dr["ItemBuyDate"]).ToString("yyyy-MM-dd") + "\",\"rotate\":90}" + dot; itemPrice += dr["ItemPrice"].ToString() + dot; i++; } } Response.Write(GetChartJsonString(itemBuyDate, itemPrice, max, step)); Response.End(); }