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