///// <summary>
///// 加载收款单位
///// </summary>
//private void LoadColUnit()
//{
// this.collectUnit.Items.Clear();
// this.collectUnit.Items.Add(new ListItem("——请选择——", "0"));
// IList<Customer> customers = CustomerManager.getCustomerAll();
// foreach (Customer customer in customers)
// {
// ListItem adItem = new ListItem();
// adItem.Value = customer.Id.ToString();
// adItem.Text = customer.CusshortName;
// this.collectUnit.Items.Add(adItem);
// }
//}
/// <summary>
/// 加载订单数据
/// </summary>
private void LoadInvoiceRecordList()
{
LoginInfo login = Session["login"] as LoginInfo;
string sql = " ";
sql += Session["query"];
EtNet_BLL.DataPage.Data data = new EtNet_BLL.DataPage.Data();
AspNetPager1.RecordCount = data.GetCount("InvoiceRecord", sql);
SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 032);
if (sps == null)
{
AspNetPager1.NumericButtonCount = 5;
AspNetPager1.PageSize = 5;
}
else
{
AspNetPager1.NumericButtonCount = sps.Pagecount;
AspNetPager1.PageSize = sps.Pageitem;
}
DataTable dt = data.GetList("InvoiceRecord", "makeDate", "asc", AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, sql);
this.payRepeater.DataSource = dt;
this.payRepeater.DataBind();
}
/// <summary>
/// 加载付款申请数据
/// </summary>
private void LoadPayList()
{
LoginInfo login = Session["login"] as LoginInfo;
if (!string.IsNullOrEmpty(Session["payQuery"].ToString()) || !string.IsNullOrEmpty(Session["query"].ToString()))//--0429 更改
{
//}
//if (Session["payQuery"].ToString() != "" || Session["query"].ToString() != "")//原方法报错
//{
string sql = " and auditstatus = '04' ";
sql += Session["payQuery"];
sql += Session["query"];
EtNet_BLL.DataPage.Data data = new EtNet_BLL.DataPage.Data();
AspNetPager1.RecordCount = data.GetCount("View_PaymentList", sql);
SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 040);
if (sps == null)
{
AspNetPager1.NumericButtonCount = 5;
AspNetPager1.PageSize = 5;
}
else
{
AspNetPager1.NumericButtonCount = sps.Pagecount;
AspNetPager1.PageSize = sps.Pageitem;
}
//0429 修改 为了排序顺序
// DataTable dt = new EtNet_BLL.RegReimbursementManager().GetListpage(" auditstatus = '04'" + Session["payQuery"] + Session["query"], "regType asc,confirmDate DESC", AspNetPager1.StartRecordIndex, AspNetPager1.EndRecordIndex);
DataTable dt = data.GetpageList("View_PaymentList", " regType asc,confirmDate DESC ", AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, sql);
// DataTable dt = data.GetList("View_PaymentList", "isConfirm", "asc", AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, sql);//原方法
this.payRepeater.DataSource = dt;
this.payRepeater.DataBind();
}
else
{
this.payRepeater.DataSource = null;
this.payRepeater.DataBind();
}
}