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