Ejemplo n.º 1
0
        protected void BindReportDataSource()
        {
            DateTime start = Convert.ToDateTime(this.StartDate.Text);
            DateTime end   = Convert.ToDateTime(this.EndDate.Text);
            string   time  = Convert.ToString(this.Time.Text);
            //string result = Convert.ToString(this.HiddenForResult.Value);
            string result   = Convert.ToString(this.HiddenForResult.Value);
            string name     = (this.Name.Text).ToString();
            string workCode = Convert.ToString(this.WorkCode.Text);
            string start1   = start.ToString();
            string end1     = end.ToString();

            this.ReportViewer1.LocalReport.DataSources.Clear();
            this.ReportViewer1.LocalReport.ReportPath = Server.MapPath(@"~/Reports/TJ_WJLD.rdlc");
            Microsoft.Reporting.WebForms.ReportParameter st = new Microsoft.Reporting.WebForms.ReportParameter("StartTime", start1);
            Microsoft.Reporting.WebForms.ReportParameter ed = new Microsoft.Reporting.WebForms.ReportParameter("EndTime", end1);
            this.ReportViewer1.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter[] { st, ed });
            TJDAL     dal = new TJDAL();
            DataTable dt  = dal.Get_WJLD(start, end, time, result, name, workCode);

            this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_WJLD", dt));
            DataTable dt1 = dal.Get_WJLD_Reason(start, end, time, result, name, workCode);

            this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_WJLDSum", dt1));
            this.ReportViewer1.LocalReport.Refresh();
        }
Ejemplo n.º 2
0
        protected void BindReportDataSource()
        {
            DateTime start    = Convert.ToDateTime(this.StartDate.Text);
            DateTime end      = Convert.ToDateTime(this.EndDate.Text);
            string   center   = (this.Center.Text).ToString();
            string   station  = (this.Station.Text);
            string   name     = (this.Name.Text).ToString();
            string   workCode = (this.WorkCode.Text).ToString();
            string   type     = (this.DropDownList_Type.Text).ToString();
            string   start1   = start.ToString();
            string   end1     = end.ToString();

            this.ReportViewer1.LocalReport.DataSources.Clear();
            this.ReportViewer1.LocalReport.ReportPath = Server.MapPath(@"~/Reports/TJ_FYSJ.rdlc");
            Microsoft.Reporting.WebForms.ReportParameter st = new Microsoft.Reporting.WebForms.ReportParameter("StartTime", start1);
            Microsoft.Reporting.WebForms.ReportParameter ed = new Microsoft.Reporting.WebForms.ReportParameter("EndTime", end1);
            this.ReportViewer1.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter[] { st, ed });
            TJDAL     dal = new TJDAL();
            DataTable dt  = dal.Get_TJ_FYSJ(start, end, center, station, name, workCode, type);

            this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_FYSJ", dt));
            DataTable dt1 = dal.Get_TJ_FYSJ_CenterTime(start, end, station, name, workCode, type);

            this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_FYSJ_CenterTime", dt1));
            this.ReportViewer1.LocalReport.Refresh();
        }
        private void Data_Binding()
        {
            string ReportTime   = Server.UrlDecode(Request.QueryString["ReportTime"]);
            string MaterialType = Request.QueryString["MaterialType"];

            this.ReportViewer1.LocalReport.DataSources.Clear();
            this.ReportViewer1.LocalReport.ReportPath = Server.MapPath(@"~/Reports/TJ_IMBalanceDetial.rdlc");
            TJDAL     dal = new TJDAL();
            DataTable dt  = dal.Get_BalanceDetial(ReportTime, MaterialType);

            this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_BalanceDetial", dt));
            this.ReportViewer1.LocalReport.Refresh();
        }
        private void Data_Binding(string type)
        {
            string month = this.TextMonth.Text;

            string newtype = type;

            this.ReportViewer1.LocalReport.DataSources.Clear();
            this.ReportViewer1.LocalReport.ReportPath = Server.MapPath(@"~/Reports/TJ_IMBalanceTotal.rdlc");
            TJDAL     dal = new TJDAL();
            DataTable dt  = dal.Get_BalanceTotal(month, newtype);

            this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_BalanceTotal", dt));
            this.ReportViewer1.LocalReport.Refresh();
        }
        protected void btnCar_Click(object sender, EventArgs e)
        {
            TJDAL dal = new TJDAL();
            List <CheckModelExt> lm = dal.GetTDictionaryIDByParentID("MaterialType-9999");

            string ret = "";

            for (int i = 0; i < lm.Count; i++)
            {
                ret += lm[i].ID.ToString() + "','";
            }
            ret = ret.TrimEnd(',');

            type = ret;
            Data_Binding(type);
        }
        protected void BindReportDataSource()
        {
            string year  = (this.Year.Text).ToString();
            string month = (this.Month.Text).ToString();

            this.ReportViewer1.LocalReport.DataSources.Clear();
            this.ReportViewer1.LocalReport.ReportPath = Server.MapPath(@"~/Reports/TJ_PDDHMRFZ.rdlc");
            Microsoft.Reporting.WebForms.ReportParameter st = new Microsoft.Reporting.WebForms.ReportParameter("StartTime", year);
            Microsoft.Reporting.WebForms.ReportParameter ed = new Microsoft.Reporting.WebForms.ReportParameter("EndTime", month);
            this.ReportViewer1.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter[] { st, ed });
            TJDAL     dal = new TJDAL();
            DataTable dt  = dal.Get_PDDHMRFZ(year, month);

            this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_PDDHMRFZ", dt));
            this.ReportViewer1.LocalReport.Refresh();
        }
        protected void BindReportDataSource()
        {
            string textMonth = Convert.ToString(this.textMonth.Text);
            //将月份转换成那个月的起始时间和结束时间
            int mm = Convert.ToInt32(textMonth.Substring(4, 2));
            int year = Convert.ToInt32(textMonth.Substring(0, 4));
            int nextMM, nextYear, lastYear, lastMM;

            if (mm == 12)
            {
                nextMM   = 1;
                nextYear = year + 1;
            }
            else
            {
                nextMM   = mm + 1;
                nextYear = year;
            }
            if (mm == 1)
            {
                lastMM   = 12;
                lastYear = year - 1;
            }
            else
            {
                lastMM   = mm - 1;
                lastYear = year;
            }
            DateTime beginTime = Convert.ToDateTime(year.ToString() + "-" + mm.ToString() + "-1 00:00:00");
            DateTime endTime   = Convert.ToDateTime(nextYear.ToString() + "-" + nextMM.ToString() + "-1 00:00:00");

            string MaterialType = Convert.ToString(this.MaterialType.Text);

            string DeliveryStorage = Convert.ToString(this.DeliveryStorage.Text);

            this.ReportViewer1.LocalReport.DataSources.Clear();
            this.ReportViewer1.LocalReport.ReportPath = Server.MapPath(@"~/Reports/TJ_IMBalancePersonal.rdlc");
            TJDAL     dal = new TJDAL();
            DataTable dt  = dal.Get_BalancePersonal(beginTime, endTime, MaterialType, DeliveryStorage, textMonth);

            this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_BalancePersonal", dt));

            this.ReportViewer1.LocalReport.Refresh();
        }
