// /// <summary> /// 查消费的数量还有总价格 /// </summary> /// <param name="orderId">订单的id</param> /// <returns>总数量和总价格</returns> public R_OrderInfo_Product GetCountAndMoney(int orderId) { string sql = "select count(*),sum(UnitCount*ProPrice) from R_OrderInfo_Product inner join ProductInfo on ProductInfo.ProId=R_OrderInfo_Product.ProId where R_OrderInfo_Product.DelFlag=0 and OrderId=@OrderId"; SQLiteDataReader reader = SqliteHelper.ExecuteReader(sql, new SQLiteParameter("@OrderId", orderId)); R_OrderInfo_Product rop = null; if (reader.HasRows) { while (reader.Read()) { rop = new R_OrderInfo_Product();//这是个大坑 rop.CT = reader.GetInt32(0); rop.MONEY = reader.GetDecimal(1); } } return(rop); }
/// <summary> /// 查询会员级别 /// </summary> /// <param name="delFlag">删除标识</param> /// <returns>级别对象集合</returns> public List <MemmberType> GetAllMemmberTypeByDelFlag(int delFlag) { string sql = "select MemType,MemTpName from MemmberType where DelFlag=@DelFlag"; SQLiteDataReader reader = SqliteHelper.ExecuteReader(sql, new SQLiteParameter("@DelFlag", delFlag)); List <MemmberType> list = new List <MemmberType>(); if (reader.HasRows) { while (reader.Read()) { MemmberType mt = new MemmberType(); mt.MemTpName = reader["MemTpName"].ToString(); mt.MemType = Convert.ToInt32(reader["MemType"]); list.Add(mt); } } return(list); }
/// <summary> /// 根据会员id获取会员的级别还有金额还有折扣 /// </summary> /// <param name="memId">会员id</param> /// <returns></returns> public MemmberInfo GetMemMoneyAndDisCountAndTypeNameByMemId(int memId) { string sql = "select MemTpName,MemDiscount,MemMoney from MemmberInfo inner join MemmberType on MemmberType.MemType=MemmberInfo.MemType where MemmberInfo.DelFlag=0 and MemmberId=@MemmberId"; SQLiteDataReader reader = SqliteHelper.ExecuteReader(sql, new SQLiteParameter("@MemmberId", memId)); MemmberInfo mem = null; if (reader.HasRows) { while (reader.Read()) { mem = new MemmberInfo(); mem.MemTpName = reader["MemTpName"].ToString(); mem.MemMoney = Convert.ToDecimal(reader["MemMoney"]); mem.MemDiscount = Convert.ToDecimal(reader["MemDiscount"]); } } return(mem); }
/// <summary> /// 根据餐桌id查询该餐桌信息 /// </summary> /// <param name="id">餐桌id</param> /// <returns></returns> public DeskInfo GetDeskById(int id) { string sql = "select RoomId,DeskName,DeskRemark,DeskRegion from DeskInfo where DelFlag=0 and DeskId=@DeskId"; SQLiteDataReader reader = SqliteHelper.ExecuteReader(sql, new SQLiteParameter("@DeskId", id)); DeskInfo dk = new DeskInfo(); if (reader.HasRows) { while (reader.Read()) { dk.DeskName = reader["DeskName"].ToString(); dk.DeskRegion = reader["DeskRegion"].ToString(); dk.DeskRemark = reader["DeskRemark"].ToString(); dk.RoomId = Convert.ToInt32(reader["RoomId"]); } } return(dk); }
/// <summary> /// 根据id查询房间信息 /// </summary> /// <param name="id">房间id</param> /// <returns></returns> public RoomInfo GetRoomInfoByRoomId(int id) { string sql = "select RoomName , RoomType ,RoomMinimunConsume ,RoomMaxConsumer, IsDefault from RoomInfo where DelFlag=0 and RoomId=@RoomId"; SQLiteDataReader reader = SqliteHelper.ExecuteReader(sql, new SQLiteParameter("@RoomId", id)); RoomInfo r = new RoomInfo(); if (reader.HasRows) { while (reader.Read()) { r.RoomName = reader["RoomName"].ToString(); r.RoomType = Convert.ToInt32(reader["RoomType"]); r.RoomMinimunConsume = Convert.ToDecimal(reader["RoomMinimunConsume"]); r.RoomMaxConsumer = Convert.ToDecimal(reader["RoomMaxConsumer"]); r.IsDefault = Convert.ToInt32(reader["IsDefault"]); } } return(r); }
/// <summary> /// 获取所有房间的名字和id /// </summary> /// <param name="delFlag">删除标识</param> /// <returns></returns> public List <RoomInfo> GetRoomNameAndId(int delFlag) { string sql = "select RoomId,RoomName from RoomInfo where DelFlag=@DelFlag"; SQLiteDataReader reader = SqliteHelper.ExecuteReader(sql, new SQLiteParameter("@DelFlag", delFlag)); List <RoomInfo> list = new List <RoomInfo>(); if (reader.HasRows) { while (reader.Read()) { RoomInfo r = new RoomInfo(); r.RoomId = Convert.ToInt32(reader["RoomId"]); r.RoomName = reader["RoomName"].ToString(); list.Add(r); } } return(list); }
/// <summary> /// 根据房间的id获取该房间下的所有的餐桌 /// </summary> /// <param name="roomId">房间的id</param> /// <returns>餐桌集合</returns> public List <DeskInfo> GetAllDeskInfoByRoomId(int roomId) { string sql = "select DeskId,DeskName,DeskRemark,DeskRegion,DeskState from DeskInfo where DelFlag=0 and RoomId=@RoomId"; SQLiteDataReader reader = SqliteHelper.ExecuteReader(sql, new SQLiteParameter("@RoomId", roomId)); List <DeskInfo> list = new List <DeskInfo>(); if (reader.HasRows) { while (reader.Read()) { DeskInfo dk = new DeskInfo(); dk.DeskId = Convert.ToInt32(reader["DeskId"]); dk.DeskName = reader["DeskName"].ToString(); dk.DeskRegion = reader["DeskRegion"].ToString(); dk.DeskRemark = reader["DeskRemark"].ToString(); dk.DeskState = Convert.ToInt32(reader["DeskState"]); list.Add(dk); } } return(list); }
/// <summary> /// 根据订单的Id查询总数量和总金额 /// </summary> /// <param name="orderId">订单id</param> /// <returns></returns> public R_OrderInfo_Product GetMoneyAndCount(int orderId) { string sql = "select count(*),sum(UnitCount*ProPrice)from R_OrderInfo_Product inner join ProductInfo on R_OrderInfo_Product.ProId=ProductInfo.ProId where OrderId=@OrderId"; //释放 SQLiteDataReader sda = SqliteHelper.ExecuteReader(sql, new SQLiteParameter("@OrderId", orderId)); R_OrderInfo_Product r = null; if (sda.HasRows) { if (sda != null) { while (sda.Read()) { r = new R_OrderInfo_Product(); r.CT = Convert.ToInt32(sda[0]); r.MONEY = Convert.ToDecimal(sda[1]); } } } return(r); }