impitemdal.cs

酒店在线订餐管理系统

            {
                if (cmd.Connection.State == System.Data.ConnectionState.Closed)
                    cmd.Connection.Open();
                List<Item> list = new List<Item>();
                Item item;
                DbDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                while (reader.Read())
                {
                    item = new Item(long.Parse(reader.GetValue(0).ToString()), reader.GetString(1),float.Parse(reader.GetDecimal(2).ToString()), int.Parse(reader.GetValue(3).ToString()), reader.GetString(4),reader.GetString(5));
                    list.Add(item);
                }
                return list;
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
            finally
            {
                cmd.Parameters.Clear();
                cmd.Connection.Close();
            }
        }

        public IList<Item> SelectItem(int type,int top)
        {
            cmd.CommandText = "SELECT Top "+top+" * FROM UT_Items WHERE Type=@p";
            SqlParameter p = new SqlParameter("p", type);
            cmd.Parameters.Add(p);
            try
            {
                if (cmd.Connection.State == System.Data.ConnectionState.Closed)
                    cmd.Connection.Open();
                List<Item> list = new List<Item>();
                Item item;
                DbDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                while (reader.Read())
                {
                    item = new Item(long.Parse(reader.GetValue(0).ToString()), reader.GetString(1), float.Parse(reader.GetDecimal(2).ToString()), int.Parse(reader.GetValue(3).ToString()), reader.GetString(4), reader.GetString(5));
                    list.Add(item);
                }
                return list;
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
            finally
            {
                cmd.Parameters.Clear();
                cmd.Connection.Close();
            }
        }
        #endregion

        #region 查询出主页显示的菜肴
        public IList<Item> SelectNewItemByIndex()
        {
            cmd.CommandText = "SELECT TOP 4* FROM UT_Items ORDER BY SystemId DESC";
            try
            {
                if (cmd.Connection.State == System.Data.ConnectionState.Closed)
                    cmd.Connection.Open();
                List<Item> list = new List<Item>();
                Item item;
                DbDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                while (reader.Read())
                {
                    item = new Item(long.Parse(reader.GetValue(0).ToString()), reader.GetString(1), float.Parse(reader.GetDecimal(2).ToString()), int.Parse(reader.GetValue(3).ToString()), reader.GetString(4), reader.GetString(5));
                    list.Add(item);
                }
                return list;
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
            finally
            {
                cmd.Parameters.Clear();
                cmd.Connection.Close();
            }
        }
        #endregion

        #region SelectOneItem


        public Item SelectOneItem(long systemId)
        {
            cmd.CommandText = "SELECT * FROM UT_Items WHERE SystemId=@id";
            SqlParameter p = new SqlParameter("id", systemId);
            cmd.Parameters.Add(p);
            try
            {
                if (cmd.Connection.State == System.Data.ConnectionState.Closed)
                    cmd.Connection.Open();
                Item item = null; ;
                DbDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                while (reader.Read())
                {
                    item = new Item(long.Parse(reader.GetValue(0).ToString()), reader.GetString(1), float.Parse(reader.GetDecimal(2).ToString()), int.Parse(reader.GetValue(3).ToString()), reader.GetString(4), reader.GetString(5));
                }
                return item;
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
            finally
            {
                cmd.Parameters.Clear();
                cmd.Connection.Close();
            }
        }

        #endregion

        #region 修改菜肴类型
        public int EditItemType(Item item)
        {
            cmd.CommandText = "UPDATE UT_Items SET Type=@T WHERE SystemId=@id";
            SqlParameter[] parameter = new SqlParameter[2];
            parameter[0] = new SqlParameter("T", item.Type);
            parameter[1] = new SqlParameter("id", item.SystemId);

            cmd.Parameters.Add(parameter[0]);
            cmd.Parameters.Add(parameter[1]);

            try
            {
                if (cmd.Connection.State == System.Data.ConnectionState.Closed)
                    cmd.Connection.Open();
                return cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
            finally
            {
                cmd.Parameters.Clear();
                cmd.Connection.Close();
            }
        }
        #endregion

        #region 随机读取前几个菜肴


        public IList<Item> SelectItemTop(int top)
        {
            cmd.CommandText = "SELECT  TOP " + top + "  * FROM  UT_Items ORDER BY newid()";
            try
            {
                if (cmd.Connection.State == System.Data.ConnectionState.Closed)
                    cmd.Connection.Open();
                List<Item> list = new List<Item>();
                Item item;
                DbDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                while (reader.Read())
                {
                    item = new Item(long.Parse(reader.GetValue(0).ToString()), reader.GetString(1), float.Parse(reader.GetDecimal(2).ToString()), int.Parse(reader.GetValue(3).ToString()), reader.GetString(4), reader.GetString(5));
                    list.Add(item);
                }
                return list;
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
            finally
            {
                cmd.Parameters.Clear();
                cmd.Connection.Close();
            }
        }

        #endregion

        #region 查询热门菜肴


        public IList<Item> SelectHotItems()
        {
            cmd.CommandText = "SELECT * FROM  UV_HotItems";
            try
            {
                if (cmd.Connection.State == System.Data.ConnectionState.Closed)
                    cmd.Connection.Open();
                List<Item> list = new List<Item>();
                Item item;
                DbDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                while (reader.Read())
                {
                    item = new Item(long.Parse(reader.GetValue(0).ToString()), reader.GetString(1), float.Parse(reader.GetDecimal(2).ToString()), int.Parse(reader.GetValue(3).ToString()), reader.GetString(4), reader.GetString(5));
                    list.Add(item);
                }
                return list;
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
            finally
            {
                cmd.Parameters.Clear();
                cmd.Connection.Close();
            }
        }

        #endregion


        #endregion
    }
}