📄 main_addbg.asp

📁 Computer SHOP+DATABASE
💻 ASP
字号:
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="65001"%>
<!--#include file="admin_common.asp"-->

<%
		var strTitle;
		var strFile;
		var type = Request.QueryString("type")
		var id = Request.QueryString("id");

		var txtTitle = String(Request.Form("bgTitle"));
		var txtFile = String(Request.Form("bgFile"));
		
		if(type == 'edit')
		{
			var rsBG = Server.CreateObject("ADODB.Recordset");
			var strSQL = "Select * From vwDownload Where id=" + parseInt(id);
			rsBG.Open(strSQL,oConn,3,1); 
			strTitle = rsBG.Fields("title");
			strFile = rsBG.Fields("url");
		}
		
		if(Request.Form("btnAdd") == "Thêm")
		{
			var strSQL_add; 
			strSQL_add = "Execute sp_addBG 'add', N'" + txtTitle + "', '" + txtFile + "', ''";
			oConn.Execute(strSQL_add);
			Response.Redirect("admin_done.asp?mess=Báo giá đã được thêm vào CSDL!!!" + "&gourl=main_Download.asp");
		}
		
		if(Request.Form("btnAdd") == "Cập nhật")
		{
				var strSQL_edit; 
				strSQL_edit = "Execute sp_addBG 'edit', N'" + txtTitle + "', '" + txtFile + "', " + parseInt(Request.Form("hdID"));
				oConn.Execute(strSQL_edit);
				Response.Redirect("admin_done.asp?mess=Báo giá đã được sửa và lưu vào CSDL!!!" + "&gourl=main_Download.asp");
		}
%>

<html>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Add BG</title>
<script>
	function checkBG(obj)
	{
		if(obj.bgTitle.value=="")
		{
			alert("Bạn chưa nhập tiêu đề của báo giá");
			obj.bgTitle.focus();
			return false;
		}
		if(obj.bgFile.value=="")
		{
			alert("Bạn chưa nhập đường dẫn File");
			obj.bgFile.focus();
			return false;
		}
	return true;	
	}
</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>
	<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"><%if(type=='new'){Response.Write('THÊM');}else{Response.Write('SỬA');}%> BÁO GIÁ</font></strong>
			</td>
      </tr>
      <tr>
        <td height="45">&nbsp;</td>
      </tr>
      <tr>
        <td>
		<form name="frmAddProduct" action="main_addBG.asp" method="post" onSubmit="return checkBG(this);">
		<table width="100%"  border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td width="3" align="left">&nbsp;</td>
            <td align="right" valign="top" class="list"><strong>Tiêu đề</strong></td>
            <td width="494" style="padding-left:10px; ">
			<input name="bgTitle" type="text" value="<%=strTitle%>" class="textbox" size="40">
			</td>
            <td width="4">&nbsp;</td>
          </tr>
          <tr>
            <td width="3" align="left">&nbsp;</td>
            <td height="40" align="right" valign="top">&nbsp;</td>
            <td height="40">&nbsp;</td>
            <td width="4">&nbsp;</td>
          </tr>
          <tr>
            <td width="3" align="left">&nbsp;</td>
            <td align="right" valign="top" class="list"><strong>File báo giá</strong></td>
            <td style="padding-left:10px; ">
			<input name="bgFile" type="text" value="<%=strFile%>" class="textbox" size="40">&nbsp;
			[<a href="JavaScript:openWindow2('admin_upload.asp?dir=downloads&targetis=bgFile')">Upload</a>]
			<%if(Request.QueryString("type")=='edit'){%><input type="hidden" name="hdID" value="<%=id%>"><%}%>
			</td>
            <td width="4">&nbsp;</td>
          </tr>
		  <tr>
		    <td align="left">&nbsp;</td>
		    <td align="right" valign="top" class="list">&nbsp;</td>
		    <td style="padding-left:10px; ">&nbsp;</td>
		    <td>&nbsp;</td>
		    </tr>
		  <tr>
		    <td align="left">&nbsp;</td>
		    <td align="right" valign="top" class="list"><input name="btnAdd" type="submit" value="<%if(Request.QueryString('type')=='edit'){Response.Write('Cập nhật')}else{Response.Write('Thêm')}%>"></td>
		    <td style="padding-left:10px; "><input type="reset" name="Reset" value="Xóa"></td>
		    <td>&nbsp;</td>
		    </tr>
		  <tr><td>&nbsp;</td></tr>
        </table>
		</form>
		</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 + -