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