public QueryCriteria(Channel channel)
{
InitializeComponent();
channelForm = channel;
type = "Add";
sqlOutQueryCriteriaItem = new SQLOutQueryCriteriaItem();
this.Text = "Add Filter Item";
}
public QueryInParameter(XCollection <SQLOutQueryCriteriaItem> parameters)
{
InitializeComponent();
GetLUTTables();
parameterList = parameters;
parameterItem = new SQLOutQueryCriteriaItem();
type = "Add";
this.Text = "Add Parameter";
}
public QueryCriteria(Channel channel, int index)
{
InitializeComponent();
channelForm = channel;
type = "Edit";
this.Text = "Edit Filter Item";
selectIndex = index;
sqlOutQueryCriteriaItem = channel.criteriaItemList[index];
ShowInformation(selectIndex);
}
public QueryInParameter(XCollection <SQLOutQueryCriteriaItem> parameters, int index)
{
InitializeComponent();
GetLUTTables();
parameterList = parameters;
parameterItem = parameters[index];
type = "Edit";
this.Text = "Edit Parameter";
ShowInformation();
}
private void LoadEventTypeSetting(SQLOutboundChanel chn, string tablePrefix, string[] eventTypes)
{
chn.Rule.QueryCriteria.Type = QueryCriteriaRuleType.DataSet;
foreach (string str in eventTypes)
{
SQLOutQueryCriteriaItem item = new SQLOutQueryCriteriaItem();
item.TargetField = GWDataDBField.i_EventType.GetFullFieldName(tablePrefix);
item.GWDataDBField = GWDataDBField.i_EventType;
ThrPartyDBParamter p = new ThrPartyDBParamter();
p.FieldType = System.Data.OleDb.OleDbType.Empty;
item.ThirdPartyDBPatamter = p;
item.SourceField = "";
item.Translating.Type = TranslatingType.FixValue;
item.Translating.ConstValue = str;
item.Type = QueryCriteriaType.Or;
chn.Rule.QueryCriteria.MappingList.Add(item);
}
}
