DA/DBProductAttr.cs

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Common;

namespace DA
{
   public class DBProductAttr
    {
        private string sql;
        private SqlHelpers sqlh;
        private DataSet ds;
        private SqlDataReader dr;

        public DBProductAttr()
        {
            sqlh = new SqlHelpers();
        }

        public DBProductAttr(SqlHelpers helper)
        {
            sqlh = helper;
        }

        public void Dispose()
        {
            sqlh.Dispose();
        }
       public int Update(CProductAttr pa)
       {
           //List<SqlParameter> pars = new List<SqlParameter>();
           //pars.Add(new SqlParameter("@ProductId", SqlDbType.Int));
           //pars[0].Value = pa.ProductId;
           //pars.Add(new SqlParameter("@MenuId", SqlDbType.Int));
           //pars[1].Value = pa.MenuId;
           //pars.Add(new SqlParameter("@Name", SqlDbType.VarChar, 20));
           //pars[2].Value = ma.Name;
           //pars.Add(new SqlParameter("@Price", SqlDbType.Decimal));
           //pars[3].Value = ma.Price;
           //sql = "update MenusAttr set MenuId=@MenuId,Name=@Name,Price=@price where Id=@Id";
           //sqlh.NonQuery(sql, pars, CommandType.Text);
           return 1;
       }
    }
}