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(); }