当前文件路径：JobSiteStarterKit/App_Code/BOL/MySearch.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 MySearch
 15    ...{
 16        private int intMySearchID;
 17        private string strCriteria;
 18        private int intCountryID;
 19        private int intStateID;
 20        private string strCity;
 21        private string strUserName;
 22
 23        public int MySearchID
 24        ...{
 25            get
 26            ...{
 27                return intMySearchID;
 28            }
 29            set
 30            ...{
 31                intMySearchID = value;
 32            }
 33        }
 34
 35        public string Criteria
 36        ...{
 37            get
 38            ...{
 39                return strCriteria;
 40            }
 41            set
 42            ...{
 43                strCriteria = value;
 44            }
 45        }
 46
 47        public int CountryID
 48        ...{
 49            get
 50            ...{
 51                return intCountryID;
 52            }
 53            set
 54            ...{
 55                intCountryID = value;
 56            }
 57        }
 58
 59        public int StateID
 60        ...{
 61            get
 62            ...{
 63                return intStateID;
 64            }
 65            set
 66            ...{
 67                intStateID = value;
 68            }
 69        }
 70
 71        public string City
 72        ...{
 73            get
 74            ...{
 75                return strCity;
 76            }
 77            set
 78            ...{
 79                strCity = value;
 80            }
 81        }
 82
 83        public string UserName
 84        ...{
 85            get
 86            ...{
 87                return strUserName;
 88            }
 89            set
 90            ...{
 91                strUserName=value;
 92            }
 93        }
 94
 95
 96        public static int Insert(MySearch s)
 97        ...{
 98            DBAccess db = new DBAccess();
 99            db.AddParameter("@sSearchCriteria", s.Criteria);
100            db.AddParameter("@iCountryID", s.CountryID);
101            db.AddParameter("@iStateID", s.StateID);
102            db.AddParameter("@iCity", s.City);
103            db.AddParameter("@sUserName", s.UserName);
104            SqlParameter p = new SqlParameter("@iMySearchID", SqlDbType.Int);
105            p.Direction = ParameterDirection.Output;
106            db.AddParameter(p);
107
108            int retval=db.ExecuteNonQuery("JobsDb_MySearches_Insert");
109            if (retval == 1)
110            ...{
111                return int.Parse(p.Value.ToString());
112            }
113            else
114            ...{
115                return -1;
116            }
117        }
118
119        public static DataSet GetMySearches(string username)
120        ...{
121            DBAccess db = new DBAccess();
122            db.AddParameter("@sUserName", username);
123            return db.ExecuteDataSet("JobsDb_MySearches_SelectForUser");
124        }
125
126        public static MySearch GetMySearch(int mysearchid)
127        ...{
128            DBAccess db = new DBAccess();
129            db.AddParameter("@iMySearchID", mysearchid);
130            SqlDataReader dr = (SqlDataReader)db.ExecuteReader("JobsDb_MySearches_SelectOne");
131
132            if (dr.HasRows)
133            ...{
134                MySearch s = new MySearch();
135                while (dr.Read())
136                ...{
137                    s.MySearchID = dr.GetInt32(dr.GetOrdinal("mysearchid"));
138                    s.Criteria = dr.GetString(dr.GetOrdinal("SearchCriteria"));
139                    s.CountryID = dr.GetInt32(dr.GetOrdinal("CountryID"));
140                    s.StateID = dr.GetInt32(dr.GetOrdinal("StateID"));
141                    s.City = dr.GetString(dr.GetOrdinal("City"));
142                    s.UserName = dr.GetString(dr.GetOrdinal("UserName"));
143
144                }
145                dr.Close();
146                return s;
147            }
148            else
149            ...{
150                return null;
151            }
152
153        }
154
155
156        public static int Delete(MySearch s)
157        ...{
158            DBAccess db = new DBAccess();
159            db.AddParameter("@iMySearchID", s.MySearchID);
160            return db.ExecuteNonQuery("JobsDb_MySearches_Delete");
161        }
162
163    }
164}
165