/// <summary>
/// 数据绑定
/// </summary>
public override void DataBind()
{
Maticsoft.BLL.Search.Search bll = new Maticsoft.BLL.Search.Search();
string sqlw = " 1=1 ";
if (drpdepartment.Text != "")
{
sqlw += string.Format(" And A.DeptID = '{0}' ", drpdepartment.SelectedValue);
}
if (txtStartDate.Text != "")
{
sqlw += string.Format(" And A.CheckDate>='{0}' ", Convert.ToDateTime(txtStartDate.Text));
}
if (txtEndDate.Text != "")
{
sqlw += string.Format(" And A.CheckDate<'{0}' ", Convert.ToDateTime(txtEndDate.Text).AddDays(1));
}
ReportRepeater.DataSource = bll.GetList_workload_package(sqlw).Tables[0];
base.DataBind();
}
/// <summary>
/// 数据绑定
/// </summary>
public override void DataBind()
{
Maticsoft.BLL.Search.Search bll = new Maticsoft.BLL.Search.Search();
bool blDate = true;
string sqlw = " 1=1 And Enabled='1' ";
if (txtRegisterNo.Text != "")
{
sqlw += string.Format(" And RegisterNo like '%{0}%' ", txtRegisterNo.Text);
blDate = false;
}
if (txtDeptName.Text != "")
{
sqlw += string.Format(" And DeptName like '%{0}%' ", txtDeptName.Text);
//blDate = false;
}
if (txtName.Text != "")
{
sqlw += string.Format(" And Name like '%{0}%' ", txtName.Text);
//blDate = false;
}
if (txtIdNumber.Text != "")
{
sqlw += string.Format(" And IdNumber like '{0}%' ", txtIdNumber.Text);
blDate = false;
}
if (txtOverallDoctor.Text != "")
{
sqlw += string.Format(" And OverallDoctor like '{0}%' ", txtOverallDoctor.Text);
//blDate = false;
}
if (blDate)
{
if (txtStartDate.Text != "")
{
sqlw += string.Format(" And RegisterDate>='{0}' ", Convert.ToDateTime(txtStartDate.Text));
}
if (txtEndDate.Text != "")
{
sqlw += string.Format(" And RegisterDate<'{0}' ", Convert.ToDateTime(txtEndDate.Text).AddDays(1));
}
}
DataSet ds = bll.GetListByPage_Composed(sqlw, " RegisterNo desc ", (Pager.CurrentPageIndex - 1) * Pager.PageSize, (Pager.CurrentPageIndex) * Pager.PageSize);
Pager.RecordCount = bll.GetRecordCount_Composed(sqlw);
ReportRepeater.DataSource = ds.Tables[0];
base.DataBind();
}
/// <summary>
/// 数据绑定
/// </summary>
public override void DataBind()
{
Maticsoft.BLL.Search.Search bll = new Maticsoft.BLL.Search.Search();
string sql = "";
sql += string.Format(" RegisterNo='{0}'", RegisterNo);
rptMain.DataSource = bll.GetList_GroupResult(sql);
base.DataBind();
}
//科室医生工作量查询
public void BuildSearch_workload_checkItem()
{
Report a = new Report();
a.Load(Server.MapPath("workload_checkItem.frx"));
Maticsoft.BLL.Search.Search bll = new Maticsoft.BLL.Search.Search();
string sqlw = " 1=1 ";
if (Request.Params["DeptID"] != "")
{
sqlw += string.Format(" And A.DeptID = '{0}' ", Request.Params["DeptID"]);
}
if (Request.Params["CheckDoctor"] != "")
{
sqlw += string.Format(" And B.CheckDoctor= '{0}' ", Request.Params["CheckDoctor"]);
}
if (Request.Params["StartDate"] != "")
{
sqlw += string.Format(" And A.CheckDate>='{0}' ", Convert.ToDateTime(Request.Params["StartDate"]));
}
if (Request.Params["EndDate"] != "")
{
sqlw += string.Format(" And A.CheckDate<'{0}' ", Convert.ToDateTime(Request.Params["EndDate"]).AddDays(1));
}
DataSet ds = bll.GetList_workload_checkItem(sqlw);
a.SetParameterValue("CheckDoctor", Request.Params["CheckDoctor"]);
a.SetParameterValue("DeptName", Request.Params["DeptName"]);
a.SetParameterValue("StartDate", Request.Params["StartDate"]);
a.SetParameterValue("EndDate", Request.Params["EndDate"]);
a.RegisterData(ds.Tables[0], "workload_checkItem");
WebReport1.Report = a;
WebReport1.Prepare();
}
protected void rptMain_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
//判断里层repeater处于外层repeater的哪个位置（ AlternatingItemTemplate，FooterTemplate，
//HeaderTemplate，，ItemTemplate，SeparatorTemplate）
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
//Repeater rep = e.Item.FindControl("rptSub") as Repeater;//找到里层的repeater对象
DataRowView rowv = (DataRowView)e.Item.DataItem; //找到分类Repeater关联的数据项
string RegisterNo = Convert.ToString(rowv["RegisterNo"]); //获取填充子类的id
//string GroupID = Convert.ToString(rowv["GroupID"]); //获取填充子类的id
Maticsoft.BLL.Search.Search bll = new Maticsoft.BLL.Search.Search();
string sql = "";
sql += string.Format(" RegisterNo='{0}' ", RegisterNo);
DataTable dt = bll.GetList_GroupResult(sql).Tables[0];
Literal ltDo = e.Item.FindControl("ltDo") as Literal; //找到里层的repeater对象
Literal ltNoDo = e.Item.FindControl("ltNoDo") as Literal; //找到里层的repeater对象
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["IsOver"].ToString() == "0")
{
ltNoDo.Text += dt.Rows[i]["GroupName"].ToString() + "-";
}
else
{
ltDo.Text += dt.Rows[i]["GroupName"].ToString() + "-";
}
}
}
}
}
protected void rptMain_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
//判断里层repeater处于外层repeater的哪个位置（ AlternatingItemTemplate，FooterTemplate，
//HeaderTemplate，，ItemTemplate，SeparatorTemplate）
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
Repeater rep = e.Item.FindControl("rptSub") as Repeater; //找到里层的repeater对象
DataRowView rowv = (DataRowView)e.Item.DataItem; //找到分类Repeater关联的数据项
string DeptID = Convert.ToString(rowv["DeptID"]); //获取填充子类的id
string GroupID = Convert.ToString(rowv["GroupID"]); //获取填充子类的id
Maticsoft.BLL.Search.Search bll = new Maticsoft.BLL.Search.Search();
string sql = "";
sql += string.Format(" RegisterNo='{0}' And DeptID='{1}' And GroupID='{2}' ", RegisterNo, DeptID, GroupID);
rep.DataSource = bll.GetList_itemresult(sql);
rep.DataBind();
}
}
//组合查询
public void BuildSearch_Composed()
{
Report a = new Report();
a.Load(Server.MapPath("Search_Composed.frx"));
Maticsoft.BLL.Search.Search bll = new Maticsoft.BLL.Search.Search();
bool blDate = true;
string sqlw = " 1=1 ";
if (Request.Params["RegisterNo"] != "")
{
sqlw += string.Format(" And RegisterNo like '%{0}%' ", Request.Params["RegisterNo"]);
blDate = false;
}
if (Request.Params["DeptName"] != "")
{
sqlw += string.Format(" And DeptName like '%{0}%' ", Request.Params["DeptName"]);
blDate = false;
}
if (Request.Params["Name"] != "")
{
sqlw += string.Format(" And Name like '%{0}%' ", Request.Params["Name"]);
blDate = false;
}
if (Request.Params["IdNumber"] != "")
{
sqlw += string.Format(" And IdNumber like '{0}%' ", Request.Params["IdNumber"]);
blDate = false;
}
if (Request.Params["OverallDoctor"] != "")
{
sqlw += string.Format(" And OverallDoctor like '{0}%' ", Request.Params["OverallDoctor"]);
blDate = false;
}
if (blDate)
{
if (Request.Params["StartDate"] != "")
{
sqlw += string.Format(" And RegisterDate>='{0}' ", Convert.ToDateTime(Request.Params["StartDate"]));
}
if (Request.Params["EndDate"] != "")
{
sqlw += string.Format(" And RegisterDate<'{0}' ", Convert.ToDateTime(Request.Params["EndDate"]).AddDays(1));
}
}
sqlw += " order by RegisterNo Desc";
DataSet ds = bll.GetList_Composed(sqlw);
a.SetParameterValue("RegisterNo", Request.Params["RegisterNo"]);
a.SetParameterValue("DeptName", Request.Params["DeptName"]);
a.SetParameterValue("Name", Request.Params["Name"]);
a.SetParameterValue("IdNumber", Request.Params["IdNumber"]);
a.SetParameterValue("pOverallDoctor", Request.Params["OverallDoctor"]);
a.SetParameterValue("StartDate", Request.Params["StartDate"]);
a.SetParameterValue("EndDate", Request.Params["EndDate"]);
a.RegisterData(ds.Tables[0], "View_Search_Composed");
WebReport1.Report = a;
//WebReport1.Report.RegisterData(ds.Tables[0], "View_Search_Composed");
//WebReport1.Report.SetParameterValue("registerNo", Request.Params["RegisterNo"].ToString());
// WebReport1.Report.SetParameterValue("pOverallDoctor", "wsw");
WebReport1.Prepare();
}
