1using System;
  2using System.Collections.Generic;
  3using System.Data;
  4using System.Data.OleDb;
  5using MyShop.IDAL;
  6using MyShop.Model;
  7
  8namespace MyShop.AccessDAL
  9...{
 10    public class Vote : IVote
 11    ...{
 12
 13        private ConfigInfo configInfo = new ConfigInfo();
 14        private string tableName = "Ljh_Vote";
 15
 16        public Vote()
 17        ...{
 18            if (!string.IsNullOrEmpty(configInfo.TablePrefix.Trim()))
 19                tableName = configInfo.TablePrefix + "Vote";
 20        }
 21
 22        IVote member#region IVote member
 23
 24
 25        /**//// <summary>
 26        /// add  
 27        /// </summary>
 28        /// <param name="model"></param>
 29        /// <returns>返回ID, 如果发生错误则返回-1</returns>
 30        public int Add(VoteInfo model)
 31        ...{
 32            if (model == null)
 33            ...{
 34                return -1;
 35            }
 36            string commandText = "insert into " + this.tableName + "(Title,Content,Number,VoteTime,EndTime,VoteType,IsSelected)  values(@Title,@Content,@Number,@VoteTime,@EndTime,@VoteType,@IsSelected)  ";
 37            OleDbParameter[] commandParameters = 
 38                ...{
 39                Database.MakeInParam("@Title", OleDbType.VarWChar        ,    0    ,model.Title    ),
 40                Database.MakeInParam("@Content", OleDbType.VarWChar    ,    0    ,model.Content    ),
 41                Database.MakeInParam("@Number", OleDbType.VarWChar    ,    0    ,model.Number    ),
 42                Database.MakeInParam("@VoteTime", OleDbType.Date    ,    8    ,model.VoteTime    ),
 43                Database.MakeInParam("@EndTime", OleDbType.Date    ,    8    ,model.EndTime    ),
 44                Database.MakeInParam("@VoteType", OleDbType.UnsignedTinyInt    ,    1    ,model.VoteType    ),
 45                Database.MakeInParam("@IsSelected", OleDbType.UnsignedTinyInt    ,    1    ,model.IsSelected    )
 46         };
 47
 48            int intIdentity = -1;
 49            try
 50            ...{
 51                Database.ExecuteNonQuery(CommandType.Text, out intIdentity, commandText, commandParameters);
 52            }
 53            catch (Exception exception)
 54            ...{
 55                throw exception;
 56            }
 57            return intIdentity;
 58        }
 59
 60
 61
 62
 63        /**//// <summary>
 64        /// 删除 
 65        /// </summary>
 66        /// <param name="filter">where后面的条件语句，不加where</param>
 67        /// <returns>返回影响行数</returns>
 68        public int Delete(string filter)
 69        ...{
 70            int count = -1;
 71            string sql = @"delete from " + tableName;
 72            if (!string.IsNullOrEmpty(filter.Trim()))
 73            ...{
 74                sql = sql + "  where  " + filter;
 75            }
 76            try
 77            ...{
 78
 79                count = Database.ExecuteNonQuery(sql);
 80            }
 81            catch (Exception ex)
 82            ...{
 83                throw ex;
 84            }
 85            return count;
 86        }
 87
 88        /**//// <summary>
 89        /// 
 90        /// </summary>
 91        /// <param name="filter"></param>
 92        /// <returns></returns>
 93        public bool Exist(string filter)
 94        ...{
 95            bool result = false;
 96            string sql = @"select * from " + tableName;
 97            if (!string.IsNullOrEmpty(filter))
 98            ...{
 99                sql = sql + "  where  " + filter;
100            }
101            try
102            ...{
103
104
105                DataSet dataset = new DataSet();
106                dataset = Database.ExecuteDataSet(sql);
107                if (dataset.Tables[0].Rows.Count > 0)
108                ...{
109                    result = true;
110                }
111            }
112            catch (Exception ex)
113            ...{
114                throw ex;
115            }
116            return result;
117        }
118
119        /**//// <summary>
120        /// 返回所有
121        /// </summary>
122        /// <returns>返回所有</returns>
123        public DataSet GetDataSet()
124        ...{
125            string sql = "select * from " + tableName;
126            DataSet dataset = new DataSet();
127            try
128            ...{
129
130                dataset = Database.ExecuteDataSet(sql);
131
132            }
133            catch (Exception ex)
134            ...{
135                throw ex;
136            }
137            return dataset;
138        }
139
140        public DataSet GetDataSet(string filter)
141        ...{
142            if (string.IsNullOrEmpty(filter))
143                return null;
144
145            string sql = "select * from " + tableName + " where " + filter;
146            DataSet dataset = new DataSet();
147            try
148            ...{
149
150                dataset = Database.ExecuteDataSet(sql);
151            }
152            catch (Exception ex)
153            ...{
154                throw ex;
155            }
156            return dataset;
157        }
158
159        /**//// <summary>
160        ///
161        /// </summary>
162        /// <param name="dr"></param>
163        /// <returns></returns>
164        public VoteInfo GetModel(DataRow dr)
165        ...{
166            if (dr == null)
167                return null;
168            VoteInfo model = new VoteInfo();
169
170            if (dr["ID"].ToString() != "") model.ID = Convert.ToInt32( dr["ID"]);
171            if (dr["Title"].ToString() != "") model.Title = dr["Title"].ToString();
172            if (dr["Content"].ToString() != "") model.Content = dr["Content"].ToString();
173            if (dr["Number"].ToString() != "") model.Number = dr["Number"].ToString();
174            if (dr["VoteTime"].ToString() != "") model.VoteTime = dr["VoteTime"].ToString();
175            if (dr["EndTime"].ToString() != "") model.EndTime = dr["EndTime"].ToString();
176            if (dr["VoteType"].ToString() != "") model.VoteType =Convert.ToInt32( dr["VoteType"]);
177            if (dr["IsSelected"].ToString() != "") model.IsSelected = Convert.ToInt32( dr["IsSelected"]);
178
179
180            return model;
181        }
182
183        /**//// <summary>
184        /// 
185        /// </summary>
186        /// <param name="sql"></param>
187        /// <returns></returns>
188        public DataSet Query(string sql)
189        ...{
190            if (string.IsNullOrEmpty(sql))
191                return null;
192
193            DataSet dataset = new DataSet();
194            try
195            ...{
196
197                dataset = Database.ExecuteDataSet(sql);
198            }
199            catch (Exception ex)
200            ...{
201                throw ex;
202            }
203            return dataset;
204        }
205
206
207        /**//// <summary>
208        /// update  
209        /// </summary>
210        /// <param name="model"></param>
211        /// <param name="filter"></param>
212        /// <returns></returns>
213        public int Update(VoteInfo model, string filter)
214        ...{
215            int result;
216            if (string.IsNullOrEmpty(filter))
217            ...{
218                throw new Exception("The 'filter' can not be null!");
219            }
220            string sql = @"update " + tableName + " set Title=@Title,Content=@Content,[Number]=@Number,VoteTime=@VoteTime,EndTime=@EndTime,VoteType=@VoteType,IsSelected=@IsSelected " + " where " + filter;
221
222            OleDbParameter[] prams = ...{
223                Database.MakeInParam("@Title", OleDbType.VarWChar        ,    0    ,model.Title    ),
224                Database.MakeInParam("@Content", OleDbType.VarWChar    ,    0    ,model.Content    ),
225                Database.MakeInParam("@Number", OleDbType.VarWChar    ,    0    ,model.Number    ),
226                Database.MakeInParam("@VoteTime", OleDbType.Date    ,    8    ,model.VoteTime    ),
227                Database.MakeInParam("@EndTime", OleDbType.Date    ,    8    ,model.EndTime    ),
228                Database.MakeInParam("@VoteType", OleDbType.UnsignedTinyInt    ,    1    ,model.VoteType    ),
229                Database.MakeInParam("@IsSelected", OleDbType.UnsignedTinyInt    ,    1    ,model.IsSelected    ),
230         };
231
232            try
233            ...{
234
235                result = Database.ExecuteNonQuery(sql, prams);
236            }
237            catch (Exception ex)
238            ...{
239                throw ex;
240            }
241            return result;
242        }
243
244
245        #endregion
246    }
247}
248