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); } }