/// <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); }