📄 main_add_product.asp
字号:
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="65001"%>
<!--#include file="admin_common.asp"-->
<!--#include file="../script/formatString.asp"-->
<!--#include file="../script/trimFunction.asp"-->
<%
if(Request.Form("addPro")=="Thêm")
{
var oRs=Server.CreateObject("ADODB.Recordset");
var pCode=trim_str(String(Request.Form("pcode")));
var pType=parseInt(Request.Form("ptype"));
var pName=trim_str(FormatString(String(Request.Form("pname"))));
var pCompany=trim_str(FormatString(String(Request.Form("pcompany"))));
var pImage=trim_str(String(Request.Form("anhnho")));
var pPrice=parseFloat(Request.Form("pprice"));
var pWarranty=parseInt(Request.Form("pwarranty"));
var pDescription=FormatString(String(Request.Form("pdescription")));
var pStatus=Request.Form("status");
var pNew=Request.Form("new");
var pBest=Request.Form("best");
if(pNew!=1){pNew=0;}
if(pBest!=1){pBest=0;}
if(pImage==""){pImage="images/Products/noimage.gif";}
var strSQL="Select PID From tblProduct Where PID=" + "'" + pCode + "'";
oRs.Open(strSQL,oConn,3,1);
if((!oRs.BOF)&&(!oRs.EOF))
{
Response.Redirect("admin_done.asp?mess=Mã hàng đã tồn tại. Hãy nhập lại!!!&gourl=javascript:history.back()");
}
else
{
var strSQL_pro;
strSQL_pro="Execute sp_addPro 'add', '" + pCode + "', N'";
strSQL_pro+= pName + "', ";
strSQL_pro+= pPrice + ", ";
strSQL_pro+= pWarranty + ", N'";
strSQL_pro+= pDescription + "', '";
strSQL_pro+= pImage + "', N'";
strSQL_pro+= pCompany + "', ";
strSQL_pro+= pStatus + ", ";
strSQL_pro+= pBest + ", ";
strSQL_pro+= pNew + ", ";
strSQL_pro+= pType + ", ''";
oConn.Execute(strSQL_pro);
Response.Redirect("admin_done.asp?mess=Sản phẩm đã được thêm vào CSDL!!!&gourl=main_Add_Product.asp");
}
oRs.Close();
}
%>
<html>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Add Product</title>
<script src="lib/checkPro.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">
<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 SẢN PHẨM MỚI</font></strong>
</td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<form name="frmAddProduct" action="main_Add_Product.asp" method="post" onsubmit="javascript:return checkF(this)">
<tr class="add_new">
<td width="16%" align="right" valign="middle"> </td>
<td colspan="2" align="left" valign="top"> </td>
</tr>
<tr class="add_new">
<td align="right" valign="middle" style="padding-bottom:15px; ">Loại sản phẩm</td>
<td colspan="2" align="left" valign="top" style="padding-bottom:15px; ">
<select name="ptype" size="1" class="textbox">
<option value="0" selected>--- Chọn loại sản phẩm ---</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>
<tr class="add_new">
<td align="right" valign="middle" style="padding-bottom:15px; ">Mã sản phẩm</td>
<td colspan="2" align="left" valign="top"><input name="pcode" type="text" class="textbox" size="20"></td>
</tr>
<tr class="add_new">
<td align="right" valign="middle">Tên sản phẩm</td>
<td colspan="2" align="left" valign="top"><input name="pname" type="text" class="textbox" size="50"></td>
</tr>
<tr class="add_new">
<td align="right" valign="middle"> </td>
<td colspan="2" align="left" valign="top"> </td>
</tr>
<tr class="add_new">
<td align="right" valign="middle">Hãng sản xuất</td>
<td colspan="2" align="left" valign="top"><input name="pcompany" type="text" class="textbox" size="40"></td>
</tr>
<tr class="add_new">
<td align="right" valign="middle"> </td>
<td colspan="2" align="left" valign="top"> </td>
</tr>
<tr class="add_new">
<td align="right" valign="middle">Ảnh</td>
<td colspan="2" align="left" valign="top">
<input name="anhnho" type="text" class="textbox" size="57">
[<a href="JavaScript:openWindow2('admin_upload.asp?dir=Products&targetis=anhnho')">Upload</a>]
</td>
</tr>
<tr class="add_new">
<td align="right" valign="middle"> </td>
<td colspan="2" align="left" valign="top"> </td>
</tr>
<tr class="add_new">
<td align="right" valign="middle">Giá</td>
<td colspan="2" align="left" valign="top"><input name="pprice" type="text" class="textbox" size="12" style="text-align:right ">
<font color="#FF0000"><strong>USD</strong></font>
</td>
</tr>
<tr class="add_new">
<td align="right" valign="middle"> </td>
<td colspan="2" align="left" valign="top"> </td>
</tr>
<tr>
<td align="right" valign="middle" class="add_new">Thời gian bảo hành</td>
<td colspan="2" align="left" valign="top"><input name="pwarranty" type="text" class="textbox" size="8" style="text-align:right ">
<span style="font-family:arial, tahoma, verdana; font-size:12px ">(Tháng)</span></td>
</tr>
<tr class="add_new">
<td align="right" valign="middle"> </td>
<td colspan="2" align="left" valign="top"> </td>
</tr>
<tr class="add_new">
<td align="right" valign="top">Miêu tả</td>
<td colspan="2" align="left" valign="middle" nowrap><textarea name="pdescription" cols="65" rows="5" class="textbox"></textarea>
</td>
</tr>
<tr class="add_new">
<td align="right" valign="middle"> </td>
<td colspan="2" align="left" valign="top"> </td>
</tr>
<tr>
<td align="right" valign="middle" class="add_new">Tình trạng </td>
<td colspan="2" align="left" valign="top"><input name="status" type="radio" value="1" checked>
<span style="font-family:arial, tahoma, verdana; font-size:12px ">Còn hàng</span>
<input name="status" type="radio" value="0">
<span style="font-family:arial, tahoma, verdana; font-size:12px ">Hết hàng</span></td>
</tr>
<tr class="add_new">
<td align="right" valign="middle"> </td>
<td colspan="2" align="left" valign="top"> </td>
</tr>
<tr>
<td align="right" valign="middle" class="add_new">Tùy chọn thêm</td>
<td colspan="2" align="left" valign="top">
<input name="new" type="checkbox" value="1"><span style="font-family:arial, tahoma, verdana; font-size:12px ">Sản phẩm mới</span>
<input name="best" type="checkbox" value="1"><span style="font-family:arial, tahoma, verdana; font-size:12px ">Sản phẩm bán chạy</span>
</td>
</tr>
<tr class="add_new">
<td align="right" valign="middle"> </td>
<td colspan="2" align="left" valign="top"> </td>
</tr>
<tr class="add_new">
<td align="right" valign="middle"> </td>
<td colspan="2" align="left" valign="top"> </td>
</tr>
<tr class="add_new">
<td align="right" valign="middle"> </td>
<td colspan="2" align="left" valign="top"><input type="submit" name="addPro" value="Thêm">
<input type="reset" name="Reset" value="Xóa">
</td>
</tr>
</form>
</table></td>
</tr>
</table></td>
</tr>
</table>
</td>
</tr>
</table></td>
</tr>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -