Пример #1
0
        public bool InitializeDataStoreManager()
        {
            String cmdSQL = $"select * from `datastoreconfig` where CompanyCode = '{_deviceInfo.CompanyCode}' and DeviceCode = '{_deviceInfo.DeviceCode}'";

            MySqlDataReader dataStoreConfigReader = MySqlHelper.ExecuteReader(Conn, CommandType.Text, cmdSQL, null);

            while (dataStoreConfigReader.Read())
            {
                DataStoreTableInfo  dataStoreTableItem  = new DataStoreTableInfo();
                DataStoreConfigInfo dataStoreConfigItem = new DataStoreConfigInfo();

                dataStoreTableItem.TableName       = (string)dataStoreConfigReader["DefaultTableName"];
                dataStoreTableItem.SpliteTableType = (SPLITE_TABLE_TYPE)(int)dataStoreConfigReader["SpliteType"];
                string fieldInfoJson = (string)dataStoreConfigReader["FieldInfo"];

                dataStoreTableItem.FieldList = JsonConvert.DeserializeObject <DataStoreFieldInfo[]>(fieldInfoJson);


                dataStoreConfigItem.TableInfo = dataStoreTableItem;

                dataStoreConfigItem.CompanyCode  = (string)dataStoreConfigReader["CompanyCode"];
                dataStoreConfigItem.DeviceCode   = (string)dataStoreConfigReader["DeviceCode"];
                dataStoreConfigItem.SaveInterval = (int)dataStoreConfigReader["SaveInterval"];
                dataStoreConfigItem.StoreTime    = (int)dataStoreConfigReader["StoreTime"];
                //dataStoreConfigItem.DataType = (string)dataStoreConfigReader["DataType"];
                dataStoreConfigItem.StoreCondition = dataStoreConfigReader["StoreCondition"].ToString();
                dataStoreConfigItem.BufferTime     = (int)dataStoreConfigReader["BufferTime"];
                dataStoreConfigItem.BufferSize     = (int)dataStoreConfigReader["BufferSize"];


                _deviceDataStoreManager.AddDataStoreItem(dataStoreConfigItem);

                _DataStoreMap.Add(dataStoreTableItem.TableName, dataStoreTableItem);
            }

            return(true);
        }