/// <summary>
/// 保存当前配置到数据库(单条数据)
/// </summary>
/// <param name="dic_item"></param>
/// <returns></returns>
public string save(DBCommonDictionaryItem dic_item)
{
bool is_update = false;
if (dic_item.id > 0)
{
DBCommonDictionaryItem test = queryItem(dic_item.id);
if (test.id > 0)
{
is_update = true;
}
}
else
{
dic_item.id = nextId();
}
if (dic_item.index <= 0)
{
dic_item.index = nextIndex(dic_item.dic_type);
}
if (is_update)
{
var pm = new List <DBParameter>();
pm.Add(new DBParameter(dictionary_info.type_column, dic_item.dic_type));
pm.Add(new DBParameter(dictionary_info.content_column, dic_item.content));
pm.Add(new DBParameter(dictionary_info.shortcut_column, dic_item.shortcut));
pm.Add(new DBParameter(dictionary_info.index_column, dic_item.index));
if (dictionary_info.domain_column != "")
{
pm.Add(new DBParameter(dictionary_info.domain_column, domain_id));
}
var pk = new List <DBParameter>();
pk.Add(new DBParameter(dictionary_info.id_column, dic_item.id));
return(DBQuery.update(dictionary_info.table_name, pm, pk, connection));
}
else
{
var pm = new List <DBParameter>();
pm.Add(new DBParameter(dictionary_info.id_column, dic_item.id));
pm.Add(new DBParameter(dictionary_info.type_column, dic_item.dic_type));
pm.Add(new DBParameter(dictionary_info.content_column, dic_item.content));
pm.Add(new DBParameter(dictionary_info.shortcut_column, dic_item.shortcut));
pm.Add(new DBParameter(dictionary_info.index_column, dic_item.index));
if (dictionary_info.domain_column != "")
{
pm.Add(new DBParameter(dictionary_info.domain_column, domain_id));
}
return(DBQuery.insert(dictionary_info.table_name, pm, connection));
}
}
public string insertData(string table_name)
{
var pm = new List <DBParameter>();
foreach (var di in item_list)
{
if (di.column_value == null)
{
continue;
}
var param = di.getParameter(table_name);
if (param != null)
{
pm.Add(param);
}
}
return(DBQuery.insert(table_name, pm));
}
/// <summary>
/// 保存当前配置到数据库(单条数据)
/// </summary>
/// <param name="field"></param>
/// <returns></returns>
public string save(FieldInfo field)
{
var pk = new List <DBParameter>();
pk.Add(new DBParameter(config_info.name_column, field.Name));
if (config_info.domain_column != "")
{
pk.Add(new DBParameter(config_info.domain_column, domain_id));
}
DBQuery.delete(config_info.table_name, pk, connection);
var pm = new List <DBParameter>();
pm.Add(new DBParameter(config_info.name_column, field.Name));
pm.Add(new DBParameter(config_info.value_column, field.GetValue(this)));
if (config_info.domain_column != "")
{
pm.Add(new DBParameter(config_info.domain_column, domain_id));
}
return(DBQuery.insert(config_info.table_name, pm, connection));
}
