public async Task <JsonResult> getEventsHeader()
{
int batchStart = 0;
int batchEnd = 0;
StreamReader stream = new StreamReader(Request.InputStream);
string json = stream.ReadToEnd();
DataRequest dataRequest = new JavaScriptSerializer().Deserialize <DataRequest>(json);
string DB = string.Empty;
string table = string.Empty;
foreach (string key in Session.Keys)
{
if (key.Contains("dbName") && key.Contains(Request.QueryString["plc"].ToString()))
{
DB = Session[key].ToString();
}
if (key.Contains("tableName") && key.Contains(Request.QueryString["plc"].ToString()))
{
table = Session[key].ToString();
}
}
ReportDBHelper db = new ReportDBHelper(DB, 2);
GraphEventsData data = await db.SelectGraphDataAsync(dataRequest.beginTime, dataRequest.beginTime + dataRequest.timeAxisLength, table);
foreach (ColumnGraphModel CGM in data.events)
{
if (CGM.RecordType == 10 || CGM.RecordType == 14)
{
if (data.events.Exists(p => (int)p.RecordType == 10 && p.BatchNo == CGM.BatchNo))
{
batchStart = data.events.Single(p => (int)p.RecordType == 10 && p.BatchNo == CGM.BatchNo).TimeStart;
}
if (data.events.Exists(p => (int)p.RecordType == 14 && p.BatchNo == CGM.BatchNo))
{
batchEnd = (data.events.Single(p => (int)p.RecordType == 14 && p.BatchNo == CGM.BatchNo).TimeStart);
}
if (data.events.Exists(p => (int)p.RecordType == 10 && p.BatchNo == CGM.BatchNo) && data.events.Exists(p => (int)p.RecordType == 14 && p.BatchNo == CGM.BatchNo))
{
CGM.Variant3 = batchEnd - batchStart;
}
//Duration is for George graphs in recordType 10 and 14
}
}
return(Json(data)); //it add data in the reguested shape to client
}
public async Task <JsonResult> getEventsHeader()
{
int batchStart = 0;
int batchEnd = 0;
StreamReader stream = new StreamReader(Request.InputStream);
string json = stream.ReadToEnd();
DataRequest dataRequest = new JavaScriptSerializer().Deserialize <DataRequest>(json);
string DB = string.Empty;
string table = string.Empty;
foreach (string key in Session.Keys)
{
if (key.Contains("dbName") && key.Contains(Request.QueryString["plc"].ToString()))
{
DB = Session[key].ToString();
}
if (key.Contains("tableName") && key.Contains(Request.QueryString["plc"].ToString()))
{
table = Session[key].ToString();
}
}
ReportDBHelper db = new ReportDBHelper(DB, 2);
DataReportModel data = await db.SelectHeaderDataAsync(dataRequest.beginTime, dataRequest.beginTime + dataRequest.timeAxisLength, table);
GraphEventsData GED = new GraphEventsData();
GED.events = new List <ColumnGraphModel>();
foreach (ColumnReportModel CRM in data.Data)
{
ColumnGraphModel CGM = new ColumnGraphModel();
CGM.RecordNo = CRM.RecordNo;
CGM.RecordType = (int)CRM.RecordType;
CGM.TimeStart = AlarmHelper.DateTimeTopkTime(CRM.TimeStart);
CGM.TimeEnd = AlarmHelper.DateTimeTopkTime(CRM.TimeEnd);
CGM.BatchNo = CRM.BatchNo;
CGM.Destination = CRM.Destination;
CGM.Need = CRM.Need;
CGM.Actual = CRM.Actual;
CGM.Variant1 = CRM.Variant1;
CGM.Variant2 = CRM.Variant2;
CGM.Variant3 = CRM.Variant3;
if (CGM.RecordType == 10 || CGM.RecordType == 14)
{
if (data.Data.Exists(p => (int)p.RecordType == 10 && p.BatchNo == CGM.BatchNo))
{
batchStart = AlarmHelper.DateTimeTopkTime(data.Data.Single(p => (int)p.RecordType == 10 && p.BatchNo == CGM.BatchNo).TimeStart);
}
if (data.Data.Exists(p => (int)p.RecordType == 14 && p.BatchNo == CGM.BatchNo))
{
batchEnd = AlarmHelper.DateTimeTopkTime(data.Data.Single(p => (int)p.RecordType == 14 && p.BatchNo == CGM.BatchNo).TimeEnd);
}
if (data.Data.Exists(p => (int)p.RecordType == 10 && p.BatchNo == CGM.BatchNo) && data.Data.Exists(p => (int)p.RecordType == 14 && p.BatchNo == CGM.BatchNo))
{
CGM.Variant3 = batchEnd - batchStart;
}
//Duration is for George graphs in recordType 10 and 14
}
CGM.Variant4 = CRM.Variant4;
GED.events.Add(CGM);
}
return(Json(GED)); //it add data in the reguested shape to client
}