/// <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();
}
//科室工作量查询
public void BuildSearch_workload_package()
{
Report a = new Report();
a.Load(Server.MapPath("workload_package.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["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_package(sqlw);
a.SetParameterValue("DeptName", Request.Params["DeptName"]);
a.SetParameterValue("StartDate", Request.Params["StartDate"]);
a.SetParameterValue("EndDate", Request.Params["EndDate"]);
a.RegisterData(ds.Tables[0], "workload_package");
WebReport1.Report = a;
WebReport1.Prepare();
}
