/// <summary> /// 绑定付费列表数据 /// </summary> private void BindPaymentList() { LoginInfo login = (LoginInfo)Session["login"]; string sqlstr = ""; sqlstr += FilterSql; string ids = LoginDataLimitManager.GetLimit(login.Id); if (string.IsNullOrEmpty(ids)) { sqlstr += " and makerID = " + login.Id; } else { sqlstr += " and makerID in (" + ids + ")"; } SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 017); Data data = new Data(); if (sps == null) { DataSet ds = data.DataPage("View_PaymentList", "id", "*", sqlstr, "requestDate", true, 10, 5, pages); RpPaymentList.DataSource = ds; RpPaymentList.DataBind(); } else { DataSet ds = data.DataPage("View_PaymentList", "id", "*", sqlstr, "requestDate", true, sps.Pageitem, sps.Pagecount, pages); RpPaymentList.DataSource = ds; RpPaymentList.DataBind(); } }
/// <summary> /// 绑定付费列表数据 /// </summary> private void BindPaymentList() { double zje = 0; LoginInfo login = (LoginInfo)Session["login"]; SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 020); string sql = " and isconfirm = 1"; sql += FilterSql; Data data = new Data(); AspNetPager1.RecordCount = data.GetCount("View_PaymentList", sql); if (sps == null) { AspNetPager1.NumericButtonCount = 10; AspNetPager1.PageSize = 10; } else { AspNetPager1.NumericButtonCount = sps.Pagecount; AspNetPager1.PageSize = sps.Pageitem; } //0419,修改首页列表中未支付优先显示 //DataTable dt = new EtNet_BLL.RegReimbursementManager().GetListpage(" isconfirm = 1" + FilterSql, "regType asc,requestDate DESC", AspNetPager1.StartRecordIndex, AspNetPager1.CurrentPageIndex); //原方法 DataTable dt = data.GetList("View_PaymentList", " regType"," DESC ", AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, sql); //0512 修改存储过程之后 多条件排序方法 DataTable dt = data.GetpageList("View_PaymentList", " regType asc,requestDate DESC ", AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, sql); for (int i = 0; i < dt.Rows.Count; i++) { zje += dt.Rows[i]["totalAmount"].ToString() == "" ? 0.00 : Convert.ToDouble(dt.Rows[i]["totalAmount"]); } RpPaymentList.DataSource = dt; RpPaymentList.DataBind(); this.zje.Text = zje.ToString("0.00"); }