public static void PreperatMappingList <T>(XCollection <T> target, XCollection <T> source)
where T : XObject, IDicomMappingItem
{
if (target == null || source == null)
{
return;
}
target.Clear();
int count = source.Count;
for (int i = 0; i < source.Count; i++)
{
T t = source[i];
if (t.DPath.Enable == false && t.DPath.Type == DPathType.Normal)
{
if (t.DPath.VR == DVR.SQ)
{
EatDisableSequence(source, ref i);
}
continue;
}
target.Add(t);
}
}
private void enumCmbbxOperationType_SelectedIndexChanged(object sender, EventArgs e)
{
if (enumCmbbxOperationType.Text == ThrPartyDBOperationType.StorageProcedure.ToString())
{
lblModeName.Text = "Storage Procedure Name";
panelModeName.Visible = true;
lblCriteria.Text = "Input parameter";
lstvCriteria.Visible = true;
btnCriteriaAdd.Visible = true;
btnCriteriaModify.Visible = true;
btnCriteriaDelete.Visible = true;
txtStatement.Visible = false;
//btnApply.Visible = false;
btnApply.Text = "Advance";
txtStatement.Text = "";
ShowCriteriaList();
}
else
{
lblModeName.Text = enumCmbbxOperationType.Text + " Name";
panelModeName.Visible = false;
lblCriteria.Text = "SQL Statement";
lstvCriteria.Visible = false;
btnCriteriaAdd.Visible = false;
btnCriteriaModify.Visible = false;
btnCriteriaDelete.Visible = false;
txtStatement.Visible = true;
//btnApply.Visible = true;
btnApply.Text = "Apply";
txtStatement.Text = channel.Rule.QueryCriteria.SQLStatement;
criteriaItemList.Clear();
}
if (enumCmbbxOperationType.Text != ThrPartyDBOperationType.StorageProcedure.ToString())
{
if (txtStatement.Text.Trim() == "")
{
if (parentForm.DBconfig.ConnectionParameter.FileConnection)
{
txtStatement.Text = "select * from {FileName}";
}
else
{
txtStatement.Text = "select * from";
}
}
}
}
private void SaveChecked()
{
_FileFields.Clear();
for (int i = 0; i < this.listView1.Items.Count; i++)
{
ListViewItem lvi = this.listView1.Items[i];
GWDataDBField dbf = (GWDataDBField)lvi.Tag;
if (lvi.Checked)
{
_FileFields.Add(dbf);
}
}
}
private void LoadDefaultInboundSP()
{
channelSet.Clear();
string interfaceName = Program.DeviceMgt.DeviceDirInfor.Header.Name;
//Patient Table
SQLInboundChanel chnPatient = channelSet.Add(new SQLInboundChanel());
chnPatient.Rule.RuleID = GWDataDBTable.Patient.ToString();
chnPatient.SPName = "sp_" + interfaceName + "_" + GWDataDBTable.Patient.ToString();
LoadTableParameter(chnPatient, GWDataDBTable.Index, interfaceName);
LoadTableParameter(chnPatient, GWDataDBTable.Patient, interfaceName);
chnPatient.SPStatement = RuleControl.GetInboundSP(interfaceName, chnPatient.Rule, false);
//Order Table
SQLInboundChanel chnOrder = channelSet.Add(new SQLInboundChanel());
chnOrder.Rule.RuleID = GWDataDBTable.Order.ToString();
chnOrder.SPName = "sp_" + interfaceName + "_" + GWDataDBTable.Order.ToString();
LoadTableParameter(chnOrder, GWDataDBTable.Index, interfaceName);
LoadTableParameter(chnOrder, GWDataDBTable.Patient, interfaceName);
LoadTableParameter(chnOrder, GWDataDBTable.Order, interfaceName);
chnOrder.SPStatement = RuleControl.GetInboundSP(interfaceName, chnOrder.Rule, false);
//Report Table
SQLInboundChanel chnReport = channelSet.Add(new SQLInboundChanel());
chnReport.Rule.RuleID = GWDataDBTable.Report.ToString();
chnReport.SPName = "sp_" + interfaceName + "_" + GWDataDBTable.Report.ToString();
LoadTableParameter(chnReport, GWDataDBTable.Index, interfaceName);
LoadTableParameter(chnReport, GWDataDBTable.Patient, interfaceName);
LoadTableParameter(chnReport, GWDataDBTable.Order, interfaceName);
LoadTableParameter(chnReport, GWDataDBTable.Report, interfaceName);
chnReport.SPStatement = RuleControl.GetInboundSP(interfaceName, chnReport.Rule, false);
}
public static bool LoadDefaultPassiveChannels(XCollection <SQLOutboundChanel> chs, string Prefix, string interfaceName)
{
//XCollection<SQLOutboundChanel> chs = new XCollection<SQLOutboundChanel>();
chs.Clear();
SQLOutboundChanel ch;
int iFieldID = 0;
SQLOutQueryResultItem ri;
#region CH_Patient
ch = new SQLOutboundChanel();
ch.ChannelName = "CH_PATITENT";
ch.SPName = Prefix + GWDataDBTable.Patient.ToString();
ch.OperationType = ThrPartyDBOperationType.StorageProcedure;
ch.Modified = false;
#region Criteria
SQLOutQueryCriteriaItem ci = new SQLOutQueryCriteriaItem();
ch.Rule.QueryCriteria.Type = QueryCriteriaRuleType.DataSet;
ci.GWDataDBField = GWDataDBField.i_EventType;
ci.Operator = QueryCriteriaOperator.Equal;
ci.Type = QueryCriteriaType.Or;
ci.SourceField = ci.GWDataDBField.GetFullFieldName();
ci.TargetField = ci.GWDataDBField.GetFullFieldName();
ci.Translating.Type = TranslatingType.FixValue;
ci.Translating.ConstValue = "00";
ch.Rule.QueryCriteria.MappingList.Add(ci);
ci = new SQLOutQueryCriteriaItem();
ch.Rule.QueryCriteria.Type = QueryCriteriaRuleType.DataSet;
ci.GWDataDBField = GWDataDBField.i_EventType;
ci.Operator = QueryCriteriaOperator.Equal;
ci.Type = QueryCriteriaType.Or;
ci.SourceField = ci.GWDataDBField.GetFullFieldName();
ci.TargetField = ci.GWDataDBField.GetFullFieldName();
ci.Translating.Type = TranslatingType.FixValue;
ci.Translating.ConstValue = "01";
ch.Rule.QueryCriteria.MappingList.Add(ci);
ci = new SQLOutQueryCriteriaItem();
ch.Rule.QueryCriteria.Type = QueryCriteriaRuleType.DataSet;
ci.GWDataDBField = GWDataDBField.i_EventType;
ci.Operator = QueryCriteriaOperator.Equal;
ci.Type = QueryCriteriaType.Or;
ci.SourceField = ci.GWDataDBField.GetFullFieldName();
ci.TargetField = ci.GWDataDBField.GetFullFieldName();
ci.Translating.Type = TranslatingType.FixValue;
ci.Translating.ConstValue = "02";
ch.Rule.QueryCriteria.MappingList.Add(ci);
ci = new SQLOutQueryCriteriaItem();
ch.Rule.QueryCriteria.Type = QueryCriteriaRuleType.DataSet;
ci.GWDataDBField = GWDataDBField.i_EventType;
ci.Operator = QueryCriteriaOperator.Equal;
ci.Type = QueryCriteriaType.Or;
ci.SourceField = ci.GWDataDBField.GetFullFieldName();
ci.TargetField = ci.GWDataDBField.GetFullFieldName();
ci.Translating.Type = TranslatingType.FixValue;
ci.Translating.ConstValue = "03";
ch.Rule.QueryCriteria.MappingList.Add(ci);
#endregion
#region Result
iFieldID = 0;
foreach (GWDataDBField f in GWDataDBField.GetFields(GWDataDBTable.Index))
{
// Third party application need to use this ID to update process flag
//if (f.GetFullFieldName() == GWDataDBField.i_IndexGuid.GetFullFieldName()) continue;
if (f.GetFullFieldName() == GWDataDBField.i_DataDateTime.GetFullFieldName())
{
continue;
}
if (f.GetFullFieldName() == GWDataDBField.i_PROCESS_FLAG.GetFullFieldName())
{
continue;
}
ri = new SQLOutQueryResultItem();
ri.GWDataDBField = f;
ri.SourceField = f.FieldName.ToUpper();
ri.TargetField = f.GetFullFieldName().Replace(".", "_").ToUpper();
ri.ThirdPartyDBPatamter.FieldName = f.GetFullFieldName().Replace(".", "_").ToUpper();
ri.ThirdPartyDBPatamter.FieldID = ++iFieldID;
ri.Translating.Type = TranslatingType.None;
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ri.Translating.Type = TranslatingType.None;
ch.Rule.QueryResult.MappingList.Add(ri);
}
foreach (GWDataDBField f in GWDataDBField.GetFields(GWDataDBTable.Patient))
{
if (f.GetFullFieldName() == GWDataDBField.p_DATA_ID.GetFullFieldName())
{
continue;
}
if (f.GetFullFieldName() == GWDataDBField.p_DATA_DT.GetFullFieldName())
{
continue;
}
ri = new SQLOutQueryResultItem();
ri.GWDataDBField = f;
ri.SourceField = f.FieldName.ToUpper();
ri.TargetField = f.GetFullFieldName().Replace(".", "_").ToUpper();
ri.ThirdPartyDBPatamter.FieldName = f.GetFullFieldName().Replace(".", "_").ToUpper();
ri.ThirdPartyDBPatamter.FieldID = ++iFieldID;
ri.Translating.Type = TranslatingType.None;
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ri.Translating.Type = TranslatingType.None;
ch.Rule.QueryResult.MappingList.Add(ri);
}
chs.Add(ch);
#endregion
ch.Rule.RuleID = GWDataDBTable.Patient.ToString();
ch.SPStatement = RuleControl.GetOutboundSP(interfaceName, ch.Rule);
#endregion
#region CH_Order
ch = new SQLOutboundChanel();
ch.ChannelName = "CH_ORDER";
ch.SPName = Prefix + GWDataDBTable.Order.ToString();
ch.OperationType = ThrPartyDBOperationType.StorageProcedure;
ch.Modified = false;
#region Criteria
ci = new SQLOutQueryCriteriaItem();
ch.Rule.QueryCriteria.Type = QueryCriteriaRuleType.DataSet;
ci.GWDataDBField = GWDataDBField.i_EventType;
ci.Operator = QueryCriteriaOperator.Equal;
ci.Type = QueryCriteriaType.Or;
ci.SourceField = ci.GWDataDBField.GetFullFieldName();
ci.TargetField = ci.GWDataDBField.GetFullFieldName();
ci.Translating.Type = TranslatingType.FixValue;
ci.Translating.ConstValue = "10";
ch.Rule.QueryCriteria.MappingList.Add(ci);
ci = new SQLOutQueryCriteriaItem();
ch.Rule.QueryCriteria.Type = QueryCriteriaRuleType.DataSet;
ci.GWDataDBField = GWDataDBField.i_EventType;
ci.Operator = QueryCriteriaOperator.Equal;
ci.Type = QueryCriteriaType.Or;
ci.SourceField = ci.GWDataDBField.GetFullFieldName();
ci.TargetField = ci.GWDataDBField.GetFullFieldName();
ci.Translating.Type = TranslatingType.FixValue;
ci.Translating.ConstValue = "11";
ch.Rule.QueryCriteria.MappingList.Add(ci);
ci = new SQLOutQueryCriteriaItem();
ch.Rule.QueryCriteria.Type = QueryCriteriaRuleType.DataSet;
ci.GWDataDBField = GWDataDBField.i_EventType;
ci.Operator = QueryCriteriaOperator.Equal;
ci.Type = QueryCriteriaType.Or;
ci.SourceField = ci.GWDataDBField.GetFullFieldName();
ci.TargetField = ci.GWDataDBField.GetFullFieldName();
ci.Translating.Type = TranslatingType.FixValue;
ci.Translating.ConstValue = "12";
ch.Rule.QueryCriteria.MappingList.Add(ci);
ci = new SQLOutQueryCriteriaItem();
ch.Rule.QueryCriteria.Type = QueryCriteriaRuleType.DataSet;
ci.GWDataDBField = GWDataDBField.i_EventType;
ci.Operator = QueryCriteriaOperator.Equal;
ci.Type = QueryCriteriaType.Or;
ci.SourceField = ci.GWDataDBField.GetFullFieldName();
ci.TargetField = ci.GWDataDBField.GetFullFieldName();
ci.Translating.Type = TranslatingType.FixValue;
ci.Translating.ConstValue = "13";
ch.Rule.QueryCriteria.MappingList.Add(ci);
#endregion
#region Result
iFieldID = 0;
foreach (GWDataDBField f in GWDataDBField.GetFields(GWDataDBTable.Index))
{
// Third party application need to use this ID to update process flag
//if (f.GetFullFieldName() == GWDataDBField.i_IndexGuid.GetFullFieldName()) continue;
if (f.GetFullFieldName() == GWDataDBField.i_DataDateTime.GetFullFieldName())
{
continue;
}
if (f.GetFullFieldName() == GWDataDBField.i_PROCESS_FLAG.GetFullFieldName())
{
continue;
}
ri = new SQLOutQueryResultItem();
ri.GWDataDBField = f;
ri.SourceField = f.FieldName.ToUpper();
ri.TargetField = f.GetFullFieldName().Replace(".", "_").ToUpper();
ri.ThirdPartyDBPatamter.FieldName = f.GetFullFieldName().Replace(".", "_").ToUpper();
ri.ThirdPartyDBPatamter.FieldID = ++iFieldID;
ri.Translating.Type = TranslatingType.None;
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ch.Rule.QueryResult.MappingList.Add(ri);
}
foreach (GWDataDBField f in GWDataDBField.GetFields(GWDataDBTable.Patient))
{
if (f.GetFullFieldName() == GWDataDBField.p_DATA_ID.GetFullFieldName())
{
continue;
}
if (f.GetFullFieldName() == GWDataDBField.p_DATA_DT.GetFullFieldName())
{
continue;
}
ri = new SQLOutQueryResultItem();
ri.GWDataDBField = f;
ri.SourceField = f.FieldName.ToUpper();
ri.TargetField = f.GetFullFieldName().Replace(".", "_").ToUpper();
ri.ThirdPartyDBPatamter.FieldName = f.GetFullFieldName().Replace(".", "_").ToUpper();
ri.ThirdPartyDBPatamter.FieldID = ++iFieldID;
ri.Translating.Type = TranslatingType.None;
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ch.Rule.QueryResult.MappingList.Add(ri);
}
foreach (GWDataDBField f in GWDataDBField.GetFields(GWDataDBTable.Order))
{
if (f.GetFullFieldName() == GWDataDBField.o_DATA_ID.GetFullFieldName())
{
continue;
}
if (f.GetFullFieldName() == GWDataDBField.o_DATA_DT.GetFullFieldName())
{
continue;
}
ri = new SQLOutQueryResultItem();
ri.GWDataDBField = f;
ri.SourceField = f.FieldName.ToUpper();
ri.TargetField = f.GetFullFieldName().Replace(".", "_").ToUpper();
ri.ThirdPartyDBPatamter.FieldName = f.GetFullFieldName().Replace(".", "_").ToUpper();
ri.ThirdPartyDBPatamter.FieldID = ++iFieldID;
ri.Translating.Type = TranslatingType.None;
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ch.Rule.QueryResult.MappingList.Add(ri);
}
chs.Add(ch);
#endregion
ch.Rule.RuleID = GWDataDBTable.Order.ToString();
ch.SPStatement = RuleControl.GetOutboundSP(interfaceName, ch.Rule);
#endregion
#region CH_Report
ch = new SQLOutboundChanel();
ch.ChannelName = "CH_REPORT";
ch.SPName = Prefix + GWDataDBTable.Report.ToString();
ch.OperationType = ThrPartyDBOperationType.StorageProcedure;
ch.Modified = false;
#region Criteria
ci = new SQLOutQueryCriteriaItem();
ch.Rule.QueryCriteria.Type = QueryCriteriaRuleType.DataSet;
ci.GWDataDBField = GWDataDBField.i_EventType;
ci.Operator = QueryCriteriaOperator.Equal;
ci.Type = QueryCriteriaType.Or;
ci.SourceField = ci.GWDataDBField.GetFullFieldName();
ci.TargetField = ci.GWDataDBField.GetFullFieldName();
ci.Translating.Type = TranslatingType.FixValue;
ci.Translating.ConstValue = "30";
ch.Rule.QueryCriteria.MappingList.Add(ci);
ci = new SQLOutQueryCriteriaItem();
ch.Rule.QueryCriteria.Type = QueryCriteriaRuleType.DataSet;
ci.GWDataDBField = GWDataDBField.i_EventType;
ci.Operator = QueryCriteriaOperator.Equal;
ci.Type = QueryCriteriaType.Or;
ci.SourceField = ci.GWDataDBField.GetFullFieldName();
ci.TargetField = ci.GWDataDBField.GetFullFieldName();
ci.Translating.Type = TranslatingType.FixValue;
ci.Translating.ConstValue = "31";
ch.Rule.QueryCriteria.MappingList.Add(ci);
ci = new SQLOutQueryCriteriaItem();
ch.Rule.QueryCriteria.Type = QueryCriteriaRuleType.DataSet;
ci.GWDataDBField = GWDataDBField.i_EventType;
ci.Operator = QueryCriteriaOperator.Equal;
ci.Type = QueryCriteriaType.Or;
ci.SourceField = ci.GWDataDBField.GetFullFieldName();
ci.TargetField = ci.GWDataDBField.GetFullFieldName();
ci.Translating.Type = TranslatingType.FixValue;
ci.Translating.ConstValue = "32";
ch.Rule.QueryCriteria.MappingList.Add(ci);
ci = new SQLOutQueryCriteriaItem();
ch.Rule.QueryCriteria.Type = QueryCriteriaRuleType.DataSet;
ci.GWDataDBField = GWDataDBField.i_EventType;
ci.Operator = QueryCriteriaOperator.Equal;
ci.Type = QueryCriteriaType.Or;
ci.SourceField = ci.GWDataDBField.GetFullFieldName();
ci.TargetField = ci.GWDataDBField.GetFullFieldName();
ci.Translating.Type = TranslatingType.FixValue;
ci.Translating.ConstValue = "33";
ch.Rule.QueryCriteria.MappingList.Add(ci);
#endregion
#region Result
iFieldID = 0;
foreach (GWDataDBField f in GWDataDBField.GetFields(GWDataDBTable.Index))
{
// Third party application need to use this ID to update process flag
//if (f.GetFullFieldName() == GWDataDBField.i_IndexGuid.GetFullFieldName()) continue;
if (f.GetFullFieldName() == GWDataDBField.i_DataDateTime.GetFullFieldName())
{
continue;
}
if (f.GetFullFieldName() == GWDataDBField.i_PROCESS_FLAG.GetFullFieldName())
{
continue;
}
ri = new SQLOutQueryResultItem();
ri.GWDataDBField = f;
ri.SourceField = f.FieldName.ToUpper();
ri.TargetField = f.GetFullFieldName().Replace(".", "_").ToUpper();
ri.ThirdPartyDBPatamter.FieldName = f.GetFullFieldName().Replace(".", "_").ToUpper();
ri.ThirdPartyDBPatamter.FieldID = ++iFieldID;
ri.Translating.Type = TranslatingType.None;
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ch.Rule.QueryResult.MappingList.Add(ri);
}
foreach (GWDataDBField f in GWDataDBField.GetFields(GWDataDBTable.Patient))
{
if (f.GetFullFieldName() == GWDataDBField.p_DATA_ID.GetFullFieldName())
{
continue;
}
if (f.GetFullFieldName() == GWDataDBField.p_DATA_DT.GetFullFieldName())
{
continue;
}
ri = new SQLOutQueryResultItem();
ri.GWDataDBField = f;
ri.SourceField = f.FieldName.ToUpper();
ri.TargetField = f.GetFullFieldName().Replace(".", "_").ToUpper();
ri.ThirdPartyDBPatamter.FieldName = f.GetFullFieldName().Replace(".", "_").ToUpper();
ri.ThirdPartyDBPatamter.FieldID = ++iFieldID;
ri.Translating.Type = TranslatingType.None;
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ch.Rule.QueryResult.MappingList.Add(ri);
}
foreach (GWDataDBField f in GWDataDBField.GetFields(GWDataDBTable.Order))
{
if (f.GetFullFieldName() == GWDataDBField.o_DATA_ID.GetFullFieldName())
{
continue;
}
if (f.GetFullFieldName() == GWDataDBField.o_DATA_DT.GetFullFieldName())
{
continue;
}
ri = new SQLOutQueryResultItem();
ri.GWDataDBField = f;
ri.SourceField = f.FieldName.ToUpper();
ri.TargetField = f.GetFullFieldName().Replace(".", "_").ToUpper();
ri.ThirdPartyDBPatamter.FieldName = f.GetFullFieldName().Replace(".", "_").ToUpper();
ri.ThirdPartyDBPatamter.FieldID = ++iFieldID;
ri.Translating.Type = TranslatingType.None;
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ch.Rule.QueryResult.MappingList.Add(ri);
}
foreach (GWDataDBField f in GWDataDBField.GetFields(GWDataDBTable.Report))
{
if (f.GetFullFieldName() == GWDataDBField.r_DATA_ID.GetFullFieldName())
{
continue;
}
if (f.GetFullFieldName() == GWDataDBField.r_DATA_DT.GetFullFieldName())
{
continue;
}
ri = new SQLOutQueryResultItem();
ri.GWDataDBField = f;
ri.SourceField = f.FieldName.ToUpper();
ri.TargetField = f.GetFullFieldName().Replace(".", "_").ToUpper();
ri.ThirdPartyDBPatamter.FieldName = f.GetFullFieldName().Replace(".", "_").ToUpper();
ri.ThirdPartyDBPatamter.FieldID = ++iFieldID;
ri.Translating.Type = TranslatingType.None;
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ch.Rule.QueryResult.MappingList.Add(ri);
}
chs.Add(ch);
#endregion
ch.Rule.RuleID = GWDataDBTable.Report.ToString();
ch.SPStatement = RuleControl.GetOutboundSP(interfaceName, ch.Rule);
#endregion
return(true);
}
