public SocketInChannel Clone()
{
SocketInChannel ch = new SocketInChannel();
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.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 (SocketInQueryCriteriaItem item in Rule.QueryCriteria.MappingList)
{
SocketInQueryCriteriaItem i = item.Clone();
ch.Rule.QueryCriteria.MappingList.Add(i);
}
foreach (SocketInQueryResultItem item in Rule.QueryResult.MappingList)
{
SocketInQueryResultItem i = item.Clone();
ch.Rule.QueryResult.MappingList.Add(i);
}
return(ch);
}
public SocketInQueryResultItem Clone()
{
SocketInQueryResultItem item = new SocketInQueryResultItem();
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 SocketInboundAdapterConfig BuildSampleConfig()
{
SocketInboundAdapterConfig Config = new SocketInboundAdapterConfig();
#region General Params
//Config.InGeneralParams.LogLevel = LogType.Debug;
#endregion
#region Server Socket Params
Config.ListenServerSocketParams.ListenIP = "127.0.0.1";
Config.ListenServerSocketParams.ListenPort = 6000;
#endregion
#region Look up Table
LookupTable lt = new LookupTable();
lt.DisplayName = "CommandType to EventType";
lt.Table.Add(new LookupItem(Convert.ToInt32(CommandBase.CommandTypeEnum.PATIENT_ADD).ToString(), "0"));
lt.Table.Add(new LookupItem(Convert.ToInt32(CommandBase.CommandTypeEnum.PATIENT_UPDATE).ToString(), "1"));
lt.Table.Add(new LookupItem(Convert.ToInt32(CommandBase.CommandTypeEnum.PATIENT_DEL).ToString(), "3"));
lt.Table.Add(new LookupItem(Convert.ToInt32(CommandBase.CommandTypeEnum.ORDER_ADD).ToString(), "10"));
lt.Table.Add(new LookupItem(Convert.ToInt32(CommandBase.CommandTypeEnum.ORDER_UPDATE).ToString(), "11"));
lt.Table.Add(new LookupItem(Convert.ToInt32(CommandBase.CommandTypeEnum.ORDER_DEL).ToString(), "13"));
//IMAGE_ARRIVAL map to ORDER_UPDATE, later we use sigle channel to treate IMAGE_ARRVIAL
lt.Table.Add(new LookupItem(Convert.ToInt32(CommandBase.CommandTypeEnum.IMAGE_ARRIVAL).ToString(), "11"));
Config.LookupTables.Add(lt);
#endregion
#region Channel List
SocketInChannel ch;
#region Channel For Add,Edit,Delete Patient
ch = new SocketInChannel();
ch.ChannelName = "CRUDPatient";
ch.Enable = true;
ch.OperationName = "CRUDPatient";
ch.Rule.CheckProcessFlag = true;
ch.Rule.AutoUpdateProcessFlag = true;
#region CriterialItems
ch.Rule.QueryCriteria.Type = QueryCriteriaRuleType.DataSet;
// Patient Add
SocketInQueryCriteriaItem ciPatientAdd = new SocketInQueryCriteriaItem();
ciPatientAdd.Type = QueryCriteriaType.Or;
ciPatientAdd.SourceField = "Commandtype";
ciPatientAdd.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ciPatientAdd.ThirdPartyDBPatamter.FieldName = "Commandtype";
ciPatientAdd.Translating.Type = TranslatingType.FixValue;
ciPatientAdd.Translating.ConstValue = Convert.ToInt32(CommandBase.CommandTypeEnum.PATIENT_UPDATE).ToString();
ciPatientAdd.Operator = QueryCriteriaOperator.EqualSmallerThan;
ch.Rule.QueryCriteria.MappingList.Add(ciPatientAdd);
//// Order
//SocketInQueryCriteriaItem ciOrderAdd = new SocketInQueryCriteriaItem();
//ciOrderAdd.Type = QueryCriteriaType.Or;
//ciOrderAdd.SourceField = "Commandtype";
//ciPatientAdd.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
//ciOrderAdd.ThirdPartyDBPatamter.FieldName = "Commandtype";
//ciOrderAdd.Translating.ConstValue = CommandBase.CommandTypeEnum.ORDER_ADD;
//ch.Rule.QueryCriteria.MappingList.Add(ciOrderAdd);
#endregion
#region Query Result
SocketInQueryResultItem ri;
// Commantype -> DataIndex.Event_Type
ri = new SocketInQueryResultItem();
ri.SourceField = "Commandtype";
ri.TargetField = "Event_Type";
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 SocketInQueryResultItem();
ri.SourceField = "CommandGUID";
ri.TargetField = "Record_Index_1";
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 SocketInQueryResultItem();
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 SocketInQueryResultItem();
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.InboundChanels.Add(ch);
#endregion
#region Channel for Add ,Edit, Delete Order
ch = new SocketInChannel();
ch.ChannelName = "CRUDOrder";
ch.Enable = true;
ch.OperationName = "CRUDOrder";
ch.Rule.CheckProcessFlag = false;
ch.Rule.AutoUpdateProcessFlag = false;
#region CriterialItems
ch.Rule.QueryCriteria.Type = QueryCriteriaRuleType.DataSet;
// Order Add, Del ,Update
SocketInQueryCriteriaItem ciOrder = new SocketInQueryCriteriaItem();
ciOrder.Type = QueryCriteriaType.And;
ciOrder.SourceField = "Commandtype";
ciOrder.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ciOrder.ThirdPartyDBPatamter.FieldName = "Commandtype";
ciOrder.Translating.Type = TranslatingType.FixValue;
ciOrder.Translating.ConstValue = Convert.ToInt32(CommandBase.CommandTypeEnum.ORDER_ADD).ToString();
ciOrder.Operator = QueryCriteriaOperator.EqualLargerThan;
ch.Rule.QueryCriteria.MappingList.Add(ciOrder);
ciOrder = new SocketInQueryCriteriaItem();
ciOrder.Type = QueryCriteriaType.And;
ciOrder.SourceField = "Commandtype";
ciOrder.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ciOrder.ThirdPartyDBPatamter.FieldName = "Commandtype";
ciOrder.Translating.Type = TranslatingType.FixValue;
ciOrder.Translating.ConstValue = Convert.ToInt32(CommandBase.CommandTypeEnum.ORDER_UPDATE).ToString();
ciOrder.Operator = QueryCriteriaOperator.EqualSmallerThan;
ch.Rule.QueryCriteria.MappingList.Add(ciOrder);
#endregion
#region Query Result
// Commantype -> DataIndex.Event_Type
ri = new SocketInQueryResultItem();
ri.SourceField = "Commandtype";
ri.TargetField = "Event_Type";
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 SocketInQueryResultItem();
ri.SourceField = "CommandGUID";
ri.TargetField = "Record_Index_1";
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);
// OrderID -> Order.OrderID
ri = new SocketInQueryResultItem();
ri.SourceField = "PatientID";
ri.TargetField = "PatientID";
ri.GWDataDBField.FieldName = "PatientID";
ri.GWDataDBField.Table = GWDataDBTable.Order;
ri.ThirdPartyDBPatamter.FieldName = "PatientID";
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ch.Rule.QueryResult.MappingList.Add(ri);
// AccessionNumber -> Order_No
ri = new SocketInQueryResultItem();
ri.SourceField = "AccessionNumber";
ri.TargetField = "Order_No";
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);
#endregion
Config.InboundChanels.Add(ch);
#endregion
#region Channel for ImageArrival
ch = new SocketInChannel();
ch.ChannelName = "ImageArrival";
ch.Enable = true;
ch.OperationName = "ImageArrival";
ch.Rule.CheckProcessFlag = true;
ch.Rule.AutoUpdateProcessFlag = true;
#region Query CriterialItems for channel ImageArrival
ch.Rule.QueryCriteria.Type = QueryCriteriaRuleType.DataSet;
// ImageArrival
SocketInQueryCriteriaItem ciImageArrival = new SocketInQueryCriteriaItem();
ciImageArrival.Type = QueryCriteriaType.Or;
ciImageArrival.SourceField = "Commandtype";
ciImageArrival.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ciImageArrival.ThirdPartyDBPatamter.FieldName = "Commandtype";
ciImageArrival.Translating.ConstValue = Convert.ToInt32(CommandBase.CommandTypeEnum.IMAGE_ARRIVAL).ToString();
ciImageArrival.Operator = QueryCriteriaOperator.Equal;
ch.Rule.QueryCriteria.MappingList.Add(ciImageArrival);
#endregion
#region Query Result for channel ImageArrival
// Commantype -> DataIndex.Event_Type
ri = new SocketInQueryResultItem();
ri.SourceField = "Commandtype";
ri.TargetField = "Event_Type";
ri.GWDataDBField.FieldName = "Event_Type";
ri.GWDataDBField.Table = GWDataDBTable.Index;
ri.ThirdPartyDBPatamter.FieldName = "Commandtype";
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ri.Translating.LutName = lt.TableName;
ri.Translating.Type = TranslatingType.LookUpTable;
ch.Rule.QueryResult.MappingList.Add(ri);
// CommandGUID -> DataIndex.Record_Index_1
ri = new SocketInQueryResultItem();
ri.SourceField = "CommandGUID";
ri.TargetField = "Record_Index_1";
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 SocketInQueryResultItem();
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);
// AccessionNumber -> Order.Order_No
ri = new SocketInQueryResultItem();
ri.SourceField = "AccessionNumber";
ri.TargetField = "Order_No";
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 SocketInQueryResultItem();
ri.SourceField = "Performed_startdt";
ri.TargetField = "Exam_DT";
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);
// Important: CommandType=ImageArrival -> Exam_Status = 18
ri = new SocketInQueryResultItem();
ri.SourceField = "";
ri.TargetField = "Exam_Status";
ri.GWDataDBField.FieldName = "Exam_Status";
ri.GWDataDBField.Table = GWDataDBTable.Order;
ri.Translating.Type = TranslatingType.FixValue;
ri.Translating.ConstValue = "18";
ch.Rule.QueryResult.MappingList.Add(ri);
#endregion //Channel for ImageArrival
Config.InboundChanels.Add(ch);
#endregion
#endregion
#region ThrPartDBParameters
#endregion
return(Config);
}