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