257 lines
15 KiB
XML
257 lines
15 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<Report ReportInfo.Created="06/24/2017 13:16:54" ReportInfo.Modified="05/19/2018 11:21:52" ReportInfo.CreatorVersion="1.2.47.0">
|
|
<ScriptText>using System;
|
|
using System.Collections;
|
|
using System.Collections.Generic;
|
|
using System.ComponentModel;
|
|
using System.Windows.Forms;
|
|
using System.Drawing;
|
|
using System.Data;
|
|
using FastReport;
|
|
using FastReport.Data;
|
|
using FastReport.Dialog;
|
|
using FastReport.Barcode;
|
|
using FastReport.Table;
|
|
using FastReport.Utils;
|
|
|
|
namespace FastReport
|
|
{
|
|
public class ReportScript
|
|
{
|
|
|
|
private void Text13_AfterData(object sender, EventArgs e)
|
|
{
|
|
if(Text13.Text.Contains("药品"))
|
|
{
|
|
Text18.Visible=true;
|
|
}
|
|
else
|
|
{
|
|
Text18.Visible=false;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
</ScriptText>
|
|
<Dictionary>
|
|
<MsSqlDataConnection Name="Connection" ConnectionString="rijcmlqveABMfnqRj7Azp6bE+ejNjHm4xfNvDChgc0AjC2KM2vi1nVm2sdFZnA7liDtBhVcu4fyvEPIqq8rJAdSEMN7IacmzicJBH81sVQLGoUbt64noq4mjIAQ0PVfB5Jm4TZxzsjXCqYa2zckqubkPeps9oGP571ndnxqrwYvmaZuEGZN3F2zdqWLCYvtZmPob3OdNqrRfU8JF762EP4KKuX8sg==">
|
|
<TableDataSource Name="professionalExam_register" DataType="System.Int32" Enabled="true" TableName="professionalExam_register">
|
|
<Column Name="id" DataType="System.Int32"/>
|
|
<Column Name="health_certificate_number" DataType="System.String"/>
|
|
<Column Name="physical_num" DataType="System.String"/>
|
|
<Column Name="physical_num_old" DataType="System.String"/>
|
|
<Column Name="person_name" DataType="System.String"/>
|
|
<Column Name="sex" DataType="System.String"/>
|
|
<Column Name="person_age" DataType="System.Int32"/>
|
|
<Column Name="birth" DataType="System.String"/>
|
|
<Column Name="card_number" DataType="System.String"/>
|
|
<Column Name="phone" DataType="System.String"/>
|
|
<Column Name="native_info_maintain_id" DataType="System.Int32"/>
|
|
<Column Name="home_address" DataType="System.String"/>
|
|
<Column Name="category" DataType="System.String"/>
|
|
<Column Name="trade_type_maintain_id" DataType="System.Int32"/>
|
|
<Column Name="work_category" DataType="System.String"/>
|
|
<Column Name="person_category" DataType="System.String"/>
|
|
<Column Name="person_type_maintain_id" DataType="System.Int32"/>
|
|
<Column Name="util_name" DataType="System.String"/>
|
|
<Column Name="enterprise_info_maintain_id" DataType="System.Int32"/>
|
|
<Column Name="area" DataType="System.String"/>
|
|
<Column Name="depart" DataType="System.String"/>
|
|
<Column Name="physical_category" DataType="System.String"/>
|
|
<Column Name="medical_scheme_maintain_id" DataType="System.Int32"/>
|
|
<Column Name="register_type" DataType="System.String"/>
|
|
<Column Name="physical_way" DataType="System.String"/>
|
|
<Column Name="physical_status" DataType="System.String"/>
|
|
<Column Name="register_date" DataType="System.String"/>
|
|
<Column Name="phone_path" DataType="System.String"/>
|
|
<Column Name="status" DataType="System.String"/>
|
|
<Column Name="prescription" DataType="System.String"/>
|
|
<Column Name="physial_expenses" DataType="System.String"/>
|
|
<Column Name="payment" DataType="System.String"/>
|
|
<Column Name="haemospasia" DataType="System.String"/>
|
|
<Column Name="stool" DataType="System.String"/>
|
|
<Column Name="urine" DataType="System.String"/>
|
|
<Column Name="image" DataType="System.String"/>
|
|
<Column Name="director_approval_status" DataType="System.String"/>
|
|
<Column Name="procedure_status" DataType="System.String"/>
|
|
<Column Name="main_review" DataType="System.String"/>
|
|
<Column Name="main_result" DataType="System.String"/>
|
|
<Column Name="result_status" DataType="System.String"/>
|
|
<Column Name="is_printed" DataType="System.String"/>
|
|
<Column Name="wait_print" DataType="System.String"/>
|
|
<Column Name="other" DataType="System.String"/>
|
|
<Column Name="printtimes" DataType="System.String"/>
|
|
<Column Name="exam_type_id" DataType="System.Int32"/>
|
|
<Column Name="exam_type" DataType="System.String"/>
|
|
<Column Name="main_user_id" DataType="System.String"/>
|
|
<Column Name="main_user_name" DataType="System.String"/>
|
|
<Column Name="main_review_date" DataType="System.String"/>
|
|
<Column Name="work_category_id" DataType="System.Int32"/>
|
|
<Column Name="check_date" DataType="System.String"/>
|
|
<Column Name="security_card_no" DataType="System.String"/>
|
|
<Column Name="flag" DataType="System.String"/>
|
|
<Column Name="physical_type" DataType="System.String"/>
|
|
<Column Name="agreement_money" DataType="System.Decimal"/>
|
|
<Column Name="marry_status" DataType="System.String"/>
|
|
<Column Name="department" DataType="System.String"/>
|
|
<Column Name="job_num" DataType="System.String"/>
|
|
<Column Name="nation" DataType="System.String"/>
|
|
<Column Name="nationality" DataType="System.String"/>
|
|
<Column Name="common_scheme" DataType="System.String"/>
|
|
<Column Name="common_scheme_id" DataType="System.Int32"/>
|
|
<Column Name="job_status_id" DataType="System.Int32"/>
|
|
<Column Name="hazard_ids" DataType="System.String"/>
|
|
<Column Name="hazards" DataType="System.String"/>
|
|
<Column Name="hazards_alias" DataType="System.String"/>
|
|
<Column Name="work_years" DataType="System.Int32"/>
|
|
<Column Name="work_months" DataType="System.Int32"/>
|
|
<Column Name="touch_years" DataType="System.Int32"/>
|
|
<Column Name="touch_months" DataType="System.Int32"/>
|
|
<Column Name="attention" DataType="System.String"/>
|
|
<Column Name="invoice_num" DataType="System.String"/>
|
|
<Column Name="doctor_process" DataType="System.String"/>
|
|
<Column Name="check_item_ids" DataType="System.String"/>
|
|
<Column Name="printdate_recheck_notice" DataType="System.String"/>
|
|
<Column Name="printdate_recheck_list" DataType="System.String"/>
|
|
<Column Name="printdate_recheck_report" DataType="System.String"/>
|
|
<Column Name="remark" DataType="System.String"/>
|
|
<Column Name="audit_person" DataType="System.String"/>
|
|
<Column Name="audit_time" DataType="System.String"/>
|
|
<Column Name="handle_advise" DataType="System.String"/>
|
|
<Column Name="health_advise" DataType="System.String"/>
|
|
<Column Name="hazard_type_ids" DataType="System.String"/>
|
|
<Column Name="hazard_type_names" DataType="System.String"/>
|
|
<Column Name="exam_form_url" DataType="System.String"/>
|
|
<Column Name="recheck_notice_url" DataType="System.String"/>
|
|
<Column Name="recheck_report_url" DataType="System.String"/>
|
|
<Column Name="freezing_and_thawing" DataType="System.String"/>
|
|
<Column Name="register_person" DataType="System.String"/>
|
|
<Column Name="main_object" DataType="System.String"/>
|
|
<Column Name="effective_date" DataType="System.String"/>
|
|
<Column Name="picture" DataType="System.String"/>
|
|
<Column Name="regain" DataType="System.String"/>
|
|
<Column Name="education_level" DataType="System.String"/>
|
|
<Column Name="current_util" DataType="System.String"/>
|
|
<Column Name="resultids" DataType="System.String"/>
|
|
<Column Name="roll_no" DataType="System.String"/>
|
|
<Column Name="enrolment_year" DataType="System.String"/>
|
|
<Column Name="stu_grade" DataType="System.String"/>
|
|
<Column Name="stu_class" DataType="System.String"/>
|
|
<Column Name="parents_name" DataType="System.String"/>
|
|
<Column Name="stu_source" DataType="System.String"/>
|
|
<Column Name="electronic_signature" DataType="System.String"/>
|
|
<Column Name="otherProject" DataType="System.String"/>
|
|
<Column Name="fujianProject" DataType="System.String"/>
|
|
<Column Name="zhiyeProject" DataType="System.String"/>
|
|
<Column Name="yisiProject" DataType="System.String"/>
|
|
<Column Name="unnomel_type" DataType="System.String"/>
|
|
<Column Name="unnomel_ages" DataType="System.String"/>
|
|
<Column Name="blood_num" DataType="System.String"/>
|
|
<Column Name="urine_num" DataType="System.String"/>
|
|
<Column Name="fei_result" DataType="System.String"/>
|
|
<Column Name="orderid" DataType="System.Int32"/>
|
|
<Column Name="special_health_certificate" DataType="System.String"/>
|
|
<Column Name="charging_time" DataType="System.String"/>
|
|
</TableDataSource>
|
|
<TableDataSource Name="Table" Alias="tjlctop" DataType="System.Int32" Enabled="true" SelectCommand="select ''as'lc'">
|
|
<Column Name="lc" DataType="System.String"/>
|
|
</TableDataSource>
|
|
<TableDataSource Name="Table1" Alias="tjlcbom" DataType="System.Int32" Enabled="true" SelectCommand="select ''as'lc'">
|
|
<Column Name="lc" DataType="System.String"/>
|
|
</TableDataSource>
|
|
<TableDataSource Name="Table10" Alias="zydtop" DataType="System.Int32" Enabled="true" SelectCommand="select ''as 'zyd'">
|
|
<Column Name="zyd" DataType="System.String"/>
|
|
</TableDataSource>
|
|
<TableDataSource Name="Table11" Alias="imagedt" DataType="System.Int32" Enabled="true" SelectCommand="select ''as'image'">
|
|
<Column Name="image" DataType="System.String"/>
|
|
</TableDataSource>
|
|
</MsSqlDataConnection>
|
|
<Parameter Name="agreement_money" DataType="System.String"/>
|
|
</Dictionary>
|
|
<ReportPage Name="Page1" Fill.Color="White">
|
|
<ReportTitleBand Name="ReportTitle1" Width="718.2" Height="226.8">
|
|
<PictureObject Name="Picture1" Left="577.9" Top="37.8" Width="113.4" Height="122.85" DataColumn="imagedt.image"/>
|
|
<BarcodeObject Name="Barcode1" Left="558.55" Top="170.1" Width="153.75" Height="56.7" DataColumn="professionalExam_register.physical_num" Text="1234567891234" Barcode="Code128" Barcode.AutoEncode="true"/>
|
|
<TextObject Name="Text13" Left="141.75" Top="56.7" Width="396.9" Height="37.8" AfterDataEvent="Text13_AfterData" Text="[zydtop.zyd]" HorzAlign="Center" Font="宋体, 18pt, style=Bold"/>
|
|
</ReportTitleBand>
|
|
<PageHeaderBand Name="PageHeader1" Top="230.8" Width="718.2" Height="309.96">
|
|
<TextObject Name="Text2" Left="56.7" Top="18.9" Width="94.5" Height="18.9" Text="姓 名："/>
|
|
<TextObject Name="Text3" Left="56.7" Top="56.7" Width="94.5" Height="18.9" Text="身份证号："/>
|
|
<TextObject Name="Text4" Left="56.7" Top="94.5" Width="94.5" Height="18.9" Text="行业类别："/>
|
|
<TextObject Name="Text5" Left="56.7" Top="132.3" Width="94.5" Height="18.9" Text="单位名称："/>
|
|
<TextObject Name="Text6" Left="132.3" Top="18.9" Width="245.7" Height="18.9" Text="[professionalExam_register.person_name]"/>
|
|
<TextObject Name="Text7" Left="132.3" Top="56.7" Width="207.9" Height="18.9" Text="[professionalExam_register.card_number]"/>
|
|
<TextObject Name="Text8" Left="132.3" Top="94.5" Width="94.5" Height="18.9" Text="[professionalExam_register.category]"/>
|
|
<TextObject Name="Text9" Left="132.3" Top="132.3" Width="444.15" Height="18.9" Text="[professionalExam_register.util_name]"/>
|
|
<TextObject Name="Text10" Left="406.35" Top="18.9" Width="94.5" Height="18.9" Text="性 别："/>
|
|
<TextObject Name="Text11" Left="406.35" Top="56.7" Width="94.5" Height="18.9" Text="联系电话："/>
|
|
<TextObject Name="Text12" Left="406.35" Top="94.5" Width="94.5" Height="18.9" Text="工 种："/>
|
|
<TextObject Name="Text14" Left="481.95" Top="18.9" Width="94.5" Height="18.9" Text="[professionalExam_register.sex]"/>
|
|
<TextObject Name="Text15" Left="481.95" Top="56.7" Width="94.5" Height="18.9" Text="[professionalExam_register.phone]"/>
|
|
<TextObject Name="Text16" Left="481.95" Top="94.5" Width="94.5" Height="18.9" Text="[professionalExam_register.work_category]"/>
|
|
<TextObject Name="Text17" Top="151.2" Width="94.5" Height="18.9" Text="体检流程："/>
|
|
<TableObject Name="Table5" Left="9.45" Top="198.45" Width="708.75" Height="35.91">
|
|
<TableColumn Name="Column21" Width="77.49"/>
|
|
<TableColumn Name="Column22" Width="171.99"/>
|
|
<TableColumn Name="Column23" Width="171.99"/>
|
|
<TableColumn Name="Column24" Width="77.49"/>
|
|
<TableColumn Name="Column25" Width="209.79"/>
|
|
<TableRow Name="Row5" Height="35.91">
|
|
<TableCell Name="Cell21"/>
|
|
<TableCell Name="Cell22" Text="1. 空腹静脉抽血;" ColSpan="3"/>
|
|
<TableCell Name="Cell23"/>
|
|
<TableCell Name="Cell24"/>
|
|
<TableCell Name="Cell25" Text="医生签章："/>
|
|
</TableRow>
|
|
</TableObject>
|
|
<TableObject Name="Table6" Left="9.45" Top="236.25" Width="708.75" Height="35.91">
|
|
<TableColumn Name="Column26" Width="77.49"/>
|
|
<TableColumn Name="Column27" Width="171.99"/>
|
|
<TableColumn Name="Column28" Width="171.99"/>
|
|
<TableColumn Name="Column29" Width="77.49"/>
|
|
<TableColumn Name="Column30" Width="209.79"/>
|
|
<TableRow Name="Row6" Height="35.91">
|
|
<TableCell Name="Cell26"/>
|
|
<TableCell Name="Cell27" Text="2.登记信息时领取大便盒 留取大便样本后送回;" ColSpan="3"/>
|
|
<TableCell Name="Cell28"/>
|
|
<TableCell Name="Cell29"/>
|
|
<TableCell Name="Cell30" Text="医生签章："/>
|
|
</TableRow>
|
|
</TableObject>
|
|
<TextObject Name="Text18" Left="9.45" Top="170.1" Width="689.85" Height="28.35" Text="请在一楼收费处缴费或者通过微信关注“德城疾控查体中心”进行自助缴费。" VertAlign="Center" Font="宋体, 12pt, style=Bold"/>
|
|
<TableObject Name="Table12" Left="9.45" Top="274.05" Width="708.75" Height="35.91">
|
|
<TableColumn Name="Column41" Width="77.49"/>
|
|
<TableColumn Name="Column42" Width="171.99"/>
|
|
<TableColumn Name="Column43" Width="171.99"/>
|
|
<TableColumn Name="Column44" Width="77.49"/>
|
|
<TableColumn Name="Column45" Width="209.79"/>
|
|
<TableRow Name="Row9" Height="35.91">
|
|
<TableCell Name="Cell41"/>
|
|
<TableCell Name="Cell42" Text="3.检查皮肤及内科;" ColSpan="3"/>
|
|
<TableCell Name="Cell43"/>
|
|
<TableCell Name="Cell44"/>
|
|
<TableCell Name="Cell45" Text="医生签章："/>
|
|
</TableRow>
|
|
</TableObject>
|
|
</PageHeaderBand>
|
|
<DataBand Name="Data1" Top="544.76" Width="718.2" DataSource="Table">
|
|
<DataFooterBand Name="DataFooter1" Top="548.76" Width="718.2" Height="45.36">
|
|
<TableObject Name="Table8" Left="9.45" Width="708.75" Height="45.36">
|
|
<TableColumn Name="Column36" Width="77.49"/>
|
|
<TableColumn Name="Column37" Width="171.99"/>
|
|
<TableColumn Name="Column38" Width="171.99"/>
|
|
<TableColumn Name="Column39" Width="77.49"/>
|
|
<TableColumn Name="Column40" Width="209.79"/>
|
|
<TableRow Name="Row8" Height="45.36">
|
|
<TableCell Name="Cell36" Text="体检结束三个工作日后至两周内凭身份证和健康体检指引单来体检机构领证。" Font="Arial, 12pt, style=Bold" ColSpan="5"/>
|
|
<TableCell Name="Cell37" Font="Arial, 12pt, style=Bold"/>
|
|
<TableCell Name="Cell38" Font="Arial, 12pt, style=Bold"/>
|
|
<TableCell Name="Cell39" Font="Arial, 12pt, style=Bold"/>
|
|
<TableCell Name="Cell40" Font="Arial, 12pt, style=Bold"/>
|
|
</TableRow>
|
|
</TableObject>
|
|
</DataFooterBand>
|
|
</DataBand>
|
|
</ReportPage>
|
|
</Report>
|