private void couponBind() { BLL.user_coupon bll = new BLL.user_coupon(); DataTable dt = bll.GetList(" datediff(dd,end_time,'" + DateTime.Now + "')<0", " id").Tables[0]; this.ddlGroupId.Items.Clear(); this.ddlGroupId.Items.Add(new ListItem("请选择...", "")); foreach (DataRow dr in dt.Rows) { string Id = dr["id"].ToString(); string Title = dr["title"].ToString().Trim(); this.ddlGroupId.Items.Add(new ListItem(Title, Id)); } }
private void RptBind(string _strWhere, string _orderby) { this.page = Vincent._DTcms.DTRequest.GetQueryInt("page", 1); if (this.status > 0) { this.ddlStatus.SelectedValue = this.status.ToString(); } if (this.coupon_stype > 0) { this.ddlPaymentStatus.SelectedValue = this.coupon_stype.ToString(); } txtKeywords.Text = this.keywords; BLL.user_coupon bll = new BLL.user_coupon(); this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount); this.rptList.DataBind(); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Vincent._DTcms.Utils.CombUrlTxt("coupon_list.aspx", "status={0}&coupon_stype={1}&page={2}&page={3}", this.status.ToString(), this.coupon_stype.ToString(), this.keywords, "__id__"); PageContent.InnerHtml = Vincent._DTcms.Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }