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