public void TraerRegistro(int n_IdRegistro, int n_IdEmpresa)
{
CD_con_pcitems miFun = new CD_con_pcitems();
miFun.mysConec = mysConec;
e_Items = new BE_CON_PCITEMS();
miFun.TraerRegistro(n_IdRegistro, n_IdEmpresa);
dtLista = miFun.dtLista;
if (dtLista == null)
{
b_OcurrioError = miFun.b_OcurrioError;
c_ErrorMensaje = miFun.c_ErrorMensaje;
n_ErrorNumber = miFun.n_ErrorNumber;
}
else
{
e_Items = null;
if (dtLista.Rows.Count != 0)
{
e_Items = new BE_CON_PCITEMS();
e_Items.n_idemp = Convert.ToInt32(dtLista.Rows[0]["n_idemp"]);
e_Items.n_idite = Convert.ToInt32(dtLista.Rows[0]["n_idite"]);
e_Items.n_idpc = Convert.ToInt32(funFunciones.NulosN(dtLista.Rows[0]["n_idpc"]));
e_Items.n_idpcven = Convert.ToInt32(funFunciones.NulosN(dtLista.Rows[0]["n_idpcven"]));
e_Items.n_iddet = Convert.ToInt32(funFunciones.NulosN(dtLista.Rows[0]["n_iddet"]));
e_Items.n_idper = Convert.ToInt32(funFunciones.NulosN(dtLista.Rows[0]["n_idper"]));
e_Items.n_idret = Convert.ToInt32(funFunciones.NulosN(dtLista.Rows[0]["n_idret"]));
e_Items.n_idigvcom = Convert.ToInt32(funFunciones.NulosN(dtLista.Rows[0]["n_idigvcom"]));
e_Items.n_idigvven = Convert.ToInt32(funFunciones.NulosN(dtLista.Rows[0]["n_idigvven"]));
e_Items.n_idisc = Convert.ToInt32(funFunciones.NulosN(dtLista.Rows[0]["n_idisc"]));
}
}
return;
}
void VerRegistro(int n_IdRegistro)
{
Blanquea();
DataTable dtresul = new DataTable();
objItems.mysConec = mysConec;
//e_Items = new BE_CON_PCITEMS();
objItems.TraerRegistro(n_IdRegistro, STU_SISTEMA.EMPRESAID);
e_Items = objItems.e_Items;
dtresul = funDatos.DataTableFiltrar(dtInventario, "n_id = " + n_IdRegistro.ToString() + "");
//dtresul = funDatos.DataTableFiltrar(dtItems, "n_iditem = " + n_IdRegistro.ToString() + "");
if (dtresul.Rows.Count != 0)
{
CboClase.SelectedValue = Convert.ToInt32(dtresul.Rows[0]["n_idclas"]);
CboFamilia.SelectedValue = Convert.ToInt32(dtresul.Rows[0]["n_idfam"]);
CboTipExis.SelectedValue = Convert.ToInt32(dtresul.Rows[0]["n_idtipexi"]);
CboSubClase.SelectedValue = Convert.ToInt32(dtresul.Rows[0]["n_idsubclas"]);
TxtCodigo.Text = dtresul.Rows[0]["c_codpro"].ToString();
TxtDescripcion.Text = dtresul.Rows[0]["c_despro"].ToString();
LblIdItem.Text = dtresul.Rows[0]["n_id"].ToString();
//LblIdItem.Text = dtresul.Rows[0]["n_iditem"].ToString();
}
if (e_Items != null)
{
dtresul = funDatos.DataTableFiltrar(dtPlaCue, "n_id = " + e_Items.n_idpc + "");
if (dtresul.Rows.Count != 0)
{
TxtCtaCom.Text = dtresul.Rows[0]["c_cuecon"].ToString();
TxtCtaDesCom.Text = dtresul.Rows[0]["c_des"].ToString();
LblIdCtaCom.Text = dtresul.Rows[0]["n_id"].ToString();
}
dtresul = funDatos.DataTableFiltrar(dtPlaCue, "n_id = " + e_Items.n_idpcven + "");
if (dtresul.Rows.Count != 0)
{
TxtCtaVen.Text = dtresul.Rows[0]["c_cuecon"].ToString();
TxtCtaDesVen.Text = dtresul.Rows[0]["c_des"].ToString();
LblIdCtaVen.Text = dtresul.Rows[0]["n_id"].ToString();
}
CboDet.SelectedValue = e_Items.n_iddet;
CboRet.SelectedValue = e_Items.n_idret;
CboPer.SelectedValue = e_Items.n_idper;
CboIsc.SelectedValue = e_Items.n_idisc;
CboIgvCom.SelectedValue = e_Items.n_idigvcom;
CboIgvVen.SelectedValue = e_Items.n_idigvven;
}
}
public bool Actualizar(BE_CON_PCITEMS e_Items)
{
bool b_result = false;
CD_con_pcitems miFun = new CD_con_pcitems();
miFun.mysConec = mysConec;
b_result = miFun.Actualizar(e_Items);
if (b_result == false)
{
b_OcurrioError = miFun.b_OcurrioError;
c_ErrorMensaje = miFun.c_ErrorMensaje;
n_ErrorNumber = miFun.n_ErrorNumber;
}
return(b_result);
}
public bool Actualizar(BE_CON_PCITEMS e_Items)
{
bool booOk = false;
DatosMySql xMiFuncion = new DatosMySql();
if (xMiFuncion.StoreEjecutar("con_pcitems_actualizar", e_Items, mysConec, null) == false)
{
b_OcurrioError = xMiFuncion.booOcurrioError;
c_ErrorMensaje = xMiFuncion.StrErrorMensaje;
n_ErrorNumber = xMiFuncion.IntErrorNumber;
}
else
{
booOk = true;
}
return(booOk);
}
void AsignarEntidad()
{
e_Items = new BE_CON_PCITEMS();
e_Items.n_idemp = STU_SISTEMA.EMPRESAID; // POR DEFAULT LE ASIGNAMOS EL ID DE EMPRESA 0
if (STU_SISTEMA.SYS_UNIBD == 0)
{
e_Items.n_idemp = STU_SISTEMA.EMPRESAID;
} // SI EL MAESTRO DE INVENTARIOS NO ES UNIFICADO LE ASIGNAMOS EL ID DE LA EMPRESA
e_Items.n_idemp = STU_SISTEMA.EMPRESAID;
e_Items.n_idite = Convert.ToInt32(LblIdItem.Text);
e_Items.n_idpc = Convert.ToInt32(funFunciones.NulosN(LblIdCtaCom.Text));
e_Items.n_idpcven = Convert.ToInt32(funFunciones.NulosN(LblIdCtaVen.Text));
e_Items.n_iddet = Convert.ToInt32(CboDet.SelectedValue);
e_Items.n_idper = Convert.ToInt32(CboPer.SelectedValue);
e_Items.n_idret = Convert.ToInt32(CboRet.SelectedValue);
e_Items.n_idigvcom = Convert.ToInt32(CboIgvCom.SelectedValue);
e_Items.n_idigvven = Convert.ToInt32(CboIgvVen.SelectedValue);
e_Items.n_idisc = Convert.ToInt32(CboIsc.SelectedValue);
}
