void ToBaReportTask()
{
SSHMC01Entities db = new SSHMC01Entities();
var q =from n in db.vwSiteToBA_Report where n.ISTOBA==false && n.MFCC_ID==this.mfccid select n;
foreach (vwSiteToBA_Report rpt in q)
{
try
{
ToBAReport report = new ToBAReport()
{
reportType = rpt.TYPE,
reportURL = rpt.URL
};
if (manager.ContainsKey(rpt.CONTROLLER_ID))
{
if (manager[rpt.CONTROLLER_ID].IsConnected)
{
manager[rpt.CONTROLLER_ID].Send(report.ToJsonString());
}
var q1 = from n in db.tblReportNotified where n.SITE_ID == rpt.SITE_ID && n.DATATIME == rpt.DATATIME && n.TYPE == rpt.TYPE select n;
tblReportNotified tmp = q1.FirstOrDefault();
if (tmp != null)
tmp.ISTOBA = true;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message + "," + ex.StackTrace);
}
}
db.SaveChanges();
}
void ToBaTask()
{
SSHMC01Entities db = new SSHMC01Entities();
var q = db.vwSiteToBA_Status;
foreach (vwSiteToBA_Status site in q)
{
ToBAStatus BaStatus = new ToBAStatus()
{
systemStatus = site.current_degree.ToString()
};
try
{
var q1 = (from n in db.vwSensorDegree
where
n.SITE_ID == site.SITE_ID
select n);
ToBASensorStatus[] snrstat = new ToBASensorStatus[q1.Count()];
int i = 0;
foreach (vwSensorDegree snr in q1)
{
snrstat[i++] = new ToBASensorStatus() { deviceAdd = snr.SENSOR_ID.ToString(), deviceType = snr.SENSOR_TYPE, deviceValue = snr.CURRENT_DEGREE.ToString() };
}
BaStatus.deviceList = snrstat;
var q3 = from n in db.tblTC where n.SITE_ID == site.SITE_ID && n.DEVICE_TYPE == "BA" select n;
foreach (tblTC tc in q3)
{
if (manager.ContainsKey(tc.CONTROLLER_ID))
if (manager[tc.CONTROLLER_ID].IsConnected)
{
// send tc here
// Console.WriteLine(BaStatus.ToJsonString());
try
{
manager[tc.CONTROLLER_ID].Send(BaStatus.ToJsonString());
}
catch (Exception ex)
{
Console.WriteLine(ex.Message + "," + ex.StackTrace);
}
}
}
// BaStatus.deviceList = snrStatus;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message + "," + ex.StackTrace);
}
}
}
void loadTC_AndBuildManaer()
{
try
{
SSHMC01Entities db = new SSHMC01Entities();
// var q = from n in db.tblTC where n.MFCC_ID == this.mfccid && n.ENABLE == "Y" select n;
var q= db.tblTC.Where(n => n.ENABLE == "Y" && n.MFCC_ID == this.mfccid);
foreach (tblTC tc in q)
{
Comm.TC.BATC batc = new Comm.TC.BATC(tc.CONTROLLER_ID, tc.IP, tc.PORT, tc.ISCONNECTED == "Y" ? true : false);
manager.Add(batc.controlid, batc);
batc.OnConnectChange += OnTCConnectedChangeTask;
}
//SqlDataReader rd;
//SqlConnection cn = new SqlConnection(Comm.SQL.SQL.dbConnectionStr);
//rd = Comm.SQL.SQL.getDeviceConfigReader(cn, this.mfccid);
//// Comm.TCBase tc=null;
//while (rd.Read())
//{
// string devtype = rd[8].ToString();
// try
// {
// // manager..AddDevice(rd[0].ToString());
// }
// catch (Exception ex)
// {
// ConsoleServer.WriteLine(ex.Message + ex.StackTrace);
// }
//}
//rd.Close();
//cn.Close();
}
catch (Exception ex)
{
ConsoleServer.WriteLine(ex.Message + ex.StackTrace);
}
}
