public void Insert(CampusJob job)
{
IDatabase db = DataManager.CampusDB();
WinSys.Int64 jobid = WinSys.Convert.ToInt64(db.ExecuteScalar("select isnull(max(job_id),0) from campus_job ")) + 1;
string vsSql = @"INSERT INTO [campus_job]([company_id], [job_id], [dept_id], [user_id], [Industry_Category], [Major_Category], [Location], [Occupation_Category], [job_desc], [job_title], [job_url], [job_type], [apply_no], [headcount], [create_date], [update_date], [post_date], [end_date], [job_status], [is_html], [order_no], [Email], [SearchKeyWord], [IsAudit], [AuditDate], [AuditUserId])
VALUES({0}, {1}, {2},{3}, '{4}','{5}', '{6}', '{7}','{8}', '{9}', '{10}', {11},{12},{13},'{14}', '{15}', '{16}', '{17}', {18},{19}, {20}, '{21}','{22}',{23}, '{24}','{25}')";
vsSql = WinSys.String.Format(vsSql, job.Company_id, jobid, job.Dept_id, job.User_id, job.Industry_Category, job.Major_Category, job.Location, job.Occupation_Category, job.Job_desc, job.Job_title, job.Job_url, job.Job_type, job.Apply_no, job.Headcount, job.Create_date, job.Update_date, job.Post_date, job.End_date, job.Job_status, job.Is_html, job.Order_no, job.Email, job.SearchKeyWord, job.IsAudit, job.AuditDate, job.AuditUserId);
db.Execute(vsSql);
}
public void Insert(string Memid, CampusJob job)
{
IDatabase db = DataManager.CampusDB();
IDbDataParameter[] param = db.CreateParamArray(14);
param[0] = db.CreateParam("@mem_id", Memid);
param[1] = db.CreateParam("@user_id", job.User_id);
param[2] = db.CreateParam("@Industry_Category", job.Industry_Category);
param[3] = db.CreateParam("@Occupation_Category", job.Occupation_Category);
param[4] = db.CreateParam("@Major_Category", job.Major_Category);
param[5] = db.CreateParam("@Location", job.Location);
param[6] = db.CreateParam("@job_title", job.Job_title);
param[7] = db.CreateParam("@job_type", job.Job_type);
param[8] = db.CreateParam("@job_desc", job.Job_desc);
param[9] = db.CreateParam("@headcount", job.Headcount);
param[10] = db.CreateParam("@order_no", job.Order_no);
param[11] = db.CreateParam("@end_date", job.End_date);
param[12] = db.CreateParam("@SearchKeyWord", job.SearchKeyWord);
param[13] = db.CreateParam("@Email", job.Email);
db.Execute("usp_campus_job_add", param);
}
public void Update(CampusJob job)
{
}
public void Delete(CampusJob job)
{
}
public void Insert(string Memid,CampusJob job)
{
IDatabase db = DataManager.CampusDB();
IDbDataParameter[] param = db.CreateParamArray(14);
param[0] = db.CreateParam("@mem_id", Memid);
param[1] = db.CreateParam("@user_id", job.User_id);
param[2] = db.CreateParam("@Industry_Category", job.Industry_Category);
param[3] = db.CreateParam("@Occupation_Category",job.Occupation_Category);
param[4] = db.CreateParam("@Major_Category", job.Major_Category);
param[5] = db.CreateParam("@Location", job.Location);
param[6] = db.CreateParam("@job_title", job.Job_title);
param[7] = db.CreateParam("@job_type", job.Job_type);
param[8] = db.CreateParam("@job_desc", job.Job_desc);
param[9] = db.CreateParam("@headcount", job.Headcount);
param[10] = db.CreateParam("@order_no", job.Order_no);
param[11] = db.CreateParam("@end_date", job.End_date);
param[12] = db.CreateParam("@SearchKeyWord", job.SearchKeyWord);
param[13] = db.CreateParam("@Email", job.Email);
db.Execute("usp_campus_job_add", param);
}
public void Insert(CampusJob job)
{
IDatabase db = DataManager.CampusDB();
WinSys.Int64 jobid = WinSys.Convert.ToInt64( db.ExecuteScalar("select isnull(max(job_id),0) from campus_job "))+1;
string vsSql = @"INSERT INTO [campus_job]([company_id], [job_id], [dept_id], [user_id], [Industry_Category], [Major_Category], [Location], [Occupation_Category], [job_desc], [job_title], [job_url], [job_type], [apply_no], [headcount], [create_date], [update_date], [post_date], [end_date], [job_status], [is_html], [order_no], [Email], [SearchKeyWord], [IsAudit], [AuditDate], [AuditUserId])
VALUES({0}, {1}, {2},{3}, '{4}','{5}', '{6}', '{7}','{8}', '{9}', '{10}', {11},{12},{13},'{14}', '{15}', '{16}', '{17}', {18},{19}, {20}, '{21}','{22}',{23}, '{24}','{25}')";
vsSql = WinSys.String.Format(vsSql, job.Company_id, jobid, job.Dept_id, job.User_id, job.Industry_Category, job.Major_Category, job.Location, job.Occupation_Category, job.Job_desc, job.Job_title, job.Job_url, job.Job_type, job.Apply_no, job.Headcount, job.Create_date, job.Update_date, job.Post_date, job.End_date, job.Job_status, job.Is_html, job.Order_no, job.Email, job.SearchKeyWord, job.IsAudit, job.AuditDate, job.AuditUserId);
db.Execute(vsSql);
}
public void Delete(CampusJob job)
{
}
public void Update(CampusJob job)
{
}
