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 Trademark:ITrademark
 11    ...{
 12        private ConfigInfo configInfo = new ConfigInfo();
 13        private string tableName = "Ljh_Trademark";
 14
 15         public Trademark()
 16         ...{
 17             if (!string.IsNullOrEmpty(configInfo.TablePrefix.Trim()))
 18                 tableName = configInfo.TablePrefix + "Trademark";
 19
 20         }
 21
 22         ITrademark member#region ITrademark member
 23
 24
 25         /**//// <summary>
 26         /// add  
 27         /// </summary>
 28         /// <param name="model"></param>
 29         /// <returns>返回ID, 如果发生错误则返回-1</returns>
 30         public int Add(TrademarkInfo model)
 31         ...{
 32             if (model == null)
 33             ...{
 34                 return -1;
 35             }
 36             string commandText = "insert into " + this.tableName + "(ChannelID,ProducerID,TrademarkName,TrademarkPhoto,TrademarkIntro,TrademarkType,Passed,OnTop,IsElite,Hits)  values(@ChannelID,@ProducerID,@TrademarkName,@TrademarkPhoto,@TrademarkIntro,@TrademarkType,@Passed,@OnTop,@IsElite,@Hits)  ";
 37             OleDbParameter[] commandParameters = ...{
 38                Database.MakeInParam("@ChannelID",OleDbType.Integer,4,model.ChannelID),
 39                Database.MakeInParam("@ProducerID",OleDbType.Integer,4,model.ProducerID),
 40                Database.MakeInParam("@TrademarkName",OleDbType.VarWChar,50,model.TrademarkName),
 41                Database.MakeInParam("@TrademarkPhoto",OleDbType.VarWChar,50,model.TrademarkPhoto),
 42                Database.MakeInParam("@TrademarkIntro",OleDbType.VarWChar,0,model.TrademarkIntro),
 43                Database.MakeInParam("@TrademarkType",OleDbType.Integer,4,model.TrademarkType),
 44                Database.MakeInParam("@Passed",OleDbType.UnsignedTinyInt,1,model.Passed),
 45                Database.MakeInParam("@onTop",OleDbType.UnsignedTinyInt,1,model.OnTop),
 46                Database.MakeInParam("@IsElite",OleDbType.UnsignedTinyInt,1,model.IsElite),
 47                Database.MakeInParam("@Hits",OleDbType.Integer,4,model.Hits)
 48         };
 49             int intIdentity = -1;
 50             try
 51             ...{
 52                 Database.ExecuteNonQuery(CommandType.Text, out intIdentity, commandText, commandParameters);
 53             }
 54             catch (Exception exception)
 55             ...{
 56                 throw exception;
 57             }
 58             return intIdentity;
 59         }
 60
 61
 62
 63
 64         /**//// <summary>
 65         /// 删除 
 66         /// </summary>
 67         /// <param name="filter">where后面的条件语句，不加where</param>
 68         /// <returns>返回影响行数</returns>
 69         public int Delete(string filter)
 70         ...{
 71             int count = -1;
 72             string sql = @"delete from " + tableName;
 73             if (!string.IsNullOrEmpty(filter.Trim()))
 74             ...{
 75                 sql = sql + "  where  " + filter;
 76             }
 77             try
 78             ...{
 79
 80                 count = Database.ExecuteNonQuery(sql);
 81             }
 82             catch (Exception ex)
 83             ...{
 84                 throw ex;
 85             }
 86             return count;
 87         }
 88
 89         /**//// <summary>
 90         /// 
 91         /// </summary>
 92         /// <param name="filter"></param>
 93         /// <returns></returns>
 94         public bool Exist(string filter)
 95         ...{
 96             bool result = false;
 97             string sql = @"select * from " + tableName;
 98             if (!string.IsNullOrEmpty(filter))
 99             ...{
100                 sql = sql + "  where  " + filter;
101             }
102             try
103             ...{
104
105
106                 DataSet dataset = new DataSet();
107                 dataset = Database.ExecuteDataSet(sql);
108                 if (dataset.Tables[0].Rows.Count > 0)
109                 ...{
110                     result = true;
111                 }
112             }
113             catch (Exception ex)
114             ...{
115                 throw ex;
116             }
117             return result;
118         }
119
120         /**//// <summary>
121         /// 返回所有
122         /// </summary>
123         /// <returns>返回所有</returns>
124         public DataSet GetDataSet()
125         ...{
126             string sql = "select * from " + tableName;
127             DataSet dataset = new DataSet();
128             try
129             ...{
130
131                 dataset = Database.ExecuteDataSet(sql);
132
133             }
134             catch (Exception ex)
135             ...{
136                 throw ex;
137             }
138             return dataset;
139         }
140
141         public DataSet GetDataSet(string filter)
142         ...{
143             if (string.IsNullOrEmpty(filter))
144                 return null;
145
146             string sql = "select * from " + tableName + " where " + filter;
147             DataSet dataset = new DataSet();
148             try
149             ...{
150
151                 dataset = Database.ExecuteDataSet(sql);
152             }
153             catch (Exception ex)
154             ...{
155                 throw ex;
156             }
157             return dataset;
158         }
159
160         /**//// <summary>
161         ///
162         /// </summary>
163         /// <param name="dr"></param>
164         /// <returns></returns>
165         public TrademarkInfo GetModel(DataRow dr)
166         ...{
167             if (dr == null)
168                 return null;
169             TrademarkInfo model = new TrademarkInfo();
170
171             if (dr["TrademarkID"].ToString() != "") model.TrademarkID = Convert.ToInt32( dr["TrademarkID"]);
172             if (dr["ChannelID"].ToString() != "") model.ChannelID = Convert.ToInt32(  dr["ChannelID"]);
173             if (dr["ProducerID"].ToString() != "") model.ProducerID = Convert.ToInt32(  dr["ProducerID"]);
174             if (dr["TrademarkName"].ToString() != "") model.TrademarkName = dr["TrademarkName"].ToString();
175             if (dr["TrademarkPhoto"].ToString() != "") model.TrademarkPhoto = dr["TrademarkPhoto"].ToString();
176             if (dr["TrademarkIntro"].ToString() != "") model.TrademarkIntro = dr["TrademarkIntro"].ToString();
177             if (dr["TrademarkType"].ToString() != "") model.TrademarkType = Convert.ToInt32(  dr["TrademarkType"]);
178             if (dr["Passed"].ToString() != "") model.Passed = Convert.ToInt32(  dr["Passed"]);
179             if (dr["onTop"].ToString() != "") model.OnTop =  Convert.ToInt32( dr["onTop"]);
180             if (dr["IsElite"].ToString() != "") model.IsElite = Convert.ToInt32(  dr["IsElite"]);
181             if (dr["Hits"].ToString() != "") model.Hits = Convert.ToInt32(  dr["Hits"]);
182
183
184
185             return model;
186         }
187
188         /**//// <summary>
189         /// 
190         /// </summary>
191         /// <param name="sql"></param>
192         /// <returns></returns>
193         public DataSet Query(string sql)
194         ...{
195             if (string.IsNullOrEmpty(sql))
196                 return null;
197
198             DataSet dataset = new DataSet();
199             try
200             ...{
201
202                 dataset = Database.ExecuteDataSet(sql);
203             }
204             catch (Exception ex)
205             ...{
206                 throw ex;
207             }
208             return dataset;
209         }
210
211
212         /**//// <summary>
213         /// update  
214         /// </summary>
215         /// <param name="model"></param>
216         /// <param name="filter"></param>
217         /// <returns></returns>
218         public int Update(TrademarkInfo model, string filter)
219         ...{
220             int result;
221             if (string.IsNullOrEmpty(filter))
222             ...{
223                 throw new Exception("The 'filter' can not be null!");
224             }
225             string sql = @"update " + tableName + " set  ChannelID=@ChannelID,ProducerID=@ProducerID,TrademarkName=@TrademarkName,TrademarkPhoto=@TrademarkPhoto,TrademarkIntro=@TrademarkIntro,TrademarkType=@TrademarkType,Passed=@Passed    ,OnTop=@OnTop,IsElite=@IsElite,Hits=@Hits " + " where " + filter;
226
227
228             OleDbParameter[] prams = ...{
229                Database.MakeInParam("@ChannelID",OleDbType.Integer,4,model.ChannelID),
230                Database.MakeInParam("@ProducerID",OleDbType.Integer,4,model.ProducerID),
231                Database.MakeInParam("@TrademarkName",OleDbType.VarWChar,50,model.TrademarkName),
232                Database.MakeInParam("@TrademarkPhoto",OleDbType.VarWChar,50,model.TrademarkPhoto),
233                Database.MakeInParam("@TrademarkIntro",OleDbType.VarWChar,0,model.TrademarkIntro),
234                Database.MakeInParam("@TrademarkType",OleDbType.Integer,4,model.TrademarkType),
235                Database.MakeInParam("@Passed",OleDbType.UnsignedTinyInt,1,model.Passed),
236                Database.MakeInParam("@onTop",OleDbType.UnsignedTinyInt,1,model.OnTop),
237                Database.MakeInParam("@IsElite",OleDbType.UnsignedTinyInt,1,model.IsElite),
238                Database.MakeInParam("@Hits",OleDbType.Integer,4,model.Hits)
239
240         };
241
242             try
243             ...{
244
245                 result = Database.ExecuteNonQuery(sql, prams);
246             }
247             catch (Exception ex)
248             ...{
249                 throw ex;
250             }
251             return result;
252         }
253
254
255         /**//// <summary>
256         /// 高级查询
257         /// </summary>
258         /// <param name="field"></param>
259         /// <param name="keywords"></param>
260         /// <returns></returns>
261         public DataSet KeywordsSearch(string field, string keywords)
262         ...{
263             OleDbParameter[] parameters = new OleDbParameter[] ...{ Database.MakeInParam("@field", OleDbType.VarWChar, 50, field.ToLower()), Database.MakeInParam("@keywords", OleDbType.VarWChar, 50, keywords.ToLower()) };
264             DataSet set = new DataSet();
265             return Database.ExecuteDataSet("Select * From " + this.tableName + "   Where   @field like '%' + @keywords +'%'   order by [TrademarkId] Desc ", parameters);
266         }
267
268
269         #endregion
270
271     
272     }
273}
274