public IList <MenuPractices> GetCurrentMenuElseGY(String currentmenunumber, String menuname, String menuTechnology, String Attribute)
{
DAL.DALmenu menu = new DAL.DALmenu();
String sql = "select distinct MenuGY from menualldetails where MenuName like '%" + menuname + "%' and " + Attribute + "<> '" + menuTechnology + "'";
return(menu.GetCurrentMenuElseGY(sql));
}
public IList <MenuAll> GetMenuByOtherPractices(String MenuName, String MenuGY)
{
DAL.DALmenu menu = new DAL.DALmenu();
String sql = "select * from menualldetails where KeyWord ='" + MenuName + "' and MenuGY ='" + MenuGY + "'";
return(menu.GetMenuByIdenticalGY(sql));
}
public IList <MenuAll> GetMenuByIdenticalGY(String MenuNumberList, String MenuName, String MenuGY)
{
DAL.DALmenu menu = new DAL.DALmenu();
String[] MenuNList = MenuNumberList.Split('/');
String notin = " where menunumber not in(";
foreach (string s in MenuNList)
{
notin = notin + "'" + s + "',";
}
String sql = "select * from (select * from menualldetails where MenuGY='" + MenuGY + "' and MenuName like '%" + MenuName + "') as a" + notin + ")";
return(menu.GetMenuByIdenticalGY(sql));
}
public IList <SimpleMenu> GetSimpleSingleMenu(String MenuId)
{
DAL.DALmenu menu = new DAL.DALmenu();
return(menu.GetSimpleSingleMenu(MenuId));
}
//读取菜单
public IList <SimpleMenu> GetMenudetail(String MenuId)
{
DAL.DALmenu menu = new DAL.DALmenu();
return(menu.GetMenudetail(MenuId));
}
public IList <User> GetUserinfo(String UserId, String Type)
{
DAL.DALmenu menu = new DAL.DALmenu();
return(menu.GetUserinfo(UserId, Type));
}
public IList <SimpleMenu> GetMenu(String type, int Size, int index)
{
DAL.DALmenu menu = new DAL.DALmenu();
return(menu.GetMenu(type, Size, index));
}
public IList <SimpleMenu> GetRelavantMenuA(String sql)
{
DAL.DALmenu menu = new DAL.DALmenu();
return(menu.GetRelavantMenuA(sql));
}
//读多条数据
public IList <MenuAll> GetMenuList(String type, String value, int Size, int index)
{
DAL.DALmenu menu = new DAL.DALmenu();
return(menu.GetMenuList(type, value, Size, index));
}
public IList <Ingredient> GetsimpleIngredientList(String type, String value, int Size, int index)
{
DAL.DALmenu menu = new DAL.DALmenu();
return(menu.GetsimpleIngredientList(type, value, Size, index));
}
public IList <UserComment> GetUserComment2(String val)
{
DAL.DALmenu menu = new DAL.DALmenu();
return(menu.GetUserComment2(val));
}
public IList <Ingredient> GetIngredientDetail(String by, String val)
{
DAL.DALmenu menu = new DAL.DALmenu();
return(menu.GetIngredientDetail(by, val));
}
public IList <recipeteachinginformation> GetRelavantMenu(String IngredientName)
{
DAL.DALmenu menu = new DAL.DALmenu();
return(menu.GetRelavantMenu(IngredientName));
}
//#region //通过一个属性获取简单菜谱
//public IList<SimpleMenu> GetSimpleMenuByOneAttribute(String val,String Attribute)
//{
// DAL.DALmenu menu = new DAL.DALmenu();
// String sql="select * from menualldetails where "+Attribute+"='"+val+"'";
// // return menu.GetSimpleMenuByOneAttribute(sql);
//}
//#endregion
#region //通过关键字获取相似菜谱(同种菜的相似做法)
public IList <MenuAll> GetSimilarMenu(String Keyword, String MenuNumber)
{
DAL.DALmenu menu = new DAL.DALmenu();
return(menu.GetSimilarMenu(Keyword, MenuNumber));
}
public int GetMenuCount(String type)
{
DAL.DALmenu menu = new DAL.DALmenu();
return(menu.GetMenuCount(type));
}
public IList <IngredientTaboo> GetIngredientTaboo(String IngredientNumber)
{
DAL.DALmenu menu = new DAL.DALmenu();
return(menu.GetIngredientTaboo(IngredientNumber));
}
public IList <UserProductions> GetSingleUserMenu(String MenuId)
{
DAL.DALmenu menu = new DAL.DALmenu();
return(menu.GetSingleUserMenu(MenuId));
}
