public UserRedPagerInfo GetUserRedPagerByOrderIDAndUserID(int userid, string orderid) { UserRedPagerInfo info = new UserRedPagerInfo(); DbCommand sqlStringCommand = this.database.GetSqlStringCommand("select top 1 * from vshop_UserRedPager where OrderID=@OrderID and UserID=@UserID"); this.database.AddInParameter(sqlStringCommand, "UserID", DbType.Int32, userid); this.database.AddInParameter(sqlStringCommand, "OrderID", DbType.String, orderid); using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand)) { if (reader.Read()) { info = DataMapper.PopulateUserRedPagerInfo(reader); } } return(info); }
public string CreateUserRedPager(UserRedPagerInfo userredpager) { if (this.HasGetThisRedPager(userredpager.UserID, userredpager.OrderID)) { return("-1"); } DbCommand sqlStringCommand = this.database.GetSqlStringCommand("if exists(select top 1 OrderID from vshop_OrderRedPager where OrderID=@OrderID and MaxGetTimes>AlreadyGetTimes) begin Update vshop_OrderRedPager set AlreadyGetTimes=AlreadyGetTimes+1 where OrderID=@OrderID;INSERT INTO vshop_UserRedPager(Amount,UserID,OrderID,RedPagerActivityName,OrderAmountCanUse,CreateTime,ExpiryTime,IsUsed) VALUES(@Amount,@UserID,@OrderID,@RedPagerActivityName,@OrderAmountCanUse,@CreateTime,@ExpiryTime,@IsUsed); select 1 end else begin select 0 end"); this.database.AddInParameter(sqlStringCommand, "Amount", DbType.Decimal, userredpager.Amount); this.database.AddInParameter(sqlStringCommand, "UserID", DbType.Int32, userredpager.UserID); this.database.AddInParameter(sqlStringCommand, "OrderID", DbType.String, userredpager.OrderID); this.database.AddInParameter(sqlStringCommand, "RedPagerActivityName", DbType.String, userredpager.RedPagerActivityName); this.database.AddInParameter(sqlStringCommand, "OrderAmountCanUse", DbType.Decimal, userredpager.OrderAmountCanUse); this.database.AddInParameter(sqlStringCommand, "CreateTime", DbType.DateTime, userredpager.CreateTime); this.database.AddInParameter(sqlStringCommand, "ExpiryTime", DbType.DateTime, userredpager.ExpiryTime); this.database.AddInParameter(sqlStringCommand, "IsUsed", DbType.Boolean, userredpager.IsUsed); return(this.database.ExecuteScalar(sqlStringCommand).ToString()); }
public UserRedPagerInfo GetUserRedPagerByRedPagerID(int redpagerid) { if (redpagerid <= 0) { return(null); } UserRedPagerInfo info = null; string query = string.Format("select * FROM vshop_UserRedPager WHERE redpagerid={0}", redpagerid); DbCommand sqlStringCommand = this.database.GetSqlStringCommand(query); using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand)) { if (reader.Read()) { info = DataMapper.PopulateUserRedPagerInfo(reader); } } return(info); }
public static string CreateUserRedPager(UserRedPagerInfo userredpager) { return(new UserRedPagerDao().CreateUserRedPager(userredpager)); }
protected override void AttachChildControls() { string s = HttpContext.Current.Request.QueryString.Get("m"); string str2 = HttpContext.Current.Request.QueryString.Get("type"); this.ltGetTotal = (Literal)this.FindControl("ltGetTotal"); this.ltOrderAmountCanUse = (Literal)this.FindControl("ltOrderAmountCanUse"); this.ltExpiryTime = (Literal)this.FindControl("ltExpiryTime"); this.ltRedPagerActivityName = (Literal)this.FindControl("ltRedPagerActivityName"); this.ltRedPagerActivityNameForOrders = (Literal)this.FindControl("ltRedPagerActivityNameForOrders"); this.divNoLogin = (Panel)this.FindControl("divNoLogin"); this.divNoNum = (Panel)this.FindControl("divNoNum"); this.divSuccess = (Panel)this.FindControl("divSuccess"); this.hlinkLogin = (HyperLink)this.FindControl("hlinkLogin"); switch (str2) { case "1": case "5": { int result = 0; int.TryParse(s, out result); if (result > 0) { string orderid = HttpContext.Current.Request.QueryString.Get("orderid"); UserRedPagerInfo userRedPagerByOrderIDAndUserID = UserRedPagerBrower.GetUserRedPagerByOrderIDAndUserID(result, orderid); if (userRedPagerByOrderIDAndUserID != null) { this.ltGetTotal.Text = userRedPagerByOrderIDAndUserID.Amount.ToString().Split(new char[] { '.' })[0]; this.ltOrderAmountCanUse.Text = userRedPagerByOrderIDAndUserID.OrderAmountCanUse.ToString("F2").Replace(".00", ""); this.ltExpiryTime.Text = userRedPagerByOrderIDAndUserID.ExpiryTime.ToString("yyyy-M-d"); if (str2 == "5") { this.ltRedPagerActivityName.Text = "该券已经到你的钱包了</div><div class='get-red-explain'><a href='/Vshop/myredpager.aspx'>点击查看</a>"; } else { this.ltRedPagerActivityName.Text = userRedPagerByOrderIDAndUserID.RedPagerActivityName ?? ""; } this.divSuccess.Visible = true; } } PageTitle.AddSiteNameTitle("成功获取代金券"); return; } default: { string str6 = str2; if (str6 != null) { if (!(str6 == "-1")) { if ((str6 == "-2") || (str6 == "-4")) { this.divNoLogin.Visible = true; break; } if (str6 == "-3") { this.divNoNum.Visible = true; break; } } else { string str4 = HttpContext.Current.Request.QueryString.Get("orderid"); OrderRedPagerInfo orderRedPagerInfo = OrderRedPagerBrower.GetOrderRedPagerInfo(str4); if (orderRedPagerInfo != null) { this.ltRedPagerActivityNameForOrders.Text = orderRedPagerInfo.RedPagerActivityName; string str5 = "http://" + Globals.DomainName + Globals.ApplicationPath + "/Vshop/GetRedPager.aspx?orderid=" + str4; this.hlinkLogin.NavigateUrl = "/Vshop/UserLogin.aspx?returnUrl=" + HttpContext.Current.Server.UrlEncode(str5 + "&" + this.getopenid()); this.divNoLogin.Visible = true; } else { HttpContext.Current.Response.Redirect("/Vshop/"); HttpContext.Current.Response.End(); } } } break; } } PageTitle.AddSiteNameTitle("获取代金券"); }