示例#1
0
        private void butOK_Click(object sender, EventArgs e)
        {
            DataTable tablePats = KPIRecallBacklog.GetRecallBacklog(dtpStart.Value, dtpEnd.Value);

            ReportComplex report = new ReportComplex(true, false);

            report.ReportName = Lan.g(this, "Backlog of Recall Patients");
            report.AddTitle("Title", Lan.g(this, "Backlog of Recall Patients"));
            report.AddSubTitle("Date", dtpStart.Value.ToShortDateString() + " - " + dtpEnd.Value.ToShortDateString());
            QueryObject query;

            query = report.AddQuery(tablePats, "", "", SplitByKind.None, 0);
            query.AddColumn("Name", 90, FieldValueType.String);
            query.AddColumn("Gender", 60, FieldValueType.String);
            query.AddColumn("Contact Method", 100, FieldValueType.String);
            query.AddColumn("Phone", 100, FieldValueType.String);
            query.AddColumn("Email", 120, FieldValueType.String);
            query.AddColumn("Hygienist ID (Last Appt)", 60, FieldValueType.String);
            query.AddColumn("Date of Last Recall", 90, FieldValueType.String);
            query.AddColumn("Due Date", 90, FieldValueType.String);
            query.AddGroupSummaryField("Patient Count", "Gender", "Name", SummaryOperation.Count);
            report.AddPageNum();
            if (!report.SubmitQueries())
            {
                return;
            }
            FormReportComplex FormR = new FormReportComplex(report);

            FormR.ShowDialog();
            //DialogResult=DialogResult.OK;
        }
示例#2
0
        public void GetPatientsOnRecall()
        {
            var       startDate = new DateTime(2016, 3, 20);
            var       endDate   = new DateTime(2017, 4, 2);
            DataTable test      = KPIRecallBacklog.GetRecallBacklog(startDate, endDate);

            Assert.IsNotNull(test);
            Assert.AreEqual(1, test.Rows.Count);
        }