private void BindDrawMoney()
{
MemDrawMoney bllDrawMoney = new MemDrawMoney();
string strSql = this.QueryCondition();
strSql += " and MemDrawMoney.DrawMoneyMemID=Mem.MemID ";
strSql = PubFunction.GetShopAuthority(this._UserShopID, "DrawMoneyShopID", strSql);
DataTable dtDrawMoney = bllDrawMoney.GetDrawMoneyCount(strSql).Tables[0];
this.lblDrawTotalMoney.Text = decimal.Parse(dtDrawMoney.Rows[0]["DrawMoney"].ToString()).ToString("0.00");
this.lblDrawActualMoney.Text = decimal.Parse(dtDrawMoney.Rows[0]["DrawActualMoney"].ToString()).ToString("0.00");
}
protected void btnMemDrawMoneyExcel_Click(object sender, EventArgs e)
{
MemDrawMoney bllDrawMoney = new MemDrawMoney();
int Counts = this.NetPagerParameter.RecordCount;
string strSql = this.QueryCondition();
strSql += "and MemDrawMoney.DrawMoneyShopID = SysShop.ShopID and MemDrawMoney.DrawMoneyMemID = Mem.MemID and Mem.MemLevelID=MemLevel.LevelID and MemDrawMoney.DrawMoneyUserID = SysUser.UserID";
strSql = PubFunction.GetShopAuthority(this._UserShopID, "DrawMoneyShopID", strSql);
DataTable db = bllDrawMoney.GetListSP(1000000, 1, out Counts, new string[]
{
strSql
}).Tables[0];
DataExcelInfo.MemDrawMoney(db, this._UserName);
}
private void Get_ParameterList(string strSql)
{
MemDrawMoney bllDrawMoney = new MemDrawMoney();
int Counts = this.NetPagerParameter.RecordCount;
strSql += "and MemDrawMoney.DrawMoneyShopID = SysShop.ShopID and MemDrawMoney.DrawMoneyMemID = Mem.MemID and Mem.MemLevelID=MemLevel.LevelID and MemDrawMoney.DrawMoneyUserID = SysUser.UserID";
strSql = PubFunction.GetShopAuthority(this._UserShopID, "DrawMoneyShopID", strSql);
DataTable db = bllDrawMoney.GetListSP(this.NetPagerParameter.PageSize, this.NetPagerParameter.CurrentPageIndex, out Counts, new string[]
{
strSql
}).Tables[0];
this.NetPagerParameter.RecordCount = Counts;
this.NetPagerParameter.CustomInfoHTML = string.Format("<div class=\"results\"><span>当前第{0}/{1}页 共{2}条记录 每页{3}条</span></div>", new object[]
{
this.NetPagerParameter.CurrentPageIndex,
this.NetPagerParameter.PageCount,
this.NetPagerParameter.RecordCount,
this.NetPagerParameter.PageSize
});
this.gvRptMemDrawMoney.DataSource = db;
this.gvRptMemDrawMoney.DataBind();
PageBase.BindSerialRepeater(this.gvRptMemDrawMoney, this.NetPagerParameter.PageSize * (this.NetPagerParameter.CurrentPageIndex - 1));
}