public void CouponGetList(string strSql)
{
Chain.BLL.CouponList bllcoupon = new Chain.BLL.CouponList();
int Counts = this.NetPagerParameter.RecordCount;
strSql = strSql + " and CouPonID=" + this.spCouponID.InnerText;
DataTable db = bllcoupon.GetListSP(this.NetPagerParameter.PageSize, this.NetPagerParameter.CurrentPageIndex, out Counts, new string[]
{
strSql
}).Tables[0];
this.NetPagerParameter.RecordCount = Counts;
this.gvCouponList.DataSource = db;
this.gvCouponList.DataBind();
PageBase.BindSerialRepeater(this.gvCouponList, this.NetPagerParameter.PageSize * (this.NetPagerParameter.CurrentPageIndex - 1));
}
protected void btnCouponExcel_Click(object sender, EventArgs e)
{
Chain.BLL.CouponList bllcoupon = new Chain.BLL.CouponList();
int Counts = this.NetPagerParameter.RecordCount;
string strSql = this.QueryCondition();
strSql = strSql + " and CouPonID=" + this.spCouponID.InnerText;
DataTable db = bllcoupon.GetListSP(1000000, 1, out Counts, new string[]
{
strSql
}).Tables[0];
int CouponID = int.Parse(this.spCouponID.InnerText);
Chain.BLL.Coupon coupon = new Chain.BLL.Coupon();
Chain.Model.Coupon model = coupon.GetModel(CouponID);
DataExcelInfo.Coupon(db, this._UserName, model);
}
