📄 diclist.asp

📁 客户管理crm xitong ,希望能给你带来帮助

💻 ASP

字号:

<!--#include file="../function/connect.asp"-->
<%
	strTable=request("strTable")
	if strTable="" then
		response.end
	end if
	meth=request("meth")
	if meth="del" and request("Dict" & strTable & "_ID")<>"" then
		strsql="delete from Dict" & strTable & " where Dict" & strTable & "_ID in (" & request("Dict" & strTable & "_ID") &")"
		objConn.execute strsql
	end if
	
	PY_Code=request("PY_Code")
	Dic=request("Dic")

	strsql="select * from Dict" & strTable & " where 1=1 "
	if PY_Code<>"" then
		strsql=strsql & " and PY_Code like '%" & PY_Code & "%'"
	end if 
	if Country<>"" then
		strsql=strsql & " and Dict_value like '%" & Dic & "%'"
	end if 

	Set objRs = Server.CreateObject("adodb.recordset")
	    objRs.Open strsql,objConn,1,1
%>
<html>
<head>
<title>客户类型</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href="../cssD.css" rel=stylesheet>
</head>

<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="1" cellspacing="0" cellpadding="2" bordercolorlight='#000000' bordercolordark='#FFFFFF'>
 <form name="form1" method="post" action="Diclist.asp?strTable=<%=strTable%>">
  <tr class="tablehead"> 
    <td width="4%">&nbsp;</td>
    <td width="48%"> 
      <div align="center">字段值</div>
    </td>
    <td width="48%"> 
      <div align="center">拼音码</div>
    </td>
  </tr>
  <%if not objrs.eof then
  	do while not objrs.eof
  %>
  <tr align="center"> 
    <td width="3%" class="tablehead">
        <input type="checkbox" name="Dict<%=strTable%>_ID" value="<%=objrs.fields("Dict" & strTable & "_ID")%>">
      </td>
    <td width="48%">&nbsp;<%=objrs.fields("Dict_Value")%></td>
    <td width="48%">&nbsp;<%=objrs.fields("PY_Code")%></td>
  </tr>
  <%
  	objrs.movenext
  	loop
    end if%>
    <input type="hidden" name="meth" value="">
  </form>
</table>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -