private bool GetIsQuote(SqlTypeE sqlType)
{
bool isIsQuote = true;
if (
sqlType == SqlTypeE.@int || sqlType == SqlTypeE.numeric ||
sqlType == SqlTypeE.@money || sqlType == SqlTypeE.@bit
)
{
isIsQuote = false;
}
return(isIsQuote);
}
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);
}
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 = Config.FolderAppBin + t.TableName + ".sql";
UFile.Write(filePath, s.ToString());
return filePath;
}
