1using System;
  2using System.Collections.Generic;
  3using System.Text;
  4using System.Data;
  5using Model;
  6
  7namespace SqlServerBLL
  8...{
  9    public class Users
 10    ...{
 11        用户注册#region 用户注册
 12        /**//// <summary>
 13        /// 用户注册
 14        /// </summary>
 15        /// <param name="sName">用户名称</param>
 16        /// <param name="sPwd">用户密码</param>
 17        /// <returns></returns>
 18        public bool UserRegister(string sName, string sPwd)
 19        ...{
 20            sPwd = MyUtility.MyConvert.Encrypt(sPwd, "sha1");
 21            return SqlServerDAL.Users.UserRegister(sName, sPwd);
 22        }
 23        #endregion
 24
 25        发表文章#region 发表文章
 26        /**//// <summary>
 27        /// 发表文章
 28        /// </summary>
 29        /// <param name="sArticleName">文章标题</param>
 30        /// <param name="iTypeID">文章分类ID</param>
 31        /// <param name="iUserID">用户ID</param>
 32        /// <param name="sSummary">摘要</param>
 33        /// <param name="sContent">内容</param>
 34        /// <returns></returns>
 35        public bool CreatArticle(string sArticleName, int iTypeID, int iUserID, string sSummary, string sContent, string sSource)
 36        ...{
 37            return SqlServerDAL.Users.CreatArticle(sArticleName, iTypeID, iUserID, sSummary, sContent, sSource);
 38        }
 39        #endregion
 40
 41        取得所有分类#region 取得所有分类
 42        /**//// <summary>
 43        /// 取得所有分类
 44        /// </summary>
 45        /// <returns></returns>
 46        public DataTable GetAllType()
 47        ...{
 48            return SqlServerDAL.Users.GetAllType();
 49        }
 50        #endregion
 51
 52        取得文章#region 取得文章
 53        /**//// <summary>
 54        /// 取得文章
 55        /// </summary>
 56        /// <param name="iPageIndex">当前页</param>
 57        /// <param name="iPageSize">每页显示的数据</param>
 58        /// <param name="iTypeID">类别ID</param>
 59        /// <param name="iUserID">用户ID</param>
 60        /// <param name="sArticleName">文章标题</param>
 61        /// <param name="sSummary">摘要</param>
 62        /// <returns></returns>
 63        public DataSet GetArticle(int iPageIndex, int iPageSize, int iTypeID, int iUserID, string sArticleName, string sSummary)
 64        ...{
 65            return SqlServerDAL.Users.GetArticle(iPageIndex, iPageSize, iTypeID, iUserID, sArticleName, sSummary);
 66        }
 67        #endregion
 68
 69        获取文章详细信息#region 获取文章详细信息
 70        /**//// <summary>
 71        /// 获取文章详细信息
 72        /// </summary>
 73        /// <param name="iArticleID"></param>
 74        /// <returns></returns>
 75        public DataTable GetArticleDetail(int iArticleID)
 76        ...{
 77            return SqlServerDAL.Users.GetArticleDetail(iArticleID);
 78        }
 79
 80        /**//// <summary>
 81        /// 获取文章详细信息
 82        /// </summary>
 83        /// <param name="iArticleID"></param>
 84        /// <returns></returns>
 85        public ArticleModel GetArticleDetailForUpdate(int iArticleID)
 86        ...{
 87            return SqlServerDAL.Users.GetArticleDetailForUpdate(iArticleID);
 88        }
 89        #endregion
 90
 91        统计#region 统计
 92        /**//// <summary>
 93        /// 分类统计
 94        /// </summary>
 95        /// <param name="iUserID"></param>
 96        /// <returns></returns>
 97        public DataTable TypeGroup(int iUserID)
 98        ...{
 99            return SqlServerDAL.Users.TypeGroup(iUserID);
100        }
101
102        /**//// <summary>
103        /// 根据用户编号，获取用户文章个数
104        /// </summary>
105        /// <param name="user"></param>
106        /// <returns></returns>
107        public int GetUserArticleCount(UsersModel user)
108        ...{
109            return SqlServerDAL.Users.GetUserArticleCount(user);
110        }
111        #endregion
112
113        用户登录判断#region 用户登录判断
114        /**//// <summary>
115        /// 用户登录判断
116        /// </summary>
117        /// <param name="userName">用户名</param>
118        /// <param name="userPassword">用户密码</param>
119        /// <returns></returns>
120        public UsersModel UserLogin(string userName, string userPassword)
121        ...{
122            userPassword = MyUtility.MyConvert.Encrypt(userPassword, "sha1");
123            return SqlServerDAL.Users.UserLogin(userName, userPassword);
124        }
125        #endregion
126
127        修改用户密码#region 修改用户密码
128        /**//// <summary>
129        /// 修改用户密码
130        /// </summary>
131        /// <param name="userID">用户ID</param>
132        /// <param name="oldPassword">旧密码</param>
133        /// <param name="newPassword">新密码</param>
134        /// <returns></returns>
135        public bool ChangePassword(int userID, string oldPassword, string newPassword)
136        ...{
137            if (!string.IsNullOrEmpty(oldPassword))
138            ...{
139                oldPassword = MyUtility.MyConvert.Encrypt(oldPassword, "sha1");
140            }
141            newPassword = MyUtility.MyConvert.Encrypt(newPassword, "sha1");
142            return SqlServerDAL.Users.ChangePassword(userID, oldPassword, newPassword);
143        }
144        #endregion
145    }
146}
147