xiangmu_edit.asp

财务预算管理 财务支出

<!--#include file="sysconfig.asp"-->
<!--#include file="Inc/Function_1.asp"-->
<%
'黄华于2008年3月
%>
<%
dim id,Action,rs,Newxiangmu_name,Oldxianmu_name,FoundErr,ErrMsg
id=trim(Request("id"))
Action=trim(Request("Action"))
newxiangmu_name=trim(Request("newxiangmu_name"))
oldxiangmu_name=trim(Request("oldxiangmu_name"))

if id="" then
  response.Redirect("Class.asp")
end if
Set rs=Server.CreateObject("Adodb.RecordSet")
rs.Open "Select * from xiangmu where id=" & id,conn,1,3
if rs.Bof and rs.EOF then
	FoundErr=True
	ErrMsg=ErrMsg & "<br><li>此项目不存在！</li>"
else
	if Action="Modify" then
		if newxiangmu_name="" then
			FoundErr=True
			ErrMsg=ErrMsg & "<br><li>项目名不能为空！</li>"
		end if
		if FoundErr<>True then
			rs("xiangmu_name")=newxiangmu_name
    	rs.update
			rs.Close
	    set rs=Nothing
			if newxiangmu_name<>oldxiangmu_name then
				conn.execute "Update xiangmu set xiangmu_name='" & newxiangmu_name & "'where xiangmu_name='" & oldxiangmu_name & "'"
     	end if		
			call CloseConn()
     		Response.Redirect "Class.asp" 
		end if
	end if
	if FoundErr=True then
		call WriteErrMsg()
	else
%>
<script language="JavaScript" type="text/JavaScript">
function checkBig()
{
  if (document.form1.danwei_name.value=="")
  {
    alert("项目名称不能为空！");
    document.form1.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"> 
      <form name="form1" method="post" action="xiangmu_edit.asp">
			
        <table width="350" border="0" align="center" cellpadding="0" cellspacing="2" class="border">
          <tr class="title"> 
            <td height="25" colspan="2" align="center" bgcolor="#999999"><strong>修改项目名称</strong></td>
          </tr>
          <tr class="tdbg"> 
            <td width="126" bgcolor="#C0C0C0" align=right><strong>所属业务科室：</strong></td>
            <td width="204" bgcolor="#E3E3E3"> <%set rsguikou=conn.execute("select * from guikou where id="&rs("guikou_id")&"")%> <%=rsguikou("guikou_name")%> <input name="id" type="hidden" id="id" value="<%=rs("id")%>"> 
              <input name="oldxiangmu_name" type="hidden" id="oldxiangmu_name" value="<%=rs("danwei_name")%>"> 
            </td>
          </tr>
          <tr class="tdbg"> 
            <td width="126" align=right bgcolor="#C0C0C0"><strong>所属单位：</strong></td>
            <td bgcolor="#E3E3E3">
              <%set rsdanwei=conn.execute("select * from danwei where id="&rs("danwei_id")&"")%>
              <%=rsdanwei("danwei_name")%></td>
          </tr>
          <tr class="tdbg"> 
            <td width="126" bgcolor="#C0C0C0" align=right><strong>项目名称：</strong></td>
            <td bgcolor="#E3E3E3"> <input name="newxiangmu_name" type="text" id="newxiangmu_name" value="<%=rs("xiangmu_name")%>" size="20" maxlength="30"></td>
          </tr>
          <tr class="tdbg"> 
            <td align="center" bgcolor="#C0C0C0">&nbsp;</td>
            <td align="center" bgcolor="#E3E3E3"><div align="left"> 
                <input name="Action" type="hidden" id="Action" value="Modify">
                <input name="Save" type="submit" id="Save" value=" 修 改 ">
              </div></td>
          </tr>
        </table> 
			</form>	
		</td>
	</tr>
</table>
<BR>
<%htmlend%>
<%
	end if
end if
rs.close
set rs=nothing
call CloseConn()
%>