Line 173: if ((jistr+results[0]).Length > 0)
Line 174: {
Line 175: jobdr = Maticsoft.DBUtility.SqlHelper.ExecuteReader(BASE.con, CommandType.Text, "select hire_id,hire_place,hire_edu,hire_sex,hire_comname,company_id,hire_announcedate,hire_somekey,commendhome_enddate, commendhome ,hire_workadd,hire_workaddcity,hire_experience,hire_pay,(select top 1 hirekey_enddate from hirekey where hirekey_hireid=hire_id ) as hirekey_enddate from hire where hire_enddate>=getdate() and hire_status = 1 and hire_id in (" + (jistr + results[0]) + ") order by hire_somekey desc,hire_announcedate desc,hire_id desc");
Line 176:
Line 177:
|