//到職缺細項頁面 // 傳入 職缺PK,執行 [查看職缺細項] 功能 // 回傳 整筆資料或部分資料(list的JobModel型態) public ActionResult toJobDetailView(int JobID) { SJM.SearchJob sjm = new SJM.SearchJob(); JM.JobModel jmModel = new JM.JobModel(); jmModel = sjm.jobDetail(JobID); return(View("JobDetailView", jmModel)); }
//到職缺細項頁面 // 傳入 職缺PK,執行 [查看職缺細項] 功能 // 回傳 整筆資料或部分資料(list的JobModel型態) //for test 12/16 //public ActionResult toJobDetailView(string jobID) public ActionResult toJobDetailView(int jobID) { SJM.SearchJob sjm = new SJM.SearchJob(); JM.JobModel jmModel = new JM.JobModel(); string userID = ""; if (Session["suserID"] != null) { userID = Session["suserID"].ToString(); } jmModel = sjm.jobDetail(jobID, userID); //jmModel = sjm.jobDetail(1); // 搜尋職缺欄位內容種類 ViewBag.DWorkType = sjm.getWorkType(); ViewBag.DCityName = sjm.getCityName(); ViewBag.DCjob_Name1 = sjm.getCjob_Name1(); return(View("JobDetailView", jmModel)); }
// 搜尋職缺細項 public JM.JobModel jobDetail(int jobID, string userID) { // SQL指令 撈出職缺細項 #region [做DB連線 以及 執行DB處理] // 建立DB連線 Tools.DBConnection bsc = new Tools.DBConnection(); #endregion // 取出職缺細項 #region [ 取出職缺細項 ] DataTable dt = bsc.ReadDB( string.Format( @"SELECT * FROM [Job] AS J , [Company] AS C , [JobType] AS JT WHERE 1=1 AND J.JOB_ID = {0} AND J.COMP_ID = C.COMP_ID AND J.CJOB_ID = JT.CJOB_ID" , jobID) ); JM.JobModel jmModel = new JM.JobModel(); // 將DataTable的資料轉換為model 將職缺細項列出 jmModel.Job_ID = Convert.ToInt16(dt.Rows[0][0]); jmModel.Occu_Desc = dt.Rows[0][1].ToString(); jmModel.Wk_Type = dt.Rows[0][2].ToString(); jmModel.Cjob_ID = Convert.ToInt16(dt.Rows[0][3]); jmModel.Cjob_Name1 = dt.Rows[0][18].ToString(); jmModel.AvailReqNum = Convert.ToInt16(dt.Rows[0][4]); jmModel.Stop_Date = dt.Rows[0][5].ToString(); jmModel.Job_Detail = dt.Rows[0][6].ToString(); jmModel.CityName = dt.Rows[0][7].ToString(); jmModel.Experience = dt.Rows[0][8].ToString(); jmModel.WkTime = dt.Rows[0][9].ToString(); jmModel.SalaryCd = dt.Rows[0][10].ToString(); jmModel.EdGrDesc = dt.Rows[0][11].ToString(); jmModel.Url_Query = dt.Rows[0][12].ToString(); jmModel.Comp_ID = Convert.ToInt16(dt.Rows[0][13]); jmModel.CompName = dt.Rows[0][16].ToString(); jmModel.TranDate = dt.Rows[0][14].ToString(); if (userID != "") { DataTable dt1 = bsc.ReadDB( string.Format( @"SELECT JOB_ID FROM [MyFavorite] WHERE 1=1 AND USER_ID = '{0}' AND JOB_ID = {1}" , userID, jobID) ); if (dt1.Rows.Count > 0) { jmModel.Is_Favorite = 1; } else { jmModel.Is_Favorite = 0; } } #endregion return(jmModel); }