public Decimal SumaVentaEfectivoCaja(Int32 codSuc, DateTime fech1, Int32 codigocaja) { Decimal total = 0; try { con.conectarBD(); cmd = new MySqlCommand("SumaVentasEfectivoDia", con.conector); cmd.Parameters.AddWithValue("codSucur", codSuc); cmd.Parameters.AddWithValue("fecha1", fech1); cmd.Parameters.AddWithValue("codcaja_ex", codigocaja); cmd.CommandType = CommandType.StoredProcedure; dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { total = Convert.ToDecimal(dr.GetDecimal(0)); } } return(total); } catch (MySqlException ex) { throw ex; } finally { con.conector.Dispose(); cmd.Dispose(); con.desconectarBD(); } }
public Details RetreiveProductDetails(int ProductID) { Details ProductDetails = new Details(); using (MySqlConnection connection = new MySqlConnection(ConnectionString)) { MySqlCommand command = new MySqlCommand("SELECT ProductName, Price, ProductDetail FROM products where ProductID = '" + ProductID + "';", connection); connection.Open(); MySqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { ProductDetails.Name = reader.GetString(0); ProductDetails.Price = reader.GetDecimal(1); ProductDetails.Picture = (byte[])reader[2]; } } reader.Close(); return(ProductDetails); } }
public ArrayList RetreiveSaleItems(int SaleID) { ArrayList ProductsList = new ArrayList(); using (MySqlConnection connection = new MySqlConnection(ConnectionString)) { MySqlCommand command = new MySqlCommand("SELECT ProductID, Price, Quantity FROM sale_details where SaleID = '" + SaleID + "';", connection); connection.Open(); MySqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { string ProductID = reader.GetString(0); decimal ProductPrice = reader.GetDecimal(1); int ProductQuantity = reader.GetInt32(2); string ProductName = this.ReturnProductName(ProductID); ProductsList.Add(new Details() { Name = ProductName, Price = ProductPrice, Quantity = ProductQuantity }); } } reader.Close(); return(ProductsList); } }
public List <ProdutoVendaDTO> Consultar() { string script = @"SELECT * FROM tb_produtoVenda"; List <MySqlParameter> parms = new List <MySqlParameter>(); Database db = new Database(); MySqlDataReader reader = db.ExecuteSelectScript(script, parms); List <ProdutoVendaDTO> produtos = new List <ProdutoVendaDTO>(); while (reader.Read()) { ProdutoVendaDTO produto = new ProdutoVendaDTO(); produto.id_produtoVenda = reader.GetInt32("id_produtoVenda"); produto.nm_Produto = reader.GetString("nm_Produto"); produto.ds_Produto = reader.GetString("ds_Produto"); produto.vl_Venda = reader.GetDecimal("vl_Venda"); produto.dt_Validade = reader.GetDateTime("dt_Validade"); produto.fk_ProdutoVenda_Filial = reader.GetInt32("fk_ProdutoVenda_Filial"); produtos.Add(produto); } reader.Close(); return(produtos); }
private void confirmButton_Click(object sender, EventArgs e) { if (nameText.Text != "" && nativeText.Text != "" && pwdText.Text != "" && (occupText.Text == "receiver" || occupText.Text == "deliver" || occupText.Text == "adminer" || occupText.Text == "warehourser" ) && phoneText.Text != "" && (genderText.Text == "M" || genderText.Text == "F") ) { MySqlCommand com = new MySqlCommand("select count(*) from worker", Login.con); com.ExecuteNonQuery(); MySqlDataReader dataReader = com.ExecuteReader(); dataReader.Read(); Decimal workerId = dataReader.GetDecimal(0); dataReader.Close(); string insertStatement = "insert into worker values(\"" + workerId.ToString() + "\", \"" + pwdText.Text + "\", \"" + nameText.Text + "\", \"" + birthText.Value + "\",\"" + nativeText.Text + "\",\"" + genderText.Text + "\",\"" + occupText.Text + "\",\"" + phoneText.Text + "\",\"" + adminText.Value + "\")"; com = new MySqlCommand(insertStatement, Login.con); com.ExecuteNonQuery(); MetroFramework.MetroMessageBox.Show(this, "新建员工的编号为 " + workerId.ToString(), "插入员工成功"); } else { MetroFramework.MetroMessageBox.Show(this, "选项填写不完整,请填写完整!", "注册失败", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
public Product GetProduct(int id) { MySqlConnection conn = new MySqlConnection(connectionString); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "SELECT * FROM Products WHERE ProductID = @id;"; cmd.Parameters.AddWithValue("id", id); using (conn) { conn.Open(); MySqlDataReader reader = cmd.ExecuteReader(); var product = new Product(); while (reader.Read() == true) { product.ID = reader.GetInt32("ProductID"); product.Name = reader.GetString("Name"); product.Price = reader.GetDecimal("Price"); product.CategoryID = reader.GetInt32("OnSale"); if (reader.IsDBNull(reader.GetOrdinal("StockLevel"))) { product.StockLevel = null; } else { product.StockLevel = reader.GetString("StockLevel"); } } return(product); } }
public List <EventoDTO> Listar() { string script = @"SELECT * FROM tb_Evento"; List <MySqlParameter> parms = new List <MySqlParameter>(); Database db = new Database(); MySqlDataReader reader = db.ExecuteSelectScript(script, parms); List <EventoDTO> lista = new List <EventoDTO>(); while (reader.Read()) { EventoDTO dto = new EventoDTO(); dto.id = reader.GetInt32("id_Evento"); dto.Nome = reader.GetString("nm_NomeEvento"); dto.Local = reader.GetString("nm_Local"); dto.Data = reader.GetDateTime("dt_Data"); dto.Horario = reader.GetString("dt_Horário"); dto.Valor = reader.GetDecimal("vl_Preco"); dto.Descricao = reader.GetString("ds_Descricao"); dto.Quantidade = reader.GetInt32("ds_Quantidade"); dto.Estoque = reader.GetInt32("tb_Estoque_id_Estoque"); dto.Funcionario = reader.GetInt32("tb_Funcionario_id_Funcionario"); dto.Cliente = reader.GetInt32("tb_Cliente_id_Cliente"); lista.Add(dto); } reader.Close(); return(lista); }
public static List <ProductoEstado> ObtenerProductosEstado()//sin estado { List <ProductoEstado> _lista = new List <ProductoEstado>(); MySqlConnection conexion = bdComun.obtenerConexion(); MySqlCommand _comando = new MySqlCommand(String.Format( "SELECT * FROM producto where ESTADO=1"), conexion); MySqlDataReader _reader = _comando.ExecuteReader(); while (_reader.Read()) { ProductoEstado pProducto = new ProductoEstado(); pProducto.COD = _reader.GetString(0); pProducto.NOMBRE = _reader.GetString(1); pProducto.DESCRIPCION = _reader.GetString(2); pProducto.CATEGORIA = _reader.GetString(3); pProducto.SUBCATEGORIA = _reader.GetString(4); pProducto.EXISTENCIA = _reader.GetInt32(5); pProducto.PRECIO = _reader.GetDecimal(6); //pProducto.ESTADO = _reader.GetInt32(7); _lista.Add(pProducto); } conexion.Close(); return(_lista); }
public ItemDTO ConsultarProTxt(string nome, int fornecedor) { string script = @"SELECT * FROM tb_item WHERE nm_item LIKE @nm_item AND id_fornecedor LIKE @id_fornecedor"; List <MySqlParameter> parms = new List <MySqlParameter>(); parms.Add(new MySqlParameter("nm_item", nome + "%")); parms.Add(new MySqlParameter("id_fornecedor", fornecedor + "%")); Database db = new Database(); MySqlDataReader reader = db.ExecuteSelectScript(script, parms); ItemDTO dto = null; while (reader.Read()) { dto = new ItemDTO(); dto.Id = reader.GetInt32("id_item"); dto.Nome = reader.GetString("nm_item"); dto.FornecedorId = reader.GetInt32("id_fornecedor"); dto.Preco = reader.GetDecimal("vl_preco"); dto.Descricao = reader.GetString("ds_item"); } reader.Close(); return(dto); }
public List <VwConsultarFolhapagamento> Consultarmes(string mes) { string script = @"SELECT * FROM vw_consultar_folhapagamento WHERE ds_mes like @ds_mes"; List <SqlParameter> parms = new List <SqlParameter>(); parms.Add(new SqlParameter("ds_mes", "%" + mes + "%")); Database db = new Database(); MySqlDataReader reader = db.ExecuteSelectScript(script, parms); List <VwConsultarFolhapagamento> folhas = new List <VwConsultarFolhapagamento>(); while (reader.Read()) { VwConsultarFolhapagamento dto = new VwConsultarFolhapagamento(); dto.Nome = reader.GetString("nm_nome"); dto.Departamento = reader.GetString("ds_dpto"); dto.Mês = reader.GetString("ds_mes"); dto.SalarioLiquido = reader.GetDecimal("vl_salarioliquido"); folhas.Add(dto); } reader.Close(); return(folhas); }
public static List <Producto> ObtenerPorFiltro(string pId, string pNombre, string pDescripcion, string pCategoria, string pSubcategoria) { List <Producto> _lista = new List <Producto>(); MySqlConnection conexion = bdComun.obtenerConexion(); MySqlCommand _comando = new MySqlCommand(String.Format("SELECT * FROM sercordb.producto where ID_PRODUCTO='{0}' or NOMBRE='{1}' or DESCRIPCION='{2}' or CATEGORIA='{3}' or SUBCATEGORIA='{4}'", pId, pNombre, pDescripcion, pCategoria, pSubcategoria), conexion); MySqlDataReader _reader = _comando.ExecuteReader(); while (_reader.Read()) { Producto pProducto = new Producto(); pProducto.COD = _reader.GetString(0); pProducto.NOMBRE = _reader.GetString(1); pProducto.DESCRIPCION = _reader.GetString(2); pProducto.CATEGORIA = _reader.GetString(3); pProducto.SUBCATEGORIA = _reader.GetString(4); pProducto.EXISTENCIA = _reader.GetInt32(5); pProducto.PRECIO = _reader.GetDecimal(6); pProducto.ESTADO = _reader.GetInt32(7); _lista.Add(pProducto); } conexion.Close(); return(_lista); }
/// <summary> /// 测试用户的合法性 /// </summary> /// <param name="vAIS_Users"></param> /// <returns></returns> public Model.v_UserInfos TestUser(Model.v_UserInfos vUser) { Model.v_UserInfos users = null; StringBuilder sql = new StringBuilder(); sql.Append("select UserID,UserAccount,UserName From UserInfos "); sql.Append(" where UserAccount=@UserAccount and UserPassword=@UserPassword "); MySqlParameter[] paras = new MySqlParameter[]{ new MySqlParameter("@UserAccount",vUser.UserAccount), new MySqlParameter("@UserPassword",vUser.UserPassword) }; using (MySqlDataReader reader = db.getSelectData(sql.ToString(), paras)) { if (reader.Read()) { users = new Model.v_UserInfos(); users.UserID = reader.GetDecimal(0); users.UserAccount = reader.GetString(1); users.UserName = reader.GetString(2); } reader.Close(); return users; } }
/// <summary> /// 查询信息 /// </summary> /// <param name="v">查询条件</param> /// <param name="pageIndex">页数</param> /// <param name="pageSize">页大小</param> /// <param name="recordCount">返回记录数</param> /// <returns></returns> public List<Model.v_UserInfos> querying(Condition.SystemuserCondition v, int pageIndex, int pageSize, out int recordCount) { StringBuilder sql = new StringBuilder(); sql.Append("Select UserID,UserAccount,UserPassword,UserName,UserType From UserInfos "); sql.Append(" Where 1=1 "); if (!string.IsNullOrEmpty(v.UserName)) { sql.Append(" and UserName Like '%" + v.UserName + "%'"); } using (MySqlDataReader reader = db.Paging(sql.ToString(), pageIndex, pageSize, out recordCount)) { List<Model.v_UserInfos> result = new List<Model.v_UserInfos>(); while (reader.Read()) { result.Add(new Model.v_UserInfos() { UserID = reader.GetDecimal(0), UserAccount = reader.GetString(1), UserPassword = reader.GetString(2), UserName = reader.GetString(3), UserType = reader.GetString(4) }); } reader.Close(); return result; } }
public Decimal traersaldo() { Decimal saldo = 0; try { con.conectarBD(); cmd = new MySqlCommand("traersaldoCajaChica", con.conector); //cmd.Parameters.AddWithValue("codAlma", codAlmacen); cmd.CommandType = CommandType.StoredProcedure; dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { saldo = Convert.ToDecimal(dr.GetDecimal(0)); } } return(saldo); } catch (MySqlException ex) { throw ex; } finally { con.conector.Dispose(); cmd.Dispose(); con.desconectarBD(); } }
private Customer GetMoney(MySqlDataReader reader) { Customer customer = new Customer(); customer.Money = reader.GetDecimal("Money"); return(customer); }
public List <ItemView> Consultar(string nome, string fornecedor) { string script = @"SELECT * FROM tb_item WHERE nm_item LIKE @nm_item AND nm_fornecedor LIKE @nm_fornecedor"; List <MySqlParameter> parms = new List <MySqlParameter>(); parms.Add(new MySqlParameter("nm_item", nome + "%")); Database db = new Database(); MySqlDataReader reader = db.ExecuteSelectScript(script, parms); List <ItemView> lista = new List <ItemView>(); while (reader.Read()) { ItemView dto = new ItemView(); dto.Id = reader.GetInt32("id_item"); dto.Nome = reader.GetString("nm_item"); dto.Fornecedor = reader.GetString("nm_fornecedor"); dto.Preco = reader.GetDecimal("vl_preco"); dto.Descricao = reader.GetString("ds_item"); lista.Add(dto); } reader.Close(); return(lista); }
public List <Book> GetAllFilms() { List <Book> list = new List <Book>(); using (MySqlConnection conn = GetConnection()) { conn.Open(); MySqlCommand cmd = new MySqlCommand("SELECT * FROM books", conn); using (MySqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { list.Add(new Book() { ID = reader.GetInt32("ID"), Title = reader.GetString("title"), Author = reader.GetString("author"), ReleaseDate = reader.GetDateTime("releasedate"), Price = reader.GetDecimal("price"), Rating = reader.GetString("rating") }); } } } return(list); }
public SFamilhaDTO Consultar(decimal salario) { string script = @"SELECT * FROM tb_salarioFamilia WHERE ds_salFamilia = @ds_salFamilia"; Database db = new Database(); List <MySqlParameter> parms = new List <MySqlParameter>(); parms.Add(new MySqlParameter("ds_salFamilia", salario)); MySqlDataReader reader = db.ExecuteSelectScript(script, parms); SFamilhaDTO add = null; if (reader.Read()) { add = new SFamilhaDTO(); add.Id = reader.GetInt32("id_salFamilia"); add.SalFamilia = reader.GetDecimal("ds_salFamilia"); add.Valor = reader.GetInt32("vl_salFamilia"); } reader.Close(); return(add); }
public List <Product> GetOnSaleProducts() { MySqlConnection conn = new MySqlConnection(connectionString); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "SELECT * FROM Products WHERE OnSale = 1;"; using (conn) { conn.Open(); MySqlDataReader reader = cmd.ExecuteReader(); List <Product> allProducts = new List <Product>(); while (reader.Read() == true) { var currentProduct = new Product(); currentProduct.ID = reader.GetInt32("ProductID"); currentProduct.Name = reader.GetString("Name"); currentProduct.Price = reader.GetDecimal("Price"); currentProduct.OnSale = reader.GetInt32("OnSale"); currentProduct.StockLevel = reader.GetString("OnSale"); currentProduct.CategoryID = reader.GetInt32("CategoryID"); allProducts.Add(currentProduct); } return(allProducts); } }
public List <TratamentoDTO> Listar() { string script = @"SELECT * FROM tratamentos"; List <MySqlParameter> parms = new List <MySqlParameter>(); Database db = new Database(); MySqlDataReader reader = db.ExecuteSelectScript(script, parms); List <TratamentoDTO> lista = new List <TratamentoDTO>(); while (reader.Read()) { TratamentoDTO dto = new TratamentoDTO(); dto.ID = reader.GetInt32("id_tratamentos"); dto.Nome = reader.GetString("nm_tratamento"); dto.Valor = reader.GetDecimal("ds_valor"); dto.Duracao = reader.GetInt32("duracao"); dto.descricao = reader.GetString("tratamentoscol"); lista.Add(dto); } reader.Close(); return(lista); }
public List <Product> GetProducts() { MySqlConnection conn = new MySqlConnection(connString); using (conn) { conn.Open(); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "SELECT ProductID, Name, Price, StockLevel FROM products;"; MySqlDataReader reader = cmd.ExecuteReader(); var products = new List <Product>(); while (reader.Read()) { var row = new Product(); row.ProductID = reader.GetInt32("ProductID"); row.Name = reader.GetString("Name"); row.Price = reader.GetDecimal("Price"); row.StockLevel = reader.GetInt32("StockLevel"); products.Add(row); } return(products); } }
public static List <ClsCmdFournisseur> ResultatSommeCmdFournisseurSql(string _RequeteSql) { List <ClsCmdFournisseur> cliste = new List <ClsCmdFournisseur>(); using (MySqlConnection cn = new MySqlConnection(_cs)) { cn.Open(); using (MySqlCommand cmd = new MySqlCommand(_RequeteSql, cn)) { MySqlDataReader rd = cmd.ExecuteReader(); if (rd.HasRows) { while (rd.Read()) { ClsCmdFournisseur lg = new ClsCmdFournisseur(); try { lg.Somme = rd.GetDecimal(rd.GetOrdinal("somme")); } catch (Exception) { lg.Somme = 0; } cliste.Add(lg); } } rd.Close(); } cn.Close(); } return(cliste); }
public ProdutoVendaDTO ConsultarPorId(int idProduto) { string script = @"SELECT * FROM tb_produtoVenda WHERE id_produtoVenda = @id_produtoVenda"; List <MySqlParameter> parms = new List <MySqlParameter>(); parms.Add(new MySqlParameter("id_produtoVenda", idProduto)); Database db = new Database(); MySqlDataReader reader = db.ExecuteSelectScript(script, parms); ProdutoVendaDTO produto = new ProdutoVendaDTO(); if (reader.Read()) { produto.id_produtoVenda = reader.GetInt32("id_produtoVenda"); produto.nm_Produto = reader.GetString("nm_Produto"); produto.ds_Produto = reader.GetString("ds_Produto"); produto.vl_Venda = reader.GetDecimal("vl_Venda"); produto.dt_Validade = reader.GetDateTime("dt_Validade"); produto.fk_ProdutoVenda_Filial = reader.GetInt32("fk_ProdutoVenda_Filial"); } reader.Close(); return(produto); }
public Product GetProduct(int id) { MySqlConnection conn = new MySqlConnection(); conn.ConnectionString = System.IO.File.ReadAllText("ConnectionString.txt"); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "SELECT ProductID, Name, Price " + "FROM products " + "WHERE ProductId = @id;"; cmd.Parameters.AddWithValue("id", id); using (conn) { conn.Open(); MySqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { Product product = new Product(); product.Id = reader.GetInt32("ProductID"); product.Name = reader.GetString("Name"); product.Price = reader.GetDecimal("Price"); return(product); } else { return(null); } } }
public ArrayList RetreiveProductsFromDatabase() { ArrayList ProductsList = new ArrayList(); using (MySqlConnection connection = new MySqlConnection(ConnectionString)) { MySqlCommand command = new MySqlCommand("SELECT ProductID, ProductName, Price, ProductDetail FROM products ;", connection); connection.Open(); MySqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { int ProductID = reader.GetInt32(0); string ProductName = reader.GetString(1); decimal ProductPrice = reader.GetDecimal(2); byte[] ProductPicture = (byte[])reader[3]; ProductsList.Add(new Details() { ID = ProductID, Name = ProductName, Price = ProductPrice, Picture = ProductPicture }); } } reader.Close(); return(ProductsList); } }
public static User convertDBtoUserWithManager(MySqlDataReader readerRow) { return(new User() { UserId = readerRow.GetInt32(0), UserName = readerRow.GetString(1), UserComputer = readerRow.IsDBNull(2) ? "" : readerRow.GetString(2), DepartmentId = readerRow.GetInt32(4), Email = readerRow.GetString(5), NumHoursWork = readerRow.GetDecimal(6), ManagerId = readerRow.IsDBNull(7) ? 0 : readerRow.GetInt32(7), DepartmentUser = new Models.DepartmentUser() { Id = readerRow.GetInt32(8), Department = readerRow.GetString(9) } , Manager = new User() { UserId = readerRow.IsDBNull(10) ? 0 : readerRow.GetInt32(10), UserName = readerRow.IsDBNull(11) ? string.Empty : readerRow.GetString(11), Email = readerRow.IsDBNull(15) ? string.Empty : readerRow.GetString(15) } }); }
public ArrayList RetreiveAllSales() { ArrayList SalesList = new ArrayList(); using (MySqlConnection connection = new MySqlConnection(ConnectionString)) { MySqlCommand command = new MySqlCommand("SELECT SaleID, SaleDateTime, StaffID, GrandTotal FROM sales;", connection); connection.Open(); MySqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { int SaleID = reader.GetInt32(0); DateTime SaleTime = reader.GetDateTime(1); int SalesmanID = reader.GetInt32(2); string SalesmanName = ReturnUserName(SalesmanID); decimal TotalBill = reader.GetDecimal(3); SalesList.Add(new Details() { SaleID = SaleID, SaleTime = SaleTime, Name = SalesmanName, Total = TotalBill }); } } reader.Close(); return(SalesList); } }
public List <Product> GetAllProducts() { MySqlConnection conn = new MySqlConnection(); conn.ConnectionString = System.IO.File.ReadAllText("ConnectionString.txt"); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "SELECT ProductID, Name, Price FROM products;"; using (conn) { conn.Open(); MySqlDataReader reader = cmd.ExecuteReader(); List <Product> products = new List <Product>(); while (reader.Read()) { Product nextProduct = new Product(); nextProduct.Id = reader.GetInt32("ProductID"); nextProduct.Name = reader.GetString("Name"); nextProduct.Price = reader.GetDecimal("Price"); products.Add(nextProduct); } return(products); } }
public ArrayList RetreiveAllProducts() { ArrayList ProductsList = new ArrayList(); using (MySqlConnection connection = new MySqlConnection(ConnectionString)) { MySqlCommand command = new MySqlCommand("SELECT ProductID, ProductName, ProductPrice, ProductCategoryID, ProductDescription, ProductImage FROM products;", connection); connection.Open(); MySqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { int ProductID = reader.GetInt32(0); string ProductName = reader.GetString(1); decimal ProductPrice = reader.GetDecimal(2); int ProductCategoryID = reader.GetInt32(3); string ProductCategoryName = ReturnCategoryName(ProductCategoryID); string ProductDescription = reader.GetString(4); byte[] ProductPicture = (byte[])reader[5]; ProductsList.Add(new Details() { Name = ProductName, Price = ProductPrice, Category = ProductCategoryName, Description = ProductDescription, Picture = ProductPicture, ID = ProductID }); } } reader.Close(); return(ProductsList); } }
public clsCaja CargaCierreAnterior(Int32 iCodSucursal, Int32 tipocaja) { clsCaja aper = null; try { con.conectarBD(); cmd = new MySqlCommand("MuestraCierreAnterior", con.conector); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("codsuc", iCodSucursal); cmd.Parameters.AddWithValue("tipo_ex", tipocaja); dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { aper = new clsCaja(); aper.Montocierre = Convert.ToDecimal(dr.GetDecimal(0)); } } return(aper); } catch (MySqlException ex) { throw ex; } finally { con.conector.Dispose(); cmd.Dispose(); con.desconectarBD(); } }