工作任务三 打印表单数据
工作快一个月了，我对于工作的感觉越来越熟练了。
第三个任务是有关报表的打印。
div自己画表单，从数据库中读取数据
代码如下
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Apply.aspx.cs" Inherits="hbproject.CerProject.print.Apply" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
</style>
</head>
<body>
<form id="form1" runat="server">
<div style="height: 978px">
<br />
<div align="center" style="vertical-align: middle; line-height: 300px; height: 300px">
<h2>
环境污染治理设施运营资质证书申请表
</h2>
</div>
<table align="center" border="0" cellpadding="0" cellspacing="0" width="400px" height="240px">
<tr>
<td colspan="2" align="left">
<span style="font-size:15.0pt;mso-bidi-font-size:12.0pt;
font-family:仿宋_GB2312;mso-hansi-font-family:"Times New Roman";mso-bidi-font-family:
"Times New Roman";mso-font-kerning:1.0pt;mso-ansi-language:EN-US;mso-fareast-language:
ZH-CN;mso-bidi-language:AR-SA">申请单位（盖章）</span>：
<asp:Label ID="lb_applyUnit" runat="server" ></asp:Label>
</td>
</tr>
<tr>
<td colspan="2" align="left">
<span style="font-size:15.0pt;mso-bidi-font-size:12.0pt;
font-family:仿宋_GB2312;mso-hansi-font-family:"Times New Roman";mso-bidi-font-family:
"Times New Roman";mso-font-kerning:1.0pt;mso-ansi-language:EN-US;mso-fareast-language:
ZH-CN;mso-bidi-language:AR-SA">填表日期</span>：
<asp:Label ID="lb_applyDate" runat="server" ></asp:Label>
</td>
</tr>
</table>
<div align="center" style="vertical-align: middle; line-height: 300px; height: 300px">
中华人民共和国环境保护部印制
</div>
</div>
<div style="height: 978px;position:relative;margin:auto; top:auto">
<table align="center" cellpadding="0" cellspacing="0" width="600px" border="0px" >
<tr>
<td valign="top">
<b>一、申请单位基本情况</b>
</td>
</tr>
</table>
<table align="center" border="1" cellpadding="0" cellspacing="0" style="border-style: solid;
width: 600px;">
<tr>
<td align="center" width="100">
单位名称
</td>
<td colspan="5">
<asp:Label ID="lb_unit_name" runat="server"></asp:Label>
</td>
</tr>
<tr>
<td align="center">
地 址
</td>
<td colspan="3">
<asp:Label ID="lb_address" runat="server"></asp:Label>
</td>
<td align="center">
邮政编码
</td>
<td>
<asp:Label ID="lb_postal_code" runat="server"></asp:Label>
</td>
</tr>
<tr>
<td align="center">
联系人
</td>
<td>
<asp:Label ID="lb_link_man" runat="server" Text="label1"></asp:Label>
</td>
<td align="center">
电话/传<br />
真/手机
</td>
<td colspan="3">
<asp:Label ID="lb_phone_fax_mobile" runat="server" Text="label1"></asp:Label>
</td>
</tr>
<tr>
<td align="center">
成立时间
</td>
<td>
<asp:Label ID="lb_creat_date" runat="server" Text="label1"></asp:Label>
</td>
<td align="center">
注册资金
</td>
<td>
<asp:Label ID="lb_register_money" runat="server" Text="label1"></asp:Label>万元
</td>
<td align="center">
法人代表
</td>
<td>
<asp:Label ID="lb_corporation" runat="server" Text="label1"></asp:Label>万元
</td>
</tr>
<tr>
<td align="center">
单位性质
</td>
<td colspan="2">
<asp:Label ID="lb_unit_type" runat="server" Text="label1"></asp:Label>
</td>
<td align="center">
固定资产
</td>
<td colspan="2">
<asp:Label ID="lb_fixed_assets" runat="server" Text="label1"></asp:Label>
</td>
</tr>
<tr>
<td align="center">
开户银行
</td>
<td align="center" colspan="2">
<asp:Label ID="lb_bank" runat="server"></asp:Label>
</td>
<td align="center">
账 号
</td>
<td colspan="2">
<asp:Label ID="lb_bank_card" runat="server"></asp:Label>
</td>
</tr>
<tr>
<td align="center">
主管部门
</td>
<td align="center" colspan="5">
<asp:Label ID="lb_main_unit" runat="server" Height="26px" Text="label1">
</asp:Label>
</td>
</tr>
<tr>
<td align="center">
职工总数
</td>
<td align="center">
<asp:Label ID="lb_employee_count" runat="server" Height="26px" Text="label1">
</asp:Label>
</td>
<td align="center">
技术人员总数
</td>
<td align="center">
<asp:Label ID="lb_all_tech_count" runat="server" Height="26px" Text="label1">
</asp:Label>
</td>
<td align="center">
高级工程师
</td>
<td align="center">
<asp:Label ID="lb_h_engineer_count" runat="server" Height="26px" Text="label1">
</asp:Label>
</td>
</tr>
<tr>
<td align="center">
工 程 师
</td>
<td align="center">
<asp:Label ID="lb_engineer_count" runat="server" Height="26px" Text="label1">
</asp:Label>
</td>
<td align="center">
助理工程师
</td>
<td align="center">
<asp:Label ID="lb_assistant_engineer_count" runat="server" Height="26px" Text="label1">
</asp:Label>
</td>
<td align="center">
技 术 员
</td>
<td align="center">
<asp:Label ID="lb_tech_count" runat="server" Height="26px" Text="label1">
</asp:Label>
</td>
</tr>
<tr>
<td align="center" colspan="5">
取得污染治理设施运营岗位培训证书操作人员数
</td>
<td>
<asp:Label ID="lb_get_cer_count" runat="server" Text="label1"></asp:Label>
</td>
</tr>
<tr>
<td align="center" colspan="6" style="border-bottom-width:0px">
主要管理和技术负责人
</td>
</tr>
<tr>
<td colspan="6" style="border-left-width:0px; border-right-width:0px; border-bottom-width:0px">
<table align="center" border="0px" cellpadding="0" cellspacing="0" height="100%"
width="100%">
<tr>
<td >
<asp:GridView ID="Menber1Grid" runat="server" BorderWidth="1px" Height="100%" Width="100%"
AutoGenerateColumns="false" DataKeyNames="CER_MENBER_ID">
<Columns>
<asp:BoundField DataField="CER_MENBER_ID" Visible="false" />
</Columns>
<Columns>
<asp:BoundField HeaderText="姓名" DataField="FULL_NAME" />
</Columns>
<Columns>
<asp:BoundField HeaderText="职务及职称" DataField="POST_TITLE" />
</Columns>
<Columns>
<asp:BoundField HeaderText="年龄" DataField="AGE" />
</Columns>
<Columns>
<asp:BoundField HeaderText="专业" DataField="PROFESSION" />
</Columns>
<Columns>
<asp:BoundField HeaderText="技术专长" DataField="PROFESSION_WAY" />
</Columns>
</asp:GridView>
</td>
</tr>
</table>
</td>
</tr>
</table>
</div>
<div style="height: 978px">
<table align="center" border="0px" cellpadding="0" cellspacing="0" width="600px">
<tr>
<td valign="top" >
<b>二、主要专业技术人员概况</b>
</td>
</tr>
<tr>
<td valign="top" style=" border:0px;">
<asp:GridView ID="Menber2Grid" runat="server" BorderWidth="1px" Height="100%" Width="100%"
AutoGenerateColumns="false" DataKeyNames="CER_MENBER_ID">
<Columns>
<asp:BoundField DataField="CER_MENBER_ID" Visible="false" />
</Columns>
<Columns>
<asp:BoundField HeaderText="姓名" DataField="FULL_NAME" />
</Columns>
<Columns>
<asp:BoundField HeaderText="职务及职称" DataField="POST_TITLE" />
</Columns>
<Columns>
<asp:BoundField HeaderText="年龄" DataField="AGE" />
</Columns>
<Columns>
<asp:BoundField HeaderText="专业" DataField="PROFESSION" />
</Columns>
<Columns>
<asp:BoundField HeaderText="身份证号" DataField="PERSON_CODE" />
</Columns>
</asp:GridView>
</td>
</tr>
</table>
</div>
<div style="height: 978px">
<table align="center" cellpadding="0" cellspacing="0" width="600px" border="0px">
<tr>
<td>
<b>三、现场管理及操作人员概况</b>
</td>
</tr>
<tr>
<td valign="top" style=" border:0px" >
<asp:GridView ID="Menber3Grid" runat="server" BorderWidth="1px" Height="100%" Width="100%"
AutoGenerateColumns="false" DataKeyNames="CER_MENBER_ID">
<Columns>
<asp:BoundField DataField="CER_MENBER_ID" Visible="false" />
</Columns>
<Columns>
<asp:BoundField HeaderText="姓名" DataField="FULL_NAME" />
</Columns>
<Columns>
<asp:BoundField HeaderText="职务及职称" DataField="POST_TITLE" />
</Columns>
<Columns>
<asp:BoundField HeaderText="年龄" DataField="AGE" />
</Columns>
<Columns>
<asp:BoundField HeaderText="专业" DataField="PROFESSION" />
</Columns>
<Columns>
<asp:BoundField HeaderText="培训证书编号" DataField="CER_CODE" />
</Columns>
</asp:GridView>
</td>
</tr>
</table>
</div>
<div style="height: 978px">
<table align="center" cellpadding="0" cellspacing="0" width="600px" border="0px">
<tr>
<td>
<b>四、主要技术装备情况</b>
</td>
</tr>
<tr>
<td valign="top" style=" border:0px">
<asp:GridView ID="EquipmentGrid" runat="server" BorderWidth="1px" Width="100%" AutoGenerateColumns="false"
DataKeyNames="CER_EQUIPMENT_ID">
<Columns>
<asp:BoundField DataField="CER_EQUIPMENT_ID" Visible="false" />
</Columns>
<Columns>
<asp:BoundField HeaderText="名称" DataField="EQUIPMENT_NAME" />
</Columns>
<Columns>
<asp:BoundField HeaderText="规格型号" DataField="TYPE" />
</Columns>
<Columns>
<asp:BoundField HeaderText="数量" DataField="COUNT" />
</Columns>
<Columns>
<asp:BoundField HeaderText="主要性能" DataField="CAPABILITY" />
</Columns>
<Columns>
<asp:BoundField HeaderText="备注" DataField="REMARK" />
</Columns>
</asp:GridView>
</td>
</tr>
</table>
</div>
<div style="height: 978px">
<table align="center" cellpadding="0" cellspacing="0" width="600px" border="0px">
<tr>
<td>
<b>五、主要环境保护运营项目</b>
</td>
</tr>
<tr>
<td valign="top" style=" border:0px">
<asp:GridView ID="ProjectGrid" runat="server" BorderWidth="1px" Width="100%" AutoGenerateColumns="false"
DataKeyNames="CER_PROJECT_ID">
<Columns>
<asp:BoundField DataField="CER_PROJECT_ID" Visible="false" />
</Columns>
<Columns>
<asp:BoundField HeaderText="序号" DataField="ORDERNUM" />
</Columns>
<Columns>
<asp:BoundField HeaderText="项目名称" DataField="PROJECT_NAME" />
</Columns>
<Columns>
<asp:BoundField HeaderText="运营类型" DataField="TYPE" />
</Columns>
<Columns>
<asp:BoundField HeaderText="运营规模" DataField="MODLE" />
</Columns>
<Columns>
<asp:BoundField HeaderText="运营起始时间" DataField="MODLE" DataFormatString="{0:yyyy-MM-dd}" />
</Columns>
<Columns>
<asp:BoundField HeaderText="运营效果" DataField="RESULT" />
</Columns>
</asp:GridView>
</td>
</tr>
</table>
</div>
<div style="height: 978px; top:0" >
<table align="center" cellpadding="0" cellspacing="0" width="600px" border="0px">
<tr>
<td colspan="2">
<b>六、申请资质情况</b>
</td>
</tr>
</table>
<table align="center" cellpadding="0" cellspacing="0" width="600px" border="1px">
<tr>
<td align="center">
申请<br />
类型和<br />
等级
</td>
<td colspan="5" style="border-left-width:0px; border-right-width:0px; border-bottom-width:0px; border-top-width:0px">
<asp:GridView ID="ApplyTypeGrid" runat="server" BorderWidth="1px" Width="100%" AutoGenerateColumns="false"
DataKeyNames="CER_APPLY_ID">
<Columns>
<asp:BoundField DataField="CER_APPLY_ID" Visible="false" />
</Columns>
<Columns>
<asp:BoundField HeaderText="申请类型" DataField="APPLY_TYPE" />
</Columns>
<Columns>
<asp:BoundField HeaderText="申请范围" DataField="APPLY_COSPE" />
</Columns>
<Columns>
<asp:BoundField HeaderText="申请等级" DataField="APPLY_LEVEL" />
</Columns>
</asp:GridView>
</td>
</tr>
<tr>
<td align="center" style="height:100px">
原有资<br />
质类别<br />
及编号
</td>
<td colspan="5">
<asp:Label runat="server" ID="lb_old_apply_code_type"></asp:Label>
</td>
</tr>
<tr>
<td align="center" style="height:150px">
业务<br />
范围
</td>
<td colspan="5">
<asp:Label runat="server" ID="lb_work_cospe"></asp:Label>
</td>
</tr>
<tr>
<td align="center" style="height:150px" >
技术<br />
特长
</td>
<td colspan="5">
<asp:Label runat="server" ID="lb_special_skill"></asp:Label>
</td>
</tr>
</table>
</div>
<div style="height: 978px; top:100px">
<table align="center" cellpadding="0" cellspacing="0" width="600px" border="0px">
<tr>
<td valign="top">
<b>七、运营管理实例</b>
</td>
</tr>
</table>
<table align="center" border="1" cellpadding="0" cellspacing="0" width="600px">
<tr>
<td valign="top" style=" border:0px">
<asp:GridView ID="OperationsGrid" runat="server" BorderWidth="1px" Width="100%" AutoGenerateColumns="false"
DataKeyNames="CER_OPERATIONS_ID">
<Columns>
<asp:BoundField DataField="CER_OPERATIONS_ID" Visible="false" />
</Columns>
<Columns>
<asp:BoundField HeaderText="名称" DataField="OPERATIONS_NAME" />
</Columns>
<Columns>
<asp:BoundField HeaderText="设施简介和运行效果" DataField="RESULT" />
</Columns>
</asp:GridView>
</td>
</tr>
</table>
</div>
<div style="height: 978px">
<table align="center" border="1px" cellpadding="0" cellspacing="0" style="border-style: solid;
width: 600px;">
<tr>
<td colspan="2" style="border-top-width: 0px; border-bottom-width:0px; border-left-width:0px; border-right-width:0px" class="style1">
<span style="font-size:15.0pt;mso-bidi-font-size:12.0pt;
font-family:仿宋_GB2312;mso-hansi-font-family:"Times New Roman";mso-bidi-font-family:
"Times New Roman";mso-font-kerning:1.0pt;mso-ansi-language:EN-US;mso-fareast-language:
ZH-CN;mso-bidi-language:AR-SA;mso-bidi-font-weight:bold">八、省级环境保护行政主管部门初审意见 </span>
</td>
</tr>
<tr>
<td colspan="2" style="border-top-width: 0px; border-bottom-width:0px; border-left-width:0px; border-right-width:0px"
class="style2">
<asp:Label ID="Label15" runat="server" Text="" ></asp:Label>
<br />
</td>
</tr>
<tr>
<td width="60%" height="30%" style="border-top-width: 0px; border-bottom-width:0px; border-left-width:0px; border-right-width:0px">
</td>
<td align="left" style="border-top-width: 0px; border-bottom-width:0px; border-left-width:0px; border-right-width:0px">
<br />
<br />
<br />
(盖章)<br />
<br />
日期：<br />
<br />
</td>
</tr>
</table>
<table align="center" border="1px" cellpadding="0" cellspacing="0" style="border-style: solid;
width: 600px;">
<tr>
<td colspan="2" style="border-top-width: 0px; border-bottom-width:0px; border-left-width:0px; border-right-width:0px" >
<p class="MsoNormal">
<span style="font-size:15.0pt;
mso-bidi-font-size:12.0pt;font-family:仿宋_GB2312">九、专家审核意见<span lang="EN-US"><o:p></o:p></span></span></p>
</td>
</tr>
<tr>
<td colspan="2" style="border-top-width: 0px; border-bottom-width:0px; border-left-width:0px; border-right-width:0px">
<asp:Label ID="Label5" runat="server" Text=""></asp:Label>
<br />
</td>
</tr>
<tr>
<td width="60%" height="30%" style="border-top-width: 0px; border-bottom-width:0px; border-left-width:0px; border-right-width:0px">
</td>
<td align="left" style="border-top-width: 0px; border-bottom-width:0px; border-left-width:0px; border-right-width:0px">
<br />
<br />
<br />
(盖章)<br />
<br />
日期：<br />
<br />
</td>
</tr>
</table>
<table align="center" border="1px" cellpadding="0" cellspacing="0" style="border-style: solid;
width: 600px;">
<tr>
<td colspan="2" style="border-top-width: 0px; border-bottom-width:0px; border-left-width:0px; border-right-width:0px" >
<p class="MsoNormal">
<span style="font-size:15.0pt;
mso-bidi-font-size:12.0pt;font-family:仿宋_GB2312">十、国家环境保护总局审批意见<span lang="EN-US"><o:p></o:p></span></span></p>
</td>
</tr>
<tr>
<td colspan="2" style="border-top-width: 0px; border-bottom-width:0px; border-left-width:0px; border-right-width:0px">
<asp:Label ID="Label12" runat="server" Text=""></asp:Label>
<br />
</td>
</tr>
<tr>
<td width="60%" height="70%" style="border-top-width: 0px; border-bottom-width:0px; border-left-width:0px; border-right-width:0px">
</td>
<td align="left" style="border-top-width: 0px; border-bottom-width:0px; border-left-width:0px; border-right-width:0px">
<br />
<br />
<br />
(盖章)<br />
<br />
日期：<br />
<br />
</td>
</tr>
</table>
</div>
<div style="height:978px">
<table align="center" cellpadding="0" cellspacing="0" width="600px" border="0px" >
<tr>
<td align="center" style="letter-spacing: 2px;">
<b>
<br />
填 表 说 明</b>
<br />
<br />
<br />
</td>
</tr>
</table>
<table align="center" border="0" cellpadding="0" cellspacing="0" width="600px" >
<tr>
<td style="letter-spacing: 2px;">
1、本表由国家环境保护总局统一印制，申请单位填写一式三份。<br />
<br />
2、本表须用钢笔填写或计算机打印，字迹工整，不得涂改。<br />
<br />
3、申请单位要如实、逐项填报，不得弄虚作假。<br />
<br />
4、封面申请单位一栏须填写单位全称，并加盖单位公章。单位名称要与所盖公章一致。<br />
<br />
5、技术人员名单按专业顺序填写，同专业人员按高中级顺序填写。<br />
<br />
6、申请的类别和等级一栏中，要求在所对应的申请类别下面填写申请级别。<br />
<br />
7、申请每一专业类别应有本专业领域至少3名以上专业技术人员。<br />
<br />
8、申请正式资质时，每一专业类别应有两项运营管理实例，设施简介应说明处理规模、设施投入运行时间、工艺简介、运行效果等。<br />
<br />
9、业务范围是指申报单位从事的有关环境保护的业务工作。<br />
<br />
10、环境保护行政主管部门意见栏中，须签署意见并盖章。<br />
<br />
11、表中栏目不足者可另加附页。<br />
<br />
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
浙公网安备 33010602011771号