📄 newinitial_f.asp
字号:
<!--#include file="../config.ini" -->
<!--#include file="../commfunction.inc" -->
<%
if Request("id")<>"" then
dim connq
set connq=server.CreateObject("adodb.connection")
connq.Open connstring
sql="select * from InitialFinance where id="&Request("id")
set rsq=connq.Execute(sql)
accountid=rsq("accountid")
account=getfieldvalue("account","accountid",rsq("accountid"),"account")
financetype=rsq("financetype")
initialcollect=rsq("initialcollect")
initialpay=rsq("initialpay")
initailinvoice=rsq("initailinvoice")
description=rsq("description")
rsq.Close
set rsq=nothing
connq.Close
set connq=nothing
end if
if request("account")<>"" then
dim conn
dim rs
set conn=server.CreateObject("adodb.connection")
set rs=server.CreateObject("adodb.recordset")
conn.Open connstring
if request("id")="" then
'response.write "select accountid from InitialFinance where accountid='"&request("account")&"' and sysaccountid='"&request("sysaccountid")&"' and financetype='"&request("type")&"'"
'response.end
rs.Open "select accountid from InitialFinance where accountid='"&request("account")&"' and sysaccountid='"&request("sysaccountid")&"' and financetype='"&request("type")&"'" ,conn,1,1
if rs.eof then
rs.close
rs.Open "select * from InitialFinance",conn,2,3,1
rs.AddNew
rs("creator")=session("loginid")
rs("createdate")=now()
rs("lastmoduser")=session("loginid")
rs("lastmoddate")=now()
else
rs.Close
set rs=nothing
conn.Close
set conn=nothing
%>
<script language=javascript>
alert('<%=request.form("accountname")%>'+'客户已存在，请关闭窗口！');
window.opener.location.reload();
window.close();
</script>
<%
end if
else
rs.Open "select * from InitialFinance where id="&request("id"),conn,2,3,1
rs("lastmoduser")=session("loginid")
rs("lastmoddate")=now()
end if
rs("sysaccountid")=cint(request("sysaccountid"))
rs("accountid")=request("account")
if request("type")="initialcollect" then
rs("initialcollect")=request("initialcollect")
elseif request("type")="initialpay" then
rs("initialpay")=request("initialpay")
elseif request("type")="initailinvoice" then
rs("initailinvoice")=request("initailinvoice")
elseif request("type")="initailpoinvoice" then
rs("initailpoinvoice")=request("initailpoinvoice")
end if
rs("financetype")=request("type")
rs("description")=request("description")
rs.Update
rs.Close
set rs=nothing
conn.Close
set conn=nothing
%>
<script language=javascript>
window.opener.location.reload();
window.close();
</script>
<%
end if
%>
<html>
<head>
<LINK href="../global.css" rel=STYLESHEET type=text/css>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title><%if request("id")="" then%>新建<%else%>编辑<%end if%>期初</title>
</head>
<body leftmargin="10" rightmargin="10" topmargin="10">
<%'期初#############################################################################################################%>
<form name="form1" id="form1" method="post" action="">
<input type=hidden name=financetype value=<%=request("type")%>>
<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="FFFFFF" align="center">
<tr>
<td height="25" colspan=2><div align="left"><strong><font size="2" class=title>
<%if request("id")="" then%>新建<%else%>编辑<%end if%>
<%if request("type")="initialcollect" then%>应收款期初
<%elseif request("type")="initialpay" then%>应付款期初
<%elseif request("type")="initailinvoice" then%>应开发票期初
<%elseif request("type")="initailpoinvoice" then%>应收发票期初
<%end if%>
</font></strong></div></td>
</tr>
<tr>
<td height="16" colspan="2" background="../images/title.gif"> </td>
</tr>
<tr>
<td colspan="2" height=2></td>
</tr>
<tr valign="middle">
<td height="25" colspan=2 valign=center><div align=center> <img src="../images/button_save.gif" style="cursor:hand" border=0 onclick="save();">
<img src="../images/button_cancel.gif" style="cursor:hand" border=0 onclick="window.close();">
</div></td>
</tr>
<tr valign="middle">
<td width="20%" height="25" align=center bgcolor="DEDFDE">类型</td>
<td height="25" align=left bgcolor="efefef"><font color=red>
<%if request("type")="initialcollect" then%>
应收款期初
<%elseif request("type")="initialpay" then%>
应付款期初
<%elseif request("type")="initailinvoice" then%>
应开发票期初
<%elseif request("type")="initailpoinvoice" then%>
应收发票期初
<%end if%>
</font></td>
</td>
</tr>
<tr valign="middle">
<td width="20%" height="25" align=center bgcolor="DEDFDE"><font color=red>* </font>客户</td>
<td height="25" align=left bgcolor="efefef">
<input type=hidden name=account value=<%=accountid%>>
<input type=text name=accountname size=25 readonly value="<%=account%>">
<input type=button name=baccount onClick="JavaScript:opensubwin2('form1','account')" value="..." class=black>
</td>
</tr>
<%if request("type")="initialcollect" then%>
<tr valign="middle">
<td width="20%" height="25" align=center bgcolor="DEDFDE"><font color=red>* </font>金额</td>
<td height="25" align=left bgcolor="efefef">
<input type=text name="initialcollect" size=12 value=<%=initialcollect%>></td>
</tr>
<%elseif request("type")="initialpay" then%>
<tr valign="middle">
<td width="20%" height="25" align=center bgcolor="DEDFDE"><font color=red>* </font>金额</td>
<td height="25" align=left bgcolor="efefef">
<input type=text name="initialpay" size=12 value=<%=initialpay%>></td>
</tr>
<%elseif request("type")="initailinvoice" then%>
<tr valign="middle">
<td width="20%" height="25" align=center bgcolor="DEDFDE"><font color=red>* </font>金额</td>
<td height="25" align=left bgcolor="efefef">
<input type=text name="initailinvoice" size=12 value=<%=initailinvoice%>></td>
</tr>
<%elseif request("type")="initailpoinvoice" then%>
<tr valign="middle">
<td width="20%" height="25" align=center bgcolor="DEDFDE"><font color=red>* </font>金额</td>
<td height="25" align=left bgcolor="efefef">
<input type=text name="initailpoinvoice" size=12 value=<%=initailpoinvoice%>></td>
</tr>
<%end if%>
<tr bgcolor="white">
<td width="20%" bgcolor="DEDFDE" >
<div align="center">描述</div></td>
<td bgcolor="EFEFEF"> <textarea name="description" cols="45" rows="4"><%=description%></textarea>
</td>
</tr>
</table>
</form>
<script language=javascript>
function save(){
if (form1.accountname.value==''){
alert('请选择客户!');
form1.accountname.focus();
return false;
}
if (form1.financetype.value=='initialcollect'){
if (form1.initialcollect.value==''){
alert('请输入金额!');
form1.initialcollect.focus();
return false;
}
if (isNaN(form1.initialcollect.value)){
alert('请输入数字!');
form1.initialcollect.focus();
return false;
}
}
if (form1.financetype.value=='initialpay'){
if (form1.initialpay.value==''){
alert('请输入金额!');
form1.initialpay.focus();
return false;
}
if (isNaN(form1.initialpay.value)){
alert('请输入数字!');
form1.initialpay.focus();
return false;
}
}
if (form1.financetype.value=='initailinvoice'){
if (form1.initailinvoice.value==''){
alert('请输入金额!');
form1.initailinvoice.focus();
return false;
}
if (isNaN(form1.initailinvoice.value)){
alert('请输入数字!');
form1.initailinvoice.focus();
return false;
}
}
if (form1.financetype.value=='initailpoinvoice'){
if (form1.initailpoinvoice.value==''){
alert('请输入金额!');
form1.initailpoinvoice.focus();
return false;
}
if (isNaN(form1.initailpoinvoice.value)){
alert('请输入数字!');
form1.initailpoinvoice.focus();
return false;
}
}
form1.submit();
}
</script>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -