public RestModule() : base("rest") { Post["/updateVal"] = parameters => { string str; using (var reader = new StreamReader(this.Request.Body)) str = reader.ReadToEnd(); Console.WriteLine(str); UpdateValue upVal = Newtonsoft.Json.JsonConvert.DeserializeObject <UpdateValue>(str); Console.WriteLine("Got Post val " + upVal.value); ushort msgIdp; MqttClient cliento = new MqttClient("broker.hivemq.com"); msgIdp = cliento.Publish("/8406AndroidVal", // topic Encoding.UTF8.GetBytes(upVal.value.ToString()), // message body MqttMsgBase.QOS_LEVEL_EXACTLY_ONCE, // QoS level true); // retained return(Nancy.HttpStatusCode.OK); }; Get["/timeInterval"] = parameters => { ReportValue rVal = new ReportValue(); rVal.value = Convert.ToInt32(Program.timeInterval); rVal.nodeSerial = "123"; rVal.thingName = "Android"; var json = Newtonsoft.Json.JsonConvert.SerializeObject(rVal); return(json); }; }
/// <summary> /// Initializes the control properties. /// </summary> protected void SetupControl() { if (StopProcessing) { // Do nothing } else { string[] items = ReportValue.Split(';'); if ((items != null) && (items.Length == 2)) { ucValue.Parameter = items[0] + "." + items[1]; ucValue.ReportItemName = items[0] + ";" + items[1]; ucValue.CacheItemName = CacheItemName; ucValue.CacheMinutes = CacheMinutes; ucValue.CacheDependencies = CacheDependencies; ucValue.ItemType = ReportItemType.Graph; ucValue.LoadDefaultParameters(ParametersXmlData, ParametersXmlSchema); ucValue.EnableSubscription = EnableSubscription; ucValue.IsLiveSite = (CMSContext.ViewMode == ViewModeEnum.LiveSite);; ucValue.ReloadData(true); } } }
public void TestGetReport() { EnergyDB _db = new EnergyDB(); DepartmentReportDbContext context = new DepartmentReportDbContext(); string[] depts = { "D000001G001001", "D000001G001002" }; string sql = string.Format(DepartmentReportResources.YearReportSQL, "'" + string.Join("','", depts) + "'"); SqlParameter param = new SqlParameter(); param.ParameterName = "@EndTime"; param.SqlDbType = SqlDbType.Date; param.Value = "2018-07-01"; SqlParameter[] sqlParameters = { param, new SqlParameter("@EnergyItemCode", "02000") }; String connStr = _db.Database.Connection.ConnectionString; List <ReportValue> list = new List <ReportValue>(); Console.WriteLine(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); using (SqlConnection conn = new SqlConnection(connStr)) { conn.Open(); Console.WriteLine(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Add(new SqlParameter("@EndTime", "2018-07-01")); cmd.Parameters.Add(new SqlParameter("@EnergyItemCode", "02000")); SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataTable table = new DataTable(); adapter.Fill(table); Console.WriteLine(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); foreach (DataRow row in table.Rows) { ReportValue report = new ReportValue(); report.Id = row["ID"].ToString(); report.Name = row["Name"].ToString(); report.Time = Convert.ToDateTime(row["Time"]); report.Value = Convert.ToDecimal(row["Value"]); list.Add(report); } Console.WriteLine(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); } Console.WriteLine(list.Count); Console.WriteLine(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); }
public void GenerateReport(GenerateReportModel generateReport, Guid userId, string nameFile) { try { nameFile = Helpers.Helpers.GetNameFileWithCurrentDate(nameFile); Report report = new Report { ReportTypeId = generateReport.ReportTypeId, SignerUserId = userId, Name = nameFile }; _docFlowContext.Reports.Add(report); ReportHistory reportHistory = new ReportHistory { ReportId = report.Id, CreateUserId = userId, CreateDate = DateTime.Now }; _docFlowContext.ReportHistory.Add(reportHistory); foreach (ReportLabelModel label in generateReport.Values) { ReportValue reportValue = new ReportValue { ReportId = report.Id, ReportLabelId = label.Id, Value = label.Value }; _docFlowContext.ReportValues.Add(reportValue); ReportValuesHistory reportValuesHistory = new ReportValuesHistory { ReportValueId = reportValue.Id, ReportHistoryId = reportHistory.Id, NewValue = reportValue.Value }; _docFlowContext.ReportValuesHistory.Add(reportValuesHistory); } _docFlowContext.SaveChanges(); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public void TestRegionReportBySqlReader() { EnergyDB _db = new EnergyDB(); string connString = "data source=192.168.105.227,1433;initial catalog=EMS;persist security info=True;user id=sa;password=Acrel001"; List <ReportValue> list = new List <ReportValue>(); using (SqlConnection conn = new SqlConnection(connString)) { conn.Open(); string sql = string.Format(RegionReportResources.YearReportSQL, @"'000001G0010002', '000001G0010005', '000001G0010006', '000001G0010007', '000001G0010008', '000001G0010009', '000001G0010010', '000001G0010011', '000001G0010012', '000001G0010013', '000001G0010014'"); SqlCommand cmd = new SqlCommand(sql, conn); SqlParameter[] sqlParameters = { new SqlParameter("@BuildID", "000001G001"), new SqlParameter("@EnergyItemCode", "01000"), new SqlParameter("@EndTime", "2018-01-01") }; cmd.Parameters.AddRange(sqlParameters); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { ReportValue report = new ReportValue(); report.Id = reader["ID"].ToString(); report.Name = reader["Name"].ToString(); report.Time = Convert.ToDateTime(reader["Time"]); report.Value = Convert.ToDecimal(reader["Value"]); list.Add(report); } } Console.WriteLine(list.Count); }
/// <summary> /// Initializes the control properties. /// </summary> protected void SetupControl() { if (this.StopProcessing) { // Do nothing } else { string[] items = ReportValue.Split(';'); if ((items != null) && (items.Length == 2)) { ucValue.Parameter = items[0] + "." + items[1]; ucValue.ReportItemName = items[0] + ";" + items[1]; ucValue.CacheItemName = CacheItemName; ucValue.CacheMinutes = CacheMinutes; ucValue.CacheDependencies = CacheDependencies; ucValue.ItemType = ReportItemType.Graph; ucValue.LoadDefaultParameters(this.ParametersXmlData, this.ParametersXmlSchema); ucValue.ReloadData(true); } } }