⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 search.asp

📁 这是一个自己研发的薪酬管理系统
💻 ASP
字号:
<%@ Language=VBScript %>
<%
'文件功能:工资管理---查找、检索
'版权所有:万户网络
'编写人员:房鹏
'编写时间:2003-8-12
'修改人员:房鹏
'修改时间:2003-8-13
'修改目的:设立权限控制
%>

<!-- #include file="../Common/Cls_DbProcess2.1.asp" -->
<!-- #include file="../wh_salaries/Cls_wh_salaries.asp" -->
<!-- #include file="../pub/conn.asp" -->
<!-- #include file="../pub/fun.asp" -->

<%call checklogin()%>

<%
if session("right")<3 then
	dim lr
	lr="<font color=red>"&now()&"有"&session("name")&"试图查看工资总表  IP:"&REQUEST.SERVERVARIABLES("REMOTE_ADDR")&"</font>"
    call savelog("../pub/error.htm",lr)
	call savedatalog(now(),session("name"),"试图查看工资总表",REQUEST.SERVERVARIABLES("REMOTE_ADDR"),2)
	response.redirect("../error.asp?msg=2")
end if
%>


<HTML>
<HEAD>
    <META NAME="GENERATOR" CONTENT="WindSoft Programmer3">
    <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=gb2312">
    <TITLE>wh_salaries--查询</TITLE>
    <%
    dim mStr_WINDCallType
    mStr_WINDCallType = trim(request.querystring("WINDCallType"))       '调用方式
    dim mStr_WINDURL   '请将需要全局传递的变量链接到本变量上,使用方法参见WINDCallType,多个变量之间采用&链接
    mStr_WINDURL = "WINDCallType="+Server.URLEncode(mStr_WINDCallType)
    
    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="javascript:window.location.reload()">查询</A>
            </TD>
        </TR>
    </TABLE>
    <FORM ACTION="Main.asp?<% =mStr_WINDURL%>" ID="Frm_Update" METHOD="post">
        <TABLE WIDTH="80%" <% Response.write GetTableBorder()%>>
            <COLGROUP>
                <COL 1 CLASS="TABLEHEAD" WIDTH="100" ALIGN="RIGHT">
                <COL 2 CLASS="TABLEDATA">
            </COLGROUP>
            <TR>
                <TD>排序方式&nbsp;</TD>
                <TD>&nbsp;
                    <SELECT NAME="SortBy">
                        <OPTION VALUE='salary_month'>发放月份</OPTION>
                        <OPTION VALUE='salary_date'>发放时间</OPTION>
                        <OPTION VALUE='salary_basic'>基本工资</OPTION>
                        <OPTION VALUE='salary_tech'>技能工资</OPTION>
                        <OPTION VALUE='salary_eduage'>工龄学历</OPTION>
                        <OPTION VALUE='salary_duty'>职务工资</OPTION>
                        <OPTION VALUE='salary_prize1'>满勤奖</OPTION>
                        <OPTION VALUE='salary_prize2'>项目奖励</OPTION>
                        <OPTION VALUE='salary_manage'>管理质量</OPTION>
                        <OPTION VALUE='salary_special'>特殊补贴</OPTION>
                        <OPTION VALUE='salary_food'>餐补</OPTION>
                        <OPTION VALUE='salary_hols'>事假</OPTION>
                        <OPTION VALUE='salary_break'>违纪</OPTION>
                        <OPTION VALUE='salary_insurance'>保险</OPTION>
                        <OPTION VALUE='salary_tax'>个税</OPTION>
                        <OPTION VALUE='salary_late'>迟到</OPTION>
                        <OPTION VALUE='salary_other'>其它</OPTION>
                        <OPTION VALUE='employee_id'>员工ID</OPTION>
                    </SELECT>
                    <INPUT TYPE=RADIO       NAME="AscMark"  VALUE='' CHECKED>升序
                    <INPUT TYPE=RADIO       NAME="AscMark"  VALUE='desc'>倒序
                    <INPUT TYPE=HIDDEN      NAME="Page"    VALUE='1'>
                </TD>
            </TR>
            <TR>
                <TD>发放月份&nbsp;</TD>
                <TD>&nbsp;
				<SELECT NAME="salary_month" ONCHANGE='javascript:window.Frm_Update.salary_date.value=ConvertToDate(window.Frm_Update.salary_dateYear.value,window.Frm_Update.salary_dateMonth.value,window.Frm_Update.salary_dateDay.value)'>
                        <OPTION VALUE='' SELECTED>请选择</OPTION>
                        <% Call ShowOptionList(1,1,12,0) %>
				</SELECT>月
                </TD>
            </TR>
            <TR>
                <TD>发放时间&nbsp;</TD>
                <TD>&nbsp;
                    <SELECT NAME="salary_dateYear" ONCHANGE='javascript:window.Frm_Update.salary_date.value=ConvertToDate(window.Frm_Update.salary_dateYear.value,window.Frm_Update.salary_dateMonth.value,window.Frm_Update.salary_dateDay.value)'>
                        <OPTION VALUE='' SELECTED>请选择</OPTION>
                        <% Call ShowOptionList(Year(Date())-5-gInt_BeginYear,Year(Date())-5,11,Year(Date())) %>
                    </SELECT>年
                    <SELECT NAME="salary_dateMonth" ONCHANGE='javascript:window.Frm_Update.salary_date.value=ConvertToDate(window.Frm_Update.salary_dateYear.value,window.Frm_Update.salary_dateMonth.value,window.Frm_Update.salary_dateDay.value)'>
                        <OPTION VALUE='' SELECTED>请选择</OPTION>
                        <% Call ShowOptionList(1,1,12,0) %>
                    </SELECT>月
                    <SELECT NAME="salary_dateDay" ONCHANGE='javascript:window.Frm_Update.salary_date.value=ConvertToDate(window.Frm_Update.salary_dateYear.value,window.Frm_Update.salary_dateMonth.value,window.Frm_Update.salary_dateDay.value)'>
                        <OPTION VALUE='' SELECTED>请选择</OPTION>
                        <% Call ShowOptionList(1,1,31,0) %>
                    </SELECT>日
                    <SPAN <%if gInt_BeginYear=0 then response.write "STYLE='DISPLAY:NONE'" %> >
                    &nbsp;&nbsp;&nbsp;西元:<INPUT STYLE="WIDTH:100px" NAME="salary_date" VALUE='' READONLY CLASS="READONLY">
                    </SPAN>
                </TD>
            </TR>
            <TR>
                <TD>基本工资&nbsp;</TD>
                <TD>&nbsp;
                    <INPUT STYLE="WIDTH:100px" NAME="salary_basic">
                </TD>
            </TR>
            <TR>
                <TD>技能工资&nbsp;</TD>
                <TD>&nbsp;
                    <INPUT STYLE="WIDTH:100px" NAME="salary_tech">
                </TD>
            </TR>
            <TR>
                <TD>工龄学历&nbsp;</TD>
                <TD>&nbsp;
                    <INPUT STYLE="WIDTH:100px" NAME="salary_eduage">
                </TD>
            </TR>
            <TR>
                <TD>职务工资&nbsp;</TD>
                <TD>&nbsp;
                    <INPUT STYLE="WIDTH:100px" NAME="salary_duty">
                </TD>
            </TR>
            <TR>
                <TD>满勤奖&nbsp;</TD>
                <TD>&nbsp;
                    <INPUT STYLE="WIDTH:100px" NAME="salary_prize1">
                </TD>
            </TR>
            <TR>
                <TD>项目奖励&nbsp;</TD>
                <TD>&nbsp;
                    <INPUT STYLE="WIDTH:100px" NAME="salary_prize2">
                </TD>
            </TR>
            <TR>
                <TD>管理质量&nbsp;</TD>
                <TD>&nbsp;
                    <INPUT STYLE="WIDTH:100px" NAME="salary_manage">
                </TD>
            </TR>
            <TR>
                <TD>特殊补贴&nbsp;</TD>
                <TD>&nbsp;
                    <INPUT STYLE="WIDTH:100px" NAME="salary_special">
                </TD>
            </TR>
            <TR>
                <TD>餐补&nbsp;</TD>
                <TD>&nbsp;
                    <INPUT STYLE="WIDTH:100px" NAME="salary_food">
                </TD>
            </TR>
            <TR>
                <TD>事假&nbsp;</TD>
                <TD>&nbsp;
                    <INPUT STYLE="WIDTH:100px" NAME="salary_hols">
                </TD>
            </TR>
            <TR>
                <TD>违纪&nbsp;</TD>
                <TD>&nbsp;
                    <INPUT STYLE="WIDTH:100px" NAME="salary_break">
                </TD>
            </TR>
            <TR>
                <TD>保险&nbsp;</TD>
                <TD>&nbsp;
                    <INPUT STYLE="WIDTH:100px" NAME="salary_insurance">
                </TD>
            </TR>
            <TR>
                <TD>个税&nbsp;</TD>
                <TD>&nbsp;
                    <INPUT STYLE="WIDTH:100px" NAME="salary_tax">
                </TD>
            </TR>
            <TR>
                <TD>迟到&nbsp;</TD>
                <TD>&nbsp;
                    <INPUT STYLE="WIDTH:100px" NAME="salary_late">
                </TD>
            </TR>
            <TR>
                <TD>其它&nbsp;</TD>
                <TD>&nbsp;
                    <INPUT STYLE="WIDTH:100px" NAME="salary_other">
                </TD>
            </TR>
            <TR>
                <TD>员工姓名&nbsp;</TD>
                <TD>&nbsp;
                    <SELECT NAME="employee_id">
					<OPTION VALUE=''>请选择</OPTION>
					<%call listemployee(-1,0)%>
					</SELECT>	
                </TD>
            </TR>
        </TABLE>
        <TABLE BORDER="0" WIDTH="80%">
            <TR>
                <TD>
                    <A HREF="#" ONCLICK="javascript:window.Frm_Update.submit();return false"><IMG SRC="../image/btok.gif" BORDER="0"></A>
                    <A HREF="#" ONCLICK="javascript:window.Frm_Update.reset();return false"><IMG SRC="../image/btno.gif" BORDER="0"></A> 
                </TD>
            </TR>
        </TABLE>
        <DIV STYLE="DISPLAY:NONE">
        </DIV>
    </FORM> 
</BODY> 
</HTML> 

<%
function InitData()
end function
%>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -