/// <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)); }