protected void PopulateControls() { double priceMax = 0; DataTable dt = ItemAccess.GetItemDateTopList(today, userId, "list", out priceMax); DateTop.DataSource = dt; DateTop.DataBind(); this.hidChartData.Value = ItemHelper.GetChartData(dt, "ItemBuyDate"); }
protected void PopulateControls() { string today = Session["TodayDate"].ToString(); int userId = Int32.Parse(Session["UserID"].ToString()); string orderBy = Request.QueryString["orderBy"] ?? "chart"; double priceMax = 0; DataTable dt = ItemAccess.GetItemDateTopList(today, userId, orderBy, out priceMax); string max = "1"; string step = "1"; string itemBuyDate = ""; string shouruPrice = ""; string zhichuPrice = ""; string tip = (orderBy == "list" ? "#x_label#" : DateTime.Parse(today).ToString("yyyy-MM-") + "#x_label#"); if (dt.Rows.Count > 0) { max = Math.Floor(priceMax).ToString(); step = Math.Floor(Double.Parse(max) / 10).ToString(); int i = 0; foreach (DataRow dr in dt.Rows) { string dot = (i < dt.Rows.Count - 1 ? "," : ""); string date = (orderBy == "list" ? DateTime.Parse(dr["ItemBuyDate"].ToString()).ToString("yyyy-MM-dd") : DateTime.Parse(dr["ItemBuyDate"].ToString()).ToString("dd")); int rotate = (orderBy == "list" ? 90 : 0); itemBuyDate += "{\"text\":\"" + date + "\",\"rotate\":" + rotate + "}" + dot; shouruPrice += dr["ShouRuPrice"].ToString() + dot; zhichuPrice += dr["ZhiChuPrice"].ToString() + dot; i++; } } else { itemBuyDate = "{\"text\":\"0\"},{\"text\":\"1\"}"; } Response.Write(GetChartJsonString(itemBuyDate, shouruPrice, zhichuPrice, max, step, tip)); Response.End(); }
protected void BindGrid() { if (Request.QueryString["date"] != null && Request.QueryString["date"] != "") { if (!ValidHelper.CheckDate(Request.QueryString["date"])) { Session["TodayDate"] = DateTime.Now.ToString("yyyy-MM-dd"); } else { Session["TodayDate"] = Request.QueryString["date"]; } } string today = Session["TodayDate"].ToString(); int userId = Int32.Parse(Session["UserID"].ToString()); //图表点击事件 double priceMax = 0; DataTable dd = ItemAccess.GetItemDateTopList(today, userId, "chart", out priceMax); this.hidChartData.Value = ItemHelper.GetChartData(dd, "ItemBuyDate"); #region 每日消费代码 double shouruPrice = 0; double zhichuPrice = 0; double shouruPriceMonth = 0; double zhichuPriceMonth = 0; double shouruPriceYear = 0; double zhichuPriceYear = 0; DataTable total = ItemAccess.GetItemListShouZhi(today, userId, out shouruPrice, out zhichuPrice, out shouruPriceMonth, out zhichuPriceMonth, out shouruPriceYear, out zhichuPriceYear); this.Label2.Text = shouruPrice.ToString("0.0##"); this.Label4.Text = zhichuPrice.ToString("0.0##"); this.Label1.Text = shouruPriceMonth.ToString("0.0##"); this.Label3.Text = zhichuPriceMonth.ToString("0.0##"); this.Label11.Text = shouruPriceYear.ToString("0.0##"); this.Label12.Text = zhichuPriceYear.ToString("0.0##"); double jiechuPrice = 0; double huanruPrice = 0; double jieruPrice = 0; double huanchuPrice = 0; DataTable jiehuan = ItemAccess.GetItemListJieHuanYear(today, userId, out jiechuPrice, out huanruPrice, out jieruPrice, out huanchuPrice); this.Label5.Text = jiechuPrice.ToString("0.##"); this.Label6.Text = huanruPrice.ToString("0.##"); this.Label7.Text = jieruPrice.ToString("0.##"); this.Label8.Text = huanchuPrice.ToString("0.##"); this.Label9.Text = (jiechuPrice - huanruPrice).ToString("0.##"); this.Label10.Text = (jieruPrice - huanchuPrice).ToString("0.##"); #endregion //首页功能链接 string userFunction = ""; if (Session["UserFunction"] != null) { userFunction = Session["UserFunction"].ToString(); } this.Label13.Text = UserAccess.GetUserFunctionText(userFunction); //钱包列表 this.CardList.DataSource = CardAccess.GetCardList(userId); this.CardList.DataTextField = "CardName"; this.CardList.DataValueField = "CardID"; this.CardList.DataBind(); if (Request.Cookies["CardID"] != null) { string cardId = Request.Cookies["CardID"].Value; this.CardList.SelectedValue = cardId; } CardList_SelectionChanged(this.CardList, null); }