Ejemplo n.º 8
0
        protected void BindReportDataSource()
        {
            DateTime start         = Convert.ToDateTime(this.StartDate.Text);
            DateTime end           = Convert.ToDateTime(this.EndDate.Text);
            string   telNumber     = (this.TelNumber.Text).ToString();
            string   disposeResult = (this.HiddenForResult.Value).ToString();
            string   start1        = start.ToString();
            string   end1          = end.ToString();

            this.ReportViewer1.LocalReport.DataSources.Clear();
            this.ReportViewer1.LocalReport.ReportPath = Server.MapPath(@"~/Reports/TJ_LDJL.rdlc");
            Microsoft.Reporting.WebForms.ReportParameter st = new Microsoft.Reporting.WebForms.ReportParameter("StartTime", start1);
            Microsoft.Reporting.WebForms.ReportParameter ed = new Microsoft.Reporting.WebForms.ReportParameter("EndTime", end1);
            this.ReportViewer1.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter[] { st, ed });
            TJDAL     dal = new TJDAL();
            DataTable dt  = dal.Get_LDJL(start, end, telNumber, disposeResult);

            this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_LDJL", dt));
            this.ReportViewer1.LocalReport.Refresh();
        }
        protected void BindReportDataSource()
        {
            DateTime start     = Convert.ToDateTime(this.StartDate.Text);
            DateTime end       = Convert.ToDateTime(this.EndDate.Text);
            string   center    = (this.Center.Text).ToString();
            string   station   = (this.Station.Text).ToString();
            string   name      = Convert.ToString(this.Name.Text);
            string   workCode  = Convert.ToString(this.WorkCode.Text);
            string   carNumber = (this.CarNumber.Text).ToString();
            int      time      = Convert.ToInt32(this.Time.Text);
            string   start1    = start.ToString();
            string   end1      = end.ToString();

            this.ReportViewer1.LocalReport.DataSources.Clear();
            this.ReportViewer1.LocalReport.ReportPath = Server.MapPath(@"~/Reports/" + reportName);
            Microsoft.Reporting.WebForms.ReportParameter st = new Microsoft.Reporting.WebForms.ReportParameter("StartTime", start1);
            Microsoft.Reporting.WebForms.ReportParameter ed = new Microsoft.Reporting.WebForms.ReportParameter("EndTime", end1);
            this.ReportViewer1.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter[] { st, ed });
            LSDAL dal  = new LSDAL();
            TJDAL dalt = new TJDAL();

            switch (reportName)
            {
            case "LS_SJCCQK.rdlc":     //司机出车大于5分钟流水表
                DataTable dt = dal.Get_LS_SJCCQK(start, end, center, station, name, workCode, carNumber, time);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForLS_SJCCQK", dt));
                break;

            case "TJ_SJCCDY5FZ.rdlc":     //司机出车大于5分钟统计表
                DataTable dt1 = dalt.Get_SJCCDY5FZ(start, end, center, station, name, workCode, carNumber, time);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_SJCCDY5FZ", dt1));
                break;

            default:
                break;
            }
            this.ReportViewer1.LocalReport.Refresh();
        }
