Пример #1
0
        /// <summary>
        ///根据类型获取菜品信息
        /// </summary>
        /// <param name="TypeId"></param>
        /// <returns></returns>
        public List <tb_Menu> GetMenuList(int TypeId)
        {
            string procName = "proc_ShowMenu";

            MySqlParameter[] mySqlParameter = new MySqlParameter[] {
                new MySqlParameter {
                    ParameterName = "TypeId", MySqlDbType = MySqlDbType.Int32, Direction = ParameterDirection.Input, Value = TypeId
                }
            };
            DataTable      tb   = _dbHelper.ExecuteSql_Proc(procName, mySqlParameter);
            List <tb_Menu> list = listClass.GetDataList <tb_Menu>(tb);

            return(list);
        }