C# 클래스 lnhpd.DBConnection

파일 보기 프로젝트 열기: hres/api-lnhpd

Private Properties

프로퍼티 타입 설명

공개 메소드들

메소드 설명
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

메소드 상세

DBConnection() 공개 메소드

public DBConnection ( string lang ) : System
lang string
리턴 System

GetAllIngredient() 공개 메소드

public GetAllIngredient ( string lang ) : List
lang string
리턴 List

GetAllIngredientQuantity() 공개 메소드

public GetAllIngredientQuantity ( string lang ) : List
lang string
리턴 List

GetAllIngredientQuantityByMatrixId() 공개 메소드

public GetAllIngredientQuantityByMatrixId ( int matrix_id, string lang ) : List
matrix_id int
lang string
리턴 List

GetAllIngredientSource() 공개 메소드

public GetAllIngredientSource ( string lang ) : List
lang string
리턴 List

GetAllIngredientSubmission() 공개 메소드

public GetAllIngredientSubmission ( string lang ) : List
lang string
리턴 List

GetAllProductByCriteria() 공개 메소드

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

GetAllProductBySingleTerm() 공개 메소드

public GetAllProductBySingleTerm ( string term, string lang ) : List
term string
lang string
리턴 List

GetAllProductDose() 공개 메소드

public GetAllProductDose ( string lang ) : List
lang string
리턴 List

GetAllProductLicence() 공개 메소드

public GetAllProductLicence ( string lang ) : List
lang string
리턴 List

GetAllProductPurpose() 공개 메소드

public GetAllProductPurpose ( string lang ) : List
lang string
리턴 List

GetAllProductRisk() 공개 메소드

public GetAllProductRisk ( string lang ) : List
lang string
리턴 List

GetAllProductRiskText() 공개 메소드

public GetAllProductRiskText ( string lang ) : List
lang string
리턴 List

GetAllProductRiskTextByRiskId() 공개 메소드

public GetAllProductRiskTextByRiskId ( int riskId, string lang ) : List
riskId int
lang string
리턴 List

GetAllProductRoute() 공개 메소드

public GetAllProductRoute ( string lang ) : List
lang string
리턴 List

GetIngredientById() 공개 메소드

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

GetIngredientQuantityById() 공개 메소드

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

GetIngredientSourceById() 공개 메소드

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

GetIngredientSubmissionById() 공개 메소드

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

GetMedIngredientByLicenceNumber() 공개 메소드

public GetMedIngredientByLicenceNumber ( int licenceNumber, string lang ) : List
licenceNumber int
lang string
리턴 List

GetNonMedIngredientByLicenceNumber() 공개 메소드

public GetNonMedIngredientByLicenceNumber ( int licenceNumber, string lang ) : List
licenceNumber int
lang string
리턴 List

GetProductDoseById() 공개 메소드

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

GetProductDoseByLicenceNumber() 공개 메소드

public GetProductDoseByLicenceNumber ( int licenceNumber, string lang ) : List
licenceNumber int
lang string
리턴 List

GetProductLicenceById() 공개 메소드

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

GetProductPurposeById() 공개 메소드

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

GetProductPurposeByLicenceNumber() 공개 메소드

public GetProductPurposeByLicenceNumber ( int licenceNumber, string lang ) : List
licenceNumber int
lang string
리턴 List

GetProductRiskById() 공개 메소드

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

GetProductRiskTextById() 공개 메소드

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

GetProductRouteById() 공개 메소드

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

GetProductRouteByLicenceNumber() 공개 메소드

public GetProductRouteByLicenceNumber ( int licenceNumber, string lang ) : List
licenceNumber int
lang string
리턴 List

GetRiskByLicenceNumber() 공개 메소드

public GetRiskByLicenceNumber ( int licenceNumber, string lang ) : List
licenceNumber int
lang string
리턴 List

GetSecondaryBrandNameList() 공개 메소드

public GetSecondaryBrandNameList ( int licenceNumber, string lang ) : List
licenceNumber int
lang string
리턴 List

mergeMedIngredientRow() 공개 메소드

public mergeMedIngredientRow ( List medInglist, List newMedInglist ) : List
medInglist List
newMedInglist List
리턴 List