1using System;
  2using System.Data;
  3using System.Configuration;
  4using System.Web;
  5using System.Text;
  6using System.Collections.Generic;
  7using System.Data.SqlClient;
  8using SQLHelper;
  9using Model;
 10/**//// <summary>
 11/// JobSQL 的摘要说明
 12/// </summary>
 13namespace DAL
 14...{
 15    public class JobSQL
 16    ...{
 17       /**//// <summary>
 18       /// 添加
 19       /// </summary>
 20       /// <param name="job"></param>
 21       /// <returns></returns>
 22        public int Add_Job(Job job)
 23        ...{
 24            SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();
 25            SqlParameter[] ParamList =...{ 
 26                sqlHelper.CreateInParam("@Title",SqlDbType.NVarChar,50,job.Title),
 27                sqlHelper.CreateInParam("@Content",SqlDbType.NText,0,job.Content),
 28                sqlHelper.CreateInParam("@Click",SqlDbType.Int,4,job.Click)
 29            };
 30            try
 31            ...{
 32                return (sqlHelper.RunProc("Add_Job", ParamList));
 33            }
 34            catch (Exception ex)
 35            ...{
 36                SystemError.CreateErrorLog(ex.Message);
 37                throw new Exception(ex.Message, ex);
 38            }
 39        }
 40        /**//// <summary>
 41        /// 修改
 42        /// </summary>
 43        /// <param name="job"></param>
 44        public void Update_Job(Job job)
 45        ...{
 46            SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();
 47            SqlParameter[] ParamList =...{
 48                sqlHelper.CreateInParam("@ID",SqlDbType.Int,4,job.ID),
 49                sqlHelper.CreateInParam("@Title",SqlDbType.NVarChar,50,job.Title),
 50                sqlHelper.CreateInParam("@Content",SqlDbType.NText,0,job.Content),
 51                sqlHelper.CreateInParam("@Click",SqlDbType.Int,4,job.Click)
 52            };
 53            try
 54            ...{
 55                sqlHelper.RunProc("Update_Job", ParamList);
 56            }
 57            catch (Exception ex)
 58            ...{
 59                SystemError.CreateErrorLog(ex.Message);
 60                throw new Exception(ex.Message, ex);
 61            }
 62        }
 63        /**//// <summary>
 64        /// 删除
 65        /// </summary>
 66        /// <param name="nID"></param>
 67        public void Delete_Job(int nID)
 68        ...{
 69             SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();
 70             SqlParameter[] ParamList =...{
 71                sqlHelper.CreateInParam("@ID",SqlDbType.Int,4,nID),
 72            };
 73             try
 74             ...{
 75                 sqlHelper.RunProc("Delete_Job", ParamList);
 76             }
 77             catch (Exception ex)
 78             ...{
 79                 SystemError.CreateErrorLog(ex.Message);
 80                 throw new Exception(ex.Message, ex);
 81             }
 82        }
 83        /**//// <summary>
 84        /// 查看全部
 85        /// </summary>
 86        /// <param name="nstartIndex"></param>
 87        /// <param name="endIndex"></param>
 88        /// <returns></returns>
 89        public List<Job> Get_Job(int nstartIndex, int nendIndex)
 90        ...{
 91            SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();
 92            SqlParameter[] ParamList = ...{ 
 93                sqlHelper.CreateInParam("@startIndex",SqlDbType.Int,4,nstartIndex),
 94                sqlHelper.CreateInParam("@endIndex",SqlDbType.Int,4,nendIndex),
 95                sqlHelper.CreateInParam("@docount",SqlDbType.Bit,1,0)
 96            };
 97            SqlDataReader rec = null;
 98            try
 99            ...{
100                sqlHelper.RunProc("Get_Job", ParamList, out rec);
101            }
102            catch (Exception ex)
103            ...{
104                SystemError.CreateErrorLog(ex.Message);
105                throw new Exception(ex.Message, ex);
106            }
107            List<Job> List_Job = new List<Job>();
108            while (rec.Read())
109            ...{
110                Job job = new Job();
111                job.ID = Int32.Parse(rec["ID"].ToString());
112                job.Title = rec["Title"].ToString();
113                job.Content = rec["Content"].ToString();
114                job.Updatatime = DateTime.Parse(rec["Updatatime"].ToString());
115                job.Click = Int32.Parse(rec["Click"].ToString());
116                List_Job.Add(job);
117                job = null;
118            }
119            return (List_Job);
120        }
121        /**//// <summary>
122        /// 查看总数
123        /// </summary>
124        /// <returns></returns>
125        public int Get_JobNum()
126        ...{
127            SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();
128            SqlParameter[] ParamList = ...{ 
129                sqlHelper.CreateInParam("@startIndex",SqlDbType.Int,4,1),
130                sqlHelper.CreateInParam("@endIndex",SqlDbType.Int,4,1),
131                sqlHelper.CreateInParam("@docount",SqlDbType.Bit,1,1)
132            };
133            SqlDataReader rec = null;
134            try
135            ...{
136                sqlHelper.RunProc("Get_Job", ParamList, out rec);
137            }
138            catch (Exception ex)
139            ...{
140                SystemError.CreateErrorLog(ex.Message);
141                throw new Exception(ex.Message, ex);
142            }
143            int Num = 0;
144            while (rec.Read())
145            ...{
146                Num = Int32.Parse(rec["Counts"].ToString());
147            }
148            return Num;
149        }
150        /**//// <summary>
151        /// 查看单个
152        /// </summary>
153        /// <param name="nID"></param>
154        /// <returns></returns>
155        public Job Get_SingJob(int nID)
156        ...{
157             SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();
158             SqlParameter[] ParamList = ...{ sqlHelper.CreateInParam("@ID", SqlDbType.Int, 4, nID) };
159             SqlDataReader rec = null;
160             try
161             ...{
162                 sqlHelper.RunProc("Get_SingJob", ParamList, out rec);
163             }
164             catch (Exception ex)
165             ...{
166                 SystemError.CreateErrorLog(ex.Message);
167                 throw new Exception(ex.Message, ex);
168             }
169             Job job = new Job();
170             while (rec.Read())
171             ...{
172                 job.ID = Int32.Parse(rec["ID"].ToString());
173                 job.Title = rec["Title"].ToString();
174                 job.Content = rec["Content"].ToString();
175                 job.Updatatime = DateTime.Parse(rec["Updatatime"].ToString());
176                 job.Click = Int32.Parse(rec["Click"].ToString());
177             }
178             return job;
179        }
180    }
181}
182