public static ArrayList layDanhSachLoaiMonAn()
        {
            DbCommand command = DataAccessCode.CreateCommand();

            command.CommandText = "dbo.LayDanhSachLoaiMonAn";

            DataTable dt   = DataAccessCode.ExecuteSelectCommand(command);
            ArrayList list = new ArrayList();

            if (dt != null)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    LoaiMonAnDTO r = new LoaiMonAnDTO();
                    r.MaLoaiMonAn  = Int32.Parse(dt.Rows[i]["MaLoaiMonAn"].ToString());
                    r.TenLoaiMonAn = dt.Rows[i]["TenLoaiMonAn"].ToString();

                    list.Add(r);
                }
            }
            return(list);
        }
 public static ArrayList layDanhSachMonAnTheoPhanLoaiMonAn(LoaiMonAnDTO loaiMonAn, int maNhaHang)
 {
     return(PhanLoaiMonAnDAO.layDanhSachMonAnTheoPhanLoaiMonAn(loaiMonAn, maNhaHang));
 }