/// <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("保存表配置发生错误！");
}
}
