/// <summary>
/// Ctor
/// </summary>
/// <param name="location">Каталог Релакс</param>
/// <param name="lpuCode">Код ЛПУ (релаксовский)</param>
/// <param name="period">Каталог текущего периода (от корневого каталога Релакс)</param>
public Pool(string location, string lpuCode, string period, SQL.Medialog medialog)
{
this.period = period;
this.lpuCode = lpuCode;
lastRecourceSubsection = Model.ProphSubsection.None;
this.medialog = medialog;
aStrings = new AdapterStrings();
aPerson = new AdapterPerson(medialog);
aInvoice = new AdapterInvoice();
aRecourse = new AdapterRecourseAux();
aService = new AdapterServiceAux();
aConcomitantDisease = new AdapterConcomitantDisease();
aOncologyDirection = new AdapterOncoDirection();
string cs = string.Format(CONNECTION_STRING, location);
connectionMain = new OleDbConnection(cs);
connectionAlt = new OleDbConnection(cs);
selectServicesTreatment = connectionAlt.CreateCommand();
selectServicesTreatment.CommandText = LocalizeQuery(Queries.SELECT_SERVICES);
AddStringParameters(selectServicesTreatment, SELECT_SERVICES_TREATMENT);
selectServicesByDate = connectionAlt.CreateCommand();
selectServicesByDate.CommandText = LocalizeQuery(Queries.SELECT_SERVICES
+ SERVICES_BY_DATE_CRITERION);
AddStringParameters(selectServicesByDate, SELECT_SERVICES_BY_DATE);
selectServicesStage1 = connectionAlt.CreateCommand();
selectServicesStage1.CommandText = LocalizeQuery(Queries.SELECT_SERVICES
+ "and (" + D3_SELECTION_STAGE1 + ")");
AddStringParameters(selectServicesStage1, SELECT_SERVICES_TREATMENT);
selectServicesStage2 = connectionAlt.CreateCommand();
selectServicesStage2.CommandText = LocalizeQuery(Queries.SELECT_SERVICES
+ "and (" + D3_SELECTION_STAGE2 + ")");
AddStringParameters(selectServicesStage2, SELECT_SERVICES_TREATMENT);
selectServicesProf = connectionAlt.CreateCommand();
selectServicesProf.CommandText = LocalizeQuery(Queries.SELECT_SERVICES
+ "and (" + D3_SELECTION_PROF + ")");
AddStringParameters(selectServicesProf, SELECT_SERVICES_TREATMENT);
selectConcomDiseases = connectionAlt.CreateCommand();
selectConcomDiseases.CommandText = LocalizeQuery(Queries.SELECT_CONCOMITANT_DISEASES);
AddStringParameters(selectConcomDiseases, SELECT_CONCOM_DISEASES);
selectDispDirections = connectionAlt.CreateCommand();
selectDispDirections.CommandText = LocalizeQuery(Queries.SELECT_DISP_ASSIGNMENTS);
AddStringParameters(selectDispDirections, PARAMETER_EVENT_RECID);
selectOnkologyDirections = connectionAlt.CreateCommand();
selectOnkologyDirections.CommandText = LocalizeQuery(Queries.SELECT_ONCO_DIRECTIONS);
AddStringParameters(selectOnkologyDirections, PARAMETER_EVENT_RECID);
selectOnkologyTreat = connectionAlt.CreateCommand();
selectOnkologyTreat.CommandText = LocalizeQuery(Queries.SELECT_ONKO_TREAT);
AddStringParameters(selectOnkologyTreat, PARAMETER_EVENT_RECID);
}
public AdapterPerson(SQL.Medialog medialog)
{
this.medialog = medialog;
}
