using System; using System.Collections.Generic; using System.Data; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; namespace Com.Jpsoft.Hospital.Web.Module.MsgRecord { public partial class List : Com.Jpsoft.Hospital.Web.Common.BasePage { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int pageindex = 1; AspNetPager1.RecordCount = pageindex * AspNetPager1.PageSize; AspNetPager1.CurrentPageIndex = pageindex; BindData(); SetCount(); } } private void SetCount() { string strWhere = " 1=1 "; if (ViewState["SearchTerms"] != null) { strWhere = ViewState["SearchTerms"].ToString(); } Com.Jpsoft.Hospital.DAL.jp_msg_sendrecordEx bll = new DAL.jp_msg_sendrecordEx(); lblCount.Text = bll.GetOKMsgCount(strWhere); } private void BindData() { int RecordCount = 0; string strWhere = " where 1=1"; if (ViewState["SearchTerms"] != null) { strWhere = ViewState["SearchTerms"].ToString(); } string strOrder = " order by r_createdate DESC"; using (IDataReader idr = Com.Jpsoft.Hospital.DAL.jp_msg_sendrecordEx.SelectPage(AspNetPager1.CurrentPageIndex, AspNetPager1.PageSize, strWhere, strOrder)) { if (idr.Read()) { RecordCount = Convert.ToInt32(idr["RecordCount"]); } idr.NextResult(); GridView1.DataSource = idr; GridView1.DataBind(); } this.AspNetPager1.RecordCount = RecordCount; } protected void btnSearch_Click(object sender, EventArgs e) { System.Text.StringBuilder strWhere = new System.Text.StringBuilder(); strWhere.Append(" where 1=1 "); if (txtstart.Text.Trim().Length > 0) { strWhere.Append(" and r_createdate>='" + txtstart.Text.Trim() + "'"); } if (txtEnd.Text.Trim().Length > 0) { strWhere.Append(" and r_createdate<'" + txtEnd.Text.Trim() + "'"); } if (ddltype.SelectedValue != "") { strWhere.Append(" and r_type='" + ddltype.SelectedValue + "'"); } ViewState["SearchTerms"] = strWhere.ToString(); BindData(); } protected void AspNetPager1_PageChanged(object sender, EventArgs e) { BindData(); } public string GetBoolCN(object obj) { bool bl; if (bool.TryParse(obj.ToString(), out bl)) { if (bl) return "成功"; else return "失败"; } return "未知"; } public string GetTypeName(object obj) { string type = string.Empty; switch (obj.ToString()) { case "1": type = "住院随访"; break; case "2": type = "门诊随访"; break; case "3": type = "科研随访"; break; case "4": type = "表扬回复"; break; case "5": type = "投诉"; break; case "6": type = "入院问候"; break; case "7": type = "出院问候"; break; case "8": type = "化验提醒"; break; } return type; } } }