房屋销售管理系统
一、HouseManagerDAL数据访问层中设计三个类：
CustomerService.cs和DBhelper.cs和houseserver.cs (1)在CustomerService.cs中 using System;
using System.Collections.Generic; using System.Text; using System.Data;
using System.Data.SqlClient; using HouseManager.Models; namespace HouseManager.DAL
{public static class CustomerService {/// 根据提供的登录账号查询用户信息
public static Customer GetCustomerByLoginName(string name) {
string sql = string.Format(\Customers where LoginName='{0}'\, name); return GetCustomerBySQL(sql); }
/// 根据用户ID查询用户信息
public static Customer GetCustomerById(int id)
{
string sql = string.Format(\Customers where CustomerId={0}\, id); return GetCustomerBySQL(sql); }
/// 私有方法，提供公共方法查询用户信息使用
private static Customer GetCustomerBySQL(string sql) {
using (SqlConnection conn = new SqlConnection(DBHelper.connectString)) {
Customer c = null; try {
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn); SqlDataReader sdr = cmd.ExecuteReader(); if (sdr.Read()) {
c = new Customer();
c.Id = (int)sdr[\]; c.LoginName = sdr[\].ToString();
c.Password = sdr[\].ToString(); } }
catch (Exception ex) {
Console.WriteLine(ex.Message); } finally {
conn.Close(); }
return c; } } } }
(2)在DBHelper中 using System;
using System.Collections.Generic; using System.Text;
namespace HouseManager.DAL {
public static class DBHelper {
public static readonly string connectString = \; } }
(3)在HouseService中 using System;
using System.Collections.Generic; using System.Text; using System.Data;
using System.Data.SqlClient; using HouseManager.Models; namespace HouseManager.DAL {
public static class HouseService {
/// 获取所有发布的房屋信息
public static IList
List
