673 lines
82 KiB
XML
673 lines
82 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<xs:schema id="dccdcDataSet" targetNamespace="http://tempuri.org/dccdcDataSet.xsd" xmlns:mstns="http://tempuri.org/dccdcDataSet.xsd" xmlns="http://tempuri.org/dccdcDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
|
|
<xs:annotation>
|
|
<xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
|
|
<DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
|
|
<Connections>
|
|
<Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="TJDB" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="TJDB (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.TJDB.ConnectionString" Provider="System.Data.SqlClient" />
|
|
</Connections>
|
|
<Tables>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="occupation_reportTableAdapter" GeneratorDataComponentClassName="occupation_reportTableAdapter" Name="occupation_report" UserDataComponentName="occupation_reportTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="TJDB (Web.config)" DbObjectName="dccdc.dbo.occupation_report" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>DELETE FROM [dbo].[occupation_report] WHERE (([id] = @Original_id))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[occupation_report] ([physical_num], [report_num], [check_start_time], [check_end_time], [subject_company], [entrust_company], [count_unit], [evaluation_basic], [diagnostic_standard], [status], [descript], [expersion_disease], [other_disease], [result_description], [per_factory_analysis], [treatment_opinion], [person_ids], [report_user_name], [report_person], [report_date], [report_status], [approve_user_name], [approve_person], [approve_date], [approve_back_desc], [issue_user_name], [issue_person], [issue_date], [issue_back_desc], [print_date], [print_person], [report_edit_type], [report_url]) VALUES (@physical_num, @report_num, @check_start_time, @check_end_time, @subject_company, @entrust_company, @count_unit, @evaluation_basic, @diagnostic_standard, @status, @descript, @expersion_disease, @other_disease, @result_description, @per_factory_analysis, @treatment_opinion, @person_ids, @report_user_name, @report_person, @report_date, @report_status, @approve_user_name, @approve_person, @approve_date, @approve_back_desc, @issue_user_name, @issue_person, @issue_date, @issue_back_desc, @print_date, @print_person, @report_edit_type, @report_url)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@physical_num" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="physical_num" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@report_num" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="report_num" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@check_start_time" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="check_start_time" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@check_end_time" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="check_end_time" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@subject_company" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="subject_company" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@entrust_company" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="entrust_company" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@count_unit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="count_unit" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@evaluation_basic" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="evaluation_basic" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@diagnostic_standard" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="diagnostic_standard" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@descript" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="descript" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@expersion_disease" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="expersion_disease" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@other_disease" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="other_disease" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@result_description" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="result_description" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@per_factory_analysis" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="per_factory_analysis" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@treatment_opinion" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="treatment_opinion" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@person_ids" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="person_ids" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@report_user_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="report_user_name" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@report_person" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="report_person" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@report_date" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="report_date" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@report_status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="report_status" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@approve_user_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="approve_user_name" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@approve_person" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="approve_person" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@approve_date" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="approve_date" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@approve_back_desc" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="approve_back_desc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@issue_user_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="issue_user_name" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@issue_person" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="issue_person" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@issue_date" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="issue_date" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@issue_back_desc" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="issue_back_desc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@print_date" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="print_date" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@print_person" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="print_person" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@report_edit_type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="report_edit_type" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@report_url" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="report_url" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT id, physical_num, report_num, check_start_time, check_end_time, subject_company, entrust_company, count_unit, evaluation_basic, diagnostic_standard, status, descript, expersion_disease, other_disease, result_description, per_factory_analysis, treatment_opinion, person_ids, report_user_name, report_person, report_date, report_status, approve_user_name, approve_person, approve_date, approve_back_desc, issue_user_name, issue_person, issue_date, issue_back_desc, print_date, print_person, report_edit_type, report_url FROM dbo.occupation_report</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[occupation_report] SET [physical_num] = @physical_num, [report_num] = @report_num, [check_start_time] = @check_start_time, [check_end_time] = @check_end_time, [subject_company] = @subject_company, [entrust_company] = @entrust_company, [count_unit] = @count_unit, [evaluation_basic] = @evaluation_basic, [diagnostic_standard] = @diagnostic_standard, [status] = @status, [descript] = @descript, [expersion_disease] = @expersion_disease, [other_disease] = @other_disease, [result_description] = @result_description, [per_factory_analysis] = @per_factory_analysis, [treatment_opinion] = @treatment_opinion, [person_ids] = @person_ids, [report_user_name] = @report_user_name, [report_person] = @report_person, [report_date] = @report_date, [report_status] = @report_status, [approve_user_name] = @approve_user_name, [approve_person] = @approve_person, [approve_date] = @approve_date, [approve_back_desc] = @approve_back_desc, [issue_user_name] = @issue_user_name, [issue_person] = @issue_person, [issue_date] = @issue_date, [issue_back_desc] = @issue_back_desc, [print_date] = @print_date, [print_person] = @print_person, [report_edit_type] = @report_edit_type, [report_url] = @report_url WHERE (([id] = @Original_id))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@physical_num" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="physical_num" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@report_num" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="report_num" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@check_start_time" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="check_start_time" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@check_end_time" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="check_end_time" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@subject_company" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="subject_company" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@entrust_company" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="entrust_company" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@count_unit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="count_unit" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@evaluation_basic" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="evaluation_basic" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@diagnostic_standard" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="diagnostic_standard" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@descript" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="descript" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@expersion_disease" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="expersion_disease" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@other_disease" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="other_disease" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@result_description" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="result_description" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@per_factory_analysis" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="per_factory_analysis" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@treatment_opinion" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="treatment_opinion" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@person_ids" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="person_ids" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@report_user_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="report_user_name" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@report_person" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="report_person" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@report_date" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="report_date" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@report_status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="report_status" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@approve_user_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="approve_user_name" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@approve_person" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="approve_person" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@approve_date" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="approve_date" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@approve_back_desc" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="approve_back_desc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@issue_user_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="issue_user_name" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@issue_person" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="issue_person" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@issue_date" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="issue_date" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@issue_back_desc" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="issue_back_desc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@print_date" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="print_date" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@print_person" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="print_person" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@report_edit_type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="report_edit_type" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@report_url" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="report_url" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="id" DataSetColumn="id" />
|
|
<Mapping SourceColumn="physical_num" DataSetColumn="physical_num" />
|
|
<Mapping SourceColumn="report_num" DataSetColumn="report_num" />
|
|
<Mapping SourceColumn="check_start_time" DataSetColumn="check_start_time" />
|
|
<Mapping SourceColumn="check_end_time" DataSetColumn="check_end_time" />
|
|
<Mapping SourceColumn="subject_company" DataSetColumn="subject_company" />
|
|
<Mapping SourceColumn="entrust_company" DataSetColumn="entrust_company" />
|
|
<Mapping SourceColumn="count_unit" DataSetColumn="count_unit" />
|
|
<Mapping SourceColumn="evaluation_basic" DataSetColumn="evaluation_basic" />
|
|
<Mapping SourceColumn="diagnostic_standard" DataSetColumn="diagnostic_standard" />
|
|
<Mapping SourceColumn="status" DataSetColumn="status" />
|
|
<Mapping SourceColumn="descript" DataSetColumn="descript" />
|
|
<Mapping SourceColumn="expersion_disease" DataSetColumn="expersion_disease" />
|
|
<Mapping SourceColumn="other_disease" DataSetColumn="other_disease" />
|
|
<Mapping SourceColumn="result_description" DataSetColumn="result_description" />
|
|
<Mapping SourceColumn="per_factory_analysis" DataSetColumn="per_factory_analysis" />
|
|
<Mapping SourceColumn="treatment_opinion" DataSetColumn="treatment_opinion" />
|
|
<Mapping SourceColumn="person_ids" DataSetColumn="person_ids" />
|
|
<Mapping SourceColumn="report_user_name" DataSetColumn="report_user_name" />
|
|
<Mapping SourceColumn="report_person" DataSetColumn="report_person" />
|
|
<Mapping SourceColumn="report_date" DataSetColumn="report_date" />
|
|
<Mapping SourceColumn="report_status" DataSetColumn="report_status" />
|
|
<Mapping SourceColumn="approve_user_name" DataSetColumn="approve_user_name" />
|
|
<Mapping SourceColumn="approve_person" DataSetColumn="approve_person" />
|
|
<Mapping SourceColumn="approve_date" DataSetColumn="approve_date" />
|
|
<Mapping SourceColumn="approve_back_desc" DataSetColumn="approve_back_desc" />
|
|
<Mapping SourceColumn="issue_user_name" DataSetColumn="issue_user_name" />
|
|
<Mapping SourceColumn="issue_person" DataSetColumn="issue_person" />
|
|
<Mapping SourceColumn="issue_date" DataSetColumn="issue_date" />
|
|
<Mapping SourceColumn="issue_back_desc" DataSetColumn="issue_back_desc" />
|
|
<Mapping SourceColumn="print_date" DataSetColumn="print_date" />
|
|
<Mapping SourceColumn="print_person" DataSetColumn="print_person" />
|
|
<Mapping SourceColumn="report_edit_type" DataSetColumn="report_edit_type" />
|
|
<Mapping SourceColumn="report_url" DataSetColumn="report_url" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="enterprise_info_maintainTableAdapter" GeneratorDataComponentClassName="enterprise_info_maintainTableAdapter" Name="enterprise_info_maintain" UserDataComponentName="enterprise_info_maintainTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="TJDB (Web.config)" DbObjectName="dccdc.dbo.enterprise_info_maintain" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>DELETE FROM [dbo].[enterprise_info_maintain] WHERE (([id] = @Original_id))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[enterprise_info_maintain] ([enterprise_name], [abbreviation], [enterprise_pinyincode], [post_id], [address], [belong_area], [area_info_maintain_id], [belong_trade], [org_code], [city_rural_type], [school_type], [trade_maintain_id], [contacts], [telephone], [email], [portraiture], [introduction], [status], [attribution], [loginname], [loginpwd]) VALUES (@enterprise_name, @abbreviation, @enterprise_pinyincode, @post_id, @address, @belong_area, @area_info_maintain_id, @belong_trade, @org_code, @city_rural_type, @school_type, @trade_maintain_id, @contacts, @telephone, @email, @portraiture, @introduction, @status, @attribution, @loginname, @loginpwd)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@enterprise_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="enterprise_name" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@abbreviation" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="abbreviation" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@enterprise_pinyincode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="enterprise_pinyincode" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@post_id" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="post_id" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="address" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@belong_area" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="belong_area" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@area_info_maintain_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="area_info_maintain_id" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@belong_trade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="belong_trade" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@org_code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="org_code" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@city_rural_type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="city_rural_type" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@school_type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="school_type" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@trade_maintain_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="trade_maintain_id" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@contacts" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="contacts" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@telephone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="telephone" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@portraiture" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="portraiture" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@introduction" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="introduction" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@attribution" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="attribution" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@loginname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="loginname" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@loginpwd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="loginpwd" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT id, enterprise_name, abbreviation, enterprise_pinyincode, post_id, address, belong_area, area_info_maintain_id, belong_trade, org_code, city_rural_type, school_type, trade_maintain_id, contacts, telephone, email, portraiture, introduction, status, attribution, loginname, loginpwd FROM dbo.enterprise_info_maintain</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[enterprise_info_maintain] SET [enterprise_name] = @enterprise_name, [abbreviation] = @abbreviation, [enterprise_pinyincode] = @enterprise_pinyincode, [post_id] = @post_id, [address] = @address, [belong_area] = @belong_area, [area_info_maintain_id] = @area_info_maintain_id, [belong_trade] = @belong_trade, [org_code] = @org_code, [city_rural_type] = @city_rural_type, [school_type] = @school_type, [trade_maintain_id] = @trade_maintain_id, [contacts] = @contacts, [telephone] = @telephone, [email] = @email, [portraiture] = @portraiture, [introduction] = @introduction, [status] = @status, [attribution] = @attribution, [loginname] = @loginname, [loginpwd] = @loginpwd WHERE (([id] = @Original_id))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@enterprise_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="enterprise_name" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@abbreviation" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="abbreviation" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@enterprise_pinyincode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="enterprise_pinyincode" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@post_id" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="post_id" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="address" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@belong_area" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="belong_area" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@area_info_maintain_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="area_info_maintain_id" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@belong_trade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="belong_trade" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@org_code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="org_code" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@city_rural_type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="city_rural_type" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@school_type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="school_type" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@trade_maintain_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="trade_maintain_id" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@contacts" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="contacts" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@telephone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="telephone" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@portraiture" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="portraiture" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@introduction" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="introduction" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@attribution" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="attribution" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@loginname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="loginname" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@loginpwd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="loginpwd" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="id" DataSetColumn="id" />
|
|
<Mapping SourceColumn="enterprise_name" DataSetColumn="enterprise_name" />
|
|
<Mapping SourceColumn="abbreviation" DataSetColumn="abbreviation" />
|
|
<Mapping SourceColumn="enterprise_pinyincode" DataSetColumn="enterprise_pinyincode" />
|
|
<Mapping SourceColumn="post_id" DataSetColumn="post_id" />
|
|
<Mapping SourceColumn="address" DataSetColumn="address" />
|
|
<Mapping SourceColumn="belong_area" DataSetColumn="belong_area" />
|
|
<Mapping SourceColumn="area_info_maintain_id" DataSetColumn="area_info_maintain_id" />
|
|
<Mapping SourceColumn="belong_trade" DataSetColumn="belong_trade" />
|
|
<Mapping SourceColumn="org_code" DataSetColumn="org_code" />
|
|
<Mapping SourceColumn="city_rural_type" DataSetColumn="city_rural_type" />
|
|
<Mapping SourceColumn="school_type" DataSetColumn="school_type" />
|
|
<Mapping SourceColumn="trade_maintain_id" DataSetColumn="trade_maintain_id" />
|
|
<Mapping SourceColumn="contacts" DataSetColumn="contacts" />
|
|
<Mapping SourceColumn="telephone" DataSetColumn="telephone" />
|
|
<Mapping SourceColumn="email" DataSetColumn="email" />
|
|
<Mapping SourceColumn="portraiture" DataSetColumn="portraiture" />
|
|
<Mapping SourceColumn="introduction" DataSetColumn="introduction" />
|
|
<Mapping SourceColumn="status" DataSetColumn="status" />
|
|
<Mapping SourceColumn="attribution" DataSetColumn="attribution" />
|
|
<Mapping SourceColumn="loginname" DataSetColumn="loginname" />
|
|
<Mapping SourceColumn="loginpwd" DataSetColumn="loginpwd" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
</Tables>
|
|
<Sources />
|
|
</DataSource>
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
<xs:element name="dccdcDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="dccdcDataSet" msprop:Generator_UserDSName="dccdcDataSet">
|
|
<xs:complexType>
|
|
<xs:choice minOccurs="0" maxOccurs="unbounded">
|
|
<xs:element name="occupation_report" msprop:Generator_TableClassName="occupation_reportDataTable" msprop:Generator_TableVarName="tableoccupation_report" msprop:Generator_TablePropName="occupation_report" msprop:Generator_RowDeletingName="occupation_reportRowDeleting" msprop:Generator_RowChangingName="occupation_reportRowChanging" msprop:Generator_RowEvHandlerName="occupation_reportRowChangeEventHandler" msprop:Generator_RowDeletedName="occupation_reportRowDeleted" msprop:Generator_UserTableName="occupation_report" msprop:Generator_RowChangedName="occupation_reportRowChanged" msprop:Generator_RowEvArgName="occupation_reportRowChangeEvent" msprop:Generator_RowClassName="occupation_reportRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
|
|
<xs:element name="physical_num" msprop:Generator_ColumnVarNameInTable="columnphysical_num" msprop:Generator_ColumnPropNameInRow="physical_num" msprop:Generator_ColumnPropNameInTable="physical_numColumn" msprop:Generator_UserColumnName="physical_num" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="report_num" msprop:Generator_ColumnVarNameInTable="columnreport_num" msprop:Generator_ColumnPropNameInRow="report_num" msprop:Generator_ColumnPropNameInTable="report_numColumn" msprop:Generator_UserColumnName="report_num" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="check_start_time" msprop:Generator_ColumnVarNameInTable="columncheck_start_time" msprop:Generator_ColumnPropNameInRow="check_start_time" msprop:Generator_ColumnPropNameInTable="check_start_timeColumn" msprop:Generator_UserColumnName="check_start_time" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="check_end_time" msprop:Generator_ColumnVarNameInTable="columncheck_end_time" msprop:Generator_ColumnPropNameInRow="check_end_time" msprop:Generator_ColumnPropNameInTable="check_end_timeColumn" msprop:Generator_UserColumnName="check_end_time" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="subject_company" msprop:Generator_ColumnVarNameInTable="columnsubject_company" msprop:Generator_ColumnPropNameInRow="subject_company" msprop:Generator_ColumnPropNameInTable="subject_companyColumn" msprop:Generator_UserColumnName="subject_company" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="entrust_company" msprop:Generator_ColumnVarNameInTable="columnentrust_company" msprop:Generator_ColumnPropNameInRow="entrust_company" msprop:Generator_ColumnPropNameInTable="entrust_companyColumn" msprop:Generator_UserColumnName="entrust_company" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="count_unit" msprop:Generator_ColumnVarNameInTable="columncount_unit" msprop:Generator_ColumnPropNameInRow="count_unit" msprop:Generator_ColumnPropNameInTable="count_unitColumn" msprop:Generator_UserColumnName="count_unit" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="evaluation_basic" msprop:Generator_ColumnVarNameInTable="columnevaluation_basic" msprop:Generator_ColumnPropNameInRow="evaluation_basic" msprop:Generator_ColumnPropNameInTable="evaluation_basicColumn" msprop:Generator_UserColumnName="evaluation_basic" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="diagnostic_standard" msprop:Generator_ColumnVarNameInTable="columndiagnostic_standard" msprop:Generator_ColumnPropNameInRow="diagnostic_standard" msprop:Generator_ColumnPropNameInTable="diagnostic_standardColumn" msprop:Generator_UserColumnName="diagnostic_standard" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="status" msprop:Generator_ColumnVarNameInTable="columnstatus" msprop:Generator_ColumnPropNameInRow="status" msprop:Generator_ColumnPropNameInTable="statusColumn" msprop:Generator_UserColumnName="status" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="descript" msprop:Generator_ColumnVarNameInTable="columndescript" msprop:Generator_ColumnPropNameInRow="descript" msprop:Generator_ColumnPropNameInTable="descriptColumn" msprop:Generator_UserColumnName="descript" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="expersion_disease" msprop:Generator_ColumnVarNameInTable="columnexpersion_disease" msprop:Generator_ColumnPropNameInRow="expersion_disease" msprop:Generator_ColumnPropNameInTable="expersion_diseaseColumn" msprop:Generator_UserColumnName="expersion_disease" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="5" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="other_disease" msprop:Generator_ColumnVarNameInTable="columnother_disease" msprop:Generator_ColumnPropNameInRow="other_disease" msprop:Generator_ColumnPropNameInTable="other_diseaseColumn" msprop:Generator_UserColumnName="other_disease" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="5" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="result_description" msprop:Generator_ColumnVarNameInTable="columnresult_description" msprop:Generator_ColumnPropNameInRow="result_description" msprop:Generator_ColumnPropNameInTable="result_descriptionColumn" msprop:Generator_UserColumnName="result_description" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="per_factory_analysis" msprop:Generator_ColumnVarNameInTable="columnper_factory_analysis" msprop:Generator_ColumnPropNameInRow="per_factory_analysis" msprop:Generator_ColumnPropNameInTable="per_factory_analysisColumn" msprop:Generator_UserColumnName="per_factory_analysis" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="treatment_opinion" msprop:Generator_ColumnVarNameInTable="columntreatment_opinion" msprop:Generator_ColumnPropNameInRow="treatment_opinion" msprop:Generator_ColumnPropNameInTable="treatment_opinionColumn" msprop:Generator_UserColumnName="treatment_opinion" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="person_ids" msprop:Generator_ColumnVarNameInTable="columnperson_ids" msprop:Generator_ColumnPropNameInRow="person_ids" msprop:Generator_ColumnPropNameInTable="person_idsColumn" msprop:Generator_UserColumnName="person_ids" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="5000" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="report_user_name" msprop:Generator_ColumnVarNameInTable="columnreport_user_name" msprop:Generator_ColumnPropNameInRow="report_user_name" msprop:Generator_ColumnPropNameInTable="report_user_nameColumn" msprop:Generator_UserColumnName="report_user_name" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="report_person" msprop:Generator_ColumnVarNameInTable="columnreport_person" msprop:Generator_ColumnPropNameInRow="report_person" msprop:Generator_ColumnPropNameInTable="report_personColumn" msprop:Generator_UserColumnName="report_person" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="report_date" msprop:Generator_ColumnVarNameInTable="columnreport_date" msprop:Generator_ColumnPropNameInRow="report_date" msprop:Generator_ColumnPropNameInTable="report_dateColumn" msprop:Generator_UserColumnName="report_date" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="report_status" msprop:Generator_ColumnVarNameInTable="columnreport_status" msprop:Generator_ColumnPropNameInRow="report_status" msprop:Generator_ColumnPropNameInTable="report_statusColumn" msprop:Generator_UserColumnName="report_status" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="approve_user_name" msprop:Generator_ColumnVarNameInTable="columnapprove_user_name" msprop:Generator_ColumnPropNameInRow="approve_user_name" msprop:Generator_ColumnPropNameInTable="approve_user_nameColumn" msprop:Generator_UserColumnName="approve_user_name" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="approve_person" msprop:Generator_ColumnVarNameInTable="columnapprove_person" msprop:Generator_ColumnPropNameInRow="approve_person" msprop:Generator_ColumnPropNameInTable="approve_personColumn" msprop:Generator_UserColumnName="approve_person" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="approve_date" msprop:Generator_ColumnVarNameInTable="columnapprove_date" msprop:Generator_ColumnPropNameInRow="approve_date" msprop:Generator_ColumnPropNameInTable="approve_dateColumn" msprop:Generator_UserColumnName="approve_date" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="approve_back_desc" msprop:Generator_ColumnVarNameInTable="columnapprove_back_desc" msprop:Generator_ColumnPropNameInRow="approve_back_desc" msprop:Generator_ColumnPropNameInTable="approve_back_descColumn" msprop:Generator_UserColumnName="approve_back_desc" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="issue_user_name" msprop:Generator_ColumnVarNameInTable="columnissue_user_name" msprop:Generator_ColumnPropNameInRow="issue_user_name" msprop:Generator_ColumnPropNameInTable="issue_user_nameColumn" msprop:Generator_UserColumnName="issue_user_name" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="issue_person" msprop:Generator_ColumnVarNameInTable="columnissue_person" msprop:Generator_ColumnPropNameInRow="issue_person" msprop:Generator_ColumnPropNameInTable="issue_personColumn" msprop:Generator_UserColumnName="issue_person" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="issue_date" msprop:Generator_ColumnVarNameInTable="columnissue_date" msprop:Generator_ColumnPropNameInRow="issue_date" msprop:Generator_ColumnPropNameInTable="issue_dateColumn" msprop:Generator_UserColumnName="issue_date" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="issue_back_desc" msprop:Generator_ColumnVarNameInTable="columnissue_back_desc" msprop:Generator_ColumnPropNameInRow="issue_back_desc" msprop:Generator_ColumnPropNameInTable="issue_back_descColumn" msprop:Generator_UserColumnName="issue_back_desc" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="print_date" msprop:Generator_ColumnVarNameInTable="columnprint_date" msprop:Generator_ColumnPropNameInRow="print_date" msprop:Generator_ColumnPropNameInTable="print_dateColumn" msprop:Generator_UserColumnName="print_date" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="print_person" msprop:Generator_ColumnVarNameInTable="columnprint_person" msprop:Generator_ColumnPropNameInRow="print_person" msprop:Generator_ColumnPropNameInTable="print_personColumn" msprop:Generator_UserColumnName="print_person" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="report_edit_type" msprop:Generator_ColumnVarNameInTable="columnreport_edit_type" msprop:Generator_ColumnPropNameInRow="report_edit_type" msprop:Generator_ColumnPropNameInTable="report_edit_typeColumn" msprop:Generator_UserColumnName="report_edit_type" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="report_url" msprop:Generator_ColumnVarNameInTable="columnreport_url" msprop:Generator_ColumnPropNameInRow="report_url" msprop:Generator_ColumnPropNameInTable="report_urlColumn" msprop:Generator_UserColumnName="report_url" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="enterprise_info_maintain" msprop:Generator_TableClassName="enterprise_info_maintainDataTable" msprop:Generator_TableVarName="tableenterprise_info_maintain" msprop:Generator_TablePropName="enterprise_info_maintain" msprop:Generator_RowDeletingName="enterprise_info_maintainRowDeleting" msprop:Generator_RowChangingName="enterprise_info_maintainRowChanging" msprop:Generator_RowEvHandlerName="enterprise_info_maintainRowChangeEventHandler" msprop:Generator_RowDeletedName="enterprise_info_maintainRowDeleted" msprop:Generator_UserTableName="enterprise_info_maintain" msprop:Generator_RowChangedName="enterprise_info_maintainRowChanged" msprop:Generator_RowEvArgName="enterprise_info_maintainRowChangeEvent" msprop:Generator_RowClassName="enterprise_info_maintainRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
|
|
<xs:element name="enterprise_name" msprop:Generator_ColumnVarNameInTable="columnenterprise_name" msprop:Generator_ColumnPropNameInRow="enterprise_name" msprop:Generator_ColumnPropNameInTable="enterprise_nameColumn" msprop:Generator_UserColumnName="enterprise_name" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="abbreviation" msprop:Generator_ColumnVarNameInTable="columnabbreviation" msprop:Generator_ColumnPropNameInRow="abbreviation" msprop:Generator_ColumnPropNameInTable="abbreviationColumn" msprop:Generator_UserColumnName="abbreviation" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="enterprise_pinyincode" msprop:Generator_ColumnVarNameInTable="columnenterprise_pinyincode" msprop:Generator_ColumnPropNameInRow="enterprise_pinyincode" msprop:Generator_ColumnPropNameInTable="enterprise_pinyincodeColumn" msprop:Generator_UserColumnName="enterprise_pinyincode" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="post_id" msprop:Generator_ColumnVarNameInTable="columnpost_id" msprop:Generator_ColumnPropNameInRow="post_id" msprop:Generator_ColumnPropNameInTable="post_idColumn" msprop:Generator_UserColumnName="post_id" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="address" msprop:Generator_ColumnVarNameInTable="columnaddress" msprop:Generator_ColumnPropNameInRow="address" msprop:Generator_ColumnPropNameInTable="addressColumn" msprop:Generator_UserColumnName="address" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="belong_area" msprop:Generator_ColumnVarNameInTable="columnbelong_area" msprop:Generator_ColumnPropNameInRow="belong_area" msprop:Generator_ColumnPropNameInTable="belong_areaColumn" msprop:Generator_UserColumnName="belong_area" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="area_info_maintain_id" msprop:Generator_ColumnVarNameInTable="columnarea_info_maintain_id" msprop:Generator_ColumnPropNameInRow="area_info_maintain_id" msprop:Generator_ColumnPropNameInTable="area_info_maintain_idColumn" msprop:Generator_UserColumnName="area_info_maintain_id" type="xs:int" minOccurs="0" />
|
|
<xs:element name="belong_trade" msprop:Generator_ColumnVarNameInTable="columnbelong_trade" msprop:Generator_ColumnPropNameInRow="belong_trade" msprop:Generator_ColumnPropNameInTable="belong_tradeColumn" msprop:Generator_UserColumnName="belong_trade" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="org_code" msprop:Generator_ColumnVarNameInTable="columnorg_code" msprop:Generator_ColumnPropNameInRow="org_code" msprop:Generator_ColumnPropNameInTable="org_codeColumn" msprop:Generator_UserColumnName="org_code" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="city_rural_type" msprop:Generator_ColumnVarNameInTable="columncity_rural_type" msprop:Generator_ColumnPropNameInRow="city_rural_type" msprop:Generator_ColumnPropNameInTable="city_rural_typeColumn" msprop:Generator_UserColumnName="city_rural_type" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="school_type" msprop:Generator_ColumnVarNameInTable="columnschool_type" msprop:Generator_ColumnPropNameInRow="school_type" msprop:Generator_ColumnPropNameInTable="school_typeColumn" msprop:Generator_UserColumnName="school_type" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="trade_maintain_id" msprop:Generator_ColumnVarNameInTable="columntrade_maintain_id" msprop:Generator_ColumnPropNameInRow="trade_maintain_id" msprop:Generator_ColumnPropNameInTable="trade_maintain_idColumn" msprop:Generator_UserColumnName="trade_maintain_id" type="xs:int" minOccurs="0" />
|
|
<xs:element name="contacts" msprop:Generator_ColumnVarNameInTable="columncontacts" msprop:Generator_ColumnPropNameInRow="contacts" msprop:Generator_ColumnPropNameInTable="contactsColumn" msprop:Generator_UserColumnName="contacts" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="telephone" msprop:Generator_ColumnVarNameInTable="columntelephone" msprop:Generator_ColumnPropNameInRow="telephone" msprop:Generator_ColumnPropNameInTable="telephoneColumn" msprop:Generator_UserColumnName="telephone" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnPropNameInTable="emailColumn" msprop:Generator_UserColumnName="email" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="portraiture" msprop:Generator_ColumnVarNameInTable="columnportraiture" msprop:Generator_ColumnPropNameInRow="portraiture" msprop:Generator_ColumnPropNameInTable="portraitureColumn" msprop:Generator_UserColumnName="portraiture" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="introduction" msprop:Generator_ColumnVarNameInTable="columnintroduction" msprop:Generator_ColumnPropNameInRow="introduction" msprop:Generator_ColumnPropNameInTable="introductionColumn" msprop:Generator_UserColumnName="introduction" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="status" msprop:Generator_ColumnVarNameInTable="columnstatus" msprop:Generator_ColumnPropNameInRow="status" msprop:Generator_ColumnPropNameInTable="statusColumn" msprop:Generator_UserColumnName="status" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="5" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="attribution" msprop:Generator_ColumnVarNameInTable="columnattribution" msprop:Generator_ColumnPropNameInRow="attribution" msprop:Generator_ColumnPropNameInTable="attributionColumn" msprop:Generator_UserColumnName="attribution" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="loginname" msprop:Generator_ColumnVarNameInTable="columnloginname" msprop:Generator_ColumnPropNameInRow="loginname" msprop:Generator_ColumnPropNameInTable="loginnameColumn" msprop:Generator_UserColumnName="loginname" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="loginpwd" msprop:Generator_ColumnVarNameInTable="columnloginpwd" msprop:Generator_ColumnPropNameInRow="loginpwd" msprop:Generator_ColumnPropNameInTable="loginpwdColumn" msprop:Generator_UserColumnName="loginpwd" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="tjjg" msprop:Generator_TableClassName="tjjgDataTable" msprop:Generator_TableVarName="tabletjjg" msprop:Generator_RowChangedName="tjjgRowChanged" msprop:Generator_TablePropName="tjjg" msprop:Generator_RowDeletingName="tjjgRowDeleting" msprop:Generator_RowChangingName="tjjgRowChanging" msprop:Generator_RowEvHandlerName="tjjgRowChangeEventHandler" msprop:Generator_RowDeletedName="tjjgRowDeleted" msprop:Generator_RowClassName="tjjgRow" msprop:Generator_UserTableName="tjjg" msprop:Generator_RowEvArgName="tjjgRowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="physical_num" msprop:Generator_ColumnVarNameInTable="columnphysical_num" msprop:Generator_ColumnPropNameInRow="physical_num" msprop:Generator_ColumnPropNameInTable="physical_numColumn" msprop:Generator_UserColumnName="physical_num" type="xs:string" minOccurs="0" />
|
|
<xs:element name="person_name" msprop:Generator_ColumnVarNameInTable="columnperson_name" msprop:Generator_ColumnPropNameInRow="person_name" msprop:Generator_ColumnPropNameInTable="person_nameColumn" msprop:Generator_UserColumnName="person_name" type="xs:string" minOccurs="0" />
|
|
<xs:element name="sex" msprop:Generator_ColumnVarNameInTable="columnsex" msprop:Generator_ColumnPropNameInRow="sex" msprop:Generator_ColumnPropNameInTable="sexColumn" msprop:Generator_UserColumnName="sex" type="xs:string" minOccurs="0" />
|
|
<xs:element name="department" msprop:Generator_ColumnVarNameInTable="columndepartment" msprop:Generator_ColumnPropNameInRow="department" msprop:Generator_ColumnPropNameInTable="departmentColumn" msprop:Generator_UserColumnName="department" type="xs:string" minOccurs="0" />
|
|
<xs:element name="work_category" msprop:Generator_ColumnVarNameInTable="columnwork_category" msprop:Generator_ColumnPropNameInRow="work_category" msprop:Generator_ColumnPropNameInTable="work_categoryColumn" msprop:Generator_UserColumnName="work_category" type="xs:string" minOccurs="0" />
|
|
<xs:element name="work_years" msprop:Generator_ColumnVarNameInTable="columnwork_years" msprop:Generator_ColumnPropNameInRow="work_years" msprop:Generator_ColumnPropNameInTable="work_yearsColumn" msprop:Generator_UserColumnName="work_years" type="xs:string" minOccurs="0" />
|
|
<xs:element name="hazards" msprop:Generator_ColumnVarNameInTable="columnhazards" msprop:Generator_ColumnPropNameInRow="hazards" msprop:Generator_ColumnPropNameInTable="hazardsColumn" msprop:Generator_UserColumnName="hazards" type="xs:string" minOccurs="0" />
|
|
<xs:element name="main_result" msprop:Generator_ColumnVarNameInTable="columnmain_result" msprop:Generator_ColumnPropNameInRow="main_result" msprop:Generator_ColumnPropNameInTable="main_resultColumn" msprop:Generator_UserColumnName="main_result" type="xs:string" minOccurs="0" />
|
|
<xs:element name="person_age" msprop:Generator_ColumnVarNameInTable="columnperson_age" msprop:Generator_ColumnPropNameInRow="person_age" msprop:Generator_ColumnPropNameInTable="person_ageColumn" msprop:Generator_UserColumnName="person_age" type="xs:string" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="ckz" msprop:Generator_TableClassName="ckzDataTable" msprop:Generator_TableVarName="tableckz" msprop:Generator_RowChangedName="ckzRowChanged" msprop:Generator_TablePropName="ckz" msprop:Generator_RowDeletingName="ckzRowDeleting" msprop:Generator_RowChangingName="ckzRowChanging" msprop:Generator_RowEvHandlerName="ckzRowChangeEventHandler" msprop:Generator_RowDeletedName="ckzRowDeleted" msprop:Generator_RowClassName="ckzRow" msprop:Generator_UserTableName="ckz" msprop:Generator_RowEvArgName="ckzRowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="mc" msprop:Generator_ColumnVarNameInTable="columnmc" msprop:Generator_ColumnPropNameInRow="mc" msprop:Generator_ColumnPropNameInTable="mcColumn" msprop:Generator_UserColumnName="mc" type="xs:string" minOccurs="0" />
|
|
<xs:element name="fh" msprop:Generator_ColumnVarNameInTable="columnfh" msprop:Generator_ColumnPropNameInRow="fh" msprop:Generator_ColumnPropNameInTable="fhColumn" msprop:Generator_UserColumnName="fh" type="xs:string" minOccurs="0" />
|
|
<xs:element name="ckz" msprop:Generator_ColumnVarNameInTable="columnckz" msprop:Generator_ColumnPropNameInRow="ckz" msprop:Generator_ColumnPropNameInTable="ckzColumn" msprop:Generator_UserColumnName="ckz" type="xs:string" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
</xs:choice>
|
|
</xs:complexType>
|
|
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:occupation_report" />
|
|
<xs:field xpath="mstns:id" />
|
|
</xs:unique>
|
|
<xs:unique name="enterprise_info_maintain_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:enterprise_info_maintain" />
|
|
<xs:field xpath="mstns:id" />
|
|
</xs:unique>
|
|
</xs:element>
|
|
</xs:schema> |