/// <summary> /// REALIZAR OPERACIONES DE MANTENIMIENTO /// </summary> /// <param name="oBe"></param> public void Set_SVPR_OVEN(BESVTC_OVEN oBe) { try { oDa.Set_SVPR_OVEN(oBe); Dispose(false); } catch (Exception ex) { throw new ArgumentException(ex.Message); } }
/// <summary> /// OBTENER EL RESULTADO DE CUALQUIER CONSULTA /// </summary> /// <param name="oBe"></param> /// <returns></returns> public List<BESVTC_OVEN> Get_SVPR_OVEN_BUSC(BESVTC_OVEN oBe) { try { using (IDataReader oDr = oDa.Get_SVPR_OVEN_BUSC(oBe)) { List<BESVTC_OVEN> oList = new List<BESVTC_OVEN>(); IList iList = oList; ((IList)iList).LoadFromReader<BESVTC_OVEN>(oDr); Dispose(false); return (oList); } } catch (Exception ex) { throw new ArgumentException(ex.Message); } }
/// <summary> /// REALIZAR OPERACIONES DE MANTENIMIENTO PARA LA VENTA /// </summary> /// <param name="oBe"></param> public void Set_SVPR_OVEN(BESVTC_OVEN oBe) { if (ocn.State == ConnectionState.Closed) ocn.Open(); using (var obts = ocn.BeginTransaction()) { try { using (var ocmd = odb.GetStoredProcCommand("SVPR_OVEN", oBe.COD_OVEN, oBe.COD_COTI, oBe.COD_SUCU, oBe.COD_SOCI_NEGO, oBe.ALF_NOMB, oBe.FEC_REGI, oBe.FEC_DOCU, oBe.FEC_PAGO, oBe.ALF_DIRE, oBe.ALF_CONT, oBe.NUM_DESC, oBe.ALF_OBSE, oBe.NUM_SUBT, oBe.NUM_IGVV, oBe.NUM_ISCC, oBe.NUM_TOTA, oBe.ALF_TOTA, oBe.COD_MONE, oBe.COD_USUA_CREA, oBe.COD_USUA_MODI, oBe.NUM_ACCI)) { ocmd.CommandTimeout = 2000; odb.ExecuteNonQuery(ocmd, obts); oBe.COD_OVEN = Convert.ToInt32(odb.GetParameterValue(ocmd, "@COD_OVEN")); DbCommand cmdo; oBe.LST_OVEN.ForEach(item => { cmdo = odb.GetStoredProcCommand("SVPR_OVEN_DETA", oBe.COD_OVEN, item.COD_ARTI, item.ALF_ARTI, item.NUM_PREC_UNIT, item.NUM_PORC_DESC, item.NUM_DESC, item.NUM_CANT, item.NUM_STOC_REAL, item.NUM_STOC_VIRT, item.NUM_IMPO, oBe.COD_USUA_CREA, oBe.COD_USUA_MODI, 1); cmdo.CommandTimeout = 2000; odb.ExecuteNonQuery(cmdo, obts); }); oBe.LST_OVEN_GROU.ForEach(item => { cmdo = odb.GetStoredProcCommand("SVPR_OVEN_GROU", item.COD_OVEN_GROU, oBe.COD_OVEN, item.ALF_NOMB, item.NUM_CANT, oBe.COD_USUA_CREA, oBe.COD_USUA_MODI, 1); cmdo.CommandTimeout = 2000; odb.ExecuteNonQuery(cmdo, obts); }); oBe.LST_OVEN_ARTI_GROU.ForEach(item => { cmdo = odb.GetStoredProcCommand("SVPR_OVEN_GROU_DETA", item.COD_OVEN_GROU, oBe.COD_OVEN, item.COD_ARTI, item.ALF_ARTI, item.NUM_PREC_UNIT, item.NUM_PORC_DESC, item.NUM_DESC, item.NUM_CANT, item.NUM_IMPO, oBe.COD_USUA_CREA, oBe.COD_USUA_MODI, 1); cmdo.CommandTimeout = 2000; odb.ExecuteNonQuery(cmdo, obts); }); obts.Commit(); } } catch (Exception ex) { obts.Rollback(); throw new ArgumentException(ex.Message); } finally { ocn.Close(); } } }
public IDataReader Get_SVPR_OVEN_BUSC(BESVTC_OVEN oBe) { try { if (ocn.State == ConnectionState.Closed) ocn.Open(); var ocmd = odb.GetStoredProcCommand("SVPR_OVEN_BUSC", oBe.ALF_NUME_IDENT, oBe.FEC_DESD, oBe.FEC_HAST, oBe.NUM_ACCI ); ocmd.CommandTimeout = 2000; var odr = odb.ExecuteReader(ocmd); Dispose(false); return (odr); } finally { ocn.Close(); } }