C# (CSharp) SystèmeGestionPharmacie.DAL.MSSQL DataBase示例

示例#1

 //--------------------------------------------------------------------
 public DataTable FindAll()
 {
     return(DataBase.SelectTable("[tblLigneTransactionVente]", ""));
 }

示例#2

 //--------------------------------------------------------------------
 public DataTable FindAllPourUnTransactionVente(Guid pTransactionVenteId)
 {
     return(DataBase.Select("SELECT * FROM tblLigneTransactionVente WHERE IDTransactionVente='" + pTransactionVenteId.ToString() + "'"));
 }

示例#3

 //--------------------------------------------------------------------
 public DataTable FindAll()
 {
     return(DataBase.SelectTable("[tblUtilisateur]", ""));
 }

示例#4

 //--------------------------------------------------------------------
 public DataTable FindAll()
 {
     return(DataBase.SelectTable("[tblPharmacie]", ""));
 }

示例#5

 //--------------------------------------------------------------------
 public DataTable FindAllPrescriptionTable(Session pSession)
 {
     return(DataBase.Select("SELECT * FROM tblSessionPrescription WHERE IDSession = '" + pSession.ID.ToString() + "'"));
 }

示例#6

 //--------------------------------------------------------------------
 public DataTable FindAll()
 {
     return(DataBase.SelectTable("[tblSession]", ""));
 }

示例#7

 //--------------------------------------------------------------------
 public DataTable FindAllTransactionVenteTable(Session pSession)
 {
     return(DataBase.Select("SELECT * FROM tblSessionTransactionVente WHERE IDSession = '" + pSession.ID.ToString() + "'"));
 }