本文整理匯總了C#中Cliente.SetId方法的典型用法代碼示例。如果您正苦於以下問題：C# Cliente.SetId方法的具體用法？C# Cliente.SetId怎麽用？C# Cliente.SetId使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Cliente的用法示例。
在下文中一共展示了Cliente.SetId方法的3個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的C#代碼示例。
示例1: BuscarPorCPF
public List<Cliente> BuscarPorCPF(string cpf)
{
MySqlDataReader reader = null;
List<Cliente> clientes = null;
string cmdText = "SELECT id, nome, cpf FROM cliente WHERE [email protected]";
using (MySqlCommand cmd = new MySqlCommand(cmdText, _con))
{
cmd.Prepare();
cmd.Parameters.AddWithValue("@cpf", cpf);
reader = cmd.ExecuteReader();
clientes = new List<Cliente>();
if (reader.HasRows)
{
while (reader.Read())
{
Cliente cliente = new Cliente();
cliente.SetId(reader.GetInt64("id"))
.SetNome(reader.GetString("nome"))
.SetCPF(reader.GetString("cpf"));
clientes.Add(cliente);
}
}
return clientes;
}
}示例2: BuscarPorId
public Cliente BuscarPorId(int id)
{
MySqlDataReader reader = null;
Cliente cliente = null;
string cmdText = @"SELECT id, nome,
cpf,
data_nascimento,
observacao,
situacao,
email,
logradouro,
numero,
complemento,
cep,
bairro,
uf,
cidade FROM cliente WHERE [email protected]";
using (MySqlCommand cmd = new MySqlCommand(cmdText, _con))
{
cmd.Prepare();
cmd.Parameters.AddWithValue("@id", id);
reader = cmd.ExecuteReader();
cliente = new Cliente();
while (reader.Read())
{
var isNull = reader.IsDBNull(reader.GetOrdinal("email"));
var t = reader.GetFieldValue<object>(reader.GetOrdinal("email"));
cliente.SetId(reader.GetInt64("id"))
.SetNome(reader.GetString("nome"))
.SetEmail(GetValue("email", reader) as string)
.SetCPF(reader.GetString("cpf"))
.SetDataNascimento(GetValue("data_nascimento", reader) as DateTime?)
.SetObservacao(GetValue("observacao", reader) as string)
.SetSituacao(reader.GetString("situacao"))
.SetEndereco(new Endereco()
.SetLogradouro(GetValue("logradouro", reader) as string)
.SetNumero(GetValue("numero", reader) as string)
.SetComplemento(GetValue("complemento", reader) as string)
.SetCep(GetValue("cep", reader) as string)
.SetBairro(GetValue("bairro", reader) as string)
.SetUf(GetValue("uf", reader) as string)
.SetCidade(GetValue("cidade", reader) as string));
}
reader.Close();
return cliente;
}
}示例3: BuscarTodos
public List<Cliente> BuscarTodos()
{
MySqlDataReader reader = null;
List<Cliente> clientes = new List<Cliente>();
string cmdText = "SELECT id, nome, cpf, situacao FROM cliente";
using (MySqlCommand cmd = new MySqlCommand(cmdText, _con))
{
reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
Cliente cliente = new Cliente();
cliente.SetId(reader.GetInt64("id"))
.SetNome(reader.GetString("nome"))
.SetCPF(reader.GetString("cpf"))
.SetSituacao(reader.GetString("situacao"));
clientes.Add(cliente);
}
}
return clientes;
}
}