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