当前文件：
MyShop080617/AccessDAL/DeliverType.cs[7K，2009-6-12 11:48:22]，
打开代码结构图
1
using System;
2using System.Collections.Generic;
3
4using System.Data;
5using System.Data.OleDb;
6using MyShop.IDAL;
7using MyShop.Model;
8
9namespace MyShop.AccessDAL
10
...{
11
public class DeliverType : IDeliverType
12
...{
13
14 private ConfigInfo configInfo = new ConfigInfo();
15 private string tableName = "Ljh_DeliverType";
16 public DeliverType()
17 ...{
18 if (!string.IsNullOrEmpty(configInfo.TablePrefix.Trim()))
19 tableName = configInfo.TablePrefix + "DeliverType";
20
}
21
22 IDeliverType member#region IDeliverType member
23
24 /**//// <summary>
25 /// 添加
26 /// </summary>
27 /// <param name="model"></param>
28 /// <returns>返回ID, 如果发生错误则返回-1</returns>
29 public int Add(DeliverTypeInfo model)
30 ...{
31 if (model == null)
32 ...{
33 return 0;
34 }
35 string commandText = "insert into " + this.tableName + "(typeName,intro,isDefault,isDisabled,orderId,charge) values(@typeName,@intro,@isDefault,@isDisabled,@orderId,@charge) ";
36 OleDbParameter[] commandParameters = ...{
37 Database.MakeInParam("@TypeName",OleDbType.VarWChar,50,model.TypeName),
38 Database.MakeInParam("@Intro",OleDbType.VarWChar,255,model.Intro),
39 Database.MakeInParam("@IsDefault",OleDbType.UnsignedTinyInt,1,model.IsDefault),
40 Database.MakeInParam("@IsDisabled",OleDbType.UnsignedTinyInt,1,model.IsDisabled),
41 Database.MakeInParam("@OrderId",OleDbType.Integer,4,model.OrderId),
42 Database.MakeInParam("@Charge",OleDbType.Currency,8,model.Charge),
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">UserName=condition|UserName and password</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.Trim()))
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 /**//// <summary>
137 ///
138 /// </summary>
139 /// <param name="filter"></param>
140 /// <returns></returns>
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 DeliverTypeInfo GetModel(DataRow dr)
166 ...{
167 if (dr == null)
168 return null;
169 DeliverTypeInfo model = new DeliverTypeInfo();
170
171 if (dr["TypeId"].ToString() != "")
172 model.TypeId = Convert.ToInt32(dr["TypeId"]);
173 if (dr["typeName"].ToString() != "")
174 model.TypeName = dr["typeName"].ToString();
175 if (dr["intro"].ToString() != "")
176 model.Intro = dr["intro"].ToString();
177 if (dr["IsDefault"].ToString() != "")
178 model.IsDefault = Convert.ToInt32( dr["IsDefault"]);
179 if (dr["IsDisabled"].ToString() != "")
180 model.IsDisabled = Convert.ToInt32( dr["IsDisabled"]);
181 if (dr["OrderId"].ToString() != "")
182 model.OrderId = Convert.ToInt32(dr["OrderId"]);
183 if (dr["Charge"].ToString() != "")
184 model.Charge = Convert.ToDecimal(dr["Charge"]);
185
186 return model;
187 }
188
189 /**//// <summary>
190 ///
191 /// </summary>
192 /// <param name="sql"></param>
193 /// <returns></returns>
194 public DataSet Query(string sql)
195 ...{
196 if (string.IsNullOrEmpty(sql))
197 return null;
198
199 DataSet dataset = new DataSet();
200 try
201 ...{
202
203 dataset = Database.ExecuteDataSet(sql);
204 }
205 catch (Exception ex)
206 ...{
207 throw ex;
208 }
209 return dataset;
210 }
211
212 /**//// <summary>
213 ///
214 /// </summary>
215 /// <param name="model"></param>
216 /// <param name="filter"></param>
217 /// <returns></returns>
218 public int Update(DeliverTypeInfo 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 typeName=@typeName,intro=@intro,isDefault=@isDefault,isDisabled=@isDisabled,orderId=@orderId,charge=@charge " + " where " + filter;
226 OleDbParameter[] prams = ...{
227 Database.MakeInParam("@TypeName",OleDbType.VarWChar,50,model.TypeName),
228 Database.MakeInParam("@Intro",OleDbType.VarWChar,255,model.Intro),
229 Database.MakeInParam("@IsDefault",OleDbType.UnsignedTinyInt,1,model.IsDefault),
230 Database.MakeInParam("@IsDisabled",OleDbType.UnsignedTinyInt,1,model.IsDisabled),
231 Database.MakeInParam("@OrderId",OleDbType.Integer,4,model.OrderId),
232 Database.MakeInParam("@Charge",OleDbType.Currency,8,model.Charge),
233 };
234
235 try
236 ...{
237
238 result = Database.ExecuteNonQuery(sql, prams);
239 }
240 catch (Exception ex)
241 ...{
242 throw ex;
243 }
244 return result;
245 }
246
247 #endregion
248
249
250 }
251
}
252
打包下载该项目完整源码：MyShop网络商城080617源码