Ejemplo n.º 10
0
        protected void BindReportDataSource()
        {
            DateTime start    = Convert.ToDateTime(this.StartDate.Text);
            DateTime end      = Convert.ToDateTime(this.EndDate.Text);
            string   name     = (this.Name.Text).ToString();
            string   workCode = (this.WorkCode.Text).ToString();
            string   start1   = start.ToString();
            string   end1     = end.ToString();

            this.ReportViewer1.LocalReport.DataSources.Clear();
            this.ReportViewer1.LocalReport.ReportPath = Server.MapPath(@"~/Reports/TJ_HJSJLY.rdlc");
            Microsoft.Reporting.WebForms.ReportParameter st = new Microsoft.Reporting.WebForms.ReportParameter("StartTime", start1);
            Microsoft.Reporting.WebForms.ReportParameter ed = new Microsoft.Reporting.WebForms.ReportParameter("EndTime", end1);
            this.ReportViewer1.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter[] { st, ed });
            TJDAL     dal = new TJDAL();
            DataTable dt  = dal.Get_TJ_HJSJLY(start, end, name, workCode);

            this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_HJSJLY", dt));
            DataTable dt1 = dal.Get_TJ_HJSJLY_TL(start, end, name, workCode);

            this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_HJSJLYTU", dt1));
            this.ReportViewer1.LocalReport.Refresh();
        }
Ejemplo n.º 11
0
        protected void BindReportDataSource()
        {
            DateTime start = Convert.ToDateTime(this.StartDate.Text);
            DateTime end   = Convert.ToDateTime(this.EndDate.Text);
            //string workState = (this.HiddenForStartWorkState.Value);
            string workState  = (this.HiddenForStartWorkState.Value);
            string time       = Convert.ToString(this.WorkStateTime.Text);
            string name       = Convert.ToString(this.DispatcherName.Text);
            string personCode = Convert.ToString(this.WorkNumber.Text);
            string start1     = start.ToString();
            string end1       = end.ToString();

            this.ReportViewer1.LocalReport.DataSources.Clear();
            this.ReportViewer1.LocalReport.ReportPath = Server.MapPath(@"~/Reports/" + reportName);
            Microsoft.Reporting.WebForms.ReportParameter st = new Microsoft.Reporting.WebForms.ReportParameter("StartTime", start1);
            Microsoft.Reporting.WebForms.ReportParameter ed = new Microsoft.Reporting.WebForms.ReportParameter("EndTime", end1);
            this.ReportViewer1.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter[] { st, ed });
            LSDAL dal  = new LSDAL();
            TJDAL dalt = new TJDAL();

            switch (reportName)
            {
            case "LS_DDYGZZT.rdlc":    //调度员工作状态流水表
                DataTable dt = dal.Get_LS_DDYGZZT(start, end, workState, time, name, personCode);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForLS_DDYGZZT", dt));
                break;

            case "TJ_DDYGZZT.rdlc":    //调度员工作状态统计表
                DataTable dt1 = dalt.Get_TJ_DDYGZZT(start, end, workState, name, personCode, time);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_DDYGZZT", dt1));
                break;

            default:
                break;
            }
            this.ReportViewer1.LocalReport.Refresh();
        }
