?? addclass.asp
字號:
<!--#include file="../include/conn.asp"-->
<%
If Session("flag")<>1 Then
Response.Write "<script language=javascript>window.history.back();</script>"
Response.End()
End If
TypeName1=trim(request("TypeName"))
if len(trim(request("TypeName")))<=0 or isEmpty(trim(request("TypeName"))) then
%>
<script language="javascript">
alert("請填寫類別名稱!");
window.location.href="goodsclass.asp";
</script>
<%
response.End()
else
if instr(TypeName1,"'")>0 then
%>
<script language="javascript">
alert("請正確填寫類別名稱!");
window.close();
</script>
<%
else
set rs=server.CreateObject("adodb.recordset")
strsql="select TypeName from tb_MedicineType where TypeName='"&TypeName1&"'"
rs.open strsql,conn,3,3
if not rs.eof then
%>
<script language="javascript">
alert("已存在此類別名稱!");
window.location.href="/manage/goods/goodsclass.asp";
</script>
<%
response.End()
rs.close
else
'rs.addnew
'rs("TypeName")=TypeName1
'rs.update
strsql="insert into tb_MedicineType (TypeName) values ('"&TypeName1&"')"
conn.execute(strsql)
%>
<script language="javascript">
alert("添加類別成功!");
window.location.href="/manage/goods/goodsclass.asp";
</script>
<%
'rs.close
'set rs=nothing
end if
end if
end if
rs.close
set rs=nothing
%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -