DA/DBBom.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Common;
namespace DA
{
    public class DBBom : IDisposable
    {

        string sql,sql1;
        SqlHelpers sqlh;
        SqlDataReader dr;
        public DBBom()
        {
            sqlh = new SqlHelpers();
        }
        public DBBom(SqlHelpers sh)
        {
            sqlh = sh;
        }
        public void Dispose()
        {
            sqlh.Dispose();
        }

        /// <summary>
        /// DB  查询所有菜品类型的方法
        /// </summary>
        /// <returns></returns>
        public List<CBom> DBBomQuery()
        {

            List<CBom> lmt = new List<CBom>();
            sql = "select a.BomID as bid,a.BomName,a.BomVersion,a.menuName,a.menuID,a.storeID,a.comments,a.createUserID,a.userName,a.createDateTime,b.BomDetailID,b.productID,b.unit,b.Qty from Bom as a,BomDetail as b where a.BomID=b.BomID";
            dr = sqlh.RQuery(sql, null, CommandType.Text);
            while (dr.Read())
            {
                CBom cmt = new CBom();
                cmt.BomID = dr["bid"].ToString();
                cmt.BomName = dr["BomName"].ToString();
                cmt.BomVersion = dr["BomVersion"].ToString();
                cmt.MenuName=dr["menuName"].ToString();
                cmt.MenuId = dr["menuID"].ToString();
                cmt.StoreId = dr["storeID"].ToString();
                cmt.Comments = dr["comments"].ToString();
                cmt.CreateUserId = dr["createUserID"].ToString();
                cmt.CreatDateTime = dr["createDateTime"].ToString();
                cmt.BomDetailId = dr["BomDetailID"].ToString();
                cmt.ProductId = dr["productID"].ToString();
                cmt.userName = dr["userName"].ToString();
                cmt.Unit = dr["unit"].ToString();
                cmt.Qty = dr["Qty"].ToString();
                lmt.Add(cmt);
         
            }
            dr.Close();
            return lmt;
        }