public DictionaryTreeItem(DictionaryModel dict)
: this()
{
this.ID = dict.ID;
this.text = dict.name;
this.leaf = true;
}
public Dictionary(DictionaryModel dictionaryModel_, List<DictionaryField> fields_)
: base()
{
this.dictionaryGroupID = dictionaryModel_.dictionaryGroupID;
this.ID = dictionaryModel_.ID;
this.name = dictionaryModel_.name;
this.tableName = dictionaryModel_.tableName;
this.fields = fields_;
}
private void DropColumnForDictionaryField(DictionaryFieldModel obj, DictionaryModel dictionary, IDbConnection connectionID, IDbTransaction transactionID)
{
string sql = null;
bool isEdit = obj.ID > 0;
if (!isEdit)
{
sql = string.Format(
"alter table {0} drop {1};",
dictionary.tableName,
obj.columnName
);
DBUtils.ExecuteSQL(sql, connectionID, false, transactionID).ThrowExceptionIfError();
}
}
private void CreateTableForDictionary(DictionaryModel obj, IDbConnection connectionID, IDbTransaction transactionID)
{
string sql = null;
bool isEdit = obj.ID > 0;
if (!isEdit)
{
sql = string.Format(
"create table {0}(id integer not null primary key);",
obj.tableName
);
DBUtils.ExecuteSQL(sql, connectionID, false, transactionID).ThrowExceptionIfError();
sql = string.Format(
"create generator generator_{0};",
obj.tableName
);
DBUtils.ExecuteSQL(sql, connectionID, false, transactionID).ThrowExceptionIfError();
sql = string.Format(
"create trigger ins_{0} for {0} active " + Environment.NewLine +
"before insert position 1 " + Environment.NewLine +
"as " + Environment.NewLine +
"begin " + Environment.NewLine +
" if (new.id is null) then " + Environment.NewLine +
" new.id = gen_id (generator_{0}, 1); " + Environment.NewLine +
"end ",
obj.tableName
);
DBUtils.ExecuteSQL(sql, connectionID, false, transactionID).ThrowExceptionIfError();
}
}
private void CreateColumnForDictionaryField(DictionaryFieldModel obj, DictionaryModel dictionary, IDbConnection connectionID, IDbTransaction transactionID)
{
string sql = null;
bool isEdit = obj.ID > 0;
if (!isEdit)
{
sql = string.Format(
"alter table {0} add {1} {2};",
dictionary.tableName,
obj.columnName,
GetDBTypeByID(obj.domainValueTypeID)
);
DBUtils.ExecuteSQL(sql, connectionID, false, transactionID).ThrowExceptionIfError();
}
}
public DictionaryValue(DictionaryModel dictionary_, List<DictionaryFieldValue> fields_)
{
this.dictionary = dictionary_;
this.fields = fields_;
}
public ResponsePackage SaveDictionary(DictionaryModel dictionary)
{
RequestObjectPackage<DictionaryModel> request = new RequestObjectPackage<DictionaryModel>()
{
requestData = dictionary
};
ResponsePackage response = new DBUtils().RunSqlAction(new DictionaryTypesAdministrator().SaveDictionary, request);
response.ThrowExceptionIfError();
return response;
}
public JsonResult SaveDictionary(DictionaryModel dictionary)
{
try
{
ResponsePackage result = new DictionaryTypeAdministratorLogic().SaveDictionary(dictionary);
return Json(result);
}
catch (Exception ex)
{
return this.HandleException(ex);
}
}
