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); }