Exemple #1
0
        public QueryParameter(XCollection <SQLInQueryResultItem> parameters)
        {
            InitializeComponent();
            GetLUTTables();
            parameterList = parameters;
            parameterItem = new SQLInQueryResultItem();
            type          = "Add";
            this.Text     = "Add Parameter";

            GetGCFieldSet(parameters);
        }
Exemple #2
0
        public QueryResult(Channel channel)
        {
            InitializeComponent();
            GetLUTTables();
            ComboxLoader.LoadOleDBType(this.enumCmbbxThirdPartyFieldType);

            channelForm = channel;
            type        = "Add";
            resultItem  = new SQLInQueryResultItem();
            this.Text   = "Add Mapping Item";

            GetGCFieldSet(channel.resultItemList);
        }
Exemple #3
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);
     }
 }
Exemple #4
0
        public QueryParameter(XCollection <SQLInQueryResultItem> parameters, int index)
        {
            InitializeComponent();
            GetLUTTables();
            parameterList  = parameters;
            parameterItem  = parameters[index];
            parameterIndex = index;
            type           = "Edit";
            this.Text      = "Edit Parameter";

            parameterIndex = index;

            GetGCFieldSet(parameters);
            ShowInformation();
        }
Exemple #5
0
        public QueryResult(Channel channel, int index)
        {
            InitializeComponent();
            GetLUTTables();
            ComboxLoader.LoadOleDBType(this.enumCmbbxThirdPartyFieldType);

            channelForm = channel;
            type        = "Edit";
            this.Text   = "Edit Mapping Item";
            resultItem  = channel.resultItemList[index];

            resultIndex = index;

            GetGCFieldSet(channel.resultItemList);
            ShowInformation();
        }
