📄 main_edit_product.asp
字号:
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="65001"%>
<!--#include file="admin_common.asp"-->
<!--#include file="../script/formatString.asp"-->
<!--#include file="../script/trimFunction.asp"-->
<%
var pCode=Request.QueryString("p_code");
if(Request.Form("editPro")=="Cập nhật")
{
var pCode=trim_str(String(Request.Form("pcode")));
var pCodeOld=trim_str(String(Request.Form("pcodeOld")));
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 oRsAdd=Server.CreateObject("ADODB.Recordset");
var strSQL="Select PID From vwProduct Where PID=" + "'" + pCode + "'";
oRsAdd.Open(strSQL,oConn,3,1);
if((!oRsAdd.BOF)&&(!oRsAdd.EOF)&&(pCode!=pCodeOld))
{
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 '', '" + 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 + ", '";
strSQL_pro+= pCodeOld + "'";
oConn.Execute(strSQL_pro);
Response.Redirect("admin_done.asp?mess=Sản phẩm đã được sửa và lưu vào CSDL!!!&gourl=main_List_Product.asp?list=" + parseInt(Request.Form('list')) + "|page=" + parseInt(Request.Form('page')) + "|ds=" + String(Request.Form('ds')) + "|txtSearch=" + String(Request('txtSearch')));
}
}
var oRs=Server.CreateObject("ADODB.Recordset");
var strSQL="Select PID, PImage, PName, PPrice, PWarranty, PDescription, PStatus, PBest, PNew, PCompany, PSubCatID From vwProduct Where PDelete=1 AND PID=" + "'" + pCode + "'";
oRs.Open(strSQL,oConn,3,1);
%>
<html>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Edit 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">SỬA THÔNG TIN SẢN PHẨM</font></strong>
</td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<form name="frmAddProduct" action="main_Edit_Product.asp" method="post" onsubmit="javascript:return checkF(this)">
<tr class="add_new">
<td width="16%" align="right" valign="middle"> </td>
<td width="84%" align="left" valign="top"> </td>
</tr>
<tr class="add_new">
<td align="right" valign="middle">Loại sản phẩm</td>
<td align="left" valign="top">
<select name="ptype" size="1" class="textbox">
<option value=0>--- 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))
{
%>
<option value=0 style="background-color:#006600; color:#FFFFFF;">- <%=oRsCat.Fields("CatName")%></option>
<%
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")%>" <%if(parseInt(oRs("PSubCatID"))==parseInt(oRsSub("SubID"))){%>selected<%}%>> + <%=oRsSub.Fields("SubName")%></option>
<%
oRsSub.MoveNext();
}
oRsSub.Close();
%>
<%
oRsCat.MoveNext();
}
oRsCat.Close();
%>
</select><input type="hidden" name="page" value="<%=Request.QueryString('page')%>" size="20"><input type="hidden" value="<%=Request.QueryString('list')%>" name="list" size="20">
<input type="hidden" value="<%=Request.QueryString('ds')%>" name="ds" size="20">
<input type="hidden" value="<%=Request.QueryString('txtSearch')%>" name="txtSearch" size="20"></td>
</tr>
<tr class="add_new">
<td align="right" valign="middle"> </td>
<td align="left" valign="top"> </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" value="<%=String((oRs.Fields('PID')))%>"><input name="pcodeOld" type="hidden" class="textbox" size="20" value="<%=oRs.Fields("PID")%>"></td>
</tr>
<tr class="add_new">
<td align="right" valign="middle"> </td>
<td align="left" valign="top"> </td>
</tr>
<tr class="add_new">
<td align="right" valign="middle">Tên sản phẩm</td>
<td align="left" valign="top"><input name="pname" type="text" class="textbox" size="50" value="<%=deFormatString(String((oRs.Fields('PName'))))%>">
</td>
</tr>
<tr class="add_new">
<td align="right" valign="middle"> </td>
<td align="left" valign="top"> </td>
</tr>
<tr class="add_new">
<td align="right" valign="middle">Hãng sản xuất</td>
<td align="left" valign="top"><input name="pcompany" type="text" class="textbox" value="<%=deFormatString(String((oRs.Fields('PCompany'))))%>" size="40"></td>
</tr>
<tr class="add_new">
<td align="right" valign="middle"> </td>
<td 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" value="<%=oRs.Fields("PImage")%>">
[<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 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" value="<%=oRs.Fields("PPrice")%>" 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 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" value="<%=oRs.Fields("PWarranty")%>" 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 align="left" valign="top"> </td>
</tr>
<tr class="add_new">
<td align="right" valign="top">Miêu tả</td>
<td align="left" valign="middle" nowrap><textarea name="pdescription" cols="65" rows="5" class="textbox"><%=deFormatString(String((oRs.Fields("PDescription"))))%></textarea>
</td>
</tr>
<tr class="add_new">
<td align="right" valign="middle"> </td>
<td align="left" valign="top"> </td>
</tr>
<tr>
<td align="right" valign="middle" class="add_new">Tình trạng </td>
<td align="left" valign="top"><input name="status" type="radio" value="1" <%if (oRs.Fields("PStatus")==1){%> checked <%}%>>
<span style="font-family:arial, tahoma, verdana; font-size:12px ">Còn hàng</span>
<input name="status" type="radio" value="0" <%if (oRs.Fields("PStatus")==0){%> checked <%}%>>
<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 align="left" valign="top"> </td>
</tr>
<tr>
<td align="right" valign="middle" class="add_new">Tùy chọn thêm</td>
<td align="left" valign="top">
<input name="new" value="1" type="checkbox" <%if (oRs.Fields("PNew")==1){%> checked <%}%>>
<span style="font-family:arial, tahoma, verdana; font-size:12px ">Sản phẩm mới</span> <input name="best" type="checkbox" value="1" <%if (oRs.Fields("PBest")==1){%> checked <%}%>>
<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 align="left" valign="top"> </td>
</tr>
<tr class="add_new">
<td align="right" valign="middle"> </td>
<td align="left" valign="top"><input type="submit" name="editPro" value="Cập nhật">
<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 + -