当前文件：
MyShop080617/AccessDAL/AboutUs.cs[6K，2009-6-12 11:48:22]，
打开代码结构图
1
using System;
2using System.Collections.Generic;
3using System.Data;
4using System.Data.OleDb;
5using MyShop.IDAL;
6using MyShop.Model;
7
8namespace MyShop.SQLServerDAL
9
...{
10
public class AboutUs : IAboutUs
11
...{
12
13 private ConfigInfo configInfo = new ConfigInfo();
14 private string tableName = "Ljh_AboutUs";
15
16 public AboutUs()
17 ...{
18 if (!string.IsNullOrEmpty(configInfo.TablePrefix.Trim()))
19 tableName = configInfo.TablePrefix + "AboutUs";
20
}
21
22 IAboutUs member#region IAboutUs member
23
24
25 /**//// <summary>
26 /// add
27 /// </summary>
28 /// <param name="model"></param>
29 /// <returns>返回ID, 如果发生错误则返回-1</returns>
30 public int Add(AboutUsInfo model)
31 ...{
32 int result;
33 if (model == null)
34 ...{
35 return -1;
36 }
37 string sql = @"insert into " + tableName + "(Title,Content,OrderID) " +
38 " values(@Title,@Content,@OrderID)" + " ;SELECT @@IDENTITY ";
39
40 SqlParameter[] prams = ...{
41 Database.MakeInParam("@Title", OleDbType.VarWChar, 0 ,model.Title),
42 Database.MakeInParam("@Content", OleDbType.VarWChar, 50 ,model.Content),
43 Database.MakeInParam("@OrderID", OleDbType.Integer, 4 ,model.OrderID)
44 };
45
46
47 try
48 ...{
49
50 result = (Convert.ToInt32(Database.ExecuteDataSet(sql, prams).Tables[0].Rows[0][0]));
51 }
52 catch
53 ...{
54 result = -1;
55 }
56 return result;
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 AboutUsInfo GetModel(DataRow dr)
161 ...{
162 if (dr == null)
163 return null;
164 AboutUsInfo model = new AboutUsInfo();
165
166 if (dr["TitleID"].ToString() != "") model.TitleID = Convert.ToInt32( dr["TitleID"]);
167 if (dr["Title"].ToString() != "") model.Title = dr["Title"].ToString();
168 if (dr["Content"].ToString() != "") model.Content = dr["Content"].ToString();
169 if (dr["OrderID"].ToString() != "") model.OrderID = Convert.ToInt32( dr["OrderID"]);
170
171
172
173 return model;
174 }
175
176 /**//// <summary>
177 ///
178 /// </summary>
179 /// <param name="sql"></param>
180 /// <returns></returns>
181 public DataSet Query(string sql)
182 ...{
183 if (string.IsNullOrEmpty(sql))
184 return null;
185
186 DataSet dataset = new DataSet();
187 try
188 ...{
189
190 dataset = Database.ExecuteDataSet(sql);
191 }
192 catch (Exception ex)
193 ...{
194 throw ex;
195 }
196 return dataset;
197 }
198
199
200 /**//// <summary>
201 /// update
202 /// </summary>
203 /// <param name="model"></param>
204 /// <param name="filter"></param>
205 /// <returns></returns>
206 public int Update(AboutUsInfo model, string filter)
207 ...{
208 int result;
209 if (string.IsNullOrEmpty(filter))
210 ...{
211 throw new Exception("The 'filter' can not be null!");
212 }
213 string sql = @"update " + tableName + " set Title=@Title,Content=@Content,OrderID=@OrderID " + " where " + filter;
214
215
216 SqlParameter[] prams = ...{
217 Database.MakeInParam("@Title", OleDbType.VarWChar, 0 ,model.Title),
218 Database.MakeInParam("@Content", OleDbType.VarWChar, 50 ,model.Content),
219 Database.MakeInParam("@OrderID", OleDbType.Integer, 4 ,model.OrderID)
220 };
221
222 try
223 ...{
224
225 result = Database.ExecuteNonQuery(sql, prams);
226 }
227 catch (Exception ex)
228 ...{
229 throw ex;
230 }
231 return result;
232 }
233
234
235 #endregion
236 }
237
}
238
打包下载该项目完整源码：MyShop网络商城080617源码