protected void PopulateControls() { int userId = Int32.Parse(Session["UserID"].ToString()); DataTable dt = ItemAccess.GetQuJianTongJiList(userId); string value = ""; string itemName = ""; if (dt.Rows.Count > 0) { int i = 0; foreach (DataRow dr in dt.Rows) { DateTime d1 = DateTime.Parse(dr["ItemBuyDate"].ToString()); DateTime d2 = DateTime.Parse(dr["ItemBuyDateMax"].ToString()); string dot = (i < dt.Rows.Count - 1 ? "," : ""); value += "{\"left\":\"" + (Int32.Parse(d1.ToString("MM")) - 1) + "\",\"right\":" + (GetRegionDate(d1, d2) - 1) + ",\"tip\":\"区间 " + d1.ToString("yyyy-MM-dd") + "~" + d2.ToString("yyyy-MM-dd") + "\"}" + dot; itemName = "\"" + dr["ItemName"].ToString() + "\"," + itemName; i++; } itemName = itemName.Remove(itemName.Length - 1); } else { itemName = "\"0\""; } Response.Write(GetChartJsonString(value, itemName)); Response.End(); }
protected void PopulateControls() { DataTable dt = ItemAccess.GetQuJianTongJiList(userId); List.DataSource = dt; List.DataBind(); this.hidChartData.Value = ItemHelper.GetChartData(dt, "ItemBuyDate"); }