Exemple #1
0
        public HttpResponseMessage Get(long startDate, long endDate)
        {
            try
            {
                if (startDate > endDate)
                {
                    endDate = DateTime.Now.Ticks;
                }

                string ordem   = "";
                string codTira = "";

                var localReport = new LocalReport();
                ReportDataSource reportDataSource = null;

                localReport.ReportPath = System.Web.Hosting.HostingEnvironment.MapPath("~/Report/Report1.rdlc");

                DataSet1 dbrelatorio = new DataSet1();
                // Pegando a DataTable que será populada
                RestAPI restOtherApi = new RestAPI();

                var dataTable = dbrelatorio.DataTable1;

                var thingList = restOtherApi.ThingGet();

                foreach (var thing in thingList.Where(x => x.position > 0).OrderBy(x => x.position))
                {
                    var bigTable = restOtherApi.BigTableGet(thing.thingId, startDate, endDate);

                    if (bigTable == null || bigTable.tags.Count() <= 1)
                    {
                        continue;
                    }

                    var bigTableGroup = bigTable.tags.GroupBy(x => x.group);

                    var linhaTags     = bigTableGroup.Where(x => x.Key.ToLower() == "linha").FirstOrDefault();
                    var roloTimeStamp = linhaTags.FirstOrDefault().timestamp;
                    var roloValores   = linhaTags.Where(x => x.name.ToLower() == "rolo").FirstOrDefault().value;


                    foreach (var group in bigTableGroup)
                    {
                        if (group.Key.ToLower() == "linha")
                        {
                            ordem   = group.Where(x => x.name.Contains("ordem")).FirstOrDefault().value.FirstOrDefault();
                            codTira = group.Where(x => x.name.Contains("codTira")).FirstOrDefault().value.FirstOrDefault();
                        }
                        var timeStamp = group.Where(x => x.name.Contains("Valor"));

                        if (timeStamp == null || timeStamp.Count() == 0)
                        {
                            continue;
                        }
                        //try
                        //{
                        //    if (group.Where(x => x.name.Contains("LSE")).FirstOrDefault().timestamp.Count() < timeStamp.FirstOrDefault().timestamp.Count())
                        //        timeStamp = group.Where(x => x.name.Contains("LSE"));
                        //    if (group.Where(x => x.name.Contains("LSC")).FirstOrDefault().timestamp.Count() < timeStamp.FirstOrDefault().timestamp.Count())
                        //        timeStamp = group.Where(x => x.name.Contains("LSC"));
                        //    if (group.Where(x => x.name.Contains("LIC")).FirstOrDefault().timestamp.Count() < timeStamp.FirstOrDefault().timestamp.Count())
                        //        timeStamp = group.Where(x => x.name.Contains("LIC"));
                        //    if (group.Where(x => x.name.Contains("LIE")).FirstOrDefault().timestamp.Count() < timeStamp.FirstOrDefault().timestamp.Count())
                        //        timeStamp = group.Where(x => x.name.Contains("LIE"));
                        //}
                        //catch
                        //{
                        //    continue;
                        //}
                        for (int i = 0; i < timeStamp.FirstOrDefault().timestamp.Count(); i++)
                        {
                            string sValor = "";
                            string sLSE   = "";
                            string sLSC   = "";
                            string sLIC   = "";
                            string sLIE   = "";

                            var valor = group.Where(x => x.name.Contains("Valor"));
                            var LSE   = group.Where(x => x.name.Contains("LSE"));
                            var LSC   = group.Where(x => x.name.Contains("LSC"));
                            var LIC   = group.Where(x => x.name.Contains("LIC"));
                            var LIE   = group.Where(x => x.name.Contains("LIE"));

                            if (valor.Count() > 0 && (valor.FirstOrDefault().value.Count - 1) >= i)
                            {
                                sValor = valor.FirstOrDefault().value[i];
                            }
                            if (LSE.Count() > 0 && (LSE.FirstOrDefault().value.Count - 1) >= i)
                            {
                                sLSE = LSE.FirstOrDefault().value[i];
                            }
                            if (LSC.Count() > 0 && (LSC.FirstOrDefault().value.Count - 1) >= i)
                            {
                                sLSC = LSC.FirstOrDefault().value[i];
                            }
                            if (LIC.Count() > 0 && (LIC.FirstOrDefault().value.Count - 1) >= i)
                            {
                                sLIC = LIC.FirstOrDefault().value[i];
                            }
                            if (LIE.Count() > 0 && (LIE.FirstOrDefault().value.Count - 1) >= i)
                            {
                                sLIE = LIE.FirstOrDefault().value[i];
                            }


                            var roloIndex = roloTimeStamp.FindIndex(x => x == valor.FirstOrDefault().timestamp[i]);


                            dataTable.AddDataTable1Row("", "", "", roloValores[roloIndex], thing.thingName, group.FirstOrDefault().group, sValor, sLSC
                                                       , sLSE, sLIC, sLIE, new DateTime(valor.FirstOrDefault().timestamp[i]).ToString("dd/MM/yyyy HH:mm"), thing.position);
                        }
                    }
                }

                if (string.IsNullOrEmpty(ordem))
                {
                    ordem = "";
                }
                if (string.IsNullOrEmpty(codTira))
                {
                    codTira = "";
                }

                localReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("ReportParameter1", ordem));
                localReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("ReportParameter4", codTira));
                localReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("ReportParameter2", new DateTime(startDate).ToString("dd/MM/yyyy HH:mm")));
                localReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("ReportParameter3", new DateTime(endDate).ToString("dd/MM/yyyy HH:mm")));

                reportDataSource = new ReportDataSource("DataSet1", dataTable.ToList());
                localReport.DataSources.Add(reportDataSource);

                //Realizando o Refresh do LocalReport
                localReport.Refresh();

                string reportType = "excel";
                string mimeType;
                string encoding;
                string fileNameExtension;

                //The DeviceInfo settings should be changed based on the reportType
                //http://msdn2.microsoft.com/en-us/library/ms155397.aspx
                string deviceInfo = null;

                Warning[] warnings;
                string[]  streams;
                byte[]    renderedBytes = null;

                var p = localReport.ListRenderingExtensions();

                //Render the report
                renderedBytes = localReport.Render(
                    reportType,
                    deviceInfo,
                    out mimeType,
                    out encoding,
                    out fileNameExtension,
                    out streams,
                    out warnings);

                HttpResponseMessage result = new HttpResponseMessage(HttpStatusCode.OK);
                result.Content = new ByteArrayContent(renderedBytes);
                result.Content.Headers.ContentType = new System.Net.Http.Headers.MediaTypeHeaderValue(mimeType);
                return(result);
            }
            catch (Exception ex)
            {
                throw new ArgumentException(ex.ToString());
            }
        }