当前文件路径：ClothesShop/OleDbDAL/message.cs

		            
 1using System;
 2using System.Collections.Generic;
 3using System.Text;
 4using System.Data;
 5using System.Data.OleDb;
 6using ClothesShop.DBUtility;
 7//该源码下载自http://www.51aspx.com/CV/ClothesShop
 8namespace ClothesShop.OleDbDAL
 9...{
10    public class message : ClothesShop.IDAL.Imessage
11    ...{
12        /**//// <summary>
13        /// 添加新留言
14        /// </summary>
15        /// <param name="Messages_Name"></param>
16        /// <param name="Messages_Content"></param>
17        /// <param name="IsDelete"></param>
18        public int createmessage(string Messages_Name, string Messages_Content, bool IsDelete)
19        ...{
20            StringBuilder sb = new StringBuilder();
21            sb.Append("Insert into Message (Messages_Name,Messages_Content,IsDelete) values (@Messages_Name,@Messages_Content,@IsDelete)");
22            OleDbParameter[] param = 
23                                   ...{
24                                      OleDbHelper.GetParameter("@Messages_Name",OleDbType.Char,50,"Messages_Name",Messages_Name),
25                                      OleDbHelper.GetParameter("@Messages_Content",OleDbType.Char,5000,"Messages_Content",Messages_Content),
26                                      OleDbHelper.GetParameter("@IdDelete",OleDbType.Boolean,1,"IsDelete",IsDelete)
27                                   };
28            return OleDbHelper.ExecuteSql(sb.ToString(), param);
29        }
30
31        /**//// <summary>
32        /// 获得一条留言
33        /// </summary>
34        /// <param name="Messages_ID"></param>
35        /// <returns></returns>
36        public DataRow getonemessage(int Messages_ID)
37        ...{
38            OleDbParameter[] param = ...{ OleDbHelper.GetParameter("@BookID", OleDbType.Integer, 4, "Messages_ID", Messages_ID) };
39            String sql = "Select Messages_ID, Messages_Name,Messages_Content,Messages_Time from Message where IsDelete=0 and Messages_ID=@BookID";
40            DataTable dt =  OleDbHelper.ExecuteDt(sql, param);
41            return dt.Rows[0];
42        }
43
44        /**//// <summary>
45        /// 删除一条留言
46        /// </summary>
47        /// <param name="Messages_ID"></param>
48        public int deletemessage(int Messages_ID)
49        ...{
50            OleDbParameter[] param = ...{ OleDbHelper.GetParameter("@Messages_ID", OleDbType.Integer, 4, "Messages_ID", Messages_ID) };
51            String sql = "Update Message set IsDelete=1 where Messages_ID=@Messages_ID";
52            return OleDbHelper.ExecuteSql(sql, param);
53        }
54
55        /**//// <summary>
56        /// 获得全部留言和回复
57        /// </summary>
58        /// <returns></returns>
59        public DataTable GetMessageList()
60        ...{
61            StringBuilder sb = new StringBuilder();
62            sb.Append("Select a.Messages_ID,a.Messages_Name,a.Messages_Content,a.Messages_Time,b.Relay_ID,b.Relay_Content,b.Relay_Time ");
63            sb.Append("from Message as a left outer join Relay as b on a.Messages_ID=b.Messages_ID where a.IsDelete=0 order by a.Messages_Time desc");
64            DataTable dt = OleDbHelper.ExecuteDt(sb.ToString());
65            return dt;
66        }
67
68        /**//// <summary>
69        /// 获得全部留言
70        /// </summary>
71        /// <returns></returns>
72        public DataTable messagelist()
73        ...{
74            StringBuilder sb = new StringBuilder();
75            sb.Append("select Messages_ID,Messages_Name,Messages_Content,Messages_Time from message where IsDelete=0 order by Messages_ID desc");
76            DataTable dt = OleDbHelper.ExecuteDt(sb.ToString());
77            return dt;
78        }
79    }
80}
81