private void BindExpenseMoney()
{
OrderLog bllOrder = new OrderLog();
string sbWhere = this.QueryCondition();
sbWhere += "and OrderLog.OrderShopID = SysShop.ShopID and OrderLog.OrderMemID = Mem.MemID and Mem.MemLevelID=MemLevel.LevelID and OrderLog.OrderUserID = SysUser.UserID";
sbWhere = PubFunction.GetShopAuthority(this._UserShopID, "OrderShopID", sbWhere);
string strMoney = bllOrder.GetTotalMoney(sbWhere + " and datediff(day,OrderCreateTime,getdate())=0").ToString("f2");
this.lblToTalToday.Text = strMoney;
strMoney = bllOrder.GetTotalMoney(sbWhere + " and datediff(week,OrderCreateTime,getdate())=0").ToString("f2");
this.lblToTalWeek.Text = strMoney;
strMoney = bllOrder.GetTotalMoney(sbWhere + " and datediff(month,OrderCreateTime,getdate())=0").ToString("f2");
this.lblToTalMonth.Text = strMoney;
strMoney = bllOrder.GetTotalMoney(sbWhere).ToString("f2");
this.lblTotal.Text = strMoney;
strMoney = bllOrder.GetDiscountMoney(sbWhere + " and datediff(day,OrderCreateTime,getdate())=0").ToString("f2");
this.lblDiscountToday.Text = strMoney;
strMoney = bllOrder.GetDiscountMoney(sbWhere + " and datediff(week,OrderCreateTime,getdate())=0").ToString("f2");
this.lblDiscountWeek.Text = strMoney;
strMoney = bllOrder.GetDiscountMoney(sbWhere + " and datediff(month,OrderCreateTime,getdate())=0").ToString("f2");
this.lblDiscountMonth.Text = strMoney;
strMoney = bllOrder.GetDiscountMoney(sbWhere).ToString("f2");
this.lblDiscountTotal.Text = strMoney;
}
