private string GetViewSelectCommand()
{
List <string> columns = new List <string>();
//System.Data.Common.DbConnection con = ConnectionManager.Connection;
foreach (ColumnInfo ci in TableInfo.Columns)
{
if (ci.IsPrimaryKey)
{
uxGrid.MasterTableView.DataKeyNames = new string[] { ci.Title != "" ? ci.Title : ci.ColumnName };
}
ForeignKeyRelation fk = ci.ForeignKeyRelation;
if (fk != null)
{
TableInfo ti = SchemaUtility.GetTable(fk.PKTable);
string nameColumn = ti.GetNameColumn().ColumnName;
columns.Add("( Select [" + nameColumn + "] From " + fk.PKTable + " Where " + fk.PKTable + ".[" + fk.PKField + "] = " + TableName + ".[" + fk.FKField + "] ) ");
break;
}
else
{
columns.Add(ci.ColumnName + " as [" + ci.Title + "]");//+ " as [" + ci.Title + "]");
}
}
return("select " + string.Join(",", columns.ToArray()) + " from " + TableName);
}
