1.先创建一个空的解决方案。
2.创建四个项目,3个类库。
3.增加项目的引用实现关联。
表现层:模型层+业务逻辑层 FreshLiveWeb:Models+BLL
业务逻辑层:模型层+数据访问层 BLL:Models+DAL
数据访问层:模型层 DAL:Models
(1) AdminUser表例子
--------------------Models层
namespace Models
{
/// <summary>
///
/// </summary>
public class AdminUser
{
/// <summary>
///
/// </summary>
public int AdminID { get; set; }
public string AdminName { get; set; }
public string AdminPwd { get; set; }
}
}-
------------------DAL层
namespace DAL
{
public class AdminUserDAL
{
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool Insert(AdminUser model)
{
string sql = string.Format(@"INSERT INTO [dbo].[AdminUser]
([AdminName]
,[AdminPwd])
VALUES
('{0}'
,'{1}')", model.AdminName, model.AdminPwd);
return SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionString, CommandType.Text, sql, null) > 0;
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool Update(AdminUser model)
{
string sql = string.Format(@"UPDATE [dbo].[AdminUser]
SET [AdminName] = '{0}'
,[AdminPwd] = '{1}'
WHERE AdminID='{2}'", model.AdminName, model.AdminPwd, model.AdminID);
return SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionString, CommandType.Text, sql, null) > 0;
}
/// <summary>
/// 删除
/// </summary>
/// <param name="id">主键</param>
/// <returns></returns>
public static bool Delete(int id)
{
string sql = string.Format(@"DELETE FROM [dbo].[AdminUser]
WHERE AdminID='{0}'", id);
return SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionString, CommandType.Text, sql, null) > 0;
}
/// <summary>
/// 查询
/// </summary>
/// <param name="where">where条件</param>
/// <returns></returns>
public static List<AdminUser> GetAdminUsers(string where)
{
string sql = @"SELECT [AdminID]
,[AdminName]
,[AdminPwd]
FROM [dbo].[AdminUser] ";
if (!string.IsNullOrWhiteSpace(where))
{
sql += " where " + where;
}
SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionString, CommandType.Text, sql, null);
if (dr.HasRows)
{
List<AdminUser> list = new List<AdminUser>();
while (dr.Read())
{
AdminUser model = new AdminUser()
{
AdminID = int.Parse(dr["AdminID"].ToString()),
AdminPwd = dr["AdminPwd"].ToString(),
AdminName = dr["AdminName"].ToString()
};
list.Add(model);
}
return list;
}
else
{
return null;
}
}
}
}
--------------------------------BLL层
namespace BLL
{
public class AdminUserBLL
{
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool Insert(AdminUser model)
{
return DAL.AdminUserDAL.Insert(model);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool Update(AdminUser model)
{
return DAL.AdminUserDAL.Update(model);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="id">主键</param>
/// <returns></returns>
public static bool Delete(int id)
{
return DAL.AdminUserDAL.Delete(id);
}
/// <summary>
/// 查询
/// </summary>
/// <param name="where">where条件</param>
/// <returns></returns>
public static List<AdminUser> GetAdminUsers(string where)
{
return DAL.AdminUserDAL.GetAdminUsers(where);
}
}
}