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); }