xiangmu_add.asp

财务预算管理 财务支出

<!--#include file="sysconfig.asp"-->
<!--#include file="Inc/Function_1.asp"-->

<%
'黄华于2008年3月
%>

<%
dim Action,guikou_id,danwei_id,xiangmu_name,rs,FoundErr,ErrMsg
Action=trim(Request("Action"))
guikou_id=trim(request("guikou_id"))
danwei_id=trim(request("danwei_id"))
xiangmu_name=trim(request("xiangmu_name"))

if Action="Add" then
	if guikou_id="" or danwei_id="" then
		FoundErr=True
		ErrMsg=ErrMsg & "<br><li>归口或者项目不能为空！</li>"
	end if
	if xiangmu_name="" then
		FoundErr=True
		ErrMsg=ErrMsg & "<br><li>项目名不能为空！</li>"
	end if
	if FoundErr<>True then
		Set rs=Server.CreateObject("Adodb.RecordSet")
		if yzcv<>zcv then response.end
		rs.open "Select * from xiangmu Where guikou_id='" & guikou_id & "'AND danwei_id='" & danwei_id & "'AND xiangmu_name ='" & xiangmu_name & "'",conn,1,3
		if not rs.EOF then
			FoundErr=True
			ErrMsg=ErrMsg & "<br><li>“" & guikou_id& "”“" & danwei_id& "”中已经存在单位“" & xiangmu_name & "”！</li>"
		else
     		rs.addnew
			rs("guikou_id")=guikou_id
			rs("danwei_id")=danwei_id
    	 	rs("xiangmu_name")=xiangmu_name
			rs("cost_delete")=0
     		rs.update
	     	rs.Close
    	 	set rs=Nothing
     		call CloseConn()
			Response.Redirect "Class.asp"  
		end if
	end if
end if
if FoundErr=True then
	call WriteErrMsg()
else
%>
<script language="JavaScript" type="text/JavaScript">
function checkSmall()
{
  if (document.form2.guikou_name.value=="")
  {
    alert("请先添加归口名称！");
	document.form1.guikou_name.focus();
	return false;
  }

  if (document.form2.xiangmu_name.value=="")
  {
    alert("项目名称不能为空！");
	document.form2.danwei_name.focus();
	return false;
  }
}
</script>
<!-- #include file="Inc/Head.asp" -->
<BR>
<table cellpadding="2" cellspacing="1" border="0" width="360" align="center" class="a2">
	<tr>
		<td class="a1" height="25" align="center"><strong>预 算 基 础 设 置</strong></td>
	</tr>
	<tr class="a4">
		<td align="center">
			<BR>
			<form name="form2" method="post" action="xiangmu_Add.asp" onSubmit="return checkSmall()">
			
        <table width="350" border="0" align="center" cellpadding="0" cellspacing="2" class="border">
          <tr bgcolor="#999999" class="title"> 
            <td height="25" colspan="2" align="center"><strong>添加项目</strong></td>
          </tr>
          <tr class="tdbg"> 
            <td width="126" height="22" bgcolor="#C0C0C0" align=right><strong>所属业务科室：</strong></td>
            <td width="218" bgcolor="#E3E3E3"> 
              <%set rsguikou=conn.execute("select * from guikou where id="&guikou_id&"")%>
              <%=rsguikou("guikou_name")%> <input name="guikou_id"  id="guikou_id" type="hidden"value=<%=rsguikou("id")%>> 
            </td>
          </tr>
          <tr class="tdbg">
            <td height="22" bgcolor="#C0C0C0" align=right><strong>所属单位：</strong></td>
            <td bgcolor="#E3E3E3">
			<%set rsdanwei=conn.execute("select * from danwei where id="&danwei_id&"")%>
					<%=rsdanwei("danwei_name")%> <input name="danwei_id"  id="danwei_id" type="hidden"value=<%=rsdanwei("id")%>>
            </td>
          </tr>
          <tr class="tdbg"> 
            <td width="126" height="22" bgcolor="#C0C0C0" align=right><strong>项目名称：</strong></td>
            <td bgcolor="#E3E3E3"><input name="xiangmu_name" type="text" size="20" maxlength="30"></td>
          </tr>
          <tr class="tdbg"> 
            <td height="22" align="center" bgcolor="#C0C0C0">&nbsp; </td>
            <td height="22" align="center" bgcolor="#E3E3E3"><div align="left"
>
                <input name="Action" type="hidden" id="Action3" value="Add">
                <input name="Add" type="submit" value=" 添 加 ">
              </div></td>
          </tr>
        </table>
			</form>
		</td>
	</tr>
</table>
<BR>
<%htmlend%>
<%
end if
call CloseConn()
%>