public JsonResult RelatorioMaquina(int idempresa, string lista_ids, int periodo)
{
string sreult = string.Empty;
string sFileName = string.Empty;
Empresa empresaLista = null;
//
List <EmpresaRelatorioModel> lista_empresa_model = new List <EmpresaRelatorioModel>();
List <ColetorAlerta> lista_coletoralerta_model = new List <ColetorAlerta>();
List <ColetorAlertaLog> lista_coletor_alerta_log = new List <ColetorAlertaLog>();
//
List <ColetorAlertaModel> lista_coletor_alerta_item_model = new List <ColetorAlertaModel>();
List <ColetorAlertaLogModel> lista_coletor_alerta_log_model = new List <ColetorAlertaLogModel>();
List <MaquinaItensReportModel> lista_maquina_itens_report_model = new List <MaquinaItensReportModel>();
//
empresaLista = db.Empresa.Where(x => x.Id == idempresa).FirstOrDefault();
//
if (empresaLista != null)
{
EmpresaRelatorioModel tmp = new EmpresaRelatorioModel();
//
tmp.Id = empresaLista.Id;
tmp.Nome = empresaLista.Nome;
tmp.Numero = empresaLista.Numero;
tmp.Telefone = empresaLista.Telefone;
tmp.Site = empresaLista.Site;
tmp.EstadoSigla = PegaEstadoSigla(empresaLista.Estado);
tmp.Endereco = empresaLista.Endereco;
tmp.CEP = empresaLista.CEP;
tmp.Cidade = empresaLista.Cidade;
tmp.NomeFantasia = empresaLista.NomeFantasia;
tmp.Email = empresaLista.Email;
tmp.Bairro = empresaLista.Bairro;
lista_empresa_model.Add(tmp);
}
//
string[] lista_ids_maquinas = lista_ids.Split(',');
for (int i = 0; i < lista_ids_maquinas.Length; i++)
{
int idmaquina = Convert.ToInt32(lista_ids_maquinas[i]);
Coletor coletor = db.Coletor.Where(x => x.Maquina != null && x.Maquina.ID == idmaquina).FirstOrDefault();
//
if (coletor != null)
{
MaquinaItensReportModel mirm = new MaquinaItensReportModel();
//
mirm.DescricaoColetor = coletor.Descricao;
mirm.DescricaoMaquina = coletor.Maquina.Descricao;
//
lista_maquina_itens_report_model.Add(mirm);
//
lista_coletoralerta_model = db.ColetorAlerta.Where(x => x.Id_Coletor == coletor.Id).ToList();
foreach (ColetorAlerta item in lista_coletoralerta_model)
{
ColetorAlertaModel cam = new ColetorAlertaModel();
//
cam.Id = item.Id;
cam.Id_Empresa = item.Id_Empresa;
cam.Id_Coletor = item.Id_Coletor;
cam.Id_TipoAlerta = item.Id_TipoAlerta;
cam.Prioridade = item.Prioridade.HasValue ? item.Prioridade.Value : 0;
cam.DescricaoColetor = "";
cam.Descricao = item.Descricao;
cam.Email = item.Email;
switch (item.ColetorTipoAlerta.Tipo.Value)
{
case 1:
cam.DescricaoTipoAlerta = "Temperatura";
break;
case 2:
cam.DescricaoTipoAlerta = "Pressão";
break;
case 3:
cam.DescricaoTipoAlerta = "Produção";
break;
}
cam.AtivoDescricao = item.Ativo.Value == 1 ? "Sim" : "Não";
//
cam.Ativo = item.Ativo.Value;
cam.Valor = item.Valor;
cam.Regra = item.Regra.Value;
cam.AtivoDescricao = "";
cam.Prioridade = 0;
//
lista_coletor_alerta_item_model.Add(cam);
}
//
}
}
//
ReportDocument oRelatorioMaquina = null;
ReportDocument oRelatorioMaquinaItem = null;
ReportDocument oRelatorioMaquinaItemAlerta = null;
ReportDocument oRelatorioMaquinaItemLogAlerta = null;
//
try
{
oRelatorioMaquina = new ReportDocument();
oRelatorioMaquinaItem = new ReportDocument();
oRelatorioMaquinaItemAlerta = new ReportDocument();
oRelatorioMaquinaItemLogAlerta = new ReportDocument();
oRelatorioMaquina = new ReportDocument();
//
string local = AppDomain.CurrentDomain.BaseDirectory + "Temp";
sFileName = "Relatório_Máquinas" + DateTime.Today.ToShortDateString() + "_" + DateTime.Now.ToLongTimeString() + "_.pdf";
sFileName = sFileName.Replace("/", "-");
sFileName = sFileName.Replace("\\", "-");
sFileName = sFileName.Replace(":", "-");
//
oRelatorioMaquina.Load(System.Web.HttpContext.Current.Server.MapPath("~/Relatorio/") + "RelatorioMaquinaTemp.rpt");
oRelatorioMaquina.SetDataSource(lista_empresa_model);
oRelatorioMaquina.Database.Tables[0].SetDataSource(lista_empresa_model);
//oRelatorioMaquina.Subreports["RelatorioMaquinaItem.rpt"].Database.Tables[0].SetDataSource(lista_maquina_itens_report_model);
////
//oRelatorioMaquinaItemAlerta.Load(System.Web.HttpContext.Current.Server.MapPath("~/Relatorio/") + "RelatorioMaquinaItemAlerta.rpt");
//oRelatorioMaquinaItemAlerta.SetDataSource(lista_coletor_alerta_item_model);
//oRelatorioMaquinaItemAlerta.Database.Tables[0].SetDataSource(lista_coletor_alerta_item_model);
//
//oRelatorioMaquinaItem.Load(System.Web.HttpContext.Current.Server.MapPath("~/Relatorio/") + "RelatorioMaquinaItem.rpt");
//oRelatorioMaquinaItem.SetDataSource(lista_maquina_itens_report_model);
//oRelatorioMaquinaItem.Database.Tables[0].SetDataSource(lista_maquina_itens_report_model);
//oRelatorioMaquinaItem.Subreports["RelatorioMaquinaItemAlerta.rpt"].Database.Tables[0].SetDataSource(lista_coletor_alerta_item_model);
//
//
//
//
oRelatorioMaquina.ExportToDisk(ExportFormatType.PortableDocFormat, local + "\\" + sFileName);
//
oRelatorioMaquinaItemAlerta.Close();
oRelatorioMaquina.Close();
oRelatorioMaquinaItem.Close();
//
oRelatorioMaquinaItemAlerta.Dispose();
oRelatorioMaquina.Dispose();
oRelatorioMaquinaItem.Dispose();
//
System.GC.Collect();
sreult = "ok";
}
catch (Exception exc)
{
//Utils.Utils.Log.GravaLogExc(exc);
sFileName = "Erro: " + exc.Message;
sreult = "nok";
}
//
return(Json(new
{
data = sFileName,
sreult,
results = lista_empresa_model.Count(),
success = true,
errors = String.Empty
}, JsonRequestBehavior.AllowGet));
}
public JsonResult RelatorioTemperaturaAtmosfera(int idempresa, string strimage1, string maquinas, string periodo)
{
//string data = strimage1 + strimage2;
string img = strimage1.Split(',')[1];
string sFileNameImgGrafico = "img" + DateTime.Today.ToShortDateString().Replace("/", "_") + "_" + DateTime.Now.ToLongTimeString().Replace(":", "_");
string ext = ".png";
string app_path = ((HttpRequestWrapper)this.Request).PhysicalApplicationPath;
app_path += "Temp\\";
//byte[] bytes = Convert.FromBase64String("iVBORw0KGgoAAAANSUhEUgAAAwwAAAGGCAYAAADWywbsAAAgAElEQVR4XuydCXwcZf3/P9/ZhATQcjSbAnIoh8ohhyUbyiXKjaA/ORWbTZuLcioFUdoUCk0BQUCpYkmTtNkUOVV+HggoCgq02RRR5Pj/9Ac/BAGbTYFWoEnTne//9czOpJNtjtljdmdmv/N6+ZJmn+P7vD+zs89nnosglxAQAkJACAgBISAEhIAQEAJCYBwCJGSEgBAQAkJACAgBISAEhIAQEALjERDDIPeGEBACQkAICAEhIASEgBAQAuMSEMMgN4cQEAJCQAgIASEgBISAEBACYhjkHhACQkAICAEhIASEgBAQAkIgcwIywpA5M8khBISAEBACQkAICAEhIARKhoAYhpKRWhoqBISAEBACQkAICAEhIAQyJyCGIXNmkkMICAEhIASEgBAQAkJACJQMATEMJSO1NFQICAEhIASEgBAQAkJACGROQAxD5swkhxAQAkJACAgBISAEhIAQKBkCYhhKRmppqBAQAkJACAgBISAEhIAQyJyAGIbMmUkOISAEhIAQEAJCQAgIASFQMgTEMJSM1NJQIRBMAi0tLfcCOM9qHTNfu2zZsusvvfTSKYODgw+rv1dWVp62ZMmSDbkQaGlpqSWixrvuuqvFXk629ajyADzKzLepeO1lTvRZLm1QeYvNa7L4m5ubryGi61Q6Zj572bJlP02Lez2Ak9vb23vHKyudn9JoaGioXdO0K8rLy/8z2X0xZ86cj+m6/gyAPe0xTBR7tvfBZDzkcyEgBISAFwiIYfCCChKDEBACGROwOmhEtIemaUcuXbr0TaujCOCRioqKlsk6hk4rtXUgV7W3t3/Vab6J0rlpCsaq1y+87IYBwH2Kty32owBkbBhMkzTDuk8m06+5ufksInrQTGfEMFke+VwICAEhEGQCYhiCrK60TQgEmIDVqRvvDbCtk7mDieEgAK/bO41pb9uNz6w30ERk5VNvmV8jooPNt95P20csxnqzbC+XmUeltyRxOsJQWVn5fcv4EJEaJTk1vR1pb+XHrM8rvCa7JW1teZGZ31Osh4aG9lejMQD+BWB3NcLAzLurTr2lv5lvrvrMrMMYvVH/bY1YKLOh6/qZRGSM6Iw38mQZDGZ+w25IVR4rPlVvKBRarUYiVLpQKHReMpm8z16uk/tgMh7yuRAQAkLACwTEMHhBBYlBCAiBjAlM9tbYZhiUURjViVRTgFQHGsDlaR3SkZEJIjLyqakvE40wpBuGwcHBE62OLBGpDm7G047sZsIyDFY89s6w1Q6rPqsDC2CrkRCv8JpMaJthUJ3vU0xzcLKaDkZEiuW5mRgGxcje9smmJNm1ZuYH7KZExW4fqTENhXGfVFRUvGwf0XJ6H0zGQz4XAkJACHiBgBgGL6ggMQgBIZAxgQw6wMaUJVWBOS99VGc6bZThvrGmMmVjGFR9E81/z3SEwXrTnd6OdA7q3+rte/rbc6/wmkxo2xv8bxLRXGbuJKIDzBGF1QCa3DQM9pGY8QzYWFOWxjOOk90Hk/GQz4WAEBACXiAghsELKkgMQkAIZEzAaQdYFaw6z8PDwx+1Gwb7m2y1GNb6LFfDoOpTb5qJSM23N66xjEOmhmGsdlix2usyqxw19Ur9zSu8JhPa0oWIGnRdb1TplVlSxsH8b2PakdMpSZmOMIxlwACMWv+QPnqlRqHSDYPT+2AyHvK5EBACQsALBMQweEEFiUEICIGMCTidkz9RR9vJZ2p3pUxGGOy7MdlMyVgdeEe7JNnXMIxlfCYzAhZYr/Cy70A01gJm+xoBAAfad0wy/+2aYbAtmrfWr4zcl9buW+oPY60ZsQyCdU85vQ8yvvElgxAQAkKgCATEMBQBulQpBIRA7gQy3fUnfYTB3tFOJpNqfrzaytPRlKSx1hhYHcXBwUFjKs1Y89rtnch8jDCo3XucTKFRsRWTVyZqpxkGNbqgdisyDJep01YLmydb5+F0DYO9bms7V8vgqPUK6etdmPkldd8oM5Fu7JzeB5mwkbRCQAgIgWIREMNQLPJSrxAQAnkhkH6uQPpWnGONIqiOdtrbZLVV5wZmfn2s3W5UGbZ6VOf1Yl3XV6pdeNI7isoUpMU05jagE7zNVot9b7cWS082wjDeG+/xzp0oEi9j21sngo+3C5HqrNs74WoakK0tirE6N0GtVRlzgbu1TSoR1em6Pid9JGAsQ2XFa9ZjLMBWC+WtxdjWQmc1ZcqcJtVhL9fJfeCEiaQRAkJACBSbgBiGYisg9QsBIeBrAnJgl6/lk+CFgBAQAkLAAQExDA4gSRIhIASEwFgE7KMETk8EFpJCQAgIASEgBPxGQAyD3xSTeIWAEBACQkAICAEhIASEQAEJiGEoIGypSggIASEgBISAEBACQkAI+I2AGAa/KSbxCgEhIASEgBAQAkJACAiBAhIQw1BA2FKVEBACQkAICAEhIASEgBDwGwExDH5TTOIVAkJACAgBISAEhIAQEAIFJCCGoYCwpSohIASEgBAQAkJACAgBIeA3AmIY/KaYxCsEhIAQEAJCQAgIASEgBApIQAxDAWFLVUJACAgBISAEhIAQEAJCwG8ExDD4TTGJVwgIASEgBISAEBACQkAIFJCAGIYCwpaqhIAQEAJCQAgIASEgBISA3wiIYfCbYhKvEBACQkAICAEhIASEgBAoIAExDAWELVUJASEgBISAEBACQkAICAG/ERDD4DfFJF4hIASEgBAQAkJACAgBIVBAAmIYCghbqhICQkAICAEhIASEgBAQAn4jIIbBb4pJvEJACAgBISAEhIAQEAJCoIAExDAUELZUJQSEgBAQAkJACAgBISAE/EZADIPfFJN4hYAQEAJCQAgIASEgBIRAAQmIYSggbKlKCAgBISAEhIAQEAJCQAj4jYAYBr8pJvEKASEgBISAEBACQkAICIECEhDDUEDYUpUQcJMAN1y7m5vl57ts6rrurXyXKeVlRuCwzoSv7pnnGsNyz2QmsaQWAkJACOSFgBiGvGCUQoRA8QlwY9t3AVxV/EgcRfBt6my92VFKSeQagZrl/YdSiJ5zrYJ8Fkz4S7wufFg+i5SyhIAQEAJCwBkBMQzOOEkqIeB5AmIYPC+R5wIUw+A5SSQgISAEhIAnCYhh8KQsEpQQyJyA3w1DS0tLLYBHmfmFysrK05YsWbJBUbj00kunDA4OPkxEBwE4ub29vdcJnZaWlnsBnJeWdr0qA8DlzPzSsmXLrndSlkqjynOSp7m5+Swiuk3TtCOXLl365njlOy3PaXxWujlz5nxM1/VHADRNxsrvhmGie6O5ufkaIrqOma/NUGfjPgSwg2LKzE/b78dM9chHetUWACdNFoeTdJncH5nGbn6HOzRNO2Wiez/TciW9EBACxScghqH4GkgEQiAvBAJiGB4AoIxCo9XZNTshnQCmADhnsk6wBdM0DGhvb/9qPgA77eCLYcgH7THKGGNKks0w7MjM91vGQP19aGhIGcaDmLnDqWGwmdbGZcuW/dRmFHefrLPuUquNYp0YAafpxDC4qZSULQSCS0AMQ3C1lZaVGIGAGIYOIlql6/q/rE6e6ixpmrY7M89Qb83TRwfMzhTSO4UTGQar819ZWfl9c/RiRwAHMvPZ6rYhogfN2+d1NVKQTCYb1dtq843zVm+srY6m+Vb6PgAzVL7y8vL/mOUfZX9bPTg4+M308qw34ma9xkiIMkemARkVj3p7a+ssW2WfXVlZ+VtbfSNljPdVCNAIw2oAB1RUVHxVjUyZelxrMlefvajuG6vTb31upbf4jGX2zLTKyBpm1a5H+uiDfVRL3UvKdIylk/q79TaemdcT0YiGllGx1aN0fIaZp4xlWsZLNzw8/FFd158BsKfZvvsqKipa0u8PTdP+lZ7OMtlpo3T32f5uH4UxviOqDls5xt9klKHEfoSkuYEmIIYh0PJK40qJQFAMg3ojrDpnqnOk9FNvipm5k4gWKsPAzLtbnT/rcwDXpY88ZGgY/qU6Q+lvX+1mZLwRBjOP6tB1KtNi1msYBl3Xb1Ux2spW6eaaHcaRKU7pHVUrdk3TrrBPL0qPxyrbzK9GYU42O4AlNSUJwANEpMykMQ3L4kREB6hpZKFQqHM8jvZnhKWlafy2mv5mNw8VFRUvm51v494xDd8B6r/tU3PUPaDuWXU/Dw4OnkhEhk5mvWoK3m3WfWOlGxoa2t+cntdomUCVPt0w2EdE7OlCodB5yWRSGdfHzLJVB98wPfb7w2rDWOnG+55ZBiPtPjbaZ8YtU5JK6YdH2loyBMQwlIzU0tCgEwiKYdA0rVHXddWpUh1AdV2r6/oVmqbdr/6mOiyqM6Q6RbquK/NwbfqbYpVprDUM1lvf9BEGq8M00XSN8QxD+rzt8eZxW2+aAdyebhjS702r85luGKx0NpNimA972aFQaHWprWFQTInoHGUO1KiROR1JjQiNrFUx9XtAdaytz8eb3jbBaM+otQTKqKk6bB10Q1tLp3TNbf9+jIjUOolRIxeWEVbGwj4iYtWTbhjS/z5eOvt9PZGhtKezGwZrPZFq1xjmVpkRwySY30cxDEH/sZH2lSQBMQwlKbs0OogEAmQYVMdDvZVVnakD1Vvi9I6z1flTnystx5qjnskIg9WJN43GyHQL+5ST8QyDgw7UyAJaVX66aVGxp09bMe9PYwqIfbqTFc8Y002MLGqBb/rb9Inu9aBMSVL6qXYq02D+t9WBVfeRsbjd1Mn6fEyTORYru772qWm2tK+HQqEzk8nkz6y37uMZO8vIqphMwzDSubZ39tWUNfsi5wkMw5gGxjaaYU1lU1UbU9TSDUPalLeRdNZIzRhT59Sifnu5I3nMdothCOIPjLSp5AmIYSj5W0AABIVAkAxDMpk8goga1bxt1QFMf2tudnIaTe22mo5kdczU/4+16HmMEYZRb4ateyJtmsmYuySNN8Kgpn+Y06uMaSETjTCkL2q112u/Py");
//var imgbase64 = data.Split(',')[1];
string img2 = img.Replace(" ", "+");
byte[] bytes = Convert.FromBase64String(img2);
//byte[] imageBytes = Convert.FromBase64String(base64String);
MemoryStream ms = new MemoryStream(bytes, 0, bytes.Length);
ms.Write(bytes, 0, bytes.Length);
System.Drawing.Image image = System.Drawing.Image.FromStream(ms, true);
image.Save(app_path + sFileNameImgGrafico + ext);
sFileNameImgGrafico = RemTransp(app_path + sFileNameImgGrafico + ext, sFileNameImgGrafico);
//
List <Object> lista = new List <Object>();
//
string sreult = string.Empty;
string sFileName = string.Empty;
Empresa empresaLista = null;
//
List <EmpresaRelatorioModel> lista_empresa_model = new List <EmpresaRelatorioModel>();
List <ColetorAlerta> lista_coletoralerta_model = new List <ColetorAlerta>();
List <ColetorAlertaLog> lista_coletor_alerta_log = new List <ColetorAlertaLog>();
//
List <ColetorAlertaModel> lista_coletor_alerta_item_model = new List <ColetorAlertaModel>();
List <ColetorAlertaLogModel> lista_coletor_alerta_log_model = new List <ColetorAlertaLogModel>();
List <MaquinaItensReportModel> lista_maquina_itens_report_model = new List <MaquinaItensReportModel>();
//
empresaLista = db.Empresa.Where(x => x.Id == idempresa).FirstOrDefault();
//
if (empresaLista != null)
{
EmpresaRelatorioModel tmp = new EmpresaRelatorioModel();
//
tmp.Id = empresaLista.Id;
tmp.Nome = empresaLista.Nome;
tmp.Numero = empresaLista.Numero;
tmp.Telefone = empresaLista.Telefone;
tmp.Site = empresaLista.Site;
tmp.EstadoSigla = PegaEstadoSigla(empresaLista.Estado);
tmp.Endereco = empresaLista.Endereco;
tmp.CEP = empresaLista.CEP;
tmp.Cidade = empresaLista.Cidade;
tmp.NomeFantasia = empresaLista.NomeFantasia;
tmp.Email = empresaLista.Email;
tmp.Bairro = empresaLista.Bairro;
tmp.Imagem = RetornaImagemLink(sFileNameImgGrafico);
tmp.Periodo = periodo;
tmp.NomeMaquina = maquinas;
lista_empresa_model.Add(tmp);
}
//
ReportDocument oRelatorioMaquina = null;
ReportDocument oRelatorioMaquinaItem = null;
ReportDocument oRelatorioMaquinaItemAlerta = null;
ReportDocument oRelatorioMaquinaItemLogAlerta = null;
//
try
{
oRelatorioMaquina = new ReportDocument();
oRelatorioMaquinaItem = new ReportDocument();
oRelatorioMaquinaItemAlerta = new ReportDocument();
oRelatorioMaquinaItemLogAlerta = new ReportDocument();
oRelatorioMaquina = new ReportDocument();
//
string local = AppDomain.CurrentDomain.BaseDirectory + "Temp";
sFileName = "Relatorio_Maquinas" + DateTime.Today.ToShortDateString() + "_" + DateTime.Now.ToLongTimeString() + "_.pdf";
sFileName = sFileName.Replace("/", "-");
sFileName = sFileName.Replace("\\", "-");
sFileName = sFileName.Replace(":", "-");
//
oRelatorioMaquina.Load(System.Web.HttpContext.Current.Server.MapPath("~/Relatorio/") + "RelatorioMaquinaTemp.rpt");
oRelatorioMaquina.SetDataSource(lista_empresa_model);
oRelatorioMaquina.Database.Tables[0].SetDataSource(lista_empresa_model);
//oRelatorioMaquina.Subreports["RelatorioMaquinaItem.rpt"].Database.Tables[0].SetDataSource(lista_maquina_itens_report_model);
////
//oRelatorioMaquinaItemAlerta.Load(System.Web.HttpContext.Current.Server.MapPath("~/Relatorio/") + "RelatorioMaquinaItemAlerta.rpt");
//oRelatorioMaquinaItemAlerta.SetDataSource(lista_coletor_alerta_item_model);
//oRelatorioMaquinaItemAlerta.Database.Tables[0].SetDataSource(lista_coletor_alerta_item_model);
//
//oRelatorioMaquinaItem.Load(System.Web.HttpContext.Current.Server.MapPath("~/Relatorio/") + "RelatorioMaquinaItem.rpt");
//oRelatorioMaquinaItem.SetDataSource(lista_maquina_itens_report_model);
//oRelatorioMaquinaItem.Database.Tables[0].SetDataSource(lista_maquina_itens_report_model);
//oRelatorioMaquinaItem.Subreports["RelatorioMaquinaItemAlerta.rpt"].Database.Tables[0].SetDataSource(lista_coletor_alerta_item_model);
//
oRelatorioMaquina.ExportToDisk(ExportFormatType.PortableDocFormat, local + "\\" + sFileName);
//
oRelatorioMaquinaItemAlerta.Close();
oRelatorioMaquina.Close();
oRelatorioMaquinaItem.Close();
//
oRelatorioMaquinaItemAlerta.Dispose();
oRelatorioMaquina.Dispose();
oRelatorioMaquinaItem.Dispose();
//
GC.Collect();
sreult = "ok";
}
catch (Exception exc)
{
//Utils.Utils.Log.GravaLogExc(exc);
sFileName = "Erro: " + exc.Message;
sreult = "nok";
}
//
return(Json(new
{
data = "OK",
results = 1,
success = true,
errors = 0,
relatorio = sFileName,
}, JsonRequestBehavior.AllowGet));
}
