public Model.CasicFireEvent isFireUp(String cmd) { try { using (OracleConnection conn = new OracleConnection(OracleHelper.ConnectionStringOrderDistributedTransaction)) { String SQL = " SELECT t.STATUS,t.VERSION" + " FROM ALARM_FIREUP_EVENT t" + " WHERE t.CMD = :CMD "; OracleParameter[] oraParams = new OracleParameter[] { new OracleParameter(":CMD", cmd), }; DataTable dt = OracleHelper.ExecuteDataset(conn, CommandType.Text, SQL, oraParams).Tables[0]; if (dt.Rows.Count > 0) { Model.CasicFireEvent fireEvent = new Model.CasicFireEvent(); if (null != dt.Rows[0]["STATUS"]) { fireEvent.Status = dt.Rows[0]["STATUS"].ToString(); } if (null != dt.Rows[0]["VERSION"]) { fireEvent.Version = dt.Rows[0]["VERSION"].ToString(); } return(fireEvent); } } } catch (Exception e) { String ex = e.Message; } return(null); }
public virtual void Execute(IJobExecutionContext context) { JobDataMap map = context.JobDetail.JobDataMap; CasicServer server = (CasicServer)map.Get("server"); Dictionary <String, String> devHubMaps = new Dictionary <String, String>(); List <Model.DevHubInfo> devHubs = new BLL.DevHub().findAll(); foreach (Model.DevHubInfo devHub in devHubs) { if (devHub.DevCode.StartsWith("21")) { devHubMaps.Add(devHub.DevCode, devHub.HubCode); } } CasicSender casicSender = new CasicSender(server); new BLL.DevHub().setOffLine(); Model.CasicFireEvent fireEvent = new Model.CasicFireEvent(); fireEvent.Version = "20"; casicSender.SendGetDataReq(devHubMaps, fireEvent); }