123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778 |
- using System;
- using System.Collections.Generic;
- //using System.Linq;
- using System.Web;
- using System.Web.UI;
- using System.Web.UI.WebControls;
- using System.Data;
- using System.Text;
- namespace Com.Jpsoft.Hospital.Web.Module.FllowUp
- {
- public partial class SelectSMS : System.Web.UI.Page
- {
- protected void Page_Load(object sender, EventArgs e)
- {
- if (!IsPostBack)
- {
- BindPageData();
- }
- }
- /// <summary>
- /// 绑定页面数据
- /// </summary>
- private void BindPageData()
- {
- string strWhere = " where 1=1 ";
- int recordCount = 0;
- if (!string.IsNullOrEmpty((string)ViewState["SearchTerms"]))
- {
- strWhere = ViewState["SearchTerms"].ToString();
- }
-
- string orderby = " order by info_id DESC";
- using (IDataReader idr = Com.Jpsoft.Hospital.DAL.jp_message_infoEx.SelectPage(AspNetPager1.CurrentPageIndex, AspNetPager1.PageSize, strWhere, orderby))
- {
- if (idr.Read())
- {
- recordCount = int.Parse(idr["RecordCount"].ToString());
- }
- AspNetPager1.RecordCount = recordCount;
- idr.NextResult();
- this.gv.DataSource = idr;
- this.gv.DataBind();
- idr.Close();
- }
- //绑定下拉框
- Com.Jpsoft.Hospital.BLL.jp_message_type type = new Com.Jpsoft.Hospital.BLL.jp_message_type();
- DataTable dt = type.GetAllList().Tables[0];
- this.ddlMessageType.DataSource = dt;
- this.ddlMessageType.DataTextField = "type_typename";
- this.ddlMessageType.DataValueField = "type_id";
- this.ddlMessageType.DataBind();
- this.ddlMessageType.Items.Insert(0, new ListItem("==请选择短信类型==", "0"));
- }
- protected void AspNetPager1_PageChanged(object sender, EventArgs e)
- {
- BindPageData();
- }
- protected void btncheck_Click(object sender, EventArgs e)
- {
- StringBuilder strWhere = new StringBuilder();
- strWhere.Append(" where 1=1 ");
- int type_id = int.Parse(this.ddlMessageType.SelectedValue.ToString().Trim());
- if (type_id != 0)
- {
- strWhere.Append(" and info_typeid=" + type_id);
- }
- ViewState["SearchTerms"] = strWhere.ToString();
- BindPageData();
- }
- }
- }
|