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