C# Class lnhpd.DBConnection

ファイルを表示 Open project: hres/api-lnhpd

Private Properties

Property Type Description

Public Methods

Method Description
DBConnection ( string lang ) : System
GetAllIngredient ( string lang ) : List
GetAllIngredientQuantity ( string lang ) : List
GetAllIngredientQuantityByMatrixId ( int matrix_id, string lang ) : List
GetAllIngredientSource ( string lang ) : List
GetAllIngredientSubmission ( string lang ) : List
GetAllProductByCriteria ( string brandname, string ingredient, string companyname, string din, string lang ) : List
GetAllProductBySingleTerm ( string term, string lang ) : List
GetAllProductDose ( string lang ) : List
GetAllProductLicence ( string lang ) : List
GetAllProductPurpose ( string lang ) : List
GetAllProductRisk ( string lang ) : List
GetAllProductRiskText ( string lang ) : List
GetAllProductRiskTextByRiskId ( int riskId, string lang ) : List
GetAllProductRoute ( string lang ) : List
GetIngredientById ( int id, string lang ) : Ingredient
GetIngredientQuantityById ( int id, string lang ) : IngredientQuantity
GetIngredientSourceById ( int id, string lang ) : IngredientSource
GetIngredientSubmissionById ( int id, string lang ) : IngredientSubmission
GetMedIngredientByLicenceNumber ( int licenceNumber, string lang ) : List
GetNonMedIngredientByLicenceNumber ( int licenceNumber, string lang ) : List
GetProductDoseById ( int id, string lang ) : ProductDose
GetProductDoseByLicenceNumber ( int licenceNumber, string lang ) : List
GetProductLicenceById ( int id, string lang ) : ProductLicence
GetProductPurposeById ( int id, string lang ) : ProductPurpose
GetProductPurposeByLicenceNumber ( int licenceNumber, string lang ) : List
GetProductRiskById ( int id, string lang ) : ProductRisk
GetProductRiskTextById ( int id, string lang ) : ProductRiskText
GetProductRouteById ( int id, string lang ) : ProductRoute
GetProductRouteByLicenceNumber ( int licenceNumber, string lang ) : List
GetRiskByLicenceNumber ( int licenceNumber, string lang ) : List
GetSecondaryBrandNameList ( int licenceNumber, string lang ) : List
mergeMedIngredientRow ( List medInglist, List newMedInglist ) : List

Method Details

DBConnection() public method

public DBConnection ( string lang ) : System
lang string
return System

GetAllIngredient() public method

public GetAllIngredient ( string lang ) : List
lang string
return List

GetAllIngredientQuantity() public method

public GetAllIngredientQuantity ( string lang ) : List
lang string
return List

GetAllIngredientQuantityByMatrixId() public method

public GetAllIngredientQuantityByMatrixId ( int matrix_id, string lang ) : List
matrix_id int
lang string
return List

GetAllIngredientSource() public method

public GetAllIngredientSource ( string lang ) : List
lang string
return List

GetAllIngredientSubmission() public method

public GetAllIngredientSubmission ( string lang ) : List
lang string
return List

GetAllProductByCriteria() public method

public GetAllProductByCriteria ( string brandname, string ingredient, string companyname, string din, string lang ) : List
brandname string
ingredient string
companyname string
din string
lang string
return List

GetAllProductBySingleTerm() public method

public GetAllProductBySingleTerm ( string term, string lang ) : List
term string
lang string
return List

GetAllProductDose() public method

public GetAllProductDose ( string lang ) : List
lang string
return List

GetAllProductLicence() public method

public GetAllProductLicence ( string lang ) : List
lang string
return List

GetAllProductPurpose() public method

public GetAllProductPurpose ( string lang ) : List
lang string
return List

GetAllProductRisk() public method

public GetAllProductRisk ( string lang ) : List
lang string
return List

GetAllProductRiskText() public method

public GetAllProductRiskText ( string lang ) : List
lang string
return List

GetAllProductRiskTextByRiskId() public method

public GetAllProductRiskTextByRiskId ( int riskId, string lang ) : List
riskId int
lang string
return List

GetAllProductRoute() public method

public GetAllProductRoute ( string lang ) : List
lang string
return List

GetIngredientById() public method

public GetIngredientById ( int id, string lang ) : Ingredient
id int
lang string
return lnhpdWebApi.Models.Ingredient

GetIngredientQuantityById() public method

public GetIngredientQuantityById ( int id, string lang ) : IngredientQuantity
id int
lang string
return lnhpdWebApi.Models.IngredientQuantity

GetIngredientSourceById() public method

public GetIngredientSourceById ( int id, string lang ) : IngredientSource
id int
lang string
return lnhpdWebApi.Models.IngredientSource

GetIngredientSubmissionById() public method

public GetIngredientSubmissionById ( int id, string lang ) : IngredientSubmission
id int
lang string
return lnhpdWebApi.Models.IngredientSubmission

GetMedIngredientByLicenceNumber() public method

public GetMedIngredientByLicenceNumber ( int licenceNumber, string lang ) : List
licenceNumber int
lang string
return List

GetNonMedIngredientByLicenceNumber() public method

public GetNonMedIngredientByLicenceNumber ( int licenceNumber, string lang ) : List
licenceNumber int
lang string
return List

GetProductDoseById() public method

public GetProductDoseById ( int id, string lang ) : ProductDose
id int
lang string
return lnhpdWebApi.Models.ProductDose

GetProductDoseByLicenceNumber() public method

public GetProductDoseByLicenceNumber ( int licenceNumber, string lang ) : List
licenceNumber int
lang string
return List

GetProductLicenceById() public method

public GetProductLicenceById ( int id, string lang ) : ProductLicence
id int
lang string
return lnhpdWebApi.Models.ProductLicence

GetProductPurposeById() public method

public GetProductPurposeById ( int id, string lang ) : ProductPurpose
id int
lang string
return lnhpdWebApi.Models.ProductPurpose

GetProductPurposeByLicenceNumber() public method

public GetProductPurposeByLicenceNumber ( int licenceNumber, string lang ) : List
licenceNumber int
lang string
return List

GetProductRiskById() public method

public GetProductRiskById ( int id, string lang ) : ProductRisk
id int
lang string
return lnhpdWebApi.Models.ProductRisk

GetProductRiskTextById() public method

public GetProductRiskTextById ( int id, string lang ) : ProductRiskText
id int
lang string
return lnhpdWebApi.Models.ProductRiskText

GetProductRouteById() public method

public GetProductRouteById ( int id, string lang ) : ProductRoute
id int
lang string
return lnhpdWebApi.Models.ProductRoute

GetProductRouteByLicenceNumber() public method

public GetProductRouteByLicenceNumber ( int licenceNumber, string lang ) : List
licenceNumber int
lang string
return List

GetRiskByLicenceNumber() public method

public GetRiskByLicenceNumber ( int licenceNumber, string lang ) : List
licenceNumber int
lang string
return List

GetSecondaryBrandNameList() public method

public GetSecondaryBrandNameList ( int licenceNumber, string lang ) : List
licenceNumber int
lang string
return List

mergeMedIngredientRow() public method

public mergeMedIngredientRow ( List medInglist, List newMedInglist ) : List
medInglist List
newMedInglist List
return List