Yii2中如何调用带参数的存储过程 [英] How to call stored procedure with parameters in Yii2

问题描述

Yii2中如何调用带参数的存储过程?

How to call stored procedure with parameters in Yii2?

这是我的存储过程

ALTER PROCEDURE [dbo].[usp_M_Inventory#InsertData]
    @ID_Item RunNum,
    @Item_Name varchar(250),
    @ID_Mom varchar(50),
    @Item_Price float,
    @ID_Inv_Category RunNum,
    @Item_PIC1 varchar(50),
    @Item_PIC2 varchar(50),
    @Item_active BIT,
    @User UserDataType
AS
BEGIN
    SET NOCOUNT ON;

    INSERT INTO M_Inventory(ID_Item, Item_Name, ID_Mom, Item_Price, 
                            ID_Inv_Category, Item_PIC1, Item_PIC2, 
                            Item_active, insert_user, insert_date, update_user, update_date)
    VALUES (@ID_Item, @Item_Name, @ID_Mom, @Item_Price,
            @ID_Inv_Category, @Item_PIC1, @Item_PIC2,
            @Item_active, @User, GETDATE(), @User, GETDATE())
END

推荐答案

您可以使用以下代码调用带参数的存储过程.

You can use below code to call stored procedure with parameters.

$result = \Yii::$app->db->createCommand("CALL storedProcedureName(:paramName1, :paramName2)") 
                      ->bindValue(':paramName1' , $param1 )
                      ->bindValue(':paramName2', $param2)
                      ->execute();

这篇关于Yii2中如何调用带参数的存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！