private void PopulateControls()
{
decimal priceMax = 0m;
DataTable lists = bll.GetBiJiaoFenXiList(userId, today, "list", out priceMax);
List.DataSource = lists;
List.DataBind();
double zhiTotalCur = 0d;
double shouTotalCur = 0d;
double zhiTotalPrev = 0d;
double shouTotalPrev = 0d;
foreach (DataRow dr in lists.Rows)
{
zhiTotalCur += Convert.ToDouble(dr["ZhiPriceCur"]);
shouTotalCur += Convert.ToDouble(dr["ShouPriceCur"]);
zhiTotalPrev += Convert.ToDouble(dr["ZhiPricePrev"]);
shouTotalPrev += Convert.ToDouble(dr["ShouPricePrev"]);
}
this.Label4.Text = zhiTotalCur.ToString("0.0##");
this.Label2.Text = shouTotalCur.ToString("0.0##");
this.Label5.Text = zhiTotalPrev.ToString("0.0##");
this.Label3.Text = shouTotalPrev.ToString("0.0##");
DataTable dt = bll.GetBiJiaoFenXiList(userId, today, "chart", out priceMax);
this.hidChartData.Value = ItemHelper.GetChartData(dt, "PageUrl");
}
//设置图表
private void GetChartInfo()
{
DataTable dt = new DataTable();
DateTime now = DateTime.Now.Date;
if (curDate != "")
{
now = Convert.ToDateTime(curDate).Date;
}
switch (chartType)
{
case "datechart":
decimal priceMax = 0m;
dt = month_bll.GetItemDateTopList(userId, now, "chart", out priceMax);
chartDate = ItemHelper.GetChartData(dt, "ItemBuyDate");
chartUrl = "/Web2015/ItemDateChartJson.aspx?date=" + curDate;
break;
case "numchart":
dt = month_bll.GetItemNumTopList(userId, now);
chartDate = ItemHelper.GetChartData(dt, "ChartUrl");
chartUrl = "/Web2015/ItemNumChartJson.aspx?date=" + curDate;
break;
case "pricechart":
dt = month_bll.GetItemPriceTopList(userId, now);
chartDate = ItemHelper.GetChartData(dt, "ItemBuyDate");
chartUrl = "/Web2015/ItemPriceChartJson.aspx?date=" + curDate;
break;
}
}
protected void PopulateControls()
{
DataTable dt = ItemAccess.GetQuJianTongJiList(userId);
List.DataSource = dt;
List.DataBind();
this.hidChartData.Value = ItemHelper.GetChartData(dt, "ItemBuyDate");
}
//初始数据
private void PopulateControls()
{
DataTable lists = bll.GetItemNumDetailList(userId, today, Convert.ToInt32(catTypeId), itemType, itemName, "list");
List.DataSource = lists;
List.DataBind();
this.hidChartData.Value = ItemHelper.GetChartData(lists, "ItemBuyDate");
}
protected void PopulateControls()
{
DataTable dt = ItemAccess.GetItemPriceTopList(today, userId);
PriceTop.DataSource = dt;
PriceTop.DataBind();
this.hidChartData.Value = ItemHelper.GetChartData(dt, "ItemBuyDate");
}
//初始数据
private void PopulateControls()
{
DataTable lists = bll.GetItemPriceTopList(userId, today);
PriceTop.DataSource = lists;
PriceTop.DataBind();
this.hidChartData.Value = ItemHelper.GetChartData(lists, "ItemBuyDate");
}
//初始数据
private void PopulateControls()
{
DataTable lists = bll.GetQuJianTongJiList(userId);
List.DataSource = lists;
List.DataBind();
this.hidChartData.Value = ItemHelper.GetChartData(lists, "ItemBuyDate");
}
//初始数据
private void PopulateControls()
{
DataTable lists = bll.GetItemNumTopList(userId, today);
NumTop.DataSource = lists;
NumTop.DataBind();
this.hidChartData.Value = ItemHelper.GetChartData(lists, "PageUrl");
}
//初始数据
private void PopulateControls()
{
decimal priceMax = 0m;
DataTable lists = bll.GetItemDateTopList(userId, today, "list", out priceMax);
DateTop.DataSource = lists;
DateTop.DataBind();
this.hidChartData.Value = ItemHelper.GetChartData(lists, "ItemBuyDate");
}
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()
{
double priceMax = 0;
DataTable dt = ItemAccess.GetFenLeiZongJiMingXiList(catTypeId, today, userId, out priceMax);
List.DataSource = dt;
List.DataBind();
this.hidChartData.Value = ItemHelper.GetChartData(dt, "PageUrl");
}
protected void PopulateControls()
{
int monthMax = 0;
DataTable dt = ItemAccess.GetTuiJianFenXiList(userId, out monthMax);
ItemList.DataSource = dt;
ItemList.DataBind();
this.hidChartData.Value = ItemHelper.GetChartData(dt, "ItemBuyDate");
}
protected void PopulateControls()
{
double priceMax = 0;
DataTable dt = ItemAccess.GetItemNumDetailList(itemName, itemType, userId, Int32.Parse(catTypeId), today, "list", out priceMax);
List.DataSource = dt;
List.DataBind();
this.hidChartData.Value = ItemHelper.GetChartData(dt, "ItemBuyDate");
}
//初始数据
private void PopulateControls()
{
decimal priceMax = 0m;
DataTable lists = bll.GetFenLeiZongJiMingXiList(userId, today, catTypeId, out priceMax);
List.DataSource = lists;
List.DataBind();
this.hidChartData.Value = ItemHelper.GetChartData(lists, "PageUrl");
}
protected void PopulateControls()
{
int countMax = 0;
DataTable dt = ItemAccess.GetItemNumTopList(today, userId, out countMax);
NumTop.DataSource = dt;
NumTop.DataBind();
this.hidChartData.Value = ItemHelper.GetChartData(dt, "PageUrl");
}
protected void PopulateControls()
{
int pageNumber = 1;
double priceMax = 0;
DataTable dt = ItemAccess.GetJiaGeFenXiList(userId, pageNumber, out howManyItems, out priceMax);
ItemList.DataSource = dt;
ItemList.DataBind();
this.hidChartData.Value = ItemHelper.GetChartData(dt, "PageUrl");
}
protected void PopulateControls()
{
int notBuyMax = 0;
int pageNumber = 1;
DataTable dt = ItemAccess.GetJianGeFenXiList(userId, pageNumber, out howManyItems, out notBuyMax);
List.DataSource = dt;
List.DataBind();
this.hidChartData.Value = ItemHelper.GetChartData(dt, "ItemBuyDate");
}
protected void PopulateControls()
{
int pageNumber = 1;
double priceMax = 0;
DataTable dt = ItemAccess.GetJiaGeFenXiMingXiList(itemName, itemType, userId, pageNumber, out howManyItems, out priceMax);
List.DataSource = dt;
List.DataBind();
this.hidChartData.Value = ItemHelper.GetChartData(dt, "ItemBuyDate");
}
protected void PopulateControls()
{
double priceMax = 0;
int countMax = 0;
DataTable dt = ItemAccess.GetBiJiaoMingXiList(catTypeId, today, userId, out priceMax, out countMax);
CatTypeList.DataSource = dt;
CatTypeList.DataBind();
this.hidChartData.Value = ItemHelper.GetChartData(dt, "PageUrlCur");
this.hidChartData2.Value = ItemHelper.GetChartData(dt, "PageUrlPrev");
}
private void PopulateControls()
{
decimal priceMax = 0m;
int countMax = 0;
DataTable dt = bll.GetBiJiaoMingXiList(userId, today, catTypeId, out priceMax, out countMax);
CatTypeList.DataSource = dt;
CatTypeList.DataBind();
this.hidChartData.Value = ItemHelper.GetChartData(dt, "PageUrlCur");
this.hidChartData2.Value = ItemHelper.GetChartData(dt, "PageUrlPrev");
}
//初始数据
private void BindGrid()
{
int userId = Convert.ToInt32(Session["UserID"]);
DateTime today = Utility.GetRequestDate(Request.QueryString["date"]);
//图表点击所需数据
decimal priceMax = 0m;
DataTable dt = month_bll.GetItemDateTopList(userId, today, "chart", out priceMax);
this.hidChartData.Value = ItemHelper.GetChartData(dt, "ItemBuyDate");
#region 每日消费代码
DataTable total = month_bll.GetShouZhiJieHuanList(userId, today);
this.Label2.Text = Convert.ToDouble(total.Rows[0]["ShouRuPrice"]).ToString("0.0##");
this.Label4.Text = Convert.ToDouble(total.Rows[0]["ZhiChuPrice"]).ToString("0.0##");
this.Label1.Text = Convert.ToDouble(total.Rows[0]["ShouRuPriceMonth"]).ToString("0.0##");
this.Label3.Text = Convert.ToDouble(total.Rows[0]["ZhiChuPriceMonth"]).ToString("0.0##");
this.Label11.Text = Convert.ToDouble(total.Rows[0]["ShouRuPriceYear"]).ToString("0.0##");
this.Label12.Text = Convert.ToDouble(total.Rows[0]["ZhiChuPriceYear"]).ToString("0.0##");
double JieChuPrice = Convert.ToDouble(total.Rows[0]["JieChuPriceYear"]);
double HuanRuPrice = Convert.ToDouble(total.Rows[0]["HuanRuPriceYear"]);
double JieRuPrice = Convert.ToDouble(total.Rows[0]["JieRuPriceYear"]);
double HuanChuPrice = Convert.ToDouble(total.Rows[0]["HuanChuPriceYear"]);
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 = UserHelper.GetUserFunctionText(userFunction);
//钱包列表
this.CardList.DataSource = card_bll.GetCardList(userId);
this.CardList.DataTextField = "CardName";
this.CardList.DataValueField = "CDID";
this.CardList.DataBind();
if (Request.Cookies["CardID"] != null)
{
string cardId = Request.Cookies["CardID"].Value;
this.CardList.SelectedValue = cardId;
}
CardList_SelectionChanged(this.CardList, null);
}
private void PopulateControls()
{
int pageNumber = 1;
int pagePerNumber = Convert.ToInt32(WebConfiguration.PagePerNumber);
decimal priceMax = 0m;
DataTable lists = bll.GetJiaGeFenXiList(userId, pageNumber, pagePerNumber, out howManyItems, out priceMax);
ItemList.DataSource = lists;
ItemList.DataBind();
this.hidChartData.Value = ItemHelper.GetChartData(lists, "PageUrl");
}
private void PopulateControls()
{
int pageNumber = 1;
int pagePerNumber = Convert.ToInt32(WebConfiguration.PagePerNumber);
int notBuyMax = 0;
DataTable lists = bll.GetJianGeFenXiList(userId, pageNumber, pagePerNumber, out howManyItems, out notBuyMax);
List.DataSource = lists;
List.DataBind();
this.hidChartData.Value = ItemHelper.GetChartData(lists, "ItemBuyDate");
}
protected void PopulateControls()
{
DataTable dt = ItemAccess.GetFenLeiZongJiList(today, userId);
List.DataSource = dt;
List.DataBind();
double priceTotal = 0;
foreach (DataRow dr in dt.Rows)
{
priceTotal += Double.Parse(dr["ItemPriceTotal"].ToString());
}
this.Label2.Text = priceTotal.ToString("0.0##");
this.hidChartData.Value = ItemHelper.GetChartData(dt, "PageUrl");
}
//初始数据
private void PopulateControls()
{
DataTable lists = bll.GetFenLeiZongJiList(userId, today);
List.DataSource = lists;
List.DataBind();
double zhiPriceTotal = 0d;
double shouPriceTotal = 0d;
foreach (DataRow dr in lists.Rows)
{
zhiPriceTotal += Convert.ToDouble(dr["ZhiPriceTotal"]);
shouPriceTotal += Convert.ToDouble(dr["ShouPriceTotal"]);
}
this.Label3.Text = zhiPriceTotal.ToString("0.0##");
this.Label2.Text = shouPriceTotal.ToString("0.0##");
this.hidChartData.Value = ItemHelper.GetChartData(lists, "PageUrl");
}
protected void PopulateControls()
{
double priceMax = 0;
DataTable dt = ItemAccess.GetBiJiaoFenXiList(today, userId, "", out priceMax);
List.DataSource = dt;
List.DataBind();
double totalCur = 0;
double totalPrev = 0;
foreach (DataRow dr in dt.Rows)
{
totalCur += Double.Parse(dr["ItemPriceCur"].ToString());
totalPrev += Double.Parse(dr["ItemPricePrev"].ToString());
}
this.Label2.Text = totalCur.ToString("0.0##");
this.Label3.Text = totalPrev.ToString("0.0##");
DataTable dd = ItemAccess.GetBiJiaoFenXiList(today, userId, "chart", out priceMax);
this.hidChartData.Value = ItemHelper.GetChartData(dd, "PageUrl");
}
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);
}
