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