コード例 #1
0
        public void ActualizarSaldo(CajaGeneral caja, decimal valor)
        {
            string vl = valor.ToString("N2");
            string vr = valor.ToString();

            decimal v1 = Convert.ToDecimal(vl, CultureInfo.CreateSpecificCulture("es-ES"));

            vl = vl.Replace(',', '.');
            vr = vr.Replace(',', '.');

            int retorno = 0;

            string[] data  = caja.FechaSaldo.Split('/');
            string   fecha = caja.FechaSaldo;

            if (data.Length > 1)
            {
                fecha = String.Format("{0}-{1}-{2}", data[2].Substring(0, 4), data[1], data[0]);
            }
            MySqlConnection conection = Conexion.ObtenerConexion();
            MySqlCommand    comando   = new MySqlCommand(string.Format("update cajageneral set saldo = (saldo + '{0}') where fechaSaldo >= '{1}'", vr, fecha), conection);

            retorno = comando.ExecuteNonQuery();

            comando.Dispose();
            conection.Close();

            return;
        }
コード例 #2
0
        public CajaGeneral LocalizarNuevoSaldo(string de)
        {
            string[] data  = de.Split('/');
            string   fecha = de;

            if (data.Length > 1)
            {
                fecha = String.Format("{0}-{1}-{2}", data[2].Substring(0, 4), data[1], data[0]);
            }

            CajaGeneral cg = new CajaGeneral();

            MySqlConnection cmd = Conexion.ObtenerConexion();

            MySqlCommand    comando = new MySqlCommand(String.Format("select * from cajageneral where fechaSaldo >= '{0}' limit 1;", fecha), cmd);
            MySqlDataReader cods    = comando.ExecuteReader();

            while (cods.Read())
            {
                cg.IdCaja     = cods.GetInt32(0);
                cg.FechaSaldo = cods.GetString(1);
                cg.Saldo      = cods.GetDecimal(2);
            }

            cmd.Close();

            return(cg);
        }
コード例 #3
0
        public int Insertar(CajaGeneral cg)
        {
            string vl = cg.Saldo.ToString("N2");
            string vr = cg.Saldo.ToString();

            decimal v1 = Convert.ToDecimal(vl, CultureInfo.CreateSpecificCulture("es-ES"));

            vl = vl.Replace(',', '.');
            vr = vr.Replace(',', '.');

            string f = String.Format("{0}-{1}-{2}", cg.FechaSaldo.Substring(6), cg.FechaSaldo.Substring(3, 2), cg.FechaSaldo.Substring(0, 2));

            MySqlConnection conection = Conexion.ObtenerConexion();
            MySqlCommand    comando   = new MySqlCommand(string.Format("Insert into cajageneral (fechaSaldo, saldo) values ('{0}','{1}')",
                                                                       f, vr), conection);

            int retorno = comando.ExecuteNonQuery();

            comando.Dispose();
            conection.Close();

            return(retorno);
        }