SelectSMS.aspx.cs 2.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778
  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. using System.Data;
  8. using System.Text;
  9. namespace Com.Jpsoft.Hospital.Web.Module.FllowUp
  10. {
  11. public partial class SelectSMS : System.Web.UI.Page
  12. {
  13. protected void Page_Load(object sender, EventArgs e)
  14. {
  15. if (!IsPostBack)
  16. {
  17. BindPageData();
  18. }
  19. }
  20. /// <summary>
  21. /// 绑定页面数据
  22. /// </summary>
  23. private void BindPageData()
  24. {
  25. string strWhere = " where 1=1 ";
  26. int recordCount = 0;
  27. if (!string.IsNullOrEmpty((string)ViewState["SearchTerms"]))
  28. {
  29. strWhere = ViewState["SearchTerms"].ToString();
  30. }
  31. string orderby = " order by info_id DESC";
  32. using (IDataReader idr = Com.Jpsoft.Hospital.DAL.jp_message_infoEx.SelectPage(AspNetPager1.CurrentPageIndex, AspNetPager1.PageSize, strWhere, orderby))
  33. {
  34. if (idr.Read())
  35. {
  36. recordCount = int.Parse(idr["RecordCount"].ToString());
  37. }
  38. AspNetPager1.RecordCount = recordCount;
  39. idr.NextResult();
  40. this.gv.DataSource = idr;
  41. this.gv.DataBind();
  42. idr.Close();
  43. }
  44. //绑定下拉框
  45. Com.Jpsoft.Hospital.BLL.jp_message_type type = new Com.Jpsoft.Hospital.BLL.jp_message_type();
  46. DataTable dt = type.GetAllList().Tables[0];
  47. this.ddlMessageType.DataSource = dt;
  48. this.ddlMessageType.DataTextField = "type_typename";
  49. this.ddlMessageType.DataValueField = "type_id";
  50. this.ddlMessageType.DataBind();
  51. this.ddlMessageType.Items.Insert(0, new ListItem("==请选择短信类型==", "0"));
  52. }
  53. protected void AspNetPager1_PageChanged(object sender, EventArgs e)
  54. {
  55. BindPageData();
  56. }
  57. protected void btncheck_Click(object sender, EventArgs e)
  58. {
  59. StringBuilder strWhere = new StringBuilder();
  60. strWhere.Append(" where 1=1 ");
  61. int type_id = int.Parse(this.ddlMessageType.SelectedValue.ToString().Trim());
  62. if (type_id != 0)
  63. {
  64. strWhere.Append(" and info_typeid=" + type_id);
  65. }
  66. ViewState["SearchTerms"] = strWhere.ToString();
  67. BindPageData();
  68. }
  69. }
  70. }