📄 update.asp
字号:
<%@ Language=VBScript %>
<%
'文件功能：wh_tech_bonuses--维护
'编写人员：阿房
'编写时间：2003-08-16 19:57:18
'开发平台：ASP3.0 + MSSQL2000
%>
<!-- #include file="../Common/Cls_DbProcess2.1.asp" -->
<!-- #include file="../wh_tech_bonuses/Cls_wh_tech_bonuses.asp" -->
<!-- #include file="../pub/conn.asp" -->
<!-- #include file="../pub/fun.asp" -->
<%call checklogin()%>
<%if session("right")<2 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%>
<%flag=request("flag")
'response.write flag%>
<%
set rs=conn.execute("select project_id,project_gain,project_gain2,project_not,project_notpay,project_sum,project_firstpay,project_lastpay from view_projects")%>
<script language = "vbScript">
dim proj(10000,3)
<%j=0
do while not rs.eof
%>
proj(<%=j%>,0)=<%=rs("project_id")%>
<%if rs("project_not")>0.1 then%>
proj(<%=j%>,1)=<%=rs("project_gain")%>
proj(<%=j%>,2)=0
<%else
if int(rs("project_firstpay"))/int(rs("project_sum"))>=0.9 then
%>
proj(<%=j%>,1)=<%=rs("project_gain")+rs("project_notpay")%>
proj(<%=j%>,2)=0
<% else%>
proj(<%=j%>,1)=<%=rs("project_gain")%>
proj(<%=j%>,2)=<%=rs("project_gain2")+rs("project_notpay")%>
<% end if
end if%>
<% rs.movenext
j=j+1
loop
rs.close
%>
function showsum(proj_id)
for i=0 to 10000
if int(proj_id) = 0 then
Frm_Update.tbonus_firstsum.value=0
Frm_Update.tbonus_lastsum.value=0
Frm_Update.tbonus_firstsum1.value=0
Frm_Update.tbonus_lastsum1.value=0
exit for
end if
if int(proj_id) = proj(i,0) then
Frm_Update.tbonus_firstsum.value=proj(i,1)
Frm_Update.tbonus_lastsum.value=proj(i,2)
Frm_Update.tbonus_firstsum1.value=proj(i,1)*0.03
Frm_Update.tbonus_lastsum1.value=proj(i,2)*0.03
exit for
end if
next
end function
</SCRIPT>
<HTML>
<HEAD>
<META NAME="GENERATOR" CONTENT="WindSoft Programmer3">
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=gb2312">
<TITLE>wh_tech_bonuses--维护</TITLE>
<%
dim mStr_WINDCallType
mStr_WINDCallType = trim(request.querystring("WINDCallType")) '调用方式
dim mStr_WINDURL '请将需要全局传递的变量链接到本变量上，使用方法参见WINDCallType，多个变量之间采用&链接
mStr_WINDURL = "WINDCallType="+Server.URLEncode(mStr_WINDCallType)
'下列为全局变量
dim mStr_PK_tbonus_id '主鍵
dim mStr_tbonus_memo '备注
dim mStr_tbonus_quote '技术部分配比例
dim mStr_tbonus_firstsum '项目纯分配金额（前期）
dim mStr_tbonus_fpercent '个人前期分配比例
dim mStr_tbonus_fisgive '前期是否发放
dim mStr_tbonus_fdate '前期发放日期
dim mStr_tbonus_lastsum '项目纯分配金额（后期）
dim mStr_tbonus_lpercent '个人后期分配比例
dim mStr_tbonus_lisgive '后期是否发放
dim mStr_tbonus_ldate '后期发放日期
dim mStr_employee_id '员工ID
dim mStr_project_id '项目ID
call InitData()
%>
<SCRIPT LANGUAGE="vbScript">
</SCRIPT>
</HEAD>
<BODY>
<TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD>
<FONT CLASS="locationhead">您的位置：</FONT>
技术部提成管理>>
<A CLASS="locationlastdata" HREF="javascript:window.location.reload()"><%if mStr_PK_tbonus_id="" then Response.write "新增" else Response.write "修改"%></A>
</TD>
</TR>
</TABLE>
<FORM ACTION="Post_Update.asp?<% =mStr_WINDURL%>" ID="Frm_Update" name="Frm_Update" METHOD="post">
打<FONT COLOR=RED>**</FONT>的栏位为必须填写
<TABLE WIDTH="80%" <% Response.write GetTableBorder()%>>
<COLGROUP>
<COL 1 CLASS="TABLEHEAD" WIDTH="100" ALIGN="RIGHT">
<COL 1 CLASS="TABLEDATA">
</COLGROUP>
<TR>
<TD>员工姓名 </TD>
<TD>
<SELECT NAME="employee_id">
<OPTION VALUE='' SELECTED>请选择</OPTION>
<%Call listemployee(1,mStr_employee_id)%>
</SELECT>
<FONT COLOR=RED>**</FONT>
</TD>
</TR>
<TR>
<TD>参与项目 </TD>
<TD>
<SELECT NAME="project_id" onchange="showsum(Frm_Update.project_id.value);">
<OPTION VALUE='0' SELECTED>请选择</OPTION>
<%Call listproj(mStr_project_id)%>
</SELECT>
<FONT COLOR=RED>**</FONT>
</TD>
</TR>
<TD>备注 </TD>
<TD>
<TEXTAREA STYLE="HEIGHT:100px;WIDTH:200px" NAME="tbonus_memo"><% Response.write mStr_tbonus_memo%> </TEXTAREA>
</TD>
</TR>
<TR>
<TD>技术部分配金额（前期） </TD>
<TD>
<INPUT STYLE="WIDTH:100px" NAME="tbonus_firstsum1" VALUE='<%if len(mStr_tbonus_firstsum)>0 then Response.write mStr_tbonus_firstsum*0.03%>' readonly style="font-size: 9pt; color: blue" size="8">
<INPUT VALUE='<% Response.write mStr_tbonus_firstsum%>' type="hidden" NAME="tbonus_firstsum">
<FONT COLOR=RED>**</FONT>
</TD>
</TR>
<TR>
<TD>个人前期分配比例 </TD>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -