tz.asp

来自「绿叶oa系统v6.04试用版(2007-4-29) 带视频演示」· ASP 代码 · 共 30 行

<!--#include file="../../../Connections/oavbsconn.asp" -->
<%
set Command1fffffffffff = Server.CreateObject("ADODB.Command")
Command1fffffffffff.ActiveConnection = MM_oavbsconn_STRING
Command1fffffffffff.CommandText = "DELETE FROM infoall  WHERE (信息属性='短消息' or 信息属性='短消息回复') and 是否标记为删除='是' and 是否标记为接收人删除='是' "
Command1fffffffffff.CommandType = 1
Command1fffffffffff.CommandTimeout = 0
Command1fffffffffff.Prepared = true
Command1fffffffffff.Execute()
%>
<%
set delfilesdfg = Server.CreateObject("ADODB.Command")
delfilesdfg.ActiveConnection = MM_oavbsconn_STRING
delfilesdfg.CommandText = "DELETE FROM 文件信息  WHERE 接收人是否删除='是' and 上传人是否删除='是' "
delfilesdfg.CommandType = 1
delfilesdfg.CommandTimeout = 0
delfilesdfg.Prepared = true
delfilesdfg.Execute()
%>
<%
set deyuedumindfghfg = Server.CreateObject("ADODB.Command")
deyuedumindfghfg.ActiveConnection = MM_oavbsconn_STRING
deyuedumindfghfg.CommandText = "DELETE FROM 文件阅读明细wtrhy6wtrgvr467htyhgt  WHERE 接收人是否删除='是' and 发送人是否删除='是' "
deyuedumindfghfg.CommandType = 1
deyuedumindfghfg.CommandTimeout = 0
deyuedumindfghfg.Prepared = true
deyuedumindfghfg.Execute()
%>