1
using System;
2using System.Data;
3using System.Data.SqlClient;
4using My.Hr.DbBase;
5using System.Collections ;
6
7namespace My
8
...{
9
/**//// <summary>
10
/// Book description for book。
11
/// </summary>
12 public class GiveJobInfo:Base
13 ...{
14 public GiveJobInfo()
15 ...{
16
17 }
18 //get all data of books
19 public static DataSet GetGiveJobInfo()
20 ...{
21 String strsql;
22
23 strsql="SELECT * FROM giveJobInfo";
24 try
25 ...{
26 return ExecuteSql4Ds(strsql);
27 }
28 catch
29 ...{
30 throw new Exception("Get all the Information failed!");
31 }
32 }
33
34 //from companyID get GiveJobInfo
35 public DataRow GetMyBaseInfo(int companyId)
36 ...{
37 DataSet myDs;
38 strSQL = "SELECT companyName,vocation,email,phone,address,addrNum from GiveJobInfo Where companyID=" + companyId.ToString();
39 try
40 ...{
41 myDs = ExecuteSql4Ds(strSQL);
42 return myDs.Tables[0].Rows[0];
43 }
44 catch
45 ...{
46 throw new Exception("Get information failed!");
47 }
48 }
49 public DataRow GetMyCareer(int companyId)
50 ...{
51 DataSet myDs;
52 strSQL = "SELECT workPosition,giveNum,workCity,discribe,request,publicTime,lookTimes from GiveJobInfo Where companyID=" + companyId.ToString();
53 try
54 ...{
55 myDs = ExecuteSql4Ds(strSQL);
56 return myDs.Tables[0].Rows[0];
57 }
58 catch
59 ...{
60 throw new Exception("Get information failed!");
61 }
62 }
63 /**//////////////update info/////////////////////////////////////
64 public void UpdateMyBaseInfo(ArrayList tempary)
65 ...{
66 SqlConnection myCn=new SqlConnection(strConn);
67 SqlCommand myCm=new SqlCommand("updateCBaseInfo",myCn);
68 myCm.CommandType =CommandType.StoredProcedure ;
69
70 myCm.Parameters.Add(new SqlParameter("@companyID",SqlDbType.Int));
71 myCm.Parameters["@companyID"].Value =tempary[0];
72
73 myCm.Parameters.Add(new SqlParameter("@companyName",SqlDbType.VarChar,50));
74 myCm.Parameters["@companyName"].Value =tempary[1];
75
76 myCm.Parameters.Add(new SqlParameter("@vocation",SqlDbType.VarChar,50));
77 myCm.Parameters["@vocation"].Value =tempary[2];
78
79 myCm.Parameters.Add(new SqlParameter("@email",SqlDbType.VarChar,50));
80 myCm.Parameters["@email"].Value =tempary[3];
81
82 myCm.Parameters.Add(new SqlParameter("@phone",SqlDbType.VarChar,50));
83 myCm.Parameters["@phone"].Value =tempary[4];
84
85 myCm.Parameters.Add(new SqlParameter("@address",SqlDbType.VarChar,50));
86 myCm.Parameters["@address"].Value =tempary[5];
87
88 myCm.Parameters.Add(new SqlParameter("@addrNum",SqlDbType.VarChar,50));
89 myCm.Parameters["@addrNum"].Value =tempary[6];
90
91 try
92 ...{
93 myCn.Open() ;
94 myCm.ExecuteNonQuery() ;
95 }
96 catch(System.Data.SqlClient.SqlException er)
97 ...{
98 throw new Exception(er.Message);
99 }
100 finally
101 ...{
102 myCm.Dispose() ;
103 myCn.Close() ;
104 }
105 }
106 public void UpdateMyCareer(ArrayList tempary)
107 ...{
108 SqlConnection myCn=new SqlConnection(strConn);
109 SqlCommand myCm=new SqlCommand("updateCCareer",myCn);
110 myCm.CommandType =CommandType.StoredProcedure ;
111
112 myCm.Parameters.Add(new SqlParameter("@companyID",SqlDbType.Int));
113 myCm.Parameters["@companyID"].Value =tempary[0];
114
115 myCm.Parameters.Add(new SqlParameter("@workPosition",SqlDbType.VarChar,50));
116 myCm.Parameters["@workPosition"].Value =tempary[1];
117
118 myCm.Parameters.Add(new SqlParameter("@giveNum",SqlDbType.VarChar,50));
119 myCm.Parameters["@giveNum"].Value =tempary[2];
120
121 myCm.Parameters.Add(new SqlParameter("@workCity",SqlDbType.VarChar,50));
122 myCm.Parameters["@workCity"].Value =tempary[3];
123
124 myCm.Parameters.Add(new SqlParameter("@discribe",SqlDbType.Text));
125 myCm.Parameters["@discribe"].Value =tempary[4];
126
127 myCm.Parameters.Add(new SqlParameter("@request",SqlDbType.Text));
128 myCm.Parameters["@request"].Value =tempary[5];
129
130 myCm.Parameters.Add(new SqlParameter("@publicTime",SqlDbType.DateTime)); //
131 myCm.Parameters["@publicTime"].Value =tempary[6];
132
133 myCm.Parameters.Add(new SqlParameter("@lookTimes",SqlDbType.Int));
134 myCm.Parameters["@lookTimes"].Value =tempary[7];
135
136 try
137 ...{
138 myCn.Open() ;
139 myCm.ExecuteNonQuery() ;
140 }
141 catch(System.Data.SqlClient.SqlException er)
142 ...{
143 throw new Exception(er.Message);
144 }
145 finally
146 ...{
147 myCm.Dispose() ;
148 myCn.Close() ;
149 }
150 }
151 /**///////////////////////////////////////////////////////////////////////////////////////
152 //get top ten best salers
153 public DataView GiveJobInfoTop10()
154 ...{
155 String strsql;
156 DataSet myDs;
157 strsql="select top 10 giveJobInfoID,companyName,vocation,workPosition from giveJobInfo order by lookTimes DESC";
158 myDs=ExecuteSql4Ds(strsql);
159 return myDs.Tables[0].DefaultView ;
160 }
161
162 public DataView GetNewInfo10()
163 ...{
164 String strsql;
165 DataSet myDs;
166 strsql="select top 10 giveJobInfoID,companyName,vocation,workPosition from giveJobInfo order by giveJobInfoID desc";
167 myDs=ExecuteSql4Ds(strsql);
168 return myDs.Tables[0].DefaultView ;
169 }
170
171 public DataRow GetInfoDetail(string companyID)
172 ...{
173 string strsql;
174 DataSet myDs;
175 try
176 ...{
177 strsql="select * from giveJobInfo where giveJobInfo.companyID="+companyID;
178 myDs=ExecuteSql4Ds(strsql);
179 return myDs.Tables[0].Rows[0];
180 }
181 catch(System.Data.SqlClient.SqlException er)
182 ...{
183 throw new Exception(er.Message);
184 }
185
186 }
187
188 /**//// <summary>
189 /// Add book hits
190 /// </summary>
191 /// <param name="bookId">book ID</param>
192 /// <returns></returns>
193 public static void Hits(string giveJobInfoID)
194 ...{
195 strSQL = "Update giveJobInfo set lookTimes=lookTimes+1 Where giveJobInfoID= " + giveJobInfoID;
196 try
197 ...{
198 ExecuteSql4Ds(strSQL);
199 }
200 catch
201 ...{
202 throw new Exception("Hits FAILED!!");
203 }
204 }
205
206 /**//// <summary>
207 /// Search Book By name,author,translator,publisher
208 /// </summary>
209 /// <param name="Msg"></param>
210 /// <returns></returns>
211 public static DataSet SearchCompanyInfo(string Msg)
212 ...{
213 string str;
214 str="select * from giveJobInfo where companyName like '%" + Msg + "%' or workPosition like '%" + Msg + "%' or workCity like '%" + Msg + "%' or request like '%" + Msg + "%' ";
215 DataSet myDs;
216 myDs=ExecuteSql4Ds(str);
217 return myDs;
218 }
219 }
220
}
221
NiitJob/App_Code/classes/GiveJobInfo.cs[6K，2009-6-12 11:50:17]，打开代码结构图
打包下载该项目完整源码：人才招聘系统（NIIT学生作品）