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); }