📄 update.asp
字号:
<%@ Language=VBScript %>
<%
'文件功能：view_salaries--维护
'编写人员：阿房
'编写时间：2003-09-03 17:08:12
'开发平台：ASP3.0 + MSSQL2000
'版本：1.1.20030908.01
%>
<!-- #include file="../Common/Cls_DbProcess2.1.asp" -->
<!-- #include file="../view_salaries/Cls_view_salaries.asp" -->
<HTML>
<HEAD>
<META NAME="GENERATOR" CONTENT="WindSoft Programmer3">
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=gb2312">
<TITLE>view_salaries--维护</TITLE>
<%
dim mStr_WINDCallType
mStr_WINDCallType = trim(request.querystring("WINDCallType")) '调用方式
dim mStr_WINDURL '请将需要全局传递的变量链接到本变量上，使用方法参见WINDCallType，多个变量之间采用&链接
mStr_WINDURL = "WINDCallType="+Server.URLEncode(mStr_WINDCallType)
'下列为全局变量
dim mStr_PK_salary_id '主鍵
dim mStr_salary_id 'salary_id
dim mStr_salary_date 'salary_date
dim mStr_salary_month 'salary_month
dim mStr_employee_id 'employee_id
dim mStr_salary_info1 'salary_info1
dim mStr_salary_info2 'salary_info2
dim mStr_salary_memo 'salary_memo
dim mStr_Expr1 'Expr1
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%>">view_salaries</A>>>
<A CLASS="locationlastdata" HREF="javascript:window.location.reload()"><%if mStr_PK_salary_id="" then Response.write "新增" else Response.write "修改"%></A>
</TD>
</TR>
</TABLE>
<FORM ACTION="Post_Update.asp?<% =mStr_WINDURL%>" ID="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>salary_id </TD>
<TD>
<INPUT STYLE="WIDTH:100px" NAME="salary_id" VALUE='<% Response.write mStr_salary_id%>'>(数值格式:999999.99)
<FONT COLOR=RED>**</FONT>
</TD>
</TR>
<TR>
<TD>salary_date </TD>
<TD>
<SELECT STYLE="WIDTH:50px" 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>
<%
if (FormatDate(mStr_salary_date,"yyyy")="") then
Call ShowOptionList(Year(Date())-5-gInt_BeginYear,Year(Date())-5,11,Year(Date()))
else
Call ShowOptionList(Val(FormatDate(mStr_salary_date,"yyyy"))-5-gInt_BeginYear,Val(FormatDate(mStr_salary_date,"yyyy"))-5,11,Val(FormatDate(mStr_salary_date,"yyyy")))
end if
%>
</SELECT>年
<SELECT STYLE="WIDTH:40px" 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,FormatDate(mStr_salary_date,"mm")) %>
</SELECT>月
<SELECT STYLE="WIDTH:40px" 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,FormatDate(mStr_salary_date,"dd")) %>
</SELECT>日
<SPAN <%if gInt_BeginYear=0 then response.write "STYLE='DISPLAY:NONE'" %> >
西元：<INPUT STYLE="WIDTH:100px" NAME="salary_date" VALUE='<% Response.write mStr_salary_date%>' READONLY CLASS="READONLY">
</SPAN>
<FONT COLOR=RED>**</FONT>
</TD>
</TR>
<TR>
<TD>salary_month </TD>
<TD>
<INPUT STYLE="WIDTH:100px" NAME="salary_month" VALUE='<% Response.write mStr_salary_month%>'>(数值格式:999999.99)
<FONT COLOR=RED>**</FONT>
</TD>
</TR>
<TR>
<TD>employee_id </TD>
<TD>
<INPUT STYLE="WIDTH:100px" NAME="employee_id" VALUE='<% Response.write mStr_employee_id%>'>(数值格式:999999.99)
<FONT COLOR=RED>**</FONT>
</TD>
</TR>
<TR>
<TD>salary_info1 </TD>
<TD>
<TEXTAREA STYLE="HEIGHT:100px;WIDTH:200px" NAME="salary_info1"><% Response.write mStr_salary_info1%> </TEXTAREA>
<FONT COLOR=RED>**</FONT>
</TD>
</TR>
<TR>
<TD>salary_info2 </TD>
<TD>
<TEXTAREA STYLE="HEIGHT:100px;WIDTH:200px" NAME="salary_info2"><% Response.write mStr_salary_info2%> </TEXTAREA>
<FONT COLOR=RED>**</FONT>
</TD>
</TR>
<TR>
<TD>salary_memo </TD>
<TD>
<INPUT STYLE="WIDTH:200px" NAME="salary_memo" VALUE='<% Response.write mStr_salary_memo%>'>
<FONT COLOR=RED>**</FONT>
</TD>
</TR>
<TR>
<TD>Expr1 </TD>
<TD>
<INPUT STYLE="WIDTH:200px" NAME="Expr1" VALUE='<% Response.write mStr_Expr1%>'>
<FONT COLOR=RED>**</FONT>
</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>
<TD ALIGN="RIGHT">
<% if (mStr_PK_salary_id="") then%>
<INPUT NAME="Continue" TYPE="checkbox" VALUE="1" <% if request.querystring("Continue")<>empty then Response.write "CHECKED"%>>
确定后继续增加资料
<% end if %>
</TD>
</TR>
</TABLE>
<DIV STYLE="DISPLAY:NONE">
<INPUT TYPE="hidden" NAME="PK_salary_id" VALUE='<% Response.write mStr_PK_salary_id%>'>
</DIV>
</FORM>
</BODY>
</HTML>
<%
function InitData()
'初始化
dim Rec_Data '结果集
mStr_PK_salary_id = trim(request.querystring("PK_salary_id"))
if (mStr_PK_salary_id<>"") then
'读取原有数据
set Rec_Data = mCls_view_salaries.GetData(mStr_PK_salary_id)
if (not Rec_Data.eof) then
mStr_salary_id = Server.HTMLEncode(trim(Rec_Data.fields("salary_id") & ""))
mStr_salary_date = Server.HTMLEncode(trim(Rec_Data.fields("salary_date") & ""))
mStr_salary_month = Server.HTMLEncode(trim(Rec_Data.fields("salary_month") & ""))
mStr_employee_id = Server.HTMLEncode(trim(Rec_Data.fields("employee_id") & ""))
mStr_salary_info1 = Server.HTMLEncode(trim(Rec_Data.fields("salary_info1") & ""))
mStr_salary_info2 = Server.HTMLEncode(trim(Rec_Data.fields("salary_info2") & ""))
mStr_salary_memo = Server.HTMLEncode(trim(Rec_Data.fields("salary_memo") & ""))
mStr_Expr1 = Server.HTMLEncode(trim(Rec_Data.fields("Expr1") & ""))
end if
Rec_Data.close
if (mStr_PK_salary_id="") then
call ShowMess(16,"对不起，找不到您所要的 [view_salaries]！")
call WindowBack()
end if
else
mStr_salary_id = ""
mStr_salary_date = ""
mStr_salary_month = ""
mStr_employee_id = ""
mStr_salary_info1 = ""
mStr_salary_info2 = ""
mStr_salary_memo = ""
mStr_Expr1 = ""
end if
end function
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -