温馨提示:代码在线浏览功能只能做为源码浏览参考,如果想更进一步了解该代码请下载:ASP.NET三层架构留言本项目源码
当前文件:
MVCGuestBook/DAL/Admin.cs,打开代码结构图
MVCGuestBook/DAL/Admin.cs,打开代码结构图1using System; 2
using System.Collections.Generic; 3
using System.Text; 4
using GustBook.DBUtility; 5
using System.Data; 6
7
//该源码下载自www.51aspx.com(51aspx.com) 8
9
namespace GustBook.DAL 10
{ 11
public class Admin 12
{ 13
public DataBase myData = DBHelper.CreateData("mySql"); 14
15
///<summary> 16
///用户登录 17
///</summary> 18
public bool uLogin(GustBook.Model.Admin model) 19
{ 20
myData.AddParameter("@name", model.AdminName); 21
myData.AddParameter("@pass", model.PassWord); 22
string strsql = "select AdminName,PassWord From Admin where AdminName=@name and PassWord=@pass"; 23
DataTable dt = myData.ExecuteDataSet(strsql).Tables[0]; 24
if (dt.Rows.Count < 1) 25
return false; 26
else return true; 27
28
} 29
///<summary> 30
///删除留言 31
///</summary> 32
public bool uDel(int nId) 33
{ 34
//GustBook.Model.Admin mo=new GustBook.Model.Admin(); 35
myData.AddParameter("@id", nId); 36
37
string sqlstr = "delete from Content Where Id=@id"; 38
if (myData.ExecuteNonQuery(sqlstr) > 0) 39
return true; 40
else 41
return false; 42
} 43
///<summary> 44
///回复留言 45
///</summary> 46
public bool uAddRe(GustBook.Model.Content model) 47
{ 48
myData.AddParameter("@id",model.Id); 49
myData.AddParameter("@content",model.Reply); 50
string sqlstr = "update Content set Reply=@content where Id=@id"; 51
if (myData.ExecuteNonQuery(sqlstr) > 0) 52
return true; 53
else return false; 54
} 55
} 56
} 57





}