static void Sync_equipment_project_func()
{
try
{
DbHelperSQL dbNet;
var connectionString = ToolAPI.INIOperate.IniReadValue("netSqlGroup", "connectionString", Application.StartupPath + "\\Config.ini");
string[] connectionStringtearm = connectionString.Split('&');
if (connectionStringtearm != null && connectionStringtearm.Length == 5)
dbNet = new DbHelperSQL(string.Format("Data Source={0};Port={1};Database={2};User={3};Password={4}", connectionStringtearm[0], connectionStringtearm[1], connectionStringtearm[2], connectionStringtearm[3], connectionStringtearm[4]), DbProviderType.MySql);
else
dbNet = new DbHelperSQL(string.Format("Data Source={0};Port={1};Database={2};User={3};Password={4}", "172.24.108.167", "3306", "gd_db_v2", "wisdom_root", "JIwLi5j40SY#o1Et"), DbProviderType.MySql);
Dictionary<string, string> Equipment_project_temp = new Dictionary<string, string>();
string sql = "select project_code,project_id from biz_project";
DataTable dt = dbNet.ExecuteDataTable(sql, null);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
string project_personnel_id = dr["project_code"].ToString();
string project_id = dr["project_id"].ToString();
//存入redis中
string key = "equipment:projectid:" + Equipment_type.人员管理 + ":" + project_personnel_id;
TimeSpan timeSpan = new TimeSpan(0, 0, 300);
RedisCacheHelper.Add(key, project_id, timeSpan);
}
}
}
catch (Exception ex)
{
ToolAPI.XMLOperation.WriteLogXmlNoTail("人员管理Sync_equipment_project异常", ex.Message);
}
}
public static void Update_equminet_driver(string sn, string driver_code)
{
string key = "equipment:driver:" + Equipment_type.升降机 + ":" + sn;
string value = driver_code + "&" + DateTime.Now.ToString();
RedisCacheHelper.Add(key, value);
}
static void Sync_equipment_project_func()
{
try
{
DbHelperSQL dbNet;
var connectionString = ToolAPI.INIOperate.IniReadValue("netSqlGroup", "connectionString", Application.StartupPath + "\\Config.ini");
string[] connectionStringtearm = connectionString.Split('&');
if (connectionStringtearm != null && connectionStringtearm.Length == 5)
{
dbNet = new DbHelperSQL(string.Format("Data Source={0};Port={1};Database={2};User={3};Password={4}", connectionStringtearm[0], connectionStringtearm[1], connectionStringtearm[2], connectionStringtearm[3], connectionStringtearm[4]), DbProviderType.MySql);
}
else
{
dbNet = new DbHelperSQL(string.Format("Data Source={0};Port={1};Database={2};User={3};Password={4}", "172.24.108.167", "3306", "gd_db_v2", "wisdom_root", "JIwLi5j40SY#o1Et"), DbProviderType.MySql);
}
Dictionary <string, string> Equipment_project_temp = new Dictionary <string, string>();
string sql = "select bpe.equipment_sn,bpe.project_id,bwn.pm25_warn_value,bwn.pm10_warn_value,bwn.noise_warn_value from biz_warn_config_dust_noise as bwn,biz_project_equipment as bpe where bwn.equipment_id = bpe.equipment_id and bpe.equipment_type='" + Equipment_type.扬尘噪音 + "'";
DataTable dt = dbNet.ExecuteDataTable(sql, null);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
string equipment_sn = dr["equipment_sn"].ToString();
string project_id = dr["project_id"].ToString();
string pm25_warn_value = dr["pm25_warn_value"].ToString();
string pm10_warn_value = dr["pm10_warn_value"].ToString();
string noise_warn_value = dr["noise_warn_value"].ToString();
string value = project_id + "&" + pm25_warn_value + "&" + pm10_warn_value + "&" + noise_warn_value;
//存入redis中
string key = "equipment:projectid:" + Equipment_type.扬尘噪音 + ":" + equipment_sn;
TimeSpan timeSpan = new TimeSpan(0, 0, 300);
RedisCacheHelper.Add(key, value, timeSpan);
}
}
}
catch (Exception ex)
{
ToolAPI.XMLOperation.WriteLogXmlNoTail("扬尘噪音Sync_equipment_project异常", ex.Message);
}
}
public static void Update_equminet_last_online_time(string sn, long time)
{
string key = "equipment:online_time:" + Equipment_type.卸料平台 + ":" + sn;
RedisCacheHelper.Add(key, time);
}