当前文件路径：AjaxMail/App_Code/Filter.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//该源码下载自www.51aspx.com(５１asｐｘ．ｃｏｍ)
14
15namespace Web2ASPNET2.ASPNET2AjaxMail
16...{
17    /**//// <summary>
18    /// Filter 的摘要说明
19    /// </summary>
20    public class Filter
21    ...{
22        public Filter()
23        ...{
24            //
25            // TODO: 在此处添加构造函数逻辑
26            //
27        }
28
29        public DataSet GetFilters()
30        ...{
31            return DataCommon.GetDataByDataSet("Pr_GetAjaxFilters");
32        }
33
34        public SqlDataReader GetSingleFilter(int filterID)
35        ...{
36            return DataCommon.GetDataByReaderIDParam("Pr_GetSingleAjaxFilter",filterID);
37        }
38
39        public int AddFilter(string key,byte flag)
40        ...{
41            SqlParameter[] parameters = ...{
42                OperateDatabase.CreateInParam("@Key",SqlDbType.VarChar,255,key),
43                OperateDatabase.CreateInParam("@Flag",SqlDbType.TinyInt,1,flag)
44            };
45            return (OperateDatabase.RunProc("Pr_AddAjaxFilter",parameters));
46        }
47
48        public int UpdateFilter(int filterID,string key)
49        ...{
50            SqlParameter[] parameters = ...{
51                OperateDatabase.CreateInParam("@ID",SqlDbType.Int,4,filterID),
52                OperateDatabase.CreateInParam("@Key",SqlDbType.VarChar,255,key)
53            };
54            return (OperateDatabase.RunProc("Pr_UpdateAjaxFilter",parameters));
55        }
56
57        public int DeleteFilter(int filterID)
58        ...{
59            return DataCommon.QueryDataIDParam("Pr_DeleteAjaxFilter",filterID);
60        }
61    }
62}
63