当前文件路径：AjaxMail/App_Code/Tag.cs

		            
 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
14namespace Web2ASPNET2.ASPNET2AjaxMail
15...{
16    public class Tag
17    ...{
18        public Tag() ...{ }
19
20        public DataSet GetTagsDS()
21        ...{
22            return DataCommon.GetDataByDataSet("Pr_GetAjaxTags");
23        }
24        public SqlDataReader GetTags()
25        ...{
26            return DataCommon.GetDataByReader("Pr_GetAjaxTags");
27        }
28        public SqlDataReader GetSingleTag(int tagID)
29        ...{
30            return DataCommon.GetDataByReaderIDParam("Pr_GetSingleAjaxTag",tagID);
31        }
32
33        public int AddTag(string name)
34        ...{
35            SqlParameter[] parameters = ...{
36                OperateDatabase.CreateInParam("@Name",SqlDbType.VarChar,50,name)
37            };
38            return (OperateDatabase.RunProc("Pr_AddAjaxTag",parameters));
39        }
40
41        public int AddMailTag(int mailID,int tagID)
42        ...{
43            SqlParameter[] parameters = ...{
44                OperateDatabase.CreateInParam("@MailID",SqlDbType.Int,4,tagID),
45                OperateDatabase.CreateInParam("@TagID",SqlDbType.Int,4,tagID)
46            };
47            return (OperateDatabase.RunProc("Pr_AddAjaxMailTag",parameters));
48        }
49
50        public int UpdateTag(int tagID,string name)
51        ...{
52            SqlParameter[] parameters = ...{
53                OperateDatabase.CreateInParam("@ID",SqlDbType.Int,4,tagID),
54                OperateDatabase.CreateInParam("@Name",SqlDbType.VarChar,50,name)
55            };
56            return (OperateDatabase.RunProc("Pr_UpdateAjaxTag",parameters));
57        }
58
59        public int DeleteTag(int tagID)
60        ...{
61            return DataCommon.QueryDataIDParam("Pr_DeleteAjaxTag",tagID);
62        }
63    }
64}
65