public IHttpActionResult TrazDropDown(
[FromUri] MaterialCentroDropDownDTO dto,
[FromUri] TipoDaInfo tipoC,
[FromUri] bool ctLogis,
[FromUri] bool adm
)
{
LimpaResultado(dto, tipoC, adm);
var dtoRst = new MaterialCentroDropDownDTORst()
{
Empresas = (from x in _listaEstoqueHistorico
orderby x.EmpresaNome
select x.EmpresaNome)
.Distinct()
.ToList(),
Gestores = (from x in _listaEstoqueHistorico
orderby x.UserName
select x.UserName)
.Distinct()
.ToList(),
Familias = (from x in _listaEstoqueHistorico
orderby x.FamiliaNome
select x.FamiliaNome)
.Distinct()
.ToList(),
Materiais = (from x in _listaEstoqueHistorico
orderby x.MaterialCodSap
select x.MaterialCodSap.ToString())
.Distinct()
.ToList(),
Centros = (from x in _listaEstoqueHistorico
orderby x.CentroLogisticoCodSap
select x.CentroLogisticoCodSap)
.Distinct()
.ToList(),
};
//if(ctLogis)
//{
// dtoRst.Centros = (from x in _listaEstoqueHistorico
// orderby x.CentroLogisticoCodSap
// select x.CentroLogisticoCodSap)
// .Distinct()
// .ToList();
//}
return(Ok(dtoRst));
}
private void LimpaResultado(MaterialCentroDropDownDTO dto, TipoDeConsultaHistConsumo tipoC)
{
BuscaPeloAcesso(tipoC);
if (!(dto.Empresa == null || dto.Empresa == ""))
{
_listaHistConsumo = (from x in _listaHistConsumo
where x.EmpresaNome == dto.Empresa
select x).Distinct().ToList();
}
if (!(dto.Gestor == null || dto.Gestor == ""))
{
_listaHistConsumo = (from x in _listaHistConsumo
where x.UserName == dto.Gestor
select x).Distinct().ToList();
}
if (!(dto.Familia == null || dto.Familia == ""))
{
_listaHistConsumo = (from x in _listaHistConsumo
where x.FamiliaNome == dto.Familia
select x).Distinct().ToList();
}
if (!(dto.Material == null || dto.Material == ""))
{
_listaHistConsumo = (from x in _listaHistConsumo
where x.MaterialCodSap == dto.Material
select x).ToList();
}
if (!(dto.Centro == null || dto.Centro == ""))
{
_listaHistConsumo = (from x in _listaHistConsumo
where x.CentroLogisticoCodSap == dto.Centro
select x).Distinct().ToList();
}
}
public IHttpActionResult TrazDropDown([FromUri] MaterialCentroDropDownDTO dto,
[FromUri] TipoDeConsultaHistConsumo tipoC)
{
LimpaResultado(dto, tipoC);
var dtoRst = new MaterialCentroDropDownDTORst()
{
Empresas = (from x in _listaHistConsumo
orderby x.EmpresaNome
select x.EmpresaNome)
.Distinct()
.ToList(),
Gestores = (from x in _listaHistConsumo
orderby x.UserName
select x.UserName)
.Distinct()
.ToList(),
Familias = (from x in _listaHistConsumo
orderby x.FamiliaNome
select x.FamiliaNome)
.Distinct()
.ToList(),
Materiais = (from x in _listaHistConsumo
orderby x.MaterialCodSap
select x.MaterialCodSap.ToString())
.Distinct()
.ToList(),
Centros = (from x in _listaHistConsumo
orderby x.CentroLogisticoCodSap
select x.CentroLogisticoCodSap)
.Distinct()
.ToList(),
};
return(Ok(dtoRst));
}
private void LimpaResultado(MaterialCentroDropDownDTO dto, TipoDaInfo tipoC, bool adm)
{
BuscaPeloAcesso();
var indice = Convert.ToInt32(tipoC);
if (indice != 6)
{
_listaEstoqueHistorico = _listaEstoqueHistorico
.Where(c => c.TipoDaInfo == tipoC)
.Where(d => d.AdmVersion == adm)
.ToList();
}
else
{
_listaEstoqueHistorico = (from x in _listaEstoqueHistorico
where
(x.TipoDaInfo == TipoDaInfo.ConsumoValor ||
x.TipoDaInfo == TipoDaInfo.EntradaValor ||
x.TipoDaInfo == TipoDaInfo.EstoqueValor) &&
x.AdmVersion == adm
select x
).ToList();
}
if (!(dto.Empresa == null || dto.Empresa == ""))
{
_listaEstoqueHistorico = (from x in _listaEstoqueHistorico
where x.EmpresaNome == dto.Empresa
select x).Distinct().ToList();
}
if (!(dto.Gestor == null || dto.Gestor == ""))
{
_listaEstoqueHistorico = (from x in _listaEstoqueHistorico
where x.UserName == dto.Gestor
select x).Distinct().ToList();
}
if (!(dto.Familia == null || dto.Familia == ""))
{
_listaEstoqueHistorico = (from x in _listaEstoqueHistorico
where x.FamiliaNome == dto.Familia
select x).Distinct().ToList();
}
if (!(dto.Material == null || dto.Material == ""))
{
_listaEstoqueHistorico = (from x in _listaEstoqueHistorico
where x.MaterialCodSap == dto.Material
select x).ToList();
}
if (!(dto.Centro == null || dto.Centro == ""))
{
_listaEstoqueHistorico = (from x in _listaEstoqueHistorico
where x.CentroLogisticoCodSap == dto.Centro
select x).Distinct().ToList();
}
}
public IHttpActionResult GetListaEstoqueHistorico(
[FromUri] MaterialCentroDropDownDTO dto,
[FromUri] TipoDaInfo tipoC,
[FromUri] bool ctLogis,
[FromUri] bool adm)
{
LimpaResultado(dto, tipoC, adm);
var _EstHIstFiltrado = Filtro.EstHist(_listaEstoqueHistorico.ToList());
string TipoDaInforamcao = null;
var tipoConsulta = (int)tipoC;
try
{
switch (tipoConsulta)
{
case 1:
{
TipoDaInforamcao = "Consumo por Valor";
break;
}
case 2:
{
TipoDaInforamcao = "Estoque por Quantidade";
break;
}
case 3:
{
TipoDaInforamcao = "Estoque por Valor";
break;
}
case 4:
{
TipoDaInforamcao = "Entrada por Quantidade";
break;
}
case 5:
{
TipoDaInforamcao = "Entrada por Valor";
break;
}
case 6:
{
var Resumo = (from x in _EstHIstFiltrado
group x by x.DataLanc into g
select new
{
data = g.Key,
tipoDaInforamcao = "Estoque",
m1 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 3).Sum(c => c.M1),
m2 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 3).Sum(c => c.M2),
m3 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 3).Sum(c => c.M3),
m4 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 3).Sum(c => c.M4),
m5 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 3).Sum(c => c.M5),
m6 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 3).Sum(c => c.M6),
m7 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 3).Sum(c => c.M7),
m8 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 3).Sum(c => c.M8),
m9 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 3).Sum(c => c.M9),
m10 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 3).Sum(c => c.M10),
m11 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 3).Sum(c => c.M11),
m12 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 3).Sum(c => c.M12),
acumulado = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 3).Sum(c => c.Media),
}).ToList().Union(
(from x in _EstHIstFiltrado
group x by x.DataLanc into g
select new
{
data = g.Key,
tipoDaInforamcao = "Entrada",
m1 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 5).Sum(c => c.M1),
m2 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 5).Sum(c => c.M2),
m3 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 5).Sum(c => c.M3),
m4 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 5).Sum(c => c.M4),
m5 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 5).Sum(c => c.M5),
m6 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 5).Sum(c => c.M6),
m7 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 5).Sum(c => c.M7),
m8 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 5).Sum(c => c.M8),
m9 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 5).Sum(c => c.M9),
m10 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 5).Sum(c => c.M10),
m11 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 5).Sum(c => c.M11),
m12 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 5).Sum(c => c.M12),
acumulado = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 5).Sum(c => c.Acumulado),
}).ToList()
).Union(
(from x in _EstHIstFiltrado
group x by x.DataLanc into g
select new
{
data = g.Key,
tipoDaInforamcao = "Consumo",
m1 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 1).Sum(c => c.M1),
m2 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 1).Sum(c => c.M2),
m3 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 1).Sum(c => c.M3),
m4 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 1).Sum(c => c.M4),
m5 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 1).Sum(c => c.M5),
m6 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 1).Sum(c => c.M6),
m7 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 1).Sum(c => c.M7),
m8 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 1).Sum(c => c.M8),
m9 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 1).Sum(c => c.M9),
m10 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 1).Sum(c => c.M10),
m11 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 1).Sum(c => c.M11),
m12 = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 1).Sum(c => c.M12),
acumulado = g.Where(d => Convert.ToInt16(d.TipoDaInfo) == 1).Sum(c => c.Acumulado),
}).ToList()
);
return(Ok(Resumo));
}
default:
{
TipoDaInforamcao = "Consumo por Quantidade";
break;
}
}
if (ctLogis)
{
if (tipoConsulta == 2 || tipoConsulta == 3)
{
var eHistConsumo = (from x in _EstHIstFiltrado
group x by new
{
x.EmpresaNome,
x.CentroLogisticoCodSap,
x.MaterialCodSap,
x.MaterialDescricao,
x.MaterialUM,
x.MaterialClasse,
x.ClassificacaoNome,
x.FamiliaNome,
x.MGCodeCodigoSap,
x.MGCodeDescricao,
x.UserName,
}
into g
select new
{
empresaNome = g.Key.EmpresaNome,
centroLogisticoCodSap = g.Key.CentroLogisticoCodSap,
materialCodSap = g.Key.MaterialCodSap,
materialDescricao = g.Key.MaterialDescricao,
materialUM = g.Key.MaterialUM,
materialClasse = g.Key.MaterialClasse,
classificacaoNome = g.Key.ClassificacaoNome,
familiaNome = g.Key.FamiliaNome,
mGCodeCodigoSap = g.Key.MGCodeCodigoSap,
mGCodeDescricao = g.Key.MGCodeDescricao,
userName = g.Key.UserName,
tipoDaInforamcao = TipoDaInforamcao,
m1 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M1),
m2 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M2),
m3 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M3),
m4 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M4),
m5 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M5),
m6 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M6),
m7 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M7),
m8 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M8),
m9 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M9),
m10 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M10),
m11 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M11),
m12 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M12),
acumulado = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.Media),
}).ToList();
return(Ok(eHistConsumo));
}
var zHistConsumo = (from x in _EstHIstFiltrado
group x by new
{
x.EmpresaNome,
x.CentroLogisticoCodSap,
x.MaterialCodSap,
x.MaterialDescricao,
x.MaterialUM,
x.MaterialClasse,
x.ClassificacaoNome,
x.FamiliaNome,
x.MGCodeCodigoSap,
x.MGCodeDescricao,
x.UserName,
}
into g
select new
{
empresaNome = g.Key.EmpresaNome,
centroLogisticoCodSap = g.Key.CentroLogisticoCodSap,
materialCodSap = g.Key.MaterialCodSap,
materialDescricao = g.Key.MaterialDescricao,
materialUM = g.Key.MaterialUM,
materialClasse = g.Key.MaterialClasse,
classificacaoNome = g.Key.ClassificacaoNome,
familiaNome = g.Key.FamiliaNome,
mGCodeCodigoSap = g.Key.MGCodeCodigoSap,
mGCodeDescricao = g.Key.MGCodeDescricao,
userName = g.Key.UserName,
tipoDaInforamcao = TipoDaInforamcao,
m1 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M1),
m2 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M2),
m3 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M3),
m4 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M4),
m5 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M5),
m6 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M6),
m7 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M7),
m8 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M8),
m9 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M9),
m10 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M10),
m11 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M11),
m12 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M12),
acumulado = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.Acumulado),
}).ToList();
return(Ok(zHistConsumo));
}
if (tipoConsulta == 2 || tipoConsulta == 3)
{
var eHistConsumo = (from x in _EstHIstFiltrado
group x by new
{
x.EmpresaNome,
x.MaterialCodSap,
x.MaterialDescricao,
x.MaterialUM,
x.MaterialClasse,
x.ClassificacaoNome,
x.FamiliaNome,
x.MGCodeCodigoSap,
x.MGCodeDescricao,
x.UserName,
}
into g
select new
{
empresaNome = g.Key.EmpresaNome,
materialCodSap = g.Key.MaterialCodSap,
materialDescricao = g.Key.MaterialDescricao,
materialUM = g.Key.MaterialUM,
materialClasse = g.Key.MaterialClasse,
classificacaoNome = g.Key.ClassificacaoNome,
familiaNome = g.Key.FamiliaNome,
mGCodeCodigoSap = g.Key.MGCodeCodigoSap,
mGCodeDescricao = g.Key.MGCodeDescricao,
userName = g.Key.UserName,
tipoDaInforamcao = TipoDaInforamcao,
m1 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M1),
m2 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M2),
m3 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M3),
m4 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M4),
m5 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M5),
m6 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M6),
m7 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M7),
m8 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M8),
m9 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M9),
m10 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M10),
m11 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M11),
m12 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M12),
acumulado = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.Media),
}).ToList();
return(Ok(eHistConsumo));
}
var HistConsumo = (from x in _EstHIstFiltrado
group x by new
{
x.EmpresaNome,
x.MaterialCodSap,
x.MaterialDescricao,
x.MaterialUM,
x.MaterialClasse,
x.ClassificacaoNome,
x.FamiliaNome,
x.MGCodeCodigoSap,
x.MGCodeDescricao,
x.UserName,
}
into g
select new
{
empresaNome = g.Key.EmpresaNome,
materialCodSap = g.Key.MaterialCodSap,
materialDescricao = g.Key.MaterialDescricao,
materialUM = g.Key.MaterialUM,
materialClasse = g.Key.MaterialClasse,
classificacaoNome = g.Key.ClassificacaoNome,
familiaNome = g.Key.FamiliaNome,
mGCodeCodigoSap = g.Key.MGCodeCodigoSap,
mGCodeDescricao = g.Key.MGCodeDescricao,
userName = g.Key.UserName,
tipoDaInforamcao = TipoDaInforamcao,
m1 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M1),
m2 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M2),
m3 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M3),
m4 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M4),
m5 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M5),
m6 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M6),
m7 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M7),
m8 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M8),
m9 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M9),
m10 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M10),
m11 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M11),
m12 = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.M12),
acumulado = g.Where(d => d.TipoDaInfo == tipoC).Sum(c => c.Acumulado),
}).ToList();
return(Ok(HistConsumo));
}
catch (Exception msg)
{
return(BadRequest(msg.Message));
}
}
public IHttpActionResult GetListaEstoqueConsumo([FromUri] MaterialCentroDropDownDTO dto,
[FromUri] TipoDeConsultaEstoqueConsumo tipoC)
{
LimpaResultado(dto);
var tipoConsulta = (int)tipoC;
try
{
switch (tipoConsulta)
{
case 1:
{
var EstoqueConsumo = (from x in _listaEstoqueConsumo
group x by new
{
x.EmpresaNome,
x.CentroLogisticoCodSap,
x.MaterialCodSap,
x.MaterialDescricao,
x.MaterialClasse,
x.MaterialUM,
x.ClassificacaoNome,
x.UserName,
x.MGCodeCodigoSap,
x.MGCodeDescricao,
x.FamiliaNome,
x.TipoDoCentro,
x.DataLanc
,
x.MaterialBloqueado,
x.MaterialSubstituto,
} into g
select new
{
empresaNome = g.Key.EmpresaNome,
centroLogisticoCodSap = g.Key.CentroLogisticoCodSap,
materialCodSap = g.Key.MaterialCodSap,
materialDescricao = g.Key.MaterialDescricao,
materialClasse = g.Key.MaterialClasse,
materialUM = g.Key.MaterialUM,
classificacaoNome = g.Key.ClassificacaoNome,
userName = g.Key.UserName,
mGCodeCodigoSap = g.Key.MGCodeCodigoSap,
mGCodeDescricao = g.Key.MGCodeDescricao,
familiaNome = g.Key.FamiliaNome,
sapQtde = g.Sum(c => c.SapQtde),
sapValor = g.Sum(c => c.SapValor),
fisicoQtde = g.Sum(c => c.FisicoQtde),
fisicoValor = g.Sum(c => c.FisicoValor),
admQtde = g.Sum(c => c.AdmQtde),
admValor = g.Sum(c => c.AdmValor),
consumoQtde = g.Sum(c => c.ConsumoQtde),
consumoValor = g.Sum(c => c.ConsumoValor),
entradaQtde = g.Sum(c => c.EntradaQtde),
entradaValor = g.Sum(c => c.EntradaValor),
tipoDoCentro = g.Key.TipoDoCentro,
dataLanc = g.Key.DataLanc,
materialBloqueado = g.Key.MaterialBloqueado,
materialSubstituto = g.Key.MaterialSubstituto,
}
).ToList();
return(Ok(EstoqueConsumo));
}
case 2:
{
var EstoqueConsumo = (from x in _listaEstoqueConsumo
group x by new
{
x.EmpresaNome,
x.CentroLogisticoCodSap,
x.MaterialCodSap,
x.MaterialDescricao,
x.MaterialClasse,
x.MaterialUM,
x.ClassificacaoNome,
x.UserName,
x.MGCodeCodigoSap,
x.MGCodeDescricao,
x.FamiliaNome,
x.TipoDoCentro,
x.DataLanc,
x.Lote,
x.MaterialBloqueado,
x.MaterialSubstituto,
} into g
select new
{
empresaNome = g.Key.EmpresaNome,
centroLogisticoCodSap = g.Key.CentroLogisticoCodSap,
lote = g.Key.Lote,
materialCodSap = g.Key.MaterialCodSap,
materialDescricao = g.Key.MaterialDescricao,
materialClasse = g.Key.MaterialClasse,
materialUM = g.Key.MaterialUM,
classificacaoNome = g.Key.ClassificacaoNome,
userName = g.Key.UserName,
mGCodeCodigoSap = g.Key.MGCodeCodigoSap,
mGCodeDescricao = g.Key.MGCodeDescricao,
familiaNome = g.Key.FamiliaNome,
sapQtde = g.Sum(c => c.SapQtde),
sapValor = g.Sum(c => c.SapValor),
fisicoQtde = g.Sum(c => c.FisicoQtde),
fisicoValor = g.Sum(c => c.FisicoValor),
admQtde = g.Sum(c => c.AdmQtde),
admValor = g.Sum(c => c.AdmValor),
consumoQtde = g.Sum(c => c.ConsumoQtde),
consumoValor = g.Sum(c => c.ConsumoValor),
entradaQtde = g.Sum(c => c.EntradaQtde),
entradaValor = g.Sum(c => c.EntradaValor),
tipoDoCentro = g.Key.TipoDoCentro,
dataLanc = g.Key.DataLanc,
materialBloqueado = g.Key.MaterialBloqueado,
materialSubstituto = g.Key.MaterialSubstituto,
}
).ToList();
return(Ok(EstoqueConsumo));
}
case 3:
{
var EstoqueConsumo = ((from x in _listaEstoqueConsumo
group x by new
{
x.DataLanc,
x.TipoDoCentro,
} into g
select new
{
sapValor = g.Sum(c => c.SapValor),
fisicoValor = g.Sum(c => c.FisicoValor),
admValor = g.Sum(c => c.AdmValor),
consumoValor = g.Sum(c => c.ConsumoValor),
entradaQtde = g.Sum(c => c.EntradaQtde),
entradaValor = g.Sum(c => c.EntradaValor),
tipoDoCentro = g.Key.TipoDoCentro,
dataLanc = g.Key.DataLanc,
})
.Union(from x in _listaEstoqueConsumo
group x by new
{
x.DataLanc,
} into g
select new
{
sapValor = g.Sum(c => c.SapValor),
fisicoValor = g.Sum(c => c.FisicoValor),
admValor = g.Sum(c => c.AdmValor),
consumoValor = g.Sum(c => c.ConsumoValor),
entradaQtde = g.Sum(c => c.EntradaQtde),
entradaValor = g.Sum(c => c.EntradaValor),
tipoDoCentro = "Total",
dataLanc = g.Key.DataLanc,
})
).ToList();
return(Ok(EstoqueConsumo));
}
default:
{
var EstoqueConsumo = (from x in _listaEstoqueConsumo
orderby x.MaterialCodSap
group x by new
{
x.EmpresaNome,
x.MaterialCodSap,
x.MaterialDescricao,
x.MaterialClasse,
x.MaterialUM,
x.ClassificacaoNome,
x.UserName,
x.MGCodeCodigoSap,
x.MGCodeDescricao,
x.FamiliaNome,
x.DataLanc,
x.MaterialBloqueado,
x.MaterialSubstituto,
} into g
select new
{
empresaNome = g.Key.EmpresaNome,
materialCodSap = g.Key.MaterialCodSap,
materialDescricao = g.Key.MaterialDescricao,
materialClasse = g.Key.MaterialClasse,
materialUM = g.Key.MaterialUM,
classificacaoNome = g.Key.ClassificacaoNome,
userName = g.Key.UserName,
mGCodeCodigoSap = g.Key.MGCodeCodigoSap,
mGCodeDescricao = g.Key.MGCodeDescricao,
familiaNome = g.Key.FamiliaNome,
sapQtde = g.Sum(c => c.SapQtde),
sapValor = g.Sum(c => c.SapValor),
fisicoQtde = g.Sum(c => c.FisicoQtde),
fisicoValor = g.Sum(c => c.FisicoValor),
admQtde = g.Sum(c => c.AdmQtde),
admValor = g.Sum(c => c.AdmValor),
consumoQtde = g.Sum(c => c.ConsumoQtde),
consumoValor = g.Sum(c => c.ConsumoValor),
entradaQtde = g.Sum(c => c.EntradaQtde),
entradaValor = g.Sum(c => c.EntradaValor),
dataLanc = g.Key.DataLanc,
materialBloqueado = g.Key.MaterialBloqueado,
materialSubstituto = g.Key.MaterialSubstituto,
}
).ToList();
return(Ok(EstoqueConsumo));
}
}
}
catch (Exception msg)
{
return(BadRequest(msg.Message));
}
}
public IHttpActionResult GetListaHistConsumo([FromUri] MaterialCentroDropDownDTO dto,
[FromUri] TipoDeConsultaHistConsumo tipoC)
{
LimpaResultado(dto, tipoC);
var tipoConsulta = (int)tipoC;
try
{
switch (tipoConsulta)
{
case 1:
{
var HistConsumo = (from x in _listaHistConsumo
select new
{
empresaNome = x.EmpresaNome,
centroLogisticoCodSap = x.CentroLogisticoCodSap,
materialCodSap = x.MaterialCodSap,
materialDescricao = x.MaterialDescricao,
materialUM = x.MaterialUM,
materialClasse = x.MaterialClasse,
classificacaoNome = x.ClassificacaoNome,
familiaNome = x.FamiliaNome,
mGCodeCodigoSap = x.MGCodeCodigoSap,
mGCodeDescricao = x.MGCodeDescricao,
userName = x.UserName,
cpm3 = x.Cpm3,
cpm6 = x.Cpm6,
cpm9 = x.Cpm9,
cpm12 = x.Cpm12,
cpm15 = x.Cpm15,
cpm18 = x.Cpm18,
cpm21 = x.Cpm21,
cpm24 = x.Cpm24,
}
).ToList();
return(Ok(HistConsumo));
}
default:
{
var HistConsumo = (from x in _listaHistConsumo
orderby x.MaterialCodSap
select new
{
empresaNome = x.EmpresaNome,
materialCodSap = x.MaterialCodSap,
materialDescricao = x.MaterialDescricao,
materialUM = x.MaterialUM,
materialClasse = x.MaterialClasse,
classificacaoNome = x.ClassificacaoNome,
familiaNome = x.FamiliaNome,
mGCodeCodigoSap = x.MGCodeCodigoSap,
mGCodeDescricao = x.MGCodeDescricao,
userName = x.UserName,
cpm3 = x.Cpm3,
cpm6 = x.Cpm6,
cpm9 = x.Cpm9,
cpm12 = x.Cpm12,
cpm15 = x.Cpm15,
cpm18 = x.Cpm18,
cpm21 = x.Cpm21,
cpm24 = x.Cpm24,
}
).ToList();
return(Ok(HistConsumo));
}
}
}
catch (Exception msg)
{
return(BadRequest(msg.Message));
}
}
