public bool Actualizar(BE_LOG_ORDENCOMPRA e_OrdenCompra, List <BE_LOG_ORDENCOMPRADET> l_OrdenCompraDetalles)
{
CD_log_ordencompra miFun = new CD_log_ordencompra();
bool booOk = false;
miFun.mysConec = mysConec;
booOk = miFun.Actualizar(e_OrdenCompra, l_OrdenCompraDetalles);
b_OcurrioError = miFun.b_OcurrioError;
c_ErrorMensaje = miFun.c_ErrorMensaje;
n_ErrorNumber = miFun.n_ErrorNumber;
return(booOk);
}
public bool Eliminar(int n_Id)
{
CD_log_ordencompra miFun = new CD_log_ordencompra();
bool booOk = false;
miFun.mysConec = mysConec;
booOk = miFun.Eliminar(n_Id);
b_OcurrioError = miFun.b_OcurrioError;
c_ErrorMensaje = miFun.c_ErrorMensaje;
n_ErrorNumber = miFun.n_ErrorNumber;
return(booOk);
}
public DataTable OrdenesPendienteJalar(int n_IdEmpresa)
{
DataTable dtResult = new DataTable();
CD_log_ordencompra objsol = new CD_log_ordencompra();
string[,] arrCabeceraFlexFil = new string[5, 5];
objsol.mysConec = mysConec;
if (objsol.ConsultaPendientes(n_IdEmpresa) == true)
{
dtResult = objsol.dtLista;
// FLEX GRID DE LOS TAREAS
arrCabeceraFlexFil[0, 0] = "Nº Documento";
arrCabeceraFlexFil[0, 1] = "110";
arrCabeceraFlexFil[0, 2] = "C";
arrCabeceraFlexFil[0, 3] = "c_numdoc";
arrCabeceraFlexFil[1, 0] = "Proveedor";
arrCabeceraFlexFil[1, 1] = "110";
arrCabeceraFlexFil[1, 2] = "C";
arrCabeceraFlexFil[1, 3] = "c_pronom";
arrCabeceraFlexFil[2, 0] = "Fecha";
arrCabeceraFlexFil[2, 1] = "30";
arrCabeceraFlexFil[2, 2] = "C";
arrCabeceraFlexFil[2, 3] = "d_fchent";
arrCabeceraFlexFil[3, 0] = "Local";
arrCabeceraFlexFil[3, 1] = "110";
arrCabeceraFlexFil[3, 2] = "C";
arrCabeceraFlexFil[3, 3] = "c_locdes";
arrCabeceraFlexFil[4, 0] = "Area";
arrCabeceraFlexFil[4, 1] = "110";
arrCabeceraFlexFil[4, 2] = "C";
arrCabeceraFlexFil[4, 3] = "c_aredes";
funDatos.Buscar_CampoBusqueda = "c_numdoc";
funDatos.Buscar_CadFiltro = "";
funDatos.Buscar_CampoOrden = "c_numdoc";
funDatos.Buscar_Titulo = "Documentos Pendientes";
dtResult = funDatos.Buscar(arrCabeceraFlexFil, dtResult);
}
return(dtResult);
}
public void Listar(int n_idempresa, int n_idmes, int n_idano)
{
DataTable dtResul = new DataTable();
CD_log_ordencompra miFun = new CD_log_ordencompra();
miFun.mysConec = mysConec;
miFun.Listar(n_idempresa, n_idmes, n_idano);
dtLista = miFun.dtLista;
if (miFun.b_OcurrioError == true)
{
b_OcurrioError = miFun.b_OcurrioError;
c_ErrorMensaje = miFun.c_ErrorMensaje;
n_ErrorNumber = miFun.n_ErrorNumber;
}
return;
}
public bool TraerRegistro(int n_IdRegistro)
{
bool booresult = false;
DataTable dtCab = new DataTable();
DataTable dtDet = new DataTable();
BE_LOG_ORDENCOMPRA e_reque = new BE_LOG_ORDENCOMPRA();
CD_log_ordencompra miFun = new CD_log_ordencompra();
miFun.mysConec = mysConec;
l_OCDet.Clear();
if (miFun.TraerRegistro(n_IdRegistro) == true)
{
dtCab = miFun.dtCabecera;
dtDet = miFun.dtDetalle;
e_OC.n_idemp = Convert.ToInt32(dtCab.Rows[0]["n_idemp"]);
e_OC.n_id = Convert.ToInt32(dtCab.Rows[0]["n_id"]);
e_OC.n_idtipdoc = Convert.ToInt32(dtCab.Rows[0]["n_idtipdoc"]);
e_OC.c_numser = dtCab.Rows[0]["c_numser"].ToString();
e_OC.c_numdoc = dtCab.Rows[0]["c_numdoc"].ToString();
e_OC.n_anotra = Convert.ToInt32(dtCab.Rows[0]["n_anotra"]);
e_OC.n_mestra = Convert.ToInt32(dtCab.Rows[0]["n_mestra"]);
e_OC.d_fchemi = Convert.ToDateTime(dtCab.Rows[0]["d_fchemi"]);
e_OC.d_fchent = Convert.ToDateTime(dtCab.Rows[0]["d_fchent"]);
e_OC.n_idloc = Convert.ToInt32(dtCab.Rows[0]["n_idloc"]);
e_OC.n_idare = Convert.ToInt32(dtCab.Rows[0]["n_idare"]);
e_OC.n_idpersol = Convert.ToInt32(dtCab.Rows[0]["n_idpersol"]);
e_OC.n_idpri = Convert.ToInt32(dtCab.Rows[0]["n_idpri"]);
e_OC.c_obs = dtCab.Rows[0]["c_obs"].ToString();
e_OC.n_idest = Convert.ToInt32(dtCab.Rows[0]["n_idest"]);
e_OC.n_idmot = Convert.ToInt32(dtCab.Rows[0]["n_idmot"]);
e_OC.n_idpro = Convert.ToInt32(dtCab.Rows[0]["n_idpro"]);
e_OC.n_idmon = Convert.ToInt32(dtCab.Rows[0]["n_idmon"]);
e_OC.n_impbru = Convert.ToDouble(dtCab.Rows[0]["n_impbru"]);
e_OC.n_impigv = Convert.ToDouble(dtCab.Rows[0]["n_impigv"]);
e_OC.n_imptot = Convert.ToDouble(dtCab.Rows[0]["n_imptot"]);
e_OC.n_idconpag = Convert.ToInt32(dtCab.Rows[0]["n_idconpag"]);
e_OC.n_impina = Convert.ToDouble(dtCab.Rows[0]["n_impina"]);
if (!string.IsNullOrEmpty(dtCab.Rows[0]["n_docrefidtipdoc"].ToString()))
{
e_OC.n_docrefidtipdoc = Convert.ToInt32(dtCab.Rows[0]["n_docrefidtipdoc"]);
}
if (!string.IsNullOrEmpty(dtCab.Rows[0]["n_docrefiddocref"].ToString()))
{
e_OC.n_docrefiddocref = Convert.ToInt32(dtCab.Rows[0]["n_docrefiddocref"]);
}
e_OC.c_docrefnumser = dtCab.Rows[0]["c_docrefnumser"].ToString();
e_OC.c_docrefnumdoc = dtCab.Rows[0]["c_docrefnumdoc"].ToString();
int n_row = 0;
for (n_row = 0; n_row <= dtDet.Rows.Count - 1; n_row++)
{
BE_LOG_ORDENCOMPRADET e_ocdet = new BE_LOG_ORDENCOMPRADET();
e_ocdet.n_idoc = Convert.ToInt32(dtDet.Rows[n_row]["n_idoc"]);
e_ocdet.n_idite = Convert.ToInt32(dtDet.Rows[n_row]["n_idite"]);
e_ocdet.n_idunimed = Convert.ToInt32(dtDet.Rows[n_row]["n_idunimed"]);
e_ocdet.n_can = Convert.ToDouble(dtDet.Rows[n_row]["n_can"]);
e_ocdet.n_preuni = Convert.ToDouble(dtDet.Rows[n_row]["n_preuni"]);
e_ocdet.n_imptot = Convert.ToDouble(dtDet.Rows[n_row]["n_imptot"]);
e_ocdet.n_idtipafeigv = Convert.ToInt32(dtDet.Rows[n_row]["n_idtipafeigv"]);
if (string.IsNullOrEmpty(dtDet.Rows[n_row]["n_canat"].ToString()))
{
e_ocdet.n_canat = 0;
}
else
{
e_ocdet.n_canat = Convert.ToDouble(dtDet.Rows[n_row]["n_canat"]);
}
l_OCDet.Add(e_ocdet);
}
booresult = true;
}
return(booresult);
}
