258 lines
16 KiB
XML
258 lines
16 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<Report ScriptLanguage="CSharp" ReportInfo.Created="06/24/2017 13:16:54" ReportInfo.Modified="04/26/2021 15:09:55" ReportInfo.CreatorVersion="2019.4.4.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+ejNjHm4xfNvDChgc0AjC2KM2vi1nVm2sdFZnA7liDtBhVcu4fyvEPIqq8rJAdSEMN7IacmzicJBH81sVQLGoUbt64noq4mjIAQ0PVfB5Jm4TZxzsjXCqYa2zckqubkPeps9oGP571ndnxqrwYvmaZuEGZN3F2zdqWLCYvtZmPob3OdiSMefPr3pZb2oCf7rXtMTQ==">
|
|
<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" Watermark.Font="宋体, 60pt">
|
|
<ReportTitleBand Name="ReportTitle1" Width="718.2" Height="226.8">
|
|
<TextObject Name="Text1" Left="207.9" Top="28.35" Width="330.75" Height="47.25" Text="乐陵市铁营镇卫生院" Font="Arial, 18pt"/>
|
|
<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="207.9" Top="75.6" Width="330.75" Height="18.9" AfterDataEvent="Text13_AfterData" Text="[zydtop.zyd]" HorzAlign="Center" Font="Arial, 10pt, style=Bold"/>
|
|
</ReportTitleBand>
|
|
<PageHeaderBand Name="PageHeader1" Top="230" Width="718.2" Height="272.16">
|
|
<TextObject Name="Text2" Left="56.7" Top="18.9" Width="94.5" Height="18.9" Text="姓 名：" Font="Arial, 10pt"/>
|
|
<TextObject Name="Text3" Left="56.7" Top="56.7" Width="94.5" Height="18.9" Text="身份证号：" Font="Arial, 10pt"/>
|
|
<TextObject Name="Text4" Left="56.7" Top="94.5" Width="94.5" Height="18.9" Text="行业类别：" Font="Arial, 10pt"/>
|
|
<TextObject Name="Text5" Left="56.7" Top="132.3" Width="94.5" Height="18.9" Text="单位名称：" Font="Arial, 10pt"/>
|
|
<TextObject Name="Text6" Left="132.3" Top="18.9" Width="245.7" Height="18.9" Text="[professionalExam_register.person_name]" Font="Arial, 10pt"/>
|
|
<TextObject Name="Text7" Left="132.3" Top="56.7" Width="207.9" Height="18.9" Text="[professionalExam_register.card_number]" Font="Arial, 10pt"/>
|
|
<TextObject Name="Text8" Left="132.3" Top="94.5" Width="94.5" Height="18.9" Text="[professionalExam_register.category]" Font="Arial, 10pt"/>
|
|
<TextObject Name="Text9" Left="132.3" Top="132.3" Width="444.15" Height="18.9" Text="[professionalExam_register.util_name]" Font="Arial, 10pt"/>
|
|
<TextObject Name="Text10" Left="406.35" Top="18.9" Width="94.5" Height="18.9" Text="性 别：" Font="Arial, 10pt"/>
|
|
<TextObject Name="Text11" Left="406.35" Top="56.7" Width="94.5" Height="18.9" Text="联系电话：" Font="Arial, 10pt"/>
|
|
<TextObject Name="Text12" Left="406.35" Top="94.5" Width="94.5" Height="18.9" Text="工 种：" Font="Arial, 10pt"/>
|
|
<TextObject Name="Text14" Left="481.95" Top="18.9" Width="94.5" Height="18.9" Text="[professionalExam_register.sex]" Font="Arial, 10pt"/>
|
|
<TextObject Name="Text15" Left="481.95" Top="56.7" Width="94.5" Height="18.9" Text="[professionalExam_register.phone]" Font="Arial, 10pt"/>
|
|
<TextObject Name="Text16" Left="481.95" Top="94.5" Width="94.5" Height="18.9" Text="[professionalExam_register.work_category]" Font="Arial, 10pt"/>
|
|
<TextObject Name="Text17" Top="151.2" Width="94.5" Height="18.9" Text="体检流程：" Font="Arial, 10pt"/>
|
|
<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" Font="Arial, 10pt"/>
|
|
<TableCell Name="Cell22" Text="1. “血检(217)室 ” 上午空腹静脉抽血;" Font="Arial, 10pt" ColSpan="3"/>
|
|
<TableCell Name="Cell23" Font="Arial, 10pt"/>
|
|
<TableCell Name="Cell24" Font="Arial, 10pt"/>
|
|
<TableCell Name="Cell25" Text="医生签章：" Font="Arial, 10pt"/>
|
|
</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" Font="Arial, 10pt"/>
|
|
<TableCell Name="Cell27" Text="2.前往“(213)粪检室”领取大便盒 留取大便样本后送回;" Font="Arial, 10pt" ColSpan="3"/>
|
|
<TableCell Name="Cell28" Font="Arial, 10pt"/>
|
|
<TableCell Name="Cell29" Font="Arial, 10pt"/>
|
|
<TableCell Name="Cell30" Text="医生签章：" Font="Arial, 10pt"/>
|
|
</TableRow>
|
|
</TableObject>
|
|
<TextObject Name="Text18" Left="9.45" Top="170.1" Width="689.85" Height="28.35" Text="请在一楼收费处缴费或者通过微信关注“德城疾控查体中心”进行自助缴费。" VertAlign="Center" Font="宋体, 12pt, style=Bold"/>
|
|
</PageHeaderBand>
|
|
<DataBand Name="Data1" Top="505.36" Width="718.2" Height="35.91" DataSource="Table">
|
|
<TableObject Name="Table7" Left="9.45" Width="708.75" Height="35.91">
|
|
<TableColumn Name="Column31" Width="77.49"/>
|
|
<TableColumn Name="Column32" Width="171.99"/>
|
|
<TableColumn Name="Column33" Width="171.99"/>
|
|
<TableColumn Name="Column34" Width="77.49"/>
|
|
<TableColumn Name="Column35" Width="209.79"/>
|
|
<TableRow Name="Row7" Height="35.91">
|
|
<TableCell Name="Cell31" Font="Arial, 10pt"/>
|
|
<TableCell Name="Cell32" Text="[tjlctop.lc]" Font="Arial, 10pt" ColSpan="3"/>
|
|
<TableCell Name="Cell33" Font="Arial, 10pt"/>
|
|
<TableCell Name="Cell34" Font="Arial, 10pt"/>
|
|
<TableCell Name="Cell35" Text="医生签章：" Font="Arial, 10pt"/>
|
|
</TableRow>
|
|
</TableObject>
|
|
<DataFooterBand Name="DataFooter1" Top="544.47" 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>
|