Example #1
0
        public DataSet ProcesarSocioLineaLog(SocioLineaLogBE BE)
        {
            DataSet dsResult;

            try
            {
                cmd = db.GetStoredProcCommand("SocioLineaLog_Mnt");
                db.AddInParameter(cmd, "OPCION", DbType.Int32, BE.OPCION);
                db.AddInParameter(cmd, "USUARIO", DbType.String, BE.USUARIO);
                db.AddInParameter(cmd, "IdLineaLog", DbType.String, BE.IdLineaLog);
                db.AddInParameter(cmd, "IdLinea", DbType.String, BE.IdLinea);
                if (BE.dtRegistro != DateTime.MinValue)
                {
                    db.AddInParameter(cmd, "dtRegistro", DbType.DateTime, BE.dtRegistro);
                }
                db.AddInParameter(cmd, "IdMoneda_tt", DbType.String, BE.IdMoneda_tt);
                db.AddInParameter(cmd, "nImporteAnterior", DbType.Decimal, BE.nImporteAnterior);
                db.AddInParameter(cmd, "nImporteNuevo", DbType.Decimal, BE.nImporteNuevo);
                dsResult = db.ExecuteDataSet(cmd);
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
            return(dsResult);
        }
Example #2
0
        private void frmMntLineasAutorizadasLog_Load(object sender, EventArgs e)
        {
            try
            {
                if (!pIdMoneda_tt.Equals("00036"))
                {
                    lblLineaMon.Text = "Línea Actual US$";
                }

                txtSocio_Id_Dsc.Text = pIdSocio_Dsc.Trim();
                txtImporte.Text      = pnImporte.Trim();

                SocioLineaLogBE SocioLineaLogBE = new SocioLineaLogBE()
                {
                    OPCION  = 1,
                    USUARIO = General.General.GetUsuario,
                    IdLinea = pIdLinea.Trim()
                };
                DataSet ds = new DataSet();
                ds = SocioLineaLogBL.ProcesarSocioLineaLog(SocioLineaLogBE);
                dgvHistorial.DataSource = ds.Tables[0];
                lblRegistros.Text       = ds.Tables[0].Rows.Count.ToString() + " registro(s)";
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
 public DataSet ProcesarSocioLineaLog(SocioLineaLogBE BE)
 {
     return(SocioLineaLogDA.ProcesarSocioLineaLog(BE));
 }