public void AddDSCondition(ActDSConditon.eCondition wCond, string wColName, ActDSConditon.eOperator wOper, string wValue, List <string> mColName)
{
ActDSConditon ADSC = new ActDSConditon();
ObservableList <string> Condition = new ObservableList <string>();
if (wCond != ActDSConditon.eCondition.EMPTY)
{
foreach (ActDSConditon.eCondition item in Enum.GetValues(typeof(ActDSConditon.eCondition)))
{
if (item.ToString() != "EMPTY")
{
Condition.Add(item.ToString());
}
}
}
List <string> colNames = new List <string>();
foreach (string sColName in mColName)
{
colNames.Add(sColName);
}
ADSC.PossibleCondValues = Condition;
ADSC.PossibleColumnValues = colNames;
WhereConditions.Add(ADSC);
ADSC.wCondition = wCond;
ADSC.wTableColumn = wColName;
ADSC.wOperator = wOper;
ADSC.wValue = wValue;
}
private void AddWhereCondition(object sender, RoutedEventArgs e)
{
ActDSConditon.eCondition defaultCondition = ActDSConditon.eCondition.EMPTY;
ObservableList <string> Condition = new ObservableList <string>();
if (mWhereConditionList.Count > 0)
{
foreach (ActDSConditon.eCondition item in Enum.GetValues(typeof(ActDSConditon.eCondition)))
{
if (item.ToString() != "EMPTY")
{
Condition.Add(item.ToString());
}
}
defaultCondition = ActDSConditon.eCondition.AND;
}
List <string> cols = new List <string>();
var columns = mDataTable.Columns;
foreach (var item in columns)
{
cols.Add(item.ToString());
}
mWhereConditionList.Add(new ActDSConditon()
{
PossibleCondValues = Condition, PossibleColumnValues = cols, wCondition = defaultCondition, wTableColumn = cols[0]
});
xGrdExportCondition.DataSourceList = mWhereConditionList;
CreateQueryBasedWhereCondition();
}
