可以'；t将数据插入数据库

我似乎无法将数据插入数据库。我想知道我是否正确使用了SCOPE_IIDENTITY。我只想将这些数据插入到我的数据库中，而不必手动键入PurchOrderId。

在我的BllPurchaseOrder.cs文件中：

public int InsertPO(String PurchName, String PurchDesc, int SuppId)
    {
        StringBuilder sql;
        SqlCommand sqlCmd;
        int result;
        result = 0;
        sql = new StringBuilder();
        sql.AppendLine("INSERT INTO PurchaseOrder(PurchName, PurchDesc, SuppId, CreateDate, SentStatus)");
        sql.AppendLine(" ");
        sql.AppendLine("VALUES (@PurchName, @PurchDesc, @SuppId, @CreateDate, @SentStatus)");
        sql.AppendLine(" ");
        sql.AppendLine("SELECT CAST(scope_identity() AS int)");
        sql.AppendLine(" ");
        SqlConnection conn = dbConn.GetConnection();
        try
        {
            sqlCmd = new SqlCommand(sql.ToString(), conn);
            sqlCmd.Parameters.AddWithValue("@PurchName", PurchName);
            sqlCmd.Parameters.AddWithValue("@PurchDesc", PurchDesc);
            sqlCmd.Parameters.AddWithValue("@CreateDate", DateTime.Now);
            sqlCmd.Parameters.AddWithValue("@SuppId", SuppId);
            sqlCmd.Parameters.AddWithValue("@SentStatus", "Sent");
            result = sqlCmd.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            errMsg = ex.Message;
        }
        finally
        {
            conn.Close();
        }
        return result;
    }

在我的InsertPO.aspx中：

int result = 0;
        string PurchName = tbPurchName.Text;
        string PurchDesc = tbPurchDesc.Text;
        int SuppName = int.Parse(ddlSuppName.SelectedValue);
        BllPurchaseOrder po = new BllPurchaseOrder();
        result = po.InsertPO(PurchName, PurchDesc, SuppName);
        if (result > 0)
        {
            Response.Write("<script>alert('Insert Successful!'); </script>");
            Response.Redirect("~/ViewAllPO.aspx");
        }
        else
        {
            Response.Write("<script>alert('Insert NOT Successful'); </script>");
        }