private void setFields()
{
if (_xDG == null | (_xDG != null && _xDG.DefaultFieldLayout == null) // |
//(_xDG != null && _xDG.DefaultFieldLayout != null || _xDG.DefaultFieldLayout.Fields == null) |
//(_xDG != null && _xDG.DefaultFieldLayout != null || _xDG.DefaultFieldLayout.Fields != null && _xDG.DefaultFieldLayout.Fields.Count >0)
)
{
string sql = "select * from (" + _BasicQuery + ") where 1=2";
//var da = MyDb.Common.//new OracleDataAdapter(, (OracleConnection)_cnn);
//DataTable dt = new DataTable();
//da.Fill(dt);
DataTable dt = MyDb.Common.sql2DT(sql, _cnn);
setFieldsFromDT(dt.Columns);
}
else
{
foreach (Field f in _xDG.DefaultFieldLayout.Fields)
{
Fields.Add(new cField()
{
FieldAlias = (string)f.Label,
// FieldHasValueList = f.Settings.EditorStyle.TargetType == Infragistics.Windows.Editors.XamComboEditor ?
FieldHasValueList = false,//_xDG.val.
FieldName = (string)f.DataContext,
FieldPosition = f.ActualPosition.Column,
FieldType = Strings4Enums.dotNetType_to_BasicType(f.DataType),
FieldVisible = f.Visibility == System.Windows.Visibility.Visible ? true : false,
Tag = f
});
}
Console.WriteLine(_xDG.DataSource.GetType().Name);
}
}
private void loadClauses(Strings4Enums.qFieldType _Attr_Type, bool CaseSensitive)
{
List <Strings4Enums.qClauses> clauses = Strings4Enums.Ft4Clauses(_Attr_Type);
foreach (Strings4Enums.qClauses c in clauses)
{
Clauses C = new Clauses()
{
Attr_Type = _Attr_Type, Attr_Clause = c, Sql = Strings4Enums.sqlClauses(c, CaseSensitive, _Attr_Type), Text = Strings4Enums.sClause(c)
};
oClauses.Add(C);
}
}
private void setFieldsFromDT(DataColumnCollection dCc)
{
Fields = new List <cField>();
int cPos = 0;
foreach (DataColumn dc in dCc)
{
Fields.Add(new cField()
{
FieldAlias = dc.Caption.Replace("_", " "),
FieldHasValueList = false,
FieldName = dc.ColumnName,
FieldPosition = cPos,
FieldType = Strings4Enums.dotNetType_to_BasicType(dc.DataType),
FieldVisible = true,
Tag = dc
});
cPos++;
}
}
