/// <summary> /// REALIZAR OPERACIONES DE MANTENIMIENTO /// </summary> /// <param name="oBe"></param> public void Set_SVPR_PERF(BESVMC_PERF oBe) { try { oDa.Set_SVPR_PERF(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_PERF> Get_SVPR_PERF_LIST(BESVMC_PERF oBe) { try { using (IDataReader oDr = oDa.Get_SVPR_PERF_LIST(oBe)) { List<BESVMC_PERF> oList = new List<BESVMC_PERF>(); IList iList = oList; ((IList)iList).LoadFromReader<BESVMC_PERF>(oDr); Dispose(false); return (oList); } } catch (Exception ex) { throw new ArgumentException(ex.Message); } }
/// <summary> /// REALIZAR OPERACIONES DE MANTENIMIENTO /// </summary> /// <param name="oBe"></param> public void Set_SVPR_PERF(BESVMC_PERF oBe) { if (ocn.State == ConnectionState.Closed) ocn.Open(); using (var obts = ocn.BeginTransaction()) { try { using (var ocmd = odb.GetStoredProcCommand("SVPR_PERF", oBe.COD_PERF, oBe.COD_COMP, oBe.ALF_PERF, oBe.ALF_DESC, oBe.COD_USUA_CREA, oBe.COD_USUA_MODI, oBe.NUM_ACCI)) { ocmd.CommandTimeout = 2000; odb.ExecuteNonQuery(ocmd, obts); oBe.COD_PERF = Convert.ToInt32(odb.GetParameterValue(ocmd, "@COD_PERF")); DbCommand cmdo; oBe.OBJ_ACCE.LST_OPCI.ForEach(item => { cmdo = odb.GetStoredProcCommand("SVPR_ACCE", 0, oBe.COD_PERF, null, item.COD_OPCI, item.IND_MARC, oBe.COD_USUA_CREA, oBe.COD_USUA_MODI, 1); cmdo.CommandTimeout = 2000; odb.ExecuteNonQuery(cmdo, obts); }); oBe.OBJ_ACCE.LST_OPCI_BUTT.ForEach(item => { cmdo = odb.GetStoredProcCommand("SVPR_ACCE", 0, oBe.COD_PERF, item.COD_BUTT, item.COD_OPCI, item.IND_MARC, oBe.COD_USUA_CREA, oBe.COD_USUA_MODI, 1); cmdo.CommandTimeout = 2000; odb.ExecuteNonQuery(cmdo, obts); }); obts.Commit(); } } catch (Exception ex) { obts.Rollback(); throw new ArgumentException(ex.Message); } finally { ocn.Close(); } } }
public IDataReader Get_SVPR_PERF_LIST(BESVMC_PERF oBe) { try { if (ocn.State == ConnectionState.Closed) ocn.Open(); var ocmd = odb.GetStoredProcCommand("SVPR_PERF_LIST", oBe.COD_PERF, oBe.COD_COMP, oBe.ALF_PERF, 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(); } }
private void xfProfiles_Load(object sender, EventArgs e) { SESSION_USER = ((xfMain)MdiParent).SESSION_USER; SESSION_PERF = ((xfMain)MdiParent).SESSION_PERF; SESSION_COMP = ((xfMain)MdiParent).SESSION_COMP; ControlState(true); var oBe = new BESVMC_PERF(); var oBr = new BRSVMC_PERF(); var oBeMm = new BESVMC_MAIN_MENU(); var oBrMm = new BRSVMC_MAIN(); oBe.NUM_ACCI = 4; oBe.COD_COMP = SESSION_COMP; var oList = oBr.Get_SVPR_PERF_LIST(oBe); gdcProfile.DataSource = oList; oBeMm.NUM_ACCI = 4; var oListMm = oBrMm.Get_SVPR_MAIN_LIST(oBeMm); gdcMain.DataSource = oListMm; }
public void Undo() { ClearControls(); var oBeProf = new BESVMC_PERF(); var oBrProf = new BRSVMC_PERF(); oBeProf.NUM_ACCI = 4; oBeProf.COD_COMP = SESSION_COMP; var oList = oBrProf.Get_SVPR_PERF_LIST(oBeProf); gdcProfile.DataSource = oList; ControlState(true); }
public void Save() { try { gdvOptions.CloseEditor(); gdvOptions.RefreshData(); gdvButtons.CloseEditor(); gdvButtons.RefreshData(); var oBe = new BESVMC_PERF(); var oBr = new BRSVMC_PERF(); if (string.IsNullOrEmpty(txtCOD_PERF.Text)) { oBe.NUM_ACCI = 1; } else { oBe.NUM_ACCI = 2; oBe.COD_PERF = int.Parse(txtCOD_PERF.Text); } oBe.ALF_PERF = txtALF_PERF.Text; oBe.ALF_DESC = meALF_DESC.Text; oBe.OBJ_ACCE.LST_OPCI = oListOpci; oBe.OBJ_ACCE.LST_OPCI_BUTT = oListButt; oBe.COD_COMP = SESSION_COMP; oBe.COD_USUA_CREA = SESSION_USER; oBe.COD_USUA_MODI = SESSION_USER; if (XtraMessageBox.Show("Esta seguro de que desea guardar los datos del perfil?", "Sistema", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { oBr.Set_SVPR_PERF(oBe); txtCOD_PERF.Text = oBe.COD_PERF.ToString(); var oBeOpci = new BESVMC_OPCI(); var oBrOpci = new BRSVMC_OPCI(); var oBeButt = new BESVMC_BUTT(); var oBrButt = new BRSVMC_BUTT(); oBeOpci.NUM_ACCI = 4; oBeOpci.COD_PERF = oBe.COD_PERF; oListOpci = oBrOpci.Get_SVPR_OPCI_LIST(oBeOpci); gdcOptions.DataSource = oListOpci; gdvOptions.ActiveFilter.Add(gdvOptions.Columns["COD_MAIN"], new ColumnFilterInfo(String.Format("[COD_MAIN] = {0} ", 0), "")); oBeButt.NUM_ACCI = 4; oBeButt.COD_PERF = oBe.COD_PERF; oListButt = oBrButt.Get_SVPR_BUTT_LIST(oBeButt); gdcButtons.DataSource = oListButt; gdvButtons.ActiveFilter.Add(gdvButtons.Columns["COD_OPCI"], new ColumnFilterInfo(String.Format("[COD_OPCI] = {0}", 0), "")); var oBeProf = new BESVMC_PERF(); var oBrProf = new BRSVMC_PERF(); oBeProf.NUM_ACCI = 4; oBeProf.COD_COMP = SESSION_COMP; var oList = oBrProf.Get_SVPR_PERF_LIST(oBeProf); gdcProfile.DataSource = oList; ControlState(true); XtraMessageBox.Show("Operacion realizada con exito", "Sistema", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { XtraMessageBox.Show(ex.Message,"Sistema",MessageBoxButtons.OK,MessageBoxIcon.Error); } }
private void xfUsuario_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_PERF(); var oBr = new BRSVMC_PERF(); oBe.NUM_ACCI = 4; oBe.COD_COMP = SESSION_COMP; var oList = oBr.Get_SVPR_PERF_LIST(oBe); lueCOD_PERF.Properties.DataSource = oList; lueCOD_PERF.Properties.Columns.Clear(); lueCOD_PERF.Properties.Columns.Add(new LookUpColumnInfo("ALF_PERF", 100, "Perfiles")); lueCOD_PERF.Properties.DisplayMember = "ALF_PERF"; lueCOD_PERF.Properties.ValueMember = "COD_PERF"; var oBeU = new BESVMC_USUA(); var oBrU = new BRSVMC_USUA(); oBeU.COD_COMP = SESSION_COMP; oBeU.NUM_ACCI = 4; var oListUser = oBrU.Get_SVPR_USUA_LIST(oBeU); gdcUsuarios.DataSource = oListUser; StateControl(true); }