当前位置: 代码迷 >> Sql Server >> 新手求 注释 谢谢
  详细解决方案

新手求 注释 谢谢

热度:320   发布时间:2016-04-27 12:14:52.0
新手求 注释 多谢
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             (@OrderID,@ExportDate,@ExportCount,@ShippingType,@FactExportCount,@CountDisagreeFlag,            @CountDisagreeReasion,@FactExportDate,@DateDisagreeFlag,@DateDisagreeReasion,@FactExportType)            ]]>            </String>            <Param Name="@OrderID" Column="OrderID" />            <Param Name="@ExportDate" Column="ExportDate" />            <Param Name="@ExportCount" Column="ExportCount" />            <Param Name="@ShippingType" Column="ShippingType" />            <Param Name="@FactExportCount" Column="FactExportCount" />            <Param Name="@CountDisagreeFlag" Column="CountDisagreeFlag" />            <Param Name="@CountDisagreeReasion" Column="CountDisagreeReasion" />            <Param Name="@FactExportDate" Column="FactExportDate" />            <Param Name="@DateDisagreeFlag" Column="DateDisagreeFlag" />            <Param Name="@DateDisagreeReasion" Column="DateDisagreeReasion" />            <Param Name="@FactExportType" Column="FactExportType" />        </Sql>        <Sql Name="UpdateObject">            <String><![CDATA[ UPDATE AbnormatExportManage SET [email protected],[email protected],[email protected],[email protected],[email protected],[email protected],[email protected],[email protected],[email protected],[email protected],[email protected]WHERE [email protected]]]></String>            <Param Name="@ID" Column="ID" />            <Param Name="@OrderID" Column="OrderID" />            <Param Name="@ExportDate" Column="ExportDate" />            <Param Name="@ExportCount" Column="ExportCount" />            <Param Name="@ShippingType" Column="ShippingType" />            <Param Name="@FactExportCount" Column="FactExportCount" />            <Param Name="@CountDisagreeFlag" Column="CountDisagreeFlag" />            <Param Name="@CountDisagreeReasion" Column="CountDisagreeReasion" />            <Param Name="@FactExportDate" Column="FactExportDate" />            <Param Name="@DateDisagreeFlag" Column="DateDisagreeFlag" />            <Param Name="@DateDisagreeReasion" Column="DateDisagreeReasion" />            <Param Name="@FactExportType" Column="FactExportType" />        </Sql>        <Sql Name="DeleteObject">            <String><![CDATA[ DELETE FROM AbnormatExportManage]]></String>        </Sql>    </Sqls></Entity><!--private const string OBJECT_NAME ="AbnormatExportManage";public static readonly string FIELD_ID = "ID";  //流水号public static readonly string FIELD_ORDERID = "OrderID";  //订单IDpublic static readonly string FIELD_EXPORTDATE = "ExportDate";  //出口日期public static readonly string FIELD_EXPORTCOUNT = "ExportCount";  //出口数量public static readonly string FIELD_SHIPPINGTYPE = "ShippingType";  //运输方式public static readonly string FIELD_FACTEXPORTCOUNT = "FactExportCount";  //实际出口数量public static readonly string FIELD_COUNTDISAGREEFLAG = "CountDisagreeFlag";  //数量未达成public static readonly string FIELD_COUNTDISAGREEREASION = "CountDisagreeReasion";  //数量未达成原因public static readonly string FIELD_FACTEXPORTDATE = "FactExportDate";  //实际出口日期public static readonly string FIELD_DATEDISAGREEFLAG = "DateDisagreeFlag";  //交期未达成public static readonly string FIELD_DATEDISAGREEREASION = "DateDisagreeReasion";  //交期未达成原因public static readonly string FIELD_FACTEXPORTTYPE = "FactExportType";  //实际运输方式-->
  相关解决方案