private string BuildSqlSave()
{
string sCols = ColumnasGridSQL(_tableEdit);
DataGridTables dgtTmp = new DataGridTables();
dgtTmp.AddDataGridTable(_tableEdit);
string sSQL = BeginSql(dgtTmp, "", sCols);
if (!string.IsNullOrEmpty(_whereClause))
{
sSQL += _whereClause;
}
return(sSQL);
}
private string BeginSql(DataGridTables dataGridTables, string sqlQuery, string columnNames)
{
string sBegin = "";
IList <DataGridTable> orderedDataGridTables = dataGridTables.Ordered();
for (int currentIndex = 0; currentIndex <= orderedDataGridTables.Count - 1; currentIndex++)
{
DataGridTable dataGridTable = orderedDataGridTables[currentIndex];
if (dataGridTable.VirtualTables.Count != 0)
{
sBegin = CreateStringFromVirtualColumns(sBegin, dataGridTable);
}
else
{
sBegin = sBegin + dataGridTable.JoinText;
sBegin = sBegin + dataGridTable.Table + " " + dataGridTable.AliasTable + " " +
dataGridTable.Criterias;
}
}
string sqlString = columnNames + "\n" + sBegin;
return(sqlString);
}
