当前文件路径：JobSiteStarterKit/App_Code/BOL/ExperienceLevel.cs

		            
 1Using directives#region Using directives
 2
 3using System;
 4using System.Collections.Generic;
 5using System.Text;
 6using System.Data;
 7using System.Data.SqlClient;
 8using JobSiteStarterKit.DAL;
 9
10#endregion
11
12namespace JobSiteStarterKit.BOL
13...{
14    public class ExperienceLevel
15    ...{
16
17        private int intExpLevelID;
18        private string strExpLevelName;
19
20        public int ExperienceLevelID
21        ...{
22            get
23            ...{
24                return intExpLevelID;
25            }
26            set
27            ...{
28                intExpLevelID = value;
29            }
30        }
31
32        public string ExperienceLevelName
33        ...{
34            get
35            ...{
36                return strExpLevelName;
37            }
38            set
39            ...{
40                strExpLevelName = value;
41            }
42        }
43
44        public static DataSet GetExperienceLevels()
45        ...{
46            DBAccess db = new DBAccess();
47            return db.ExecuteDataSet("JobsDb_ExperienceLevels_SelectAll");
48        }
49
50        public static int Insert(ExperienceLevel l)
51        ...{
52            DBAccess db = new DBAccess();
53            db.AddParameter("@sExperienceLevelName", l.ExperienceLevelName);
54            SqlParameter p = new SqlParameter("@iExperienceLevelID", SqlDbType.Int);
55            p.Direction = ParameterDirection.Output;
56            db.AddParameter(p);
57
58            int retval = db.ExecuteNonQuery("JobsDb_ExperienceLevels_Insert");
59            if (retval == 1)
60            ...{
61                return int.Parse(p.Value.ToString());
62            }
63            else
64            ...{
65                return -1;
66            }
67        }
68
69        public static int Update(ExperienceLevel l)
70        ...{
71            DBAccess db = new DBAccess();
72            db.AddParameter("@iExperienceLevelID", l.ExperienceLevelID);
73            db.AddParameter("@sExperienceLevelName", l.ExperienceLevelName);
74            return db.ExecuteNonQuery("JobsDb_ExperienceLevels_Update");
75        }
76
77        public static int Delete(ExperienceLevel l)
78        ...{
79            DBAccess db = new DBAccess();
80            db.AddParameter("@iExperienceLevelID",l.ExperienceLevelID);
81            return db.ExecuteNonQuery("JobsDb_ExperienceLevels_Delete");
82
83        }
84
85        public static string GetExperienceLevelName(int id)
86        ...{
87            DBAccess db = new DBAccess();
88            db.AddParameter("@iExperienceLevelID", id);
89            return db.ExecuteScalar("JobsDb_ExperienceLevels_GetLevelName").ToString();
90        }
91    }
92}
93