pc_add_x.asp

企业员工年度综合评测系统 Access(V1.060118)版

<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>
<!--#include file="forbidon.asp" -->
<!--#include file="conn.asp" -->
<%
var unameid=Request("nameid");
var departmentid=Session("departmentid");
var dp=Request("dp");
var uname=Request("name");
var s11=Request("s11");
var s12=Request("s12");
var s13=Request("s13");
var s14=Request("s14");
var s21=Request("s21");
var s22=Request("s22");
var s23=Request("s23");
var s24=Request("s24");
var s31=Request("s31");
var s32=Request("s32");
var s33=Request("s33");
var s34=Request("s34");
var s41=Request("s41");
var s42=Request("s42");
var s43=Request("s43");
var s44=Request("s44");
var s51=Request("s51");
var s52=Request("s52");
var s53=Request("s53");
var s54=Request("s54");
var total1=parseInt(s11)+parseInt(s12)+parseInt(s13)+parseInt(s14)+parseInt(s21)+parseInt(s22)+parseInt(s23)+parseInt(s24)+parseInt(s31)+parseInt(s32)+parseInt(s33)+parseInt(s34)+parseInt(s41)+parseInt(s42)+parseInt(s43)+parseInt(s44)+parseInt(s51)+parseInt(s52)+parseInt(s53)+parseInt(s54);
        //个人总分计算机公式

//sql 语句集
   var sql1="";
   var sql2="";
   var sql3="";
   if(Session("isvgm")==0)  //正负责人
      { //sql1
	    sql1="SELECT id FROM score WHERE nameid="+unameid+"  AND frompart="+departmentid+" AND isgm=1";
		//sql2
		sql2="INSERT INTO score  (nameid,name,departmentid,frompart,isgm,s11,s12,s13,s14,s21,s22,s23,s24,s31,s32,s33,s34,s41,s42,s43,s44,s51,s52,s53,s54,total)  VALUES ('"+ unameid + "','"+uname+ "','"+ dp + "','"+departmentid + "','1','"+s11+"','"+s12 + "','"+ s13 + "','"+ s14 + "','"+ s21 + "','"+ s22 + "','"+ s23 + "','"+ s24 + "','"+ s31+ "','"+ s32 + "','"+ s33 + "','"+ s34 + "','"+ s41 + "','"+ s42 + "','"+ s43 + "','"+ s44 + "','"+ s51 + "','"+ s52 + "','"+ s53 + "','"+ s54 + "','"+ total1+ "') ";		
		//sql3
		sql3="UPDATE  all_user SET gms='"+total1+"' WHERE  nameid="+unameid+"";
		}
   if(Session("isvgm")==1) //副负责人
     { //sql1
	   sql1="SELECT id FROM score WHERE nameid="+unameid+"  AND frompart="+departmentid+" AND isgm=2";	   
	  //sql2 
	    sql2="INSERT INTO score (nameid,name,departmentid,frompart,isgm,s11,s12,s13,s14,s21,s22,s23,s24,s31,s32,s33,s34,s41,s42,s43,s44,s51,s52,s53,s54,total)  VALUES ('"+ unameid + "','"+uname+ "','"+ dp + "','"+departmentid + "','2','"+s11+"','"+s12 + "','"+ s13 + "','"+ s14 + "','"+ s21 + "','"+ s22 + "','"+ s23 + "','"+ s24 + "','"+ s31+ "','"+ s32 + "','"+ s33 + "','"+ s34 + "','"+ s41 + "','"+ s42 + "','"+ s43 + "','"+ s44 + "','"+ s51 + "','"+ s52 + "','"+ s53 + "','"+ s54 + "','"+ total1+ "') ";
	   //sql3
	   sql3="UPDATE  all_user SET vgms='"+total1+"' WHERE  nameid="+unameid+" ";
	   }
  
if(dp!=departmentid) //对其他部门的员工评测
{
 var rs1 = Server.CreateObject("ADODB.Recordset");
 rs1.ActiveConnection = MM_conn_STRING;
 rs1.Source = sql1;
 rs1.CursorType = 0;
 rs1.CursorLocation = 2;
 rs1.LockType = 1;
 rs1.Open();
 if(!rs1.EOF||!rs1.BOF)
   {Response.Write("<script language='javascript'>window.alert('您已对该人评测过！');history.go(-1);</script>");
    Response.End();
	}
if(rs1.EOF&&rs1.BOF)
{
 rs1.Close;  
 var cmd = Server.CreateObject("ADODB.Command");
 cmd.ActiveConnection = MM_conn_STRING;
 cmd.CommandText = sql2;
          //添加员工详细分数
 cmd.CommandType = 1;
 cmd.CommandTimeout = 0;
 cmd.Prepared = true;
 cmd.Execute();
   {var rs2 = Server.CreateObject("ADODB.Recordset");
    rs2.ActiveConnection = MM_conn_STRING;
    rs2.Source = "SELECT *  FROM all_user  WHERE nameid="+ unameid + "";
    rs2.CursorType = 0;
    rs2.CursorLocation = 2;
    rs2.LockType = 1;
    rs2.Open();
	var orthern=rs2.Fields.Item("orthern");
    var orthers=rs2.Fields.Item("orthers");
	var n=orthern+1;
    var total2=(orthern*orthers+total1)/n;//部门员工评测平均分计算机公式，取整
	rs2.Close;
    }
     {var cmd1 = Server.CreateObject("ADODB.Command");
      cmd1.ActiveConnection = MM_conn_STRING;
      cmd1.CommandText = "UPDATE  all_user SET orthern='"+n+"',orthers='"+total2+"' WHERE  nameid="+unameid+"";　
      cmd1.CommandType = 1;
      cmd1.CommandTimeout = 0;
      cmd1.Prepared = true;
      cmd1.Execute();
	 }
	  //添加平均总分
Response.Write("<script language='javascript'>window.alert('对该员工[其他部门]评测成功！');location=('uppc_list.asp');</script>");
 }
}
   
 
if(dp==departmentid)//对本部门的员工评测 
{
  var rs3 = Server.CreateObject("ADODB.Recordset");
  rs3.ActiveConnection = MM_conn_STRING;
  rs3.Source = sql1;
  rs3.CursorType = 0;
  rs3.CursorLocation = 2;
  rs3.LockType = 1;
  rs3.Open();
  if(!rs3.EOF||!rs3.BOF)
   {Response.Write("<script language='javascript'>window.alert('您已对该人评测过！');history.go(-1);</script>");
    Response.End();
	}
  if(rs3.EOF&&rs3.BOF)
    {
	  var cmd = Server.CreateObject("ADODB.Command");
      cmd.ActiveConnection = MM_conn_STRING;
      cmd.CommandText = sql2;
          //对本部门添加相应的分数
         cmd.CommandType = 1;
         cmd.CommandTimeout = 0;
         cmd.Prepared = true;
         cmd.Execute();   
	  
	  var cmd1 = Server.CreateObject("ADODB.Command");
      cmd1.ActiveConnection = MM_conn_STRING;
      cmd1.CommandText = sql3;　
      cmd1.CommandType = 1;
      cmd1.CommandTimeout = 0;
      cmd1.Prepared = true;
      cmd1.Execute();//自评添加
	Response.Write("<script language='javascript'> window.alert('对该员工[本部门]评测成功！');location=('uppc_list.asp');</script>");
	 }
 rs3.Close();	 
 }
%>