public static string ExportSql(DataTable table, SqlTypeE type) { StringBuilder s = new StringBuilder(); DataTable t = table.Copy(); t.TableName = table.TableName; foreach (DataRow row in t.Rows) { switch (type) { case SqlTypeE.Insert: row.SetAdded(); break; case SqlTypeE.Update: row.SetModified(); break; case SqlTypeE.Delete: row.Delete(); break; default: break; } s.AppendLine(SqlHelper.ToSql(row)); } string filePath = Ap.FolderAppBin + t.TableName + ".sql"; UFile.Write(filePath, s.ToString()); return(filePath); }