本文整理汇总了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;
}
}