public bool Eliminar(BE_PRO_RECETA entReceta)
{
bool booResult = false;
CD_pro_receta miFun = new CD_pro_receta();
miFun.mysConec = mysConec;
booResult = miFun.Eliminar(entReceta.n_id);
if (booResult == false)
{
booOcurrioError = false;
StrErrorMensaje = miFun.StrErrorMensaje;
IntErrorNumber = miFun.IntErrorNumber;
}
return(booResult);
}
public void TraerRecetaProducto(Int64 n_IdProducto)
{
BE_PRO_RECETA EntCabecera = new BE_PRO_RECETA();
bool booResult;
DataTable DtRecIns = new DataTable();
DataTable DtRecTar = new DataTable();
DataTable DtRec = new DataTable();
CD_pro_receta miFun = new CD_pro_receta();
int n_row = 0;
miFun.mysConec = mysConec;
booResult = miFun.TraerRecetaProducto(n_IdProducto);
DtRec = miFun.dtRecCab;
DtRecIns = miFun.dtRecIns;
DtRecTar = miFun.dtRecTar;
lstReceta.Clear();
lstRecetaInsumo.Clear();
lstRecetaTarea.Clear();
if (DtRec.Rows.Count != 0)
{
// CARGAMOS LAS RECETAS
for (n_row = 0; n_row <= DtRec.Rows.Count - 1; n_row++)
{
BE_PRO_RECETA entReceta = new BE_PRO_RECETA();
entReceta.n_idemp = Convert.ToInt16(DtRec.Rows[n_row]["n_idemp"].ToString());
entReceta.n_id = Convert.ToInt16(DtRec.Rows[n_row]["n_id"].ToString());
entReceta.c_codrec = DtRec.Rows[n_row]["c_codrec"].ToString();
entReceta.n_idite = Convert.ToInt16(DtRec.Rows[n_row]["n_idite"].ToString());
entReceta.c_des = DtRec.Rows[n_row]["c_des"].ToString();
entReceta.n_idunimed = Convert.ToInt16(DtRec.Rows[n_row]["n_idunimed"].ToString());
entReceta.n_can = Convert.ToDouble(DtRec.Rows[n_row]["n_can"].ToString());
entReceta.n_prirec = Convert.ToInt16(DtRec.Rows[n_row]["n_prirec"].ToString());
entReceta.c_obs = DtRec.Rows[n_row]["c_obs"].ToString();
entReceta.n_act = Convert.ToInt16(DtRec.Rows[n_row]["n_act"].ToString());
lstReceta.Add(entReceta);
}
}
if (DtRecIns.Rows.Count != 0)
{
// CARGAMOS LOS INSUMOS
lstRecetaInsumo.Clear();
for (n_row = 0; n_row <= DtRecIns.Rows.Count - 1; n_row++)
{
BE_PRO_RECETAINSUMO entRecetaInsumo = new BE_PRO_RECETAINSUMO();
entRecetaInsumo.n_idrec = Convert.ToInt16(DtRecIns.Rows[n_row]["n_idrec"].ToString());
entRecetaInsumo.n_idite = Convert.ToInt16(DtRecIns.Rows[n_row]["n_idite"].ToString());
entRecetaInsumo.n_idunimed = Convert.ToInt16(DtRecIns.Rows[n_row]["n_idunimed"].ToString());
entRecetaInsumo.n_can = Convert.ToDouble(DtRecIns.Rows[n_row]["n_can"].ToString());
lstRecetaInsumo.Add(entRecetaInsumo);
}
}
if (DtRecTar.Rows.Count != 0)
{
// CARGAMOS LAS TAREAS
n_row = 0;
lstRecetaTarea.Clear();
for (n_row = 0; n_row <= DtRecTar.Rows.Count - 1; n_row++)
{
BE_PRO_RECETATAREA entRecetaTarea = new BE_PRO_RECETATAREA();
entRecetaTarea.n_idrec = Convert.ToInt16(DtRecTar.Rows[n_row]["n_idrec"].ToString());
entRecetaTarea.n_idtar = Convert.ToInt16(DtRecTar.Rows[n_row]["n_idtar"].ToString());
entRecetaTarea.n_idunimed = Convert.ToInt16(DtRecTar.Rows[n_row]["n_idunimed"].ToString());
entRecetaTarea.n_can = Convert.ToInt16(DtRecTar.Rows[n_row]["n_can"].ToString());
entRecetaTarea.n_ord = Convert.ToInt16(DtRecTar.Rows[n_row]["n_ord"].ToString());
entRecetaTarea.n_factor = Convert.ToDouble(DtRecTar.Rows[n_row]["n_factor"].ToString());
entRecetaTarea.n_cosklg = Convert.ToDouble(DtRecTar.Rows[n_row]["n_cosklg"].ToString());
entRecetaTarea.n_coshor = Convert.ToDouble(DtRecTar.Rows[n_row]["n_coshor"].ToString());
entRecetaTarea.n_jorklg = Convert.ToDouble(DtRecTar.Rows[n_row]["n_jorklg"].ToString());
entRecetaTarea.c_despro = DtRecTar.Rows[n_row]["c_despro"].ToString();
entRecetaTarea.n_numper = Convert.ToInt16(DtRecTar.Rows[n_row]["n_numper"].ToString());
entRecetaTarea.h_horarr = DtRecTar.Rows[n_row]["h_horarr"].ToString();
entRecetaTarea.n_aplpor = Convert.ToInt16(DtRecTar.Rows[n_row]["n_aplpor"].ToString());
entRecetaTarea.n_idare = Convert.ToInt16(DtRecTar.Rows[n_row]["n_idare"].ToString());
entRecetaTarea.n_idtiptra = Convert.ToInt16(DtRecTar.Rows[n_row]["n_idtiptra"].ToString());
entRecetaTarea.n_idforpag = Convert.ToInt16(DtRecTar.Rows[n_row]["n_idforpag"].ToString());
lstRecetaTarea.Add(entRecetaTarea);
}
}
return;
}
