web/bin/DataConfig/Data/Order.xml

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<?xml version="1.0" encoding="utf-8" ?>
<Commands>
  <Command CommandName="OrderAddOneEntityMWW" DatabaseName="TestInfo">
    <![CDATA[ 
			INSERT INTO dbo.[Order]
			(
				 [TrainId]
				,[UserId]
				,[OrderTime]
			)
			VALUES
			(
				 @TrainId
				,@UserId
				,@OrderTime
			)
			SELECT  SCOPE_IDENTITY()
    ]]>
  </Command>
  <Command CommandName="OrderModifyOneEntityMWW" DatabaseName="TestInfo">
    <![CDATA[ 
			UPDATE dbo.[Order]
			SET
				 [TrainId] = @TrainId
				,[UserId] = @UserId
				,[OrderTime] = @OrderTime
			WHERE [OrderId] = @OrderId

    ]]>
  </Command>
  <Command CommandName="OrderRemoveOneEntityMWW" DatabaseName="TestInfo">
    <![CDATA[ 
			DELETE FROM dbo.[Order]
			WHERE [OrderId] = @OrderId

    ]]>
  </Command>
  <Command CommandName="OrderSearchInfoMWW" DatabaseName="TestInfo">
    <![CDATA[ 
      SELECT 
							[Order].OrderId
							,[Order].UserId
							,[Order].TrainId
							,[Order].OrderTime
							,Train.TrainNum
							,[User].UserName
                FROM [Order] WITH(NOLOCK) 
 INNER JOIN Train WITH(NOLOCK)
  ON [Order].TrainId=Train.TrainId
 INNER JOIN [User] WITH(NOLOCK)
  ON [Order].UserId=[User].UserId
    ]]>
  </Command>
  <!--分页查询例子发布时请删除-->
   <Command CommandName="OrderSearchPageInfoMWW" DatabaseName="TestInfo">
    <![CDATA[ 
                  SELECT @RowsNumber=COUNT(1)
                  FROM [Order] WITH(NOLOCK) 
 INNER JOIN [Car] WITH(NOLOCK)
  ON [Order].CarId=[Car].CarId