📄 main.asp
字号:
<%@ Language=VBScript %>
<%
'文件功能：view_tech_bonus--主界面
'编写人员：阿房
'编写时间：2003-08-16 19:57:18
'开发平台：ASP3.0 + MSSQL2000
%>
<!-- #include file="../Common/Cls_DbProcess2.1.asp" -->
<!-- #include file="../view_tech_bonus/Cls_view_tech_bonus.asp" -->
<!-- #include file="../pub/fun.asp" -->
<%call checklogin()%>
<HTML>
<HEAD>
<META NAME="GENERATOR" CONTENT="WindSoft Programmer3">
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=gb2312">
<TITLE>view_tech_bonus--主界面</TITLE>
<%
dim mStr_WINDCallType
mStr_WINDCallType = trim(request.querystring("WINDCallType")) '调用方式
dim mStr_WINDURL '请将需要全局传递的变量链接到本变量上，使用方法参见WINDCallType，多个变量之间采用&链接
mStr_WINDURL = "WINDCallType="+Server.URLEncode(mStr_WINDCallType)
dim mInt_Page '当前页
dim mInt_RecordCount '总记录数
dim mInt_CountPerPage '每页记录数
dim mStr_SortBy '排序方式
dim mStr_AscMark '排列顺序
dim mStr_employee_name '姓名
dim mStr_project_name '项目名称
dim mStr_project_begin '合同签定日期
dim mStr_project_end '规定完成日期
dim mStr_project_finish '实际完成日期
dim mStr_tbonus_fprize '前期分配金额
dim mStr_tbonus_fisgive '前期是否发放
dim mStr_tbonus_fdate '前期发放日期
dim mStr_tbonus_lprize '后期分配金额
dim mStr_tbonus_lisgive '后期是否发放
dim mStr_tbonus_ldate '后期发放日期
dim mStr_employee_id '员工ID
dim mStr_dpt_id '部门ID
call InitData()
%>
</HEAD>
<BODY>
<TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD>
<FONT CLASS="locationhead">您的位置：</FONT>
<A CLASS="locationdata" HREF="Main.asp?<% =mStr_WINDURL%>">个人提成信息</A>>>
<A CLASS="locationlastdata" HREF="Main.asp?<% =mStr_WINDURL%>">主界面</A>
</TD>
</TR>
</TABLE>
<FORM ID="Frm_Data" NAME="Frm_Data">
<TABLE BORDER="0" WIDTH="100%">
<TR>
<TD ALIGN="LEFT" WIDTH=33%>
<A HREF="javascript:SelectAll()">全选</A>
<A HREF="javascript:SelectReverse()">反选</A>
</TD>
<TD ALIGN="RIGHT">
<A HREF="javascript:WindowPrint()">打印</A>
<A HREF="Search.asp?<% =mStr_WINDURL%>">查询</A>
</TD>
</TR>
</TABLE>
<TABLE WIDTH=100% <% Response.write GetTableBorder()%>>
<COLGROUP>
<COL 1 WIDTH="40" ALIGN="CENTER">
<COL 2 WIDTH="40" ALIGN="CENTER">
</COLGROUP>
<TR CLASS='TABLEHEAD' ALIGN=CENTER>
<TD>序号</TD>
<TD><A HREF='javascript:OrderBy("employee_name")'>姓名<% call GetOrderBy("employee_name")%></A></TD>
<TD><A HREF='javascript:OrderBy("project_name")'>项目名称<% call GetOrderBy("project_name")%></A></TD>
<TD><A HREF='javascript:OrderBy("project_begin")'>合同签定日期<% call GetOrderBy("project_begin")%></A></TD>
<TD><A HREF='javascript:OrderBy("project_end")'>规定完成日期<% call GetOrderBy("project_end")%></A></TD>
<TD><A HREF='javascript:OrderBy("project_finish")'>实际完成日期<% call GetOrderBy("project_finish")%></A></TD>
<TD><A HREF='javascript:OrderBy("tbonus_fprize")'>前期分配金额<% call GetOrderBy("tbonus_fprize")%></A></TD>
<TD><A HREF='javascript:OrderBy("tbonus_fdate")'>前期发放日期<% call GetOrderBy("tbonus_fdate")%></A></TD>
<TD><A HREF='javascript:OrderBy("tbonus_lprize")'>后期分配金额<% call GetOrderBy("tbonus_lprize")%></A></TD>
<TD><A HREF='javascript:OrderBy("tbonus_lisgive")'>后期发放日期<% call GetOrderBy("tbonus_lisgive")%></A></TD>
</TR>
<%
call ShowAllData_view_tech_bonus() '显示查询结果
%>
</TABLE>
<%
'显示页数
call ShowPage(mInt_RecordCount,mInt_CountPerPage,mInt_Page,"WIDTH:100%")
%>
</FORM>
<DIV STYLE="DISPLAY:NONE">
<FORM ACTION="?<% =mStr_WINDURL%>" ID="Frm_Update" METHOD="post">
<INPUT NAME="Page" id=Page VALUE='<% =mInt_Page %>'>
<INPUT NAME="SortBy" id=SortBy VALUE='<% =mStr_SortBy %>'>
<INPUT NAME="AscMark" id=AscMark VALUE='<% =mStr_AscMark %>'>
<INPUT NAME='employee_name' VALUE='<% =mStr_employee_name %>'>
<INPUT NAME='project_name' VALUE='<% =mStr_project_name %>'>
<INPUT NAME='project_begin' VALUE='<% =mStr_project_begin %>'>
<INPUT NAME='project_end' VALUE='<% =mStr_project_end %>'>
<INPUT NAME='project_finish' VALUE='<% =mStr_project_finish %>'>
<INPUT NAME='tbonus_fprize' VALUE='<% =mStr_tbonus_fprize %>'>
<INPUT NAME='tbonus_fisgive' VALUE='<% =mStr_tbonus_fisgive %>'>
<INPUT NAME='tbonus_fdate' VALUE='<% =mStr_tbonus_fdate %>'>
<INPUT NAME='tbonus_lprize' VALUE='<% =mStr_tbonus_lprize %>'>
<INPUT NAME='tbonus_lisgive' VALUE='<% =mStr_tbonus_lisgive %>'>
<INPUT NAME='tbonus_ldate' VALUE='<% =mStr_tbonus_ldate %>'>
<INPUT NAME='employee_id' VALUE='<% =mStr_employee_id %>'>
<INPUT NAME='dpt_id' VALUE='<% =mStr_dpt_id %>'>
</FORM>
</DIV>
</BODY>
</HTML>
<%
function InitData()
'初始化
dim Str_Mess '错误信息
dim Int_Count '错误记录数
'读取查询条件
mInt_Page = val(trim(request.form("Page")))
if mInt_Page=0 then mInt_Page=Val(session("session_view_tech_bonusPage"))
if mInt_Page=0 then mInt_Page=1
session("session_view_tech_bonusPage")=mInt_Page
mStr_SortBy = trim(request.form("SortBy"))
mStr_AscMark = trim(request.form("AscMark"))
mStr_employee_name = trim(request.form("employee_name"))
mStr_project_name = trim(request.form("project_name"))
mStr_project_begin = trim(request.form("project_begin"))
mStr_project_end = trim(request.form("project_end"))
mStr_project_finish = trim(request.form("project_finish"))
mStr_tbonus_fprize = trim(request.form("tbonus_fprize"))
mStr_tbonus_fisgive = trim(request.form("tbonus_fisgive"))
mStr_tbonus_fdate = trim(request.form("tbonus_fdate"))
mStr_tbonus_lprize = trim(request.form("tbonus_lprize"))
mStr_tbonus_lisgive = trim(request.form("tbonus_lisgive"))
mStr_tbonus_ldate = trim(request.form("tbonus_ldate"))
mStr_employee_id = trim(request.form("employee_id"))
mStr_dpt_id = trim(request.form("dpt_id"))
Str_Mess = ""
Int_Count = 1
if ((mStr_project_begin<>"") and not (IsDate(mStr_project_begin))) then
Str_Mess = Str_Mess + "\n" + cstr(Int_Count) + ") [合同签定日期] 一栏必须为日期！"
Int_Count = Int_Count+1
end if
if ((mStr_project_end<>"") and not (IsDate(mStr_project_end))) then
Str_Mess = Str_Mess + "\n" + cstr(Int_Count) + ") [规定完成日期] 一栏必须为日期！"
Int_Count = Int_Count+1
end if
if ((mStr_project_finish<>"") and not (IsDate(mStr_project_finish))) then
Str_Mess = Str_Mess + "\n" + cstr(Int_Count) + ") [实际完成日期] 一栏必须为日期！"
Int_Count = Int_Count+1
end if
if ((mStr_tbonus_fprize<>"") and not (IsNumeric(mStr_tbonus_fprize))) then
Str_Mess = Str_Mess + "\n" + cstr(Int_Count) + ") [前期分配金额] 一栏必须为数值！"
Int_Count = Int_Count+1
end if
if ((mStr_tbonus_fdate<>"") and not (IsDate(mStr_tbonus_fdate))) then
Str_Mess = Str_Mess + "\n" + cstr(Int_Count) + ") [前期发放日期] 一栏必须为日期！"
Int_Count = Int_Count+1
end if
if ((mStr_tbonus_lprize<>"") and not (IsNumeric(mStr_tbonus_lprize))) then
Str_Mess = Str_Mess + "\n" + cstr(Int_Count) + ") [后期分配金额] 一栏必须为数值！"
Int_Count = Int_Count+1
end if
if ((mStr_tbonus_ldate<>"") and not (IsDate(mStr_tbonus_ldate))) then
Str_Mess = Str_Mess + "\n" + cstr(Int_Count) + ") [后期发放日期] 一栏必须为日期！"
Int_Count = Int_Count+1
end if
if ((mStr_employee_id<>"") and not (IsNumeric(mStr_employee_id))) then
Str_Mess = Str_Mess + "\n" + cstr(Int_Count) + ") [员工ID] 一栏必须为数值！"
Int_Count = Int_Count+1
end if
if ((mStr_dpt_id<>"") and not (IsNumeric(mStr_dpt_id))) then
Str_Mess = Str_Mess + "\n" + cstr(Int_Count) + ") [部门ID] 一栏必须为数值！"
Int_Count = Int_Count+1
end if
if (Str_Mess<>"") then
call ShowMess(16,"对不起，您录入的资料存在以下错误:" _
+"\n"+ Str_Mess _
+"\n"++"\n"+ "请检查资料或联系管理员！")
call WindowBack()
end if
end function
function ShowAllData_view_tech_bonus()
'显示查询结果
dim Str_PK_employee_id '主鍵
dim Str_employee_name '姓名
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -