1
using System;
2
using System.Collections.Generic;
3
using System.Text;
4
using System.Data.SqlClient;
5
using Lawyee.DBUtility;
6
using System.Data;
7
//该源码下载自www.51aspx.com(51aspx.com)
8
9
namespace 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