1
using System;
2
using System.Collections.Generic;
3
using System.Text;
4
using GustBook.DBUtility;
5
using System.Data;
6
7
namespace GustBook.DAL
8
...{
9
public class Message
10
...{
11
public DataBase myData = DBHelper.CreateData("mySql");
12
成员方法#region 成员方法
13
14
/**////<summary>
15
///添加一条留言
16
///</summary>
17
public bool Add(GustBook.Model.Content model)
18
...{
19
myData.AddParameter("@userName",model.UserName);
20
myData.AddParameter("@picUrl",model.PicUrl);
21
myData.AddParameter("@userEmail", model.UserMail);
22
myData.AddParameter("@userUrl", model.UserUrl);
23
myData.AddParameter("@userQQ",model.UserQQ);
24
myData.AddParameter("@faceUrl",model.FaceUrl);
25
myData.AddParameter("@userIp",model.UserIp);
26
myData.AddParameter("@addTime", model.AddTime);
27
myData.AddParameter("@content",model.Contents);
28
myData.AddParameter("@ishid",model.IsHid);
29
30
string sqlstr = "insert into Content(UserName,UserEmail,UserQQ,UserUrl,UserIp,faceUrl,PicUrl,AddTime,Content,Reply,IsHid,IsReply)";
31
sqlstr += " values(@userName,@userEmail,@userQQ,@userUrl,@userIp,@faceUrl,@picUrl,@addTime,@content,'',@ishid,0)";
32
if (myData.ExecuteNonQuery(sqlstr) > 0)
33
return true;
34
else return false;
35
}
36
/**////<summary>
37
///获取留言数据
38
///</summary>
39
public DataSet GetList(int intSta,int intNum)
40
...{
41
StringBuilder strsql = new StringBuilder();
42
strsql.Append("Select * From Content order by AddTime desc");
43
//if(SqlWhere.Trim()!="")
44
// strsql.Append(" Where "+SqlWhere);
45
return myData.ExecuteDataSet(strsql.ToString(),intSta,intNum);
46
}
47
48
#endregion
49
}
50
}
51