private static void BuildFields1(XTableSchema schema)
{
string connectionName = schema.ConnectionName;
string selectSql = schema.SelectCommand;
// XDataBase xdb = XDatabaseFactory.Instance.GetDataBase(connectionName);
DatabaseAdmin
XSql xSql = new XSql(selectSql);
string tableName = xSql.GetFrom();
// schema.Fields.Clear();
SchemaList <FieldSchema> tmpfs = new SchemaList <FieldSchema>();
if (xSql.IsFromSourceTable(tableName))
{
string keyfield = xdb.GetPrimaryKey(tableName);
if (!string.IsNullOrEmpty(keyfield))
{
schema.KeyField = keyfield;
}
List <FieldDef> fieldDefs = xdb.GetFieldInfos(tableName);
for (int i = 0; i < fieldDefs.Count; i++)
{
FieldSchema field = new FieldSchema();
FieldDef fieldDef = fieldDefs[i];
field.Id = fieldDef.Name;
field.DisplayName = fieldDef.Alias;//未用
if (string.IsNullOrEmpty(field.Title))
{
field.Title = fieldDef.Alias;
}
if (schema.Fields.FindItem(field.Id) == null)
{
schema.Fields.Add(field);
}
if (tmpfs.FindItem(field.Id) == null)
{
tmpfs.Add(field);
}
}
}
else
{
DbConnection con = xdb.GetConnection();
DataTable netTable = new DataTable();
DbDataAdapter da = xdb.GetAdapter();
DbCommand cmd = con.CreateCommand();
xSql.ParamGetter = delegate(string name)
{
if (!name.StartsWith("@"))
{
name = "@" + name;
}
if (schema.QueryParams.FindItem(name) != null)
{
XQueryParameterSchema paramSch = schema.QueryParams.GetItem(name);
return(paramSch.DefaultValue);
}
else
{
return(null);
}
};
cmd.CommandText = xSql.RelaceParamValue();
da.SelectCommand = cmd;
da.Fill(netTable);
foreach (DataColumn col in netTable.Columns)
{
FieldSchema field = new FieldSchema();
field.Id = col.ColumnName;
field.DisplayName = col.Caption;
// schema.Fields.Add(field);
if (schema.Fields.FindItem(field.Id) == null)
{
schema.Fields.Add(field);
}
if (tmpfs.FindItem(field.Id) == null)
{
tmpfs.Add(field);
}
}
}
for (int i = schema.Fields.Count - 1; i >= 0; i--)
{
FieldSchema fld = schema.Fields[i];
FieldSchema newFld = tmpfs.FindItem(fld.Id);
if (newFld == null)
{
schema.Fields.Remove(fld);
}
}
xdb.Close();
}
