新手求 注释 多谢
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"; //实际运输方式-->