xauditcustdetail.jsp

oa系统 JAVA 办公管理系统 含有多项功能 快快下载

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@include file="check.jsp" %>
<%
//
	String userid=request.getParameter("userid");
	String username=request.getParameter("username");
	String tel=request.getParameter("tel");
	String zt=request.getParameter("zt");
	String mm = request.getParameter("mm");
	String actorid = request.getParameter("actorid");
	dbc.getConnection();
	String sql = "";
	if(mm==null){
		sql = "update custs set cname='"+username+"', tel='"+tel+"',check='"+zt+"'";
		sql = sql +"  where cuser='"+userid+"'";
		dbc.update(charset.ISO_2_GBK(sql));
	out.println(charset.ISO_2_GBK(sql)+"..0..<br>");

		sql = "update users set username='"+username+"', tel='"+tel+"',check='"+zt+"'";
		sql = sql +"  where user='"+userid+"'";
		dbc.update(charset.ISO_2_GBK(sql));
	out.println(charset.ISO_2_GBK(sql)+" ..1..<br>");


		if(zt.compareTo("1")==0){//处理默认分组
			 if(actorid.compareTo("x")==0){
			 	;//暂不分组
			 }
			else{

				String programname="",modelname="";
				dbc.getConnection();
				sql = "select id,programname,modelname from actors where actorid='"+actorid+"' and cid='"+scid+"'";
				ResultSet rrs = dbc.getRS(sql);
				while(rrs.next()){
					modelname = charset.ISO_2_GBK(rrs.getString(3));
					programname = charset.ISO_2_GBK(rrs.getString(2));
					if(dbc.getCount("select count(*) from userauth where programname='"+programname+"' and user='"+userid+"' and cid='"+scid+"'")>0){
						//已经存在该权限
						continue;
					}
					else{
						dbc.update(charset.GBK_2_ISO("insert into userauth(user,modelname,programname,authid,grantbyuser,cid) values('"+userid+"','"+modelname+"','"+programname+"','"+rrs.getString(1)+"','admin','"+scid+"')"));
					}
				}
				rrs = null;	
			}
		}
		else{
			dbc.getConnection();
			dbc.update("delete from userauth where user='"+userid+"'");
		
		}
	}
	else{
		sql = "update custs set cname='"+username+"',cpwd='"+mm+"' ,tel='"+tel+"',check='"+zt+"'";
		sql = sql +"  where cuser='"+userid+"'";
		dbc.update(charset.ISO_2_GBK(sql));
	out.println(charset.ISO_2_GBK(sql)+"..2..<br>");

		sql = "update users set username='"+username+"',password='"+mm+"', tel='"+tel+"',check='"+zt+"'";
		sql = sql +"  where user='"+userid+"'";
		dbc.update(charset.ISO_2_GBK(sql));
	out.println(charset.ISO_2_GBK(sql)+"..3..<br>");

	}
	//===========自动赋予某些初始权限==============
	//
	dbc.close();
	
//	out.println(sql);
	response.sendRedirect("../auditcust.jsp");
	
%>