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)); }