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

		            
 1using System;
 2using System.Collections.Generic;
 3using System.Text;
 4using System.Data;
 5using System.Data.OleDb;
 6using ClothesShop.DBUtility;
 7namespace ClothesShop.OleDbDAL
 8...{
 9    public class relay : ClothesShop.IDAL.Irelay
10    ...{
11        /**//// <summary>
12        /// 添加一条回复
13        /// </summary>
14        /// <param name="Relay_Content"></param>
15        /// <param name="Messages_ID"></param>
16        /// <param name="MUser_ID"></param>
17        public int createrelay(String Relay_Content, Int32 Messages_ID, Int32 MUser_ID)
18        ...{
19            OleDbParameter[] param = ...{ OleDbHelper.GetParameter("@Relay_Content",OleDbType.Char,1000,"Relay_Content",Relay_Content),
20                                   OleDbHelper.GetParameter("@Messages_ID",OleDbType.Integer,4,"Messages_ID",Messages_ID),
21                                   OleDbHelper.GetParameter("@MUser_ID",OleDbType.Integer,4,"MUser_ID",MUser_ID)};
22            String sql = "Insert into Relay (Relay_Content,Messages_ID,MUser_ID) values (@Relay_Content,@Messages_ID,@MUser_ID)";
23            return OleDbHelper.ExecuteSql(sql, param);
24        }
25
26        /**//// <summary>
27        /// 更新回复
28        /// </summary>
29        /// <param name="Messages_ID"></param>
30        /// <param name="Relay_Content"></param>
31        /// <param name="MUser_ID"></param>
32        public int updaterelay(Int32 Messages_ID, String Relay_Content, Int32 MUser_ID)
33        ...{
34            OleDbParameter[] param = ...{ 
35                                   OleDbHelper.GetParameter("@Relay_Content", OleDbType.Char, 1000, "Relay_Content", Relay_Content),
36                                   OleDbHelper.GetParameter("@MUser_ID", OleDbType.Integer, 4, "MUser_ID", MUser_ID),
37                                   OleDbHelper.GetParameter("@Messages_ID", OleDbType.Integer, 4, "Messages_ID", Messages_ID),
38                                 };
39            String sql = "Update Relay set Relay_Content=@Relay_Content,Relay_Time=Now(),MUser_ID=@MUser_ID where Messages_ID=@Messages_ID";
40            return OleDbHelper.ExecuteSql(sql, param);
41        }
42
43        /**//// <summary>
44        /// 删除一条回复
45        /// </summary>
46        /// <param name="Relay_ID"></param>
47        public int deleterelay(int Relay_ID)
48        ...{
49            OleDbParameter[] param = ...{ OleDbHelper.GetParameter("@Relay_ID", OleDbType.Char, 1000, "Relay_ID", Relay_ID) };
50            String sql = "delete from Relay where Relay_ID=@Relay_ID";
51            return OleDbHelper.ExecuteSql(sql, param);
52        }
53
54        /**//// <summary>
55        /// 留言是否有回复
56        /// </summary>
57        /// <param name="Message_ID"></param>
58        /// <returns></returns>
59        public bool isRelay(int Message_ID)
60        ...{
61            StringBuilder sb = new StringBuilder();
62            sb.Append("select Relay_ID from relay where Messages_ID=@Message_ID");
63            OleDbParameter[] param = ...{ 
64                                   OleDbHelper.GetParameter("@Messages_ID", OleDbType.Integer, 4, "Messages_ID", Message_ID),
65                                 };
66            return OleDbHelper.ExecuteDt(sb.ToString(), param).Rows.Count > 0 ? true : false;
67
68        }
69
70        /**//// <summary>
71        /// 根据留言ID获得回复内容
72        /// </summary>
73        /// <param name="Message_ID"></param>
74        /// <returns></returns>
75        public string getrelaybymessageid(int Message_ID)
76        ...{
77            StringBuilder sb = new StringBuilder();
78            sb.Append("select Relay_Content from relay where Messages_ID=@Message_ID");
79            OleDbParameter[] param = ...{ 
80                                   OleDbHelper.GetParameter("@Messages_ID", OleDbType.Integer, 4, "Messages_ID", Message_ID),
81                                 };
82            return OleDbHelper.ExecuteDt(sb.ToString(),param).Rows[0]["Relay_Content"].ToString();
83        }
84    }
85}
86