cost_detail_del.asp

财务预算管理 财务支出

<!--#include file="sysconfig.asp"-->
<!--#include file="Inc/Function.asp"-->
<!--#include file="Inc/Config.asp"-->
<%
dim id,Action,sqlDel,rsDel,FoundErr,ErrMsg

id=trim(request("id"))
Action=Trim(Request("Action"))
FoundErr=False

if id="" or Action<>"Del" then
	FoundErr=True
	ErrMsg=ErrMsg & "<br><li>参数不足！</li>"
end if
if FoundErr=False then
	if instr(id,",")>0 then
		dim idarr,i
		idArr=split(id)
		for i = 0 to ubound(idArr)
			call Del(clng(idarr(i)))
		next
	else
		call Del(clng(id))
	end if
end if
if FoundErr=False then
	call CloseConn()
	response.Redirect "cost_deltail.asp"
else
	call CloseConn()
	call WriteErrMsg()
end if

sub Del(ID)
	PurviewChecked=False
	sqlDel="select * from cost_deltail where id=" & CLng(ID)
	Set rsDel= Server.CreateObject("ADODB.Recordset")
	rsDel.open sqlDel,conn,1,3
	if FoundErr=False then
		'rsDel.delete
		rsdel("cost_delete")=1
		rsDel.update
		set rsDel=nothing
		'conn.execute "delete from jh_deletewhere id=" & CLng(ID)
	end if
end sub
%>