/// <summary>
/// 增加字段配置的默认值
/// </summary>
/// <param name="TableName"></param>
/// <param name="FieldName"></param>
public static void AddDefaultConfig(TableConfig TableInfo, string FieldName)
{
BASE_TABLE_CONFIG config = new BASE_TABLE_CONFIG();
config.TABLE_CN_NAME = TableInfo.BASE_TABLE_CN_NAME;
config.TABLE_DB_NAME = TableInfo.BASE_TABLE_DB_NAME;
config.FIELD_CN_NAME = FieldName;
config.FIELD_DB_NAME = FieldName;
config.FIELD_DB_TYPE = (int)FIELD_DB_TYPE.字符;
config.ALLOW_EDIT = 1;
config.ALLOW_EMPTY = 1;
config.MAXLENGTH = 0;
config.AUTO_INCREASE = 0;
config.FOREIGNER_FIELD_CN_NAME = "";
config.FOREIGNER_FIELD_DB_NAME = "";
config.FOREIGNER_FILTER_SQL = "";
config.FOREIGNER_TABLE = "";
config.GRID_COL_WIDTH = 75;
config.UIC_TYPE = (int)ControlType.TextBox;
config.WIDTH = 75;
config.HEIGHT = 30;
config.FIELD_MARK_TYPE = 0;
string strWhere = Tables.base_table_config.TABLE_DB_NAME + oleDb.EuqalTo() + "'" + config.TABLE_DB_NAME + "'" + oleDb.And() + Tables.base_table_config.FIELD_DB_NAME + oleDb.EuqalTo() + "'" + config.FIELD_DB_NAME + "'";
if (BindEntity <BASE_TABLE_CONFIG> .CreateInstanceDAL(oleDb).Exists(strWhere))
{
return;
}
else
{
BindEntity <BASE_TABLE_CONFIG> .CreateInstanceDAL(oleDb).Add(config);
}
}
/// <summary>
/// 更新配置
/// </summary>
/// <param name="Configs"></param>
public static void UpdateFieldConfig(List <FieldConfig> Configs)
{
oleDb.BeginTransaction();
try
{
for (int i = 0; i < Configs.Count; i++)
{
FieldConfig Config = Configs[i];
string strWhere = Tables.base_table_config.TABLE_DB_NAME + oleDb.EuqalTo() + "'" + Config.TABLE_DB_NAME + "'" + oleDb.And() + Tables.base_table_config.FIELD_DB_NAME + oleDb.EuqalTo() + "'" + Config.FIELD_DB_NAME + "'";
BASE_TABLE_CONFIG config = BindEntity <BASE_TABLE_CONFIG> .CreateInstanceDAL(oleDb).GetModel(strWhere);
if (config != null)
{
BindEntity <BASE_TABLE_CONFIG> .CreateInstanceDAL(oleDb).Update(strWhere,
Tables.base_table_config.ALLOW_EDIT + oleDb.EuqalTo() + (Config.ALLOW_EDIT ? "1" : "0"),
Tables.base_table_config.ALLOW_EMPTY + oleDb.EuqalTo() + (Config.ALLOW_EMPTY ? "1" : "0"),
Tables.base_table_config.AUTO_INCREASE + oleDb.EuqalTo() + (Config.AUTO_INCREASE ? "1" : "0"),
Tables.base_table_config.FIELD_CN_NAME + oleDb.EuqalTo() + "'" + Config.FIELD_CN_NAME + "'",
Tables.base_table_config.FIELD_DB_NAME + oleDb.EuqalTo() + "'" + Config.FIELD_DB_NAME + "'",
Tables.base_table_config.FIELD_DB_TYPE + oleDb.EuqalTo() + (int)Config.FIELD_DB_TYPE,
Tables.base_table_config.FOREIGNER_FIELD_CN_NAME + oleDb.EuqalTo() + "'" + Config.FOREIGNER_FIELD_CN_NAME + "'",
Tables.base_table_config.FOREIGNER_FIELD_DB_NAME + oleDb.EuqalTo() + "'" + Config.FOREIGNER_FIELD_DB_NAME + "'",
Tables.base_table_config.FOREIGNER_FILTER_SQL + oleDb.EuqalTo() + "'" + Config.FOREIGNER_FILTER_SQL + "'",
Tables.base_table_config.FOREIGNER_TABLE + oleDb.EuqalTo() + "'" + Config.FOREIGNER_TABLE + "'",
Tables.base_table_config.GRID_COL_WIDTH + oleDb.EuqalTo() + Config.GRID_COL_WIDTH,
Tables.base_table_config.HEIGHT + oleDb.EuqalTo() + Config.HEIGHT,
Tables.base_table_config.IS_FOREIGNER_KEY + oleDb.EuqalTo() + (Config.IS_FOREIGNER_KEY ? "1" : "0"),
Tables.base_table_config.IS_PRIMARY_KEY + oleDb.EuqalTo() + (Config.IS_PRIMARY_KEY ? "1" : "0"),
Tables.base_table_config.LOCATION_X + oleDb.EuqalTo() + Config.LOCATION_X,
Tables.base_table_config.LOCATION_Y + oleDb.EuqalTo() + Config.LOCATION_Y,
Tables.base_table_config.TABINDEX + oleDb.EuqalTo() + Config.TABINDEX,
Tables.base_table_config.MAXLENGTH + oleDb.EuqalTo() + Config.MAXLENGTH,
Tables.base_table_config.TABLE_CN_NAME + oleDb.EuqalTo() + "'" + Config.TABLE_CN_NAME + "'",
Tables.base_table_config.TABLE_DB_NAME + oleDb.EuqalTo() + "'" + Config.TABLE_DB_NAME + "'",
Tables.base_table_config.UIC_TYPE + oleDb.EuqalTo() + (int)Config.UIC_TYPE,
Tables.base_table_config.WIDTH + oleDb.EuqalTo() + Config.WIDTH,
Tables.base_table_config.FIELD_MARK_TYPE + oleDb.EuqalTo() + (int)Config.FIELD_MARK_TYPE);
}
}
oleDb.CommitTransaction();
}
catch
{
oleDb.RollbackTransaction();
}
}
