![]() |
#2
不喜欢编程2014-11-26 15:08
这是我自己写的代码,但是数据没有导入成功,只有这样的一个表头
<tr><td>学生姓名</td><td>学生学号</td><td>性别</td><td>就业方式</td><td>招聘职位</td><td>备注</td><td>就业单位名称</td></tr> 数据没有,还有哪里没写完的吗?求教高手 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.招聘信息编号 " + " 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 no, strJob, time; string head; int i; DataRow d; DataSet ds; time = DateTime.Now.ToString(); no = objCom.GetMaxNo("00000000000", "编号", "content", ""); //发布信息的id string toAdd = "<table border= \"1\" style=\"text-align:center;\"><tr><td>学生姓名</td><td>学生学号</td><td>性别</td><td>就业方式</td><td>招聘职位</td><td>备注</td><td>就业单位名称</td></tr>"; if (pubFlag == 1) { head = "<h1>录用结果:</h1>"; ds = objCom.GetDSCommon(str, "zj_netinfoEx"); for (i = 0; i < ds.Tables[0].Rows.Count; i++) { d = ds.Tables[0].Rows[i]; strJob = d["职位名称"] == null ? "待定" : d["职位名称"].ToString().Trim(); toAdd += "<tr><td>" + d["学生姓名"] + "</td><td>" + d["学生学号"] + "</td><td>" + d["性别"] + "</td><td>" + d["就业方式"] + "</td><td>" + strJob; toAdd += "</td><td>" + d["备注"] + "</td><td>" + d["就业单位名称"] + "</td></tr>"; } string s = "INSERT INTO content(编号,栏目编号,标题,日期,作者,上传日期,内容,审核,审核人,审核日期,隐藏,内容类型,招聘信息编号) VALUES('" + no + "','0405','录用结果发布','" + time + "','招生就业办','" + time + "','" + head + toAdd + "','01','系统','" + time + "','显示','内容','y" + id + "')"; objCom.excsql(s); } if (pubFlag == 0) { head = "<h1>撤销录用结果:</h1>"; ds = objCom.GetDSCommon(str, "zj_netinfoEx"); for (i = 0; i < ds.Tables[0].Rows.Count; i++) { d = ds.Tables[0].Rows[i]; strJob = d["职位名称"] == null ? "待定" : d["职位名称"].ToString().Trim(); toAdd += "<tr><td>" + d["学生姓名"] + "</td><td>" + d["学生学号"] + "</td><td>" + d["性别"] + "</td><td>" + d["就业方式"] + "</td><td>" + strJob; toAdd += "</td><td>" + d["备注"] + "</td><td>" + d["就业单位名称"] + "</td></tr>"; } string s = "INSERT INTO content(编号,栏目编号,标题,日期,作者,上传日期,内容,审核,审核人,审核日期,隐藏,内容类型,招聘信息编号) VALUES('" + no + "','0405','撤销录用结果','" + time + "','招生就业办','" + time + "','" + head + toAdd + "</table>','01','系统','" + time + "','显示','内容','y" + id + "')"; objCom.excsql(s); } } |
哪位大神帮下忙。谢谢