/// <summary> /// 构造Access和Sqlite数据文件 SQL插入语句 /// </summary> /// <param name="dataFieldTypes"></param> /// <returns></returns> public static string CreateInsertSql(DataFieldTypeCollection dataFieldTypes) { string fieldString = string.Join(",", dataFieldTypes.Select(item => item.FiledName)); string parameterNameString = string.Join(",", dataFieldTypes.Select(item => item.FieldParameterName)); string insertSql = $"insert into [mytable]({fieldString}) values({parameterNameString})"; return(insertSql); }
/// <summary> /// 创建参数列表 /// </summary> /// <param name="dataFieldTypes"></param> /// <returns></returns> public static List <string> CreateParameterNameList(DataFieldTypeCollection dataFieldTypes) { return(dataFieldTypes.Select(item => "@" + item.FiledName).ToList()); }