1
using System;
2using System.Collections.Generic;
3using System.Text;
4using System.Data;
5
6namespace SQLServerDAL
7
...{
8
业务逻辑层#region 业务逻辑层
9 /**//// <summary>
10
/// 业务逻辑层
11 /// 构造SQL语句及调用方法执行
12
/// </summary>
13 #endregion
14
15 public class news
16 ...{
17 /**//// <summary>
18 /// 实例化DBbase类的对象,用于调用其内部方法来执行不同的操作
19 /// </summary>
20 DBbase db = new DBbase();
21
22 获取现有新闻ID#region 获取现有新闻ID
23 /**//// <summary>
24 /// 获取现有新闻ID
25 /// </summary>
26 /// <returns>DataSet数据集</returns>
27 public DataSet GetNewsID()
28 ...{
29 string strSQL = "select id from news where flag='已审核'";
30 return db.ReturnDataSet(strSQL);
31 }
32 #endregion
33
34 无条件获取全部新闻内容#region 无条件获取全部新闻内容
35 /**//// <summary>
36 /// 获取全部新闻内容
37 /// </summary>
38 /// <returns></returns>
39 public DataSet GetData_news()
40 ...{
41 string strSQL = "select news.*,BigClass.name from news,BigClass where news.flag='已审核' and news.BigClassID=BigClass.id";
42 return db.ReturnDataSet(strSQL);
43 }
44 #endregion
45
46 根据栏目ID获取全部新闻内容#region 根据栏目ID获取全部新闻内容
47 /**//// <summary>
48 /// 获取全部新闻内容
49 /// </summary>
50 /// <param name="BigClassID">新闻栏目ID</param>
51 /// <returns></returns>
52 public DataSet GetData_news(int BigClassID)
53 ...{
54 string strSQL = "select news.*,BigClass.name from news,BigClass where news.flag='已审核' and news.BigClassID=" + BigClassID + " and news.BigClassID=BigClass.id";
55 return db.ReturnDataSet(strSQL);
56 }
57 #endregion
58
59 分栏目获取新闻列表#region 分栏目获取新闻列表
60 /**//// <summary>
61 /// 分栏目获取新闻列表
62 /// </summary>
63 /// <param name="M_news">Model实体层news类的对象</param>
64 /// <returns>DataSet数据集</returns>
65 public DataSet GetDataByBigClass(int BigClassID)
66 ...{
67 string strSQL = "select * from news where BigClassID =" + BigClassID + " and flag='已审核' order by cindex";
68 return db.ReturnDataSet(strSQL);
69 }
70 #endregion
71
72 获取每个分栏前6条新闻#region 获取每个分栏前6条新闻
73 /**//// <summary>
74 /// 获取每个分栏前6条新闻
75 /// </summary>
76 /// <param name="M_news">Model实体层news类的对象</param>
77 /// <returns>DataSet数据集</returns>
78 public DataSet GetDataByBigClassTopSix(Model.news M_news)
79 ...{
80 string strSQL = "select top 6 * from news where BigClassID='" + M_news.BigClassID.ToString() + "' and flag=1 order by cindex";
81 return db.ReturnDataSet(strSQL);
82 }
83 #endregion
84
85 获取最新8条新闻#region 获取最新8条新闻
86 /**//// <summary>
87 /// 获取最新8条新闻
88 /// </summary>
89 /// <returns>DataSet数据集</returns>
90 public DataSet GetDataEightNew()
91 ...{
92 string strSQL = "select top 8 id,title,infotime,hits from news where flag='已审核' order by cindex";
93 return db.ReturnDataSet(strSQL);
94 }
95 #endregion
96
97 获取点击率最高的10条新闻标题#region 获取点击率最高的10条新闻标题
98 /**//// <summary>
99 /// 获取点击率最高的10条新闻标题
100 /// </summary>
101 /// <returns>DataSet数据集</returns>
102 public DataSet GetDataTopTenHits()
103 ...{
104 string strSQL = "select top 10 id,title,hits from news where flag='已审核' order by hits DESC";
105 return db.ReturnDataSet(strSQL);
106 }
107 #endregion
108
109 添加新的新闻,添加成功返回true,否则返回false#region 添加新的新闻,添加成功返回true,否则返回false
110 /**//// <summary>
111 /// 添加新闻,添加成功返回true,否则返回false
112 /// </summary>
113 /// <param name="M_news">参数</param>
114 /// <returns>bool值</returns>
115 public bool AddNews(Model.news M_news)
116 ...{
117 string times = System.DateTime.Now.ToString();
118 int cindex = GetMaxCindex()+1;
119 string strSQL = "insert news (title,info,BigClassID,username,infotime,cindex) values('" + M_news.title + "','" + M_news.info + "'," + M_news.BigClassID + ",'" + M_news.username + "','" + times + "', " + cindex + " )";
120 return db.ExecuteNonQuery(false, strSQL);
121 }
122 #endregion
123
124 修改指定的新闻,修改成功返回true,否则返回false#region 修改指定的新闻,修改成功返回true,否则返回false
125 /**//// <summary>
126 /// 修改指定的新闻,修改成功返回true,否则返回false
127 /// </summary>
128 /// <param name="M_news">对象参数</param>
129 /// <returns>成功返回true,失败返回false</returns>
130 public bool UpdateNews(Model.news M_news)
131 ...{
132 string strSQL = "update news set title='" + M_news.title + "',BigClassID=" + M_news.BigClassID + ",info='" + M_news.info + "',username='" + M_news.username + "' where id=" + M_news.id;
133 return db.ExecuteNonQuery(false, strSQL);
134 }
135 #endregion
136
137 根据新闻id删除新闻,删除成功返回true,否则返回false#region 根据新闻id删除新闻,删除成功返回true,否则返回false
138 /**//// <summary>
139 /// 根据新闻id删除新闻,删除成功返回true,否则返回false
140 /// </summary>
141 /// <param name="id">关键字段id</param>
142 /// <returns>true,false</returns>
143 public bool DeleteNewByID(int id)
144 ...{
145 string strSQL = "delete from news where id=" + id;
146 return db.ExecuteNonQuery(false, strSQL);
147 }
148 #endregion
149
150 更新新闻的点击率#region 更新新闻的点击率
151 /**//// <summary>
152 /// 更新新闻的点击率
153 /// </summary>
154 /// <param name="id">要更新点击率的新闻id</param>
155 public void UpdateHits(int id)
156 ...{
157 string strSQL = "update news set hits=hits+1 where id=" +id;
158 db.ExecuteNonQuery(strSQL);
159 }
160 #endregion
161
162 根据指定id绑定指定的新闻内容#region 根据指定id绑定指定的新闻内容
163 /**//// <summary>
164 /// 根据指定id绑定指定的新闻内容
165 /// </summary>
166 /// <param name="id">要绑定新闻的id</param>
167 /// <returns>DataSet数据集合</returns>
168 public DataSet DataBindNews(int id)
169 ...{
170 string strSQL = "select * from news where id=" + id;
171 return db.ReturnDataSet(strSQL);
172 }
173 #endregion
174
175 按新闻标题模糊查询新闻列表#region 按新闻标题模糊查询新闻列表
176 /**//// <summary>
177 /// 按新闻标题模糊查询新闻列表
178 /// </summary>
179 /// <param name="title">新闻标题</param>
180 /// <returns>DataSet数据集</returns>
181 public DataSet QueryByNewsTitle(string title)
182 ...{
183 string strSQL = "select id,title,infotime,hits from news where flag='已审核' and title like '%" + title + "%' order by cindex";
184 return db.ReturnDataSet(strSQL);
185 }
186 #endregion
187
188 按新闻标题模糊查询新闻列表#region 按新闻标题模糊查询新闻列表
189 /**//// <summary>
190 /// 按新闻标题模糊查询新闻列表
191 /// </summary>
192 /// <param name="title">新闻标题</param>
193 /// <returns>DataSet数据集</returns>
194 public DataSet AdminQueryByNewsTitle(string title)
195 ...{
196 string strSQL = "select news.*,BigClass.name from news,BigClass where news.flag='已审核' and news.BigClassID=BigClass.id and title like '%" + title + "%' order by news.cindex";
197 return db.ReturnDataSet(strSQL);
198 }
199 #endregion
200
201 按新闻内容模糊查询新闻列表#region 按新闻内容模糊查询新闻列表
202 /**//// <summary>
203 /// 按新闻内容模糊查询新闻列表
204 /// </summary>
205 /// <param name="info">新闻内容</param>
206 /// <returns>DataSet数据集</returns>
207 public DataSet QueryByNewsInfo(string info)
208 ...{
209 string strSQL = "select id,title,infotime,hits from news where flag='已审核' and info like '%" + info + "%' order by cindex";
210 return db.ReturnDataSet(strSQL);
211 }
212 #endregion
213
214 按新闻内容模糊查询新闻列表#region 按新闻内容模糊查询新闻列表
215 /**//// <summary>
216 /// 按新闻内容模糊查询新闻列表
217 /// </summary>
218 /// <param name="info">新闻内容</param>
219 /// <returns>DataSet数据集</returns>
220 public DataSet AdminQueryByNewsInfo(string info)
221 ...{
222 string strSQL = "select news.*,BigClass.name from news,BigClass where news.flag='已审核' and news.BigClassID=BigClass.id and info like '%" + info + "%' order by news.cindex";
223 return db.ReturnDataSet(strSQL);
224 }
225 #endregion
226
227 获取最大的Cindex#region 获取最大的Cindex
228 /**//// <summary>
229 /// 获取最大的Cindex
230 /// </summary>
231 /// <returns>最大cindex</returns>
232 public int GetMaxCindex()
233
TreeLayerNews/SQLServerDAL/news.cs，打开代码结构图