private void RptBind(string _strWhere, string _orderby) { this.page = AXRequest.GetQueryInt("page", 1); if (this.product_category_id > 0) { this.ddlproduct_category_id.SelectedValue = this.product_category_id.ToString(); } txtNote_no.Text = this.note_no; txtstart_time.Value = this.start_time; txtstop_time.Value = this.stop_time; ps_join_depot bll = new ps_join_depot(); this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount); this.rptList.DataBind(); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("backdepot_list.aspx", "start_time={0}&stop_time={1}&product_category_id={2}¬e_no={3}&page={4}", this.start_time.ToString(), this.stop_time.ToString(), this.product_category_id.ToString(), this.note_no, "__id__"); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
//绑定记录 public void binddr() { string sqlstr = ""; ps_join_depot bll = new ps_join_depot(); if (Convert.ToInt32(Session["DepotID"]) == 0 && Convert.ToInt32(Session["DepotCatID"]) == 0) { sqlstr = "product_code_state='入库' "; sqlstr = sqlstr + CombSqlTxt(this.product_category_id, this.note_no, this.start_time, this.stop_time); } sqlstr = sqlstr + " order by add_time desc,id desc"; DataView dv = bll.GetList(sqlstr).Tables[0].DefaultView; repCategory.DataSource = dv; repCategory.DataBind(); }