//---Metodo de Consulta de empaquetamientos actuales para la actualización del Producto Ing. Mauricio Ortiz public DataTable BuscarProductPackingActual(int iid_Product, int iid_Packing) { DProductPacking odseProductPacking = new DProductPacking(); EProductPacking oeProductPacking = new EProductPacking(); DataTable dtProductPacking = odseProductPacking.ObtenerProductPackingActual(iid_Product, iid_Packing); odseProductPacking = null; return(dtProductPacking); }
//----Metodo que permite Actualizar ProductPacking Ing. Mauricio Ortiz public EProductPacking Actualizar_ProductPacking(int iid_Product, int iid_Packing, decimal dPeso, int iUnitsByPacking, string sProductPackinUnitOfMeasure, bool bProductPackingStatus, string sProductPacking_ModiBy, DateTime tProductPacking_DateModiby) { Lucky.Data.Common.Application.DProductPacking odaProductPacking = new Lucky.Data.Common.Application.DProductPacking(); EProductPacking oeaProductPacking = odaProductPacking.Actualizar_ProductPacking(iid_Product, iid_Packing, dPeso, iUnitsByPacking, sProductPackinUnitOfMeasure, bProductPackingStatus, sProductPacking_ModiBy, tProductPacking_DateModiby); odaProductPacking = null; return(oeaProductPacking); }
//----Metodo que permite registrar Empaquetamiento de Productos /// <summary> /// Se cambia el parametro iPeso a Decimal Ing.Carlos Hernandez /// Se agregaron los objects para la insercion Ing.Carlos Hernandez /// Se eliminaron los objects para la inserción ya que no deben ir en esta capa Ing. Mauricio Ortiz /// /// </summary> /// <param name="iid_Packing"></param> /// <param name="iPeso"></param> /// <param name="sProductPackinUnitOfMeasure"></param> /// <param name="iUnitsByPacking"></param> /// <param name="scod_Product"></param> /// <returns></returns> public EProductPacking RegistrarProdPacking(int iid_Product, int iid_Packing, decimal dPeso, int iUnitsByPacking, string sProductPackinUnitOfMeasure, bool bProductPackingStatus, string sProductPacking_CreateBy, DateTime tProductPacking_DateBy, string sProductPacking_ModiBy, DateTime tProductPacking_DateModiby) { DProductPacking odrProdPacking = new DProductPacking(); EProductPacking oeProdPacking = odrProdPacking.RegistrarProdPacking(iid_Product, iid_Packing, dPeso, iUnitsByPacking, sProductPackinUnitOfMeasure, bProductPackingStatus, sProductPacking_CreateBy, tProductPacking_DateBy, sProductPacking_ModiBy, tProductPacking_DateModiby); odrProdPacking = null; return(oeProdPacking); }
//Método para Actualizar ProductPacking public EProductPacking Actualizar_ProductPacking(int iid_Product, int iid_Packing, decimal dPeso, int iUnitsByPacking, string sProductPackinUnitOfMeasure, bool bProductPackingStatus, string sProductPacking_ModiBy, DateTime tProductPacking_DateModiby) { DataTable dt = oConn.ejecutarDataTable("UP_WEB_ACTUALIZA_PRODUCTpacking", iid_Product, iid_Packing, dPeso, iUnitsByPacking, sProductPackinUnitOfMeasure, bProductPackingStatus, sProductPacking_ModiBy, tProductPacking_DateModiby); EProductPacking oeaProducPacking = new EProductPacking(); oeaProducPacking.id_Product = iid_Product; oeaProducPacking.id_Packing = iid_Packing; oeaProducPacking.Peso = dPeso; oeaProducPacking.UnitsByPacking = iUnitsByPacking; oeaProducPacking.ProductPackinUnitOfMeasure = sProductPackinUnitOfMeasure; oeaProducPacking.ProductPackingStatus = bProductPackingStatus; oeaProducPacking.ProductPacking_ModiBy = sProductPacking_ModiBy; oeaProducPacking.ProductPacking_DateModiby = tProductPacking_DateModiby; return(oeaProducPacking); }
/// <summary> ///Método: Buscar Empaquetamientos de producto ///Función: Permite Consultar empaquetamientos de productos que se desea actualizar /// </summary> public DataTable ObtenerProductPackingActual(int iid_Product, int iid_Packing) { DataTable dt = oConn.ejecutarDataTable("UP_WEB_SEARCHPRODUCTPACKINGACTUAL", iid_Product, iid_Packing); EProductPacking oeProductPacking = new EProductPacking(); if (dt != null) { if (dt.Rows.Count > 0) { for (int i = 0; i <= dt.Rows.Count - 1; i++) { oeProductPacking.id_Packing = Convert.ToInt32(dt.Rows[i]["id_Packing"].ToString().Trim()); oeProductPacking.UnitsByPacking = Convert.ToInt32(dt.Rows[i]["UnitsByPacking"].ToString().Trim()); oeProductPacking.ProductPackingStatus = Convert.ToBoolean(dt.Rows[i]["ProductPackingStatus"].ToString().Trim()); } } return(dt); } else { return(null); } }
//Método para Registrar Empaquetamientos de producto /// <summary> /// Se agregan los object para hacer la actualizacion Ing.Carlos Hernandez /// </summary> /// <param name="iid_Packing"></param> /// <param name="iPeso"></param> /// <param name="sProductPackinUnitOfMeasure"></param> /// <param name="iUnitsByPacking"></param> /// <param name="scod_Product"></param> /// <returns></returns> public EProductPacking RegistrarProdPacking(int iid_Product, int iid_Packing, decimal dPeso, int iUnitsByPacking, string sProductPackinUnitOfMeasure, bool bProductPackingStatus, string sProductPacking_CreateBy, DateTime tProductPacking_DateBy, string sProductPacking_ModiBy, DateTime tProductPacking_DateModiby) { DataTable dt = oConn.ejecutarDataTable("UP_WEB_REGISTERPRODPACKING", iid_Product, iid_Packing, dPeso, iUnitsByPacking, sProductPackinUnitOfMeasure, bProductPackingStatus, sProductPacking_CreateBy, tProductPacking_DateBy, sProductPacking_ModiBy, tProductPacking_DateModiby); EProductPacking oerProdPacking = new EProductPacking(); oerProdPacking.id_Product = iid_Product; oerProdPacking.id_Packing = iid_Packing; oerProdPacking.Peso = dPeso; oerProdPacking.UnitsByPacking = iUnitsByPacking; oerProdPacking.ProductPackinUnitOfMeasure = sProductPackinUnitOfMeasure; oerProdPacking.ProductPackingStatus = bProductPackingStatus; oerProdPacking.ProductPacking_CreateBy = sProductPacking_CreateBy; oerProdPacking.ProductPacking_DateBy = tProductPacking_DateBy; oerProdPacking.ProductPacking_ModiBy = sProductPacking_ModiBy; oerProdPacking.ProductPacking_DateModiby = tProductPacking_DateModiby; return(oerProdPacking); }