1using System;
 2using System.Collections.Generic;
 3using System.Text;
 4using GustBook.DBUtility;
 5using System.Data;
 6
 7namespace 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