(学生管理系统web程序设计代码.docVIP

房屋销售管理系统 一、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(select * from Customers where LoginName={0}, name); return GetCustomerBySQL(sql); } /// 根据用户ID查询用户信息 public static Customer GetCustomerById(int id) { string sql = string.Format(select * from 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[CustomerId]; c.LoginName = sdr[LoginName].ToString(); c.Password = sdr[Password].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 connectSt