internal static DataTable OPDTreatmentData(DateTime dt)
{
DataTable r = null;
using (SqlCommand cmd = AppDatabase.GetStoreProcCommand(OPDTreatment_Report))
{
AppDatabase.AddInParameter(cmd, "@Date", SqlDbType.DateTime, AppShared.ToDbValueNullable(dt));
AppDatabase db = OpenDatabase();
if (db != null)
{
r = db.GetDataTable(cmd);
}
}
return(r);
}
//internal static DataTable IPDPatientTreamentSheetReport(Guid IPDPatientTreatmentSheetGuid)
//{
// return GetDataTable(IPDPatientTreamentSheetReports, Report.Columns.IPDPatientTreatmentSheetGuid, IPDPatientTreatmentSheetGuid);
//}
internal static DataTable IPDPatientVitalByDate(Guid patientGuid, DateTime treatMentDate)
{
DataTable r = null;
using (SqlCommand cmd = AppDatabase.GetStoreProcCommand(IPDPatientVitalReport_ByDate))
{
AppDatabase.AddInParameter(cmd, "@PatientGuid", SqlDbType.UniqueIdentifier, AppShared.ToDbValueNullable(patientGuid));
AppDatabase.AddInParameter(cmd, "@IPDPatientTreatmentSheetDate", SqlDbType.DateTime, AppShared.ToDbValueNullable(treatMentDate));
AppDatabase db = OpenDatabase();
if (db != null)
{
r = db.GetDataTable(cmd);
}
}
return(r);
}
internal static DataTable OPDAppointmentReport7Days(DateTime fromDate, DateTime toDate)
{
DataTable r = null;
using (SqlCommand cmd = AppDatabase.GetStoreProcCommand(OPDAppointment_Report7Days))
{
AppDatabase.AddInParameter(cmd, "@AppointmentDateFrom", SqlDbType.DateTime, AppShared.ToDbValueNullable(fromDate));
AppDatabase.AddInParameter(cmd, "@AppointmentDateTo", SqlDbType.DateTime, AppShared.ToDbValueNullable(toDate));
AppDatabase db = OpenDatabase();
if (db != null)
{
r = db.GetDataTable(cmd);
}
}
return(r);
//return GetDataTable(OPDAppointment_Report7Days);
}