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