/// <summary> /// 读取一条用户团购数据 /// </summary> /// <param name="userID">用户ID</param> /// <returns>用户团购用户团购数据模型</returns> public static UserGroupBuyInfo ReadUserGroupBuyByUser(int groupBuyID, int userID) { string sql = "SELECT [ID],[GroupBuyID],[Date],[IP],[BuyCount],[OrderID],[UserID],[UserName],[Consignee],[RegionID],[Address],[ZipCode],[Tel],[Email],[Mobile] FROM " + GroupBuyAccessHelper.TablePrefix + "UserGroupBuy WHERE [GroupBuyID]=" + groupBuyID.ToString() + " AND [UserID]=" + userID.ToString(); UserGroupBuyInfo userGroupBuy = new UserGroupBuyInfo(); using (OleDbDataReader dr = GroupBuyAccessHelper.ExecuteReader(sql)) { if (dr.Read()) { userGroupBuy.ID = dr.GetInt32(0); userGroupBuy.GroupBuyID = dr.GetInt32(1); userGroupBuy.Date = dr.GetDateTime(2); userGroupBuy.IP = dr[3].ToString(); userGroupBuy.BuyCount = dr.GetInt32(4); userGroupBuy.OrderID = dr.GetInt32(5); userGroupBuy.UserID = dr.GetInt32(6); userGroupBuy.UserName = dr[7].ToString(); userGroupBuy.Consignee = dr[8].ToString(); userGroupBuy.RegionID = dr[9].ToString(); userGroupBuy.Address = dr[10].ToString(); userGroupBuy.ZipCode = dr[11].ToString(); userGroupBuy.Tel = dr[12].ToString(); userGroupBuy.Email = dr[13].ToString(); userGroupBuy.Mobile = dr[14].ToString(); } } return(userGroupBuy); }
/// <summary> /// 获得用户团购数据列表 /// </summary> /// <param name="groupBuyID">分类ID</param> /// <returns>用户团购数据列表</returns> public static List <UserGroupBuyInfo> ReadUserGroupBuyList(int groupBuyID) { List <UserGroupBuyInfo> userGroupBuyList = new List <UserGroupBuyInfo>(); string sql = "SELECT * FROM " + GroupBuyAccessHelper.TablePrefix + "UserGroupBuy WHERE [GroupBuyID]=" + groupBuyID; using (OleDbDataReader dr = GroupBuyAccessHelper.ExecuteReader(sql)) { PrepareUserGroupBuyModel(dr, userGroupBuyList); } return(userGroupBuyList); }
/// <summary> /// 获得用户团购数据的产品数量 /// </summary> /// <param name="groupBuyID">分类ID</param> public static Dictionary <int, int> ReadUserGroupBuyCount(string groupBuyIDList) { Dictionary <int, int> dicCount = new Dictionary <int, int>(); string sql = "SELECT [GroupBuyID],SUM(BuyCount) FROM " + GroupBuyAccessHelper.TablePrefix + "UserGroupBuy WHERE [GroupBuyID] IN(" + groupBuyIDList + ") GROUP BY [GroupBuyID]"; using (OleDbDataReader dr = GroupBuyAccessHelper.ExecuteReader(sql)) { while (dr.Read()) { dicCount.Add(dr.GetInt32(0), Convert.ToInt32(dr[1].ToString())); } } return(dicCount); }
/// <summary> /// 读取一条团购数据 /// </summary> /// <param name="id">团购的主键值</param> /// <returns>团购数据模型</returns> public static GroupBuyInfo ReadGroupBuy(int id) { string sql = "SELECT [ID],[Name],[Photo],[Description],[ProductID],[StartDate],[EndDate],[Price],[MinCount],[MaxCount],[EachNumber] FROM " + GroupBuyAccessHelper.TablePrefix + "GroupBuy WHERE [ID]=" + id.ToString(); GroupBuyInfo groupBuy = new GroupBuyInfo(); using (OleDbDataReader dr = GroupBuyAccessHelper.ExecuteReader(sql)) { if (dr.Read()) { groupBuy.ID = dr.GetInt32(0); groupBuy.Name = dr[1].ToString(); groupBuy.Photo = dr[2].ToString(); groupBuy.Description = dr[3].ToString(); groupBuy.ProductID = dr.GetInt32(4); groupBuy.StartDate = dr.GetDateTime(5); groupBuy.EndDate = dr.GetDateTime(6); groupBuy.Price = dr.GetDecimal(7); groupBuy.MinCount = dr.GetInt32(8); groupBuy.MaxCount = dr.GetInt32(9); groupBuy.EachNumber = dr.GetInt32(10); } } return(groupBuy); }
/// <summary> /// 返回DataReader对像 /// </summary> /// <returns></returns> public override OleDbDataReader ExecuteReader() { return(GroupBuyAccessHelper.ExecuteReader(this.PrepareSQL())); }