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