Beispiel #1
0
        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);
        }
Beispiel #2
0
        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);
        }