工作任务三 打印表单数据

工作快一个月了,我对于工作的感觉越来越熟练了。

第三个任务是有关报表的打印。

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;
             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-0px">
                    主要管理和技术负责人
                </td>
            </tr>
            <tr>
                <td colspan="6" style="border-left-0px; border-right-0px; border-bottom-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-0px; border-right-0px; border-bottom-0px; border-top-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;
             600px;">
            <tr>
                <td colspan="2" style="border-top- 0px;  border-bottom-0px; border-left-0px; border-right-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- 0px;  border-bottom-0px; border-left-0px; border-right-0px" 
                    class="style2">
                    <asp:Label ID="Label15" runat="server" Text="" ></asp:Label>
                    <br />
                </td>
            </tr>
            
            <tr>
                <td width="60%" height="30%" style="border-top- 0px;  border-bottom-0px; border-left-0px; border-right-0px">
                    
                </td>
                <td align="left" style="border-top- 0px;  border-bottom-0px; border-left-0px; border-right-0px">
                    <br />
                    <br />
                    <br />
                    (盖章)<br />
                    <br />
                    日期:<br />
                    <br />
                </td>
            </tr>
        </table>
        <table align="center" border="1px" cellpadding="0" cellspacing="0" style="border-style: solid;
             600px;">
            <tr>
                <td colspan="2" style="border-top- 0px;  border-bottom-0px; border-left-0px; border-right-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- 0px;  border-bottom-0px; border-left-0px; border-right-0px">
                    <asp:Label ID="Label5" runat="server" Text=""></asp:Label>
                    <br />
                </td>
            </tr>
            
            <tr>
                <td width="60%" height="30%" style="border-top- 0px;  border-bottom-0px; border-left-0px; border-right-0px">
                    
                </td>
                <td align="left" style="border-top- 0px;  border-bottom-0px; border-left-0px; border-right-0px">
                    <br />
                    <br />
                    <br />
                    (盖章)<br />
                    <br />
                    日期:<br />
                    <br />
                </td>
            </tr>
        </table>
        <table align="center" border="1px" cellpadding="0" cellspacing="0" style="border-style: solid;
             600px;">
            <tr>
                <td colspan="2" style="border-top- 0px;  border-bottom-0px; border-left-0px; border-right-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- 0px;  border-bottom-0px; border-left-0px; border-right-0px">
                    <asp:Label ID="Label12" runat="server" Text=""></asp:Label>
                    <br />
                </td>
            </tr>
            
            <tr>
                <td width="60%" height="70%" style="border-top- 0px;  border-bottom-0px; border-left-0px; border-right-0px">
                    
                </td>
                <td align="left" style="border-top- 0px;  border-bottom-0px; border-left-0px; border-right-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>
原文地址:https://www.cnblogs.com/zuifengke/p/2045624.html