public DictionaryField(DictionaryFieldModel dictionaryField_, bool primaryKey_, DictionaryFieldModel dictionaryFieldModelForeignKey_ = null) : base() { this.columnName = dictionaryField_.columnName; this.dictionaryID = dictionaryField_.dictionaryID; this.domainValueTypeID = dictionaryField_.domainValueTypeID; this.ID = dictionaryField_.ID; this.name = dictionaryField_.name; this.primaryKey = primaryKey_; this.foreignKey = dictionaryFieldModelForeignKey_; this.foreignKeyColumnName = this.foreignKey == null ? null : this.foreignKey.name; }
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 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 ResponsePackage SaveDictionaryField(DictionaryFieldModel field) { RequestObjectPackage<DictionaryFieldModel> fieldRequest = new RequestObjectPackage<DictionaryFieldModel>() { requestData = field }; ResponsePackage response = new DBUtils().RunSqlAction(new DictionaryTypesAdministrator().SaveDictionaryField, fieldRequest); response.ThrowExceptionIfError(); return response; }
public JsonResult SaveDictionaryField(DictionaryFieldModel field) { try { ResponsePackage result = new DictionaryTypeAdministratorLogic().SaveDictionaryField(field); return Json(result); } catch (Exception ex) { return this.HandleException(ex); } }