private void InsertFieldsForFile(FileOutChannel ch)
{
List <FileOutQueryResultItem> Cache = new List <FileOutQueryResultItem>();
foreach (FileOutQueryResultItem item in ch.Rule.QueryResult.MappingList)
{
if (!item.ThirdPartyDBPatamter.FileFieldFlag)
{
continue;
}
Cache.Add(item);
}
foreach (FileOutQueryResultItem item in Cache)
{
foreach (GWDataDBField f in item.ThirdPartyDBPatamter.FileFields)
{
string sTargetField = f.GetFullFieldName().Replace(".", "_");; //important!!!
if (!IsExist(ch, sTargetField))
{
FileOutQueryResultItem ritem = new FileOutQueryResultItem();
ritem.ThirdPartyDBPatamter.FieldName = "";
ritem.TargetField = sTargetField;
ritem.GWDataDBField = f.Clone();
ritem.SourceField = f.GetFullFieldName();
ch.Rule.QueryResult.MappingList.Add(ritem);
}
}
}
}
private void InsertDataDT(FileOutChannel chn)
{
FileOutQueryResultItem item = new FileOutQueryResultItem();
item.ThirdPartyDBPatamter.FieldName = "";
item.TargetField = "data_dt";
item.GWDataDBField = GWDataDBField.i_DataDateTime;
item.TargetField = item.GWDataDBField.FieldName;
chn.Rule.QueryResult.MappingList.Add(item);
}
private void InsertDataID(FileOutChannel chn)
{
FileOutQueryResultItem item = new FileOutQueryResultItem();
item.ThirdPartyDBPatamter.FieldName = "";
item.TargetField = "data_id";
item.GWDataDBField = GWDataDBField.i_IndexGuid;
item.SourceField = item.GWDataDBField.FieldName;
chn.Rule.QueryResult.MappingList.Add(item);
}
public FQueryResult(FChannel frm, XCollection <FileOutQueryResultItem> resultItems, int index)
{
InitializeComponent();
parentlForm = frm;
type = "Edit";
resultList = resultItems;
resultItem = resultItems[index];
GetLUTTables(FileOutboundAdapterConfigMgt.FileOutAdapterConfig.LookupTables);
this.Text = "Edit Result Item";
ReArrageControl();
m_FFileField.CurrThrPartyDBParamterExOut = resultItem.ThirdPartyDBPatamter;
ShowResultItem();
}
public FQueryResult(FChannel frm, XCollection <FileOutQueryResultItem> resultItems)
{
InitializeComponent();
parentlForm = frm;
type = "Add";
resultList = resultItems;
resultItem = new FileOutQueryResultItem();
resultItem.ThirdPartyDBPatamter.FieldType = OleDbType.VarChar;
this.Text = "Add Result Item";
GetLUTTables(FileOutboundAdapterConfigMgt.FileOutAdapterConfig.LookupTables);
ReArrageControl();
m_FFileField.CurrThrPartyDBParamterExOut = resultItem.ThirdPartyDBPatamter;
ShowResultItem();
}
