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