List.aspx.cs 2.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566
  1. using System;
  2. using System.Collections;
  3. using System.Configuration;
  4. using System.Data;
  5. //using System.Linq;
  6. using System.Web;
  7. using System.Web.Security;
  8. using System.Web.UI;
  9. using System.Web.UI.HtmlControls;
  10. using System.Web.UI.WebControls;
  11. using System.Web.UI.WebControls.WebParts;
  12. //using System.Xml.Linq;
  13. namespace Com.Jpsoft.Hospital.Web.Module.rs_ksdm
  14. {
  15. public partial class List : System.Web.UI.Page
  16. {
  17. protected void Page_Load(object sender, EventArgs e)
  18. {
  19. if (!IsPostBack)
  20. {
  21. int iCurPage = 1;
  22. Com.Jpsoft.Hospital.Web.Common.BasePage.FetchQueryString("LCurPage", out iCurPage);
  23. AspNetPager1.RecordCount = iCurPage * AspNetPager1.PageSize;
  24. AspNetPager1.CurrentPageIndex = iCurPage;
  25. BindData();
  26. }
  27. }
  28. private void BindData()
  29. {
  30. int RecordCount = 0;
  31. string strWhere = " where 1=1 ";
  32. if (!string.IsNullOrEmpty(this.txtksmc.Text))
  33. {
  34. strWhere += " and ksmc like '%" + this.txtksmc.Text + "%' ";
  35. }
  36. string strOrder = " order by ksdm DESC";
  37. Com.Jpsoft.Hospital.BLL.Ex.rs_ksdmEx bll = new Com.Jpsoft.Hospital.BLL.Ex.rs_ksdmEx();
  38. using (IDataReader idr = bll.SelectPage(AspNetPager1.CurrentPageIndex, AspNetPager1.PageSize, strWhere, strOrder))
  39. {
  40. if (idr.Read())
  41. {
  42. RecordCount = Convert.ToInt32(idr["RecordCount"]);
  43. }
  44. idr.NextResult();
  45. GridView1.DataSource = idr;
  46. GridView1.DataBind();
  47. }
  48. this.AspNetPager1.RecordCount = RecordCount;
  49. }
  50. protected void Button1_Click(object sender, EventArgs e)
  51. {
  52. this.AspNetPager1.CurrentPageIndex = 0;
  53. BindData();
  54. }
  55. protected void AspNetPager1_PageChanged(object sender, EventArgs e)
  56. {
  57. BindData();
  58. }
  59. }
  60. }