warehouse.cs

来自「Introduce AJAX, can learn more thing.」· CS 代码 · 共 35 行

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Web.Configuration;

/// <summary>
/// Summary description for Warehouse
/// </summary>
public class Warehouse
{
    public static int GetItemQuantity(string itemID)
    {
        if (String.IsNullOrEmpty(itemID))
            return 0;
        
        System.Threading.Thread.Sleep(500);
        
        using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["Items"].ConnectionString))
        using(SqlCommand cmd = new SqlCommand("SELECT [Quantity] FROM Items WHERE [ItemID] = @itemID", conn))
        {
            conn.Open();
            cmd.Parameters.AddWithValue("@itemID", new Guid(itemID));
            return (int)cmd.ExecuteScalar();
        }
    }

}