public RdetOutChannel Clone()
{
RdetOutChannel ch = new RdetOutChannel();
ch.ChannelName = this.ChannelName;
ch.Enable = this.Enable;
ch.OperationName = this.OperationName;
//ch.Rule.RuleID = Rule.RuleID; //do not copy RuleID
ch.Rule.RuleName = Rule.RuleName;
ch.Rule.MaxRecordCount = Rule.MaxRecordCount;
ch.Rule.CheckProcessFlag = Rule.CheckProcessFlag;
ch.Rule.AutoUpdateProcessFlag = Rule.AutoUpdateProcessFlag;
ch.Rule.QueryCriteria.Type = Rule.QueryCriteria.Type;
ch.Rule.QueryCriteria.SQLStatement = Rule.QueryCriteria.SQLStatement;
//ch.Rule.QueryCriteriaRuleType = this.Rule.QueryCriteriaRuleType;
foreach (RdetOutQueryCriterialItem item in Rule.QueryCriteria.MappingList)
{
RdetOutQueryCriterialItem i = item.Clone();
ch.Rule.QueryCriteria.MappingList.Add(i);
}
foreach (RdetOutQueryResultItem item in Rule.QueryResult.MappingList)
{
RdetOutQueryResultItem i = item.Clone();
ch.Rule.QueryResult.MappingList.Add(i);
}
return(ch);
}
public RdetOutQueryResultItem Clone()
{
RdetOutQueryResultItem item = new RdetOutQueryResultItem();
item.ThirdPartyDBPatamter.FieldID = this.ThirdPartyDBPatamter.FieldID;
item.ThirdPartyDBPatamter.FieldName = this.ThirdPartyDBPatamter.FieldName;
item.ThirdPartyDBPatamter.FieldType = this.ThirdPartyDBPatamter.FieldType;
item.Translating = this.Translating.Clone();
item.SourceField = this.SourceField;
item.TargetField = this.TargetField;
item.RedundancyFlag = this.RedundancyFlag;
item.GWDataDBField.Table = this.GWDataDBField.Table;
item.GWDataDBField.FieldName = this.GWDataDBField.FieldName;
return(item);
}
public static RdetOutboundAdapterConfig BuildSampleConfig()
{
RdetOutboundAdapterConfig Config = new RdetOutboundAdapterConfig();
#region General Params
Config.OutGeneralParams.TimerEnable = true;
Config.OutGeneralParams.TimerInterval = 1000 * 30;
#endregion
#region Client Rdet Params
Config.ClientRdetParams.ServerIP = "127.0.0.1";
Config.ClientRdetParams.ServerPort = 58431;
#endregion
#region Look up Table
LookupTable ltEventType = new LookupTable();
ltEventType.DisplayName = "EventType To Command ";
//ltEventType.Table.Add(new LookupItem("00", "NewPatient"));
//ltEventType.Table.Add(new LookupItem("01", "UpdatePatient"));
ltEventType.Table.Add(new LookupItem("10", "NewPatient"));
ltEventType.Table.Add(new LookupItem("11", "UpdatePatient"));
ltEventType.Table.Add(new LookupItem("99", "NewImage"));
Config.LookupTables.Add(ltEventType);
LookupTable ltSex = new LookupTable();
ltSex.DisplayName = "Sex To Gender ";
ltSex.Table.Add(new LookupItem("M", "1"));
ltSex.Table.Add(new LookupItem("F", "2"));
ltSex.Table.Add(new LookupItem("O", "3"));
ltSex.Table.Add(new LookupItem("U", "3"));
Config.LookupTables.Add(ltSex);
#endregion
#region Channel List
RdetOutChannel ch;
RdetOutQueryResultItem ri;
#region Channel for NewPatient,UpdatePatient <- NewOrder and updateorder
// Actuall New Order -> New patient and Update Order -> Update Patient
ch = new RdetOutChannel();
ch.ChannelName = "NewPatient/UpdatePatient";
ch.Enable = true;
ch.OperationName = "NewPatient/UpdatePatient";
ch.Rule.CheckProcessFlag = true;
ch.Rule.AutoUpdateProcessFlag = true;
#region Query CriterialItems for channel Order
ch.Rule.QueryCriteria.Type = QueryCriteriaRuleType.DataSet;
// Order
RdetOutQueryCriterialItem ciOrder = new RdetOutQueryCriterialItem();
ciOrder.Type = QueryCriteriaType.Or;
ciOrder.SourceField = "Event_Type";
ciOrder.GWDataDBField.FieldName = "Event_Type";
ciOrder.GWDataDBField.Table = GWDataDBTable.Index;
ciOrder.Translating.Type = TranslatingType.FixValue;
ciOrder.Translating.ConstValue = "10"; // new order
ciOrder.Operator = QueryCriteriaOperator.Equal;
ch.Rule.QueryCriteria.MappingList.Add(ciOrder);
ciOrder = new RdetOutQueryCriterialItem();
ciOrder.Type = QueryCriteriaType.Or;
ciOrder.SourceField = "Event_Type";
ciOrder.GWDataDBField.FieldName = "Event_Type";
ciOrder.GWDataDBField.Table = GWDataDBTable.Index;
ciOrder.Translating.Type = TranslatingType.FixValue;
ciOrder.Translating.ConstValue = "11"; // update order
ciOrder.Operator = QueryCriteriaOperator.Equal;
ch.Rule.QueryCriteria.MappingList.Add(ciOrder);
ciOrder = new RdetOutQueryCriterialItem();
ciOrder.Type = QueryCriteriaType.Or;
ciOrder.SourceField = "Event_Type";
ciOrder.GWDataDBField.FieldName = "Event_Type";
ciOrder.GWDataDBField.Table = GWDataDBTable.Index;
ciOrder.Translating.Type = TranslatingType.FixValue;
ciOrder.Translating.ConstValue = "01"; // update patient
ciOrder.Operator = QueryCriteriaOperator.Equal;
ch.Rule.QueryCriteria.MappingList.Add(ciOrder);
ciOrder = new RdetOutQueryCriterialItem();
ciOrder.Type = QueryCriteriaType.Or;
ciOrder.SourceField = "Event_Type";
ciOrder.GWDataDBField.FieldName = "Event_Type";
ciOrder.GWDataDBField.Table = GWDataDBTable.Index;
ciOrder.Translating.Type = TranslatingType.FixValue;
ciOrder.Translating.ConstValue = "00"; // add patient
ciOrder.Operator = QueryCriteriaOperator.Equal;
ch.Rule.QueryCriteria.MappingList.Add(ciOrder);
#endregion
#region Query Result for channel Order -> New/Update patient
ri = new RdetOutQueryResultItem();
ri.SourceField = "Data_ID";
ri.TargetField = "Data_ID";
ri.GWDataDBField.FieldName = "Data_ID";
ri.GWDataDBField.Table = GWDataDBTable.Index;
ri.ThirdPartyDBPatamter.FieldName = ""; //flag not send to third database
ch.Rule.QueryResult.MappingList.Add(ri);
ri = new RdetOutQueryResultItem();
ri.SourceField = "Data_DT";
ri.TargetField = "Data_DT";
ri.GWDataDBField.FieldName = "Data_DT";
ri.GWDataDBField.Table = GWDataDBTable.Index;
ri.ThirdPartyDBPatamter.FieldName = ""; //flag not send to third database
ch.Rule.QueryResult.MappingList.Add(ri);
ri = new RdetOutQueryResultItem();
ri.SourceField = "Event_Type";
ri.TargetField = "Command";
ri.GWDataDBField.Table = GWDataDBTable.Index;
ri.GWDataDBField.FieldName = "Event_Type";
ri.ThirdPartyDBPatamter.FieldName = "Command";
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ri.Translating.Type = TranslatingType.LookUpTable;
ri.Translating.LutName = ltEventType.TableName;
ch.Rule.QueryResult.MappingList.Add(ri);
// Order.Study_Instance_UID -> StudyInstanceUID
ri = new RdetOutQueryResultItem();
ri.SourceField = "Study_Instance_UID";
ri.TargetField = "StudyInstanceUID";
ri.GWDataDBField.FieldName = "Study_Instance_UID";
ri.GWDataDBField.Table = GWDataDBTable.Order;
ri.ThirdPartyDBPatamter.FieldName = "StudyInstanceUID";
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ch.Rule.QueryResult.MappingList.Add(ri);
// Patient.PatientID -> PatientID
ri = new RdetOutQueryResultItem();
ri.SourceField = "PatientID";
ri.TargetField = "PatientID";
ri.GWDataDBField.FieldName = "PatientID";
ri.GWDataDBField.Table = GWDataDBTable.Patient;
ri.ThirdPartyDBPatamter.FieldName = "PatientID";
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ch.Rule.QueryResult.MappingList.Add(ri);
// Patient.PatientName -> PatientName
ri = new RdetOutQueryResultItem();
ri.SourceField = "Patient_Name";
ri.TargetField = "PatientName";
ri.GWDataDBField.FieldName = "Patient_Name";
ri.GWDataDBField.Table = GWDataDBTable.Patient;
ri.ThirdPartyDBPatamter.FieldName = "PatientName";
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ch.Rule.QueryResult.MappingList.Add(ri);
// Patient.BirthDate -> BirthDate
ri = new RdetOutQueryResultItem();
ri.SourceField = "BirthDate";
ri.TargetField = "BirthDate";
ri.GWDataDBField.FieldName = "BirthDate";
ri.GWDataDBField.Table = GWDataDBTable.Patient;
ri.ThirdPartyDBPatamter.FieldName = "BirthDate";
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ch.Rule.QueryResult.MappingList.Add(ri);
//sex -> gender
ri = new RdetOutQueryResultItem();
ri.SourceField = "sex";
ri.TargetField = "Gender";
ri.GWDataDBField.Table = GWDataDBTable.Patient;
ri.GWDataDBField.FieldName = "sex";
ri.ThirdPartyDBPatamter.FieldName = "Gender";
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ri.Translating.Type = TranslatingType.LookUpTable;
ri.Translating.LutName = ltSex.TableName;
ch.Rule.QueryResult.MappingList.Add(ri);
// Order.Order_No -> AccessionNumber
ri = new RdetOutQueryResultItem();
ri.SourceField = "Order_No";
ri.TargetField = "AccessionNumber";
ri.GWDataDBField.FieldName = "Order_No";
ri.GWDataDBField.Table = GWDataDBTable.Order;
ri.ThirdPartyDBPatamter.FieldName = "AccessionNumber";
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ch.Rule.QueryResult.MappingList.Add(ri);
// Order.Scheduled_DT -> StudyDate
ri = new RdetOutQueryResultItem();
ri.SourceField = "Scheduled_DT";
ri.TargetField = "StudyDate";
ri.GWDataDBField.FieldName = "Scheduled_DT";
ri.GWDataDBField.Table = GWDataDBTable.Order;
ri.ThirdPartyDBPatamter.FieldName = "StudyDate";
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ch.Rule.QueryResult.MappingList.Add(ri);
// Order.Scheduled_DT -> StudyTime
ri = new RdetOutQueryResultItem();
ri.SourceField = "Scheduled_DT";
ri.TargetField = "StudyTime";
ri.GWDataDBField.FieldName = "Scheduled_DT";
ri.GWDataDBField.Table = GWDataDBTable.Order;
ri.ThirdPartyDBPatamter.FieldName = "StudyTime";
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ch.Rule.QueryResult.MappingList.Add(ri);
// Order.Scheduled_DT -> StudyTime
//ri = new RdetOutQueryResultItem();
//ri.SourceField = "Scheduled_DT";
//ri.TargetField = "StudyTime";
//ri.GWDataDBField.FieldName = "Scheduled_DT";
//ri.GWDataDBField.Table = GWDataDBTable.Order;
//ri.ThirdPartyDBPatamter.FieldName = "StudyTime";
//ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
//ch.Rule.QueryResult.MappingList.Add(ri);
// Order.Customer_1 -> Priority
ri = new RdetOutQueryResultItem();
ri.SourceField = "Customer_1";
ri.TargetField = "Priority";
ri.GWDataDBField.FieldName = "Customer_1";
ri.GWDataDBField.Table = GWDataDBTable.Order;
ri.ThirdPartyDBPatamter.FieldName = "Priority";
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ri.Translating.Type = TranslatingType.DefaultValue;
ri.Translating.ConstValue = "1"; //3=STAT,2=Urgent,1=Routine
ch.Rule.QueryResult.MappingList.Add(ri);
// Patient.Procedure_Name -> ProcedureName
ri = new RdetOutQueryResultItem();
ri.SourceField = "Procedure_Name";
ri.TargetField = "ProcedureName";
ri.GWDataDBField.FieldName = "Procedure_Name";
ri.GWDataDBField.Table = GWDataDBTable.Order;
ri.ThirdPartyDBPatamter.FieldName = "ProcedureName";
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ch.Rule.QueryResult.MappingList.Add(ri);
// Patient.Procedure_Code -> ProcedureCode
ri = new RdetOutQueryResultItem();
ri.SourceField = "Procedure_Code";
ri.TargetField = "ProcedureCode";
ri.GWDataDBField.FieldName = "Procedure_Code";
ri.GWDataDBField.Table = GWDataDBTable.Order;
ri.ThirdPartyDBPatamter.FieldName = "ProcedureCode";
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ch.Rule.QueryResult.MappingList.Add(ri);
// Patient.Customer_1 -> PatientComments
ri = new RdetOutQueryResultItem();
ri.SourceField = "Customer_1";
ri.TargetField = "PatientComments";
ri.GWDataDBField.FieldName = "Customer_1";
ri.GWDataDBField.Table = GWDataDBTable.Patient;
ri.ThirdPartyDBPatamter.FieldName = "PatientComments";
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ch.Rule.QueryResult.MappingList.Add(ri);
// Order.REF_Physician -> ReferringPhysician
ri = new RdetOutQueryResultItem();
ri.SourceField = "REF_Physician";
ri.TargetField = "ReferringPhysician";
ri.GWDataDBField.FieldName = "REF_Physician";
ri.GWDataDBField.Table = GWDataDBTable.Order;
ri.ThirdPartyDBPatamter.FieldName = "ReferringPhysician";
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ch.Rule.QueryResult.MappingList.Add(ri);
// Order.Placer_Department -> Department
ri = new RdetOutQueryResultItem();
ri.SourceField = "Placer_Department";
ri.TargetField = "Department";
ri.GWDataDBField.FieldName = "Placer_Department";
ri.GWDataDBField.Table = GWDataDBTable.Order;
ri.ThirdPartyDBPatamter.FieldName = "Department";
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ch.Rule.QueryResult.MappingList.Add(ri);
// Patient.Patient_Location -> PatientLocation
ri = new RdetOutQueryResultItem();
ri.SourceField = "Patient_Location";
ri.TargetField = "PatientLocation";
ri.GWDataDBField.FieldName = "Patient_Location";
ri.GWDataDBField.Table = GWDataDBTable.Patient;
ri.ThirdPartyDBPatamter.FieldName = "PatientLocation";
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ch.Rule.QueryResult.MappingList.Add(ri);
// Order.CNT_Agent -> ContrastAgent
ri = new RdetOutQueryResultItem();
ri.SourceField = "CNT_Agent";
ri.TargetField = "ContrastAgent";
ri.GWDataDBField.FieldName = "CNT_Agent";
ri.GWDataDBField.Table = GWDataDBTable.Order;
ri.ThirdPartyDBPatamter.FieldName = "ContrastAgent";
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ch.Rule.QueryResult.MappingList.Add(ri);
// Order.Customer_2 -> TechID
ri = new RdetOutQueryResultItem();
ri.SourceField = "Customer_2";
ri.TargetField = "TechID";
ri.GWDataDBField.FieldName = "Customer_2";
ri.GWDataDBField.Table = GWDataDBTable.Order;
ri.ThirdPartyDBPatamter.FieldName = "TechID";
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ch.Rule.QueryResult.MappingList.Add(ri);
// Order.Study_ID -> StudyID
ri = new RdetOutQueryResultItem();
ri.SourceField = "Study_ID";
ri.TargetField = "StudyID";
ri.GWDataDBField.FieldName = "Study_ID";
ri.GWDataDBField.Table = GWDataDBTable.Order;
ri.ThirdPartyDBPatamter.FieldName = "StudyID";
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ch.Rule.QueryResult.MappingList.Add(ri);
// Order.Station_Name -> StationName
ri = new RdetOutQueryResultItem();
ri.SourceField = "Station_Name";
ri.TargetField = "StationName";
ri.GWDataDBField.FieldName = "Station_Name";
ri.GWDataDBField.Table = GWDataDBTable.Order;
ri.ThirdPartyDBPatamter.FieldName = "StationName";
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ch.Rule.QueryResult.MappingList.Add(ri);
// Order.Station_AETitle -> AETitle
ri = new RdetOutQueryResultItem();
ri.SourceField = "Station_AETitle";
ri.TargetField = "AETitle";
ri.GWDataDBField.FieldName = "Station_AETitle";
ri.GWDataDBField.Table = GWDataDBTable.Order;
ri.ThirdPartyDBPatamter.FieldName = "AETitle";
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ch.Rule.QueryResult.MappingList.Add(ri);
#endregion
Config.OutboundChanels.Add(ch);
#endregion//Channel for Order
#region Channel For UpdatePatient
//ch = new RdetOutChannel();
//ch.ChannelName = "Out_CRUDPatient";
//ch.Enable = true;
//ch.OperationName = "Out_CRUDPatient";
//ch.Rule.CheckProcessFlag = true;
//ch.Rule.AutoUpdateProcessFlag = true;
//#region CriterialItems
//ch.Rule.QueryCriteria.Type = QueryCriteriaRuleType.DataSet;
//// Patient Add
//RdetOutQueryCriterialItem ciPatientAdd = new RdetOutQueryCriterialItem();
//ciPatientAdd.Type = QueryCriteriaType.And;
//ciPatientAdd.SourceField = "Event_Type";
//ciPatientAdd.GWDataDBField.FieldName = "Event_Type";
//ciPatientAdd.GWDataDBField.Table = GWDataDBTable.Index;
//ciPatientAdd.Translating.Type = TranslatingType.FixValue;
//ciPatientAdd.Translating.ConstValue = "03";
//ciPatientAdd.Operator = QueryCriteriaOperator.EqualSmallerThan;
//ch.Rule.QueryCriteria.MappingList.Add(ciPatientAdd);
//ciPatientAdd = new RdetOutQueryCriterialItem();
//ciPatientAdd.Type = QueryCriteriaType.And;
//ciPatientAdd.SourceField = "Event_Type";
//ciPatientAdd.GWDataDBField.FieldName = "Event_Type";
//ciPatientAdd.GWDataDBField.Table = GWDataDBTable.Index;
//ciPatientAdd.Translating.Type = TranslatingType.FixValue;
//ciPatientAdd.Translating.ConstValue = "00";
//ciPatientAdd.Operator = QueryCriteriaOperator.EqualLargerThan;
//ch.Rule.QueryCriteria.MappingList.Add(ciPatientAdd);
//#endregion
//#region Query Result
//// Commantype -> DataIndex.Event_Type
//ri = new RdetOutQueryResultItem();
//ri.SourceField = "Data_ID";
//ri.TargetField = "Data_ID";
//ri.GWDataDBField.FieldName = "Data_ID";
//ri.GWDataDBField.Table = GWDataDBTable.Index;
//ri.ThirdPartyDBPatamter.FieldName = ""; //flag not send to third database
//ch.Rule.QueryResult.MappingList.Add(ri);
//ri = new RdetOutQueryResultItem();
//ri.SourceField = "Data_DT";
//ri.TargetField = "Data_DT";
//ri.GWDataDBField.FieldName = "Data_DT";
//ri.GWDataDBField.Table = GWDataDBTable.Index;
//ri.ThirdPartyDBPatamter.FieldName = ""; //flag not send to third database
//ch.Rule.QueryResult.MappingList.Add(ri);
//ri = new RdetOutQueryResultItem();
//ri.SourceField = "Event_Type";
//ri.TargetField = "Commandtype";
//ri.GWDataDBField.FieldName = "Event_Type";
//ri.GWDataDBField.Table = GWDataDBTable.Index;
//ri.ThirdPartyDBPatamter.FieldName = "Commandtype";
//ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
//ri.Translating.Type = TranslatingType.LookUpTable;
//ri.Translating.LutName = lt.TableName;
//ch.Rule.QueryResult.MappingList.Add(ri);
//// CommandGUID -> DataIndex.Record_Index_1
//ri = new RdetOutQueryResultItem();
//ri.SourceField = "Record_Index_1";
//ri.TargetField = "CommandGUID";
//ri.GWDataDBField.FieldName = "Record_Index_1";
//ri.GWDataDBField.Table = GWDataDBTable.Index;
//ri.ThirdPartyDBPatamter.FieldName = "CommandGUID";
//ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
//ch.Rule.QueryResult.MappingList.Add(ri);
//// PatientID -> Patient.PatientID
//ri = new RdetOutQueryResultItem();
//ri.SourceField = "PatientID";
//ri.TargetField = "PatientID";
//ri.GWDataDBField.FieldName = "PatientID";
//ri.GWDataDBField.Table = GWDataDBTable.Patient;
//ri.ThirdPartyDBPatamter.FieldName = "PatientID";
//ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
//ch.Rule.QueryResult.MappingList.Add(ri);
//// PatientName -> Patient_Name
//ri = new RdetOutQueryResultItem();
//ri.SourceField = "PatientName";
//ri.TargetField = "Patient_Name";
//ri.GWDataDBField.FieldName = "Patient_Name";
//ri.GWDataDBField.Table = GWDataDBTable.Patient;
//ri.ThirdPartyDBPatamter.FieldName = "PatientName";
//ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
//ch.Rule.QueryResult.MappingList.Add(ri);
//#endregion
//Config.OutboundChanels.Add(ch);
#endregion
#region Channel for NewImage
ch = new RdetOutChannel();
ch.ChannelName = "NewImage";
ch.Enable = false;
ch.OperationName = "NewImage";
ch.Rule.CheckProcessFlag = true;
ch.Rule.AutoUpdateProcessFlag = true;
#region Query CriterialItems for channel NewImage
ch.Rule.QueryCriteria.Type = QueryCriteriaRuleType.DataSet;
// ImageArrival
RdetOutQueryCriterialItem ciImageArrival = new RdetOutQueryCriterialItem();
ciImageArrival.Type = QueryCriteriaType.And;
ciImageArrival.SourceField = "Event_Type";
ciImageArrival.GWDataDBField.FieldName = "Event_Type";
ciImageArrival.GWDataDBField.Table = GWDataDBTable.Index;
ciImageArrival.Translating.Type = TranslatingType.FixValue;
ciImageArrival.Translating.ConstValue = "100"; // New Image
ciImageArrival.Operator = QueryCriteriaOperator.EqualSmallerThan;
ch.Rule.QueryCriteria.MappingList.Add(ciImageArrival);
#endregion
#region Query Result for channel NewImage
// Set Commantype = Convert.ToInt32(CommandBase.CommandTypeEnum.IMAGE_ARRIVAL).ToString();
// Get Data_ID ,but not send to third database
ri.SourceField = "Data_ID";
ri.TargetField = "Data_ID";
ri.GWDataDBField.FieldName = "Data_ID";
ri.GWDataDBField.Table = GWDataDBTable.Index;
ri.ThirdPartyDBPatamter.FieldName = ""; //flag not send to third database
ch.Rule.QueryResult.MappingList.Add(ri);
ri = new RdetOutQueryResultItem();
ri.SourceField = "Data_DT";
ri.TargetField = "Data_DT";
ri.GWDataDBField.FieldName = "Data_DT";
ri.GWDataDBField.Table = GWDataDBTable.Index;
ri.ThirdPartyDBPatamter.FieldName = ""; //flag not send to third database
ch.Rule.QueryResult.MappingList.Add(ri);
ri = new RdetOutQueryResultItem();
ri.SourceField = "";
ri.TargetField = "Command";
ri.ThirdPartyDBPatamter.FieldName = "Command";
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ri.Translating.Type = TranslatingType.FixValue;
ri.Translating.ConstValue = "NewImage";
ch.Rule.QueryResult.MappingList.Add(ri);
// Order.Study_Instance_UID -> StudyInstanceUID
ri = new RdetOutQueryResultItem();
ri.SourceField = "Study_Instance_UID";
ri.TargetField = "StudyInstanceUID";
ri.GWDataDBField.FieldName = "Study_Instance_UID";
ri.GWDataDBField.Table = GWDataDBTable.Order;
ri.ThirdPartyDBPatamter.FieldName = "StudyInstanceUID";
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ch.Rule.QueryResult.MappingList.Add(ri);
//// AccessionNumber -> Order.Order_No
//ri = new RdetOutQueryResultItem();
//ri.SourceField = "Order_No";
//ri.TargetField = "AccessionNumber";
//ri.GWDataDBField.FieldName = "Order_No";
//ri.GWDataDBField.Table = GWDataDBTable.Order;
//ri.ThirdPartyDBPatamter.FieldName = "AccessionNumber";
//ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
//ch.Rule.QueryResult.MappingList.Add(ri);
// ModalityName -> Order.Modality
// OperatorName -> Order.???
//TODO: Identity OperatorName
// Performed_enddt ->
//TODO: Identity Performed_enddt
// Performed_startdt -> Order.Exam_DT
ri = new RdetOutQueryResultItem();
ri.SourceField = "Exam_DT";
ri.TargetField = "Performed_startdt";
ri.GWDataDBField.FieldName = "Exam_DT";
ri.GWDataDBField.Table = GWDataDBTable.Order;
ri.ThirdPartyDBPatamter.FieldName = "Performed_startdt";
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ch.Rule.QueryResult.MappingList.Add(ri);
#endregion
Config.OutboundChanels.Add(ch);
#endregion//Channel for ImageArrival
#endregion
#region ThrPartDBParameters
#endregion
return(Config);
}