/// <summary> /// 删除字段配置 /// </summary> /// <param name="TableInfo"></param> /// <param name="FieldName"></param> public static void DeleteFieldConfig(TableConfig TableInfo, List <string> FieldList) { oleDb.BeginTransaction(); try { foreach (string FieldName in FieldList) { string strWhere = Tables.base_table_config.TABLE_DB_NAME + oleDb.EuqalTo() + "'" + TableInfo.BASE_TABLE_DB_NAME.ToString() + "' And " + Tables.base_table_config.FIELD_DB_NAME + oleDb.EuqalTo() + "'" + FieldName + "'"; BindEntity <BASE_TABLE_CONFIG> .CreateInstanceDAL(oleDb).Delete(strWhere); } oleDb.CommitTransaction(); } catch { oleDb.RollbackTransaction(); } }
/// <summary> /// 删除表配置 /// </summary> /// <param name="Config"></param> public static void DeleteTableConfig(TableConfig Config) { string strWhere1 = Tables.base_vindicate_table.BASE_TABLE_DB_NAME + oleDb.EuqalTo() + "'" + Config.BASE_TABLE_DB_NAME + "'"; string strWhere2 = Tables.base_table_config.TABLE_DB_NAME + oleDb.EuqalTo() + "'" + Config.BASE_TABLE_DB_NAME + "'"; oleDb.BeginTransaction(); try { BindEntity <BASE_TABLE_CONFIG> .CreateInstanceDAL(oleDb).Delete(strWhere2); BindEntity <BASE_VINDICATE_TABLE> .CreateInstanceDAL(oleDb).Delete(strWhere1); oleDb.CommitTransaction(); } catch (Exception err) { oleDb.RollbackTransaction(); (new ErrorController()).LogEvent(err.Message + "\r\n" + err.StackTrace); throw new Exception("删除表配置发生错误!"); } }
/// <summary> /// 更新表配置 /// </summary> /// <param name="Config"></param> public static void UpdateTableConfig(TableConfig Config) { string strWhere = Tables.base_vindicate_table.BASE_TABLE_DB_NAME + oleDb.EuqalTo() + "'" + Config.BASE_TABLE_DB_NAME + "'"; BASE_VINDICATE_TABLE table = BindEntity <BASE_VINDICATE_TABLE> .CreateInstanceDAL(oleDb).GetModel(strWhere); if (table == null) { throw new Exception("表名不存在!"); } try { BindEntity <BASE_VINDICATE_TABLE> .CreateInstanceDAL(oleDb).Update(strWhere, Tables.base_vindicate_table.BASE_TABLE_CN_NAME + oleDb.EuqalTo() + "'" + Config.BASE_TABLE_CN_NAME + "'", Tables.base_vindicate_table.ALLOW_USER_EDIT + oleDb.EuqalTo() + (Config.ALLOW_USER_EDIT ? "1" : "0")); } catch (Exception err) { (new ErrorController()).LogEvent(err.Message + "\r\n" + err.StackTrace); throw new Exception("保存表配置发生错误!"); } }