Ejemplo n.º 12
0
        protected void BindReportDataSource()
        {
            DateTime beginTime = Convert.ToDateTime(this.StartDate.Text);
            DateTime endTime   = Convert.ToDateTime(this.EndDate.Text);
            string   eventType = Convert.ToString(this.txtPatientVersion.Text);
            string   txtCenter = Convert.ToString(this.Center.Text);
            string   stationID = Convert.ToString(this.Station.Text);
            // string txtCenter = Convert.ToString(this.DropDownList_Center.SelectedValue);
            //// string txtCenter = Convert.ToString(DropDownList_Center.Text);
            // string stationID = Convert.ToString(this.DropDownList_Station.SelectedValue);
            string agentID                   = Convert.ToString(this.txtAgentWorkID.Text);
            string doctorAndNurse            = Convert.ToString(this.txtDoctorAndNurse.Text);
            string txtDiseasesClassification = Convert.ToString(this.txtDiseasesClassification.Text);
            string txtIllnessClassification  = Convert.ToString(this.txtIllnessClassification.Text);
            string txtDeathCase              = Convert.ToString(this.txtDeathCase.Text);
            string txtMeasures               = Convert.ToString(this.txtMeasures.Text);
            string txtFirstAidEffect         = Convert.ToString(this.txtFirstAidEffect.Text);
            string txtFirstImpression        = Convert.ToString(this.txtFirstImpression.Text);
            string txtSendAddress            = Convert.ToString(this.txtSendAddress.Text);
            string start1 = beginTime.ToString();
            string end1   = endTime.ToString();

            this.ReportViewer1.LocalReport.DataSources.Clear();
            this.ReportViewer1.LocalReport.ReportPath = Server.MapPath(@"~/Reports/" + reportName);
            Microsoft.Reporting.WebForms.ReportParameter st = new Microsoft.Reporting.WebForms.ReportParameter("StartTime", start1);
            Microsoft.Reporting.WebForms.ReportParameter ed = new Microsoft.Reporting.WebForms.ReportParameter("EndTime", end1);
            this.ReportViewer1.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter[] { st, ed });
            TJDAL dal = new TJDAL();

            switch (reportName)
            {
            case "TJ_JZCS.rdlc":
                this.Page.Title = "救治措施统计表";
                DataTable dt = dal.Get_TJ_JZCS(beginTime, endTime, eventType, stationID, agentID, doctorAndNurse,
                                               txtCenter, txtDiseasesClassification, txtIllnessClassification, txtDeathCase, txtMeasures, txtFirstAidEffect,
                                               txtFirstImpression, txtSendAddress);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_JZCS", dt));
                break;

            case "TJ_JJPF.rdlc":
                this.Page.Title = "急救评分统计表";
                DataTable dt1 = dal.Get_TJ_JJPF(beginTime, endTime, eventType, stationID, agentID, doctorAndNurse,
                                                txtCenter, txtDiseasesClassification, txtIllnessClassification, txtDeathCase, txtMeasures, txtFirstAidEffect,
                                                txtFirstImpression, txtSendAddress);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_JJPF", dt1));
                break;

            case "TJ_BLZDSJ.rdlc":
                this.Page.Title = "出车数,病历数,重大事件数统计表";
                DataTable dt2 = dal.Get_TJ_BLZDSJ(beginTime, endTime, eventType, stationID, agentID, doctorAndNurse,
                                                  txtCenter, txtDiseasesClassification, txtIllnessClassification, txtDeathCase, txtMeasures, txtFirstAidEffect,
                                                  txtFirstImpression, txtSendAddress);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_BLZDSJ", dt2));
                break;

            case "TJ_BQFL.rdlc":
                this.Page.Title = "病情分类统计表";
                DataTable dt3 = dal.Get_TJ_BQFL(beginTime, endTime, eventType, stationID, agentID, doctorAndNurse,
                                                txtCenter, txtDiseasesClassification, txtIllnessClassification, txtDeathCase, txtMeasures, txtFirstAidEffect,
                                                txtFirstImpression, txtSendAddress);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_BQFL", dt3));
                break;

            case "TJ_JJXG.rdlc":
                this.Page.Title = "急救效果统计表";
                DataTable dt4 = dal.Get_TJ_JJXG(beginTime, endTime, eventType, stationID, agentID, doctorAndNurse,
                                                txtCenter, txtDiseasesClassification, txtIllnessClassification, txtDeathCase, txtMeasures, txtFirstAidEffect,
                                                txtFirstImpression, txtSendAddress);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_JJXG", dt4));
                break;

            case "TJ_BQYB.rdlc":
                this.Page.Title = "病情预报统计表";
                DataTable dt5 = dal.Get_TJ_BQYB(beginTime, endTime, eventType, stationID, agentID, doctorAndNurse,
                                                txtCenter, txtDiseasesClassification, txtIllnessClassification, txtDeathCase, txtMeasures, txtFirstAidEffect,
                                                txtFirstImpression, txtSendAddress);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_BQYB", dt5));
                break;

            case "TJ_HZSW.rdlc":
                this.Page.Title = "患者死亡统计表";
                DataTable dt6 = dal.Get_TJ_HZSW(beginTime, endTime, eventType, stationID, agentID, doctorAndNurse,
                                                txtCenter, txtDiseasesClassification, txtIllnessClassification, txtDeathCase, txtMeasures, txtFirstAidEffect,
                                                txtFirstImpression, txtSendAddress);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_HZSW", dt6));
                break;

            case "TJ_HC.rdlc":
                this.Page.Title = "急救耗材统计表";
                DataTable dt7 = dal.Get_TJ_HC(beginTime, endTime, eventType, stationID, agentID, doctorAndNurse,
                                              txtCenter, txtDiseasesClassification, txtIllnessClassification, txtDeathCase, txtMeasures, txtFirstAidEffect,
                                              txtFirstImpression, txtSendAddress);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_HC", dt7));
                break;

            case "TJ_XB.rdlc":
                this.Page.Title = "性别统计表";
                DataTable dt8 = dal.Get_TJ_XB(beginTime, endTime, eventType, stationID, agentID, doctorAndNurse,
                                              txtCenter, txtDiseasesClassification, txtIllnessClassification, txtDeathCase, txtMeasures, txtFirstAidEffect,
                                              txtFirstImpression, txtSendAddress);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_XB", dt8));
                break;

            case "TJ_NLD.rdlc":
                this.Page.Title = "年龄段统计表";
                DataTable dt9 = dal.Get_TJ_NLFB(beginTime, endTime, eventType, stationID, agentID, doctorAndNurse,
                                                txtCenter, txtDiseasesClassification, txtIllnessClassification, txtDeathCase, txtMeasures, txtFirstAidEffect,
                                                txtFirstImpression, txtSendAddress);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_NLDFB", dt9));
                break;

            case "TJ_SJLX.rdlc":
                this.Page.Title = "事件类型统计表";
                DataTable dt10 = dal.Get_TJ_SJLX(beginTime, endTime, eventType, stationID, agentID, doctorAndNurse,
                                                 txtCenter, txtDiseasesClassification, txtIllnessClassification, txtDeathCase, txtMeasures, txtFirstAidEffect,
                                                 txtFirstImpression, txtSendAddress);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_SJLX", dt10));
                break;

            case "TJ_BZFL.rdlc":
                this.Page.Title = "病种分类统计表";
                DataTable dt11 = dal.Get_TJ_BZFL(beginTime, endTime, eventType, stationID, agentID, doctorAndNurse,
                                                 txtCenter, txtDiseasesClassification, txtIllnessClassification, txtDeathCase, txtMeasures, txtFirstAidEffect,
                                                 txtFirstImpression, txtSendAddress);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_BZFL", dt11));
                break;

            case "TJ_QXJC.rdlc":
                this.Page.Title = "器械检查统计表";
                DataTable dt12 = dal.Get_TJ_QXJC(beginTime, endTime, eventType, stationID, agentID, doctorAndNurse,
                                                 txtCenter, txtDiseasesClassification, txtIllnessClassification, txtDeathCase, txtMeasures, txtFirstAidEffect,
                                                 txtFirstImpression, txtSendAddress);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_QXJC", dt12));
                break;

            case "TJ_YPYYL.rdlc":
                this.Page.Title = "药品用药量统计表";
                DataTable dt13 = dal.Get_TJ_YPYYL(beginTime, endTime, eventType, stationID, agentID, doctorAndNurse,
                                                  txtCenter, txtDiseasesClassification, txtIllnessClassification, txtDeathCase, txtMeasures, txtFirstAidEffect,
                                                  txtFirstImpression, txtSendAddress);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_YPYYL", dt13));
                break;

            case "TJ_JJZLJC.rdlc":
                this.Page.Title = "拒绝治疗、体检、器械检查、提供病史统计表";
                DataTable dt14 = dal.Get_TJ_JJZLJC(beginTime, endTime, eventType, stationID, agentID, doctorAndNurse,
                                                   txtCenter, txtDiseasesClassification, txtIllnessClassification, txtDeathCase, txtMeasures, txtFirstAidEffect,
                                                   txtFirstImpression, txtSendAddress);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_JJZLJC", dt14));
                break;

            case "TJ_HJYY.rdlc":
                this.Page.Title = "呼救医院统计表";
                DataTable dt15 = dal.Get_TJ_HJYY(beginTime, endTime, eventType, stationID, agentID, doctorAndNurse,
                                                 txtCenter, txtDiseasesClassification, txtIllnessClassification, txtDeathCase, txtMeasures, txtFirstAidEffect,
                                                 txtFirstImpression, txtSendAddress);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_HJYY", dt15));
                break;

            case "TJ_SDYY.rdlc":
                this.Page.Title = "送达医院统计表";
                DataTable dt16 = dal.Get_TJ_SDYY(beginTime, endTime, eventType, stationID, agentID, doctorAndNurse,
                                                 txtCenter, txtDiseasesClassification, txtIllnessClassification, txtDeathCase, txtMeasures, txtFirstAidEffect,
                                                 txtFirstImpression, txtSendAddress);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_SDYY", dt16));
                break;

            case "TJ_RWLX.rdlc":
                this.Page.Title = "任务类型统计表";
                DataTable dt17 = dal.Get_TJ_RWLX(beginTime, endTime, eventType, stationID, agentID, doctorAndNurse,
                                                 txtCenter, txtDiseasesClassification, txtIllnessClassification, txtDeathCase, txtMeasures, txtFirstAidEffect,
                                                 txtFirstImpression, txtSendAddress);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_RWLX", dt17));
                break;

            case "TJ_HF.rdlc":
                this.Page.Title = "回访统计表";
                DataTable dt18 = dal.Get_TJ_HF(beginTime, endTime, eventType, stationID, agentID, doctorAndNurse,
                                               txtCenter, txtDiseasesClassification, txtIllnessClassification, txtDeathCase, txtMeasures, txtFirstAidEffect,
                                               txtFirstImpression, txtSendAddress);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_HF", dt18));
                break;

            default:
                break;
            }
            this.ReportViewer1.LocalReport.Refresh();
        }
