/// <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="sender"></param> /// <param name="e"></param> protected void SubmitButton_Click(object sender, EventArgs e) { //读取用户信息 userID = Cookies.User.GetUserID(true); string userName = Cookies.User.GetUserName(false); string userEmail = CookiesHelper.ReadCookieValue("UserEmail"); //添加团购记录 int id = RequestHelper.GetQueryString <int>("ID"); groupBuy = GroupBuyBLL.ReadGroupBuy(id); UserGroupBuyInfo userGroupBuy = new UserGroupBuyInfo(); userGroupBuy.GroupBuyID = id; userGroupBuy.Date = RequestHelper.DateNow; userGroupBuy.IP = ClientHelper.IP; userGroupBuy.BuyCount = RequestHelper.GetForm <int>("BuyCount"); userGroupBuy.OrderID = 0; userGroupBuy.UserID = userID; userGroupBuy.UserName = userName; userGroupBuy.Consignee = StringHelper.AddSafe(RequestHelper.GetForm <string>("Consignee")); userGroupBuy.RegionID = RegionID.ClassID; userGroupBuy.Address = StringHelper.AddSafe(RequestHelper.GetForm <string>("Address")); userGroupBuy.ZipCode = StringHelper.AddSafe(RequestHelper.GetForm <string>("ZipCode")); userGroupBuy.Tel = StringHelper.AddSafe(RequestHelper.GetForm <string>("Tel")); userGroupBuy.Email = userEmail; userGroupBuy.Mobile = StringHelper.AddSafe(RequestHelper.GetForm <string>("Mobile")); UserGroupBuyBLL.AddUserGroupBuy(userGroupBuy); UserAccountRecordBLL.AddUserAccountRecord(-groupBuy.Price * userGroupBuy.BuyCount, 0, "参加团购活动:" + groupBuy.Name, userID, userName); ScriptHelper.Alert("购买成功!", "GroupBuyDetail.aspx?ID=" + userGroupBuy.GroupBuyID); }
/// <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)); }
/// <summary> /// 准备用户团购模型 /// </summary> /// <param name="dr">Datareader</param> /// <param name="userGroupBuyList">用户团购的数据列表</param> public static void PrepareUserGroupBuyModel(OleDbDataReader dr, List <UserGroupBuyInfo> userGroupBuyList) { while (dr.Read()) { UserGroupBuyInfo userGroupBuy = new UserGroupBuyInfo(); 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(); userGroupBuyList.Add(userGroupBuy); } }