📄 main_edit_category.asp
字号:
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="65001"%>
<!--#include file="admin_common.asp"-->
<!--#include file="../script/trimFunction.asp"-->
<%
var rsCat=Server.CreateObject("ADODB.Recordset");
var catID=parseInt(Request.QueryString("catID"));
var subID=parseInt(Request.QueryString("subID"));
var field=String(Request.QueryString("field"));
if(!isNaN(catID))
{
strSQL="Select Distinct CatID, CatName, CatOrder From vwSubCat Where CatDelete=1 AND CatID=" + catID + " Order By CatOrder";
}
else
{
strSQL="Select Distinct CatID, CatName, CatOrder From vwSubCat Where CatDelete=1 Order By CatOrder";
}
rsCat.Open(strSQL,oConn,3,1);
if(Request.Form('editCat')=="Cập nhật")
{
var catName=trim_str(String(Request.Form('txtCat')));
var hd_catName=trim_str(String(Request.Form('hd_txtCat')));
var hd_catID=parseInt(Request.Form("hd_catID"));
var rsAdd=Server.CreateObject("ADODB.Recordset");
var strSQLcat="Select Distinct CatName From vwSubCat Where CatDelete=1 AND CatName=" + "'" + catName + "'";
rsAdd.Open(strSQLcat,oConn,3,1);
if((!rsAdd.BOF)&&(!rsAdd.EOF)&&(catName!=hd_catName))
{
Response.Redirect("admin_done.asp?mess=Tên nhóm hàng đã tồn tại! Hãy nhập lại!!!&gourl=javascript:history.back()");
}
else
{
var strAdd="Execute sp_addSubCat N'" + catName + "', '', '', '', " + hd_catID + ", '', ''";
oConn.Execute(strAdd);
Response.Redirect("admin_done.asp?mess=Nhóm hàng đã được sửa và lưu vào CSDL!!!&gourl=main_List_Category.asp");
}
}
else if(Request.Form('editSub')=="Cập nhật")
{
var subName=trim_str(String(Request.Form('txtSub')));
var system=Request.Form("system");
var hd_subName=trim_str(String(Request.Form('hd_txtSub')));
var hd_subID=parseInt(Request.Form("hd_subID"));
var nhomhang=parseInt(Request.Form('listCat'));
if(system!=1){system=0;}
var rsAdd=Server.CreateObject("ADODB.Recordset");
var strSQLsub="Select Distinct SubName From vwSubCat Where SDelete=1 AND SubName=" + "'" + subName + "'";
rsAdd.Open(strSQLsub,oConn,3,1);
if((!rsAdd.BOF)&&(!rsAdd.EOF)&&(subName!=hd_subName))
{
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 strAdd="Execute sp_addSubCat N'" + subName + "', " + nhomhang + ", '', 'SUB', '', " + hd_subID + ", " + system;
oConn.Execute(strAdd);
Response.Redirect("admin_done.asp?mess=Loại hàng đã được sửa và lưu vào CSDL!!!&gourl=main_List_Category.asp");
}
}
%>
<html>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Edit 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="frmEditCat" method="post" action="main_Edit_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">SỬA 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">
<%if(field=="CAT"){%>
<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"><span style="font-family:arial, tahoma, verdana;
font-size:13px; font-weight:600; color:#FFFFFF; ">>>>
Sủa nhóm sản phẩm</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:</span>
</td>
<td align="left" valign="top" style="padding-left:15px;"><input name="txtCat" type="text" value="<%=rsCat('CatName')%>" size="42">
<input type="hidden" name="hd_txtCat" value="<%=rsCat('CatName')%>">
<input type="hidden" name="hd_catID" value="<%=rsCat('CatID')%>">
</td>
</tr>
<tr valign="bottom" style="padding-top:16px; ">
<td align="right"><input name="editCat" type="submit" value="Cập nhật" onClick="return checkFrmCat();"></td>
<td align="left" style="padding-left:15px; "><input type="reset" name="Reset" value=" Xóa "></td>
</tr>
</table></td>
<td width="7%"> </td>
</tr>
<tr>
<td width="7%"> </td>
<td> </td>
<td width="7%"> </td>
</tr>
<%
}
else
{
strSQL="Select Distinct SubID, SubName, SCatID, SSystem From vwSubCat Where SDelete=1 AND SubID=" + subID;
var rsSub=oConn.Execute(strSQL);
%>
<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"><span style="font-family:arial, tahoma, verdana;
font-size:13px; font-weight:600; color:#FFFFFF; ">>>>
Sửa loại sản phẩm</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:</span>
</td>
<td align="left" valign="top" style="padding-left:15px;"><input name="txtSub" type="text" size="42" value="<%=rsSub('SubName')%>">
<input name="hd_txtSub" type="hidden" size="42" value="<%=rsSub('SubName')%>">
<input type="hidden" name="hd_subID" value="<%=rsSub('SubID')%>">
</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>
<%
while((!rsCat.BOF)&&(!rsCat.EOF))
{
%>
<option value="<%=rsCat('CatID')%>" <%if(parseInt(rsSub('SCatID'))==parseInt(rsCat('CatID'))){%> selected <%}%>> - <%=rsCat('CatName')%></option>
<%
rsCat.MoveNext();
}
rsCat.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" <%if(rsSub.Fields('SSystem')==1){%> checked <%}%> name="system" value="1"></td>
</tr>
<tr valign="bottom" style="padding-top:16px; padding-bottom:16px; ">
<td align="right"><input name="editSub" type="submit" value="Cập nhật" 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="7%"> </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 + -