public string TmtGeral(Usuarios user)
{
using (contextoTaskConsulta = new ContextoTaskConsulta())
{
//var strQuery = "select round(avg(round(avg(tma), 2)),4) TMA from(SELECT distinct t.cd_projeto,t.cd_tarefa,os.ds_tarefa,t.cd_tipotarefa,t.cd_responsavel,TO_DATE(os.dt_cadastro, 'DD/MM/YY') AS Dt_Cadastro, to_date(os.dh_entregacliente, 'dd/mm/yy') as dt_Entrega, (to_date(os.dh_entregacliente, 'dd/mm/yy') - TO_DATE(os.dt_cadastro, 'DD/MM/YY')) as tma, to_char(os.dh_entregacliente, 'MM') as MES_ENTREGA, to_char(os.dh_entregacliente, 'YYYY') as ANO_ENTREGA, os.cd_natureza, os.cd_equipe FROM TRIAGEM t, ordemservico os WHERE T.cd_projeto = os.cd_projeto AND t.cd_tarefa = os.cd_tarefa and os.cd_projeto not in ('ERP_CSERVICO', 'TREIN_ERP','ERP_SHS','SHS_INFRA', 'TREIN_EDIG', 'GINASTICA_LAB') and t.cd_equipe in (9, 13) and os.cd_natureza = (6) and os.dh_entregacliente between '01/11/2016' and '30/11/2016' AND T.CD_RESPONSAVEL = '" + user.Nome + "') group by cd_responsavel order by cd_responsavel";
var strQuery = "select round(avg(round(avg(tma), 2)),4) TMA from(SELECT distinct t.cd_projeto,t.cd_tarefa,os.ds_tarefa,t.cd_tipotarefa,t.cd_responsavel,TO_DATE(os.dt_cadastro, 'DD/MM/YY') AS Dt_Cadastro, to_date(os.dh_entregacliente, 'dd/mm/yy') as dt_Entrega, (to_date(os.dh_entregacliente, 'dd/mm/yy') - TO_DATE(os.dt_cadastro, 'DD/MM/YY')) as tma, to_char(os.dh_entregacliente, 'MM') as MES_ENTREGA, to_char(os.dh_entregacliente, 'YYYY') as ANO_ENTREGA, os.cd_natureza, os.cd_equipe FROM TRIAGEM t, ordemservico os WHERE T.cd_projeto = os.cd_projeto AND t.cd_tarefa = os.cd_tarefa and os.cd_projeto not in ('ERP_CSERVICO', 'TREIN_ERP','ERP_SHS','SHS_INFRA', 'TREIN_EDIG', 'GINASTICA_LAB') and t.cd_equipe in (9, 13) and os.cd_natureza = (6) and os.dh_entregacliente between '01/11/2016' and '30/11/2016') group by cd_responsavel order by cd_responsavel";
var retornoDataReader = contextoTaskConsulta.ExecutaComandoComRetorno(strQuery);
return(TransformaTma(retornoDataReader));
}
}
public string VerificaLogin(Usuarios user)
{
var strQuery = "";
strQuery += "SELECT cd_usuario FROM seg_usuario";
strQuery += string.Format(" WHERE cd_usuario = '{0}' ",
user.Nome);
using (contextoTaskConsulta = new ContextoTaskConsulta())
{
contextoTaskConsulta.ExecutaComandoLogin(strQuery);
var retornoDataReader = contextoTaskConsulta.ExecutaComandoComRetorno(strQuery);
return(RecuperaLogin(retornoDataReader));
}
}
