请帮我看看这个页面，红色部份如何改才能保存到ACCess数据库中

时间：2021-02-12 00:51:13
<%

if session("shiwei_username")="" then

%>

<script language="javascript">

top.location.href="../index.asp"

</script>

<%

  response.end

end if

%>

<!-- #include file="../conn2.asp" -->

<!-- #include file="../const.asp" -->

<html>

<head>

<title><%=dianming%> - 产品入库</title>

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

<link href="../style/style.css" rel="stylesheet" type="text/css">

<script language="javascript" type="text/javascript" src="../inc/Public.js"></script>

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>

<style>

body {

    background-color:#FFFFFF;

}

     table{margin: 5px auto 0;}

    .add,.remove{color: blue; text-decoration: underline; cursor: pointer; margin: 0 5px;}

    .i_color_error,.i_model_error{display: none; color: red;}

    .pirce2,.shulian,.ku,.tiaoma{width: 100px;}

    .pic{color: #333333; width: 150px;}

    #i_model_add{background: #FF8000; color: #EEEEEE; padding: 3px 5px; box-shadow: 0px 1px 1px 1px #CCCCCC; border-radius: 3px; cursor: pointer; margin-left: 5px;}

</style>

</HEAD>

<BODY>

<%

if fla1="0" and session("shiwei_id")<>"1" then

%>

<br><center><img src="../images/note.gif" align="absmiddle">&nbsp;<font color="#FF0000">你不具备此权限，请与管理员联系！</font></center>

<%

  response.end

end if

%>

<%

if request("hid1")="ok" then

nowid_login=request("id_login")

nowid_payment=request("id_payment")

set rs_login=conn.execute("select * from login where id="&nowid_login)

nowid_gys=request("id_gys")

nowgys=""

set rs_gys=conn.execute("select * from gys where id="&nowid_gys)

if rs_gys.eof=false then nowgys=rs_gys("company")

set rs_bianhao=conn.execute("select * from buy order by id desc")

if rs_bianhao.eof then

  nowbianhao=1000001

else

  nowbianhao=1000001+rs_bianhao("id")

end if

totalshulian=0

totalprice2=0

for x=1 to maxproduit

nowku=request("ku"&x)

set rs_ku=conn.execute("select * from ku where id="&nowku)

nowhuohao=request("huohao"&x)

nowshulian=request("shulian"&x)

nowprice=request("price"&x)

if nowprice="" then

  nowprice=0

end if

nowprice2=request("price2"&x)

if nowprice2="" then

  nowprice2=0

end if

nowprice3=request("price3"&x)

if nowprice3="" then

  nowprice3=0

end if

ddan=request("ddan")

wuliufee=request("wuliufee")

if nowhuohao<>"单击选择产品" and nowshulian<>"" then

set rs_produit=conn.execute("select * from produit where huohao='"&nowhuohao&"'")

beizhu=rs_produit("beizhu")

price2=rs_produit("price2")

price=rs_produit("price")

price3=rs_produit("price3")

set rs=server.createobject("ADODB.RecordSet")

sql="select * from produit where huohao='"&nowhuohao&"' and id_ku="&nowku

rs.open sql,conn,1,3

if rs.eof then

  rs.addnew

  rs("id_bigclass")=rs_produit("id_bigclass")

  rs("id_smallclass")=rs_produit("id_smallclass")

  rs("title")=rs_produit("title")

  rs("huohao")=rs_produit("huohao")

  rs("tiaoma")=rs_produit("tiaoma")

  rs("id_ku")=nowku

  rs("shulian")=nowshulian

  rs("danwei")=rs_produit("danwei")

  rs("price")=rs_produit("price")

  rs("price2")=nowprice2

  rs("price3")=rs_produit("price3")

  rs("sekuan")=rs_produit("sekuan")

  rs("guige")=rs_produit("guige")

  rs("jingzhong")=rs_produit("jingzhong")

  rs("zhuangxiangshu")=rs_produit("zhuangxiangshu")

  rs("baojin")=rs_produit("baojin")

  rs("class")=rs_produit("class")

  rs("duihuan")=rs_produit("duihuan")

  rs("tichen_type")=rs_produit("tichen_type")

  rs("tichen")=rs_produit("tichen")

  rs("photo")=rs_produit("photo")

  rs("gys")=nowgys

  rs("id_gys")=nowid_gys

  rs("beizhu")=beizhu

else

  rs("shulian")=rs("shulian")+nowshulian

  rs("price2")=nowprice2

end if

rs.update

rs.close

sql="select bigclass from bigclass where id="&rs_produit("id_bigclass")

set rs_bigclass=conn.execute(sql)

sql="select smallclass from smallclass where id="&rs_produit("id_smallclass")

set rs_smallclass=conn.execute(sql)

if rs_smallclass.eof then

  smallclass=""

else

  smallclass=rs_smallclass(0)

end if

totalshulian=totalshulian+nowshulian

totalprice2=totalprice2+nowprice2*nowshulian

ddan=request("ddan")

wuliufee=request("wuliufee")

sql="insert into buy(ddan,wuliufee,id_payment,id_produit,bigclass,smallclass,title,huohao,tiaoma,id_ku,ku,shulian,sekuan,guige,jingzhong,zhuangxiangshu,id_login,login,type,selldate,price,price2,price3,photo,id_gys,gys,bianhao,beizhu) values('"&ddan&"','"&wuliufee&"',"&nowid_payment&","&rs_produit("id")&",'"&rs_bigclass(0)&"','"&smallclass&"','"&rs_produit("title")&"','"&nowhuohao&"','"&rs_produit("tiaoma")&"',"&rs_ku("id")&",'"&rs_ku("ku")&"',"&nowshulian&",'"&rs_produit("sekuan")&"','"&rs_produit("guige")&"','"&rs_produit("jingzhong")&"','"&rs_produit("zhuangxiangshu")&"',"&nowid_login&",'"&rs_login("username")&"',0,#"&date()&"#,'"&rs_produit("price")&"',"&nowprice2&",'"&rs_produit("price3")&"','"&rs_produit("photo")&"',"&nowid_gys&",'"&nowgys&"','"&nowbianhao&"','"&beizhu&"')"

conn.execute(sql)

end if

next

sql="insert into buy(ddan,wuliufee,id_payment,shulian,id_login,login,type,selldate,price,price2,price3,id_gys,gys,bianhao,zu) values('"&ddan&"','"&wuliufee&"',"&nowid_payment&","&totalshulian&","&nowid_login&",'"&rs_login("username")&"',0,#"&date()&"#,"&price&","&price2&","&price3&","&nowid_gys&",'"&nowgys&"','"&nowbianhao&"',true)"

conn.execute(sql)

%>

<script language="javascript">

alert("产品入库成功！")

</script>

<%if dayin1="yes" then%>

<script language="javascript">

window.open('print_buy.asp?bianhao=<%=nowbianhao%>','打印','width=853,height=470,top=176,left=161,toolbar=no,location=no,directories=no,status=no,menubar=no,resizable=no,scrollbars=yes');

</script>

<%end if%>

<%

end if

%>

<%

if request("hid2")<>"" then

nowbigclass=request("bigclass")

nowsmallclass=request("smallclass")

nowtitle=request("title")

nowhuohao=request("huohao")

nowtiaoma=request("tiaoma")

nowku=request("ku")

nowshulian=request("shulian")

nowdanwei=request("danwei")

nowprice=request("price")

if nowprice="" then

  nowprice=0

end if

nowprice2=request("price2")

if nowprice2="" then

  nowprice2=0

end if

nowprice3=request("price3")

if nowprice3="" then

  nowprice3=0

end if

nowguige=request("guige")

nowsekuan=request("sekuan")

nowjingzhong=request("jingzhong")

nowzhuangxiangshu=request("zhuangxiangshu")

nowbaojin=request("baojin")

nowclass=request("class")

nowduihuan=request("duihuan")

nowtichen_type=request("tichen_type")

nowtichen=request("tichen")

nowphoto=request("photo")

nowbeizhu=request("beizhu")

nowid_login=request("id_login")

nowid_gys=request("id_gys")

nowgys=""

nowid_payment=request("id_payment")

set rs_login=conn.execute("select * from login where id="&nowid_login)

set rs_gys=conn.execute("select * from gys where id="&nowid_gys)

if rs_gys.eof=false then nowgys=rs_gys("company")

sql="select * from produit where huohao='"&nowhuohao&"'"

set rs=conn.execute(sql)

if rs.eof=false then

%>

<script language="javascript">

alert("您输入的淘宝条码已经存在，请使用已有产品入库进行添加！")

window.history.go(-1)

</script>

<%

  response.end

end if

sql="insert into produit(id_bigclass,id_smallclass,title,huohao,tiaoma,id_ku,shulian,danwei,price,price2,price3,guige,sekuan,jingzhong,zhuangxiangshu,baojin,class,tichen_type,tichen,photo,beizhu,id_gys,gys) values("&nowbigclass&","&nowsmallclass&",'"&nowtitle&"','"&nowhuohao&"','"&nowtiaoma&"',"&nowku&","&nowshulian&",'"&nowdanwei&"',"&nowprice&","&nowprice2&","&nowprice3&",'"&nowguige&"','"&nowsekuan&"','"&nowjingzhong&"','"&nowzhuangxiangshu&"',"&nowbaojin&","&nowclass&","&nowtichen_type&","&nowtichen&",'"&nowphoto&"','"&nowbeizhu&"',"&nowid_gys&",'"&nowgys&"')"

conn.execute(sql)

sql="select * from produit order by id desc"

set rs_produit=conn.execute(sql)

sql="select bigclass from bigclass where id="&nowbigclass

set rs_bigclass=conn.execute(sql)

sql="select smallclass from smallclass where id="&nowsmallclass

set rs_smallclass=conn.execute(sql)

if rs_smallclass.eof then

  smallclass=""

else

  smallclass=rs_smallclass(0)

end if

sql="select * from ku where id="&nowku

set rs_ku=conn.execute(sql)

set rs_bianhao=conn.execute("select * from buy order by id desc")

if rs_bianhao.eof then

  nowbianhao=1000001

else

  nowbianhao=1000001+rs_bianhao("id")

end if

ddan=request("ddan")

wuliufee=request("wuliufee")

sql="select * from ku where id="&nowku

set rs_ku=conn.execute(sql)

sql="insert into buy(ddan,wuliufee,id_payment,id_produit,bigclass,smallclass,title,huohao,tiaoma,id_ku,ku,shulian,guige,sekuan,jingzhong,zhuangxiangshu,id_login,login,type,selldate,price,price2,price3,photo,id_gys,gys,bianhao,beizhu) values('"&ddan&"',"&wuliufee&","&nowid_payment&","&rs_produit("id")&",'"&rs_bigclass(0)&"','"&smallclass&"','"&nowtitle&"','"&nowhuohao&"','"&nowtiaoma&"',"&rs_ku("id")&",'"&rs_ku("ku")&"',"&nowshulian&",'"&nowguige&"','"&nowsekuan&"','"&nowjingzhong&"','"&nowzhuangxiangshu&"',"&nowid_login&",'"&rs_login("username")&"',0,#"&date()&"#,"&nowprice&","&nowprice2&","&nowprice3&",'"&nowphoto&"',"&nowid_gys&",'"&nowgys&"','"&nowbianhao&"','"&nowbeizhu&"')"

conn.execute(sql)

ddan=request("ddan")

sql="insert into buy(ddan,wuliufee,id_payment,shulian,id_login,login,type,selldate,price,price2,price3,id_gys,gys,bianhao,zu) values('"&ddan&"','"&wuliufee&"',"&nowid_payment&","&nowshulian&","&nowid_login&",'"&rs_login("username")&"',0,#"&date()&"#,"&nowprice&","&nowprice2&","&nowprice3&","&nowid_gys&",'"&nowgys&"','"&nowbianhao&"',true)"

conn.execute(sql)

%>

<script language="javascript">

alert("产品入库成功！")

</script>

<%if dayin1="yes" then%>

<script language="javascript">

window.open('print_buy.asp?bianhao=<%=nowbianhao%>','打印','width=853,height=470,top=176,left=161,toolbar=no,location=no,directories=no,status=no,menubar=no,resizable=no,scrollbars=yes');

</script>

<%end if%>

<%

end if

%>

<script language="javascript">

function isNumberString (InString,RefString)

{

if(InString.length==0) return (false);

for (Count=0; Count < InString.length; Count++)  {

    TempChar= InString.substring (Count, Count+1);

    if (RefString.indexOf (TempChar, 0)==-1)

    return (false);

}

return (true);

}

function check()

{

if (document.form2.title.value==""||document.form2.huohao.value==""||document.form2.shulian.value=="")

{

alert("有*号的必须填写！");

return false;

}

if (isNumberString(document.form2.tichen.value,"1234567890.")!=1)

{

alert("价格只能为数字!");

return false;

}

}

function check1()

{

if (document.form1.huohao1.value=="单击选择产品")

{

alert("还没有选择产品！");

return false;

}

if (document.form1.shulian1.value=="")

{

alert("请输入入库数量！");

return false;

}

}

function chg1(a)

{

if (a=="0") {document.all.bian1.innerHTML="%"}

else {document.all.bian1.innerHTML="元"}

}

</script>

<script>

  function check_click(){

  if(document.form2.huohao.value=="")

  {

  alert("请先输入您要检测的淘宝条码");

  document.form2.huohao.focus();

  return   false;

  }

  window.open('check.asp?huohao='+document.form2.huohao.value);

  }

  </script>   

<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#C4D8ED">

<tr>

<td><img src="../images/r_1.gif" alt="" /></td>

<td width="100%" background="../images/r_0.gif">

  <table cellpadding="0" cellspacing="0" width="100%">

    <tr>

      <td>&nbsp;已有产品入库(带*号的为必填项)</td>

      <td align="right">&nbsp;</td>

    </tr>

  </table>

</td>

<td><img src="../images/r_2.gif" alt="" /></td>

</tr>

<tr>

<td></td>

<td>

<table align="center" cellpadding="4" cellspacing="1" class="toptable grid" border="1">

      <form name="form1" method="post">

      <tr>

        <td width="19%" align="right" height="30">选择产品：</td>

        <td width="81%" class="category">

          <table cellpadding="0" cellspacing="0" width="100%" border=0>

            <%for x=1 to maxproduit%>

            <tr id="cailiaohan<%=x%>"<%if x<>1 then%> style="display:none;"<%end if%>>

              <td>

                <input name="huohao<%=x%>" readonly onClick="JavaScript:window.open('produit1.asp?form=form1&field=huohao<%=x%>&field2=price2<%=x%>&span1=showshulian<%=x%>','','directorys=no,toolbar=no,status=no,menubar=no,scrollbars=yes,resizable=no,width=853,height=470,top=176,left=161');" style="width:80px" value="单击选择产品">

                &nbsp;数量: <input type="text" name="shulian<%=x%>" style="width:30px" onKeyUp="this.value=this.value.replace(/\D/g,'')" onafterpaste="this.value=this.value.replace(/\D/g,'')" value="1">

                &nbsp;成本单价: <input type="text" name="price2<%=x%>" style="width:50px" onKeyUp="value=value.replace(/[^\d.]/g,'')" onbeforepaste="clipboardData.setData('text',clipboardData.getData('text').replace(/[^\d.]/g,''))">

                <%

                if session("shiwei_id")=1 then

                  sql="select * from ku order by id"

                  set rs_ku=conn.execute(sql)

                else

                  sql="select * from ku where instr(login,'"&session("shiwei_id")&",')>0 order by id"

                  set rs_ku=conn.execute(sql)

                end if

                if rs_ku.eof then

                %>

                <script language="javascript">

                  alert("没有属于你管理的仓库,请先添加仓库！")

                  window.location.href="../system/ku_add.asp"

                </script>

                <%

                end if

                %>

                &nbsp;仓库: <select name="ku<%=x%>">

                <%

                do while rs_ku.eof=false

                %>

                  <option value="<%=rs_ku("id")%>"<%if rs_ku("moren") then%> selected="selected"<%end if%>><%=rs_ku("ku")%></option>

                <%

                  rs_ku.movenext

                loop

                %>

                </select>

                <%if x<>maxproduit then%><span onClick="cailiaohan<%=(x+1)%>.style.display=''" style="cursor:hand;">下一个产品</span><%end if%>

                <%if x=1 then%><font color="#ff0000">*</font><%end if%>

                <div id="showshulian<%=x%>"></div>

              </td>

            </tr>

            <%next%>

          </table>

        </td>

      </tr>

      <tr>

        <tr>

        <td align="right" height="30">订单号：</td>

        <td class="category">

          <input name="ddan" value="<%=ddan%>" style="width:150px">

            物流费：

            <input type="text" name="wuliufee" id="wuliufee" value="0" onKeyUp="clearNoNum(this);" onafterpaste="clearNoNum(this);">

            支付方式

            <%

        sql="select * from payment order by id"

        set rs_login=conn.execute(sql)

          if rs_login.eof then

          %>

            <script language="javascript">

            alert("请先添加支付方式！")

            window.location.href="../system/payment.asp"

            </script>

            <%

          response.end

          else

          %>

            <select name="id_payment" id="id_payment" style="width:65px">

              <%

          do while rs_login.eof=false

          %>

              <option value="<%=rs_login("id")%>"><%=rs_login("payment")%></option>

              <%

            rs_login.movenext

          loop

          %>

            </select>

            <%

          end if

          set rs_login=nothing

          %></td>

        </tr>

        <td align="right" height="30">供应商：</td>

        <td class="category">

          <%

                sql="select * from gys order by id"

                set rs_gys=conn.execute(sql)

                %>

                <select name="id_gys">

                  <option value="0"></option>

                <%

                do while rs_gys.eof=false

                %>

                  <option value="<%=rs_gys("id")%>"><%=rs_gys("company")%></option>

                <%

                  rs_gys.movenext

                loop

                %>

                </select></td>

      </tr>

      <tr>

        <td align="right" height="30">经办人：</td>

        <td class="category">

          <%

          if session("shiwei_id")=1 then

            sql="select * from login order by id_zu,id"

            set rs_login=conn.execute(sql)

          else

            sql="select * from login where id="&session("shiwei_id")

            set rs_login=conn.execute(sql)

          end if

          if rs_login.eof then

          %>

          <script language="javascript">

            alert("请先添加员工！")

            window.location.href="../system/user_add.asp"

          </script>

          <%

          else

          %>

          <select name="id_login">

          <%

          do while rs_login.eof=false

          %>

            <option value="<%=rs_login("id")%>"<%if rs_login("username")=session("shiwei_username") then%> selected="selected"<%end if%>><%=rs_login("username")%> (<%=rs_login("bianhao")%>)</option>

          <%

            rs_login.movenext

          loop

          %>

          </select>

          <%

          end if

          %>

        </td>

      </tr>

      <tr>

        <td height="30">&nbsp;</td>

        <td class="category">

          <input type="submit" value=" 确认添加 " onClick="return check1()" class="button">

          <input type="hidden" name="hid1" value="ok">

          <input type="reset" value=" 重新填写 " class="button">

          </td>

      </tr>

      </form>

</table>

</td>

<td></td>

</tr>

<tr>

<td><img src="../images/r_4.gif" alt="" /></td>

<td></td>

<td><img src="../images/r_3.gif" alt="" /></td>

</tr>

</table>

<table cellpadding=0 cellspacing=0 width="98%" align=center><tr><td height="5"></td></tr></table>

<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#C4D8ED">

<tr>

<td><img src="../images/r_1.gif" alt="" /></td>

<td width="100%" background="../images/r_0.gif">

  <table cellpadding="0" cellspacing="0" width="100%">

    <tr>

      <td>&nbsp;新产品入库(带*号的为必填项)</td>

      <td align="right">&nbsp;</td>

    </tr>

  </table>

</td>

<td><img src="../images/r_2.gif" alt="" /></td>

</tr>

<tr>

<td></td>

<td>

<table align="center" cellpadding="4" cellspacing="1" class="toptable grid" border="1">

      <form name="form3">

      <tr>

        <td align="right" height="30">所属大类：</td>

        <td class="category">

    <%

    sql="select * from bigclass order by id"

    set rs_bigclass=conn.execute(sql)

    if rs_bigclass.eof then

    %>

    <script language="javascript">

      alert("请先添加产品大类！")

      window.location.href="../system/bigclass_add.asp"

    </script>

    <%

    end if

    nowbigclass=request("bigclass")

    if nowbigclass="" then

      nowbigclass=rs_bigclass("id")

    end if

    %>

      <select name="bigclass" onChange="form3.submit()">

        <%

    do while rs_bigclass.eof=false

    %>

        <option value="<%=rs_bigclass("id")%>"<%if trim(cstr(rs_bigclass("id")))=nowbigclass then%> selected="selected"<%end if%>><%=rs_bigclass("bigclass")%></option>

        <%

      rs_bigclass.movenext

    loop

    %>

      </select>

          </td>

      </tr>

      </form>

      <form name="form2">

      <input type="hidden" name="bigclass" value="<%=nowbigclass%>">

      <tr>

        <td align="right" height="30">所属小类：</td>

        <td class="category">

    <%

    sql="select * from smallclass where id_bigclass="&nowbigclass&" order by id"

    set rs_smallclass=conn.execute(sql)

    %>

      <select name="smallclass">

        <option value="0"></option>

        <%

    do while rs_smallclass.eof=false

    %>

        <option value="<%=rs_smallclass("id")%>"<%if trim(cstr(rs_smallclass("id")))=nowsmallclass then%> selected="selected"<%end if%>><%=rs_smallclass("smallclass")%></option>

        <%

      rs_smallclass.movenext

    loop

    %>

      </select>

          </td>

      </tr>

      <tr>

        <td width="20%" height="30" align="right">商品名称：</td>

        <td width="80%" class="category">

          <input name="title" type="text" style="width:200px;">&nbsp;<font color="#ff0000">*</font></td>

      </tr>

      <tr>

        <td align="right" height="30">商品货号：</td>

        <td class="category">

          <input type="text" name="huohao" style="width:200px">&nbsp;<font color="#ff0000">*</font>

        <input style="width:160"   name="checkno"   type="button"     value="点击检测淘宝条码是否存在"     onClick="javascript:check_click(this)">  

          </td>

      </tr>

      <tr>

        <td align="right" height="30">商品条码：</td>

        <td class="category">

          <input type="text" name="tiaoma" style="width:200px">&nbsp;</td>

      </tr>

      <tr>

        <td align="right" height="30">订货单号：</td>

        <td class="category">

          <input name="ddan" value="<%=ddan%>" style="width:150px">

            物流费：

            <input type="text" name="wuliufee" id="wuliufee" value="0" onKeyUp="clearNoNum(this);" onafterpaste="clearNoNum(this);">

            支付方式

            <%

        sql="select * from payment order by id"

        set rs_login=conn.execute(sql)

          if rs_login.eof then

          %>

            <script language="javascript">

            alert("请先添加支付方式！")

            window.location.href="../system/payment.asp"

            </script>

            <%

          response.end

          else

          %>

            <select name="id_payment" id="id_payment" style="width:65px">

              <%

          do while rs_login.eof=false

          %>

              <option value="<%=rs_login("id")%>"><%=rs_login("payment")%></option>

              <%

            rs_login.movenext

          loop

          %>

            </select>

            <%

          end if

          set rs_login=nothing

          %></td>

      </tr>

      <tr>

        <td align="right" height="30">产品单位：</td>

        <td class="category">

    <%

    sql="select * from danwei order by id"

    set rs_danwei=conn.execute(sql)

    if rs_danwei.eof then

    %>

    <script language="javascript">

      alert("请先添加单位！")

      window.location.href="../system/danwei_add.asp"

    </script>

    <%

    end if

    %>

      <select name="danwei">

        <%

    do while rs_danwei.eof=false

    %>

        <option value="<%=rs_danwei("danwei")%>"><%=rs_danwei("danwei")%></option>

        <%

      rs_danwei.movenext

    loop

    %>

      </select>

      <font color="#666666">(只用于普通识别，不能换算)</font></td>

      </tr>

      <tr>

        <td align="right" height="30">产品价格：</td>

        <td class="category">推荐卖价：<input type="text" name="price" style="width:100px" onKeyUp="value=value.replace(/[^\d.]/g,'')" onbeforepaste="clipboardData.setData('text',clipboardData.getData('text').replace(/[^\d.]/g,''))">

          <font color="#666666">元</font>

           代理价：<input type="text" name="price3" style="width:100px" onKeyUp="value=value.replace(/[^\d.]/g,'')" onbeforepaste="clipboardData.setData('text',clipboardData.getData('text').replace(/[^\d.]/g,''))">

          <font color="#666666">元</font>

          进货价：<input type="text" name="price2" style="width:100px" onKeyUp="value=value.replace(/[^\d.]/g,'')" onbeforepaste="clipboardData.setData('text',clipboardData.getData('text').replace(/[^\d.]/g,''))">

          <font color="#666666">元</font>

          </td>

      </tr>

        <tr>

        <td align="right" height="30">产品详情：</td>

        <td class="category">

        <div style="width: 850px; margin: 0px auto 0;">

        <div>颜色分类：<input id="sekuan" width="60" /><span class="i_color_error">*</span></div>

        <div>规格型号：<input id="guige" width="60"  /><span class="i_model_error">*</span><span id="i_model_add">增加</span></div>

        <table width="100%" border="1" cellpadding="4" cellspacing="1"  bordercolor="#C9DBEF" id="ctr" >

            <tr>

                <td align="center">颜色</td>

                <td align="center">图片</td>

                <td align="center">规格</td>

                <td align="center">价格</td>

                <td align="center">数量</td>

                <td align="center">仓库</td>

                <td align="center">条码</td>

                <td align="center">删除</td>

            </tr>

        </table>

    <script type="text/javascript">

        (function($){

            var color = '';

            var model = '';

            var bool;

            var td_size = $('#ctr tr:first td').size();

            var tr;

            var index = 0;

            var boo_index;

            var rowspan;

            var click_bool;

            $('#i_model_add').click(function(){

                bool  = false;

                boo_index = true;

                model = $('#guige').val().trim();

                color = $('#sekuan').val().trim();

                if(model == ''){

                    bool = true;

                    $('.i_model_error').show();

                }

                else{

                    $('.i_model_error').hide();

                }

                if(color == ''){

                    bool = true;

                    $('.i_color_error').show();

                }

                else{

                    $('.i_color_error').hide();

                }

                if(bool){

                    return false;

                }

                $('.sekuan').each(function(){

                    if($(this).html() == color){

                        rowspan = $(this).parent().attr('rowspan');

                        if(rowspan > 0){

                            rowspan ++;

                        }

                        else{

                            rowspan = 2;

                        }

                        $(this).parent().attr('rowspan',rowspan);

                        $(this).parent().parent().find('.pic').parent().attr('rowspan',rowspan);

                        tr = '<tr><td><span class="guige" value="">' + model + '</span></td><td><input type="text" name="price2" onKeyUp="this.value=this.value.replace(/\D/g,\'\') onafterpaste="this.value=this.value.replace(/\D/g,\'\') value="<%=price2%>"></td><td><input class="shulian" onKeyUp="this.value=this.value.replace(/\D/g,\'\') onafterpaste="this.value=this.value.replace(/\D/g,\'\') value="1" /></td><td><%

                if session("shiwei_id")=1 then

                  sql="select * from ku order by id"

                  set rs_ku=conn.execute(sql)

                else

                  sql="select * from ku where instr(login,'"&session("shiwei_id")&",')>0 order by id"

                  set rs_ku=conn.execute(sql)

                end if

                if rs_ku.eof then

                %>

                <script language="javascript">

                  alert("没有属于你管理的仓库,请先添加仓库！")

                  window.location.href="../system/ku_add.asp"

                </script>

                <%

                response.end

                end if

                %><select name="ku"><%

    do while rs_ku.eof=false

    %><option value="<%=rs_ku("id")%>"<%if rs_ku("moren") then%> selected="selected"<%end if%>><%=rs_ku("ku")%></option><%

      rs_ku.movenext

    loop

    %></select></td><td><input class="tiaoma" value="<%=tiaoma%>"/></td><td><span class="remove">删除</span></td></tr>';

                        $(this).parent().parent().after(tr);

                        boo_index = false;

                    }

                });

                if(boo_index){

                    tr = '<tr><td><span class="sekuan" value="">' + color + '</span></td><td><input type="file" class="pic" /></td><td><span class="guige" value="">' + model + '</span></td><td><input type="text" name="price2" onKeyUp="this.value=this.value.replace(/\D/g,\'\') onafterpaste="this.value=this.value.replace(/\D/g,\'\') value="<%=price2%>"></td><td><input class="shulian" onKeyUp="this.value=this.value.replace(/\D/g,\'\') onafterpaste="this.value=this.value.replace(/\D/g,\'\') value="1" /></td><td><%

                if session("shiwei_id")=1 then

                  sql="select * from ku order by id"

                  set rs_ku=conn.execute(sql)

                else

                  sql="select * from ku where instr(login,'"&session("shiwei_id")&",')>0 order by id"

                  set rs_ku=conn.execute(sql)

                end if

                if rs_ku.eof then

                %>

                <script language="javascript">

                  alert("没有属于你管理的仓库,请先添加仓库！")

                  window.location.href="../system/ku_add.asp"

                </script>

                <%

                response.end

                end if

                %><select name="ku"><%

    do while rs_ku.eof=false

    %><option value="<%=rs_ku("id")%>"<%if rs_ku("moren") then%> selected="selected"<%end if%>><%=rs_ku("ku")%></option><%

      rs_ku.movenext

    loop

    %></select></td><td><input class="tiaoma" value="<%=tiaoma%>"/></td><td><span class="remove">删除</span></td></tr>';

                    $('#ctr tbody').append(tr);

                }

            });

            $('.remove').live('click',function(){

                if($(this).parent().parent().find('td').size() == td_size && (!$(this).parent().parent().find('td:first').attr('rowspan') || $(this).parent().parent().find('td:first').attr('rowspan') == 1)){

                    $(this).parent().parent().remove();

                }

                if($(this).parent().parent().find('td').size() < td_size){

                    click_bool = true;

                    $(this).parent().parent().prevAll('tr').each(function(){

                        if(click_bool && $(this).find('td:first').attr('rowspan')){

                            rowspan = $(this).find('td:first').attr('rowspan');

                            rowspan --;

                            $(this).find('td:first,td:eq(1)').attr('rowspan',rowspan);

                            click_bool = false;

                        }

                    });

                    $(this).parent().parent().remove();

                }

                if($(this).parent().parent().find('td').size() == td_size && $(this).parent().parent().find('td:first').attr('rowspan') > 1){

                    rowspan = $(this).parent().parent().find('td:first').attr('rowspan');

                    rowspan --;

                    $(this).parent().parent().next().prepend($(this).parent().parent().find('td:eq(1)').clone());

                    $(this).parent().parent().next().prepend($(this).parent().parent().find('td:first').clone());

                    $(this).parent().parent().next().find('td:first,td:eq(1)').attr('rowspan',rowspan);

                    $(this).parent().parent().remove();

                }

            });

        })(jQuery);    

        </script>

</div></td>

      </tr>

      <tr>

        <td align="right" height="30">产品净重：</td>

        <td class="category"><input type="text" name="jingzhong" style="width:200px"></td>

      </tr>

       <tr>

        <td align="right" height="30">装箱数量：</td>

        <td class="category"><input type="text" name="zhuangxiangshu" style="width:200px"></td>

      </tr>

      <tr>

        <td align="right" height="30">最低库存报警数量：</td>

        <td class="category"><input type="text" name="baojin" style="width:100px" onKeyUp="this.value=this.value.replace(/\D/g,'')"  onafterpaste="this.value=this.value.replace(/\D/g,'')" value="0">

          <font color="#666666">(设为零将不会报警)</font></td>

      </tr>

      <tr>

        <td align="right" height="30">经办人：</td>

        <td class="category">

          <%

          if session("shiwei_id")=1 then

            sql="select * from login order by id_zu,id"

            set rs_login=conn.execute(sql)

          else

            sql="select * from login where id="&session("shiwei_id")

            set rs_login=conn.execute(sql)

          end if

          if rs_login.eof then

          %>

          <script language="javascript">

            alert("请先添加员工！")

            window.location.href="../system/user_add.asp"

          </script>

          <%

          else

          %>

          <select name="id_login">

          <%

          do while rs_login.eof=false

          %>

            <option value="<%=rs_login("id")%>"<%if rs_login("username")=session("shiwei_username") then%> selected="selected"<%end if%>><%=rs_login("username")%> (<%=rs_login("bianhao")%>)</option>

          <%

            rs_login.movenext

          loop

          %>

          </select>

          <%

          end if

          %>        </td>

      </tr>

      <tr>

        <td align="right" height="30">供应商：</td>

        <td class="category">

          <%

          sql="select * from gys order by id"

          set rs_gys=conn.execute(sql)

          %>

          <select name="id_gys">

            <option value="0"></option>

          <%

          do while rs_gys.eof=false

          %>

            <option value="<%=rs_gys("id")%>"><%=rs_gys("company")%></option>

          <%

            rs_gys.movenext

          loop

          %>

          </select>

        </td>

      </tr>

      <tr>

        <td align="right" height="30">产品类型：</td>

        <td class="category">

          <select name="class">

            <option value="0">正常产品</option>

            <option value="1">公司赠品</option>

          </select>

          </td>

      </tr>

     <tr>

        <td align="right" height="30">兑换所需积分：</td>

        <td class="category">

          <input type="text" name="duihuan" style="width:100px" onKeyUp="this.value=this.value.replace(/\D/g,'')"  onafterpaste="this.value=this.value.replace(/\D/g,'')" value="0">

          <font color="#666666">(会员兑换此礼品所需积分)</font></td>

      </tr>

      <tr>

        <td align="right" height="30">提成类型：</td>

        <td class="category">

          <select name="tichen_type" onChange="chg1(this.value)">

            <option value="0">按百分比提成</option>

            <option value="1">固定提成</option>

          </select>

        </td>

      </tr>

      <tr>

        <td align="right" height="30">员工提成：</td>

        <td class="category">

          销售一件提成：<input type="text" name="tichen" style="width:50px" value="<%=jieshaojifen%>">

          <font color="#666666"><span id="bian1">%</span></font></td>

      </tr>

      <tr>

        <td align="right" height="30">产品备注：</td>

        <td class="category">

          <textarea name="beizhu" cols="60" rows="3"></textarea>

        </td>

      </tr>

      <tr>

        <td height="30">&nbsp;</td>

        <td class="category"><input type="submit" value=" 确认添加 " onClick="return check()" class="button">&nbsp;&nbsp;&nbsp;&nbsp;

          <input type="hidden" name="hid2" value="ok">

          <input type="hidden" name="photo" value="">

          <input type="reset" value=" 重新填写 " class="button">        </td>

      </tr>

      </form>

</table>

</td>

<td></td>

</tr>

<tr>

<td><img src="../images/r_4.gif" alt="" /></td>

<td></td>

<td><img src="../images/r_3.gif" alt="" /></td>

</tr>

</table>

</body>

</html>

请帮我看看这个页面，红色部份如何改才能保存到ACCess数据库中的更多相关文章

  1. 磁盘当前目录下存在文件 c1&period;txt，其中存放了一段英文文字。请编程实现将c1&period;txt中英文文字全部转换为答谢字母，并保存到c2&period;txt中。要求：c2&period;txt文件前面保存的是c1&period;txt文案中的原始文字，后面紧跟着的是转换后的文字

    #include"stdio.h"#include"string.h" void main(){ FILE *fp1,*fp2; char ch[1000]=& ...

  2. Python Django CMDB项目实战之-2创建APP、建模（models&period;py）、数据库同步、高级URL、前端页面展示数据库中数据

    基于之前的项目代码来编写 Python Django CMDB项目实战之-1如何开启一个Django-并设置base页index页文章页面 现在我们修改一个文章列表是从数据库中获取数据, 下面我们就需 ...

  3. Win10该文件没有与之关联的应用来执行该操作&period;&period;&period;请在&quot&semi;默认应用设置&quot&semi;页面中创建关联

    问题发现:一直使用的一款软件--火柴,这两天忽然发现通过ctrl + 回车快捷键无法进入到文件所在的目录中(之前几天印象中还可以使用该功能).后来测试又发现无法打开网易云音乐中下载的音乐而进入到该音乐 ...

  4. &lbrack;Windows10&rsqb;记一次修复注册表相关血案：该文件没有与之关联的应用来执行该操作。请安装应用，若已经安装应用，请在&OpenCurlyDoubleQuote;默认应用设置”页面中创建关联。

    今天闲得蛋疼清理了一下右键菜单,于是在之后某时刻使用Everything的“双击路径列打开目录”功能时发现异常: [Window Title] Everything.exe [Content] 该文件 ...

  5. 通过查询数据库中的数据匹配在页面上：（set单条数据属性是在页面上的显示与foreach的不同） 通过ID修改提取位置表信息

    ACTION   OpenModifyExtractPositionById // set单条数据属性 /* * 通过ID修改提取位置表信息 */ public String OpenModifyEx ...

  6. 关于从JSP页面插入数据到数据库中乱码问题的解决

    问题描述:最近我在写一个j2ee的留言板系统模块,遇到了一个非常让我头大的问题,当我从JSP页面输入数据后,通过hibernate中的业务逻辑类HQL语句把这个数据插入到本地的mysql数据库中,可是 ...

  7. WebMethod在webservice里面非静态方法能调用，在页面类里面，静态方法才能调用

    WebMethod在webservice里面非静态方法能调用,在页面类里面,静态方法才能调用

  8. EF6 在原有数据库中使用 CodeFirst 总复习（五、生成发帖页面）

    有点与在原有数据库中使用 CodeFirst 远了,不过是总复习吗,总得全面点. 一.在用户表(Users)中插入两个用户 二.生成发帖界面 MVC生成的界面很多,也没使用Ajax,实际开发中很少会使 ...

  9. jquery 实现页面拖拽并保存到cookie

    实现的效果就是页面内的图片可拖拽到任意位置,并将所在位置保存.下次打开页面依然可见.本文是作demo用,实际开发中,位置的数据应保存到数据库中. 好了,开始. 1.准备工作. a.jquery(1.7 ...

随机推荐

  1. python---进程、线程

    一.进程 二.线程 1,使用Thread类创建线程 #!/usr/bin/env python # -*- coding:utf-8 -*- __author__ = 'zhoufeng' impor ...

  2. YII2项目常用技能知识总结

    1.不通过日志获取AR执行的原生SQL语句和打印变量数据 $query = User::find() ->select(['username'])->where(['id'=>[1, ...

  3. 消除ComponentOne&lpar;C1StudioNet&lowbar;2013v2&rpar; 的注册提示

     以后大家如果遇到还有提示,在License文件里添加:C1.Win.C1Command.C1OutBar, C1.Win.C1Command.4, Version=4.0.20132.19568,  ...

  4. Mvc网站开发知识

    网站开发基本本步骤 mvc是一个设计模式 网站开发前台页面技术 页面设计:Html css+Div 页面特效:JavaScript,jQuery oop编程核心公共技能 c#基础语法与程序逻辑 面向对 ...

  5. 技巧两种：LINUX删除指定后缀文件及PYTHON更改屏幕字色

    http://blog.csdn.net/caryaliu/article/details/8753028 http://www.iitshare.com/python-print-color-log ...

  6. Qt 文件搜索（写入文本文件）

    代码无意间在网上找到,下载回来后改了几个格式,编译后经测试可以正常使用,这个个文件搜索的很好的例子,有两种搜索方式:一种是按文件名作为关键字进行搜索,一种是以文档中所包含的关键字进行搜索,贴两张图先: ...

  7. 关于用模拟器运行百度地图API无法定位的问题 - 不能用模拟器

    模拟器是没有办法定位,当你加入定位模块的时候,传出的参数都是空的. 定位的这个方法函数,是通过回调接口来实现,而且触发该事件的时候,需要经纬度位置改变.官方文档写得很清楚,简单点来说,就是你没有GPS ...

  8. js实现浏览器添加收藏功能

    今天搞项目的时候为了实现浏览者实现添加收藏的功能,特地了解了一下相关的API. 也看到了网上各种版本的代码.整理了一下,代码如下.简单易懂. <script> function _addF ...

  9. 三种方式给apt设置代理

    为什么设置代理,你懂得. 有很多第三方工具可以用,比如proxychains,非常好用,不过今天这不是正题.因为有可能没有代理,上网你都做不到,更别提下载软件了.想一想方法还是告诉你,免得你万一必须用 ...

  10. HNの野望

    1.标题 2.工作 3.学习 4.英语 5.健康 6.心理 7.绘画 8.看书

相关文章