310 lines
18 KiB
XML
310 lines
18 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<Report ScriptLanguage="CSharp" ReportInfo.Created="06/24/2017 13:16:54" ReportInfo.Modified="08/21/2023 09:31:01" ReportInfo.CreatorVersion="2016.1.0.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 Text21_AfterData(object sender, EventArgs e)
|
|
{
|
|
if(Text21.Text.Equals("no"))
|
|
{
|
|
Subreport1.Visible = false;
|
|
}
|
|
else
|
|
{
|
|
Subreport1.Visible = true;
|
|
}
|
|
Text21.Visible = false;
|
|
}
|
|
|
|
private void Text22_AfterData(object sender, EventArgs e)
|
|
{
|
|
if(Text22.Text.Equals("no"))
|
|
{
|
|
Subreport2.Visible = false;
|
|
}
|
|
else
|
|
{
|
|
Subreport2.Visible = true;
|
|
}
|
|
Text22.Visible = false;
|
|
}
|
|
|
|
private void Text23_AfterData(object sender, EventArgs e)
|
|
{
|
|
if(Text23.Text.Equals("no"))
|
|
{
|
|
Subreport3.Visible = false;
|
|
}
|
|
else
|
|
{
|
|
Subreport3.Visible = true;
|
|
}
|
|
Text23.Visible = false;
|
|
}
|
|
|
|
private void Text24_AfterData(object sender, EventArgs e)
|
|
{
|
|
if(Text24.Text.Equals("no"))
|
|
{
|
|
Subreport4.Visible = false;
|
|
}
|
|
else
|
|
{
|
|
Subreport4.Visible = true;
|
|
}
|
|
Text24.Visible = false;
|
|
}
|
|
}
|
|
}
|
|
</ScriptText>
|
|
<Dictionary>
|
|
<MsSqlDataConnection Name="Connection" ConnectionString="rijcmlqveABMfnqRj7Azp6bE+ejNjHm4xfNvDChgc0AjC2KM2vi1nVm2sdFZnA7liDtBhVcu4fyvEPIqq8rJAdSEMN7IacmzicJBH81sVQLGoUbt64noq4mjIAQ0PVfB5Jm4TZxzsjXCqYa2zckqubkPeps9oGP571ndnxqrwYvmaZuEGZN3F2zdqWLCYvtZmPob3Od6JkkYriNARCoXDAQBbr7Kw==">
|
|
<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"/>
|
|
<Parameter Name="strJYRoom" DataType="System.String"/>
|
|
<Parameter Name="strDBRoom" DataType="System.String"/>
|
|
<Parameter Name="bNote" DataType="System.String"/>
|
|
<Parameter Name="bJYNote" DataType="System.String"/>
|
|
<Parameter Name="bDBNote" DataType="System.String"/>
|
|
<Parameter Name="bNYNote" DataType="System.String"/>
|
|
<Parameter Name="strNYRoom" DataType="System.String"/>
|
|
</Dictionary>
|
|
<ReportPage Name="Page1" PaperWidth="80" PaperHeight="500" LeftMargin="0" RightMargin="0">
|
|
<ReportTitleBand Name="ReportTitle1" Width="302.4" Height="226.8">
|
|
<TextObject Name="Text1" Left="-9.45" Width="311.85" Height="47.25" Text="乐陵市铁营镇卫生院" HorzAlign="Center" VertAlign="Center" Font="Arial, 18pt"/>
|
|
<PictureObject Name="Picture1" Left="181" Top="94.5" Width="113.4" Height="122.85" DataColumn="imagedt.image"/>
|
|
<BarcodeObject Name="Barcode1" Left="19.9" Top="85.05" Width="116" Height="134" DataColumn="professionalExam_register.physical_num" Text="1234567891234" Barcode="QR Code" Barcode.ErrorCorrection="L" Barcode.Encoding="UTF8" Barcode.QuietZone="true"/>
|
|
<TextObject Name="Text13" Top="56.7" Width="302.4" Height="18.9" Text="[zydtop.zyd]" HorzAlign="Center" VertAlign="Bottom" Font="Arial, 10pt, style=Bold"/>
|
|
<TextObject Name="Text21" Left="207.9" Top="75.6" Width="94.5" Height="18.9" AfterDataEvent="Text21_AfterData" Text="[bNote]" VertAlign="Bottom" Font="宋体, 11pt"/>
|
|
<TextObject Name="Text22" Left="207.9" Top="94.5" Width="94.5" Height="18.9" AfterDataEvent="Text22_AfterData" Text="[bJYNote]" VertAlign="Bottom" Font="宋体, 11pt"/>
|
|
<TextObject Name="Text23" Left="207.9" Top="113.4" Width="94.5" Height="18.9" AfterDataEvent="Text23_AfterData" Text="[bDBNote]" VertAlign="Bottom" Font="宋体, 11pt"/>
|
|
<TextObject Name="Text24" Left="207.9" Top="132.3" Width="94.5" Height="18.9" AfterDataEvent="Text24_AfterData" Text="[bNYNote]" VertAlign="Bottom" Font="宋体, 11pt"/>
|
|
</ReportTitleBand>
|
|
<PageHeaderBand Name="PageHeader1" Top="230.8" Width="302.4" Height="264.6">
|
|
<TextObject Name="Text2" Left="9.45" Top="9.45" Width="94.5" Height="18.9" Text="姓 名：" Font="宋体, 12pt"/>
|
|
<TextObject Name="Text3" Left="9.45" Top="37.8" Width="94.5" Height="18.9" Text="身份证号：" Font="宋体, 12pt"/>
|
|
<TextObject Name="Text4" Left="9.45" Top="75.6" Width="94.5" Height="18.9" Text="行业类别：" Font="宋体, 12pt"/>
|
|
<TextObject Name="Text5" Left="9.45" Top="113.4" Width="94.5" Height="18.9" Text="单位名称：" Font="宋体, 12pt"/>
|
|
<TextObject Name="Text6" Left="85.05" Top="9.45" Width="245.7" Height="18.9" Text="[professionalExam_register.person_name]" Font="宋体, 12pt"/>
|
|
<TextObject Name="Text7" Left="85.05" Top="37.8" Width="207.9" Height="18.9" Text="[professionalExam_register.card_number]" Font="宋体, 12pt"/>
|
|
<TextObject Name="Text8" Left="85.05" Top="75.6" Width="94.5" Height="18.9" Text="[professionalExam_register.category]" Font="宋体, 12pt"/>
|
|
<TextObject Name="Text9" Left="85.05" Top="113.4" Width="245.7" Height="18.9" Text="[professionalExam_register.util_name]" Font="宋体, 12pt"/>
|
|
<TextObject Name="Text10" Left="9.45" Top="141.75" Width="94.5" Height="18.9" Text="性 别：" Font="宋体, 12pt"/>
|
|
<TextObject Name="Text11" Left="9.45" Top="179.55" Width="94.5" Height="18.9" Text="联系电话：" Font="宋体, 12pt"/>
|
|
<TextObject Name="Text12" Left="9.45" Top="217.35" Width="94.5" Height="18.9" Text="工 种：" Font="宋体, 12pt"/>
|
|
<TextObject Name="Text14" Left="85.05" Top="141.75" Width="94.5" Height="18.9" Text="[professionalExam_register.sex]" Font="宋体, 12pt"/>
|
|
<TextObject Name="Text15" Left="85.05" Top="179.55" Width="94.5" Height="18.9" Text="[professionalExam_register.phone]" Font="宋体, 12pt"/>
|
|
<TextObject Name="Text16" Left="85.05" Top="217.35" Width="94.5" Height="18.9" Text="[professionalExam_register.work_category]" Font="宋体, 12pt"/>
|
|
<TextObject Name="Text17" Left="9.45" Top="245.7" Width="94.5" Height="18.9" Text="体检项目：" Font="宋体, 12pt, style=Bold"/>
|
|
</PageHeaderBand>
|
|
<DataBand Name="Data1" Top="499.4" Width="302.4" Height="35.91" DataSource="Table">
|
|
<TableObject Name="Table7" Left="9.45" Width="296.4" Height="35.91">
|
|
<TableColumn Name="Column31" Width="9.45"/>
|
|
<TableColumn Name="Column32" Width="127.15"/>
|
|
<TableColumn Name="Column33" Width="127.15"/>
|
|
<TableColumn Name="Column34" Width="32.65"/>
|
|
<TableRow Name="Row7" Height="35.91" AutoSize="true">
|
|
<TableCell Name="Cell31" Font="宋体, 9pt"/>
|
|
<TableCell Name="Cell32" Text="[tjlctop.lc]" VertAlign="Center" Font="宋体, 12pt" ColSpan="3"/>
|
|
<TableCell Name="Cell33" Font="宋体, 9pt"/>
|
|
<TableCell Name="Cell34" Font="宋体, 9pt"/>
|
|
</TableRow>
|
|
</TableObject>
|
|
</DataBand>
|
|
<DataBand Name="Data3" Top="539.31" Width="302.4" Height="18.9">
|
|
<SubreportObject Name="Subreport1" Left="9.45" Width="94.5" Height="18.9" ReportPage="Page2"/>
|
|
</DataBand>
|
|
<DataBand Name="Data4" Top="562.21" Width="302.4" Height="18.9">
|
|
<SubreportObject Name="Subreport2" Left="9.45" Width="94.5" Height="18.9" ReportPage="Page3"/>
|
|
</DataBand>
|
|
<DataBand Name="Data5" Top="585.11" Width="302.4" Height="18.9">
|
|
<SubreportObject Name="Subreport3" Left="9.45" Width="94.5" Height="18.9" ReportPage="Page4"/>
|
|
</DataBand>
|
|
<DataBand Name="Data9" Top="608.01" Width="302.4" Height="18.9">
|
|
<SubreportObject Name="Subreport4" Left="9.45" Width="94.5" Height="18.9" ReportPage="Page5"/>
|
|
</DataBand>
|
|
<DataBand Name="Data2" Top="630.91" Width="302.4" Height="77.49">
|
|
<TableObject Name="Table12" Left="9.45" Width="298.62" Height="77.49">
|
|
<TableColumn Name="Column41" Width="0"/>
|
|
<TableColumn Name="Column42" Width="86.94"/>
|
|
<TableColumn Name="Column43" Width="86.94"/>
|
|
<TableColumn Name="Column44" Width="0"/>
|
|
<TableColumn Name="Column45" Width="124.74"/>
|
|
<TableRow Name="Row9" Height="77.49" AutoSize="true">
|
|
<TableCell Name="Cell41" Text="体检结束三个工作日后至两周内下午凭身份证和健康体检指引单来登记处自助机领证。" HorzAlign="Center" VertAlign="Center" Font="Arial, 14pt, style=Bold" ColSpan="5"/>
|
|
<TableCell Name="Cell42" Font="Arial, 12pt, style=Bold"/>
|
|
<TableCell Name="Cell43" Font="Arial, 12pt, style=Bold"/>
|
|
<TableCell Name="Cell44" Font="Arial, 12pt, style=Bold"/>
|
|
<TableCell Name="Cell45" Font="Arial, 12pt, style=Bold"/>
|
|
</TableRow>
|
|
</TableObject>
|
|
</DataBand>
|
|
</ReportPage>
|
|
<ReportPage Name="Page2">
|
|
<DataBand Name="Data6" Width="718.2" Height="28.35">
|
|
<TextObject Name="Text18" Width="103.95" Height="28.35" Text="注意事项：" VertAlign="Center" Font="宋体, 12pt, style=Bold"/>
|
|
</DataBand>
|
|
</ReportPage>
|
|
<ReportPage Name="Page3">
|
|
<DataBand Name="Data7" Width="718.2" Height="28.35">
|
|
<TextObject Name="Text19" Width="245.7" Height="28.35" Text="▲"[strJYRoom]"上午空腹静脉抽血;" VertAlign="Center" Font="宋体, 11pt"/>
|
|
</DataBand>
|
|
</ReportPage>
|
|
<ReportPage Name="Page4">
|
|
<DataBand Name="Data8" Width="718.2" Height="37.8">
|
|
<TextObject Name="Text20" Width="292.95" Height="37.8" Text="▲如需大便培养，请前往"[strDBRoom]"领取大便盒，留取大便样本后送回;" VertAlign="Bottom" Font="宋体, 11pt"/>
|
|
</DataBand>
|
|
</ReportPage>
|
|
<ReportPage Name="Page5">
|
|
<DataBand Name="Data10" Width="718.2" Height="37.8">
|
|
<TextObject Name="Text25" Width="292.95" Height="37.8" Text="▲如需尿常规检查，请前往"[strNYRoom]"领取尿样盒，留取尿样后送回;" VertAlign="Bottom" Font="宋体, 11pt"/>
|
|
</DataBand>
|
|
</ReportPage>
|
|
</Report>
|