/// <summary> /// Inserta un AccionTareas /// </summary> internal int Insert(Models.AccionTareas oAccionTareas) { try { SqlParameter[] dbparams = new SqlParameter[2] { Param(enumDBFields.t332_idtarea, oAccionTareas.t332_idtarea), Param(enumDBFields.t383_idaccion, oAccionTareas.t383_idaccion) }; return((int)cDblib.Execute("SUP_ACCIONTAREAS_I_SNE", dbparams)); } catch (Exception ex) { throw ex; } }
/// <summary> /// Obtiene todos los AccionTareas /// </summary> internal List <Models.AccionTareas> Catalogo(Int32 t383_idaccion) { Models.AccionTareas oAccionTareas = null; List <Models.AccionTareas> lst = new List <Models.AccionTareas>(); IDataReader dr = null; try { SqlParameter[] dbparams = new SqlParameter[1] { Param(enumDBFields.t383_idaccion, t383_idaccion) }; dr = cDblib.DataReader("SUP_ACCIONTAREAS_SByT383_idaccion", dbparams); while (dr.Read()) { oAccionTareas = new Models.AccionTareas(); oAccionTareas.t332_idtarea = Convert.ToInt32(dr["t332_idtarea"]); oAccionTareas.t332_destarea = Convert.ToString(dr["t332_destarea"]); oAccionTareas.t332_orden = Convert.ToInt32(dr["t332_orden"]); oAccionTareas.t332_etpl = Convert.ToDouble(dr["t332_etpl"]); if (!Convert.IsDBNull(dr["t332_fipl"])) { oAccionTareas.t332_fipl = Convert.ToDateTime(dr["t332_fipl"]); } if (!Convert.IsDBNull(dr["t332_ffpl"])) { oAccionTareas.t332_ffpl = Convert.ToDateTime(dr["t332_ffpl"]); } oAccionTareas.t332_etpr = Convert.ToDouble(dr["t332_etpr"]); if (!Convert.IsDBNull(dr["t332_ffpr"])) { oAccionTareas.t332_ffpr = Convert.ToDateTime(dr["t332_ffpr"]); } oAccionTareas.Consumo = Convert.ToDouble(dr["Consumo"]); oAccionTareas.t332_avanceauto = Convert.ToBoolean(dr["t332_avanceauto"]); if (!Convert.IsDBNull(dr["t332_avance"])) { oAccionTareas.t332_avance = Convert.ToDouble(dr["t332_avance"]); } if (!Convert.IsDBNull(dr["Estado"])) { oAccionTareas.Estado = Convert.ToString(dr["Estado"]); } oAccionTareas.num_proyecto = Convert.ToInt32(dr["num_proyecto"]); oAccionTareas.nom_proyecto = Convert.ToString(dr["nom_proyecto"]); oAccionTareas.t331_idpt = Convert.ToInt32(dr["t331_idpt"]); oAccionTareas.t331_despt = Convert.ToString(dr["t331_despt"]); oAccionTareas.t334_idfase = Convert.ToInt32(dr["t334_idfase"]); oAccionTareas.t334_desfase = Convert.ToString(dr["t334_desfase"]); oAccionTareas.t335_idactividad = Convert.ToInt32(dr["t335_idactividad"]); oAccionTareas.t335_desactividad = Convert.ToString(dr["t335_desactividad"]); lst.Add(oAccionTareas); } return(lst); } catch (Exception ex) { throw ex; } finally { if (dr != null) { if (!dr.IsClosed) { dr.Close(); } dr.Dispose(); } } }