当前文件路径：JobSiteStarterKit/App_Code/BOL/Company.cs 
1
Using directives#region Using directives
2
3using System;
4using System.Collections.Generic;
5using System.Text;
6using JobSiteStarterKit.DAL;
7using System.Data;
8using System.Data.SqlClient;
9
10
#endregion
11
12namespace JobSiteStarterKit.BOL
13...{
14
/**//// <summary>
15 /// 公司信息类
16
/// </summary>
17 public class Company
18 ...{
19 private int intCompanyID;
20 private string strUserName;
21
22 private string strCompanyName;
23 private string strBriefProfile;
24
25 private string strAddress1;
26 private string strAddress2;
27 private string strCity;
28 private int intStateID;
29 private int intCountryID;
30 private string strZIP;
31
32 private string strPhone;
33 private string strFax;
34 private string strEmail;
35 private string strWebSiteUrl;
36
37
38
39 public int CompanyID
40 ...{
41 get
42 ...{
43 return intCompanyID;
44 }
45 set
46 ...{
47 intCompanyID = value;
48 }
49 }
50
51 public string UserName
52 ...{
53 get
54 ...{
55 return strUserName;
56 }
57 set
58 ...{
59 strUserName = value;
60 }
61 }
62
63 public string CompanyName
64 ...{
65 get
66 ...{
67 return strCompanyName;
68 }
69 set
70 ...{
71 strCompanyName = value;
72 }
73 }
74
75 public string BriefProfile
76 ...{
77 get
78 ...{
79 return strBriefProfile;
80 }
81 set
82 ...{
83 strBriefProfile = value;
84 }
85 }
86
87 public string Address1
88 ...{
89 get
90 ...{
91 return strAddress1;
92 }
93 set
94 ...{
95 strAddress1 = value;
96 }
97 }
98
99 public string Address2
100 ...{
101 get
102 ...{
103 return strAddress2;
104 }
105 set
106 ...{
107 strAddress2 = value;
108 }
109 }
110
111 public string City
112 ...{
113 get
114 ...{
115 return strCity;
116 }
117 set
118 ...{
119 strCity = value;
120 }
121 }
122
123 public int StateID
124 ...{
125 get
126 ...{
127 return intStateID;
128 }
129 set
130 ...{
131 intStateID = value;
132 }
133 }
134
135 public int CountryID
136 ...{
137 get
138 ...{
139 return intCountryID;
140 }
141 set
142 ...{
143 intCountryID = value;
144 }
145
146 }
147
148 public string ZIP
149 ...{
150 get
151 ...{
152 return strZIP;
153 }
154 set
155 ...{
156 strZIP = value;
157 }
158 }
159
160 public string Phone
161 ...{
162 get
163 ...{
164 return strPhone;
165 }
166 set
167 ...{
168 strPhone = value;
169 }
170 }
171
172 public string Fax
173 ...{
174 get
175 ...{
176 return strFax;
177 }
178 set
179 ...{
180 strFax = value;
181 }
182 }
183 public string Email
184 ...{
185 get
186 ...{
187 return strEmail;
188 }
189 set
190 ...{
191 strEmail = value;
192 }
193 }
194 public string WebSiteUrl
195 ...{
196 get
197 ...{
198 return strWebSiteUrl;
199 }
200 set
201 ...{
202 strWebSiteUrl = value;
203 }
204 }
205 /**//// <summary>
206 /// 插入一个新的公司
207 /// </summary>
208 /// <param name="c">Company类的实例</param>
209 /// <returns>返回插入所影响的行数</returns>
210 public static int Insert(Company c)
211 ...{
212 DBAccess db = new DBAccess();
213
214 SqlParameter objParam = new SqlParameter("@iCompanyID",0);
215 objParam.Direction = ParameterDirection.Output;
216
217 db.Parameters.Add(new SqlParameter("@sUserName", c.UserName));
218 db.Parameters.Add(new SqlParameter("@sCompanyName", c.CompanyName));
219 db.Parameters.Add(new SqlParameter("@sAddress1", c.Address1));
220 db.Parameters.Add(new SqlParameter("@sAddress2", c.Address2));
221 db.Parameters.Add(new SqlParameter("@sCity", c.City));
222 db.Parameters.Add(new SqlParameter("@iStateID", c.StateID));
223 db.Parameters.Add(new SqlParameter("@iCountryID", c.CountryID));
224 db.Parameters.Add(new SqlParameter("@sZip", c.ZIP));
225 db.Parameters.Add(new SqlParameter("@sPhone", c.Phone));
226 db.Parameters.Add(new SqlParameter("@sFax", c.Fax));
227 db.Parameters.Add(new SqlParameter("@sCompanyEmail", c.Email));
228 db.Parameters.Add(new SqlParameter("@sWebSiteUrl", c.WebSiteUrl));
229 db.Parameters.Add(new SqlParameter("@sCompanyProfile", c.BriefProfile));
230 db.Parameters.Add(objParam);
231
232 int retval = db.ExecuteNonQuery("JobsDb_Companies_Insert");
233 if (retval == 1)
234 ...{
235 return int.Parse(objParam.Value.ToString());
236 }
237 else
238 ...{
239 return -1;
240 }
241
242 }
243 /**//// <summary>
244 /// 更新公司信息到数据库
245 /// </summary>
246 /// <param name="c">Company类的实例</param>
247 /// <returns>返回更新所影响的行数</returns>
248 public static int Update(Company c)
249 ...{
250 DBAccess db = new DBAccess();
251
252 db.Parameters.Add(new SqlParameter("@iCompanyID", c.CompanyID));
253 db.Parameters.Add(new SqlParameter("@sUserName", c.UserName));
254 db.Parameters.Add(new SqlParameter("@sCompanyName", c.CompanyName));
255 db.Parameters.Add(new SqlParameter("@sAddress1", c.Address1));
256 db.Parameters.Add(new SqlParameter("@sAddress2", c.Address2));
257 db.Parameters.Add(new SqlParameter("@sCity", c.City));
258 db.Parameters.Add(new SqlParameter("@iStateID", c.StateID));
259 db.Parameters.Add(new SqlParameter("@iCountryID", c.CountryID));
260 db.Parameters.Add(new SqlParameter("@sZip", c.ZIP));
261 db.Parameters.Add(new SqlParameter("@sPhone", c.Phone));
262 db.Parameters.Add(new SqlParameter("@sFax", c.Fax));
263 db.Parameters.Add(new SqlParameter("@sCompanyEmail", c.Email));
264 db.Parameters.Add(new SqlParameter("@sWebSiteUrl", c.WebSiteUrl));
265 db.Parameters.Add(new SqlParameter("@sCompanyProfile", c.BriefProfile));
266
267 int retval = db.ExecuteNonQuery("JobsDb_Companies_Update");
268
269 return retval;
270 }
271 /**//// <summary>
272 /// 通过username获取Company类的实例
273 /// </summary>
274 /// <param name="username">指定的用户名称</param>
275 /// <returns>返回一个Company类的新实例</returns>
276 public static Company GetCompany(string username)
277 ...{
278 DBAccess db = new DBAccess();
279 db.Parameters.Add(new SqlParameter("@sUserName", username));
280 SqlDataReader dr = (SqlDataReader)db.ExecuteReader("JobsDb_Companies_SelectByUserName");
281 if (dr.HasRows)
282 ...{
283 Company c = new Company();
284 while (dr.Read())
285 ...{
286 c.CompanyID = dr.GetInt32(dr.GetOrdinal("companyid"));
287 c.CompanyName = dr.GetString(dr.GetOrdinal("CompanyName"));
288 c.BriefProfile = dr.GetString(dr.GetOrdinal("CompanyProfile"));
289 c.WebSiteUrl = dr.GetString(dr.GetOrdinal("
