⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 complist.asp

📁 本程序所有数据库文件都以.sql文件保存在Database文件夹里; 2、首先在SQL查询分析器中运行CreateDatabase.sql文件创建数据库; 3、运行其他所有的.sql文件即可创建好了本
💻 ASP
字号:
<!--#include file="../conndb.asp"-->
<!--#include file="isAdmin.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>公司管理</title>
<link href="../style.css" rel="stylesheet">
<script language="javascript">
function newView(url) {
  var oth="toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,left=200,top=200";
  oth = oth+",width=600,height=400";
  var newView=window.open(url,"newView",oth);
  newView.focus();
  return false;
}
function newWin(url) {
  var oth="toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,left=200,top=200";
  oth = oth+",width=500,height=250";
  var newWin=window.open(url,"newWin",oth);
  newWin.focus();
  return false;
}
function SelectChk()
{
	var s=false;
	var deptid,n=0;
	var strid,strurl;
	var nn = self.document.all.item("comp")
	for (j=0;j<nn.length;j++)
	{
		if (self.document.all.item("comp",j).checked)
		{
			n = n + 1;
			s=true;
			deptid = self.document.all.item("comp",j).id+"";
			if(n==1)
			{
				strid = "'" + deptid + "'";
			}
			else
			{
				strid = strid + ",'" + deptid + "'";
			}
		}
	}

	strurl = "CompDelt.asp?id=" + strid;
	if(!s)	{
		alert("请选择要删除的公司!");
		return false;
	}
	if ( confirm("你确定要删除这些公司吗?")) {
	    form1.action=strurl;
	    form1.submit();
	}
}
function sltAll()
{
	var nn = self.document.all.item("comp");
	for(j=0;j<nn.length;j++)
	{
		self.document.all.item("comp",j).checked = true;
	}
}
function sltNull()
{
	var nn = self.document.all.item("comp");
	for(j=0;j<nn.length;j++)
	{
		self.document.all.item("comp",j).checked = false;
	}
}
</script>
</head>
<body link="#000080" vlink="#080080">
<form id="form1" name="form1" method="POST">
<%
Dim rs
Set rs = Server.CreateObject("ADODB.RecordSet")
sql = "Select * From Company  Order By PostDate Desc"
%>
<p align="center"><font color="#000080"><b><font style="font-size: 12pt">公 司 
管 理</font></b></font></p>
<table align=center border="1" cellspacing="0" width="100%" bordercolor="5A8FF0" >
  <tr>
   <td width="16%" align="center" bgcolor="#5A8FF0"><strong>用户名</strong></td>
   <td width="32%" align="center" bgcolor="#5A8FF0"><strong>公司名称</strong></td>
   <td width="16%" align="center" bgcolor="#5A8FF0"><strong>地域</strong></td>
   <td width="16%" align="center" bgcolor="#5A8FF0"><strong>电话</strong></td>
   <td width="10%" align="center" bgcolor="#5A8FF0"><strong>修改</strong></td>
   <td width="10%" align="center"  bgcolor="#5A8FF0"><strong>选择</strong></td>
  </tr>
  <%
rs.Open sql,conn,1,1
If rs.EOF Then
  Response.Write "<tr><td colspan=6 align=center>目前还没有公司。</td></tr></table>"
Else
  rs.PageSize = 15
  rs.AbsolutePage = 1
  If Request("page")<>"" Then rs.AbsolutePage =Request("page") 
  RowCount =rs.PageSize

  Do While Not rs.EOF And RowCount>0
  %>
  <tr>
    <td><%=rs("Cname")%></td>
	<td><a href="../CompView.asp?uid=<%=rs("Cname")%>" onClick="return newView(this.href)"><%=rs("Company")%></a></td>
	<td align="center"><%=rs("Location")%>&nbsp;</td>
	<td align="center"><%=rs("Telephone")%>&nbsp;</td>
    <td align="center"><a href="NewCompany.asp?uid=<%=rs("Cname")%>" onClick="return newWin(this.href)">修改</a></td>
    <td align="center"><input type="checkbox" name="comp" id="<%=rs("Cname")%>"></td>
  </tr>
  <%
    rs.MoveNext()
    RowCount = RowCount-1
  Loop
  %>
</table>
		<%
		If rs.PageCount>1 Then

			Response.Write "<table border='0'>"
			Response.Write "<tr>"
			Response.Write "<td><b>分页:</b></td>"
			For i=1 To rs.PageCount
			Response.Write "<td><a href='GoodsList.asp?page=" & i & "'>"
			Response.Write "[<b>" & i & "</b>]</a>"
			Response.Write "</td>"
			Next

			Response.Write "</tr></table>"
		End If
  End If
  %>
		
		<p align="center">
		<input type="button" value="添加公司" onclick="newWin('NewCompany.asp')" name=add>
		 &nbsp;&nbsp;<input type="button" value="全 选" onclick="sltAll()" name=button1> 
		 &nbsp;&nbsp;<input type="button" value="清 空" onclick="sltNull()" name=button2> 
 		 &nbsp;&nbsp;<input type="submit" value="删 除" name="tijiao" onclick="SelectChk()"> 
<br><br>
<input type=hidden name="comp">
</form>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -