my_grade.asp
来自「适用于网络/信息企业」· ASP 代码 · 共 192 行
ASP
192 行
<!--#include file="../INC/Conn.asp"-->
<!--#include file="inc/Check.asp"-->
<!--#include file="inc/public.asp"-->
<%
dim Makking
Makking = Trim(Request.QueryString("Makking"))
Employee_ID = Trim(Request.QueryString("Employee_ID"))
IF Employee_ID = "" Then Employee_ID = Session("Eboer_CRM_Employee_ID")
'---------------------------------
select case Makking
case ""
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>亿博尔</title>
</head>
<link href="Images/Admin.css" rel="stylesheet" type="text/css">
<body>
<table width="98%" height="40" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#D8D8D8">
<tr>
<td height="30" align="left" bgcolor="ffffff"><table width="100%" height="100%" border="0" cellpadding="3" cellspacing="0">
<tr bgcolor="eeeeee">
<td width="5%" align="center"><img src="./Images/1.gif" width="13" height="12"></td>
<td width="85%"><span class="style2">管理中心 >>> 我的考评</span></td>
<td width="10%" align="right"> </td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<%
Dim YearStr,MonthStr,MonthArr,DayStr
YearStr = Year(Request.QueryString("TimeStr"))
MonthStr = Month(Request.QueryString("TimeStr"))
NextTime = Request.QueryString("TimeStr")
IF NextTime = "" Then NextTime = Year(Now()) & "-" & Month(Now())
DayStr = Day(Now())
IF Request.QueryString("TimeStr") = "" Then YearStr = Year(Now())
IF Request.QueryString("TimeStr") = "" Then MonthStr = Month(Now())
IF MonthStr = 1 Then MonthArr = 31
IF MonthStr = 2 Then MonthArr = 29
IF MonthStr = 3 Then MonthArr = 31
IF MonthStr = 4 Then MonthArr = 30
IF MonthStr = 5 Then MonthArr = 31
IF MonthStr = 6 Then MonthArr = 30
IF MonthStr = 7 Then MonthArr = 31
IF MonthStr = 8 Then MonthArr = 31
IF MonthStr = 9 Then MonthArr = 30
IF MonthStr = 10 Then MonthArr = 31
IF MonthStr = 11 Then MonthArr = 30
IF MonthStr = 12 Then MonthArr = 31
%>
<table width="98%" height="90%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#D8D8D8">
<tr>
<td valign="top" bgcolor="ffffff"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="top" bgcolor="ffffff"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center" bgcolor="ffffff"> <table width=100% border=0 align='center' cellpadding=3 cellspacing=1 bordercolordark=#ffffff bgcolor="eaeaea">
<td width="2%">
<tr align="left" bgcolor="ffffff">
<td height="20" colspan="3" background="Images/box_bg.gif">时间（<%=YearStr%>年<%=MonthStr%>月）</td>
<td width="11%" height="20" background="Images/box_bg.gif" bgcolor="ffffff">分数
<td width="15%" height="20" background="Images/box_bg.gif" bgcolor="ffffff">类型
<td width="50%" background="Images/box_bg.gif" bgcolor="ffffff">事由</td>
</tr>
<%
Set Rs = Conn.Execute("Select * From Grade_List Where datepart(yyyy,DateTime) = '"& YearStr &"' AND datepart(mm,DateTime) = '"& MonthStr &"' AND Employee_ID = '"& Employee_ID &"'")
IF Not(Rs.Bof AND Rs.eof) Then
While Not Rs.eof
%>
<tr align="left" bgcolor="ffffff" onmouseout="this.style.backgroundColor=''" onmouseover="this.style.backgroundColor='#F5F5F5'">
<td height="22" colspan="3"><%=Rs("DateTime")%></td>
<td height="22"><%=Rs("Grade_Numeric")%></TD>
<td><%=Rs("Grade_Type")%></TD>
<td height="22"><%=Rs("Grade_Causation")%></td>
</tr>
<%
Rs.MoveNext
Wend
End if
Rs.Close
Set Rs = Nothing
Set Rs = Conn.Execute("Select Sum(Grade_Numeric) as Sum_1 From Grade_List Where Grade_Type = '在职' AND datepart(yyyy,DateTime) = '"& YearStr &"' AND datepart(mm,DateTime) = '"& MonthStr &"' AND Employee_ID = '"& Employee_ID &"'")
Sum_1 = Rs("Sum_1")
Rs.Close
Set Rs = Conn.Execute("Select Sum(Grade_Numeric) as Sum_2 From Grade_List Where Grade_Type = '行为' AND datepart(yyyy,DateTime) = '"& YearStr &"' AND datepart(mm,DateTime) = '"& MonthStr &"' AND Employee_ID = '"& Employee_ID &"'")
Sum_2 = Rs("Sum_2")
Rs.Close
Set Rs = Conn.Execute("Select Sum(Grade_Numeric) as Sum_3 From Grade_List Where Grade_Type = '绩效' AND datepart(yyyy,DateTime) = '"& YearStr &"' AND datepart(mm,DateTime) = '"& MonthStr &"' AND Employee_ID = '"& Employee_ID &"'")
Sum_3 = Rs("Sum_3")
Rs.Close
Set Rs = Nothing
IF Not IsNumeric(Sum_1) or Sum_1 = "" Then Sum_1 = 0
IF Not IsNumeric(Sum_2) or Sum_2 = "" Then Sum_2 = 0
IF Not IsNumeric(Sum_3) or Sum_3 = "" Then Sum_3 = 0
Set Rs = Conn.Execute("Select * From Grade Where datepart(yyyy,DateTime) = '"& YearStr &"' AND datepart(mm,DateTime) = '"& MonthStr &"' AND Employee_ID = '"& Employee_ID &"'")
IF Not(Rs.bof and Rs.eof) Then
Conn.Execute("Update Grade Set Grade_1 = "& 200+Sum_1 &",Grade_2 = "& 300+Sum_2 &",Grade_3 = "& Sum_3 &",Grade_Numeric = "& (200+Sum_1)+(300+Sum_2)+Sum_3 &" Where datepart(yyyy,DateTime) = '"& YearStr &"' AND datepart(mm,DateTime) = '"& MonthStr &"' AND Employee_ID = '"& Employee_ID &"'")
Else
Conn.Execute("Insert Into Grade (Employee_ID,Grade_1,Grade_2,Grade_3,Grade_Numeric,DateTime) Values ('"& Employee_ID &"',"& 200+Sum_1 &","& 300+Sum_2 &","& Sum_3 &","& (200+Sum_1)+(300+Sum_2)+Sum_3 &",'"& cdate(YearStr & "-" & MonthStr) &"')")
End IF
Rs.Close
Set Rs = Nothing
Set Rs = Conn.Execute("Select * From Grade Where datepart(yyyy,DateTime) = '"& YearStr &"' AND datepart(mm,DateTime) = '"& MonthStr &"' AND Employee_ID = '"& Employee_ID &"'")
IF Not(Rs.bof and Rs.eof) Then
Grade_1 = Rs("Grade_1")
Grade_2 = Rs("Grade_2")
Grade_3 = Rs("Grade_3")
Grade_Numeric = Rs("Grade_Numeric")
End IF
Rs.Close
Set Rs = Nothing
%>
</table></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="24" colspan="3" align="left" valign="middle" background="Images/box_bg_1.gif"> 本月总考评分：<font color="#FF0000"><%=Grade_Numeric%></font> 在职：<font color="#FF0000"><%=Grade_1%></font> 行为：<font color="#FF0000"><%=Grade_2%></font> 绩效：<font color="#FF0000"><%=Grade_3%></font></td>
<td width="33%" height="24" align="right" valign="middle" background="Images/box_bg_1.gif"><a href="My_Grade.asp?TimeStr=<%= DateAdd("m",-1,NextTime)%>&Employee_ID=<%=Trim(Request.QueryString("Employee_ID"))%>">上一月</a> <a href="My_Grade.asp?TimeStr=<%= DateAdd("m",+1,NextTime)%>&Employee_ID=<%=Trim(Request.QueryString("Employee_ID"))%>">下一月</a> </td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="1" bgcolor="#E2E1E1"></td>
</tr>
</table> </td>
</tr>
</table> </td>
</tr>
</table>
<%
end select
Conn.Close
Set Conn = Nothing
%>
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="6"></td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?