DA/DBMenusAttr.cs

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

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

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

namespace DA
{
    public class DBMenusAttr : IDisposable
    {
        private string sql;
        private SqlHelpers sqlh;
        private DataSet ds;
        private SqlDataReader dr;

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

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

        public void Dispose()
        {
            sqlh.Dispose();
        }
        /// <summary>
        /// 获取当前菜的属性列表
        /// </summary>
        /// <param name="menuId"></param>
        /// <returns></returns>
        public List<CMenusAttr> DBMenusAttrQuery(int menuId)
        {
            List<CMenusAttr> lm = new List<CMenusAttr>();
            sql = "select * from MenusAttr where MenuId='" + menuId + "'";
            dr = sqlh.RQuery(sql, null, CommandType.Text);
            while (dr.Read())
            {
                CMenusAttr cm = new CMenusAttr();
                cm.Id = Convert.ToInt32(dr["Id"]);
                cm.MenuId = menuId;
                cm.Name = dr["Name"].ToString();
                cm.Price = Convert.ToDecimal(dr["Price"]);
                lm.Add(cm);
            }
            dr.Close();
            return lm;
        }
        /// <summary>
        /// 根据id获取属性信息
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public CMenusAttr GetAttrById(int id)
        {
            sql = "select * from MenusAttr where id=" + id;
            dr = sqlh.RQuery(sql, null, CommandType.Text);