/// <summary>
/// Metodo que permite Consultar producto ancla
/// 03/11/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)
{
DataTable dt = oConn.ejecutarDataTable("UP_WEBXPLORA_PLA_CONSULTAPRODUCTOANCLA", iCompany_id, sid_ProductCategory, lcod_Oficina, sid_Subcategory, iidReportPlanning);
EPLA_ProductosAncla oePancla = new EPLA_ProductosAncla();
if (dt != null)
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
oePancla.id_pancla = Convert.ToInt64(dt.Rows[i]["id_pancla"].ToString().Trim());
oePancla.Company_id = Convert.ToInt32(dt.Rows[i]["Company_id"].ToString().Trim());
oePancla.id_ProductCategory = dt.Rows[i]["id_ProductCategory"].ToString().Trim();
oePancla.id_Subcategory = Convert.ToInt64(dt.Rows[i]["id_Subcategory"].ToString().Trim());
oePancla.cod_Product = dt.Rows[i]["cod_Product"].ToString().Trim();
oePancla.cod_Oficina = Convert.ToInt64(dt.Rows[i]["cod_Oficina"].ToString().Trim());
oePancla.pancla_Status = Convert.ToBoolean(dt.Rows[i]["pancla_Status"].ToString().Trim());
oePancla.pancla_CreateBy = dt.Rows[i]["pancla_CreateBy"].ToString().Trim();
oePancla.pancla_DateBy = Convert.ToDateTime(dt.Rows[i]["pancla_DateBy"].ToString().Trim());
oePancla.pancla_ModiBy = dt.Rows[i]["pancla_ModiBy"].ToString().Trim();
oePancla.pancla_DateModiBy = Convert.ToDateTime(dt.Rows[i]["pancla_DateModiBy"].ToString().Trim());
}
}
return(dt);
}
else
{
return(null);
}
}
/// <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);
}
/// <summary>
/// Permite Actualizar producto ancla,
/// 08/09/2010 Magaly jiménez
/// </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>oeaPacla</returns>
public EPLA_ProductosAncla ActualizarPAncla(long lid_pancla, int iid_ReportsPlanning, long lid_Subcategory, string scod_Product, bool bpancla_Status, string spancla_ModiBy, DateTime tpancla_DateModiBy)
{
DataSet ds = oConn.ejecutarDataSet("UP_WEBXPLORA_PLA_ACTUALIZARPANCLA", lid_pancla, iid_ReportsPlanning, lid_Subcategory, scod_Product, bpancla_Status, spancla_ModiBy, tpancla_DateModiBy);
EPLA_ProductosAncla oeaPacla = new EPLA_ProductosAncla();
oeaPacla.id_pancla = lid_pancla;
oeaPacla.id_Subcategory = lid_Subcategory;
oeaPacla.cod_Product = scod_Product;
oeaPacla.pancla_Status = bpancla_Status;
oeaPacla.pancla_ModiBy = spancla_ModiBy;
oeaPacla.pancla_DateModiBy = tpancla_DateModiBy;
return(oeaPacla);
}
/// <summary>
/// inserta información de producto Ancla
/// 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>oerpancla</returns>
public EPLA_ProductosAncla Registrar_PAncla(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)
{
DataSet ds = oConn.ejecutarDataSet("UP_WEBXPLORA_PLA_REGISTER_PRODUCTOANCLA", iCompany_id, iid_ReportsPlanning, sid_ProductCategory, lid_Subcategory, scod_Product, lcod_Oficina, bpancla_Status, spancla_CreateBy, tpancla_DateBy, spancla_ModiBy, tpancla_DateModiBy);
EPLA_ProductosAncla oerpancla = new EPLA_ProductosAncla();
oerpancla.Company_id = iCompany_id;
oerpancla.id_ReportsPlanning = iid_ReportsPlanning;
oerpancla.id_ProductCategory = sid_ProductCategory;
oerpancla.id_Subcategory = lid_Subcategory;
oerpancla.cod_Product = scod_Product;
oerpancla.cod_Oficina = lcod_Oficina;
oerpancla.pancla_Status = bpancla_Status;
oerpancla.pancla_CreateBy = spancla_CreateBy;
oerpancla.pancla_DateBy = tpancla_DateBy;
oerpancla.pancla_ModiBy = spancla_ModiBy;
oerpancla.pancla_DateModiBy = tpancla_DateModiBy;
return(oerpancla);
}
