App_Code/DAO/Bs_ProDao.cs

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

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

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.Text;
/// <summary>
/// Bs_ProDao 的摘要说明
/// </summary>
public class Bs_ProDao
{

    /// <summary>
    /// 获取商品
    /// </summary>
    /// <param name="proId"></param>
    /// <returns></returns>
    public DataTable getProById(int proId)
    {
        string strSql = "select * from bs_products  where id = " + proId;
        return CSA.DAL.DBAccess.getRS(strSql);
    }
    /// <summary>
    /// 获取礼品内容
    /// </summary>
    /// <param name="code">编号</param>
    /// <returns></returns>
    public DataTable getGiftById(string code)
    {
        string strSql = string.Format("select * from Bs_Gift where code='{0}'", code);
        return CSA.DAL.DBAccess.getRS(strSql);
    }

    /// <summary>
    /// 获取商品
    /// </summary>
    /// <param name="pro_name">商品Code</param>
    /// <returns></returns>
    public DataTable getProByCode(string pro_code)
    {
        string strSql = "";
        if (pro_code.Length > 0)
        {
            strSql = string.Format("select * from bs_products  where code = '{0}'", pro_code);
        }
        else
        {
            strSql = string.Format("select * from bs_products order by sortno ", pro_code);
        }
        return CSA.DAL.DBAccess.getRS(strSql);
    }

    /// <summary>
    /// 获取商品属性
    /// </summary>
    /// <param name="prop_type">属性名</param>