WebRoot/cgd/cgd_add.jsp

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="com.util.*"%>
<%
DBO db=new DBO();
request.setCharacterEncoding("gb2312");
ResultSet rs=null;
String sql="";
int row=0;
String bt=(String)request.getParameter("bt");
String nr=(String)request.getParameter("nr");
String fzr=(String)request.getParameter("fzr");
String bm=(String)request.getParameter("bm");
String sqyy=(String)request.getParameter("sqyy");
String bz=(String)request.getParameter("bz");
String sqr=(String)request.getParameter("sqr");
sql="insert into cgd(bt,nr,fzr,bm,sqyy,bz,sqr) values('"+bt+"','"+nr+"','"+fzr+"','"+bm+"','"+sqyy+"','"+bz+"','"+sqr+"')";
 bm="qicao";
String jdmc="起草";
String czr=sqr;
String czsj=StaticMethod.getStringDate();
String cgd="";
try{
row=db.executeUpdate(sql);

sql="select max(cgdid) as id from cgd";
rs=db.query(sql);
if(rs.next()){//获得当前的采购id
cgd=rs.getString("id");
}
//插入申请数据第一条
sql="insert into shenpi(bm,jdmc,czr,czsj,sfty,yj,cgd,xh) values('"+bm+"','"+jdmc+"','"+czr+"','"+czsj+"','','','"+cgd+"','1')";

db.update(sql);
sql="select * from lcjd where bzxh='2'";
rs=db.query(sql);
if(rs.next()){
sql="insert into shenpi(bm,jdmc,czr,cgd,xh) values('"+rs.getString("bm")+"','"+rs.getString("jd")+"','"+rs.getString("czr")+"','"+cgd+"','2')";
db.update(sql);
}

}catch(Exception e){
System.out.println(e.toString());}
if(row==1){
out.println("<script>");
out.println("alert('采购单申请成功');");
out.println("window.location='cgdadd.jsp'");
out.println("</script>");
}else{
out.println("<script>");
out.println("alert('采购单添加失败');");
out.println("window.location='cgdadd.jsp'");
out.println("</script>");
}
db.close();
%>