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);
}
}
}
