28,390
社区成员
发帖
与我相关
我的任务
分享
conn.BeginTrans
set rs=server.createobject("adodb.recordset")
sql="select * from sys_user where userid="&id
rs.open sql,conn,1,3
rs("userkefabu")=rs("userkefabu")+fabushu
rs("kebangdianpu")=rs("kebangdianpu")+dianpushu
username=rs("username")
rs.update
rs.close
set rs=nothing
conn.execute("insert into admin_jilu (caozuozhe, username, caozuo, shijian) VALUES ('"&session("aid")&"', '"&username&"', '增加会员发布数"&fabushu&"个,增加会员可绑定店铺数"&dianpushu&"个', 2)")
if err.number =0 then
conn.CommitTrans
else
conn.RollbackTrans
err.clear
end if