public FieldDALC(string connectionString) : base(connectionString)
{
tableName = "Документы.dbo.ПоляДокументов";
idField = "КодПоляДокумента";
nameField = "ПолеДокумента";
docData = new DocumentDALC(connectionString);
docTable = docData.TableName;
docIDField = docData.IDField;
fieldTypeData = new FieldTypeDALC(connectionString);
fieldTypeTableName = fieldTypeData.TableName;
fieldTypeNameField = fieldTypeData.FieldNameField;
}
public WorkDocDALC(string connectionString)
: base(connectionString)
{
tableName = "Документы.dbo.vwДокументыВРаботе";
idField = "КодДокументаВРаботе";
nameField = null;
docData = new DocumentDALC(null);
docIDField = docData.IDField;
employeeData = new EmployeeDALC(null);
empIDField = employeeData.IDField;
folderData = new FolderDALC(null);
folderIDField = folderData.IDField;
}
public DocLinksDALC(string connectionString)
: base(connectionString)
{
tableName = "vwСвязиДокументов";
idField = "КодСвязиДокументов";
nameField = "";
FieldDALC fieldData;
EmployeeDALC empData;
MessageDALC messData;
DocTypeDALC typesData;
fieldData = new FieldDALC(connectionString);
fieldTable = fieldData.TableName;
subFieldField = fieldData.NameField;
subFieldOrderField = fieldData.PositionField;
var docData = new DocumentDALC(connectionString);
docTable = docData.TableName;
documentIDField = docData.IDField;
documentNameField = docData.NameField;
documentDateField = docData.DateField;
documentDescriptionField = docData.DescriptionField;
spDocRights = docData.SpDocRights;
inWorkField = docData.InWorkField;
messData = new MessageDALC(connectionString);
spSendMessage = messData.SpSendMessage;
empData = new EmployeeDALC(connectionString);
empIDField = empData.IDField;
empField = Thread.CurrentThread.CurrentUICulture.TwoLetterISOLanguageName.Equals("ru") ? empData.NameField : empData.EmloyeeField;
empTable = empData.TableName;
typesData = new DocTypeDALC(connectionString);
typesTable = typesData.TableName;
typesIDField = typesData.IDField;
typesNameField = typesData.NameField;
typesNameEngField = typesData.TypeDocField;
}
public FaxDALC(string connectionString) : base(connectionString)
{
tableName = "vwФаксы";
idField = "КодФакса";
nameField = null;
var docData = new DocumentDALC(null);
documentIDField = docData.IDField;
docImageData = new DocImageDALC(null);
docImageIDField = docImageData.IDField;
faxFolderData = new FaxFolderDALC(null);
faxFolderIDField = faxFolderData.IDField;
multiSelectString =
"DATEADD(hour, @Diff, " + transferEndDateField + ") AS " + dateField + ", " +
folderFaxIDField + ", " +
directionField + ", " +
descriptionField + ", " +
senderField + ", " +
senderAddressField + ", " +
csidField + ", " +
recipField + ", " +
recvAddressField + ", " +
tableName + "." + idField + ", " +
fileNameField + ", " +
statusField + ", " +
readField + ", " +
spamField + ", ";
caseAddString =
"CASE WHEN EXISTS (SELECT * FROM " + faxDocImageTable + " (nolock) " +
" WHERE " + faxDocImageTable + "." + idField + " = " + tableName + "." + idField +
") THEN CONVERT(bit, 1) ELSE CONVERT(bit, 0) END " + savedField;
multiOrderByString =
" ORDER BY " + dateField + " DESC";
}
/// <summary>
/// Инициализация поставщика
/// </summary>
public static void Init(string connectionStringDocument)
{
_connectionStringDocument = connectionStringDocument;
_docDalc = new DocumentDALC(_connectionStringDocument);
}
