学生管理系统-web程序设计代码.doc
文本预览下载声明
房屋销售管理系统
一、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 connectS
显示全部