internal List <Models.DesgloseCalendario> ObtenerHorasRango(int nIdCal, DateTime dDesde, DateTime dHasta) { Models.DesgloseCalendario oDesgloseCalendario = null; List <Models.DesgloseCalendario> lst = new List <Models.DesgloseCalendario>(); SqlDataReader dr = null; try { SqlParameter[] dbparams = new SqlParameter[4] { Param(enumDBFields.nIdCal, nIdCal), Param(enumDBFields.nAnno, null), Param(enumDBFields.dDesde, dDesde), Param(enumDBFields.dHasta, dHasta) }; dr = cDblib.DataReader("SUP_DESGLOSECALS", dbparams); while (dr.Read()) { oDesgloseCalendario = new Models.DesgloseCalendario(); oDesgloseCalendario.t066_idcal = Convert.ToInt32(dr["t066_idcal"]); oDesgloseCalendario.t067_dia = Convert.ToDateTime(dr["t067_dia"]); oDesgloseCalendario.t067_horas = Convert.ToSingle(dr["t067_horas"]); oDesgloseCalendario.t067_festivo = Convert.ToInt32(dr["t067_festivo"]); lst.Add(oDesgloseCalendario); } return(lst); } catch (Exception ex) { throw ex; } finally { if (dr != null) { if (!dr.IsClosed) { dr.Close(); } dr.Dispose(); } } }
///// <summary> ///// Obtiene todos los DesgloseCalendario ///// </summary>; internal List <Models.DesgloseCalendario> ObtenerHoras(int nIdCal, int nAnno) { Models.DesgloseCalendario oDesgloseCalendario = null; List <Models.DesgloseCalendario> lst = new List <Models.DesgloseCalendario>(); SqlDataReader dr = null; try { SqlParameter[] dbparams = new SqlParameter[2] { Param(enumDBFields.t066_idcal, nIdCal), Param(enumDBFields.nAnno, nAnno) }; dr = cDblib.DataReader("SUP_DESGLOSECALENDARIO_IAP30", dbparams); if (dr.HasRows) { while (dr.Read()) { oDesgloseCalendario = new Models.DesgloseCalendario(); oDesgloseCalendario.t066_idcal = Convert.ToInt32(dr["t066_idcal"]); oDesgloseCalendario.t067_dia = Convert.ToDateTime(dr["t067_dia"]); oDesgloseCalendario.t067_horas = Convert.ToSingle(dr["t067_horas"]); oDesgloseCalendario.t067_horasD = Math.Round(Convert.ToDouble(dr["t067_horas"]), 2); oDesgloseCalendario.t067_festivo = Convert.ToInt32(dr["t067_festivo"]); lst.Add(oDesgloseCalendario); } } else { /*DateTime objDate = new DateTime(nAnno, 1, 1); * while (objDate.Year == nAnno) * { * oDesgloseCalendario = new Models.DesgloseCalendario(); * oDesgloseCalendario.t066_idcal = nIdCal; * oDesgloseCalendario.t067_dia = objDate; * oDesgloseCalendario.t067_horas = 0; * oDesgloseCalendario.t067_festivo = 0; * * lst.Add(oDesgloseCalendario); * objDate = objDate.AddDays(1); * }*/ return(null); } return(lst); } catch (Exception ex) { throw ex; } finally { if (dr != null) { if (!dr.IsClosed) { dr.Close(); } dr.Dispose(); } } }