1using System;
 2using System.Collections.Generic;
 3using System.Text;
 4using Model;
 5using System.Data.SqlClient;
 6using Lawyee.DBUtility;
 7using System.Data;
 8
 9namespace SqlServerDAL
10...{
11    public class ArticleDAL
12    ...{
13        /**//// <summary>
14        /// 返回指定
15        /// </summary>
16        /// <param name="typeID"></param>
17        /// <returns></returns>
18        public ArticleCollection GetArticleByArticleType(int typeID)
19        ...{
20            ArticleCollection articleList = new ArticleCollection();
21            SqlParameter sp = new SqlParameter("@ArticleTypeID",SqlDbType.Int);
22            sp.Value = typeID;
23            SqlDataReader sdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "ArticleDAL_GetArticleByArticleType_TOP5", sp);
24            while (sdr.Read())
25            ...{
26                ArticleModel am = new ArticleModel();
27                am.ArticleID = Convert.ToInt32(sdr["ArticleID"]);
28                am.ArticleName = Convert.ToString(sdr["ArticleName"]);
29                am.Summary = Convert.ToString(sdr["Summary"]);
30                am.PublishTime = Convert.ToDateTime(sdr["PublishTime"]).ToString("yyyy-MM-dd");
31                articleList.Add(am);
32                articleList.ArticleCount = Convert.ToInt32(sdr["Count"]);
33            }
34            sdr.Close();
35            return articleList;
36        }
37
38        /**//// <summary>
39        /// 获取全部文章类型
40        /// </summary>
41        /// <returns></returns>
42        public ArticleTypeCollection GetArticleType()
43        ...{
44            ArticleTypeCollection articleTypeList = new ArticleTypeCollection();
45            SqlDataReader sdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "ArticleDAL_GetArticleType", null);
46            while (sdr.Read())
47            ...{
48                ArticleTypeModel atm = new ArticleTypeModel();
49                atm.TypeID = Convert.ToInt32(sdr["TypeID"]);
50                atm.TypeName = Convert.ToString(sdr["TypeName"]);
51                articleTypeList.Add(atm);
52            }
53            sdr.Close();
54            return articleTypeList;
55        }
56
57        /**//// <summary>
58        /// 用户修改文章
59        /// </summary>
60        /// <param name="article"></param>
61        /// <returns></returns>
62        public bool UpdateChangeArticle(ArticleModel article)
63        ...{
64            SqlParameter[] sp=new SqlParameter[7];
65            sp[0] = new SqlParameter("@UserID",SqlDbType.Int);
66            sp[0].Value = article.User.UserID;
67            sp[1] = new SqlParameter("@ArticleID", SqlDbType.Int);
68            sp[1].Value = article.ArticleID;
69            sp[2] = new SqlParameter("@ArticleName", SqlDbType.NVarChar, 50);
70            sp[2].Value = article.ArticleName;
71            sp[3] = new SqlParameter("@TypeID",SqlDbType.Int);
72            sp[3].Value = article.ArticleType.TypeID;
73            sp[4] = new SqlParameter("@Summary",SqlDbType.NVarChar,100);
74            sp[4].Value = article.Summary;
75            sp[5] = new SqlParameter("@ArticleContent", SqlDbType.Text);
76            sp[5].Value = article.ArticleContent;
77            sp[6] = new SqlParameter("@ArticleDatasoure", SqlDbType.NVarChar, 100);
78            sp[6].Value = article.ArticleDatasoure;
79            int i=SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "ArticleDAL_UpdateChangeArticle", sp);
80            if (i > 0)
81            ...{
82                return true;
83            }
84            else
85            ...{
86                return false;
87            }
88        }
89    }
90}
91