1using System;
  2using System.Data;
  3using System.Configuration;
  4using System.Web;
  5using System.Web.Security;
  6using System.Web.UI;
  7using System.Web.UI.WebControls;
  8using System.Web.UI.WebControls.WebParts;
  9using System.Web.UI.HtmlControls;
 10using System.Data.SqlClient;
 11using Web2ASPNET2.OperateSqlServer;
 12using Web2ASPNET2.CommonOperation;
 13//该源码下载自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)
 14
 15namespace Web2ASPNET2.WebTags
 16...{
 17    public class Tag
 18    ...{
 19        public Tag() ...{ }
 20
 21        public SqlDataReader GetCatalogs()
 22        ...{
 23            return DataCommon.GetDataByReader("Pr_GetCatalogs");
 24        }
 25        public DataSet GetTagsDS()
 26        ...{
 27            return DataCommon.GetDataByDataSet("Pr_GetTags");
 28        }
 29        public SqlDataReader GetTags()
 30        ...{
 31            return DataCommon.GetDataByReader("Pr_GetTags");
 32        }
 33        public SqlDataReader GetArticles()
 34        ...{
 35            return DataCommon.GetDataByReader("Pr_GetArticles");
 36        }
 37        public SqlDataReader GetUrls()
 38        ...{
 39            return DataCommon.GetDataByReader("Pr_GetUrls");
 40        }    
 41
 42        public DataSet GetTagByKey(string key)
 43        ...{    /**////定义保存数据的DataSet对象
 44            DataSet ds = new DataSet();
 45            /**////添加存储过程参数
 46            SqlParameter[] parameters = ...{
 47                OperateDatabase.CreateInParam("@Key",SqlDbType.VarChar,20,key)
 48            };
 49            /**////执行存储过程
 50            OperateDatabase.RunProc("Pr_GetTagByKey",ref ds,parameters);
 51            /**////返回结果
 52            return ds;
 53        }
 54
 55        public DataSet GetTagByCatalog(int catalogID)
 56        ...{    /**////定义保存数据的DataSet对象
 57            DataSet ds = new DataSet();
 58            /**////添加存储过程参数
 59            SqlParameter[] parameters = ...{
 60                OperateDatabase.CreateInParam("@CatalogID",SqlDbType.Int,4,catalogID)
 61            };
 62            /**////执行存储过程
 63            OperateDatabase.RunProc("Pr_GetTagByCatalog",ref ds,parameters);
 64            /**////返回结果
 65            return ds;
 66        }
 67        public DataSet GetTagByCount(int tagID)
 68        ...{    /**////定义保存数据的DataSet对象
 69            DataSet ds = new DataSet();
 70            /**////添加存储过程参数
 71            SqlParameter[] parameters = ...{
 72                OperateDatabase.CreateInParam("@TagID",SqlDbType.Int,4,tagID)
 73            };
 74            /**////执行存储过程
 75            OperateDatabase.RunProc("Pr_GetArticleByTag",ref ds,parameters);
 76            /**////返回结果
 77            return ds;
 78        }
 79        public DataSet GetArticleByTag(int tagID)
 80        ...{    /**////定义保存数据的DataSet对象
 81            DataSet ds = new DataSet();
 82            /**////添加存储过程参数
 83            SqlParameter[] parameters = ...{
 84                OperateDatabase.CreateInParam("@TagID",SqlDbType.Int,4,tagID)
 85            };
 86            /**////执行存储过程
 87            OperateDatabase.RunProc("Pr_GetArticleByTag",ref ds,parameters);
 88            /**////返回结果
 89            return ds;
 90        }
 91        public DataSet GetUrlByTag(int tagID)
 92        ...{    /**////定义保存数据的DataSet对象
 93            DataSet ds = new DataSet();
 94            /**////添加存储过程参数
 95            SqlParameter[] parameters = ...{
 96                OperateDatabase.CreateInParam("@TagID",SqlDbType.Int,4,tagID)
 97            };
 98            /**////执行存储过程
 99            OperateDatabase.RunProc("Pr_GetUrlByTag",ref ds,parameters);
100            /**////返回结果
101            return ds;
102        }
103        public DataSet GetArticleUrlByTag(int tagID)
104        ...{    /**////定义保存数据的DataSet对象
105            DataSet ds = new DataSet();
106            /**////添加存储过程参数
107            SqlParameter[] parameters = ...{
108                OperateDatabase.CreateInParam("@TagID",SqlDbType.Int,4,tagID)
109            };
110            /**////执行存储过程
111            OperateDatabase.RunProc("Pr_GetArticleUrlByTag",ref ds,parameters);
112            /**////返回结果
113            return ds;
114        }
115
116        public SqlDataReader GetSingleCatalog(int catalogID)
117        ...{
118            return DataCommon.GetDataByReaderIDParam("Pr_GetSingleTagCatalog",catalogID);
119        }
120        public SqlDataReader GetSingleTag(int tagID)
121        ...{
122            return DataCommon.GetDataByReaderIDParam("Pr_GetSingleTag",tagID);
123        }
124        public SqlDataReader GetSingleArticle(int articleID)
125        ...{
126            return DataCommon.GetDataByReaderIDParam("Pr_GetSingleTagArticle",articleID);
127        }    
128        public SqlDataReader GetSingleUrl(int urlID)
129        ...{
130            return DataCommon.GetDataByReaderIDParam("Pr_GetSingleTagUrl",urlID);
131        }
132
133        public int AddCatalog(string name)
134        ...{
135            SqlParameter[] parameters = ...{
136                OperateDatabase.CreateInParam("@Name",SqlDbType.VarChar,50,name)
137            };
138            return (OperateDatabase.RunProc("Pr_AddTagCatalog",parameters));
139        }
140        public int AddTag(string name,int catalogID,int userID,byte flag,
141            string remark)
142        ...{
143            SqlParameter[] parameters = ...{
144                OperateDatabase.CreateInParam("@Name",SqlDbType.VarChar,50,name),
145                OperateDatabase.CreateInParam("@CatalogID",SqlDbType.Int,4,catalogID),
146                OperateDatabase.CreateInParam("@UserID",SqlDbType.Int,4,userID),
147                OperateDatabase.CreateInParam("@Flag",SqlDbType.TinyInt,1,flag),
148                OperateDatabase.CreateInParam("@Remark",SqlDbType.NVarChar,1000,remark)
149            };
150            return (OperateDatabase.RunProc("Pr_AddTag",parameters));
151        }
152        public int AddArticle(string name,string body,int tagID)
153        ...{
154            SqlParameter[] parameters = ...{
155                OperateDatabase.CreateInParam("@Name",SqlDbType.VarChar,50,name),
156                OperateDatabase.CreateInParam("@Body",SqlDbType.Text,WebTags.TextStringLength,body),
157                OperateDatabase.CreateInParam("@TagID",SqlDbType.Int,4,tagID)                
158            };
159            return (OperateDatabase.RunProc("Pr_AddTagArticle",parameters));
160        }
161        public int AddUrl(string name,string url,int tagID)
162        ...{
163            SqlParameter[] parameters = ...{
164                OperateDatabase.CreateInParam("@Name",SqlDbType.VarChar,50,name),
165                OperateDatabase.CreateInParam("@Url",SqlDbType.VarChar,255,url),
166                OperateDatabase.CreateInParam("@TagID",SqlDbType.Int,4,tagID)                
167            };
168            return (OperateDatabase.RunProc("Pr_AddTagUrl",parameters));
169        }
170
171        public int UpdateCatalog(int catalogID,string name)
172        ...{
173            SqlParameter[] parameters = ...{
174                OperateDatabase.CreateInParam("@ID",SqlDbType.Int,4,catalogID),
175                OperateDatabase.CreateInParam("@Name",SqlDbType.VarChar,50,name)
176            };
177            return (OperateDatabase.RunProc("Pr_UpdateTagCatalog",parameters));
178        }
179        public int UpdateTag(int tagID,string name,byte flag,
180            string remark)
181        ...{
182            SqlParameter[] parameters = ...{
183                OperateDatabase.CreateInParam("@ID",SqlDbType.Int,4,tagID),
184                OperateDatabase.CreateInParam("@Name",SqlDbType.VarChar,50,name),
185                OperateDatabase.CreateInParam("@Flag",SqlDbType.TinyInt,1,flag),
186                OperateDatabase.CreateInParam("@Remark",SqlDbType.NVarChar,1000,remark)
187            };
188            return (OperateDatabase.RunProc("Pr_UpdateTag",parameters));
189        }
190        public int UpdateTagViewCount(int tagID,int viewCount)
191        ...{
192            SqlParameter[] parameters = ...{
193                OperateDatabase.CreateInParam("@ID",SqlDbType.Int,4,tagID),
194                OperateDatabase.CreateInParam("@ViewCount",SqlDbType.Int,4,viewCount)
195            };
196            return (OperateDatabase.RunProc("Pr_UpdateTagViewCount",parameters));
197        }
198        public int MoveTag(int tagID,int catalogID)
199        ...{
200            SqlParameter[] parameters = ...{
201                OperateDatabase.CreateInParam("@ID",SqlDbType.Int,4,tagID),
202                OperateDatabase.CreateInParam("@CatalogID",SqlDbType.Int,4,catalogID)
203            };
204            return (OperateDatabase.RunProc("Pr_MoveTag",parameters));
205        }
206        public int UpdateArticle(int articleID,string name,string body)
207        ...{
208            SqlParameter[] parameters = ...{
209                OperateDatabase.CreateInParam("@ID",SqlDbType.Int,4,articleID),
210                OperateDatabase.CreateInParam("@Name",SqlDbType.VarChar,50,name),
211                OperateDatabase.CreateInParam("@Body",SqlDbType.Text,WebTags.TextStringLength,body)
212            };
213            return (OperateDatabase.RunProc("Pr_UpdateTagArticle",parameters));
214        }
215        public int UpdateUrl(int urlID,string name,string url)
216        ...{
217            SqlParameter[] parameters = ...{
218                OperateDatabase.CreateInParam("@ID",SqlDbType.Int,4,urlID),
219                OperateDatabase.CreateInParam("@Name",SqlDbType.VarChar,50,name),
220                OperateDatabase.CreateInParam("@Url",SqlDbType.VarChar,255,url)
221            };
222            return (OperateDatabase.RunProc("Pr_UpdateTagUrl