DA/DBMenus.cs

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

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

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



namespace DA
{
   public  class DBMenus: IDisposable 
    {
        string sql;
        SqlHelpers sqlh;
       DataSet ds;
        SqlDataReader dr;
        public DBMenus()
        {
            sqlh = new SqlHelpers();

        }
        public DBMenus(SqlHelpers sh)
        {
            sqlh = sh;            
        }
        public void Dispose()
        {
            sqlh.Dispose();
        }

    
        /// <summary>
        /// DB--查询所有菜品的方法
        /// </summary>
        /// <returns></returns>
        public List<CMenus> DBMenusQuery()
        {
            List<CMenus> lm = new List<CMenus>();
            sql = "select * from Menus";
               dr= sqlh.RQuery(sql,null,CommandType.Text );
               while (dr.Read())
               {
                   CMenus cm = new CMenus();
                   cm.CmsId1  = Convert.ToInt32(dr["msId"]);
                   cm.CmtId1  = Convert.ToInt32(dr["mtId"]);
                   cm.CmsName1  = dr["msName"].ToString();
                   cm.CmsSpell1  = dr["msSpell"].ToString();
                   cm.CmsUnit1  = dr["msUnit"].ToString();
                   cm.CmsPrice1  = Convert.ToDecimal(dr["msPrice"]);
                   cm.CmsScalar1  = Convert.ToInt32(dr["msScalar"]);
                   cm.CmsCost1 = Convert.ToDecimal(dr["msCost"]);
                   cm.CmsMoney1 = Convert.ToDecimal(dr["msMoney"]);
                   cm.CstId1 = Convert.ToInt32(dr["stId"]);
                   cm.CmsGuQing1 = Convert.ToBoolean(dr["msGuQing"]);
                   cm.CmsVipPrice1=Convert.ToDecimal(dr["msVipPrice"]);
                   cm.Taste = dr["Taste"].ToString();
                   lm.Add(cm);
               }
               dr.Close();