PageRenderTime 60ms CodeModel.GetById 6ms RepoModel.GetById 1ms app.codeStats 0ms

/bond/Admin/BondComeToMarketQuery.asp

http://demoasp.googlecode.com/
ASP | 373 lines | 363 code | 10 blank | 0 comment | 3 complexity | 88630d3956853d0e3c8fbcd0c74ff599 MD5 | raw file
Possible License(s): BSD-3-Clause, LGPL-2.1 
    

  1. <%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>

    2. 

  2. <!--#include file="../Connections/b_con.asp" -->

    3. 

  3. <%

    4. 

  4. If request.Form("hf") =1 Then

    5. 

  5. 

    6. 

  6. 	Set rsSelect = Server.CreateObject("ADODB.Recordset")

    7. 

  7. 	rsSelect.ActiveConnection = MM_b_con_STRING

    8. 

  8. 	rsSelect.Source = "SELECT T_CPBasicData.CPID, T_CPBasicData.CPShortName, T_FirmInfo.FirmName, T_CPBasicData.CPTerm, T_CPBasicData.CPCirculateStartDate, T_CPBasicData.FirmID, T_CPBasicData.CPIssueStartDate FROM T_CPBasicData INNER JOIN T_FirmInfo ON T_CPBasicData.FirmID = T_FirmInfo.FirmID Where (T_CPBasicData.CPCirculateStartDate >= '"& request.Form("txtDate") &"') Order By CPID Desc"

    9. 

  9. 	rsSelect.CursorType = 0

    10. 

  10. 	rsSelect.CursorLocation = 2

    11. 

  11. 	rsSelect.LockType = 1

    12. 

  12. 	rsSelect.Open()

    13. 

  13. 	

    14. 

  14. 	While Not rsSelect.Eof

    15. 

  15. 		Select Case rsSelect(3)

    16. 

  16. 			Case 1

    17. 

  17. 				strTerm = "1?"

    18. 

  18. 			Case 0.75

    19. 

  19. 				strTerm = "9??"

    20. 

  20. 			Case 0.5

    21. 

  21. 				strTerm = "6??"

    22. 

  22. 			Case 0.25

    23. 

  23. 				strTerm = "3??"

    24. 

  24. 		End Select

    25. 

  25. 		strTableData = strTableData & "<tr><td height='7' align='left'></td></tr><tr><td height='15' align='left' valign='middle' class='news'><table width='95%' align='center' cellpadding='0' cellspacing='3'><tr><td width='15%' class='newsz'><a href='../2/101.asp?CID="& rsSelect(0) &"&FID="& rsSelect(5) &"' target='_blank'>"& rsSelect(0) &"</a></td><td width='15%' class='newsz'>"& rsSelect(1) &"</td><td width='35%' height='15' class='newsz'>"& rsSelect(2) &"</td></td><td width='5%' height='10' class='newsz'>"& strTerm &"</td></td><td width='15%' height='20' align='right' class='sj'>"& rsSelect(6) &"</td><td width='15%' height='20' align='right' class='sj'>"& rsSelect(4) &"</td></tr></table></td></tr>"

    26. 

  26. 		rsSelect.MoveNext

    27. 

  27. 	Wend

    28. 

  28. 		

    29. 

  29. 	rsSelect.Close()

    30. 

  30. 	Set rsSelect = Nothing

    31. 

  31. 

    32. 

  32. End If

    33. 

  33. %>

    34. 

  34. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

    35. 

  35. <html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/index.dwt" codeOutsideHTMLIsLocked="false" -->

    36. 

  36. <head>

    37. 

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

    38. 

  38. <!-- InstanceBeginEditable name="doctitle" -->

    39. 

  39. <title>???????</title>

    40. 

  40. <!-- InstanceEndEditable -->

    41. 

  41. <style type="text/css">

    42. 

  42. <!--

    43. 

  43. body {

    44. 

  44. 	margin-left: 0px;

    45. 

  45. 	margin-top: 0px;

    46. 

  46. 	margin-right: 0px;

    47. 

  47. 	margin-bottom: 0px;

    48. 

  48. }

    49. 

  49. .goBotom {

    50. 

  50. 	vertical-align: bottom;

    51. 

  51. }

    52. 

  52. -->

    53. 

  53. </style>

    54. 

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

    55. 

  55. <SCRIPT language=javascript>

    56. 

  56. function showsubmenu(sid)

    57. 

  57. {

    58. 

  58. whichEl = eval("submenu" + sid);

    59. 

  59. if (whichEl.style.display == "none")

    60. 

  60. {

    61. 

  61.  HideAll();

    62. 

  62. eval("submenu" + sid + ".style.display=\"\";");

    63. 

  63. }

    64. 

  64. else

    65. 

  65. {

    66. 

  66.  HideAll();

    67. 

  67. eval("submenu" + sid + ".style.display=\"none\";");

    68. 

  68. }

    69. 

  69. }

    70. 

  70. </SCRIPT>

    71. 

  71. 

    72. 

  72. <SCRIPT lanuage="JScript">

    73. 

  73. function HideAll()

    74. 

  74. {

    75. 

  75.   var NA=navigator.appName;

    76. 

  76.   //alert(i);

    77. 

  77.     if (NA=="Microsoft Internet Explorer")

    78. 

  78. 	{

    79. 

  79. 	//document.all("submenu1").style.display="none";

    80. 

  80. submenu02.style.display="none";

    81. 

  81. submenu03.style.display="none";

    82. 

  82. //pic3.src="index/plus.gif";

    83. 

  83. submenu01.style.display="none";

    84. 

  84. submenu04.style.display="none";

    85. 

  85. submenu05.style.display="none";

    86. 

  86. 

    87. 

  87. submenu07.style.display="none";

    88. 

  88. 	}

    89. 

  89. }</SCRIPT>

    90. 

  90. <!-- InstanceBeginEditable name="head" --><!-- InstanceEndEditable -->

    91. 

  91. </head>

    92. 

  92. 

    93. 

  93. <body>

    94. 

  94. <div align="center">

    95. 

  95.   <table width="984" border="0" cellspacing="0" cellpadding="0">

    96. 

  96.     <tr>

    97. 

  97.       <td><table width="986" border="0" cellspacing="0" cellpadding="0">

    98. 

  98.         <tr>

    99. 

  99.           <td width="986" height="20" valign="bottom"><table width="100%" border="0" cellspacing="0" cellpadding="0">

    100. 

  100.             <tr>

    101. 

  101.               <td width="214" rowspan="2" align="right" valign="bottom" class="bzen"><img src="../image/logo.gif" width="180" height="26" /></td>

    102. 

  102.               <td height="20" align="right" class="bzen">&nbsp;</td>

    103. 

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

    104. 

  104.             </tr>

    105. 

  105.             <tr>

    106. 

  106.               <td width="765" align="right" class="bzen"><a href="../Default.asp">????</a> <span class="STYLE2">|</span> <a href="../concats.asp">????</a><span class="STYLE2"> | </span><a href="../4/Default.asp">????</a><span class="STYLE2"> |</span> <a href="Rating/">????</a></td>

    107. 

  107.               <td width="7" align="right">&nbsp;</td>

    108. 

  108.             </tr>

    109. 

  109.             <tr>

    110. 

  110.               <td height="5" colspan="3"></td>

    111. 

  111.             </tr>

    112. 

  112.           </table></td>

    113. 

  113.         </tr>

    114. 

  114.         <tr>

    115. 

  115.           <td width="984" height="115" align="right" valign="bottom" background="../image/t.gif"><table width="30%" border="0" cellspacing="0" cellpadding="0">

    116. 

  116.             <tr>

    117. 

  117.               <td align="right" bgcolor="#5B7730"><span class="sp"><img src="../image/wl.gif" width="327" height="24" /></span></td>

    118. 

  118.             </tr>

    119. 

  119.             <tr>

    120. 

  120.               <td>&nbsp;</td>

    121. 

  121.             </tr>

    122. 

  122.           </table></td>

    123. 

  123.         </tr>

    124. 

  124.         <tr>

    125. 

  125.           <td height="8" valign="bottom"></td>

    126. 

  126.         </tr>

    127. 

  127.       </table></td>

    128. 

  128.     </tr>

    129. 

  129.     <tr>

    130. 

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

    131. 

  131.         <tr>

    132. 

  132.           <td width="185" align="center" valign="top"><table width="92%" border="0" cellspacing="0" cellpadding="0">

    133. 

  133.             <tr>

    134. 

  134.               <td width="11%" height="12" align="right">&nbsp;</td>

    135. 

  135.               <td width="53%" align="right"><img src="../image/x.gif" width="19" height="12" /></td>

    136. 

  136.               <td width="36%" align="right"><img src="../image/com.gif" width="51" height="12" /></td>

    137. 

  137.             </tr>

    138. 

  138.             <tr>

    139. 

  139.               <td height="10" colspan="3"></td>

    140. 

  140.             </tr>

    141. 

  141.             <tr>

    142. 

  142.               <td height="25" colspan="3"><table width="100%" height="25" border="0" cellpadding="0" cellspacing="0">

    143. 

  143.                 <tr>

    144. 

  144.                   <td width="13" bgcolor="#5B7730">&nbsp;</td>

    145. 

  145.                   <td width="150" align="left" bgcolor="#5B7730" class="bian"> &nbsp;&nbsp;

    146. 

  146. 				  	<% If Session("MemberName") <> "" Then

    147. 

  147. 						Response.Write "????" & Session("MemberName")

    148. 

  148. 				  		ELse

    149. 

  149. 							Response.Write "Login"

    150. 

  150. 						End If %></td>

    151. 

  151.                 </tr>

    152. 

  152.               </table></td>

    153. 

  153.             </tr>

    154. 

  154.             <tr>

    155. 

  155.               <td height="9" colspan="3"></td>

    156. 

  156.             </tr>

    157. 

  157.             <tr>

    158. 

  158.               <td colspan="3" class="bzen">

    159. 

  159. 			  <% If Session("MemberID") <> "" Then

    160. 

  160. 					Response.Write "<table width='95%' border='0' align='right' cellpadding='0' cellspacing='0'>" & _

    161. 

  161. 					"<tr>" & _

    162. 

  162. 					  "<td width='44%' height='25' align='left'>????</td>" & _

    163. 

  163. 					  "<td align='left'>" & Session("LastLogin") & "</td>" & _

    164. 

  164. 					"</tr>" 

    165. 

  165. 					If Session("Level") > 0 Then 

    166. 

  166. 						response.write "<tr>" & _

    167. 

  167. 						  "<td width='44%' height='25' align='left' colspan='2'><a href='../../Admin/index.asp' class='sj'>??????</a></td>" & _

    168. 

  168. 						"</tr>" 

    169. 

  169. 					End If

    170. 

  170. 					Response.Write "<tr>" & _

    171. 

  171. 					 "<td height='25' colspan='2' align='Left'><a href='../../ModifyUserInfo.asp' class='sj'>?????????</a>&nbsp;&nbsp;<a href='../../Logout.asp'>??</a></td>" & _

    172. 

  172. 					  "</tr>" & _

    173. 

  173. 				  "</table>"

    174. 

  174. 			  	Else

    175. 

  175. 					Response.Write "<form action='../../CheckUser.asp' method='post' name='form1' id='form1'>" & _

    176. 

  176. 					"<table width='95%' border='0' align='right' cellpadding='0' cellspacing='0'><tr>" & _

    177. 

  177.                   	"<td width='44%' height='25' align='left'>User ID: </td>" & _

    178. 

  178. 						 "<td width='56%' align='left'><input name='txtID' type='text' class='lxth3' id='txtID' size='10' /></td>" & _

    179. 

  179. 					"</tr>" & _

    180. 

  180. 					"<tr>" & _

    181. 

  181. 					  "<td height='25' align='left'>Password:</td>" & _

    182. 

  182. 					  "<td align='left'><input name='txtPwd' type='password' class='lxth3' id='txtPwd' size='10' /></td>" & _

    183. 

  183. 					"</tr>" & _

    184. 

  184. 					"<tr>" & _

    185. 

  185. 					 "<td height='25' colspan='2' align='right'><a href='../../UserRegi.asp'>Register</a>&nbsp;" & _

    186. 

  186. 						"<input type='image' class='goBotom' value='Login' src='../../image/ago.gif' width='26' height='16' border='0'>" & _

    187. 

  187. 						"&nbsp;&nbsp;&nbsp;</td>" & _

    188. 

  188. 					  "</tr>" & _

    189. 

  189. 				  "</table>" & _

    190. 

  190. 				  "</form>"

    191. 

  191. 				End If

    192. 

  192. 			  %></td>

    193. 

  193.             </tr>

    194. 

  194.             <tr>

    195. 

  195.               <td height="5" colspan="3"></td>

    196. 

  196.             </tr>

    197. 

  197.             <tr>

    198. 

  198.               <td colspan="3"><table width="100%" height="25" border="0" cellpadding="0" cellspacing="0">

    199. 

  199.                 <tr>

    200. 

  200.                   <td width="13" bgcolor="#5B7730">&nbsp;</td>

    201. 

  201.                   <td width="150" align="left" bgcolor="#5B7730" class="bian">&nbsp;&nbsp;QuickNav</td>

    202. 

  202.                 </tr>

    203. 

  203.               </table></td>

    204. 

  204.             </tr>

    205. 

  205.             <tr>

    206. 

  206.               <td height="7" colspan="3" align="left" class="newsz"></td>

    207. 

  207.             </tr>

    208. 

  208.             <tr>

    209. 

  209.               <td height="20" align="left" class="newsz">&nbsp;</td>

    210. 

  210.               <td height="20" colspan="2" align="left" class="newsz"  style="cursor:hand;"  onClick="showsubmenu('01')"><span class="cd" >????</span></td>

    211. 

  211.             </tr>

    212. 

  212.             <tr style="display:none;" id="submenu01" >

    213. 

  213.               <td height="10" align="left"><span class="newsz">&nbsp;&nbsp;&nbsp;&nbsp;</span></td>

    214. 

  214.               <td height="20" colspan="2" align="left"><table width="100%" border="0" cellspacing="0" cellpadding="0">

    215. 

  215.                 <tr>

    216. 

  216.                   <td width="11%">&nbsp;</td>

    217. 

  217.                   <td width="89%" height="20" class="bzen"><a href="../1/1.asp">????</a></td>

    218. 

  218.                 </tr>

    219. 

  219.                 <tr>

    220. 

  220.                   <td>&nbsp;</td>

    221. 

  221.                   <td height="20" class="bzen"><a href="../1/2.asp">????</a></td>

    222. 

  222.                 </tr>

    223. 

  223.                 <tr>

    224. 

  224.                   <td>&nbsp;</td>

    225. 

  225.                   <td height="20" class="bzen"><a href="../1/3.asp">????</a></td>

    226. 

  226.                 </tr>

    227. 

  227.               </table></td>

    228. 

  228.             </tr>

    229. 

  229.             <tr>

    230. 

  230.               <td height="10" align="left">&nbsp;</td>

    231. 

  231.               <td height="20" colspan="2" align="left"  style="cursor:hand;"   onClick="showsubmenu('02')"><span class="cd">????</span></td>

    232. 

  232.             </tr>

    233. 

  233.             <tr style="display:none;" id="submenu02">

    234. 

  234.               <td height="10" align="left"><span class="newsz">&nbsp;&nbsp;&nbsp;&nbsp;</span></td>

    235. 

  235.               <td height="20" colspan="2" align="left"><table width="100%" border="0" cellspacing="0" cellpadding="0">

    236. 

  236.                 <tr>

    237. 

  237.                   <td width="11%">&nbsp;</td>

    238. 

  238.                   <td width="89%" height="20" class="bzen"><a href="../2/1.asp">?????</a></td>

    239. 

  239.                 </tr>

    240. 

  240.                 <tr>

    241. 

  241.                   <td>&nbsp;</td>

    242. 

  242.                   <td height="20" class="bzen"><a href="#">ABS&amp;MBS</a></td>

    243. 

  243.                 </tr>

    244. 

  244.                 <tr>

    245. 

  245.                   <td>&nbsp;</td>

    246. 

  246.                   <td height="20" class="bzen"><a href="#">?????</a></td>

    247. 

  247.                 </tr>

    248. 

  248.                 <tr>

    249. 

  249.                   <td>&nbsp;</td>

    250. 

  250.                   <td height="20" class="bzen"><a href="../2/4.asp">????</a></td>

    251. 

  251.                 </tr>

    252. 

  252.                 <tr>

    253. 

  253.                   <td>&nbsp;</td>

    254. 

  254.                   <td height="20" class="bzen"><a href="../2/5.asp">????</a></td>

    255. 

  255.                 </tr>

    256. 

  256.               </table></td>

    257. 

  257.             </tr>

    258. 

  258.             <tr>

    259. 

  259.               <td height="10" align="left">&nbsp;</td>

    260. 

  260.               <td height="20" colspan="2" align="left" class="cd"  style="cursor:hand;"   onClick="showsubmenu('03')">????</td>

    261. 

  261.             </tr>

    262. 

  262.             <tr  style="display:none;" id="submenu03">

    263. 

  263.               <td height="10" align="left"><span class="newsz"></span></td>

    264. 

  264.               <td height="20" colspan="2" align="left"><table width="100%" border="0" cellspacing="0" cellpadding="0">

    265. 

  265.                 <tr>

    266. 

  266.                   <td width="11%">&nbsp;</td>

    267. 

  267.                   <td width="89%" height="20" class="bzen"><a href="../3/1.asp">????<span lang="EN-US" xml:lang="EN-US"></span></a></td>

    268. 

  268.                 </tr>

    269. 

  269.                 <tr>

    270. 

  270.                   <td>&nbsp;</td>

    271. 

  271.                   <td height="20" class="bzen"><a href="../3/2.asp">????</a></td>

    272. 

  272.                 </tr>

    273. 

  273.                 

    274. 

  274.               </table></td>

    275. 

  275.             </tr>

    276. 

  276.             <tr>

    277. 

  277.               <td height="10" align="left">&nbsp;</td>

    278. 

  278.               <td height="20" colspan="2" align="left" class="cd"  style="cursor:hand;"  onClick="showsubmenu('04')">????</td>

    279. 

  279.             </tr>

    280. 

  280.             <tr style="display:none;" id="submenu04">

    281. 

  281.               <td height="10" align="left"><span class="newsz"></span></td>

    282. 

  282.               <td height="20" colspan="2" align="left"><table width="100%" border="0" cellspacing="0" cellpadding="0">

    283. 

  283.                 <tr>

    284. 

  284.                   <td width="11%">&nbsp;</td>

    285. 

  285.                   <td width="89%" height="20" class="bzen"><a href="../4/Default.asp?Btype=4">????????</a></td>

    286. 

  286.                 </tr>

    287. 

  287.                 <tr>

    288. 

  288.                   <td>&nbsp;</td>

    289. 

  289.                   <td height="20" class="bzen"><a href="../4/Default.asp?Btype=5">????</a></td>

    290. 

  290.                 </tr>

    291. 

  291.                 <tr>

    292. 

  292.                   <td>&nbsp;</td>

    293. 

  293.                   <td height="20" class="bzen"><p><a href="../4/Default.asp?Btype=6">??????</a></p></td>

    294. 

  294.                 </tr>

    295. 

  295. 

    296. 

  296.               </table></td>

    297. 

  297.             </tr>

    298. 

  298.             <tr>

    299. 

  299.               <td height="10" align="left">&nbsp;</td>

    300. 

  300.               <td height="20" colspan="2" align="left" class="cd"  style="cursor:hand;"   onClick="showsubmenu('05')">????</td>

    301. 

  301.             </tr>

    302. 

  302.             <tr  style="display:none;" id="submenu05">

    303. 

  303.               <td height="20" align="left"></td>

    304. 

  304.               <td height="20" colspan="2" align="left"><table width="100%" border="0" cellspacing="0" cellpadding="0">

    305. 

  305.                 <tr>

    306. 

  306.                   <td width="11%">&nbsp;</td>

    307. 

  307.                   <td width="89%" height="20" class="bzen"><a href="../5/1.asp">DX??</a></td>

    308. 

  308.                 </tr>

    309. 

  309.                 <tr>

    310. 

  310.                   <td>&nbsp;</td>

    311. 

  311.                   <td height="20" class="bzen"><p><a href="../concats.asp">????</a></p>                    </td>

    312. 

  312.                 </tr>

    313. 

  313. 

    314. 

  314.               </table></td>

    315. 

  315.             </tr>

    316. 

  316.             <tr>

    317. 

  317.               <td height="20" align="left"></td>

    318. 

  318.               <td height="20" colspan="2" align="left" class="cd"  style="cursor:hand;"><a href="../6/case.asp"  class="cd">????</a></td>

    319. 

  319.             </tr>

    320. 

  320.  			<tr>

    321. 

  321.               <td height="20" align="left"></td>

    322. 

  322.               <td height="20" colspan="2" align="left" class="cd"  style="cursor:hand;" onClick="showsubmenu('07')">????</td>

    323. 

  323.             </tr>

    324. 

  324.             <tr style="display:none;" id="submenu07">

    325. 

  325.               <td height="20" align="left"></td>

    326. 

  326.               <td height="20" colspan="2" align="left"><table width="100%" border="0" cellspacing="0" cellpadding="0">

    327. 

  327.                 <tr>

    328. 

  328.                   <td width="11%">&nbsp;</td>

    329. 

  329.                   <td width="89%" height="20" class="bzen"><a href="../7/open.asp" class="bzen">????</a></td>

    330. 

  330.                 </tr>

    331. 

  331.                 <tr>

    332. 

  332.                   <td>&nbsp;</td>

    333. 

  333.                   <td height="20" class="bzen"><p><a href="../7/close.asp">????</a></p></td>

    334. 

  334.                 </tr>

    335. 

  335.               </table></td>

    336. 

  336.             </tr>

    337. 

  337.          </table></td>

    338. 

  338.           <td align="center" valign="top" class="sp"><!-- InstanceBeginEditable name="1" -->

    339. 

  339.             <form id="form1" name="form1" method="post" action="BondComeToMarketQuery.asp">

    340. 

  340.               <p>????

    341. 

  341.                 <input name="txtDate" type="text" class="newsz" id="txtDate" value="<% If request.Form("txtDate") = "" Then

    342. 

  342. 																							response.Write Date()

    343. 

  343. 																						Else

    344. 

  344. 																							response.Write request.Form("txtDate")

    345. 

  345. 																						End If %>" />

    346. 

  346.                 <input name="hf" type="hidden" id="hf" value="1" />

    347. 

  347.               </p>

    348. 

  348.               <p>

    349. 

  349.                 <label>

    350. 

  350.                 <input type="submit" name="Submit" value="??" />

    351. 

  351.                 </label>

    352. 

  352.                 <a href="index.asp">??</a></p>

    353. 

  353.             </form>

    354. 

  354.             <table width="80%" border="0" cellspacing="0" cellpadding="0">

    355. 

  355.               <%= strTableData %>

    356. 

  356.               <tr>

    357. 

  357.                 <td height="8" align="left" valign="middle">&nbsp;</td>

    358. 

  358.               </tr>

    359. 

  359.             </table>

    360. 

  360.           <!-- InstanceEndEditable --></td>

    361. 

  361.           </tr>

    362. 

  362.       </table></td>

    363. 

  363.     </tr>

    364. 

  364.     <tr>

    365. 

  365.       <td height="10">&nbsp;</td>

    366. 

  366.     </tr>

    367. 

  367.     <tr>

    368. 

  368.       <td height="35" align="center" valign="middle" bgcolor="#5B7730" class="baid">Copyright (C)2006 All rights reserved</td>

    369. 

  369.     </tr>

    370. 

  370.   </table>

    371. 

  371. </div>

    372. 

  372. </body>

    373. 

  373. <!-- InstanceEnd --></html>

    374. 

  374.