Ejemplo n.º 1
0
 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));
 }
Ejemplo n.º 2
0
 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);
 }