/// <summary> /// REALIZAR OPERACIONES DE MANTENIMIENTO /// </summary> /// <param name="oBe"></param> public void Set_SVPR_COMP(BESVMC_COMP oBe) { try { oDa.Set_SVPR_COMP(oBe); Dispose(false); } catch(Exception ex) { throw new ArgumentException(ex.Message); } }
/// <summary> /// OBTENER EL RESULTADO DE CUALQUIER CONSULTA /// </summary> /// <param name="oBe"></param> /// <returns></returns> public List<BESVMC_COMP> Get_SVPR_COMP_LIST(BESVMC_COMP oBe) { try { using (IDataReader oDr = oDa.Get_SVPR_COMP_LIST(oBe)) { List<BESVMC_COMP> oList = new List<BESVMC_COMP>(); IList iList = oList; ((IList)iList).LoadFromReader<BESVMC_COMP>(oDr); Dispose(false); return (oList); } } catch (Exception ex) { throw new ArgumentException(ex.Message); } }
public IDataReader Get_SVPR_COMP_LIST(BESVMC_COMP oBe) { try { if (ocn.State == ConnectionState.Closed) ocn.Open(); var ocmd = odb.GetStoredProcCommand("SVPR_COMP_LIST", oBe.COD_COMP, oBe.COD_PAIS, oBe.COD_DEPA, oBe.COD_PROV, oBe.COD_DIST, oBe.ALF_COMP, oBe.ALF_DESC, oBe.COD_USUA_CREA, oBe.COD_USUA_MODI, oBe.NUM_ACCI ); ocmd.CommandTimeout = 2000; var odr = odb.ExecuteReader(ocmd); Dispose(false); return (odr); } finally { ocn.Close(); } }
public void Set_SVPR_COMP(BESVMC_COMP oBe) { if (ocn.State == ConnectionState.Closed) ocn.Open(); using (var obts = ocn.BeginTransaction()) { try { using (var ocmd = odb.GetStoredProcCommand("SVPR_COMP", oBe.COD_COMP, oBe.COD_PAIS, oBe.COD_DEPA, oBe.COD_PROV, oBe.COD_DIST, oBe.ALF_COMP, oBe.ALF_DESC, oBe.COD_USUA_CREA, oBe.COD_USUA_MODI, oBe.NUM_ACCI)) { ocmd.CommandTimeout = 2000; odb.ExecuteNonQuery(ocmd, obts); oBe.COD_COMP = Convert.ToInt32(odb.GetParameterValue(ocmd, "@COD_COMP")); obts.Commit(); } } catch (Exception ex) { obts.Rollback(); throw new ArgumentException(ex.Message); } finally { ocn.Close(); } } }
private void Get_DataAdd() { var obr = new BRPurchase(); txtALF_DOCU_REFE.Text = obr.Get_PSCP_SPLS_ORCO_NURE(SESSION_COMP); var obrg = new BRSVMC_COMP(); var objc = new BESVMC_COMP() { COD_COMP = SESSION_COMP, NUM_ACCI = 5 }; var ocmp = obrg.Get_SVPR_COMP_LIST(objc); mmeALF_DIRE_ENTR.Text = ocmp[0].ALF_DIRE_ENTR; }
private void xfLogin_Load(object sender, System.EventArgs e) { var oBeC = new BESVMC_COMP(); var oBrC = new BRSVMC_COMP(); oBeC.NUM_ACCI = 4; var oListC = oBrC.Get_SVPR_COMP_LIST(oBeC); lueCOD_COMP.Properties.DataSource = oListC; lueCOD_COMP.Properties.Columns.Clear(); lueCOD_COMP.Properties.Columns.Add(new LookUpColumnInfo("ALF_COMP", 100, "Compañia")); lueCOD_COMP.Properties.DisplayMember = "ALF_COMP"; lueCOD_COMP.Properties.ValueMember = "COD_COMP"; }
public void Save() { try { if (string.IsNullOrEmpty(txtALF_COMP.Text)) throw new ArgumentException("Ingresar el nombre de la compañia"); if (lueCOD_PAIS.EditValue==null) throw new ArgumentException("Seleccione el país"); var oBe = new BESVMC_COMP(); var oBr = new BRSVMC_COMP(); if (string.IsNullOrEmpty(txtCOD_COMP.Text)) { oBe.NUM_ACCI = 1; } else { oBe.NUM_ACCI = 2; oBe.COD_COMP=Convert.ToInt32(txtCOD_COMP.Text); } oBe.ALF_COMP = txtALF_COMP.Text; oBe.ALF_DESC = meALF_DESC.Text; oBe.COD_PAIS = Convert.ToInt32(lueCOD_PAIS.EditValue); oBe.COD_DEPA = lueCOD_DEPA.EditValue==null?"":lueCOD_DEPA.EditValue.ToString(); oBe.COD_PROV = lueCOD_PROV.EditValue == null ? "" : lueCOD_PROV.EditValue.ToString(); oBe.COD_DIST = lueCOD_DIST.EditValue == null ? "" : lueCOD_DIST.EditValue.ToString(); oBe.COD_USUA_CREA = SESSION_USER; oBe.COD_USUA_MODI = SESSION_USER; oBr.Set_SVPR_COMP(oBe); txtCOD_COMP.Text = oBe.COD_COMP.ToString(); var oBeC = new BESVMC_COMP(); var oBrC = new BRSVMC_COMP(); oBeC.NUM_ACCI = 4; var oListC = oBrC.Get_SVPR_COMP_LIST(oBeC); gdcCompany.DataSource = oListC; StateControl(true); XtraMessageBox.Show("Operación realizada con exito!!!","Sistema",MessageBoxButtons.OK,MessageBoxIcon.Information); } catch(Exception ex) { XtraMessageBox.Show(ex.Message,"Sistema",MessageBoxButtons.OK,MessageBoxIcon.Error); } }
private void xfCompany_Load(object sender, EventArgs e) { SESSION_USER = ((xfMain)MdiParent).SESSION_USER; SESSION_PERF = ((xfMain)MdiParent).SESSION_PERF; SESSION_COMP = ((xfMain)MdiParent).SESSION_COMP; var oBe = new BESVMC_PAIS(); var oBr = new BRSVMC_PAIS(); var oBeC = new BESVMC_COMP(); var oBrC = new BRSVMC_COMP(); oBeC.NUM_ACCI = 4; var oListC = oBrC.Get_SVPR_COMP_LIST(oBeC); gdcCompany.DataSource = oListC; oBe.NUM_ACCI = 4; oBe.COD_COMP = SESSION_COMP; var oList = oBr.Get_SVPR_PAIS_LIST(oBe); lueCOD_PAIS.Properties.DataSource = oList; lueCOD_PAIS.Properties.Columns.Clear(); lueCOD_PAIS.Properties.Columns.Add(new LookUpColumnInfo("ALF_PAIS", 100, "Paises")); lueCOD_PAIS.Properties.DisplayMember = "ALF_PAIS"; lueCOD_PAIS.Properties.ValueMember = "COD_PAIS"; StateControl(true); }