public bool Actualizar(BE_LOG_ORDENCOMPRA e_OrdenCompra, List <BE_LOG_ORDENCOMPRADET> l_OrdenCompraDetalles)
{
CD_log_ordencompra miFun = new CD_log_ordencompra();
bool booOk = false;
miFun.mysConec = mysConec;
booOk = miFun.Actualizar(e_OrdenCompra, l_OrdenCompraDetalles);
b_OcurrioError = miFun.b_OcurrioError;
c_ErrorMensaje = miFun.c_ErrorMensaje;
n_ErrorNumber = miFun.n_ErrorNumber;
return(booOk);
}
public bool Actualizar(BE_LOG_ORDENCOMPRA e_OrdenCompra, List <BE_LOG_ORDENCOMPRADET> l_OrdenCompraDetalle)
{
bool booOk = false;
int intFila = 0;
DatosMySql xMiFuncion = new DatosMySql();
MySqlTransaction trans;
xMiFuncion.ReAbrirConeccion(mysConec);
trans = mysConec.BeginTransaction();
try
{
if (xMiFuncion.StoreEjecutar("log_ordencompra_actualizar", e_OrdenCompra, mysConec, null) == true)
{
string[,] arrParametros = new string[1, 3] {
{ "n_idoc", "System.INT64", e_OrdenCompra.n_id.ToString() }
};
// BORRAMOS EL DETALLE
if (xMiFuncion.StoreEjecutar("log_ordencompradet_delete", arrParametros, mysConec) == true)
{
// SI LOS ITEMS SE ELIMINARON CON EXITO INSERTAMOS LOS NUEVOS ITEMS
for (intFila = 0; intFila <= l_OrdenCompraDetalle.Count - 1; intFila++)
{
l_OrdenCompraDetalle[intFila].n_idoc = Convert.ToInt32(e_OrdenCompra.n_id);
if (xMiFuncion.StoreEjecutar("log_ordencompradet_insertar", l_OrdenCompraDetalle[intFila], mysConec, null) == true)
{
booOk = true;
}
else
{
// CONTROLAR EL ERROR
b_OcurrioError = xMiFuncion.booOcurrioError;
c_ErrorMensaje = xMiFuncion.StrErrorMensaje;
n_ErrorNumber = xMiFuncion.IntErrorNumber;
trans.Rollback();
booOk = false;
return(booOk);
}
}
}
else
{
// CONTROLAR EL ERROR
b_OcurrioError = xMiFuncion.booOcurrioError;
c_ErrorMensaje = xMiFuncion.StrErrorMensaje;
n_ErrorNumber = xMiFuncion.IntErrorNumber;
trans.Rollback();
booOk = false;
return(booOk);
}
}
else
{
b_OcurrioError = xMiFuncion.booOcurrioError;
c_ErrorMensaje = xMiFuncion.StrErrorMensaje;
n_ErrorNumber = xMiFuncion.IntErrorNumber;
trans.Rollback();
booOk = false;
return(booOk);
}
trans.Commit();
return(booOk);
}
catch (Exception exc)
{
// SI SUCEDE UN ERROR DEVOLVEMOS FALSO
b_OcurrioError = xMiFuncion.booOcurrioError;
c_ErrorMensaje = xMiFuncion.StrErrorMensaje;
n_ErrorNumber = xMiFuncion.IntErrorNumber;
trans.Rollback();
return(booOk);
}
}
public bool Insertar(BE_LOG_ORDENCOMPRA e_OrdenCompra, List <BE_LOG_ORDENCOMPRADET> l_OrdenCompraDetalle)
{
bool booOk = false;
int intFila = 0;
DatosMySql xMiFuncion = new DatosMySql();
MySqlTransaction trans;
xMiFuncion.ReAbrirConeccion(mysConec);
trans = mysConec.BeginTransaction();
try
{
if (xMiFuncion.StoreEjecutar("log_ordencompra_insertar", e_OrdenCompra, mysConec, 1) == true)
{
for (intFila = 0; intFila <= l_OrdenCompraDetalle.Count - 1; intFila++)
{
e_OrdenCompra.n_id = Convert.ToInt32(xMiFuncion.intIdGenerado);
l_OrdenCompraDetalle[intFila].n_idoc = Convert.ToInt32(xMiFuncion.intIdGenerado);
if (xMiFuncion.StoreEjecutar("log_ordencompradet_insertar", l_OrdenCompraDetalle[intFila], mysConec, null) == true)
{
booOk = true;
}
else
{
// CONTROLAR EL ERROR
b_OcurrioError = xMiFuncion.booOcurrioError;
c_ErrorMensaje = xMiFuncion.StrErrorMensaje;
n_ErrorNumber = xMiFuncion.IntErrorNumber;
trans.Rollback();
booOk = false;
return(booOk);
}
}
}
else
{
b_OcurrioError = xMiFuncion.booOcurrioError;
c_ErrorMensaje = xMiFuncion.StrErrorMensaje;
n_ErrorNumber = xMiFuncion.IntErrorNumber;
trans.Rollback();
booOk = false;
return(booOk);
}
if (booOk == true)
{
trans.Commit();
}
else
{
trans.Rollback();
}
return(booOk);
}
catch (Exception exc)
{
// SI SUCEDE UN ERROR DEVOLVEMOS FALSO
b_OcurrioError = xMiFuncion.booOcurrioError;
c_ErrorMensaje = xMiFuncion.StrErrorMensaje;
n_ErrorNumber = xMiFuncion.IntErrorNumber;
//trans.Rollback();
return(booOk);
}
}
public bool TraerRegistro(int n_IdRegistro)
{
bool booresult = false;
DataTable dtCab = new DataTable();
DataTable dtDet = new DataTable();
BE_LOG_ORDENCOMPRA e_reque = new BE_LOG_ORDENCOMPRA();
CD_log_ordencompra miFun = new CD_log_ordencompra();
miFun.mysConec = mysConec;
l_OCDet.Clear();
if (miFun.TraerRegistro(n_IdRegistro) == true)
{
dtCab = miFun.dtCabecera;
dtDet = miFun.dtDetalle;
e_OC.n_idemp = Convert.ToInt32(dtCab.Rows[0]["n_idemp"]);
e_OC.n_id = Convert.ToInt32(dtCab.Rows[0]["n_id"]);
e_OC.n_idtipdoc = Convert.ToInt32(dtCab.Rows[0]["n_idtipdoc"]);
e_OC.c_numser = dtCab.Rows[0]["c_numser"].ToString();
e_OC.c_numdoc = dtCab.Rows[0]["c_numdoc"].ToString();
e_OC.n_anotra = Convert.ToInt32(dtCab.Rows[0]["n_anotra"]);
e_OC.n_mestra = Convert.ToInt32(dtCab.Rows[0]["n_mestra"]);
e_OC.d_fchemi = Convert.ToDateTime(dtCab.Rows[0]["d_fchemi"]);
e_OC.d_fchent = Convert.ToDateTime(dtCab.Rows[0]["d_fchent"]);
e_OC.n_idloc = Convert.ToInt32(dtCab.Rows[0]["n_idloc"]);
e_OC.n_idare = Convert.ToInt32(dtCab.Rows[0]["n_idare"]);
e_OC.n_idpersol = Convert.ToInt32(dtCab.Rows[0]["n_idpersol"]);
e_OC.n_idpri = Convert.ToInt32(dtCab.Rows[0]["n_idpri"]);
e_OC.c_obs = dtCab.Rows[0]["c_obs"].ToString();
e_OC.n_idest = Convert.ToInt32(dtCab.Rows[0]["n_idest"]);
e_OC.n_idmot = Convert.ToInt32(dtCab.Rows[0]["n_idmot"]);
e_OC.n_idpro = Convert.ToInt32(dtCab.Rows[0]["n_idpro"]);
e_OC.n_idmon = Convert.ToInt32(dtCab.Rows[0]["n_idmon"]);
e_OC.n_impbru = Convert.ToDouble(dtCab.Rows[0]["n_impbru"]);
e_OC.n_impigv = Convert.ToDouble(dtCab.Rows[0]["n_impigv"]);
e_OC.n_imptot = Convert.ToDouble(dtCab.Rows[0]["n_imptot"]);
e_OC.n_idconpag = Convert.ToInt32(dtCab.Rows[0]["n_idconpag"]);
e_OC.n_impina = Convert.ToDouble(dtCab.Rows[0]["n_impina"]);
if (!string.IsNullOrEmpty(dtCab.Rows[0]["n_docrefidtipdoc"].ToString()))
{
e_OC.n_docrefidtipdoc = Convert.ToInt32(dtCab.Rows[0]["n_docrefidtipdoc"]);
}
if (!string.IsNullOrEmpty(dtCab.Rows[0]["n_docrefiddocref"].ToString()))
{
e_OC.n_docrefiddocref = Convert.ToInt32(dtCab.Rows[0]["n_docrefiddocref"]);
}
e_OC.c_docrefnumser = dtCab.Rows[0]["c_docrefnumser"].ToString();
e_OC.c_docrefnumdoc = dtCab.Rows[0]["c_docrefnumdoc"].ToString();
int n_row = 0;
for (n_row = 0; n_row <= dtDet.Rows.Count - 1; n_row++)
{
BE_LOG_ORDENCOMPRADET e_ocdet = new BE_LOG_ORDENCOMPRADET();
e_ocdet.n_idoc = Convert.ToInt32(dtDet.Rows[n_row]["n_idoc"]);
e_ocdet.n_idite = Convert.ToInt32(dtDet.Rows[n_row]["n_idite"]);
e_ocdet.n_idunimed = Convert.ToInt32(dtDet.Rows[n_row]["n_idunimed"]);
e_ocdet.n_can = Convert.ToDouble(dtDet.Rows[n_row]["n_can"]);
e_ocdet.n_preuni = Convert.ToDouble(dtDet.Rows[n_row]["n_preuni"]);
e_ocdet.n_imptot = Convert.ToDouble(dtDet.Rows[n_row]["n_imptot"]);
e_ocdet.n_idtipafeigv = Convert.ToInt32(dtDet.Rows[n_row]["n_idtipafeigv"]);
if (string.IsNullOrEmpty(dtDet.Rows[n_row]["n_canat"].ToString()))
{
e_ocdet.n_canat = 0;
}
else
{
e_ocdet.n_canat = Convert.ToDouble(dtDet.Rows[n_row]["n_canat"]);
}
l_OCDet.Add(e_ocdet);
}
booresult = true;
}
return(booresult);
}
