public string GetValues() { PropertyInfo[] p_list = this.GetType().GetProperties(); string values = "("; foreach (PropertyInfo item in p_list) { string name = LOSQLiteTools.GetFieldName(item); if (name == null || name.Equals("sql_id")) { continue; } values += "'" + item.GetValue(this, null).ToString() + "',"; } values = values.Substring(0, values.Length - 1); values += ")"; return(values); }
public string GetFields() { PropertyInfo[] p_list = this.GetType().GetProperties(); string fields = "("; foreach (PropertyInfo item in p_list) { string name = LOSQLiteTools.GetFieldName(item); if (name == null || name.Equals("sql_id")) { continue; } fields += name + ","; } fields = fields.Substring(0, fields.Length - 1); fields += ")"; return(fields); }