-+-ڢ

我的图书管理系统

   PUBLIC L_INT
   PUBLIC L_OLD
   
   public l_press
   
   l_press=false
   
   public  l_cancle
    
    RDS2.Server = "http://<%=Request.ServerVariables("SERVER_NAME")%>"

     RDS2.Connect = "database=school;uid=sa;pwd=;dsn=school"

    rds2.sql="select  top 1  * from  tfl  order by 分类编号"
    RDS2.EXECUTEOPTIONS=1
    RDS2.REFRESH

   RDS3.Server = "http://<%=Request.ServerVariables("SERVER_NAME")%>"
   RDS3.Connect = "database=school;uid=sa;pwd=;dsn=school"
   rds3.sql="select * from  tfl  order by 分类编号"
   RDS3.EXECUTEOPTIONS=1
   RDS3.REFRESH

   RDS1.Server = "http://<%=Request.ServerVariables("SERVER_NAME")%>"

   RDS1.Connect = "database=school;uid=sa;pwd=;dsn=school"  '入库数量,出版社名称,价格,译者,册数

   rds1.sql="select 索书号=ltrim(rtrim(分类编号))+'/'+ltrim(rtrim(主序号))+'-'+LTRIM(RTRIM(次序号)),书名=书名,作者,库存数量 from ttsml where 分类编号='"&trim(RDS2.RECORDSET.FIELDS(0))&"' "
   rds1.executeoptions=1
   rds1.refresh
   
  ' L_LBMC.VALUE=RDS1.Recordset.FIELDS(1)
   
  
grid1.ScrollBars=FALSE
	 

</script>
<script language="vbscript">

sub window_onload

Grid1.CAPTION=" 图 书 目  录 浏 览"

end sub 
</script>


<p align="left"><input type="button" value=" A " name="a1" ONCLICK="A1_CLICK()"
 style="FONT-SIZE: 17px"><input type="button" value=" B " name="B1" onclick="b1_click()"
 style="FONT-SIZE: 17px"><input type="button" value=" C " name="C1" style="FONT-SIZE: 17px"
 onclick="c1_click()"><input type="button" value=" D " onclick="d1_click()" name="D1"
 style="FONT-SIZE: 17px"><input type="button" value=" E " name="E1" onclick="e1_click()"
 style="FONT-SIZE: 17px"><input type="button" value=" F " name="F1" style="FONT-SIZE: 17px"
 onclick="f1_click()"><input type="button" value=" G " name="G1" style="FONT-SIZE: 17px"><input
 type="button" value  =" H " onclick="h1_click()" name="H1" style="FONT-SIZE: 17px"><input
 type="button" value  =" I " name="I1" onclick="i1_click()" style="FONT-SIZE: 17px"><input
 type="button" value  =" J " name="J1" onclick="j1_click()" style="FONT-SIZE: 17px"><input
 type="button" value  =" K " name="K1" onclick="k1_click()" style="FONT-SIZE: 17px"><input
 type="button" value  =" L " onclick="l1_click()" name="L1" style="FONT-SIZE: 17px"><input
 type="button" value  =" M " name="M1" onclick="m1_click()" style="FONT-SIZE: 17px"><input
 type="button" value  =" 0 " name="A10" onclick="a10_click()" style="FONT-SIZE: 17px"><input
 type="button" value  =" 1 " name="a11" style="FONT-SIZE: 17px" onclick="a11_click()"><input
 type="button" value  =" 2 " name="a12" onclick="a12_click()" style="FONT-SIZE: 17px"><input
 type="button" value  =" 3 " name="a13" onclick="a13_click()" style="FONT-SIZE: 17px"><input
 type="button" value  =" 4 " name="a14" onclick="a14_click()" style="FONT-SIZE: 17px"><input
 type="button" value  =" - " name="TT" onclick="tt_click()" style="FONT-SIZE: 17px"><br>
<input type="button" value=" N " name="N1" onclick="n1_click()" style="FONT-SIZE: 17px"><input
 type="button" value  =" O " name="O1" onclick="o1_click()" style="FONT-SIZE: 17px"><input
 type="button" value  =" P " onclick="p1_click()" name="P1" style="FONT-SIZE: 17px"><input
 type="button" value  =" Q " name="Q1" onclick="q1_click()" style="FONT-SIZE: 17px"><input
 type="button" value  =" R " name="R1" onclick="r1_click()" style="FONT-SIZE: 17px"><input
 type="button" value  =" S " name="S1" onclick="s1_click()" style="FONT-SIZE: 17px"><input
 type="button" value  =" T " onclick="t1_click()" name="T1" style="FONT-SIZE: 17px"><input
 type="button" value  =" U " name="U1" onclick="u1_click()" style="FONT-SIZE: 17px"><input
 type="button" value  =" V " name="V1" onclick="v1_click()" style="FONT-SIZE: 17px"><input
 type="button" value  =" W " name="W1" style="FONT-SIZE: 17px" onclick="w1_click()"><input
 type="button" value  =" X " onclick="x1_click()" name="X1" style="FONT-SIZE: 17px"><input
 type="button" value  =" Y " name="Y1" onclick="y1_click()" style="FONT-SIZE: 17px"><input
 type="button" value  =" Z " name="Z1" onclick="z1_click()" style="FONT-SIZE: 17px"><input
 type="button" value  =" 5 " name="a15" onclick="a15_click()" style="FONT-SIZE: 17px"><input
 type="button" value  =" 6 " name="a16" onclick="a16_click()" style="FONT-SIZE: 17px"><input
 type="button" value  =" 7 " name="a17" onclick="a17_click()" style="FONT-SIZE: 17px"><input
 type="button" value  =" 8 " name="a18" onclick="a18_click()" style="FONT-SIZE: 17px"><input
 type="button" value  =" 9 " name="a19" onclick="a19_click()" style="FONT-SIZE: 17px"><input
 type="button" value =" 。" name="YY" onclick="yy_click()" style="FONT-SIZE: 17px"></p>
<script language="vbscript">
sub  f_click()

fllb_1.disabled=true

end sub


</script>

</body>
</html>