<%
select case request("action")
case "add"
call SaveAdd()
case "modify"
call SaveModify()
case "del"
call delCate()
case "edit"
isEdit=True
call myform(isEdit)
case else
isEdit=False
call myform(isEdit)
end select
sub SaveAdd
class1=request.Form("d_position1")
pinming=request.Form("pinming")
names=Split(pinming,"|")
pinming=names(0)
guige=names(1)
unit=names(2)
set rs1=server.createobject("adodb.recordset")
if guige="" then
sql1="select * from store where pinming='"&pinming&"'"
else
sql1="select * from store where pinming='"&pinming&"' and guige='"&guige&"'"
end if
rs1.open sql1,conn,1,3
if not rs1.eof and not rs1.bof then
rs1("number")=rs1("number")+request.Form("use_num")
rs1("price") = request.Form("use_price")
else
rs1.addnew
rs1("class") = trim(request.Form("d_position1"))
rs1("Unit") = unit
rs1("guige") = guige
rs1("pinming") = pinming
rs1("number")=request.Form("use_num")
rs1("price") = request.Form("use_price")
end if
rs1.update
rs1.close
set rs1=nothing
set rs=server.createobject("adodb.recordset")
sql="select * from in_store"
rs.open sql,conn,1,3
rs.addnew
rs("class") = trim(request.Form("d_position1"))
rs("guige") = guige
rs("pinming") = pinming
rs("uptime") = request.Form("uptime")
rs("end_time") = request.Form("end_time")
rs("Unit") = unit
rs("Supplier") = trim(request.Form("Supplier"))
rs("use_price") = request.Form("use_price")
rs("use_num") = request.Form("use_num")
rs("use_Amount") = request.Form("use_num") * request.Form("use_price")
rs("content") = trim(request.Form("content"))
rs.update
response.Write ""
response.write ""
response.end
rs.close
set rs=nothing
end sub
sub SaveModify
class1=request.Form("d_position1")
pinming=request.Form("pinming")
names=Split(pinming,"|")
pinming=names(0)
guige=names(1)
unit=names(2)
num=names(3)
num0=request.Form("use_num")
num1=num-num0
set rs1=server.createobject("adodb.recordset")
if guige="" then
sql1="select * from store where pinming='"&pinming&"'"
else
sql1="select * from store where pinming='"&pinming&"' and guige='"&guige&"'"
end if
rs1.open sql1,conn,1,3
if not rs1.eof and not rs1.bof then
rs1("number")=rs1("number")-num1
rs1("price") = request.Form("use_price")
end if
rs1.update
rs1.close
set rs1=nothing
set rs=server.createobject("adodb.recordset")
sql="select * from in_store where id="&request.Form("id")
rs.open sql,conn,1,3
rs("class") = trim(request.Form("d_position1"))
rs("guige") = guige
rs("pinming") = pinming
rs("Unit") = unit
rs("uptime") = request.Form("uptime")
rs("Supplier") = trim(request.Form("Supplier"))
rs("use_price") = request.Form("use_price")
rs("use_num") = request.Form("use_num")
rs("end_time") = request.Form("end_time")
rs("use_Amount") = request.Form("use_num") * request.Form("use_price")
rs("content") = trim(request.Form("content"))
rs.update
response.Write ""
response.write ""
response.end
rs.close
set rs=nothing
end sub
sub delCate()
conn.execute("delete from in_store where id in ("&Request.Form("selBigClass")&")")
response.Write ""
response.write ""
response.end
end sub
%> <% sub myform(isEdit) %>