private string combineSelectQuery()
{
String strResult = null;
int i = 0;
foreach (DataRow dataRow in dataTable.Rows)
{
DataColumn filedColumn = dataTable.Columns[0];
DataColumn commentColumn = dataTable.Columns[1];
DataColumn whereFiledColumn = dataTable.Columns[2];
DataColumn operationedColumn = dataTable.Columns[3];
string seleted = dataRow[operationedColumn].ToString();
if (seleted.Equals("true", StringComparison.OrdinalIgnoreCase) == false)
{
continue;
}
if (dataRow[filedColumn].ToString() == null)
{
continue;
}
if (dataRow[commentColumn].ToString() == null)
{
dataRow[commentColumn] = "";
}
string strAdd = " ";
if (i != 0)
{
strAdd = " , ";
}
string filed = dataRow[filedColumn].ToString();
string comment = dataRow[commentColumn].ToString();
strResult += strAdd + makeQuery.makeSelectQuery(filed, comment);
strResult += "\n";
i++;
}
return(strResult);
}
private string combineSelectQuery()
{
String strResult = "SELECT \n";
int i = 0;
foreach (DataRow dataRow in dataTable.Rows)
{
DataColumn dataColumn1 = dataTable.Columns[0];
DataColumn dataColumn2 = dataTable.Columns[1];
DataColumn dataColumn3 = dataTable.Columns[2];
if (dataRow[dataColumn1].ToString() == null)
{
//Console.WriteLine(dataRow[dataColumn1].ToString().Value);
continue;
}
if (dataRow[dataColumn2].ToString() == null)
{
dataRow[dataColumn2] = "";
}
string strAdd = " ";
if (i != 0)
{
strAdd = " , ";
}
strResult += strAdd + makeQuery.makeSelectQuery(
dataRow[dataColumn1].ToString(), dataRow[dataColumn2].ToString());
strResult += "\n";
i++;
}
return(strResult);
}
