public DataSet GetFreeTableColumns(int docTypeID, string curColumn)
{
var fieldData = new FieldDALC(connectionString);
return(GetData("SELECT " + nameField + ", " + typeField +
" FROM " + tableName + " WHERE (" +
colorderField + " > " +
"( SELECT " +
colorderField +
" FROM " + tableName +
" WHERE " + nameField + " = '" + editedField + "'" +
"))" +
" AND " +
"((" +
nameField + " NOT IN " +
"( SELECT " +
fieldData.TableColumnField +
" FROM " + fieldData.TableName +
" WHERE " + fieldData.DocTypeIDField + " = @DocTypeID" +
")) OR (" +
nameField + " = @CurColumn))",
delegate(SqlCommand cmd)
{
AddParam(cmd, "@DocTypeID", SqlDbType.Int, docTypeID);
AddParam(cmd, "@CurColumn", SqlDbType.NVarChar, curColumn);
}));
}
public DocTypeLinksDALC(string connectionString) : base(connectionString)
{
tableName = "ƒокументы.dbo.—в¤зи“иповƒокументов";
var docTypeData = new DocTypeDALC(connectionString);
docTypeTableName = docTypeData.TableName;
docTypeIDField = docTypeData.IDField;
nameField = docTypeData.NameField;
var fieldData = new FieldDALC(connectionString);
docFieldTable = fieldData.TableName;
docFieldNameField = fieldData.NameField;
if (Thread.CurrentThread.CurrentUICulture.TwoLetterISOLanguageName.Equals("ru"))
{
nameLangField = docTypeData.NameField + " + ' ' + " + docTypeData.AddNameField;
docFieldNameLangField = fieldData.NameField;
}
else
{
nameLangField = docTypeData.TypeDocField + " + ' ' + " + docTypeData.AddNameEngField;
docFieldNameLangField = fieldData.FieldNameEngField;
}
}
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;
}