/// <summary> /// 增加表配置 /// </summary> /// <param name="Config"></param> public static void AddTableConfig(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).Add(new string[] { Tables.base_vindicate_table.BASE_TABLE_DB_NAME, Tables.base_vindicate_table.BASE_TABLE_CN_NAME, Tables.base_vindicate_table.ALLOW_USER_EDIT }, new string[] { "'" + Config.BASE_TABLE_DB_NAME + "'", "'" + Config.BASE_TABLE_CN_NAME + "'", (Config.ALLOW_USER_EDIT ? "1":"0") }, new bool[] { false, false, false }); } catch (Exception err) { (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("保存表配置发生错误!"); } }