/// <summary>
///
/// </summary>
/// <param name="sCompany_Name"></param>
/// <param name="sName_Oficina"></param>
/// <param name="sProduct_Category"></param>
/// <param name="sName_Subcategory"></param>
/// <param name="sName_Brand"></param>
/// <param name="sProduct_Name"></param>
/// <returns></returns>
public DataSet ObteneridProducAncla(string sCompany_Name, string sName_Oficina, string sProduct_Category, string sName_Subcategory, string sName_Brand, string sProduct_Name)
{
DPLA_ProductosAncla odpancla = new DPLA_ProductosAncla();
DataSet ds = new DataSet();
ds = odpancla.ObteneridsProductosAncla(sCompany_Name, sName_Oficina, sProduct_Category, sName_Subcategory, sName_Brand, sProduct_Name);
return(ds);
}
/// <summary>
/// inserta registro en tabla de PLA_productosancla
/// 03/11/2011 Carlos Marín Moreno
/// </summary>
/// <param name="iCompany_id"></param>
/// <param name="sid_ProductCategory"></param>
/// <param name="lid_Subcategory"></param>
/// <param name="scod_Product"></param>
/// <param name="bpancla_Status"></param>
/// <param name="spancla_CreateBy"></param>
/// <param name="tpancla_DateBy"></param>
/// <param name="spancla_ModiBy"></param>
/// <param name="tpancla_DateModiBy"></param>
/// <returns>oePAncla</returns>
public EPLA_ProductosAncla RegistrarPAncla(int iCompany_id, int iid_ReportsPlanning, string sid_ProductCategory, long lid_Subcategory, string scod_Product, long lcod_Oficina, bool bpancla_Status, string spancla_CreateBy, DateTime tpancla_DateBy, string spancla_ModiBy, DateTime tpancla_DateModiBy)
{
DPLA_ProductosAncla odrPAncla = new DPLA_ProductosAncla();
EPLA_ProductosAncla oePAncla = odrPAncla.Registrar_PAncla(iCompany_id, iid_ReportsPlanning, sid_ProductCategory, lid_Subcategory, scod_Product, lcod_Oficina, bpancla_Status, spancla_CreateBy, tpancla_DateBy, spancla_ModiBy, tpancla_DateModiBy);
odrPAncla = null;
return(oePAncla);
}
/// <summary>
/// Permite Actualizar productos Ancla
/// 03/11/2011 Carlos Marín Moreno
/// </summary>
/// <param name="lid_pancla"></param>
/// <param name="scod_Product"></param>
/// <param name="bpancla_Status"></param>
/// <param name="spancla_ModiBy"></param>
/// <param name="tpancla_DateModiBy"></param>
/// <returns>oeaPancla</returns>
public EPLA_ProductosAncla Actualizar_Pancla(long lid_pancla, int iid_ReportsPlanning, long lid_Subcategory, string scod_Product, bool bpancla_Status, string spancla_ModiBy, DateTime tpancla_DateModiBy)
{
DPLA_ProductosAncla odaPancla = new DPLA_ProductosAncla();
EPLA_ProductosAncla oeaPancla = odaPancla.ActualizarPAncla(lid_pancla, iid_ReportsPlanning, lid_Subcategory, scod_Product, bpancla_Status, spancla_ModiBy, tpancla_DateModiBy);
odaPancla = null;
return(oeaPancla);
}
/// <summary>
/// Permite consultar productos ancla
/// 03/1/2011 Carlos Marín Moreno
/// </summary>
/// <param name="iCompany_id"></param>
/// <param name="sid_ProductCategory"></param>
/// <returns></returns>
public DataTable ConsultarPancla(int iCompany_id, string sid_ProductCategory, long lcod_Oficina, string sid_Subcategory, int iidReportPlanning)
{
DPLA_ProductosAncla odsPancla = new DPLA_ProductosAncla();
EPLA_ProductosAncla oePancla = new EPLA_ProductosAncla();
DataTable dtPancla = odsPancla.ConsultarPAncla(iCompany_id, sid_ProductCategory, lcod_Oficina, sid_Subcategory, iidReportPlanning);
odsPancla = null;
return(dtPancla);
}
