protected void pub(string id, int pubFlag)
{
/* string strtb = "SELECT d.学生姓名,a.学生学号,d.性别,a.就业方式,c.职位名称" +
"a.备注,b.就业单位名称 " +
" FROM Student_baseinfo AS d,zj_netinfoEx AS a INNER JOIN zj_job_infoEx AS b " +
" ON a.招聘信息编号 = b.招聘信息编号 " +
" LEFT OUTER JOIN zj_job AS c ON a.招聘岗位编号 = c.职位编号 " +
" WHERE a.valid != 0 AND b.valid!=0 AND a.学生学号 = d.学生学号 AND a.招聘信息编号='" + id + "'";*/
string str = "SELECT d.学生姓名,d.性别,a.学生学号,a.就业方式,a.备注," +
"a.应聘信息编号,b.招聘信息编号,b.就业单位名称,b.招聘标题,c.职位名称 " +
" FROM Student_baseinfo AS d,zj_netinfoEx AS a INNER JOIN zj_job_infoEx AS b " +
" ON a.招聘信息编号 = b.招聘信息编号 " +
......................
阅读全部 | 2014年11月26日 14:26