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

		            
 1Using directives#region Using directives
 2
 3using System;
 4using System.Collections.Generic;
 5using System.Text;
 6using JobSiteStarterKit.DAL;
 7using System.Data;
 8
 9#endregion
10
11namespace JobSiteStarterKit.BOL
12...{
13    public class State
14    ...{
15
16        public static DataSet GetStates()
17        ...{
18            DBAccess db = new DBAccess();
19            return db.ExecuteDataSet("JobsDb_States_SelectAll");
20        }
21
22        public static DataSet GetStates(int countryid)
23        ...{
24            DBAccess db = new DBAccess();
25            db.AddParameter("@iCountryID", countryid);
26            return db.ExecuteDataSet("JobsDb_States_SelectForCountry");
27        }
28
29        public static string GetStateName(int id)
30        ...{
31            DBAccess db = new DBAccess();
32            db.AddParameter("@iStateID", id);
33            return db.ExecuteScalar("JobsDb_States_GetStateName").ToString();
34        }
35    }
36}
37