wsaspx文章管理系统开发笔记(2)

数据提供者还有一个Error类.一并发上来.

 1using System;
 2using System.Diagnostics;
 3
 4namespace WsAspx
 5{
 6    /**//// <summary>
 7    /// 记录错误日志.
 8    /// </summary>
 9    public class Error 
10    {
11        const string EVENT_LOG_SOURCE = ".NET WsAspx";
12
13        /**//// <summary>
14        /// 将日志信息写入应用程序日志中
15        /// </summary>
16        /// <param name="message">日志信息.</param>
17        public static void Log(string message) 
18        {
19            EventLog m_eventLog = null;
20
21            // 确保有日志信息
22            if (!(EventLog.SourceExists(EVENT_LOG_SOURCE))) 
23            {
24                EventLog.CreateEventSource(EVENT_LOG_SOURCE, "Application");
25            }
26
27            if (m_eventLog == null) 
28            {
29                m_eventLog = new EventLog("Application");
30                m_eventLog.Source = EVENT_LOG_SOURCE;
31            }
32            
33            // 写日志信息
34            m_eventLog.WriteEntry(message, System.Diagnostics.EventLogEntryType.Error);
35        }
36    }
37}
38

看名字就知道它是干什么的了.
我现在写了一个NewsClass类.

  1using System;
  2using System.Data;
  3using System.Data.SqlClient;
  4
  5namespace WsAspx
  6{
  7    /**//// <summary>
  8    /// WsNewsClass 的摘要说明。
  9    /// </summary>
 10    public class NewsClass{
 11        public NewsClass(){
 12            _newsclassid = this.NewsClassID;
 13        }
 14        /**//// <summary>
 15        /// 重载的构造函数以初始化NewsClass类
 16        /// </summary>
 17        /// <param name="newsclassid"></param>
 18        public NewsClass(int newsclassid)
 19        {
 20            SqlDataReader reader = null;
 21            WsDataProvider ws = new WsDataProvider();
 22            SqlParameter[] prams = {ws.MakeInParam("@NewsClassID",SqlDbType.Int,4,newsclassid)};
 23            try
 24            {
 25                ws.RunProc("addws_newsclass_getone",prams,out reader);
 26                if(reader.Read())
 27                {
 28                    _newsclassid = reader.GetInt32(0);
 29                    _newssmallclassid  = reader.GetInt32(1);
 30                    _newsclassname = reader.GetString(2);
 31                    _orders=reader.GetInt32(3);
 32                    _isindextransfer = reader.GetInt32(4);
 33                    _isauditing = reader.GetInt32(5);
 34                    return;
 35                }
 36                else{
 37                    _newsclassid = 0;
 38                    _newssmallclassid  = 0;
 39                    _newsclassname = "";
 40                    _orders=0;
 41                    _isindextransfer = 0;
 42                    _isauditing = 0;
 43                }
 44            }
 45            catch(Exception ex)
 46            {
 47                Error.Log(ex.ToString());
 48                return ;
 49            }
 50            finally
 51            {
 52                reader.Close();
 53            }
 54        }
 55        /**//// <summary>
 56        /// NewsClass的属性
 57        /// </summary>
 58        public ----NewsClassDetail属性#region public ----NewsClassDetail属性
 59
 60        // NewsClassDetail属性
 61
 62        public int NewsClassID
 63        {
 64            get
 65            {
 66                return _newsclassid;
 67            }
 68            set
 69            {
 70                _newsclassid = value;
 71            }
 72        }
 73        public string NewsClassName
 74        {
 75            get
 76            {
 77                return _newsclassname;
 78            }
 79            set
 80            {
 81                _newsclassname = value;
 82            }
 83        }
 84        public int NewsSmallClassID
 85        {
 86            get
 87            {
 88                return _newssmallclassid;
 89            }
 90            set
 91            {
 92                _newssmallclassid = value;
 93            }
 94        }
 95        public int Orders
 96        {
 97            get
 98            {
 99                return _orders;
100            }
101            set
102            {
103                _orders = value;
104            }
105        }
106        public int IsIndexTransfer
107        {
108            get
109            {
110                return _isindextransfer;
111            }
112            set
113            {
114                _isindextransfer = value;
115            }
116        }
117        public int IsAuditing
118        {
119            get
120            {
121                return _isauditing;
122            }
123            set
124            {
125                _isauditing = value;
126            }
127        }
128        #endregion
129
130        /**//// <summary>
131        /// 添加NewsClass记录,成功后返回NewsClassName
132        /// </summary>
133        /// <param name="newssmallclassid">0:作为一级分类 ; >0 作为某分类下的二级分类</param>
134        /// <param name="newsclassname">NewsClassName的值</param>
135        /// <param name="orders">排序</param>
136        /// <param name="isindextransfer">是否首页调用</param>
137        /// <param name="isauditing">是否需要审核</param>
138        public string CreatNewsClass(int newssmallclassid,string newsclassname,int orders,int isindextransfer,int isauditing)
139        {
140            WsDataProvider ws = new WsDataProvider();
141            SqlParameter[] prams = {ws.MakeInParam("@NewsSmallClassID",SqlDbType.Int,4,newssmallclassid),
142                                       ws.MakeInParam("@NewsClassName",SqlDbType.NVarChar,50,newsclassname),
143                                       ws.MakeInParam("@Orders",SqlDbType.Int ,4,orders),
144                                       ws.MakeInParam("@IsIndexTransfer",SqlDbType.Int ,4 , isindextransfer),
145                                       ws.MakeInParam("@IsAuditing",SqlDbType.Int ,4,isauditing)
146                                   };
147            try
148            {
149                int retval = ws.RunProc("addws_newsclass_creat",prams);
150                if(retval==0)
151                    return newsclassname;
152                else
153                    return null;
154            }
155            catch(Exception ex)
156            {
157                Error.Log(ex.ToString());
158                return null;
159            }
160        }
161
162        /**//// <summary>
163        /// 更新NewsClass记录,无返回值
164        /// </summary>
165        /// <param name="newsclassid">要更新的记录的ID</param>
166        /// <param name="newssmallclassid">NewsSmallClassID</param>
167        /// <param name="newsclassname">NewsClassName</param>
168        /// <param name="orders">Orders</param>
169        /// <param name="isindextransfer">IsIndexTransfer</param>
170        /// <param name="isauditing">IsAuditing</param>
171        public void UpdateNewsClass(int newsclassid,int newssmallclassid,string newsclassname,int orders,int isindextransfer,int isauditing)
172        {
173            WsDataProvider ws = new WsDataProvider();
174            SqlParameter[] prams = {
175                                       ws.MakeInParam("@NewsClassID",SqlDbType.Int,4,newsclassid),
176                                       ws.MakeInParam("@NewsSmallClassID",SqlDbType.Int,4,newssmallclassid),
177                                       ws.MakeInParam("@NewsClassName",SqlDbType.NVarChar,50,newsclassname),
178                                       ws.MakeInParam("@Orders",SqlDbType.Int ,4,orders),
179                                       ws.MakeInParam("@IsIndexTransfer",SqlDbType.Int ,4 , isindextransfer),
180                                       ws.MakeInParam("@IsAuditing",SqlDbType.Int ,4,isauditing)
181                                   };
182            try
183            {
184                ws.RunProc("addws_newsclass_update",prams);
185            }
186            catch(Exception ex)
187            {
188                Error.Log(ex.ToString());
189            }
190        }
191
192        /**//// <summary>
193        /// 删除NewsClass记录,无返回值
194        /// </summary>
195        /// <param name="newsclassid">NewsClassID</param>
196        public void DeleteNewsClass(int newsclassid)
197        {
198            WsDataProvider ws = new WsDataProvider();
199            SqlParameter[] prams={ws.MakeInParam("@NewsClassID",SqlDbType.Int,4,newsclassid)};
200            try
201            {
202                ws.RunProc("addws_newsclass_del",prams);
203            }
204            catch(Exception ex)
205            {
206                Error.Log(ex.ToString());
207            }
208        }
209
210        /**//// <summary>
211        /// 获取所有父NewsClass的DataReader
212        /// </summary>
213        /// <returns>返回父NewsClass的DataReader</returns>
214        public SqlDataReader GetParentNewsClassReader()
215        {
216            SqlDataReader reader = null ;
217            WsDataProvider ws = new WsDataProvider();
218            try
219            {
220                ws.RunProc("addws_newsclass_parent",out reader);
221                return reader;
222            }
223            catch(Exception ex)
224            {
225                Error.Log(ex.ToString());
226                return null;
227            }
228        }
229
230        public SqlDataReader GetChildNewsClassReader(int ParentID)
231        {
232            SqlDataReader reader = null;
233            WsDataProvider ws = new WsDataProvider();
234            SqlParameter[] prams={ws.MakeInParam("@NewsClassID",SqlDbType.Int,4,ParentID)};
235            try
236            {
237                ws.RunProc("addws_newsclass_child",prams);
238                return reader;
239            }
240            catch(Exception ex)
241            {
242                Error.Log(ex.ToString());
243                return null;
244            }
245        }
246        
247        // NewsClassDetail私有成员
248
249        private int _newsclassid;
250        private int _newssmallclassid;
251        private string _newsclassname;
252        private int _orders;
253        private int _isindextransfer;
254        private int _isauditing;
255    }
256}
257

到这里为止,与NewsClass对象有关系的操作基本都在这里了.