itemspriceaccess.cs

酒店管理系统,您酒店物业管理的好帮手

using System;
using System.Collections;
using System.Text;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
using Hotel.DAO;
using Hotel.Entity;

namespace Hotel.Operation
{
    public class ItemsPriceAccess
    {
        GetDatabase objGetDatabase = null;
        DataSet ds=null;
        ItemsPrice ItemsPriceEntity=null;

        public ItemsPriceAccess()
        {
            objGetDatabase = new GetDatabase();
        }
        //获得商品
        public ListView GetItems(ListView lv, string type)
        {
            string sql = "select 商品编号=ItemID,商品名称=ItemName,商品类型=(select TypeName from ItemsType "
                + "where ItemsTypeID=ItemsPrice.ItemsTypeID),商品价格=price,备注=remark from ItemsPrice where ItemsTypeID="+type;
            ds=new DataSet();
            ds=objGetDatabase.GetDataSet(sql, "ItemsPrice");
            //添加表头
            ColumnHeader ch = null;
            lv.Columns.Clear();
            for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
            {
                ch = new ColumnHeader();
                ch.Text = ds.Tables[0].Columns[i].ToString();
                lv.Columns.Add(ch);
                ch.Width = 70;
                if (i == 1)
                    ch.Width = 80;
            }

            lv.Items.Clear();
            ListViewItem lsvItem = null;
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                lsvItem = new ListViewItem(ds.Tables[0].Rows[i][0].ToString());
                for (int j = 1; j < ds.Tables[0].Columns.Count; j++)
                {
                    lsvItem.SubItems.Add(ds.Tables[0].Rows[i][j].ToString());

                }
                lv.Items.Add(lsvItem);
            }
            return lv;
        }
        //获取商品最大ＩＤ
        public int GetItemMaxID()
        {
            string sql = "select max(ItemID) from ItemsPrice";
            SqlDataReader dr= objGetDatabase.GetDataReader(sql);
            int k = 0;
            if (dr.HasRows)
            {
                dr.Read();
                k =int.Parse( dr[0].ToString());
            }
            dr.Close();
            return k;
        }
        //添加商品
        public int AddItem(ItemsPrice item)
        {
            string sql = "insert ItemsPrice values('"+item.ItemName+"',"+item.ItemsTypeID+","
                +item.Price+",'"+item.Remark+"')";
            int k=objGetDatabase.ExecuteSql(sql);
            return k;
        }
        //删除商品
        public int DeleteItem(int itemNum)
        {
            string sql = "delete from ItemsPrice where ItemID="+itemNum;
            int k = objGetDatabase.ExecuteSql(sql);
            return k;
        }
        //修改商品info
        public int ModifiItemInfo(ItemsPrice itp)
        {
            string sql = "update ItemsPrice set ItemName='"+itp.ItemName+"',ItemsTypeID="+itp.ItemsTypeID
                +",price="+itp.Price+",Remark='"+itp.Remark+"' where ItemID="+itp.ItemID;
            int k = objGetDatabase.ExecuteSql(sql);
            return k;
        }
        //获取某个商品的信息
        public ItemsPrice GetItemInfo(int num)
        {
            ItemsPriceEntity = new ItemsPrice();
            string sql = "select * from ItemsPrice where ItemID="+num;
            SqlDataReader dr = objGetDatabase.GetDataReader(sql);
            dr.Read();
            if (dr.HasRows)
            {
                ItemsPriceEntity.ItemID = int.Parse(dr.GetValue(0).ToString());
                ItemsPriceEntity.ItemName = dr.GetValue(1).ToString();
                ItemsPriceEntity.ItemsTypeID =int.Parse( dr.GetValue(2).ToString());
                ItemsPriceEntity.Price = float.Parse(dr.GetValue(3).ToString());
                ItemsPriceEntity.Remark = dr.GetValue(4).ToString();
            }
            dr.Close();
            return ItemsPriceEntity;
        }
        //查找某类型是否有商品
        public int FindTypeItem(int k)
        {
            string sql = "select * from ItemsPrice where ItemsTypeID="+k;
            ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql, "ItemsPrice");
            int num = ds.Tables[0].Rows.Count;
            return num;
        }
        //通过类型ID获得同类商品
        public DataSet GetTypeItem(int k)
        {
            string sql = "select * from ItemsPrice where ItemsTypeID="+k;
            ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql, "ItemsPrice");
            return ds;
        }
        //通过商品名称获得商品信息
        public DataSet GetItemID(string name)
        {
            string sql = "select * from ItemsPrice where ItemName='"+name+"'";
            ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql, "ItemsPrice");
            return ds;
        }
    }
}