/// <summary> /// 获取数据列表 /// </summary> /// <param name="strWhere"></param> /// <returns></returns> public List <MenuEnity> GetList(string orderid) { List <MenuEnity> list = new List <MenuEnity>(); //SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings.ToString()); //con.Open(); //StringBuilder sql = new StringBuilder(); //sql.Append("select t3.OrderID,t2.[Menu_Name],t4.[table_id],t1.[OrderDetail_amount],t1.menu_id "); //sql.Append("from OrderDetail t1 inner join Menu t2 on t1.[Menu_ID]=t2.[menu_id] "); //sql.Append("inner join [Order] t3 on t3.OrderID=t1.order_id "); //sql.Append("inner join [table] t4 on t3.TableID=t4.table_id "); //sql.Append("where OrderID=@orderid and Status=0"); //SqlCommand com = new SqlCommand(sql.ToString(),con); //com.Parameters.Add(new SqlParameter("@orderid", orderid)); //SqlDataReader dr = com.ExecuteReader(); string sql = "select t3.OrderID,t2.[Menu_Name],t4.[table_id],t1.[OrderDetail_amount],t1.menu_id from OrderDetail t1 inner join Menu t2 on t1.[Menu_ID]=t2.[menu_id] inner join [Order] t3 on t3.OrderID=t1.order_id inner join [table] t4 on t3.TableID=t4.table_id where OrderID=@orderid and Status=1"; SqlParameter[] parameters = { new SqlParameter("@orderid", orderid), }; SqlDataReader dr = SQLHelper.ExecuteReader(sql.ToString(), parameters); while (dr.Read()) { string order_id = dr[0].ToString(); string menuname = dr[1].ToString(); string tableid = dr[2].ToString(); string amountOfDish = dr[3].ToString(); string menuid = dr[4].ToString(); MenuEnity obj = new MenuEnity(order_id, menuname, tableid, Convert.ToInt32(amountOfDish), menuid); list.Add(obj); } return(list); }
/// <summary> /// 获取数据列表 /// </summary> /// <param name="strWhere"></param> /// <returns></returns> public List <MenuEnity> GetList() { List <MenuEnity> list = new List <MenuEnity>(); string sql = "select Menu_ID,Menu_Name,type_Name,Menu_Price,Menu_picture from dbo.Menu m inner join dbo.Menu_Type mt on m.Menu_Type =mt.Type_ID"; SqlDataReader sdr = SQLHelper.ExecuteReader(sql); while (sdr.Read()) { MenuEnity m = new MenuEnity(sdr[0].ToString(), sdr[1].ToString(), sdr[2].ToString(), Convert.ToSingle(sdr[3]), sdr[4].ToString()); list.Add(m); } return(list); }
/// <summary> /// 菜品列表 /// </summary> /// <param name="Menu_Type"></param> /// <returns></returns> public IList <MenuEnity> GetAllMenu(int Menu_Type) { List <MenuEnity> obj = new List <MenuEnity>(); string sql = "select Menu_Name,Menu_Type,Menu_picture, Menu_ID from dbo.Menu where Menu_Type=@Menu_Type"; SqlParameter[] parameters = { new SqlParameter("@Menu_Type", Menu_Type) }; SqlDataReader dr = SQLHelper.ExecuteReader(sql.ToString(), parameters); while (dr.Read()) { MenuEnity menu = new MenuEnity(dr[0].ToString(), Convert.ToSingle(dr[1]), dr[2].ToString(), dr[3].ToString()); obj.Add(menu); } return(obj); }
/// <summary> /// 通过菜品类型获取菜单 /// </summary> /// <param name="typeid"></param> /// <returns></returns> public List <MenuEnity> getAllMenuByType(string typeName) { List <MenuEnity> list_menu = new List <MenuEnity>(); string strSql = "select Menu_Name,Menu_Price,Menu_picture from dbo.Menu inner join dbo.Menu_Type on Type_ID = Menu_Type where type_Name = @typeName"; SqlParameter[] parameters = { new SqlParameter("@typeName", typeName) }; SqlDataReader sdr = SQLHelper.ExecuteReader(strSql.ToString(), parameters); while (sdr.Read()) { MenuEnity m = new MenuEnity(sdr[0].ToString(), Convert.ToSingle(sdr[1]), sdr[2].ToString()); list_menu.Add(m); } return(list_menu); }