List.aspx.cs 3.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113
  1. using System;
  2. using System.Collections.Generic;
  3. //using System.Linq;
  4. using System.Web;
  5. using System.Web.UI;
  6. using System.Web.UI.WebControls;
  7. //
  8. using System.Data;
  9. namespace Com.Jpsoft.Hospital.Web.Module.Sys.Function
  10. {
  11. public partial class List : Com.Jpsoft.Hospital.Web.Common.BasePage
  12. {
  13. Com.Jpsoft.Hospital.Model.jp_sys_function model= new Com.Jpsoft.Hospital.Model.jp_sys_function();
  14. Com.Jpsoft.Hospital.BLL.jp_sys_function fun = new Com.Jpsoft.Hospital.BLL.jp_sys_function();
  15. protected void Page_Load(object sender, EventArgs e)
  16. {
  17. int id = 0;
  18. int curpage = 1;
  19. string cmd = string.Empty;
  20. FetchQueryString("id", out id);
  21. FetchQueryString("curpage", out curpage);
  22. FetchQueryString("cmd", out cmd);
  23. AspNetPager1.RecordCount = curpage * AspNetPager1.PageSize;
  24. AspNetPager1.CurrentPageIndex = curpage;
  25. if (cmd == "del")
  26. {
  27. Delete(id, curpage);
  28. }
  29. BindData();
  30. }
  31. /// <summary>
  32. /// delete
  33. /// </summary>
  34. /// <param name="id"></param>
  35. /// <param name="curpage"></param>
  36. private void Delete(int id, int curpage)
  37. {
  38. try
  39. {
  40. fun.Delete(id);
  41. Response.Write("<script>alert('删除成功!');window.navigate('List.aspx?curpage=" + curpage + "');</script>");
  42. }
  43. catch (Exception ex)
  44. {
  45. Response.Write("<script>alert('删除失败!原因:" + ex.ToString() + "');</script>");
  46. }
  47. }
  48. /// <summary>
  49. /// 绑定数据
  50. /// </summary>
  51. private void BindData()
  52. {
  53. int recordcount = 0;
  54. string strwhere = " where 1=1 ";
  55. string order = " order by fun_id DESC";
  56. using (IDataReader idr = Com.Jpsoft.Hospital.DAL.jp_sys_functionEx.SelectPage(AspNetPager1.CurrentPageIndex, AspNetPager1.PageSize, strwhere, order))
  57. {
  58. if (idr.Read())
  59. {
  60. recordcount=int.Parse(idr["RecordCount"].ToString());
  61. this.AspNetPager1.RecordCount = recordcount;
  62. idr.NextResult();
  63. }
  64. this.gv.DataSource = idr;
  65. this.gv.DataBind();
  66. idr.Close();
  67. }
  68. }
  69. ///// <summary>
  70. ///// 行绑定
  71. ///// </summary>
  72. ///// <param name="sender"></param>
  73. ///// <param name="e"></param>
  74. //protected void gv_RowDataBound(object sender, GridViewRowEventArgs e)
  75. //{
  76. // if (e.Row.RowType == DataControlRowType.DataRow)
  77. // {
  78. // if (e.Row.RowState == DataControlRowState.Alternate || e.Row.RowState == DataControlRowState.Normal)
  79. // {
  80. // ((LinkButton)e.Row.Cells[2].Controls[0]).Attributes.Add("onclick", "return confirm('确定要删除吗?');");
  81. // }
  82. // }
  83. //}
  84. ///// <summary>
  85. ///// 删除
  86. ///// </summary>
  87. ///// <param name="sender"></param>
  88. ///// <param name="e"></param>
  89. //protected void gv_RowDeleting(object sender, GridViewDeleteEventArgs e)
  90. //{
  91. // int id = int.Parse(this.gv.DataKeys[e.RowIndex].Value.ToString());
  92. // fun.Delete(id);
  93. // Response.Write("<script>alert('删除成功!');</script>");
  94. // BindData();
  95. //}
  96. protected void AspNetPager1_PageChanged(object sender, EventArgs e)
  97. {
  98. BindData();
  99. }
  100. protected void btnadd_Click(object sender, EventArgs e)
  101. {
  102. Response.Redirect("Insert.aspx");
  103. }
  104. protected void gv_RowDeleting(object sender, GridViewDeleteEventArgs e)
  105. {
  106. }
  107. }
  108. }