Ejemplo n.º 13
0
        protected void BindReportDataSource()
        {
            DateTime start  = Convert.ToDateTime(this.StartDate.Text);
            DateTime end    = Convert.ToDateTime(this.EndDate.Text);
            string   start1 = start.ToString();
            string   end1   = end.ToString();

            this.ReportViewer1.LocalReport.DataSources.Clear();
            this.ReportViewer1.LocalReport.ReportPath = Server.MapPath(@"~/Reports/" + reportName);
            Microsoft.Reporting.WebForms.ReportParameter st = new Microsoft.Reporting.WebForms.ReportParameter("StartTime", start1);
            Microsoft.Reporting.WebForms.ReportParameter ed = new Microsoft.Reporting.WebForms.ReportParameter("EndTime", end1);
            this.ReportViewer1.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter[] { st, ed });
            LSDAL dal  = new LSDAL();
            TJDAL dalt = new TJDAL();

            switch (reportName)
            {
            case "LS_ZDTFXZHSG.rdlc":     //重大突发性灾害事故流水表
                this.Page.Title = "重大突发性灾害事故流水表";
                DataTable dt = dal.Get_LS_ZDTFXZHSG(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForLS_ZDTFXZHSG", dt));
                break;

            case "LS_DDRZ.rdlc":     //调度日志流水表
                this.Page.Title = "调度日志流水表";
                DataTable dt1 = dal.Get_LS_DDRZ(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForLS_DDRZ", dt1));
                break;

            case "LS_FSTZ.rdlc":     //发送通知流水表
                this.Page.Title = "发送通知流水表";
                DataTable dt2 = dal.Get_LS_FSTZ(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForLS_FSTZ", dt2));
                break;

            case "LS_RCJJDDLFDSJD.rdlc":     //日常急救到达率分段(时间段)表
                this.Page.Title = "日常急救到达率分段(时间段)表";
                DataTable dt3 = dal.Get_LS_RCJJDDLFDSJD(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForLS_RCJJDDLFDSJD", dt3));
                DataTable dte = dal.Get_LS_RCJJDDLFDSJDSum(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForLS_RCJJDDLFDSJDSum", dte));
                break;

            case "LS_SJDWCGL.rdlc":     //手机定位成功率统计表
                this.Page.Title = "手机定位成功率统计表";
                DataTable dt4 = dal.Get_LS_SJDWCGL(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForLS_SJDWCGL", dt4));
                break;

            case "LS_WZBRBQYBDJ.rdlc":     //危重病人病情预报登记表
                this.Page.Title = "危重病人病情预报登记表";
                DataTable dt5 = dal.Get_LS_WZBRBQYBDJ(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForLS_WZBRBQYBDJ", dt5));
                break;

            case "LS_YYGZDJ.rdlc":     //医院搁置担架统计表
                this.Page.Title = "医院搁置担架统计表";
                DataTable dt6 = dal.Get_LS_YYGZDJ(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForLS_YYGZDJ", dt6));
                break;

            case "LS_YYGZJHCDJYXCC.rdlc":     //医院搁置救护车担架影响出车统计表
                this.Page.Title = "医院搁置救护车担架影响出车统计表";
                DataTable dt7 = dal.Get_LS_YYGZJHCDJYXCC(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForLS_YYGZJHCDJYXCC", dt7));
                break;

            case "TJ_CCCSFD.rdlc":     //出车次数分段统计表
                this.Page.Title = "出车次数分段统计表";
                DataTable dt8 = dalt.Get_TJ_CCCSFD(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_CCCSFD", dt8));
                break;

            case "TJ_CCQK.rdlc":     //出车情况统计表
                this.Page.Title = "出车情况统计表";
                DataTable dt9 = dalt.Get_TJ_CCQK(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_CCQK", dt9));
                break;

            case "TJ_DDYGZL.rdlc":     //调度员工作量统计表
                this.Page.Title = "调度员工作量统计表";
                DataTable dt10 = dalt.Get_TJ_DDYGZL(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_DDYGZL", dt10));
                break;

            case "TJ_DDYGZL2.rdlc":     //调度员工作量统计表(二)
                this.Page.Title = "调度员工作量统计表(二)";
                DataTable dt11 = dalt.Get_TJ_DDYGZL2(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_DDYGZL2", dt11));
                break;

            case "TJ_DDYGZXL.rdlc":     //调度员工作效率统计表
                this.Page.Title = "调度员工作效率统计表";
                DataTable dt12 = dalt.Get_TJ_DDYGZXL(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_DDYGZXL", dt12));
                break;

            case "TJ_DJJ.rdlc":     //对讲机统计表
                this.Page.Title = "对讲机统计表";
                DataTable dt13 = dalt.Get_TJ_DJJ(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_DJJ", dt13));
                break;

            case "TJ_FCQKMX2.rdlc":     //放车情况明细统计表(二)
                this.Page.Title = "放车情况明细统计表(二)";
                DataTable dt14 = dalt.Get_TJ_FCQKMX2(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_FCQKMX2", dt14));
                break;

            case "TJ_FCQKMX1.rdlc":     //放车情况明细统计表(一)
                this.Page.Title = "放车情况明细统计表(一)";
                DataTable dt15 = dalt.Get_TJ_FCQKMX1(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_FCQKMX1", dt15));
                DataTable dt16 = dalt.Get_TJ_FCQKMX1BT1(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_FCQKMX1_BING1", dt16));
                DataTable dt17 = dalt.Get_TJ_FCQKMX1BT2(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_FCQKMX1_BING2", dt17));
                DataTable dt18 = dalt.Get_TJ_FCQKMX1ZX(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_FCQKMX1_ZHEXIAN1", dt18));
                break;

            case "TJ_FCYQYSJGX.rdlc":     //放车与区域时间关系统计表
                this.Page.Title = "放车与区域时间关系统计表";
                DataTable dt19 = dalt.Get_TJ_FCYQYSJGX(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_FCYQYSJGX", dt19));
                break;

            case "TJ_FZXBGFSXB.rdlc":     //分中心上下班问题统计表
                this.Page.Title = "分中心上下班问题统计表";
                DataTable dt20 = dalt.Get_TJ_FZXSXBWT(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_FZXBGFSXB", dt20));
                break;

            case "TJ_FZXZTDY.rdlc":     //分中心暂停调用统计表
                this.Page.Title = "分中心暂停调用统计表";
                DataTable dt21 = dalt.Get_TJ_FZXZTDY(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_FZXZTDY", dt21));
                break;

            case "TJ_HJBZQK.rdlc":     //呼病种情况统计表
                this.Page.Title = "呼病种情况统计表";
                DataTable dt22 = dalt.Get_TJ_HJBZQK(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_HJBZQK", dt22));
                DataTable dt23 = dalt.Get_TJ_HJBZQK_XBYJB(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_HJBZQK_XBYJB", dt23));
                DataTable dt24 = dalt.Get_TJ_HJBZQK_NLYJB(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_HJBZQK_NLYJB", dt24));
                break;

            case "TJ_HJDHPDFZ.rdlc":     //呼救电话排队峰值统计表
                this.Page.Title = "呼救电话排队峰值统计表";
                DataTable dt25 = dalt.Get_TJ_HJDHPDFZ(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetFor_TJ_HJDHPDFZ", dt25));
                break;

            case "TJ_HCYQYSJGX.rdlc":     //回车与区域时间关系统计表
                this.Page.Title = "回车与区域时间关系统计表";
                DataTable dt26 = dalt.Get_TJ_HCYQYSJGX(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_HCYQYSJGX", dt26));
                break;

            case "TJ_JJFYSJRB.rdlc":     //急救反应时间(日报)统计表
                this.Page.Title = "急救反应时间(日报)统计表";
                DataTable dt27 = dalt.Get_TJ_JJFYSJRB(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_JJFYSJRB", dt27));
                DataTable dt28 = dalt.Get_TJ_JJFYSJRB1(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_JJFYSJRB1", dt28));
                DataTable dt29 = dalt.Get_TJ_JJFYSJRB2(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_JJFYSJRB2", dt29));
                DataTable dt30 = dalt.Get_TJ_JJFYSJRB_CenterTime(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_JJFYSJRB_CenterTime", dt30));
                break;

            case "TJ_JBYSJGX.rdlc":     //疾病与时间关系统计表
                this.Page.Title = "疾病与时间关系统计表";
                DataTable dt32 = dalt.Get_TJ_JBYSJGX(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_JBYSJGX", dt32));
                break;

            case "TJ_RJRCCCSFB.rdlc":     //人均日出车次数分布统计表
                this.Page.Title = "人均日出车次数分布统计表";
                DataTable dt33 = dalt.Get_TJ_RJRCCCSFB(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_RJRCCCSFB", dt33));
                break;

            case "TJ_SWDDLX.rdlc":     //送往地点类型统计表
                this.Page.Title = "送往地点类型统计表";
                DataTable dt34 = dalt.Get_TJ_SWDDLX(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_SWDDLX", dt34));
                break;

            case "TJ_SWDD.rdlc":     //送往地点统计表
                this.Page.Title = "送往地点统计表";
                DataTable dt35 = dalt.Get_TJ_SWDD(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_SWDD", dt35));
                break;

            case "TJ_WZBRBQYBDJ.rdlc":     //危重病人病情预报登记统计表
                this.Page.Title = "危重病人病情预报登记统计表";
                DataTable dt36 = dalt.Get_TJ_WZBRBQYBDJ(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_WZBRBQYBDJ", dt36));
                break;

            case "TJ_WJSFCSJFX.rdlc":     //未及时放车时间分析表
                this.Page.Title = "未及时放车时间分析表";
                DataTable dt37 = dalt.Get_TJ_WJSFCSJFX(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_WJSFCSJFX", dt37));
                break;

            case "TJ_XCDD.rdlc":     //现场地点统计表
                this.Page.Title = "现场地点统计表";
                DataTable dt38 = dalt.Get_TJ_XCDD(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_XCDD", dt38));
                break;

            case "TJ_ZFZXCS.rdlc":     //转分中心次数统计表
                this.Page.Title = "转分中心次数统计表";
                DataTable dt39 = dalt.Get_TJ_ZFZXCS(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_ZFZXCS", dt39));
                break;

            case "TJ_ZYSJ.rdlc":     //转院数据统计表
                this.Page.Title = "转院数据统计表";
                DataTable dt40 = dalt.Get_TJ_ZYSJ(start, end);
                this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetForTJ_ZYSJ", dt40));
                break;

            default:
                break;
            }
            this.ReportViewer1.LocalReport.Refresh();
        }