/// <summary>
/// Inserta un AccionTareasPT
/// </summary>
internal int Insert(Models.AccionTareasPT oAccionTareasPT)
{
try
{
SqlParameter[] dbparams = new SqlParameter[2] {
Param(enumDBFields.t332_idtarea, oAccionTareasPT.t332_idtarea),
Param(enumDBFields.t410_idaccion, oAccionTareasPT.t410_idaccion)
};
return((int)cDblib.Execute("SUP_ACCIONTAREAS_PT_I_SNE", dbparams));
}
catch (Exception ex)
{
throw ex;
}
}
///// <summary>
///// Obtiene todos los AccionTareasPT
///// </summary>
//internal List<Models.AccionTareasPT> Catalogo(Models.AccionTareasPT oAccionTareasPTFilter)
//{
// Models.AccionTareasPT oAccionTareasPT = null;
// List<Models.AccionTareasPT> lst = new List<Models.AccionTareasPT>();
// IDataReader dr = null;
// try
// {
// SqlParameter[] dbparams = new SqlParameter[19] {
// Param(enumDBFields.t332_idtarea, oTEMP_AccionTareasPTFilter.t332_idtarea),
// Param(enumDBFields.t332_destarea, oTEMP_AccionTareasPTFilter.t332_destarea),
// Param(enumDBFields.t332_orden, oTEMP_AccionTareasPTFilter.t332_orden),
// Param(enumDBFields.t332_etpl, oTEMP_AccionTareasPTFilter.t332_etpl),
// Param(enumDBFields.t332_fipl, oTEMP_AccionTareasPTFilter.t332_fipl),
// Param(enumDBFields.t332_ffpl, oTEMP_AccionTareasPTFilter.t332_ffpl),
// Param(enumDBFields.t332_etpr, oTEMP_AccionTareasPTFilter.t332_etpr),
// Param(enumDBFields.t332_ffpr, oTEMP_AccionTareasPTFilter.t332_ffpr),
// Param(enumDBFields.Consumo, oTEMP_AccionTareasPTFilter.Consumo),
// Param(enumDBFields.t332_avanceauto, oTEMP_AccionTareasPTFilter.t332_avanceauto),
// Param(enumDBFields.t332_avance, oTEMP_AccionTareasPTFilter.t332_avance),
// Param(enumDBFields.Estado, oTEMP_AccionTareasPTFilter.Estado),
// Param(enumDBFields.t331_idpt, oTEMP_AccionTareasPTFilter.t331_idpt),
// Param(enumDBFields.t331_despt, oTEMP_AccionTareasPTFilter.t331_despt),
// Param(enumDBFields.t301_denominacion, oTEMP_AccionTareasPTFilter.t301_denominacion),
// Param(enumDBFields.t334_idfase, oTEMP_AccionTareasPTFilter.t334_idfase),
// Param(enumDBFields.t334_desfase, oTEMP_AccionTareasPTFilter.t334_desfase),
// Param(enumDBFields.t335_idactividad, oTEMP_AccionTareasPTFilter.t335_idactividad),
// Param(enumDBFields.t335_desactividad, oTEMP_AccionTareasPTFilter.t335_desactividad)
// };
// dr = cDblib.DataReader("SUPER.IAP30_AccionTareasPT_CAT", dbparams);
// while (dr.Read())
// {
// oAccionTareasPT = new Models.AccionTareasPT();
// oAccionTareasPT.t332_idtarea=Convert.ToInt32(dr["t332_idtarea"]);
// oAccionTareasPT.t332_destarea=Convert.ToString(dr["t332_destarea"]);
// oAccionTareasPT.t332_orden=Convert.ToInt32(dr["t332_orden"]);
// oAccionTareasPT.t332_etpl=Convert.ToDouble(dr["t332_etpl"]);
// if(!Convert.IsDBNull(dr["t332_fipl"]))
// oAccionTareasPT.t332_fipl=Convert.ToString(dr["t332_fipl"]);
// if(!Convert.IsDBNull(dr["t332_ffpl"]))
// oAccionTareasPT.t332_ffpl=Convert.ToString(dr["t332_ffpl"]);
// oAccionTareasPT.t332_etpr=Convert.ToDouble(dr["t332_etpr"]);
// if(!Convert.IsDBNull(dr["t332_ffpr"]))
// oAccionTareasPT.t332_ffpr=Convert.ToString(dr["t332_ffpr"]);
// oAccionTareasPT.Consumo=Convert.ToDouble(dr["Consumo"]);
// oAccionTareasPT.t332_avanceauto=Convert.ToBoolean(dr["t332_avanceauto"]);
// if(!Convert.IsDBNull(dr["t332_avance"]))
// oAccionTareasPT.t332_avance=Convert.ToDouble(dr["t332_avance"]);
// if(!Convert.IsDBNull(dr["Estado"]))
// oAccionTareasPT.Estado=Convert.ToString(dr["Estado"]);
// oAccionTareasPT.t331_idpt=Convert.ToInt32(dr["t331_idpt"]);
// oAccionTareasPT.t331_despt=Convert.ToString(dr["t331_despt"]);
// oAccionTareasPT.t301_denominacion=Convert.ToString(dr["t301_denominacion"]);
// oAccionTareasPT.t334_idfase=Convert.ToInt32(dr["t334_idfase"]);
// oAccionTareasPT.t334_desfase=Convert.ToString(dr["t334_desfase"]);
// oAccionTareasPT.t335_idactividad=Convert.ToInt32(dr["t335_idactividad"]);
// oAccionTareasPT.t335_desactividad=Convert.ToString(dr["t335_desactividad"]);
// lst.Add(oAccionTareasPT);
// }
// return lst;
// }
// catch (Exception ex)
// {
// throw ex;
// }
// finally
// {
// if (dr != null)
// {
// if (!dr.IsClosed) dr.Close();
// dr.Dispose();
// }
// }
//}
/// <summary>
/// Obtiene todos los AccionTareas
/// </summary>
internal List <Models.AccionTareasPT> Catalogo(Int32 t410_idaccion)
{
Models.AccionTareasPT oAccionTareas = null;
List <Models.AccionTareasPT> lst = new List <Models.AccionTareasPT>();
IDataReader dr = null;
try
{
SqlParameter[] dbparams = new SqlParameter[1] {
Param(enumDBFields.t410_idaccion, t410_idaccion)
};
dr = cDblib.DataReader("SUP_ACCIONTAREAS_PT_SByT410_idaccion", dbparams);
while (dr.Read())
{
oAccionTareas = new Models.AccionTareasPT();
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.t301_denominacion = Convert.ToString(dr["t301_denominacion"]);
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();
}
}
}
