本文整理汇总了C#中Connection.getConnection方法的典型用法代码示例。如果您正苦于以下问题：C# Connection.getConnection方法的具体用法？C# Connection.getConnection怎么用？C# Connection.getConnection使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Connection的用法示例。
在下文中一共展示了Connection.getConnection方法的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: buscar
public List<Cliente> buscar(String nome)
{
Connection con = new Connection();
con.openConnection();
SqlCommand command = new SqlCommand();
SqlDataReader reader;
string sql = "SELECT * FROM Clientes where Nome LIKE '%" + nome + "%'";
command.CommandText = sql;
command.CommandType = CommandType.Text;
command.Connection = con.getConnection();
reader = command.ExecuteReader();
List<Cliente> listaClientes = new List<Cliente>();
while (reader.Read())
{
Cliente cliente = new Cliente();
cliente.id_cliente = Int32.Parse(string.Format("{0}", reader[0]));
cliente.nome = string.Format("{0}", reader[1]);
cliente.cpf = string.Format("{0}", reader[2]);
cliente.saldo = double.Parse(string.Format("{0}", reader[3]));
listaClientes.Add(cliente);
}
con.closeConnection();
return listaClientes;
}示例2: buscar
public List<Mensalista> buscar(String nomeCliente)
{
Connection con = new Connection();
con.openConnection();
SqlCommand command = new SqlCommand();
SqlDataReader reader;
string sql = "SELECT * FROM Mensalistas m INNER JOIN Clientes c ON m.Id_cliente = c.Id_Cliente WHERE c.Nome like '%"+ nomeCliente +"%'";
command.CommandText = sql;
command.CommandType = CommandType.Text;
command.Connection = con.getConnection();
reader = command.ExecuteReader();
List<Mensalista> listaMensalistas = new List<Mensalista>();
while (reader.Read())
{
Mensalista mensalista = new Mensalista();
mensalista.id_mensalista = Int32.Parse(string.Format("{0}", reader[0]));
mensalista.id_cliente = Int32.Parse(string.Format("{0}", reader[1]));
Cliente cliente = new Cliente();
cliente.nome = string.Format("{0}", reader[4]);
mensalista.nome_cliente = cliente.nome;
mensalista.data_termino = string.Format("{0}", reader[2]);
listaMensalistas.Add(mensalista);
}
con.closeConnection();
return listaMensalistas;
}示例3: buscar
public List<Carro> buscar(String nome)
{
Connection con = new Connection();
con.openConnection();
SqlCommand command = new SqlCommand();
SqlDataReader reader;
string sql = "SELECT * FROM Carro where modelo LIKE '%" + nome + "%' OR marca LIKE '%" + nome + "%'";
command.CommandText = sql;
command.CommandType = CommandType.Text;
command.Connection = con.getConnection();
reader = command.ExecuteReader();
List<Carro> listaCarros = new List<Carro>();
while (reader.Read())
{
Carro carro = new Carro();
carro.id_carro = Int32.Parse(string.Format("{0}", reader[0]));
carro.modelo = string.Format("{0}", reader[1]);
carro.marca = string.Format("{0}", reader[2]);
carro.cor = string.Format("{0}", reader[3]);
listaCarros.Add(carro);
}
con.closeConnection();
return listaCarros;
}示例4: editar
public Boolean editar(Mensalista mensalista)
{
Connection con = new Connection();
con.openConnection();
SqlCommand command = new SqlCommand();
String sql = "UPDATE Mensalistas set Data_termino ='" + mensalista.data_termino +"' where Id_Mensalista = "+mensalista.id_mensalista;
command.CommandText = sql;
command.CommandType = CommandType.Text;
command.Connection = con.getConnection();
command.ExecuteNonQuery();
con.closeConnection();
return true;
}示例5: editar
public Boolean editar(Carro carro)
{
Connection con = new Connection();
con.openConnection();
SqlCommand command = new SqlCommand();
String sql = "UPDATE Carro set marca='" + carro.marca + "', modelo ='" + carro.modelo + "', cor = '" + carro.cor + "' where ID_carro = " + carro.id_carro;
command.CommandText = sql;
command.CommandType = CommandType.Text;
command.Connection = con.getConnection();
command.ExecuteNonQuery();
con.closeConnection();
return true;
}示例6: editar
public Boolean editar(Ticket ticket, Carro carro, Cliente cliente, Servicos servico)
{
Connection con = new Connection();
con.openConnection();
SqlCommand command = new SqlCommand();
String sql = "UPDATE Tickets SET Id_cliente = " + cliente.id_cliente + ", id_Carro = " + carro.id_carro + ", Id_Servico = " + servico.id_servico + ", DataEntrada = '" + ticket.data_entrada + "', DataSaida = '" + ticket.data_saida + "', ValorTotal = " + ticket.valorTotal + ", Placa = '" + ticket.placa + "', UF = '" + ticket.uf + "', Cidade = '" + ticket.cidade + "'";
command.CommandText = sql;
command.CommandType = CommandType.Text;
command.Connection = con.getConnection();
command.ExecuteNonQuery();
con.closeConnection();
return true;
}示例7: deletar
public Boolean deletar(Mensalista mensalista)
{
Connection con = new Connection();
con.openConnection();
SqlCommand command = new SqlCommand();
SqlDataReader reader;
string sql = "DELETE Mensalistas WHERE Id_Mensalista = " + mensalista.id_mensalista;
command.CommandText = sql;
command.CommandType = CommandType.Text;
command.Connection = con.getConnection();
reader = command.ExecuteReader();
con.closeConnection();
return true;
}示例8: deletar
public Boolean deletar(Carro carro)
{
Connection con = new Connection();
con.openConnection();
SqlCommand command = new SqlCommand();
SqlDataReader reader;
string sql = "DELETE Carro WHERE ID_carro = " + carro.id_carro;
command.CommandText = sql;
command.CommandType = CommandType.Text;
command.Connection = con.getConnection();
reader = command.ExecuteReader();
con.closeConnection();
return true;
}示例9: deletar
public Boolean deletar(Ticket ticket)
{
Connection con = new Connection();
con.openConnection();
SqlCommand command = new SqlCommand();
SqlDataReader reader;
string sql = "DELETE Tickets WHERE ID_ticket = " + ticket.id_ticket;
command.CommandText = sql;
command.CommandType = CommandType.Text;
command.Connection = con.getConnection();
reader = command.ExecuteReader();
con.closeConnection();
return true;
}示例10: buscar
public List<Ticket> buscar(String placa)
{
Connection con = new Connection();
con.openConnection();
SqlCommand command = new SqlCommand();
SqlDataReader reader;
string sql = "SELECT * FROM Tickets WHERE placa LIKE '%" + placa + "%' ORDER BY DataEntrada";
command.CommandText = sql;
command.CommandType = CommandType.Text;
command.Connection = con.getConnection();
reader = command.ExecuteReader();
List<Ticket> listaTickets = new List<Ticket>();
while (reader.Read())
{
Ticket ticket = new Ticket();
//Ticket
ticket.id_ticket = int.Parse(string.Format("{0}", reader[0]));
//Cliente
ticket.id_cliente = int.Parse(string.Format("{0}", reader[1]));
//Carro
ticket.id_carro = Convert.ToInt32(string.Format("{0}", reader["id_Carro"]));
//Servico
ticket.id_servico = int.Parse(string.Format("{0}", reader["Id_Servico"]));
//Ticket
ticket.data_entrada = Convert.ToDateTime(reader["DataEntrada"]).ToString("dd/MM/yyyy HH:mm");
ticket.data_saida = Convert.ToDateTime(reader["DataSaida"]).ToString("dd/MM/yyyy HH:mm");
ticket.valorTotal = Convert.ToDouble(string.Format("{0}", reader[6]));
//Placa carro
ticket.placa = string.Format("{0}", reader[7]);
ticket.uf = string.Format("{0}", reader[8]);
ticket.cidade = string.Format("{0}", reader[9]);
listaTickets.Add(ticket);
}
con.closeConnection();
return listaTickets;
}示例11: getCarrobyId
public Carro getCarrobyId(Carro carro)
{
Connection con = new Connection();
con.openConnection();
SqlCommand command = new SqlCommand();
SqlDataReader reader;
string sql = "SELECT * FROM Carro where ID_carro =" + carro.id_carro;
command.CommandText = sql;
command.CommandType = CommandType.Text;
command.Connection = con.getConnection();
reader = command.ExecuteReader();
Carro returnCarro = new Carro();
while (reader.Read())
{
returnCarro.id_carro = Int32.Parse(string.Format("{0}", reader[0]));
returnCarro.modelo = string.Format("{0}", reader[1]);
returnCarro.marca = string.Format("{0}", reader[2]);
returnCarro.cor = string.Format("{0}", reader[3]);
return returnCarro;
}
con.closeConnection();
return returnCarro;
}示例12: buscarTicket
public List<Cliente> buscarTicket(Boolean mensalista,String busca)
{
Connection con = new Connection();
con.openConnection();
SqlCommand command = new SqlCommand();
SqlDataReader reader;
string sql = "";
if (mensalista == true)
{
sql = "SELECT C.Id_Cliente,C.Nome,C.Cpf,C.Saldo FROM Ticketcar.dbo.Clientes AS C LEFT JOIN Ticketcar.dbo.Mensalistas AS M ON C.Id_Cliente = M.Id_cliente WHERE M.Id_cliente IS NOT NULL AND DAY(M.Data_termino) = DAY(GETDATE()) AND C.Nome LIKE '%" + busca + "%'";
}
else
{
sql = "SELECT C.Id_Cliente,C.Nome,C.Cpf,C.Saldo FROM Ticketcar.dbo.Clientes AS C LEFT JOIN Ticketcar.dbo.Mensalistas AS M ON C.Id_Cliente = M.Id_cliente WHERE M.Id_cliente IS NULL AND C.Nome LIKE '%" + busca+"%'";
}
command.CommandText = sql;
command.CommandType = CommandType.Text;
command.Connection = con.getConnection();
reader = command.ExecuteReader();
List<Cliente> listaClientes = new List<Cliente>();
while (reader.Read())
{
Cliente cliente = new Cliente();
cliente.id_cliente = Int32.Parse(string.Format("{0}", reader[0]));
cliente.nome = string.Format("{0}", reader[1]);
cliente.cpf = string.Format("{0}", reader[2]);
cliente.saldo = double.Parse(string.Format("{0}", reader[3]));
listaClientes.Add(cliente);
}
con.closeConnection();
return listaClientes;
}示例13: getTicketbyId
public Ticket getTicketbyId(Ticket ticket)
{
Connection con = new Connection();
con.openConnection();
SqlCommand command = new SqlCommand();
SqlDataReader reader;
string sql = "SELECT T.ID_ticket,Cl.Id_Cliente,Cl.Nome,Cl.Cpf,Ca.ID_carro,Ca.Marca,Ca.Modelo,T.Placa,T.UF,T.Cidade,S.ID_servico,S.Descricao,S.Preco,T.DataEntrada,T.DataSaida,T.ValorTotal FROM ticketcar.dbo.Tickets AS T INNER JOIN Clientes AS Cl ON T.Id_cliente = Cl.Id_Cliente INNER JOIN Carro AS Ca ON T.id_Carro = Ca.ID_carro INNER JOIN Servicos AS S ON T.Id_Servico = S.ID_servico WHERE T.ID_ticket =" + ticket.id_ticket;
command.CommandText = sql;
command.CommandType = CommandType.Text;
command.Connection = con.getConnection();
reader = command.ExecuteReader();
Ticket returnTicket = new Ticket();
while (reader.Read())
{
//Ticket
ticket.id_ticket = int.Parse(string.Format("{0}", reader[0]));
//Cliente
ticket.id_cliente = int.Parse(string.Format("{0}", reader[1]));
//Carro
ticket.id_carro = Convert.ToInt32(string.Format("{0}", reader["id_Carro"]));
//Servico
ticket.id_servico = int.Parse(string.Format("{0}", reader["Id_Servico"]));
//Ticket
ticket.data_entrada = Convert.ToDateTime(reader["DataEntrada"]).ToString("dd/MM/yyyy HH:mm");
ticket.data_saida = Convert.ToDateTime(reader["DataSaida"]).ToString("dd/MM/yyyy HH:mm");
ticket.valorTotal = Convert.ToDouble(string.Format("{0}", reader[6]));
//Placa carro
ticket.placa = string.Format("{0}", reader[7]);
ticket.uf = string.Format("{0}", reader[8]);
ticket.cidade = string.Format("{0}", reader[9]);
return returnTicket;
}
con.closeConnection();
return returnTicket;
}示例14: inserir
public Boolean inserir(Mensalista mensalista)
{
Connection con = new Connection();
con.openConnection();
SqlCommand command = new SqlCommand();
string sql = "INSERT INTO Mensalistas (Id_cliente, Data_termino) VALUES(" + mensalista.id_cliente + ",'" + mensalista.data_termino + "')";
command.CommandText = sql;
command.CommandType = CommandType.Text;
command.Connection = con.getConnection();
command.ExecuteNonQuery();
con.closeConnection();
return true;
}示例15: deletar
public Boolean deletar(Cliente cliente)
{
Connection con = new Connection();
con.openConnection();
SqlCommand command = new SqlCommand();
SqlDataReader reader;
string sql = "DELETE Clientes WHERE Id_cliente = " + cliente.id_cliente;
command.CommandText = sql;
command.CommandType = CommandType.Text;
command.Connection = con.getConnection();
reader = command.ExecuteReader();
con.closeConnection();
return true;
}