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