Count.aspx 8.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277
  1. <%@ Page Language="C#" Debug="true" EnableEventValidation="false" AutoEventWireup="true" CodeFile="Count.aspx.cs" Inherits="Count" %>
  2. <!doctype html>
  3. <html lang="en">
  4. <head>
  5. <title>统计报表</title>
  6. <meta http-equiv="Content-Type" content="text/html;charset=utf-8" >
  7. <link href="css/ASPNET2.0BaseCss.css" rel="stylesheet" type="text/css" /> <script language="javascript">
  8. function preview() {
  9. bdhtml = window.document.body.innerHTML;
  10. sprnstr = "<!--startprint-->";
  11. eprnstr = "<!--endprint-->";
  12. prnhtml = bdhtml.substr(bdhtml.indexOf(sprnstr) + 17);
  13. prnhtml = prnhtml.substring(0, prnhtml.indexOf(eprnstr));
  14. window.document.body.innerHTML = prnhtml;
  15. window.print();
  16. //prnform.htext.value=prnhtml;
  17. //prnform.submit();
  18. //alert(prnhtml);
  19. }
  20. </script>
  21. <link rel="stylesheet" href="css/dataTable.css" media="screen">
  22. <style type="text/css">
  23. body {
  24. margin: 30px;
  25. font-family: "Trebuchet MS", Arial, Helvetica, sans-serif;
  26. }
  27. /* Style the form with a coloured background (and a gradient for Gecko/WebKit browsers), along with curved corners and a drop shadow */
  28. form {
  29. width: 92%;
  30. margin: 0 auto;
  31. padding: 20px;
  32. overflow: auto;
  33. color: #3e4a49;
  34. background-color: #f5eedb;
  35. background: -webkit-gradient( linear, left bottom, left top, color-stop(0,#f5eedb), color-stop(1, #faf8f1) );
  36. background: -moz-linear-gradient( center bottom, #f5eedb 0%, #faf8f1 100% );
  37. border-radius: 10px;
  38. -moz-border-radius: 10px;
  39. -webkit-border-radius: 10px;
  40. box-shadow: 0 0 .5em rgba(0, 0, 0, .8);
  41. -moz-box-shadow: 0 0 .5em rgba(0, 0, 0, .8);
  42. -webkit-box-shadow: 0 0 .5em rgba(0, 0, 0, .8);
  43. }
  44. /* Give form elements consistent margin, padding and line height */
  45. form ul {
  46. list-style: none;
  47. margin: 0;
  48. padding: 0;
  49. }
  50. form ul li {
  51. margin: .9em 0 0 0;
  52. padding: 0;
  53. }
  54. form * {
  55. line-height: 1em;
  56. }
  57. /* Form heading */
  58. form h2 {
  59. margin: 0 0 1.5em 0;
  60. padding: 0;
  61. font-size:32px;
  62. font-family:"黑体";
  63. text-align:center;
  64. color:#White;
  65. text-shadow:#000 2px 2px 5px, #FFFFFF -1px -1px 8px,2px 2px 6px #000000;
  66. }
  67. /* Give each fieldset a darker background, dark curved border and plenty of space */
  68. /*<!--
  69. fieldset {
  70. padding: 0 20px 20px;
  71. margin: 0 0 20px;
  72. border: 2px solid #593131;
  73. background: #eae1c0;
  74. border-radius: 10px;
  75. -moz-border-radius: 10px;
  76. -webkit-border-radius: 10px;
  77. }
  78. -->*/
  79. fieldset
  80. {
  81. text-align:center;
  82. height:auto;
  83. border:#06F 1px groove;
  84. margin:0 auto;
  85. margin-top:10px;
  86. border-radius:15px;
  87. box-shadow:#CCC 6px 6px;
  88. padding:10px;
  89. font-size:12px;
  90. background-color:White;
  91. }
  92. /* Give each fieldset legend a nice curvy green box with white text */
  93. legend {
  94. color: #fff;
  95. background: #8fb98b;
  96. font-family: Arial, Helvetica, sans-serif;
  97. font-size: 0.9em;
  98. font-weight: bold;
  99. text-align: center;
  100. padding: 5px;
  101. margin: 0;
  102. width: AUTO;
  103. border: 2px solid #593131;
  104. border-radius: 5px;
  105. -moz-border-radius: 5px;
  106. -webkit-border-radius: 5px;
  107. }
  108. /* The field labels */
  109. label {
  110. display: block;
  111. float: left;
  112. clear: left;
  113. text-align: right;
  114. width: 30%;
  115. padding: .4em 0 0 0;
  116. margin: .15em .5em 0 0;
  117. }
  118. select {
  119. font-size: 1em;
  120. height: 30px;
  121. }
  122. .scroll-parent {
  123. margin: 40px;
  124. height: 300px;
  125. width: 350px;
  126. display: inline-block;
  127. overflow: auto;
  128. border: 2px solid #eee;
  129. padding: 40px;
  130. }
  131. body, th, td { font-family: Arial, Verdana, sans-serif; font-size: 0.9em; }
  132. a:link, a:visited { color: #59B337; }
  133. a:hover, a:active, a:focus { color: #000000; }
  134. table.dataTable tr.marked { background-color: #FFD900; }
  135. </style>
  136. <!-- jquery packed -->
  137. <script type="text/javascript" src="css/jquery-1.2.3.pack.js"></script>
  138. <!-- tableRowCheckboxToggle -->
  139. <script type="text/javascript" src="css/tableRowCheckboxToggle.js"></script>
  140. </head>
  141. <body>
  142. <div id="formbox">
  143. <form id="formpersonal" runat="server">
  144. <div class="form">
  145. <h2>数据统计</h2>
  146. <div align="center">
  147. <OBJECT id=WebBrowser classid=CLSID:8856F961-340A-11D0-A96B-00C04FD705A2 width=1 height=1>&nbsp;</OBJECT>
  148. <input type="button" name="print" value="预览并打印" onclick="preview()">&nbsp;
  149. <asp:Button ID="Button3" runat="server" onclick="Button3_Click" Text="导出为WORD文档" />
  150. </div>
  151. <fieldset class=fieldsetQuery style="background-color: #E7F4F8">
  152. <h3>
  153. <table>
  154. <tr>
  155. <td> <div title="选择部门(如未显示列表输入部门),如计算机系">部门:<input type="text" id="sDemp" list="sDemplist" name="sDemp" placeholder="选择部门" required autofocus maxlength="18" style="width:120px; height:30px;" runat="server"/>
  156. <datalist id="sDemplist">
  157. <option value="计算机系" />
  158. <option value="经管系" />
  159. <option value="机械系" />
  160. <option value="电气系" />
  161. <option value="外语系" />
  162. <option value="基础部" />
  163. <option value="全院" />
  164. </datalist></div>
  165. </td>
  166. <td>
  167. <div title="输入报表名:如第1季度、第4月">
  168. 报表名: <input type="text" id="ReportName" placeholder="报表名:如第1季度" required autofocus maxlength="48" style="width:120px; height:30px;" runat="server"/>
  169. </div></td>
  170. <td> <div title="输入报表起始时间:如第2017-9-10">
  171. 从<input type="text" id="tbStartTime" name="tbStartTime" placeholder="如2017-9-1" required autofocus maxlength="38" style="width:150px; height:30px;" runat="server" />
  172. </div> </td>
  173. <td> <div title="输入报表结束时间:如第2017-12-30">
  174. 到 <input type="text" id="tbEndTime" name="tbEndTime" placeholder="输入结束时间:如2017-12-31" required autofocus maxlength="38" style="width:150px; height:30px;" runat="server" />
  175. </div> </td>
  176. <td>
  177. <asp:Button ID="Button1" runat="server" Text="生成报表" onclick="Button1_Click"
  178. Height="27px" Width="96px" /></td>
  179. <td>&nbsp;
  180. </td>
  181. </tr>
  182. </table>
  183. </h3>
  184. </fieldset>
  185. <!--startprint-->
  186. <div style="margin: 0 auto;" id="mainContent">
  187. <div class=WordSection1>
  188. <asp:Panel ID="Panel1" Visible="false" runat="server">
  189. <p align=center style='text-align:center'><b style='mso-bidi-font-weight:normal'><span style='font-size:14.0pt;font-family:黑体'><asp:Literal ID="Literal2" runat="server"></asp:Literal> </span></b></p>
  190. <table border="1" cellpadding="0" cellspacing="0" style="background-color:White;border-color:#3366CC;border-width:1px;border-style:None;width:98%;border-collapse:collapse;">
  191. <tr style="color:#CCCCFF;background-color:#003399;font-weight:bold;height:32px;white-space:nowrap;">
  192. <th scope="col">系部</th>
  193. <th scope="col">督导会议</th>
  194. <th scope="col">听课次数</th>
  195. <th scope="col">评课次数</th>
  196. <th scope="col">督学次数</th>
  197. <th scope="col">教学检查次数</th>
  198. <th scope="col">项目评审次数</th>
  199. <th scope="col">督导培训交流次数</th>
  200. <th scope="col">其它</th>
  201. </tr>
  202. <tr style="color:#003399;background-color:White; height:30px;">
  203. <th scope="row">
  204. <asp:Literal ID="XB" runat="server"></asp:Literal>
  205. </th>
  206. <td>
  207. <asp:Literal ID="DDHY" runat="server" Text="0"></asp:Literal>
  208. </td>
  209. <td>
  210. <asp:Literal ID="DDTK" runat="server" Text="0"></asp:Literal>
  211. </td>
  212. <td>
  213. <asp:Literal ID="DDPK" runat="server" Text="0"></asp:Literal>
  214. </td>
  215. <td>
  216. <asp:Literal ID="DXCS" runat="server" Text="0"></asp:Literal>
  217. </td>
  218. <td>
  219. <asp:Literal ID="JXJC" runat="server" Text="0"></asp:Literal>
  220. </td>
  221. <td>
  222. <asp:Literal ID="XMPH" runat="server" Text="0"></asp:Literal>
  223. </td>
  224. <td>
  225. <asp:Literal ID="PXJL" runat="server" Text="0"></asp:Literal>
  226. </td>
  227. <td>
  228. <asp:Literal ID="Othe" runat="server" Text="0"></asp:Literal>
  229. </td>
  230. </tr>
  231. </table>
  232. <p align=center style='text-align:center'>&nbsp;</p>
  233. </asp:Panel>
  234. </div> <!--WordSection1 end-->
  235. </div><!--mainContent end-->
  236. <!--endprint-->
  237. </div><!--form end-->
  238. </form>
  239. </div><!--formbox end-->
  240. </body>
  241. </html>