📄 main_add_category.asp
字号:
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="65001"%>
<!--#include file="admin_common.asp"-->
<!--#include file="../script/trimFunction.asp"-->
<%
var oRs=Server.CreateObject("ADODB.Recordset");
if(Request.Form("b_addCat")=="Thêm")
{
var strSQL_cat;
var catName=trim_str(String(Request.Form("catName")));
var strSQL="Select Distinct CatName From vwSubCat Where CatName=" + "'" + catName + "'";
oRs.Open(strSQL,oConn,3,1);
if((!oRs.EOF)&&(!oRs.BOF))
{
Response.Redirect("admin_done.asp?mess=Nhóm hàng đã tồn tại. Hãy nhập lại!!!&gourl=javascript:history.back()");
}
else
{
var strSQL_cat="Execute sp_addSubCat N'" + catName + "', '', 'add', '', '', '', ''";
oConn.Execute(strSQL_cat);
Response.Redirect("admin_done.asp?mess=Nhóm hàng đã được thêm vào CSDL!!!&gourl=main_Add_Category.asp");
}
oRs.Close();
}
else if(Request.Form("b_addSub")=="Thêm")
{
var subName=trim_str(String(Request.Form("subName")));
var system=Request.Form("system");
var intCat=Request.Form("listCat");
var strSQL="Select Distinct SubName, SCatID From vwSubCat Where SubName=" + "'" + subName + "'" + " AND SCatID=" + intCat;
oRs.Open(strSQL,oConn,3,1);
if(system!=1){system=0;}
if((!oRs.EOF)&&(!oRs.BOF))
{
Response.Redirect("admin_done.asp?mess=Loại hàng đã tồn tại. Hãy nhập lại!!!&gourl=javascript:history.back()");
}
else
{
var strSQL_sub="Execute sp_addSubCat N'" + subName + "', " + intCat + ", 'add', 'SUB', '', '', " + system;
oConn.Execute(strSQL_sub);
Response.Redirect("admin_done.asp?mess=Loại hàng đã được thêm vào CSDL!!!&gourl=main_Add_Category.asp");
}
oRs.Close();
}
%>
<html>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Add Category</title>
<script src="lib/checkSubCat.js"></script>
<body topmargin="0" rightmargin="0" leftmargin="0" bottommargin="0">
<div align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="0" background="images/menu_left_bg.gif">
<tr>
<td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr align="left" valign="top">
<td width="160" background="images/menu_left_bg.gif" style="background-repeat:repeat "><!--#include file="lib/inc_menuleft.asp"--></td>
<td align="left" valign="top" bgcolor="#FFFFFF">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<form name="frmAddCat" method="post" action="main_Add_Category.asp">
<tr>
<td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" valign="top" bgcolor="#004182" style="padding-top:5px; padding-bottom:10px; ">
<strong><font color="#FFFFFF" face="arial, tahoma, verdana"; size="5">THÊM LOẠI SẢN PHẨM</font></strong>
</td>
</tr>
</table></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="7%"> </td>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr bgcolor="#000099">
<td width="40%" align="left" valign="middle" bgcolor="#000099"><span style="font-family:arial, tahoma, verdana;
font-size:13px; font-weight:600; color:#FFFFFF; ">>>>
Thêm nhóm hàng mới</span></td>
<td width="60%"> </td>
</tr>
<tr style="padding-top:16px; ">
<td align="right" valign="top">
<span style="font-family:arial, tahoma, verdana; font-weight:600; font-size:12px; ">Tên nhóm hàng mới:</span>
</td>
<td align="left" valign="top" style="padding-left:15px;"><input name="catName" type="text" class="textbox" size="42"></td>
</tr>
<tr valign="bottom" style="padding-top:16px; ">
<td align="right"><input name="b_addCat" type="submit" value="Thêm" onClick="return checkFrmCat();"></td>
<td align="left" style="padding-left:15px; "><input type="reset" name="Reset" value="Xóa"></td>
</tr>
<tr valign="bottom">
<td height="10" colspan="2" align="right"></td>
</tr>
</table></td>
<td width="5%"></td>
</tr>
<tr>
<td width="7%"></td>
<td></td>
<td width="7%"></td>
</tr>
<tr>
<td width="7%"></td>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr bgcolor="#0066CC">
<td width="40%" align="left" valign="middle" bgcolor="#0066CC"><span style="font-family:arial, tahoma, verdana;
font-size:13px; font-weight:600; color:#FFFFFF; ">>>>
Thêm loại sản phẩm mới</span></td>
<td width="60%"> </td>
</tr>
<tr style="padding-top:16px; ">
<td align="right" valign="top">
<span style="font-family:arial, tahoma, verdana; font-weight:600; font-size:12px; ">Tên loại sản phẩm mới:</span>
</td>
<td align="left" valign="top" style="padding-left:15px;"><input name="subName" type="text" class="textbox" size="42"></td>
</tr>
<tr style="padding-top:16px; ">
<td align="right" valign="top">
<span style="font-family:arial, tahoma, verdana; font-weight:600; font-size:12px; ">Trong nhóm:</span>
</td>
<td align="left" valign="top" style="padding-left:15px; ">
<select name="listCat" class="textbox" style="width:223px; ">
<option value="0">------- Chọn nhóm sản phẩm -------</option>
<%
oRs=Server.CreateObject("ADODB.Recordset");
var SQLcat="Select Distinct CatID, CatName, CatOrder From vwSubCat Where CatDelete=1 Order by CatOrder ASC";
oRs.Open(SQLcat,oConn,3,1);
while((!oRs.BOF)&&(!oRs.EOF))
{
%>
<option value="<%=oRs.Fields('CatID')%>"> - <%=oRs.Fields('CatName')%></option>
<%
oRs.MoveNext();
}
oRs.Close();
%>
</select>
</td>
</tr>
<tr style="padding-top:16px; ">
<td align="right" valign="top"><span style="font-family:arial, tahoma, verdana; font-weight:600; font-size:12px; ">Xây dựng hệ thống:</span></td>
<td align="left" valign="top" style="padding-left:15px; "><input type="checkbox" name="system" value="1"></td>
</tr>
<tr valign="bottom" style="padding-top:16px; padding-bottom:16px; ">
<td align="right"><input name="b_addSub" type="submit" value="Thêm" onClick="return checkFrmSub();"></td>
<td align="left" style="padding-left:15px; "><input type="reset" name="Reset" value="Xóa"></td>
</tr>
</table></td>
<td width="5%"> </td>
</tr>
<tr>
<td> </td>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr bgcolor="#0099FF">
<td width="40%" align="left" valign="middle" bgcolor="#0099FF"><span style="font-family:arial, tahoma, verdana;
font-size:13px; font-weight:600; color:#FFFFFF; ">>>>
Kết quả</span></td>
<td width="60%"> </td>
</tr>
<tr style="padding-top:16px; ">
<td width="40%" align="right" valign="top">
<span style="font-family:arial, tahoma, verdana; font-weight:600; font-size:12px; ">Chi tiết nhóm sản phẩm</span>
</td>
<td align="left" valign="top" style="padding-left:15px; ">
<select name="list" size="1" class="textbox" id="list" onChange="change();">
<option value="0"> - Tất cả</option>
<%
var oRsCat=Server.CreateObject("ADODB.Recordset");
var SQLcat="Select Distinct CatID, CatName, CatOrder From vwSubCat Where CatDelete=1 Order by CatOrder ASC";
oRsCat.Open(SQLcat,oConn,3,1);
while((!oRsCat.BOF)&&(!oRsCat.EOF))
{
%>
<optgroup label="<%=oRsCat.Fields("CatName")%>" style="background-color:#006600; color:#FFFFFF;"></optgroup>
<%
var oRsSub=Server.CreateObject("ADODB.Recordset");
var SQLsub="Select SubID, SubName, SOrder From vwSubCat Where SDelete=1 AND SCatID=" + oRsCat.Fields("CatID") + " AND SDelete=1 Order by SOrder ASC";
oRsSub.Open(SQLsub,oConn,3,1);
while((!oRsSub.BOF)&&(!oRsSub.EOF))
{
%>
<option value="<%=oRsSub.Fields("SubID")%>" > + <%=oRsSub.Fields("SubName")%></option>
<%
oRsSub.MoveNext();
}
oRsSub.Close();
%>
<%
oRsCat.MoveNext();
}
oRsCat.Close();
%>
</select>
</td>
</tr>
</table></td>
<td width="5%"> </td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</form>
</table>
</td>
</tr>
</table></td>
</tr>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -