1using System;
  2using System.Collections.Generic;
  3using System.Text;
  4using System.Data.SqlClient;
  5using Lawyee.DBUtility;
  6using System.Data;
  7//该源码下载自www.51aspx.com(５１ａsｐｘ．ｃｏｍ)
  8
  9namespace SqlServerDAL
 10...{
 11    public class Admins
 12    ...{
 13        管理员登录#region 管理员登录
 14        /**//// <summary>
 15        /// 管理员登录
 16        /// </summary>
 17        /// <param name="sName">管理员名称</param>
 18        /// <param name="sPwd">管理员密码</param>
 19        /// <returns></returns>
 20        public static bool AdminLogin(string sName, string sPwd)
 21        ...{
 22            SqlParameter[] paras = new SqlParameter[2];
 23            paras[0] = new SqlParameter("@AdminName", SqlDbType.NVarChar, 50);
 24            paras[0].Value = sName;
 25            paras[1] = new SqlParameter("@AdminPwd", SqlDbType.NVarChar, 50);
 26            paras[1].Value = sPwd;
 27            int i = Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "AdminLogin", paras));
 28            if (i > 0)
 29            ...{
 30                return true;
 31            }
 32            else
 33            ...{
 34                return false;
 35            }
 36        }
 37        #endregion
 38
 39        取得文章#region 取得文章
 40        /**//// <summary>
 41        /// 取得文章
 42        /// </summary>
 43        /// <param name="iPageIndex">当前页</param>
 44        /// <param name="iPageSize">每页显示的数据</param>
 45        /// <param name="iTypeID">类别ID</param>
 46        /// <param name="iUserID">用户ID</param>
 47        /// <param name="sArticleName">文章标题</param>
 48        /// <param name="sSummary">摘要</param>
 49        /// <returns></returns>
 50        public static DataSet GetArticle(int iPageIndex, int iPageSize, int iTypeID, string sArticleName, string sSummary)
 51        ...{
 52            //@PageIndex  INT = 0,
 53            //@PageSize   INT = 20,
 54            //@ArticleName    nVARCHAR(50) = '',        --文章标题
 55            //@TypeID    int = 0,                        --分类ID
 56            //@Summary nvarchar(100)=''                --摘要
 57            SqlParameter[] paras = new SqlParameter[5];
 58            paras[0] = new SqlParameter("@PageIndex", SqlDbType.Int);
 59            paras[0].Value = iPageIndex;
 60            paras[1] = new SqlParameter("@PageSize", SqlDbType.Int);
 61            paras[1].Value = iPageSize;
 62            paras[2] = new SqlParameter("@ArticleName", SqlDbType.NVarChar, 50);
 63            paras[2].Value = sArticleName;
 64            paras[3] = new SqlParameter("@TypeID", SqlDbType.Int);
 65            paras[3].Value = iTypeID;
 66            paras[4] = new SqlParameter("@Summary", SqlDbType.NVarChar, 1000);
 67            paras[4].Value = sSummary;
 68            SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "GetArticle", paras);
 69            DataSet ds = new DataSet();
 70            ds.Tables.Add(new DataTable("Article"));
 71            ds.Tables.Add(new DataTable("Total"));
 72            DataTable[] tables = new DataTable[2] ...{ ds.Tables[0], ds.Tables[1] };
 73            ds.Load(reader, LoadOption.Upsert, tables);
 74            reader.Close();
 75            return ds;
 76        }
 77        #endregion
 78
 79        删除文章#region 删除文章
 80        /**//// <summary>
 81        /// 删除文章
 82        /// </summary>
 83        /// <param name="sId"></param>
 84        /// <returns></returns>
 85        public static bool DeleteArticleByIds(string sId)
 86        ...{
 87            SqlParameter para = new SqlParameter("@ids", SqlDbType.NVarChar, 100);
 88            para.Value = sId;
 89            int i = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "DeleteArticles", para);
 90            if (i > 0)
 91            ...{
 92                return true;
 93            }
 94            else
 95            ...{
 96                return false;
 97            }
 98        }
 99        #endregion
100
101        得到所有类别#region 得到所有类别
102        /**//// <summary>
103        /// 得到所有类别
104        /// </summary>
105        /// <returns></returns>
106        public static DataTable GetAllType()
107        ...{
108            SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "GetAllType", null);
109            DataTable table = new DataTable();
110            table.Load(reader);
111            reader.Close();
112            return table;
113        }
114        #endregion
115
116        得到所有用户#region 得到所有用户
117        /**//// <summary>
118        /// 得到所有用户
119        /// </summary>
120        /// <returns></returns>
121        public static DataTable GetAllUsers()
122        ...{
123            DataTable table = new DataTable();
124            SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "GetAllUsers", null);
125            table.Load(reader);
126            reader.Close();
127            return table;
128        }
129        #endregion
130    }
131}
132