/// <summary>
/// Método para registrar en la tabla OPE_DigFORMATOFINALSOD
/// Ing. Mauricio Ortiz
/// 27/04/2011
/// </summary>
/// <param name="sid_planning"></param>
/// <param name="iCod_Formato"></param>
/// <param name="tFecha_OpeDigFORMATOFINALSOD"></param>
/// <param name="iPerson_id"></param>
/// <param name="sClientPDV_Code"></param>
/// <param name="spdv_Name"></param>
/// <param name="icod_Oficina"></param>
/// <param name="sname_ProductCategory"></param>
/// <param name="sname_Brand"></param>
/// <param name="sExhPrim_OpeDigFORMATOFINALSOD"></param>
/// <param name="sExhSec_OpeDigFORMATOFINALSOD"></param>
/// <param name="sCreateBy_OpeDigFORMATOFINALSOD"></param>
/// <param name="tDateby_OpeDigFORMATOFINALSOD"></param>
/// <param name="sModiby_OpeDigFORMATOFINALSOD"></param>
/// <param name="tDateModiBy_OpeDigFORMATOFINALSOD"></param>
/// <returns></returns>
public EOPE_DigFORMATOFINALSOD RegistrarFormatoFinalSod(string sid_planning, int iCod_Formato, DateTime tFecha_OpeDigFORMATOFINALSOD,
int iPerson_id, string sClientPDV_Code, string spdv_Name, long icod_Oficina, string sname_ProductCategory,
string sname_Brand, string sExhPrim_OpeDigFORMATOFINALSOD, string sExhSec_OpeDigFORMATOFINALSOD,
string sCreateBy_OpeDigFORMATOFINALSOD, DateTime tDateby_OpeDigFORMATOFINALSOD, string sModiby_OpeDigFORMATOFINALSOD,
DateTime tDateModiBy_OpeDigFORMATOFINALSOD)
{
DataTable dt = oConn.ejecutarDataTable("UP_WEBXPLORA_OPE_DIG_INSERTAR_FORMATO_FINAL_SOD", sid_planning, iCod_Formato, tFecha_OpeDigFORMATOFINALSOD,
iPerson_id, sClientPDV_Code, spdv_Name, icod_Oficina, sname_ProductCategory,
sname_Brand, sExhPrim_OpeDigFORMATOFINALSOD, sExhSec_OpeDigFORMATOFINALSOD,
sCreateBy_OpeDigFORMATOFINALSOD, tDateby_OpeDigFORMATOFINALSOD, sModiby_OpeDigFORMATOFINALSOD,
tDateModiBy_OpeDigFORMATOFINALSOD);
EOPE_DigFORMATOFINALSOD oeEOPE_DigFORMATOFINALSOD = new EOPE_DigFORMATOFINALSOD();
oeEOPE_DigFORMATOFINALSOD.id_planning = sid_planning;
oeEOPE_DigFORMATOFINALSOD.Cod_Formato = iCod_Formato;
oeEOPE_DigFORMATOFINALSOD.Fecha_OpeDigFORMATOFINALSOD = tFecha_OpeDigFORMATOFINALSOD;
oeEOPE_DigFORMATOFINALSOD.Person_id = iPerson_id;
oeEOPE_DigFORMATOFINALSOD.ClientPDV_Code = sClientPDV_Code;
oeEOPE_DigFORMATOFINALSOD.pdv_Name = spdv_Name;
oeEOPE_DigFORMATOFINALSOD.cod_Oficina = icod_Oficina;
oeEOPE_DigFORMATOFINALSOD.name_ProductCategory = sname_ProductCategory;
oeEOPE_DigFORMATOFINALSOD.name_Brand = sname_Brand;
oeEOPE_DigFORMATOFINALSOD.ExhPrim_OpeDigFORMATOFINALSOD = sExhPrim_OpeDigFORMATOFINALSOD;
oeEOPE_DigFORMATOFINALSOD.ExhSec_OpeDigFORMATOFINALSOD = sExhSec_OpeDigFORMATOFINALSOD;
oeEOPE_DigFORMATOFINALSOD.CreateBy_OpeDigFORMATOFINALSOD = sCreateBy_OpeDigFORMATOFINALSOD;
oeEOPE_DigFORMATOFINALSOD.Dateby_OpeDigFORMATOFINALSOD = tDateby_OpeDigFORMATOFINALSOD;
oeEOPE_DigFORMATOFINALSOD.Modiby_OpeDigFORMATOFINALSOD = sModiby_OpeDigFORMATOFINALSOD;
oeEOPE_DigFORMATOFINALSOD.DateModiBy_OpeDigFORMATOFINALSOD = tDateModiBy_OpeDigFORMATOFINALSOD;
return(oeEOPE_DigFORMATOFINALSOD);
}
/// <summary>
/// Método para Actualizar registros en la tabla OPE_DigFORMATOFINALSOD
/// Ing. Mauricio Ortiz
/// 28/04/2011
/// </summary>
/// <param name="iid_OpeDigFORMATOFINALSOD"></param>
/// <param name="sExhPrim_OpeDigFORMATOFINALSOD"></param>
/// <param name="sExhSec_OpeDigFORMATOFINALSOD"></param>
/// <param name="sModiby_OpeDigFORMATOFINALSOD"></param>
/// <param name="tDateModiBy_OpeDigFORMATOFINALSOD"></param>
/// <returns></returns>
public EOPE_DigFORMATOFINALSOD ActualizarOPE_DigFORMATOFINALSOD(long iid_OpeDigFORMATOFINALSOD, string sExhPrim_OpeDigFORMATOFINALSOD, string sExhSec_OpeDigFORMATOFINALSOD,
string sModiby_OpeDigFORMATOFINALSOD, DateTime tDateModiBy_OpeDigFORMATOFINALSOD)
{
DOPE_DigFORMATOFINALSOD odaOPE_DigFORMATOFINALSOD = new DOPE_DigFORMATOFINALSOD();
EOPE_DigFORMATOFINALSOD oeOPE_DigFORMATOFINALSOD = odaOPE_DigFORMATOFINALSOD.ActualizarOPE_DigFORMATOFINALSOD(iid_OpeDigFORMATOFINALSOD, sExhPrim_OpeDigFORMATOFINALSOD, sExhSec_OpeDigFORMATOFINALSOD, sModiby_OpeDigFORMATOFINALSOD, tDateModiBy_OpeDigFORMATOFINALSOD);
odaOPE_DigFORMATOFINALSOD = null;
return(oeOPE_DigFORMATOFINALSOD);
}
/// <summary>
/// Método para Actualizar registros en la tabla OPE_DigFORMATOFINALSOD
/// Ing. Mauricio Ortiz
/// 28/04/2011
/// </summary>
/// <param name="iid_OpeDigFORMATOFINALSOD"></param>
/// <param name="sExhPrim_OpeDigFORMATOFINALSOD"></param>
/// <param name="sExhSec_OpeDigFORMATOFINALSOD"></param>
/// <param name="sModiby_OpeDigFORMATOFINALSOD"></param>
/// <param name="tDateModiBy_OpeDigFORMATOFINALSOD"></param>
/// <returns></returns>
public EOPE_DigFORMATOFINALSOD ActualizarOPE_DigFORMATOFINALSOD(long iid_OpeDigFORMATOFINALSOD, string sExhPrim_OpeDigFORMATOFINALSOD, string sExhSec_OpeDigFORMATOFINALSOD,
string sModiby_OpeDigFORMATOFINALSOD, DateTime tDateModiBy_OpeDigFORMATOFINALSOD)
{
DataTable dt = oConn.ejecutarDataTable("UP_WEBXPLORA_OPE_DIG_ACTUALIZAR_FORMATO_FINAL_SOD", iid_OpeDigFORMATOFINALSOD, sExhPrim_OpeDigFORMATOFINALSOD, sExhSec_OpeDigFORMATOFINALSOD, sModiby_OpeDigFORMATOFINALSOD, tDateModiBy_OpeDigFORMATOFINALSOD);
EOPE_DigFORMATOFINALSOD oaOPE_DigFORMATOFINALSOD = new EOPE_DigFORMATOFINALSOD();
oaOPE_DigFORMATOFINALSOD.id_OpeDigFORMATOFINALSOD = iid_OpeDigFORMATOFINALSOD;
oaOPE_DigFORMATOFINALSOD.ExhPrim_OpeDigFORMATOFINALSOD = sExhPrim_OpeDigFORMATOFINALSOD;
oaOPE_DigFORMATOFINALSOD.ExhSec_OpeDigFORMATOFINALSOD = sExhSec_OpeDigFORMATOFINALSOD;
oaOPE_DigFORMATOFINALSOD.Modiby_OpeDigFORMATOFINALSOD = sModiby_OpeDigFORMATOFINALSOD;
oaOPE_DigFORMATOFINALSOD.DateModiBy_OpeDigFORMATOFINALSOD = tDateModiBy_OpeDigFORMATOFINALSOD;
return(oaOPE_DigFORMATOFINALSOD);
}
/// <summary>
/// Método para consultar registros en la tabla OPE_DigFORMATOFINALESPRECIOS
/// Ing. Mauricio Ortiz
/// 29/04/2011
/// </summary>
/// <param name="sid_planning"></param>
/// <param name="iCod_Formato"></param>
/// <param name="tFecha_OpeDigFORMATOFINALSOD"></param>
/// <param name="iPerson_id"></param>
/// <param name="iNodeCommercial"></param>
/// <param name="sClientPDV_Code"></param>
/// <returns></returns>
///
/// Backup del metodo anterior, se modifica porque el store procedure 'UP_WEBXPLORA_OPE_DIG_CONSULTAR_FORMATO_FINALES_PRECIOS' no contiene los parametros
/// sid_planning, iCod_Formato. Fecha:15/06/2011. Por: Pablo Salas.
///
public DataTable ConsultarOPE_DigFORMATOFINALESPRECIOS(string sid_planning, int iCod_Formato, DateTime tFecha_OpeDigFORMATOFINALSOD, int iPerson_id,
int iNodeCommercial, string sClientPDV_Code)
{
DataTable dt = oConn.ejecutarDataTable("UP_WEBXPLORA_OPE_DIG_CONSULTAR_FORMATO_FINALES_PRECIOS", sid_planning, iCod_Formato, tFecha_OpeDigFORMATOFINALSOD, iPerson_id,
iNodeCommercial, sClientPDV_Code);
EOPE_DigFORMATOFINALSOD oeOPE_DigFORMATOFINALSOD = new EOPE_DigFORMATOFINALSOD();
if (dt != null)
{
if (dt.Rows.Count > 0)
{
return(dt);
}
}
return(null);
}
/// <summary>
/// Método para consultar registros en la tabla OPE_DigFORMATOFINALSOD
/// Ing. Mauricio Ortiz
/// 28/04/2011
/// </summary>
/// <param name="sid_planning"></param>
/// <param name="iCod_Formato"></param>
/// <param name="tFecha_OpeDigFORMATOFINALSOD"></param>
/// <param name="iPerson_id"></param>
/// <param name="sClientPDV_Code"></param>
/// <param name="icod_Oficina"></param>
/// <returns></returns>
public DataTable ConsultarOPE_DigFORMATOFINALSOD(string sid_planning, int iCod_Formato, DateTime tFecha_OpeDigFORMATOFINALSOD, int iPerson_id,
string sClientPDV_Code, long icod_Oficina)
{
DataTable dt = oConn.ejecutarDataTable("UP_WEBXPLORA_OPE_DIG_CONSULTAR_FORMATO_FINAL_SOD", sid_planning, iCod_Formato, tFecha_OpeDigFORMATOFINALSOD, iPerson_id,
sClientPDV_Code, icod_Oficina);
EOPE_DigFORMATOFINALSOD oeOPE_DigFORMATOFINALSOD = new EOPE_DigFORMATOFINALSOD();
if (dt != null)
{
if (dt.Rows.Count > 0)
{
return(dt);
}
}
return(null);
}
/// <summary>
/// Método para registrar en la tabla OPE_DigFORMATOFINALSOD
/// Ing. Mauricio Ortiz
/// 27/04/2011
/// </summary>
/// <param name="sid_planning"></param>
/// <param name="iCod_Formato"></param>
/// <param name="tFecha_OpeDigFORMATOFINALSOD"></param>
/// <param name="iPerson_id"></param>
/// <param name="sClientPDV_Code"></param>
/// <param name="spdv_Name"></param>
/// <param name="lcod_Oficina"></param>
/// <param name="sname_ProductCategory"></param>
/// <param name="sname_Brand"></param>
/// <param name="sExhPrim_OpeDigFORMATOFINALSOD"></param>
/// <param name="sExhSec_OpeDigFORMATOFINALSOD"></param>
/// <param name="sCreateBy_OpeDigFORMATOFINALSOD"></param>
/// <param name="tDateby_OpeDigFORMATOFINALSOD"></param>
/// <param name="sModiby_OpeDigFORMATOFINALSOD"></param>
/// <param name="tDateModiBy_OpeDigFORMATOFINALSOD"></param>
/// <returns></returns>
public EOPE_DigFORMATOFINALSOD RegistrarFormatoFinalSod(string sid_planning, int iCod_Formato, DateTime tFecha_OpeDigFORMATOFINALSOD,
int iPerson_id, string sClientPDV_Code, string spdv_Name, long lcod_Oficina, string sname_ProductCategory,
string sname_Brand, string sExhPrim_OpeDigFORMATOFINALSOD, string sExhSec_OpeDigFORMATOFINALSOD,
string sCreateBy_OpeDigFORMATOFINALSOD, DateTime tDateby_OpeDigFORMATOFINALSOD, string sModiby_OpeDigFORMATOFINALSOD,
DateTime tDateModiBy_OpeDigFORMATOFINALSOD)
{
DOPE_DigFORMATOFINALSOD odrOPE_DigFORMATOFINALSOD = new DOPE_DigFORMATOFINALSOD();
EOPE_DigFORMATOFINALSOD oeOPE_DigFORMATOFINALSOD = odrOPE_DigFORMATOFINALSOD.RegistrarFormatoFinalSod(sid_planning, iCod_Formato, tFecha_OpeDigFORMATOFINALSOD,
iPerson_id, sClientPDV_Code, spdv_Name, lcod_Oficina, sname_ProductCategory,
sname_Brand, sExhPrim_OpeDigFORMATOFINALSOD, sExhSec_OpeDigFORMATOFINALSOD,
sCreateBy_OpeDigFORMATOFINALSOD, tDateby_OpeDigFORMATOFINALSOD, sModiby_OpeDigFORMATOFINALSOD,
tDateModiBy_OpeDigFORMATOFINALSOD);
odrOPE_DigFORMATOFINALSOD = null;
return(oeOPE_DigFORMATOFINALSOD);
}
