2024年1月25日发(作者：)

if (index == 0) { tempstr += " '' "; } else { tempstr += " ,'' "; } index++; } }); tempstr=(, " ),"); rowsvalue += tempstr; } } rowsvalue = ing(0, - 1); str = e("rowsname", rowsname); str = e("rowsvalue", rowsvalue); str = e("tableName", tableName); }

return str; } ///

/// Insert SQL语句 /// /// 要转换的对象，不可空 /// 要添加的表明，不可空 /// ///

空 /// sql语句 /// public static string InsertSql(T t, string tableName) where T : class { if (t == null || OrEmpty(tableName)) { return ; } string columns = GetColmons(t); if (OrEmpty(columns)) { return ; } string values = GetValues(t); if (OrEmpty(values)) { return ; } StringBuilder sql = new StringBuilder(); ("Insert into " + tableName); ("(" + columns + ")"); (" values(" + values + ")"); return ng(); } ///

/// BulkInsert SQL语句（批量添加） /// /// 类型 /// 要转换的对象集合，不可空

/// 要转换的对象集合，不可空 /// >要添加的表明，不可空 /// ///

空 /// sql语句 /// public static string BulkInsertSql(List objs, string tableName) where T : class { if (objs == null || == 0 || OrEmpty(tableName)) { return ; } string columns = GetColmons(objs[0]); if (OrEmpty(columns)) { return ; } string values = (",", (p => ("({0})", GetValues(p))).ToArray()); StringBuilder sql = new StringBuilder(); ("Insert into " + tableName); ("(" + columns + ")"); (" values " + values + ""); return ng(); } ///

///

获得类型的列名 ///

/// /// private static string GetColmons(T obj) { if (obj == null) { return ; } return (",", e().GetProperties().Select(p => ).ToList()); } /// ///

获得值 ///

/// /// private static string GetValues(T obj) { if (obj == null) { return ; } return (",", e().GetProperties().Select(p => ("'{0}'", ue(obj))).ToArray()); }