App_Code/EntityDA/StockDA.cs

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

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

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Text;
using System.Data.SqlClient;

/// <summary>
/// 商品信息实体类
/// </summary>
public class StockDA
{
    private const string PARM_STOCK_ID = "@stockid";
    private const string PARM_STOCK_NAME = "@stockname";
    private const string PARM_STOCK_PRICE = "@stockprice";
    private const string PARM_STOCK_COUNT = "@stockcount";
    private const string PARM_STOCK_DATE = "@newdate";
    private const string PARM_POINT_COUNT = "@count";
    private const string SQL_SELECT_STOCK = "SELECT stockname,stockprice,stockcount FROM stock WHERE stockid=@stockid";
    private const string SQL_UPDATE_STOCKCOUNT = "UPDATE stock SET stockcount= stockcount - @stockcount WHERE stockid=@stockid";
    private const string SQL_INSERT_SALE = "INSERT INTO sale VALUES(@stockid,@stockcount,@newdate)";
    private const string SQL_INSERT_BACK = "INSERT INTO backstock VALUES(@stockid,@stockcount,@newdate)";
    private const string SQL_INSERT_GIFT = "INSERT INTO freestock VALUES(@stockid,@newdate)";
    private const string SQL_INSERT_GIFTRULE = "INSERT INTO giftrule VALUES(@stockid,@count)";
    /// <summary>
    /// 通过商品编码和数量获取实体信息
    /// </summary>
    /// <param name="stockid">商品编码</param>
    /// <param name="count">商品数量，如果是反馈商品，此值为"-1"</param>
    /// <returns>商品实体信息</returns>
    public StockEntity GetStockByID(string stockid,int count)
    {
        //初始化返回的变量
        StockEntity mystock = null;
        //初始化参数并赋值
        SqlParameter parm = new SqlParameter(PARM_STOCK_ID,SqlDbType.NVarChar,20);
        parm.Value = stockid;

        //执行DataReader命令，获取数据
        using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_SELECT_STOCK, parm))
        {
           //通过循环依次获取
            while (rdr.Read())
            {
                //使用有参数的构造函数为信息实体赋值
                //如果是在销售和退货的情况下，更改商品数量，由用户决定。
                //反馈情况下，只允许商品数量为1，所以无须更改。
                if (count != -1)
                {
                    mystock = new StockEntity(rdr.GetString(0), rdr.GetDouble(1), count);
                }
                else
                {
                    mystock = new StockEntity(rdr.GetString(0), rdr.GetDouble(1), rdr.GetInt32(2));

                }
            }
        }
        //返回实体信息