private void BindMemExpenseMoney()
{
OrderLog bllOrder = new OrderLog();
string sbWhere = this.QueryCondition();
sbWhere += " and OrderLog.OrderMemID=Mem.MemID";
if (this.txtStartTime.Value != "")
{
this.timeStart = DateTime.Parse(this.txtStartTime.Value);
}
object obj = sbWhere;
sbWhere = string.Concat(new object[]
{
obj,
" and OrderLog.OrderCreateTime>='",
this.timeStart,
"'"
});
if (this.txtEndTime.Value != "")
{
this.timeEnd = Convert.ToDateTime(PubFunction.TimeEndDay(this.txtEndTime.Value));
}
obj = sbWhere;
sbWhere = string.Concat(new object[]
{
obj,
" and OrderLog.OrderCreateTime<='",
this.timeEnd,
"'"
});
if (this._UserShopID != 1)
{
sbWhere = PubFunction.GetMemListShopAuthority(this._UserShopID, "MemShopID", sbWhere);
}
DataTable dtMem = bllOrder.GetMemExpenseMoney(sbWhere).Tables[0];
this.lblTotalNumber.Text = dtMem.Rows[0]["TotalNumber"].ToString();
this.lblTotalMoney.Text = decimal.Parse(dtMem.Rows[0]["TotalMoney"].ToString()).ToString("0.00");
}
