public void AddCustomerContact(CustomerContact contact)
{
using (var connection = new SqlConnection(_connectionString))
{
connection.Open();
connection.Insert(CustomerContactTableName, ToKeyValuePairs(contact));
}
}
public void RemoveCustomerContact(CustomerContact contact)
{
using (var connection = new SqlConnection(_connectionString))
{
connection.Open();
connection.Delete(CustomerContactTableName, new KeyValuePair<string, object>("姓名", contact.姓名));
}
}
private static IEnumerable<KeyValuePair<string, object>> ToKeyValuePairs(CustomerContact contact)
{
return new Dictionary<string, object>
{
{"姓名", contact.姓名},
{"电话", contact.电话},
{"Email", contact.Email},
{"联系人类型", contact.联系人类型},
{"客户号", contact.客户号}
};
}
public void UpdateCustomerContact(CustomerContact contact)
{
using (var connection = new SqlConnection(_connectionString))
{
connection.Open();
connection.Update(CustomerContactTableName,
new KeyValuePair<string, object>("客户号", contact.客户号),
ToKeyValuePairs(contact));
}
}
