internal static SqlDataReader IPDPatientTreatmentSheetSearch(string searchText, DateTime dateFrom, DateTime dateTo) { SqlDataReader r = null; using (SqlCommand cmd = AppDatabase.GetStoreProcCommand(IPDPatientTreatmentSheet_Search)) { AppDatabase.AddInParameter(cmd, "@SearchText", SqlDbType.NVarChar, AppShared.ToDbLikeText(searchText)); AppDatabase.AddInParameter(cmd, "@DateFrom", SqlDbType.DateTime, AppShared.ToDbValueNullable(dateFrom)); AppDatabase.AddInParameter(cmd, "@DateTo", SqlDbType.DateTime, AppShared.ToDbValueNullable(dateTo)); AppDatabase db = OpenDatabase(); if (db != null) { r = db.GetSqlDataReader(cmd); } } return(r); }
//internal static SqlDataReader PatientSelectAll() //{ // return GetReader(Patient_SelectAll); //} internal static SqlDataReader PatientSearch(string searchText, bool IsIpd, bool IsOPD, int isDischarge, DateTime dateFrom, DateTime dateTo) { SqlDataReader r = null; using (SqlCommand cmd = AppDatabase.GetStoreProcCommand(Patient_Search)) { AppDatabase.AddInParameter(cmd, "@SearchText", SqlDbType.NVarChar, AppShared.ToDbLikeText(searchText)); AppDatabase.AddInParameter(cmd, "@IsIpd", SqlDbType.Bit, IsIpd); AppDatabase.AddInParameter(cmd, "@IsOpd", SqlDbType.Bit, IsOPD); AppDatabase.AddInParameter(cmd, "@IsDischarge", SqlDbType.Int, isDischarge); AppDatabase.AddInParameter(cmd, "@DateFrom", SqlDbType.DateTime, AppShared.ToDbValueNullable(dateFrom)); AppDatabase.AddInParameter(cmd, "@DateTo", SqlDbType.DateTime, AppShared.ToDbValueNullable(dateTo)); AppDatabase db = OpenDatabase(); if (db != null) { r = db.GetSqlDataReader(cmd); } } return(r); }
internal static SqlDataReader MedicinesSearch(string SearchText) { return(GetReader(Medicines_Search, "@SearchText", SqlDbType.NVarChar, AppShared.ToDbLikeText(SearchText))); }
internal static SqlDataReader UserRoleSearch(string searchText) { return(GetReader(UserRole_Search, "@SearchText", SqlDbType.NVarChar, AppShared.ToDbLikeText(searchText))); }
//internal static SqlDataReader PatientSelectAll() //{ // return GetReader(Patient_SelectAll); //} internal static SqlDataReader PatientBillSearch(string searchText) { return(GetReader(PatientBill_Search, "@SearchText", SqlDbType.NVarChar, AppShared.ToDbLikeText(searchText))); }
internal static SqlDataReader LabInvestigationSearch(string SearchText) { return(GetReader(LabInvestigation_Search, "@SearchText", SqlDbType.NVarChar, AppShared.ToDbLikeText(SearchText))); }
internal static SqlDataReader OPDTreatmentSearch(string SearchText) { return(GetReader(Treatment_Search, "@SearchText", SqlDbType.NVarChar, AppShared.ToDbLikeText(SearchText))); }
internal static SqlDataReader CategorySearch(string SearchText) { return(GetReader(Category_Search, "@SearchText", SqlDbType.NVarChar, AppShared.ToDbLikeText(SearchText))); }
internal static SqlDataReader ReferenceDoctorSearch(string searchText) { return(GetReader(ReferenceDoctor_Search, "@SearchText", SqlDbType.NVarChar, AppShared.ToDbLikeText(searchText))); }
internal static SqlDataReader AssociateComplainSearch(string SearchText) { return(GetReader(AssociateComplain_Search, "@SearchText", SqlDbType.NVarChar, AppShared.ToDbLikeText(SearchText))); }