/// <summary> /// 增加一条团购数据 /// </summary> /// <param name="groupBuy">团购模型变量</param> public static int AddGroupBuy(GroupBuyInfo groupBuy) { string sql = "INSERT INTO " + GroupBuyAccessHelper.TablePrefix + "GroupBuy([Name],[Photo],[Description],[ProductID],[StartDate],[EndDate],[Price],[MinCount],[MaxCount],[EachNumber]) VALUES (@name,@photo,@description,@productID,@startDate,@endDate,@price,@minCount,@maxCount,@eachNumber)"; OleDbParameter[] parameters = { new OleDbParameter("@name", OleDbType.VarWChar), new OleDbParameter("@photo", OleDbType.VarWChar), new OleDbParameter("@description", OleDbType.VarWChar), new OleDbParameter("@productID", OleDbType.Integer), new OleDbParameter("@startDate", OleDbType.VarWChar), new OleDbParameter("@endDate", OleDbType.VarWChar), new OleDbParameter("@price", OleDbType.Decimal), new OleDbParameter("@minCount", OleDbType.Integer), new OleDbParameter("@maxCount", OleDbType.Integer), new OleDbParameter("@eachNumber", OleDbType.Integer) }; parameters[0].Value = groupBuy.Name; parameters[1].Value = groupBuy.Photo; parameters[2].Value = groupBuy.Description; parameters[3].Value = groupBuy.ProductID; parameters[4].Value = groupBuy.StartDate; parameters[5].Value = groupBuy.EndDate; parameters[6].Value = groupBuy.Price; parameters[7].Value = groupBuy.MinCount; parameters[8].Value = groupBuy.MaxCount; parameters[9].Value = groupBuy.EachNumber; GroupBuyAccessHelper.ExecuteNonQuery(sql, parameters); Object id = GroupBuyAccessHelper.ExecuteScalar("SELECT MAX([ID]) FROM " + GroupBuyAccessHelper.TablePrefix + "GroupBuy"); groupBuy.ID = Convert.ToInt32(id); UploadBLL.UpdateUpload(TableID, 0, groupBuy.ID, Cookies.Admin.GetRandomNumber(false)); return(groupBuy.ID); }
/// <summary> /// 获得用户团购数据的产品数量 /// </summary> /// <param name="groupBuyID">分类ID</param> public static int ReadUserGroupBuyCount(int groupBuyID) { string sql = "SELECT SUM(BuyCount) FROM " + GroupBuyAccessHelper.TablePrefix + "UserGroupBuy WHERE [GroupBuyID]=" + groupBuyID; object count = GroupBuyAccessHelper.ExecuteScalar(sql); if (count != null && count != DBNull.Value) { return(Convert.ToInt32(count)); } else { return(0); } }
/// <summary> /// 增加一条用户团购数据 /// </summary> /// <param name="userGroupBuy">用户团购模型变量</param> public static int AddUserGroupBuy(UserGroupBuyInfo userGroupBuy) { string sql = "INSERT INTO " + GroupBuyAccessHelper.TablePrefix + "UserGroupBuy([GroupBuyID],[Date],[IP],[BuyCount],[OrderID],[UserID],[UserName],[Consignee],[RegionID],[Address],[ZipCode],[Tel],[Email],[Mobile]) VALUES (@groupBuyID,@date,@iP,@buyCount,@orderID,@userID,@userName,@consignee,@regionID,@address,@zipCode,@tel,@email,@mobile)"; OleDbParameter[] parameters = { new OleDbParameter("@groupBuyID", OleDbType.Integer), new OleDbParameter("@date", OleDbType.VarWChar), new OleDbParameter("@iP", OleDbType.VarWChar), new OleDbParameter("@buyCount", OleDbType.Integer), new OleDbParameter("@orderID", OleDbType.Integer), new OleDbParameter("@userID", OleDbType.Integer), new OleDbParameter("@userName", OleDbType.VarWChar), new OleDbParameter("@consignee", OleDbType.VarWChar), new OleDbParameter("@regionID", OleDbType.VarWChar), new OleDbParameter("@address", OleDbType.VarWChar), new OleDbParameter("@zipCode", OleDbType.VarWChar), new OleDbParameter("@tel", OleDbType.VarWChar), new OleDbParameter("@email", OleDbType.VarWChar), new OleDbParameter("@mobile", OleDbType.VarWChar) }; parameters[0].Value = userGroupBuy.GroupBuyID; parameters[1].Value = userGroupBuy.Date; parameters[2].Value = userGroupBuy.IP; parameters[3].Value = userGroupBuy.BuyCount; parameters[4].Value = userGroupBuy.OrderID; parameters[5].Value = userGroupBuy.UserID; parameters[6].Value = userGroupBuy.UserName; parameters[7].Value = userGroupBuy.Consignee; parameters[8].Value = userGroupBuy.RegionID; parameters[9].Value = userGroupBuy.Address; parameters[10].Value = userGroupBuy.ZipCode; parameters[11].Value = userGroupBuy.Tel; parameters[12].Value = userGroupBuy.Email; parameters[13].Value = userGroupBuy.Mobile; GroupBuyAccessHelper.ExecuteNonQuery(sql, parameters); Object id = GroupBuyAccessHelper.ExecuteScalar("SELECT MAX([ID]) FROM " + GroupBuyAccessHelper.TablePrefix + "UserGroupBuy"); return(Convert.ToInt32(id)); }