public List <ReporteEppBE> ListadoConsumoResumen(DateTime FechaDesde, DateTime FechaHasta) { Database db = DatabaseFactory.CreateDatabase("cnSSOMABD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_rptEppConsumoResumen"); db.AddInParameter(dbCommand, "pFechaDesde", DbType.DateTime, FechaDesde); db.AddInParameter(dbCommand, "pFechaHasta", DbType.DateTime, FechaHasta); IDataReader reader = db.ExecuteReader(dbCommand); List <ReporteEppBE> ReporteEpplist = new List <ReporteEppBE>(); ReporteEppBE ReporteEpp; while (reader.Read()) { ReporteEpp = new ReporteEppBE(); ReporteEpp.DescNegocio = reader["DescNegocio"].ToString(); ReporteEpp.EmpresaResponsable = reader["EmpresaResponsable"].ToString(); ReporteEpp.Logo = (byte[])reader["Logo"]; ReporteEpp.AreaResponsable = reader["AreaResponsable"].ToString(); ReporteEpp.Total = Decimal.Parse(reader["Total"].ToString()); ReporteEpplist.Add(ReporteEpp); } reader.Close(); reader.Dispose(); return(ReporteEpplist); }
public List <ReporteEppBE> ListadoConsumoMensualSectorResponsable(int Periodo, int IdEmpresaResponsable, int IdUnidadMineraResponsable, int IdAreaResponsable) { Database db = DatabaseFactory.CreateDatabase("cnSSOMABD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_rptEppConsumoMensualSectorResponsable"); db.AddInParameter(dbCommand, "pPeriodo", DbType.Int32, Periodo); db.AddInParameter(dbCommand, "pIdEmpresaResponsable", DbType.Int32, IdEmpresaResponsable); db.AddInParameter(dbCommand, "pIdUnidadMineraResponsable", DbType.Int32, IdUnidadMineraResponsable); db.AddInParameter(dbCommand, "pIdAreaResponsable", DbType.Int32, IdAreaResponsable); IDataReader reader = db.ExecuteReader(dbCommand); List <ReporteEppBE> ReporteEpplist = new List <ReporteEppBE>(); ReporteEppBE ReporteEpp; while (reader.Read()) { ReporteEpp = new ReporteEppBE(); ReporteEpp.Periodo = reader["Periodo"].ToString(); ReporteEpp.Mes = reader["Mes"].ToString(); ReporteEpp.EmpresaResponsable = reader["EmpresaResponsable"].ToString(); ReporteEpp.Logo = (byte[])reader["Logo"]; ReporteEpp.UnidadMineraResponsable = reader["UnidadMineraResponsable"].ToString(); ReporteEpp.AreaResponsable = reader["AreaResponsable"].ToString(); ReporteEpp.SectorResponsable = reader["SectorResponsable"].ToString(); ReporteEpp.Total = Decimal.Parse(reader["Total"].ToString()); ReporteEpplist.Add(ReporteEpp); } reader.Close(); reader.Dispose(); return(ReporteEpplist); }
public List <ReporteEppBE> ListadoRegistroEntrega(int IdEmpresaResponsable, int IdUnidadMineraResponsable, DateTime FechaDesde, DateTime FechaHasta) { Database db = DatabaseFactory.CreateDatabase("cnSSOMABD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_rptEppRegistroEntrega"); db.AddInParameter(dbCommand, "pIdEmpresaResponsable", DbType.Int32, IdEmpresaResponsable); db.AddInParameter(dbCommand, "pIdUnidadMineraResponsable", DbType.Int32, IdUnidadMineraResponsable); db.AddInParameter(dbCommand, "pFechaDesde", DbType.DateTime, FechaDesde); db.AddInParameter(dbCommand, "pFechaHasta", DbType.DateTime, FechaHasta); IDataReader reader = db.ExecuteReader(dbCommand); List <ReporteEppBE> ReporteEpplist = new List <ReporteEppBE>(); ReporteEppBE ReporteEpp; while (reader.Read()) { ReporteEpp = new ReporteEppBE(); ReporteEpp.NumeroSolicitud = reader["NumeroSolicitud"].ToString(); ReporteEpp.Numero = reader["Numero"].ToString(); ReporteEpp.Responsable = reader["Responsable"].ToString(); ReporteEpp.EmpresaResponsable = reader["EmpresaResponsable"].ToString(); ReporteEpp.Logo = (byte[])reader["Logo"]; ReporteEpp.UnidadMineraResponsable = reader["UnidadMineraResponsable"].ToString(); ReporteEpp.AreaResponsable = reader["AreaResponsable"].ToString(); ReporteEpp.Cargo = reader["Cargo"].ToString(); ReporteEpp.Fecha = reader["Fecha"].ToString().Substring(0, 10); ReporteEpp.Cantidad = Int32.Parse(reader["Cantidad"].ToString()); ReporteEpp.Total = Decimal.Parse(reader["Total"].ToString()); ReporteEpplist.Add(ReporteEpp); } reader.Close(); reader.Dispose(); return(ReporteEpplist); }
public List <ReporteEppBE> ListadoPorPersona(int IdEmpresaResponsable, int IdUnidadMineraResponsable, int IdAreaResponsable, int IdPersona, DateTime FechaDesde, DateTime FechaHasta) { Database db = DatabaseFactory.CreateDatabase("cnSSOMABD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_rptEppPersona"); db.AddInParameter(dbCommand, "pIdEmpresaResponsable", DbType.Int32, IdEmpresaResponsable); db.AddInParameter(dbCommand, "pIdUnidadMineraResponsable", DbType.Int32, IdUnidadMineraResponsable); db.AddInParameter(dbCommand, "pIdAreaResponsable", DbType.Int32, IdAreaResponsable); db.AddInParameter(dbCommand, "pIdPersonaResponsable", DbType.Int32, IdPersona); db.AddInParameter(dbCommand, "pFechaDesde", DbType.DateTime, FechaDesde); db.AddInParameter(dbCommand, "pFechaHasta", DbType.DateTime, FechaHasta); IDataReader reader = db.ExecuteReader(dbCommand); List <ReporteEppBE> ReporteEpplist = new List <ReporteEppBE>(); ReporteEppBE ReporteEpp; while (reader.Read()) { ReporteEpp = new ReporteEppBE(); ReporteEpp.RazonSocial = reader["RazonSocial"].ToString(); ReporteEpp.Logo = (byte[])reader["Logo"]; ReporteEpp.DescUnidadMinera = reader["DescUnidadMinera"].ToString(); ReporteEpp.DescArea = reader["DescArea"].ToString(); ReporteEpp.NumeroSolicitud = reader["NumeroSolicitud"].ToString(); ReporteEpp.Numero = reader["Numero"].ToString(); ReporteEpp.Responsable = reader["Responsable"].ToString(); ReporteEpp.EmpresaResponsable = reader["EmpresaResponsable"].ToString(); ReporteEpp.UnidadMineraResponsable = reader["UnidadMineraResponsable"].ToString(); ReporteEpp.AreaResponsable = reader["AreaResponsable"].ToString(); ReporteEpp.Cargo = reader["Cargo"].ToString(); ReporteEpp.Fecha = reader["Fecha"].ToString().Substring(0, 10); ReporteEpp.Observacion = reader["Observacion"].ToString(); ReporteEpp.Item = Int32.Parse(reader["Item"].ToString()); ReporteEpp.Codigo = reader["Codigo"].ToString(); ReporteEpp.DescEquipo = reader["DescEquipo"].ToString(); ReporteEpp.FechaVencimiento = reader["FechaVencimiento"].ToString().Substring(0, 10); ReporteEpp.Cantidad = Int32.Parse(reader["Cantidad"].ToString()); ReporteEpp.Precio = Decimal.Parse(reader["Precio"].ToString()); ReporteEpp.Total = Decimal.Parse(reader["Total"].ToString()); ReporteEpp.DescTipoEntrega = reader["DescTipoEntrega"].ToString(); ReporteEpplist.Add(ReporteEpp); } reader.Close(); reader.Dispose(); return(ReporteEpplist); }
public List <ReporteEppBE> ListadoConsumoMensualEmpresaResponsable(int Periodo) { try { List <EmpresaBE> lstEmpresa; List <ReporteEppBE> lstConsumoMensualEmpresa; lstEmpresa = new EmpresaDL().ListaCombo(Parametros.intTECorporativo); lstConsumoMensualEmpresa = new ReporteEppDL().ListadoConsumoMensualEmpresaResponsable(Periodo); List <string> lstMes = new List <string>(); foreach (var item in lstConsumoMensualEmpresa) { var Buscar = lstMes.Where(x => x.Contains(item.Mes)).ToList(); if (Buscar.Count == 0) { lstMes.Add(item.Mes); } } foreach (string strMes in lstMes) { foreach (var ItemEmpresa in lstEmpresa) { var Buscar = lstConsumoMensualEmpresa.Where(oB => oB.Mes == strMes && oB.EmpresaResponsable == ItemEmpresa.RazonSocial).ToList(); if (Buscar.Count == 0) { ReporteEppBE objE_ReporteEpp = new ReporteEppBE(); objE_ReporteEpp.Periodo = Periodo.ToString(); objE_ReporteEpp.Mes = strMes; objE_ReporteEpp.EmpresaResponsable = ItemEmpresa.RazonSocial; objE_ReporteEpp.Total = 0; lstConsumoMensualEmpresa.Add(objE_ReporteEpp); } } } return(lstConsumoMensualEmpresa); } catch (Exception ex) { throw ex; } }
public List <ReporteEppBE> ListadoConsumoAnualEmpresaResponsable() { Database db = DatabaseFactory.CreateDatabase("cnSSOMABD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_rptEppConsumoAnualEmpresaResponsable"); IDataReader reader = db.ExecuteReader(dbCommand); List <ReporteEppBE> ReporteEpplist = new List <ReporteEppBE>(); ReporteEppBE ReporteEpp; while (reader.Read()) { ReporteEpp = new ReporteEppBE(); ReporteEpp.Periodo = reader["Periodo"].ToString(); ReporteEpp.EmpresaResponsable = reader["EmpresaResponsable"].ToString(); ReporteEpp.Logo = (byte[])reader["Logo"]; ReporteEpp.Total = Decimal.Parse(reader["Total"].ToString()); ReporteEpplist.Add(ReporteEpp); } reader.Close(); reader.Dispose(); return(ReporteEpplist); }