Exemple #6
0
        //Build a test configuration file
        static public bool BuildTestConfigFile()
        {
            #region 3rd database connection
            SQLInAdapterConfigMgt.SQLInAdapterConfig.ThirdPartyInteractConfig.OracleDriver  = false;
            SQLInAdapterConfigMgt.SQLInAdapterConfig.ThirdPartyInteractConfig.TimerEnable   = true;
            SQLInAdapterConfigMgt.SQLInAdapterConfig.ThirdPartyInteractConfig.TimerInterval = 1000;
            SQLInAdapterConfigMgt.SQLInAdapterConfig.ThirdPartyInteractConfig.ConnectionParameter.ConnectionStr = "Provider=SQLNCLI.1;Data Source=CNSHW9RSZM1X;Password=123456;User ID=sa;Initial Catalog=GWDataDB";
            #endregion


            #region channel StorageProcedure
            SQLInboundChanel ch = new SQLInboundChanel();
            ch.OperationType = ThrPartyDBOperationType.StorageProcedure;
            ch.OperationName = "p_Patient_3rdIN";
            ch.Enable        = true;
            //ch.Rule.AutoUpdateProcessFlag = false;
            //ch.Rule.CheckProcessFlag = true;
            ch.Rule.RuleName = "p_patient_3rdIn";

            ch.Rule.QueryCriteria.Type = QueryCriteriaRuleType.None; //base mapping list

            #region SQLInQueryCriteria
            SQLInQueryCriteriaItem ci = new SQLInQueryCriteriaItem();
            ci.Type                           = QueryCriteriaType.And;
            ci.Translating.Type               = TranslatingType.DefaultValue;
            ci.Translating.ConstValue         = "0";
            ci.RedundancyFlag                 = false;
            ci.SourceField                    = "process_flag";
            ci.ThirdPartyDBPatamter.FieldID   = 0;
            ci.ThirdPartyDBPatamter.FieldName = ci.SourceField;
            ci.ThirdPartyDBPatamter.FieldType = OleDbType.Integer;
            ch.Rule.QueryCriteria.MappingList.Add(ci);

            ci                                = new SQLInQueryCriteriaItem();
            ci.Type                           = QueryCriteriaType.And;
            ci.Translating.Type               = TranslatingType.FixValue;
            ci.Translating.ConstValue         = "1";
            ci.RedundancyFlag                 = false;
            ci.SourceField                    = "event_type";
            ci.ThirdPartyDBPatamter.FieldID   = 0;
            ci.ThirdPartyDBPatamter.FieldName = ci.SourceField;
            ci.ThirdPartyDBPatamter.FieldType = OleDbType.Integer;
            ch.Rule.QueryCriteria.MappingList.Add(ci);
            #endregion

            #region SQLInQueryResultItem
            // column Patient_test.patientid
            SQLInQueryResultItem map = new SQLInQueryResultItem();
            map.SourceField    = "patientid";
            map.TargetField    = "patientid";
            map.RedundancyFlag = true;
            map.ThirdPartyDBPatamter.FieldID   = 0;
            map.ThirdPartyDBPatamter.FieldName = "PatientID";
            map.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.Integer;
            ch.Rule.QueryResult.MappingList.Add(map);

            // column Patient_test.patient_name
            map                = new SQLInQueryResultItem();
            map.SourceField    = "Patient_name";
            map.TargetField    = "Patient_name";
            map.RedundancyFlag = false;
            map.ThirdPartyDBPatamter.FieldID   = 1;
            map.ThirdPartyDBPatamter.FieldName = "Patient_name";
            map.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
            ch.Rule.QueryResult.MappingList.Add(map);
            // column Patient_test.address
            map                = new SQLInQueryResultItem();
            map.SourceField    = "Address";
            map.TargetField    = "Address";
            map.RedundancyFlag = false;
            map.ThirdPartyDBPatamter.FieldID   = 2;
            map.ThirdPartyDBPatamter.FieldName = "Address";
            map.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
            ch.Rule.QueryResult.MappingList.Add(map);
            // column patient_test.birthdate
            map                = new SQLInQueryResultItem();
            map.SourceField    = "BirthDate";
            map.TargetField    = "BirthDate";
            map.RedundancyFlag = false;
            map.ThirdPartyDBPatamter.FieldID   = 3;
            map.ThirdPartyDBPatamter.FieldName = "BirthDate";
            map.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.Date;
            ch.Rule.QueryResult.MappingList.Add(map);
            #endregion

            SQLInAdapterConfigMgt.SQLInAdapterConfig.InboundChanels.Add(ch);
            #endregion


            #region channel Table
            ch = new SQLInboundChanel();
            ch.OperationType = ThrPartyDBOperationType.Table;
            ch.OperationName = "dbo.Patient_3rdIN";
            ch.Enable        = false;
            //ch.Rule.AutoUpdateProcessFlag = false;
            //ch.Rule.CheckProcessFlag = true;
            ch.Rule.RuleName = "patient_3rdIn";

            ch.Rule.QueryCriteria.Type         = QueryCriteriaRuleType.SQLStatement;
            ch.Rule.QueryCriteria.SQLStatement = "process_flag=0 and event_type=1";


            #region SQLInQueryResultItem
            // column Patient_test.patientid
            map                = new SQLInQueryResultItem();
            map.SourceField    = "patientid";
            map.TargetField    = "patientid";
            map.RedundancyFlag = true;
            map.ThirdPartyDBPatamter.FieldID   = 0;
            map.ThirdPartyDBPatamter.FieldName = "PatientID";
            map.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.Integer;
            ch.Rule.QueryResult.MappingList.Add(map);

            // column Patient_test.patient_name
            map                = new SQLInQueryResultItem();
            map.SourceField    = "Patient_name";
            map.TargetField    = "Patient_name";
            map.RedundancyFlag = false;
            map.ThirdPartyDBPatamter.FieldID   = 1;
            map.ThirdPartyDBPatamter.FieldName = "Patient_name";
            map.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
            ch.Rule.QueryResult.MappingList.Add(map);
            // column Patient_test.address
            map                = new SQLInQueryResultItem();
            map.SourceField    = "Address";
            map.TargetField    = "Address";
            map.RedundancyFlag = false;
            map.ThirdPartyDBPatamter.FieldID   = 2;
            map.ThirdPartyDBPatamter.FieldName = "Address";
            map.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.VarChar;
            ch.Rule.QueryResult.MappingList.Add(map);
            // column patient_test.birthdate
            map                = new SQLInQueryResultItem();
            map.SourceField    = "BirthDate";
            map.TargetField    = "BirthDate";
            map.RedundancyFlag = false;
            map.ThirdPartyDBPatamter.FieldID   = 3;
            map.ThirdPartyDBPatamter.FieldName = "BirthDate";
            map.ThirdPartyDBPatamter.FieldType = System.Data.OleDb.OleDbType.Date;
            ch.Rule.QueryResult.MappingList.Add(map);
            #endregion

            SQLInAdapterConfigMgt.SQLInAdapterConfig.InboundChanels.Add(ch);
            #endregion

            //save
            return(SQLInAdapterConfigMgt.Save(SQLInAdapterConfigMgt._FileName));
        }