/group/ccsjt/ccs_JT_lastyear/cwmain.asp

http://github.com/zhaowe/bc · ASP · 409 lines · 364 code · 37 blank · 8 comment · 29 complexity · c613b189ba0c83b09bfbc505a4c831e5 MD5 · raw file

  1. <%@ Language=VBScript %>
  2. <%
  3. if trim(session("UID"))<>"" then
  4. dim objD
  5. set ObjD=server.CreateObject ("Com_UserManage.ClsUserManage")
  6. VerifyOk=objD.VerifyUserFunction (session("UID"),"ccs_gscn")
  7. if VerifyOk=false then
  8. session("errorNo")="000002"
  9. Response.Redirect "../sorry/sorry.asp"
  10. end if
  11. else
  12. session("errorNo")="000001"
  13. Response.Redirect "../sorry/sorry.asp"
  14. end if
  15. %>
  16. <html>
  17. <head>
  18. <title>ÉîÛÚ¹«Ë¾Ô¤Ëã¹ÜÀíϵͳ</title>
  19. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  20. <style type="text/css">
  21. .px10 { font-size: 10px; line-height: 150%}
  22. .px12 { font-size: 12px; line-height: 150%}
  23. .px14 { font-size: 14px; line-height: 150%}
  24. .px16 { font-size: 16px; line-height: 150%}
  25. .px18 { font-size: 18px; line-height: 150%}
  26. .px24 { font-size: 24px; line-height: 150%}
  27. .px36 { font-size: 36px; line-height: 150%}
  28. .px48 { font-size: 48px; line-height: 150%}
  29. .px72 { font-size: 72px; line-height: 150%}
  30. body { font-size: 12px; line-height: 150%}
  31. p { font-size: 12px; line-height: 150%}
  32. td { font-size: 9px; line-height: 150%}
  33. input { font-size: 12px; line-height: 150%}
  34. select { font-size: 12px; line-height: 150%}
  35. .content4{FONT-SIZE:10PT; LINE-HEIGHT:9PT;}
  36. .contentindex{font-family: "ËÎÌå";FONT-SIZE:9pt; LINE-HEIGHT:11pt;}
  37. .enter {COLOR: #FFAF02; FONT-FAMILY: "ËÎÌå", "Arial", "Times New Roman"; FONT-SIZE: 11pt; TEXT-DECORATION: none ;font-weight: bold}
  38. .head1{FONT-SIZE:11pt; LINE-HEIGHT:18pt; font-weight: bold; }
  39. .head2{FONT-SIZE:10pt; LINE-HEIGHT:14pt; font-weight: bold; }
  40. .contentsmall{FONT-SIZE:9pt; LINE-HEIGHT:12pt;}
  41. .nav{FONT-SIZE:9pt; LINE-HEIGHT:10pt; color: #999999}
  42. .content{FONT-SIZE:10pt; LINE-HEIGHT:14pt;color: #000000:#000000}
  43. .news{FONT-SIZE:10pt; LINE-HEIGHT:14pt; color; color: #000000:#000000}
  44. .contentbig{FONT-SIZE:11pt; LINE-HEIGHT:14pt;}
  45. .info{ font-size: 9pt; line-height: 9pt; color: #FFFFFF}
  46. .footer{ font-size: 9pt; line-height: 12pt; font-weight: normal}
  47. .search { font-size: 10pt; line-height: 14pt; color: #ffffff; background-color: #75AEE3}
  48. .whitehead { font-size: 12pt; line-height: 15pt; color: #FFFFFF}
  49. .whitecontent { font-size: 10pt; line-height: 14pt; color: #ffffff}
  50. .bgcolor { background-color: #006797}
  51. .leftline { background-color: #FD7D04}
  52. a:active { color: #000000;; text-decoration: none}
  53. a:visited { color: #000000; font-weight: normal;; text-decoration: none}
  54. a:link { color: #000000; font-weight: normal; ; text-decoration: none}
  55. a.homepage:link { color: #000000; font-weight: normal;}
  56. a.homepage:visited { color: #000000; font-weight: normal;}
  57. a.homepage:active { color: #000000; font-weight: normal;}
  58. a.homepage:hover { color: #000000; font-weight: normal;}
  59. </style>
  60. <script language="JavaScript">
  61. <!--
  62. function edit(sn)
  63. {
  64. tzurl="hx_edit.asp?sn="+sn;
  65. window.open(tzurl,"xx","width=600,left=200,top=10,height=300,scrollbars=no");
  66. }
  67. function hx(sn)
  68. {
  69. tzurl="hx_hx.asp?sn="+sn;
  70. window.open(tzurl,"xx","width=600,left=200,top=10,height=300,scrollbars=no");
  71. }
  72. function back(sn)
  73. {
  74. tzurl="hx_back.asp?sn="+sn;
  75. window.open(tzurl,"xx","width=600,left=200,top=10,height=300,scrollbars=no");
  76. }
  77. function MM_preloadimagess() { //v3.0
  78. var d=document; if(d.imagess){ if(!d.MM_p) d.MM_p=new Array();
  79. var i,j=d.MM_p.length,a=MM_preloadimagess.arguments; for(i=0; i<a.length; i++)
  80. if (a[i].indexOf("#")!=0){ d.MM_p[j]=new images; d.MM_p[j++].src=a[i];}}
  81. }
  82. function MM_swapImgRestore() { //v3.0
  83. var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
  84. }
  85. function MM_findObj(n, d) { //v4.01
  86. var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
  87. d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  88. if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  89. for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  90. if(!x && d.getElementById) x=d.getElementById(n); return x;
  91. }
  92. function MM_swapimages() { //v3.0
  93. var i,j=0,x,a=MM_swapimages.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
  94. if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
  95. }
  96. function xx(s,y,x,a,b,c) { //v3.0
  97. //s=depar.value ;
  98. //y=nian.value ;
  99. surl="cwmain.asp?depar="+s+"&passcode="+y+"&bxcode="+x+"&payway="+a+"&price="+b+"&tabid="+c;
  100. window.location.href (surl);
  101. }
  102. //-->
  103. </script>
  104. </head>
  105. <body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" text="#000000" link="#3333FF" onLoad="MM_preloadimagess('images/bt_01_off.gif','images/bt_02_on.gif','images/bt_03_on.gif','images/bt_04_on.gif','images/bt_05_on.gif')">
  106. <table width="100%" border="0" cellspacing="0" cellpadding="0">
  107. <tr>
  108. <td background="images/obj_hed1.gif">
  109. <table border="0" cellspacing="0" cellpadding="0" width="800">
  110. <tr>
  111. <td width="10"><img src="images/spacer.gif" width="10" height="35"></td>
  112. <td width="171"><img src="images/obj_maintitle.gif" width="171" height="30" border="0"></td>
  113. <td width="10"><img src="images/spacer.gif" width="10" height="35"></td>
  114. <td width="605">
  115. <table border="0" cellspacing="0" cellpadding="3" name="menubutton">
  116. <tr>
  117. <td>&nbsp;</td>
  118. <td>&nbsp;</td>
  119. <td><a href="cwmain.asp" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapimages('images1','','images/baoxiao1.gif',1)"><img src="images/baoxiao.gif" width="120" height="24" border="0" name="images1"></a></td>
  120. <td><a href="cx/ccs_gscxy_index.asp" target="_blank" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapimages('images4','','images/gltj2.jpg',1)"><img src="images/gltj1.jpg" width="120" height="24" border="0" name="images4"></a></td>
  121. </tr>
  122. </table>
  123. </td>
  124. </tr>
  125. </table>
  126. </td>
  127. </tr>
  128. <tr>
  129. <td bgcolor="#FF6600"><img src="images/spacer.gif" width="10" height="2"></td>
  130. </tr>
  131. </table>
  132. <table border="0" cellspacing="0" cellpadding="0" width="700">
  133. <tr>
  134. <td width="140"><img src="images/obj_hed2_left.jpg" width="140" height="98"></td>
  135. <td width="30"><img src="images/obj_hed2_center2.jpg" width="30" height="98"></td>
  136. <td width="470" valign="top" background="images/obj_hed2_right.jpg">
  137. <table width="300" border="0" cellspacing="0" cellpadding="0" background>
  138. <tr>
  139. <td><img src="images/spacer.gif" width="330" height="5"></td>
  140. <td><img src="images/spacer.gif" width="130" height="5"></td>
  141. </tr>
  142. <tr>
  143. <td valign="top">
  144. <table border="0" cellspacing="0" cellpadding="0" name="banner">
  145. <tr>
  146. <td colspan="2"><img src="images/spacer.gif" width="10" height="24"></td>
  147. </tr>
  148. <tr>
  149. <td><img src="images/ba1_point.gif" width="35" height="39"></td>
  150. <td><img src="images/lizztp1.gif" width="205" height="39"></td>
  151. </tr>
  152. </table>
  153. </td>
  154. <td align="right">
  155. <table border="0" cellspacing="0" cellpadding="0">
  156. <tr>
  157. <td><img src="images/spacer.gif" width="20" height="53"></td>
  158. </tr>
  159. <tr>
  160. <td><a href><img src="images/bxsp.gif" width="138" height="28" border="0"></a></td>
  161. </tr>
  162. </table>
  163. </td>
  164. </tr>
  165. </table>
  166. </td>
  167. <td width="470" valign="top"><img src="images/obj_hed2_right-.jpg" width="60" height="73">
  168. </td>
  169. </tr>
  170. </table>
  171. <table width="740" border="0" cellspacing="0" cellpadding="0" height="90%">
  172. <tr>
  173. <td bgcolor="#000033" width="140" valign="top">
  174. <table border="0" cellspacing="0" cellpadding="0">
  175. <tr>
  176. <td background="images/obj_left.jpg">
  177. <table border="0" cellspacing="0" cellpadding="0">
  178. <tr>
  179. <td><img src="images/spacer.gif" width="140" height="45"></td>
  180. </tr>
  181. </table>
  182. </td>
  183. </tr>
  184. </table>
  185. <table border="0" cellspacing="5" cellpadding="0" width="140">
  186. <tr>
  187. <td>
  188. <hr width="130">
  189. </td>
  190. </tr>
  191. <tr>
  192. <td>
  193. <table width="130" border="0" cellspacing="0" cellpadding="1">
  194. <tr>
  195. <td><img src="images/a.gif" WIDTH="28" HEIGHT="28"></td>
  196. <td><a href="cwmain.asp"><font class="px14" color="#FFFFFF">δºËÏú²éѯ</font></a></td>
  197. </tr>
  198. <tr>
  199. <td><img src="images/a.gif" WIDTH="28" HEIGHT="28"></td>
  200. <td><a href="query1.asp"><font class="px14" color="#FFFFFF">ÒѺËÏú²éѯ</font></a></td>
  201. </tr>
  202. </table>
  203. </td>
  204. </tr>
  205. <tr>
  206. <td>
  207. <hr width="130">
  208. </td>
  209. </tr>
  210. </table>
  211. </td>
  212. <td width="5"><img src="images/spacer.gif" width="10" height="5"></td>
  213. <td width="595" valign="top">
  214. <table align="center" style="BORDER-RIGHT: #4983a0 1px solid; BORDER-TOP: #4983a0 1px solid; BORDER-LEFT: #4983a0 1px solid; BORDER-BOTTOM: #4983a0 1px solid" height="30" cellSpacing="0" cellPadding="0" width="850" border="0">
  215. <tr height="30" bgcolor="#E3E9EE" align="left">
  216. <td > <font class="px12" color="black">&nbsp;&nbsp;²¿ÃÅ£º<select name="depar" style="HEIGHT: 22px; WIDTH: 100px">
  217. <option selected value="È«²¿">È«²¿</option>
  218. <%
  219. Set objConn = Server.CreateObject("ADODB.Connection")
  220. objConn.Open Application("OledbStr")
  221. Set obj=server.CreateObject ("ADODB.Recordset")
  222. obj.LockType=3
  223. obj.CursorType=3
  224. set obj.activeConnection=objConn
  225. sql="Select * From CompanyLocale where companyid not in (6,7,11,17,21,26,27,28) order by companyname"
  226. obj.Source=sql
  227. obj.Open
  228. obj.MoveFirst
  229. while not obj.EOF
  230. %>
  231. <option value="<%=obj("CompanyName")%>"><%=obj("CompanyName")%></option>
  232. <%
  233. obj.movenext
  234. wend
  235. obj.close
  236. %>
  237. </select>&nbsp;&nbsp;
  238. ¾­°ìÈËÔ±¹¤ºÅ£º<INPUT type="text" name="passcode" size=8>
  239. &nbsp;&nbsp;
  240. ±¨ÏúÈËÔ±¹¤ºÅ£º<INPUT type="text" name="bxcode" size=8>
  241. &nbsp;&nbsp;</br>
  242. &nbsp;&nbsp;¸¿î·½Ê½£º<select name="payway">
  243. <OPTION value="ÏÖ½ð"><font color=black class="px14">ÏÖ½ð</OPTION>
  244. <OPTION value="ÒøÐÐ"><font color=black class="px14">ÒøÐÐ</OPTION>
  245. <OPTION value="ÄÚ²¿ÍùÀ´"><font color=black class="px14">ÄÚ²¿ÍùÀ´</OPTION>
  246. <OPTION value="תÕÊ"><font color=black class="px14">תÕÊ</OPTION>
  247. </select>
  248. &nbsp;&nbsp;½ð<INPUT type="text" name="price" size=8>
  249. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
  250. ±¨Ïúµ¥ºÅ£º<INPUT type="text" name="tabid" size=12>
  251. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  252. <input type="button" name="action" value="²éѯ" onclick="javascript:xx(depar.value,passcode.value,bxcode.value,payway.value,price.value,tabid.value)">
  253. </td>
  254. </tr>
  255. </table>
  256. <%
  257. depar=trim(Request.QueryString("depar"))
  258. if depar<>"È«²¿" then
  259. sql1="and mnydepm='"&depar&"'"
  260. end if
  261. passcode=trim(Request.QueryString("passcode"))
  262. if passcode<>"" then
  263. sql2="and passcode='"&passcode&"'"
  264. end if
  265. bxcode=trim(Request.QueryString("bxcode"))
  266. if bxcode<>"" then
  267. sql3="and bxcode='"&bxcode&"'"
  268. end if
  269. payway=trim(Request.QueryString("payway"))
  270. if payway<>"È«²¿" then
  271. sql4="and payway='"&payway&"'"
  272. end if
  273. price=trim(Request.QueryString("price"))
  274. if price<>"" then
  275. sql5="and price=convert(money,'"&price&"')"
  276. end if
  277. tabid=trim(Request.QueryString("tabid"))
  278. if tabid<>"" then
  279. sql6="and tabid='"&tabid&"'"
  280. end if
  281. %>
  282. <%
  283. Set objConn = Server.CreateObject("ADODB.Connection")
  284. objConn.Open Application("OledbStr")
  285. Set obj=server.CreateObject ("ADODB.Recordset")
  286. obj.LockType=3
  287. obj.CursorType=3
  288. set obj.activeConnection=objConn
  289. sql="select * from cwys_infoin where ifhandin='ÊÇ' and ifhx='·ñ'"+sql1+sql2+sql3+sql4+sql5+sql6+"order by djdate desc"
  290. obj.Source=sql
  291. obj.Open
  292. %>
  293. <% if not obj.eof then%>
  294. <table align="center" style="BORDER-RIGHT: #4983a0 1px solid; BORDER-TOP: #4983a0 0px solid; BORDER-LEFT: #4983a0 1px solid; BORDER-BOTTOM: #4983a0 1px solid" cellSpacing="1" cellPadding="1" width="850" border="0">
  295. <tr height="20" bgcolor="#E3E9EE" align="left">
  296. <td ><font class="px12" color="blue">²Ù×÷</font></td>
  297. <td ><font class="px12" color="black">²¿ÃÅ</font></td>
  298. <td ><font class="px12" color="black">·ÑÓÃÆÚ¼ä</font></td>
  299. <td ><font class="px12" color="black">¸¿î·½Ê½</font></td>
  300. <td ><font class="px12" color="black">¿ÆÄ¿</font></td>
  301. <td ><font class="px12" color="black">½ðî</font></td>
  302. <td ><font class="px12" color="black">¼òҪ˵Ã÷</font></td>
  303. <td ><font class="px12" color="black">±¨ÏúÈË</font></td>
  304. <td ><font class="px12" color="black">µÇ¼ÇÈË</font></td>
  305. <td ><font class="px12" color="black">¾­°ìÈË</font></td>
  306. <td ><font class="px12" color="black">µÇ¼Çʱ¼ä</font></td>
  307. <td ><font class="px12" color="blue">ºËÏú</font></td>
  308. <td ><font class="px12" color="blue">ÍË»Ø</font></td>
  309. </tr>
  310. <%
  311. obj.MoveFirst
  312. while not obj.EOF
  313. %>
  314. <%
  315. 'Set Conn = Server.CreateObject("ADODB.Connection")
  316. 'Conn.Open Application("OledbStr")
  317. 'Set obj1=server.CreateObject ("ADODB.Recordset")
  318. 'obj1.LockType=3
  319. 'obj1.CursorType=3
  320. 'set obj1.activeConnection=Conn
  321. 'obj1.Source="select * FROM cwys_km where fkmshuom='"&obj("mnykm")&"' and depar='"&obj("mnydepm")&"' and nian='"&obj("mnyyear")&"'"
  322. 'obj1.Open
  323. %>
  324. <% 'if obj1.eof then%>
  325. <%'else%>
  326. <tr height="20" bgcolor="#E3E9EE" align="left">
  327. <td ><input type="button" value="ÐÞ¸Ä" onclick="javascript: edit(<%=obj("record_id")%>)" id=button1 name=button1></td>
  328. <td ><font class="px12" color="black"><%=obj("mnydepm")%></font></td>
  329. <td ><font class="px12" color="black"><%=obj("mnyyear")%>Äê<%=month(obj("mnytime"))%>ÔÂ</font></td>
  330. <td ><font class="px12" color="black"><%=obj("payway")%></font></td>
  331. <td ><font class="px12" color="black"><%=obj("mnykm")%></font></td>
  332. <td ><font class="px12" color="black"><%=obj("price")%></font></td>
  333. <td ><font class="px12" color="black"><%=obj("mnynote")%></font></td>
  334. <td ><font class="px12" color="black"><%=obj("bxname")%></font></td>
  335. <td ><font class="px12" color="black"><%=obj("djname")%></font></td>
  336. <td ><font class="px12" color="black"><%=obj("passname")%></font></td>
  337. <td ><font class="px12" color="black"><%=obj("djdate")%></font></td>
  338. <td ><input type="button" value="ºËÏú" onclick="javascript: hx(<%=obj("record_id")%>)" id=button1 name=button1></td>
  339. <td ><input type="button" style="background-color: #E0E0E0; color: red;class=px14; border: 0 solid #9E9E9E" value="ÍË»Ø" onclick="javascript: back(<%=obj("record_id")%>)" id=button1 name=button1></td>
  340. </tr>
  341. <%'end if%>
  342. <%'obj1.Close%>
  343. <%
  344. obj.movenext
  345. wend
  346. %>
  347. </table>
  348. <%end if%>
  349. <br>
  350. <br>
  351. <br>
  352. <br>
  353. <br>
  354. <br>
  355. <br>
  356. <br>
  357. <br>
  358. <br>
  359. <br>
  360. <br> <br> <br>
  361. <br> <br> <br>
  362. <table border="0" cellspacing="0" cellpadding="0" align="center">
  363. <tr>
  364. <td><font class="px12">Copyright 2006, ÖйúÄÏ·½º½¿ÕÉîÛÚ¹«Ë¾ÐÅÏ¢¹¤³Ì²¿</font></td>
  365. </tr>
  366. </table>
  367. <p>¡¡</p>
  368. </td>
  369. </tr>
  370. </table>
  371. </body>
  372. </html>