日期:2014-05-18  浏览次数:20449 次

新手求 注释 多谢
SQL code

<?xml version="1.0" encoding="utf-8" ?>
<Entity>
    <EntityTypeName>AbnormatExportManage</EntityTypeName>
    <TableName>AbnormatExportManage</TableName>
    <Columns>
        <Column Name="ID" Description="流水号" DataType="System.Int32" IsKey="True" IsNull="False"
            MaxLength="4" ShowWidth="100" />
        <Column Name="OrderID" Description="订单ID" DataType="System.Int32" IsKey="False" IsNull="True"
            MaxLength="4" ShowWidth="100" />
        <Column Name="ExportDate" Description="出口日期" DataType="System.DateTime" IsKey="False" IsNull="True"
            MaxLength="8" ShowWidth="100" />
        <Column Name="ExportCount" Description="出口数量" DataType="System.Int32" IsKey="False" IsNull="True"
            MaxLength="4" ShowWidth="100" />
        <Column Name="ShippingType" Description="运输方式" DataType="System.Int32" IsKey="False" IsNull="True"
            MaxLength="4" ShowWidth="100" />
        <Column Name="FactExportCount" Description="实际出口数量" DataType="System.Int32" IsKey="False"
            IsNull="True" MaxLength="4" ShowWidth="100" />
        <Column Name="CountDisagreeFlag" Description="数量未达成" DataType="System.Boolean" IsKey="False"
            IsNull="True" MaxLength="1" ShowWidth="100" />
        <Column Name="CountDisagreeReasion" Description="数量未达成原因" DataType="System.Int32" IsKey="False"
            IsNull="True" MaxLength="4" ShowWidth="100" />
        <Column Name="FactExportDate" Description="实际出口日期" DataType="System.DateTime" IsKey="False"
            IsNull="True" MaxLength="8" ShowWidth="100" />
        <Column Name="DateDisagreeFlag" Description="交期未达成" DataType="System.Boolean" IsKey="False"
            IsNull="True" MaxLength="1" ShowWidth="100" />
        <Column Name="DateDisagreeReasion" Description="交期未达成原因" DataType="System.Int32" IsKey="False"
            IsNull="True" MaxLength="4" ShowWidth="100" />
        <Column Name="FactExportType" Description="实际运输方式" DataType="System.Int32" IsKey="False"
            IsNull="True" MaxLength="4" ShowWidth="100" />
            
    </Columns>
    <Sqls>
        <Sql Name="SelectObject">
            <String>
            <![CDATA[ 
            SELECT 
            ID,OrderID,ExportDate,ExportCount,ShippingType,FactExportCount,CountDisagreeFlag,
            CountDisagreeReasion,FactExportDate,DateDisagreeFlag,DateDisagreeReasion,FactExportType
            FROM AbnormatExportManage
            ]]>
            </String>
        </Sql>
        
        <Sql Name="AddObject">
            <String>
            <![CDATA[ 
            INSERT INTO AbnormatExportManage( 
            OrderID,ExportDate,ExportCount,ShippingType,FactExportCount,CountDisagreeFlag,
            CountDisagreeReasion,FactExportDate,DateDisagreeFlag,DateDisagreeReasion,FactExportType) 
            VALUES