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)); } }