c# - 存储过程返回结果

Question

我正在创建一个存储过程来生成项目列表。存储过程返回一个结果和一个返回值。在我调用存储过程的应用程序中返回返回值。如何让它返回结果？

这是我的程序：

CREATE PROCEDURE [AQB_RMS].[p_SO2EmailOverDue]
AS
    (SELECT
         CONVERT(CHAR(10), CheckDate, 101) AS ZSPDate, 
         Manufacturer, Model, SerialNumber, LocationName
     FROM
         [AQB_RMS].[SO2_Zsp] so
     INNER JOIN
         AQB_MON.[AQB_RMS].[Device] dev ON dev.DeviceID = so.DeviceID
     INNER JOIN
         AQB_MON.[AQB_RMS].[DeviceLocation] dl ON dev.DeviceID = dl.DeviceID
     INNER JOIN
         AQB_MON.[AQB_RMS].[Location] loc ON dl.LocationID = loc.LocationID
     INNER JOIN
         [AQB_RMS].[ManufacturerModel] mm ON dev.ManufacturerModelID = mm.ManufacturerModelID
     INNER JOIN
         [AQB_RMS].[Manufacturer] man ON mm.ManufacturerID = man.ManufacturerID
     WHERE
         CheckDate = (SELECT MAX(CheckDate) FROM [AQB_RMS].[SO2_Zsp]
                      WHERE DeviceID = so.DeviceID) 
         AND dl.EndDate IS NULL 
         AND (SELECT DATEDIFF(day, so.CheckDate, GetDate()) AS DayCount) > 14)
     ORDER BY
         CheckDate

    RETURN 
GO

以下是我在 SQL Server 2012 中执行存储过程时的返回

我正在使用存储过程来提供电子邮件正文的结果。我正在使用 C#

    static string Body()
    {
        //create a connection to the database
        string ConnString = ConfigurationManager.ConnectionStrings["avdatauser"].ConnectionString;

        StringBuilder sb = new StringBuilder();

        using (SqlConnection con = new SqlConnection(ConnString))
        {
            con.Open();

            SqlCommand cmd = new SqlCommand("AQB_RMS.p_SO2EmailNearDue", con);
            cmd.CommandType = CommandType.StoredProcedure;

            cmd.ExecuteNonQuery();

            sb.Append("<strong>SO2 Analyzer ZSP due</strong>");
            sb.Append("<br>");
            sb.Append("<br>");
            sb.Append("What do you want to say here to show these are the ones with a ZSP that are near due");
            sb.Append("<br>");
            sb.Append("<br>");
            sb.Append(" " + cmd + " ");
            con.Close();
        }

        return sb.ToString();
    }

标签： c#sqlsql-serverstored-procedures