Beispiel #1
0
 /// <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);
     }
 }
Beispiel #2
0
 /// <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);
     }
 }
Beispiel #3
0
 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();
     }
 }
Beispiel #4
0
 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();
         }
     }
 }
Beispiel #5
0
        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;
        }
Beispiel #6
0
        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";
        }
Beispiel #7
0
        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);
            }
        }
Beispiel #8
0
        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);
        }