private static bool InitializeCompanyManager()
{
MySqlDataReader companyReader = MySqlHelper.ExecuteReader(Conn, CommandType.Text, "select * from companyinfo", null);
while (companyReader.Read())
{
CompanyInfoEx companyItem = new CompanyInfoEx();
companyItem.Redis = new RedisInfo();
companyItem.CompanyCode = (string)companyReader["CompanyCode"];
companyItem.CompanyName = (string)companyReader["CompanyName"];
companyItem.DeviceCount = (int)companyReader["DeviceCount"];
companyItem.Redis.Host = (string)companyReader["Redis_IP"];
companyItem.Redis.Port = (int)companyReader["Redis_Port"];
companyItem.Redis.Passowrd = (string)companyReader["Redis_Password"];
companyItem.Redis.DB = (int)companyReader["Redis_DB"];
companyItem.Database = new DBInfo();
companyItem.Database.host = (string)companyReader["DB_IP"];
companyItem.Database.port = (int)companyReader["DB_Port"];
companyItem.Database.userName = (string)companyReader["DB_UserName"];
companyItem.Database.password = (string)companyReader["DB_UserPassword"];
CompanyHelper tempCompanyItem = new CompanyHelper(companyItem);
_companyMap.Add(companyItem.CompanyCode, tempCompanyItem);
}
return(true);
}
public int InitializeDataStoreManager(string DBCnnString,
CompanyInfoEx companyInfo, DeviceInfoEx deviceInfo)
{
_cnnDB = DBCnnString;
_redisInfo = companyInfo.Redis;
_redisTableName = $"[{companyInfo.CompanyCode}]-[{deviceInfo.DeviceCode}]";
return(0);
}
public CompanyHelper(CompanyInfoEx companyInfo)
{
_companyInfo = companyInfo;
companyRedisTableName = $"[IotConfig]-[{_companyInfo.CompanyCode}]";
CompanyDatabaseName = $"[iot]-[{_companyInfo.CompanyCode}]";
CompanyCnn = $"Database='{CompanyDatabaseName}';Data Source='{_companyInfo.Database.host}';";
CompanyCnn += $"User Id='{_companyInfo.Database.userName}';Password='******';charset='utf8';pooling=true";
InitializeCompanyHelper();
InitializeAlarmStoreManager();
}
public void InitializeDeviceManager(CompanyInfoEx companyInfo)
{
_companyInfo = companyInfo;
MySqlDataReader companyReader = MySqlHelper.ExecuteReader(Conn, CommandType.Text, $"select * from deviceconfig where CompanyCode='{companyInfo.CompanyCode}'", null);
while (companyReader.Read())
{
DeviceInfoEx deviceItem = new DeviceInfoEx();
deviceItem.CompanyCode = (string)companyReader["CompanyCode"];
deviceItem.DeviceCode = (string)companyReader["DeviceCode"];
deviceItem.GPS = (string)companyReader["DeviceGPS"];
deviceItem.DeviceName = (string)companyReader["DeviceName"];
deviceItem.DeviceType = (int)companyReader["DeviceType"];
if (companyReader["DeviceTypeName"].Equals(DBNull.Value) == true)
{
deviceItem.DeviceTypeName = "";
}
else
{
deviceItem.DeviceTypeName = (string)companyReader["DeviceTypeName"];
}
if (companyReader["Address"].Equals(DBNull.Value) == true)
{
deviceItem.Address = "";
}
else
{
deviceItem.Address = (string)companyReader["Address"];
}
DeviceHelper tempCompanyItem = new DeviceHelper(deviceItem, _companyInfo);
tempCompanyItem.InitializeDataStoreManager();
_mapDevices.Add(deviceItem.DeviceCode, tempCompanyItem);
}
}
public DeviceHelper(DeviceInfoEx deviceInfo, CompanyInfoEx companyInfo)
{
_deviceInfo = deviceInfo;
_deviceStatus.DeviceName = _deviceInfo.DeviceName;
_deviceStatus.DeviceCode = _deviceInfo.DeviceCode;
_deviceStatus.DeviceType = _deviceInfo.DeviceTypeName;
_deviceStatus.DeviceAddress = _deviceInfo.Address;
_deviceStatus.GPS = _deviceInfo.GPS;
_deviceStatus.ConnectStatus = CONNECT_STATUS.OFF_LINE;
_deviceStatus.UpdateTimestamp = 0;
_deviceRedisHashName = $"[{deviceInfo.CompanyCode}]-[{deviceInfo.DeviceCode}]";
_parentCompanyInfo = companyInfo;
companyRedisTableName = $"[IotConfig]-[{_deviceInfo.CompanyCode}]";
_deviceAlarmStoreManager = new DeviceAlarmStoreManager(deviceInfo);
}
