318 lines
18 KiB
XML
318 lines
18 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<Report ScriptLanguage="CSharp" ReportInfo.Created="06/24/2017 13:16:54" ReportInfo.Modified="10/22/2023 13:39:31" 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
|
|
{
|
|
string ny="";
|
|
string jy="";
|
|
string db="";
|
|
private void Text3_AfterData(object sender, EventArgs e)
|
|
{
|
|
|
|
|
|
}
|
|
|
|
private void Text13_AfterData(object sender, EventArgs e)
|
|
{
|
|
|
|
}
|
|
|
|
private void Text11_AfterData(object sender, EventArgs e)
|
|
{
|
|
|
|
}
|
|
|
|
private void Text18_AfterData(object sender, EventArgs e)
|
|
{
|
|
ny = Text18.Text;
|
|
if(ny.Equals("no"))
|
|
{
|
|
Subreport4.Visible = false;
|
|
}
|
|
else
|
|
{
|
|
Subreport4.Visible = true;
|
|
}
|
|
Text18.Visible = false;
|
|
}
|
|
|
|
private void Text32_AfterData(object sender, EventArgs e)
|
|
{
|
|
jy =Text32.Text;
|
|
if(jy.Equals("no"))
|
|
{
|
|
Subreport2.Visible = false;
|
|
}
|
|
else
|
|
{
|
|
Subreport2.Visible = true;
|
|
}
|
|
Text32.Visible = false;
|
|
}
|
|
|
|
private void Text33_AfterData(object sender, EventArgs e)
|
|
{
|
|
db =Text33.Text;
|
|
if(db.Equals("no"))
|
|
{
|
|
Subreport3.Visible = false;
|
|
}
|
|
else
|
|
{
|
|
Subreport3.Visible = true;
|
|
}
|
|
Text33.Visible = false;
|
|
}
|
|
|
|
private void Text34_AfterData(object sender, EventArgs e)
|
|
{
|
|
string note = Text34.Text;
|
|
if(note.Equals("yes"))
|
|
{
|
|
Subreport1.Visible = true;
|
|
}
|
|
else
|
|
{
|
|
Subreport1.Visible = false;
|
|
}
|
|
Text34.Visible = false;
|
|
}
|
|
}
|
|
}
|
|
</ScriptText>
|
|
<Dictionary>
|
|
<MsSqlDataConnection Name="Connection" ConnectionString="rijcmlqveABMfnqRj7Azp6bE+ejNjHm4xfNvDChgc0AjC2KM2vi1nVm2sdFZnA7liDtBhVcu4fyvEPIqq8rJAdSEMN7IacmzicJBH81sVQLGoUbt64noq4mjIAQ0PVfB5Jm4TZxzsjXCqYa2zckqubkPeps9oGP571ndnxqrwYvmaZuEGZN3F2zdqWLCYvtZmPob3Od0vB1KDVQwzdSQFgaToAt9w==">
|
|
<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="Table5" Alias="bjxmdt" DataType="System.Int32" Enabled="true" SelectCommand="select ''as'bjxm'">
|
|
<Column Name="bjxm" DataType="System.String"/>
|
|
</TableDataSource>
|
|
<TableDataSource Name="Table" Alias="qxdt" DataType="System.Int32" Enabled="true" SelectCommand="select '' as 'qx'">
|
|
<Column Name="qx" DataType="System.String"/>
|
|
</TableDataSource>
|
|
<TableDataSource Name="Table1" Alias="smdt" DataType="System.Int32" Enabled="true" SelectCommand="select ''as'sm'">
|
|
<Column Name="sm" DataType="System.String"/>
|
|
</TableDataSource>
|
|
<TableDataSource Name="Table6" Alias="zydtop" DataType="System.Int32" Enabled="true" SelectCommand="select ''as'zyd'">
|
|
<Column Name="zyd" DataType="System.String"/>
|
|
</TableDataSource>
|
|
</MsSqlDataConnection>
|
|
<Parameter Name="examtype" DataType="System.String"/>
|
|
<Parameter Name="agreement_money" DataType="System.String"/>
|
|
<Parameter Name="bDBNote" DataType="System.String"/>
|
|
<Parameter Name="bJYNote" DataType="System.String"/>
|
|
<Parameter Name="bNYNote" DataType="System.String"/>
|
|
<Parameter Name="bNote" DataType="System.String"/>
|
|
<Parameter Name="strNYRoom" DataType="System.String"/>
|
|
<Parameter Name="strJYRoom" DataType="System.String"/>
|
|
<Parameter Name="strDBRoom" DataType="System.String"/>
|
|
</Dictionary>
|
|
<ReportPage Name="Page1" PaperWidth="80" PaperHeight="500" LeftMargin="0" TopMargin="20" RightMargin="0" BottomMargin="0" FirstPageSource="15" OtherPagesSource="15" Fill.Color="White">
|
|
<ReportTitleBand Name="ReportTitle1" Width="302.4" Height="217.35">
|
|
<TextObject Name="Text1" Width="292.95" Height="28.35" Text="乐陵市铁营镇卫生院" HorzAlign="Center" Font="宋体, 18pt"/>
|
|
<PictureObject Name="Picture1" Left="170.1" Top="75.6" Width="113.4" Height="122.85" DataColumn="imagedt.image"/>
|
|
<BarcodeObject Name="Barcode1" Left="11.45" Top="141.75" Width="153.75" Height="56.7" DataColumn="professionalExam_register.physical_num" Text="2201707150001" Barcode="Code128" Barcode.AutoEncode="true"/>
|
|
<TextObject Name="Text13" Left="-37.8" Top="28.35" Width="330.75" Height="18.9" AfterDataEvent="Text13_AfterData" Text="[zydtop.zyd]" HorzAlign="Center" Font="Arial, 10pt, style=Bold"/>
|
|
<TextObject Name="Text3" Left="9.45" Top="75.6" Width="94.5" Height="18.9" Visible="false" AfterDataEvent="Text3_AfterData" Text="[examtype]"/>
|
|
<TextObject Name="Text7" Left="9.45" Top="113.4" Width="94.5" Height="18.9" Visible="false" Text="qx"/>
|
|
<TextObject Name="Text11" Left="9.45" Top="47.25" Width="94.5" Height="18.9" Visible="false" AfterDataEvent="Text11_AfterData" Text="[agreement_money]"/>
|
|
<TextObject Name="Text33" Left="207.9" Top="151.2" Width="66.15" Height="18.9" AfterDataEvent="Text33_AfterData" Text="[bDBNote]" VertAlign="Bottom" Font="宋体, 9pt"/>
|
|
<TextObject Name="Text32" Left="207.9" Top="170.1" Width="66.15" Height="18.9" AfterDataEvent="Text32_AfterData" Text="[bJYNote]" VertAlign="Bottom" Font="宋体, 9pt"/>
|
|
<TextObject Name="Text18" Left="207.9" Top="189" Width="66.15" Height="18.9" AfterDataEvent="Text18_AfterData" Text="[bNYNote]" VertAlign="Bottom" Font="宋体, 9pt"/>
|
|
<TextObject Name="Text34" Left="207.9" Top="132.3" Width="66.15" Height="18.9" AfterDataEvent="Text34_AfterData" Text="[bNote]" VertAlign="Bottom" Font="宋体, 9pt"/>
|
|
</ReportTitleBand>
|
|
<DataBand Name="Data1" Top="384.45" Width="302.4" Height="35.91" DataSource="Table">
|
|
<TableObject Name="Table12" Left="18.9" Width="279.72" Height="35.91">
|
|
<TableColumn Name="Column46" Width="22.69"/>
|
|
<TableColumn Name="Column47" Width="257.03"/>
|
|
<TableRow Name="Row10" Height="35.91" AutoSize="true">
|
|
<TableCell Name="Cell46" Text="[qxdt.qx]" VertAlign="Center" ColSpan="2"/>
|
|
<TableCell Name="Cell47" VertAlign="Center"/>
|
|
</TableRow>
|
|
</TableObject>
|
|
<DataHeaderBand Name="DataHeader1" Top="220.58" Width="302.4" Height="160.65">
|
|
<TextObject Name="Text17" Top="132.3" Width="311.85" Height="28.35" Text="体检项目：" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
|
|
<TextObject Name="Text23" Left="576.45" Top="66.15" Width="94.5" Height="18.9"/>
|
|
<TextObject Name="Text5" Left="9.45" Top="114.75" Width="94.5" Height="18.9" Text="单位名称：" VertAlign="Bottom"/>
|
|
<TextObject Name="Text9" Left="85.05" Top="114.75" Width="217.35" Height="18.9" Text="[professionalExam_register.util_name]" VertAlign="Bottom"/>
|
|
<TextObject Name="Text2" Left="9.45" Width="94.5" Height="18.9" Text="姓 名：" VertAlign="Bottom"/>
|
|
<TextObject Name="Text6" Left="85.05" Width="207.9" Height="18.9" Text="[professionalExam_register.person_name]" VertAlign="Bottom"/>
|
|
<TextObject Name="Text10" Left="9.45" Top="10.9" Width="94.5" Height="28.35" Text="性 别：" VertAlign="Bottom"/>
|
|
<TextObject Name="Text14" Left="85.05" Top="10.9" Width="207.9" Height="28.35" Text="[professionalExam_register.sex]" VertAlign="Bottom"/>
|
|
<TextObject Name="Text26" Left="9.45" Top="43.7" Width="94.5" Height="18.9" Text="行业类别：" VertAlign="Bottom"/>
|
|
<TextObject Name="Text27" Left="85.05" Top="43.7" Width="207.9" Height="18.9" Text="[professionalExam_register.category]" VertAlign="Bottom"/>
|
|
<TextObject Name="Text28" Left="9.45" Top="66.05" Width="94.5" Height="18.9" Text="身份证号：" VertAlign="Bottom"/>
|
|
<TextObject Name="Text29" Left="85.05" Top="66.05" Width="207.9" Height="18.9" Text="[professionalExam_register.card_number]" VertAlign="Bottom"/>
|
|
<TextObject Name="Text30" Left="9.45" Top="90.4" Width="94.5" Height="18.9" Text="联系电话：" VertAlign="Bottom"/>
|
|
<TextObject Name="Text15" Left="85.05" Top="90.4" Width="94.5" Height="18.9" Text="[professionalExam_register.phone]" VertAlign="Bottom"/>
|
|
</DataHeaderBand>
|
|
</DataBand>
|
|
<DataBand Name="Data2" Top="423.59" Width="302.4" Height="18.9">
|
|
<SubreportObject Name="Subreport1" Width="94.5" Height="18.9" ReportPage="Page2"/>
|
|
</DataBand>
|
|
<DataBand Name="Data7" Top="445.71" Width="302.4" Height="18.9">
|
|
<SubreportObject Name="Subreport2" Width="94.5" Height="18.9" ReportPage="Page3"/>
|
|
</DataBand>
|
|
<DataBand Name="Data8" Top="467.84" Width="302.4" Height="18.9">
|
|
<SubreportObject Name="Subreport3" Width="94.5" Height="18.9" ReportPage="Page4"/>
|
|
</DataBand>
|
|
<DataBand Name="Data9" Top="489.96" Width="302.4" Height="18.9">
|
|
<SubreportObject Name="Subreport4" Width="94.5" Height="18.9" ReportPage="Page5"/>
|
|
</DataBand>
|
|
<DataBand Name="Data3" Top="512.09" Width="302.4" Height="94.5">
|
|
<TextObject Name="Text4" Top="9.45" Width="302.4" Height="75.6" AfterDataEvent="Text4_AfterData" Text="体检结束三个工作日后至两周内下午凭身份证和健康体检指引单来登记处领取体检报告。" Font="Arial, 14pt, style=Bold"/>
|
|
</DataBand>
|
|
</ReportPage>
|
|
<ReportPage Name="Page2">
|
|
<DataBand Name="Data4" Width="718.2" Height="28.35">
|
|
<TextObject Name="Text8" Top="9.45" Width="94.5" Height="18.9" Text="注意事项：" VertAlign="Bottom" Font="Arial, 10pt, style=Bold"/>
|
|
</DataBand>
|
|
</ReportPage>
|
|
<ReportPage Name="Page3">
|
|
<DataBand Name="Data5" Width="718.2" Height="28.35">
|
|
<TextObject Name="Text12" Left="18.9" Width="236.25" Height="28.35" Text="▲"[strJYRoom]"上午空腹静脉抽血;" VertAlign="Bottom" Font="宋体, 11pt"/>
|
|
</DataBand>
|
|
</ReportPage>
|
|
<ReportPage Name="Page4">
|
|
<DataBand Name="Data6" Width="718.2" Height="37.8">
|
|
<TextObject Name="Text16" Left="18.9" 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="Text31" Left="18.9" Width="292.95" Height="37.8" Text="▲如需尿常规检查，请前往"[strNYRoom]"领取尿样盒，留取尿样后送回;" VertAlign="Bottom" Font="宋体, 11pt"/>
|
|
</DataBand>
|
|
</ReportPage>
|
|
</Report>
|