private void RefreshFieldList(GWDataDBTable table)
{
_comboField.Items.Clear();
_comboField.Enabled = (table != GWDataDBTable.None);
GWDataDBField[] fieldList;
if (_isInbound)
{
fieldList = GWDataDBField.GetFields(table, DirectionType.INBOUND);
}
else
{
fieldList = GWDataDBField.GetFields(table, DirectionType.OUTBOUND);
}
if (fieldList == null)
{
return;
}
foreach (GWDataDBField field in fieldList)
{
if (_isInbound && field.FieldName == GWDataDBField.i_EventType.FieldName)
{
continue;
}
_comboField.Items.Add(field.FieldName);
}
}
public static object[] GetGWDataField_Left(GWDataDBTable table, GWDataDBField[] Fields)
{
List <object> strList = new List <object>();
GWDataDBField[] allFields = GWDataDBField.GetFields(table, HYS.Common.Objects.Device.DirectionType.INBOUND);
bool bExist;
foreach (GWDataDBField af in allFields)
{
bExist = false;
foreach (GWDataDBField f in Fields)
{
if (af.GetFullFieldName() == f.GetFullFieldName())
{
bExist = true;
break;
}
}
if (!bExist)
{
strList.Add(af.FieldName);
}
}
return(strList.ToArray());
}
private void comboBoxInTable_SelectedIndexChanged(object sender, EventArgs e)
{
GWDataDBTable table = (GWDataDBTable)Enum.Parse(typeof(GWDataDBTable), comboBoxInTable.Text);
if (table == GWDataDBTable.None)
{
this.comboBoxInField.Items.Clear();
return;
}
GWDataDBField[] fields = GWDataDBField.GetFields(table);
this.comboBoxInField.Items.Clear();
foreach (GWDataDBField field in fields)
{
if (field.FieldName.ToUpper() == GWDataDBField.i_IndexGuid.FieldName.ToUpper())
{
continue;
}
if (field.FieldName.ToUpper() == GWDataDBField.i_DataDateTime.FieldName.ToUpper())
{
continue;
}
if (field.FieldName.ToUpper() == GWDataDBField.i_PROCESS_FLAG.FieldName.ToUpper())
{
continue;
}
if (field.FieldName.ToUpper() == GWDataDBField.p_DATA_ID.FieldName.ToUpper())
{
continue;
}
if (field.FieldName.ToUpper() == GWDataDBField.p_DATA_DT.FieldName.ToUpper())
{
continue;
}
if (field.FieldName.ToUpper() == GWDataDBField.o_DATA_ID.FieldName.ToUpper())
{
continue;
}
if (field.FieldName.ToUpper() == GWDataDBField.o_DATA_DT.FieldName.ToUpper())
{
continue;
}
if (field.FieldName.ToUpper() == GWDataDBField.r_DATA_ID.FieldName.ToUpper())
{
continue;
}
if (field.FieldName.ToUpper() == GWDataDBField.r_DATA_DT.FieldName.ToUpper())
{
continue;
}
this.comboBoxInField.Items.Add(field.FieldName);
}
this.comboBoxInField.SelectedIndex = 0;
}
private void LoadTableParameter(SQLInboundChanel chn, GWDataDBTable table, string interfaceName)
{
GWDataDBField[] iFields = GWDataDBField.GetFields(table);
foreach (GWDataDBField field in iFields)
{
if (field.IsAuto)
{
continue;
}
string paramName = field.GetFullFieldName(Program.DeviceMgt.DeviceDirInfor.Header.Name).Replace(".", "_");
SQLInQueryResultItem item = new SQLInQueryResultItem(field, paramName);
chn.Rule.QueryResult.MappingList.Add(item);
}
}
private XCollection <GWDataDBField> ParseTemplate()
{
XCollection <GWDataDBField> fields = new XCollection <GWDataDBField>();
string s, sub;
s = tbTemplate.Text;
foreach (GWDataDBField f in GWDataDBField.GetFields(GWDataDBTable.Index))
{
sub = "[%" + f.GetFullFieldName().Replace(".", "_") + "%]";
if (s.IndexOf(sub) >= 0)
{
fields.Add(f);
}
}
foreach (GWDataDBField f in GWDataDBField.GetFields(GWDataDBTable.Patient))
{
sub = "[%" + f.GetFullFieldName().Replace(".", "_") + "%]";
if (s.IndexOf(sub) >= 0)
{
fields.Add(f);
}
}
foreach (GWDataDBField f in GWDataDBField.GetFields(GWDataDBTable.Order))
{
sub = "[%" + f.GetFullFieldName().Replace(".", "_") + "%]";
if (s.IndexOf(sub) >= 0)
{
fields.Add(f);
}
}
foreach (GWDataDBField f in GWDataDBField.GetFields(GWDataDBTable.Report))
{
sub = "[%" + f.GetFullFieldName().Replace(".", "_") + "%]";
if (s.IndexOf(sub) >= 0)
{
fields.Add(f);
}
}
return(fields);
}
private void LoadCriteria(MatchField criteria)
{
GWDataDBField[] fields = GWDataDBField.GetFields((GWDataDBTable)Enum.Parse(typeof(GWDataDBTable), criteria.TableName));
this.comboBoxOutField.Items.Clear();
foreach (GWDataDBField field in fields)
{
this.comboBoxOutField.Items.Add(field.FieldName);
}
this.comboBoxOutTable.Text = criteria.TableName;
this.comboBoxOutField.Text = criteria.FieldName;
this.comboBoxLogicOperator.Text = criteria.LogicOperator.ToString();
if (criteria.FixValue.ValueType == FieldValueType.FixValue)
{
this.textBoxFixValue.Text = criteria.FixValue.Value;
this.radioButtonFixValue.Checked = true;
this.radioButtonInboundField.Checked = false;
textBoxFixValue.Enabled = true;
comboBoxInTable.Enabled = false;
comboBoxInField.Enabled = false;
}
else
{
fields = GWDataDBField.GetFields((GWDataDBTable)Enum.Parse(typeof(GWDataDBTable), criteria.FixValue.InboundTableName));
this.comboBoxInField.Items.Clear();
foreach (GWDataDBField field in fields)
{
this.comboBoxInField.Items.Add(field.FieldName);
}
this.comboBoxInTable.Text = criteria.FixValue.InboundTableName;
this.comboBoxInField.Text = criteria.FixValue.InboundFieldName;
this.radioButtonFixValue.Checked = false;
this.radioButtonInboundField.Checked = true;
textBoxFixValue.Enabled = false;
comboBoxInTable.Enabled = true;
comboBoxInField.Enabled = true;;
}
}
private void LoadTableSetting(SQLOutboundChanel chn, GWDataDBTable table, string inboundName, string tablePrefix)
{
GWDataDBField[] iFields = GWDataDBField.GetFields(table);
foreach (GWDataDBField f in iFields)
{
if (f.IsAuto)
{
continue;
}
string paramName = f.GetFullFieldName(inboundName).Replace(".", "_");
SQLOutQueryResultItem item = new SQLOutQueryResultItem();
item.SourceField = f.GetFullFieldName(tablePrefix);
item.GWDataDBField = f;
item.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
item.ThirdPartyDBPatamter.FieldName = paramName;
item.TargetField = paramName;
chn.Rule.QueryResult.MappingList.Add(item);
}
}
private void button5_Click(object sender, EventArgs e)
{
StringBuilder sb = new StringBuilder();
#region Index
sb.AppendLine("[F_INDEX]");
sb.AppendLine("EVENT_TYPE=00");
foreach (GWDataDBField f in GWDataDBField.GetFields(GWDataDBTable.Index))
{
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;
}
if (f.GetFullFieldName() == GWDataDBField.i_EventType.GetFullFieldName())
{
continue;
}
sb.AppendLine(f.FieldName.ToUpper() + "=" + f.FieldName.ToUpper());
}
#endregion
#region Patient
sb.AppendLine("");
sb.AppendLine("[F_PATIENT]");
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;
}
sb.AppendLine(f.FieldName.ToUpper() + "=" + f.FieldName.ToUpper());
}
#endregion
#region Order
sb.AppendLine("");
sb.AppendLine("[F_ORDER]");
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;
}
sb.AppendLine(f.FieldName.ToUpper() + "=" + f.FieldName.ToUpper());
}
#endregion
#region Report
sb.AppendLine("");
sb.AppendLine("[F_REPORT]");
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;
}
sb.AppendLine(f.FieldName.ToUpper() + "=" + f.FieldName.ToUpper());
}
#endregion
this.tbIniFile.Text = sb.ToString();
}
private void LoadFields()
{
this.listView1.Items.Clear();
GWDataDBField[] Index = GWDataDBField.GetFields(GWDataDBTable.Index);
GWDataDBField[] Patient = GWDataDBField.GetFields(GWDataDBTable.Patient);
GWDataDBField[] Order = GWDataDBField.GetFields(GWDataDBTable.Order);
GWDataDBField[] Report = GWDataDBField.GetFields(GWDataDBTable.Report);
foreach (GWDataDBField item in Index)
{
if (item.FieldName.ToUpper() == GWDataDBField.i_IndexGuid.FieldName.ToUpper())
{
continue;
}
if (item.FieldName.ToUpper() == GWDataDBField.i_DataDateTime.FieldName.ToUpper())
{
continue;
}
if (item.FieldName.ToUpper() == GWDataDBField.i_PROCESS_FLAG.FieldName.ToUpper())
{
continue;
}
ListViewItem lvi = this.listView1.Items.Add("");
lvi.SubItems.Add(item.FieldName);
lvi.Group = listView1.Groups["grpIndex"];
lvi.Tag = item;
}
foreach (GWDataDBField item in Patient)
{
if (item.FieldName.ToUpper() == GWDataDBField.p_DATA_ID.FieldName.ToUpper())
{
continue;
}
if (item.FieldName.ToUpper() == GWDataDBField.p_DATA_DT.FieldName.ToUpper())
{
continue;
}
ListViewItem lvi = this.listView1.Items.Add("");
lvi.SubItems.Add(item.FieldName);
lvi.Group = listView1.Groups["grpPatient"];
lvi.Tag = item;
}
foreach (GWDataDBField item in Order)
{
if (item.FieldName.ToUpper() == GWDataDBField.o_DATA_ID.FieldName.ToUpper())
{
continue;
}
if (item.FieldName.ToUpper() == GWDataDBField.o_DATA_DT.FieldName.ToUpper())
{
continue;
}
ListViewItem lvi = this.listView1.Items.Add("");
lvi.SubItems.Add(item.FieldName);
lvi.Group = listView1.Groups["grpOrder"];
lvi.Tag = item;
}
foreach (GWDataDBField item in Report)
{
if (item.FieldName.ToUpper() == GWDataDBField.r_DATA_ID.FieldName.ToUpper())
{
continue;
}
if (item.FieldName.ToUpper() == GWDataDBField.r_DATA_DT.FieldName.ToUpper())
{
continue;
}
ListViewItem lvi = this.listView1.Items.Add("");
lvi.SubItems.Add(item.FieldName);
lvi.Group = listView1.Groups["grpReport"];
lvi.Tag = item;
}
}
protected virtual GWDataDBField[] GetFieldList(GWDataDBTable table, DirectionType direction)
{
return(GWDataDBField.GetFields(table, directionType));
}
public static FileInChannel BuildReportChannel()
{
#region General
FileInChannel ch = new FileInChannel();
ch.ChannelName = "CH_REPORT";
ch.Enable = true;
ch.OperationName = "";
ch.Rule.AutoUpdateProcessFlag = true;
ch.Rule.CheckProcessFlag = true;
ch.Rule.RuleID = "CH_REPORT";
ch.Rule.RuleName = "CH_REPORT";
ch.Rule.QueryCriteria.Type = QueryCriteriaRuleType.DataSet;
#endregion
#region Critera
FileInQueryCriteriaItem ci = new FileInQueryCriteriaItem();
ci.Operator = QueryCriteriaOperator.Equal;
ci.Type = QueryCriteriaType.Or;
ci.SourceField = "F_INDEX_EVENT_TYPE";
//ci.TargetField = "EVENT_TYPE";
//ci.GWDataDBField = f.Clone();
ci.ThirdPartyDBPatamter.FieldName = "EVENT_TYPE";
ci.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ci.ThirdPartyDBPatamter.SectionName = "F_INDEX";
ci.Translating.Type = TranslatingType.FixValue;
ci.Singal = QueryCriteriaSignal.None;
ci.RedundancyFlag = false;
ci.ThirdPartyDBPatamter.FieldID = 1;
ci.Translating.ConstValue = "30";
ch.Rule.QueryCriteria.MappingList.Add(ci);
//CRITERIA
ci = new FileInQueryCriteriaItem();
ci.Operator = QueryCriteriaOperator.Equal;
ci.Type = QueryCriteriaType.Or;
ci.SourceField = "F_INDEX_EVENT_TYPE";
//ci.TargetField = "EVENT_TYPE";
//ci.GWDataDBField = f.Clone();
ci.ThirdPartyDBPatamter.FieldName = "EVENT_TYPE";
ci.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ci.ThirdPartyDBPatamter.SectionName = "F_INDEX";
ci.Translating.Type = TranslatingType.FixValue;
ci.Singal = QueryCriteriaSignal.None;
ci.RedundancyFlag = false;
ci.ThirdPartyDBPatamter.FieldID = 2;
ci.Translating.ConstValue = "31";
ch.Rule.QueryCriteria.MappingList.Add(ci);
//CRITERIA
ci = new FileInQueryCriteriaItem();
ci.Operator = QueryCriteriaOperator.Equal;
ci.Type = QueryCriteriaType.Or;
ci.SourceField = "F_INDEX_EVENT_TYPE";
//ci.TargetField = "EVENT_TYPE";
//ci.GWDataDBField = f.Clone();
ci.ThirdPartyDBPatamter.FieldName = "EVENT_TYPE";
ci.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ci.ThirdPartyDBPatamter.SectionName = "F_INDEX";
ci.Translating.Type = TranslatingType.FixValue;
ci.Singal = QueryCriteriaSignal.None;
ci.RedundancyFlag = false;
ci.ThirdPartyDBPatamter.FieldID = 3;
ci.Translating.ConstValue = "32";
ch.Rule.QueryCriteria.MappingList.Add(ci);
//CRITERIA
ci = new FileInQueryCriteriaItem();
ci.Operator = QueryCriteriaOperator.Equal;
ci.Type = QueryCriteriaType.Or;
ci.SourceField = "F_INDEX_EVENT_TYPE";
//ci.TargetField = "EVENT_TYPE";
//ci.GWDataDBField = f.Clone();
ci.ThirdPartyDBPatamter.FieldName = "EVENT_TYPE";
ci.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ci.ThirdPartyDBPatamter.SectionName = "F_INDEX";
ci.Translating.Type = TranslatingType.FixValue;
ci.Singal = QueryCriteriaSignal.None;
ci.RedundancyFlag = false;
ci.ThirdPartyDBPatamter.FieldID = 4;
ci.Translating.ConstValue = "33";
ch.Rule.QueryCriteria.MappingList.Add(ci);
#endregion
#region Result Index
int iFieldID = 0;
foreach (GWDataDBField f in GWDataDBField.GetFields(GWDataDBTable.Index))
{
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;
}
//Result
FileInQueryResultItem ri = new FileInQueryResultItem();
ri.Translating.Type = TranslatingType.None;
ri.RedundancyFlag = false;
ri.ThirdPartyDBPatamter.SectionName = "F_INDEX";
ri.ThirdPartyDBPatamter.FieldName = f.FieldName.ToUpper();
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ri.ThirdPartyDBPatamter.FileFieldFlag = false;
ri.ThirdPartyDBPatamter.FieldID = ++iFieldID;
ri.SourceField = f.GetFullFieldName().ToUpper().Replace(".", "_");
ri.GWDataDBField = f.Clone();
ri.TargetField = f.GetFullFieldName().ToUpper().Replace(".", "_");
ch.Rule.QueryResult.MappingList.Add(ri);
}
#endregion
#region Result Patient
iFieldID = 0;
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;
}
//Result
FileInQueryResultItem ri = new FileInQueryResultItem();
ri.Translating.Type = TranslatingType.None;
ri.RedundancyFlag = false;
ri.ThirdPartyDBPatamter.SectionName = "F_PATIENT";
ri.ThirdPartyDBPatamter.FieldName = f.FieldName.ToUpper();
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ri.ThirdPartyDBPatamter.FileFieldFlag = false;
ri.ThirdPartyDBPatamter.FieldID = ++iFieldID;
ri.SourceField = f.GetFullFieldName().ToUpper().Replace(".", "_");
ri.GWDataDBField = f.Clone();
ri.TargetField = f.GetFullFieldName().ToUpper().Replace(".", "_");
ch.Rule.QueryResult.MappingList.Add(ri);
}
#endregion
#region Result ORDER
iFieldID = 0;
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;
}
//Result
FileInQueryResultItem ri = new FileInQueryResultItem();
ri.Translating.Type = TranslatingType.None;
ri.RedundancyFlag = false;
ri.ThirdPartyDBPatamter.SectionName = "F_ORDER";
ri.ThirdPartyDBPatamter.FieldName = f.FieldName.ToUpper();
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ri.ThirdPartyDBPatamter.FileFieldFlag = false;
ri.ThirdPartyDBPatamter.FieldID = ++iFieldID;
ri.SourceField = f.GetFullFieldName().ToUpper().Replace(".", "_");
ri.GWDataDBField = f.Clone();
ri.TargetField = f.GetFullFieldName().ToUpper().Replace(".", "_");
ch.Rule.QueryResult.MappingList.Add(ri);
}
#endregion
#region Result Report
iFieldID = 0;
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;
}
//Result
FileInQueryResultItem ri = new FileInQueryResultItem();
ri.Translating.Type = TranslatingType.None;
ri.RedundancyFlag = false;
ri.ThirdPartyDBPatamter.SectionName = "F_REPORT";
ri.ThirdPartyDBPatamter.FieldName = f.FieldName.ToUpper();
ri.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
ri.ThirdPartyDBPatamter.FileFieldFlag = false;
ri.ThirdPartyDBPatamter.FieldID = ++iFieldID;
ri.SourceField = f.GetFullFieldName().ToUpper().Replace(".", "_");
ri.GWDataDBField = f.Clone();
ri.TargetField = f.GetFullFieldName().ToUpper().Replace(".", "_");
ch.Rule.QueryResult.MappingList.Add(ri);
}
#endregion
return(ch);
}
private void LoadFields()
{
this.tViewField.Nodes.Clear();
GWDataDBField[] Index = GWDataDBField.GetFields(GWDataDBTable.Index);
GWDataDBField[] Patient = GWDataDBField.GetFields(GWDataDBTable.Patient);
GWDataDBField[] Order = GWDataDBField.GetFields(GWDataDBTable.Order);
GWDataDBField[] Report = GWDataDBField.GetFields(GWDataDBTable.Report);
tViewField.Nodes.Add("Index");
foreach (GWDataDBField item in Index)
{
if (item.FieldName.ToUpper() == GWDataDBField.i_IndexGuid.FieldName.ToUpper())
{
continue;
}
if (item.FieldName.ToUpper() == GWDataDBField.i_DataDateTime.FieldName.ToUpper())
{
continue;
}
if (item.FieldName.ToUpper() == GWDataDBField.i_PROCESS_FLAG.FieldName.ToUpper())
{
continue;
}
if (item.FieldName.ToUpper().Equals(GWDataDBField.i_EventType.FieldName.ToUpper()))
{
continue;
}
this.tViewField.Nodes[0].Nodes.Add(item.FieldName);
}
tViewField.Nodes.Add("Patient");
foreach (GWDataDBField item in Patient)
{
if (item.FieldName.ToUpper() == GWDataDBField.p_DATA_ID.FieldName.ToUpper())
{
continue;
}
if (item.FieldName.ToUpper() == GWDataDBField.p_DATA_DT.FieldName.ToUpper())
{
continue;
}
this.tViewField.Nodes[1].Nodes.Add(item.FieldName);
}
tViewField.Nodes.Add("Order");
foreach (GWDataDBField item in Order)
{
if (item.FieldName.ToUpper() == GWDataDBField.o_DATA_ID.FieldName.ToUpper())
{
continue;
}
if (item.FieldName.ToUpper() == GWDataDBField.o_DATA_DT.FieldName.ToUpper())
{
continue;
}
this.tViewField.Nodes[2].Nodes.Add(item.FieldName);
}
tViewField.Nodes.Add("Report");
foreach (GWDataDBField item in Report)
{
if (item.FieldName.ToUpper() == GWDataDBField.r_DATA_ID.FieldName.ToUpper())
{
continue;
}
if (item.FieldName.ToUpper() == GWDataDBField.r_DATA_DT.FieldName.ToUpper())
{
continue;
}
this.tViewField.Nodes[3].Nodes.Add(item.FieldName);
}
tViewField.ExpandAll();
}
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);
}