protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { using (WXDBEntities db = new WXDBEntities()) { if (!string.IsNullOrEmpty(Request["del"]) && WebUtil.IsDigit(Request["del"])) { int tmpid = Convert.ToInt32(Request["del"]); UserPoinLog model = db.UserPoinLog.Where(s => s.Id == tmpid).FirstOrDefault(); if (model != null) { var tm = db.Forms.Where(s => s.Source.Equals(topid) && s.Type.Equals(8)).FirstOrDefault(); if (tm != null) { //tm.JFCount = tm.JFCount - Convert.ToDecimal(model.Extent1); // tm.Status = tm.Status - 1; } db.UserPoinLog.DeleteObject(model); db.SaveChanges(); } } } BindRepeater(topid); } using (WXDBEntities db = new WXDBEntities()) { var tm = db.Forms.Where(s => s.Source.Equals(topid) && s.Type.Equals(8)).FirstOrDefault(); if (tm != null) { ctitile = tm.Name; } } }
protected void IsQd(HttpContext context) { var tmpopid = context.Request.Params["tmpid"]; using (WXDBEntities db = new WXDBEntities()) { UserPoinLog tmodel = db.UserPoinLog.Where(s => s.WxOpenid == tmpopid && s.PointCode == 2).OrderByDescending(s => s.AddTime).FirstOrDefault(); if (tmodel != null) { if (tmodel.AddTime.Date == DateTime.Now.Date) { context.Response.Write("{\"flag\":\"0\"}"); } else { context.Response.Write("{\"flag\":\"002\"}"); } } else { context.Response.Write("{\"flag\":\"002\"}"); } } }
protected void Addqd(HttpContext context) { var tmpopid = context.Request.Params["tmpid"]; using (WXDBEntities db = new WXDBEntities()) { UserPoinLog tmodel = db.UserPoinLog.Where(s => s.WxOpenid == tmpopid && s.PointCode == 2).OrderByDescending(s => s.AddTime).FirstOrDefault(); try { //lotterUserInfo lt = db.lotterUserInfo.Where(s => s.OpenId == tmpopid).FirstOrDefault(); Forms formodel = db.Forms.Where(s => s.Type == 6).Where(s => s.Source == tmpopid).FirstOrDefault(); if (tmodel != null) { if (tmodel.AddTime.Date == DateTime.Now.Date) { context.Response.Write("{\"flag\":\"002\"}"); } else { if (formodel != null) { UserPoinLog ml = new UserPoinLog() { UserPointDesc = "签到送积分", WxOpenid = tmpopid, WxNickName = "", PointCode = 2,//签到送积分 AddTime = DateTime.Now, Updatetime = DateTime.Now, Status = 0, Orders = 0, Extent1 = GetJFAdd(formodel.Extend2), Extent2 = "", Extent3 = "" }; Signtable sl = db.Signtable.Where(s => s.wxopenid == tmpopid).FirstOrDefault(); if (sl != null) { if (DateTime.Now.AddDays(-1).Date == sl.PrevLoginDate.Date) { sl.LCount = sl.LCount + 1; } else { sl.LCount = 1; } formodel.JFCount += Convert.ToDouble(GetJFAdd(formodel.Extend2)); db.UserPoinLog.AddObject(ml); db.SaveChanges(); if (sl.LCount >= 7) { sl.LCount = 1; UserPoinLog ml2 = new UserPoinLog() { UserPointDesc = "连续签到送积分", WxOpenid = tmpopid, WxNickName = "", PointCode = 4,//连续签到送积分 AddTime = DateTime.Now, Updatetime = DateTime.Now, Status = 0, Orders = 0, Extent1 = "10", Extent2 = "", Extent3 = "" }; formodel.JFCount += 10; db.UserPoinLog.AddObject(ml2); } } else { sl = new Signtable() { wxopenid = tmpopid, LCount = 1, PrevLoginDate = DateTime.Now, AddTime = DateTime.Now, Extent1 = "", Extent2 = "" }; db.Signtable.AddObject(sl); } db.SaveChanges(); } else { formodel = new Forms(); formodel.Name = ""; formodel.Number = 0; formodel.Mobile = ""; formodel.Age = 0; formodel.Source = tmpopid; formodel.Income = ""; formodel.AddTime = DateTime.Now; formodel.UpdateTime = DateTime.Now; formodel.Remark = ""; formodel.Status = 0; formodel.Orders = 0; formodel.FormType = 0; formodel.Extend = ""; formodel.Extend2 = WebConn.MembersLevel.PT.ToString(); //会员信息 formodel.Type = 6; formodel.Title = ""; formodel.JFCount = 0; UserPoinLog ml = new UserPoinLog() { UserPointDesc = "签到送积分", WxOpenid = tmpopid, WxNickName = "", PointCode = 2,//签到送积分 AddTime = DateTime.Now, Updatetime = DateTime.Now, Status = 0, Orders = 0, Extent1 = "1", Extent2 = "", Extent3 = "" }; Signtable sl = db.Signtable.Where(s => s.wxopenid == tmpopid).FirstOrDefault(); if (DateTime.Now.AddDays(-1).Date == sl.PrevLoginDate.Date) { sl.LCount = sl.LCount + 1; } else { sl.LCount = 1; } db.Forms.AddObject(formodel); db.UserPoinLog.AddObject(ml); db.SaveChanges(); } context.Response.Write("{\"flag\":\"001\"}"); } } else { if (formodel != null) { UserPoinLog ml = new UserPoinLog() { UserPointDesc = "签到送积分", WxOpenid = tmpopid, WxNickName = "", PointCode = 2,//签到送积分 AddTime = DateTime.Now, Updatetime = DateTime.Now, Status = 0, Orders = 0, Extent1 = GetJFAdd(formodel.Extend2), Extent2 = "", Extent3 = "" }; formodel.JFCount += Convert.ToDouble(GetJFAdd(formodel.Extend2)); Signtable sl = new Signtable() { wxopenid = tmpopid, LCount = 1, PrevLoginDate = DateTime.Now, AddTime = DateTime.Now, Extent1 = "", Extent2 = "" }; db.Signtable.AddObject(sl); db.UserPoinLog.AddObject(ml); db.SaveChanges(); } else { formodel = new Forms(); formodel.Name = ""; formodel.Number = 0; formodel.Mobile = ""; formodel.Age = 0; formodel.Source = tmpopid; formodel.Income = ""; formodel.AddTime = DateTime.Now; formodel.UpdateTime = DateTime.Now; formodel.Remark = ""; formodel.Status = 0; formodel.Orders = 0; formodel.FormType = 0; formodel.Extend = ""; formodel.Extend2 = WebConn.MembersLevel.PT.ToString(); //会员信息 formodel.Type = 6; formodel.Title = ""; formodel.JFCount = 1; UserPoinLog ml = new UserPoinLog() { UserPointDesc = "签到送积分", WxOpenid = tmpopid, WxNickName = "", PointCode = 2,//签到送积分 AddTime = DateTime.Now, Updatetime = DateTime.Now, Status = 0, Orders = 0, Extent1 = "1", Extent2 = "", Extent3 = "" }; Signtable sl = new Signtable() { wxopenid = tmpopid, LCount = 1, PrevLoginDate = DateTime.Now, AddTime = DateTime.Now, Extent1 = "", Extent2 = "" }; db.Signtable.AddObject(sl); db.Forms.AddObject(formodel); db.UserPoinLog.AddObject(ml); db.SaveChanges(); } context.Response.Write("{\"flag\":\"001\"}"); } } catch (Exception) { throw; } } }
protected void AddYhQinfo(HttpContext context) { var tmpopid = context.Request.Params["tmpopid"]; var tmpqtype = context.Request.Params["qtype"]; using (WXDBEntities db = new WXDBEntities()) { var forms = db.Forms.Where(s => s.Type == 6 && s.Source == tmpopid).FirstOrDefault(); if (forms != null) { double xfi = 0f; string desc = string.Empty; switch (tmpqtype) { case "YY": xfi = 210; desc = "游泳优惠券"; break; case "MN": xfi = 300; desc = "迷你吧台优惠券"; break; case "XWC": xfi = 408; desc = "下午茶优惠券"; break; } if ((forms.JFCount - xfi) > 0) { var lotter = new lotterUserInfo(); lotter.AddTime = DateTime.Now; lotter.Type = 0;//积分兑换优惠券 lotter.OpenId = tmpopid; lotter.lotDesc = desc; lotter.StartTime = DateTime.Now; lotter.LotterNumber = 0; lotter.Updatetime = DateTime.Now; lotter.LotterSN = "yh" + DateTime.Now.ToString("HHmmss") + Senparc.Weixin.MP.TenPayLib.TenPayUtil.BuildRandomStr(4) + "q"; lotter.PriceName = ""; lotter.PriceNumber = 0; lotter.Extend1 = ""; lotter.Extend2 = ""; lotter.Status = 0; lotter.Orders = 0; lotter.Extend3 = "0";//是否使用 db.lotterUserInfo.AddObject(lotter); UserPoinLog ml = new UserPoinLog() { UserPointDesc = "兑换优惠券消费", WxOpenid = tmpopid, WxNickName = "", PointCode = 7,//兑换优惠券消费 AddTime = DateTime.Now, Updatetime = DateTime.Now, Status = 0, Orders = 0, Extent1 = "-" + xfi.ToString(), Extent2 = "", Extent3 = "" }; forms.JFCount = forms.JFCount - xfi; db.UserPoinLog.AddObject(ml); db.SaveChanges(); //计入lotteruserinfo中 context.Response.Write("{\"flag\":\"2\",\"desc\":\"兑换成功,优惠券信息请在我的优惠券中查询!\"}"); return; } else { context.Response.Write("{\"flag\":\"1\",\"desc\":\"您当前的积分不足以兑换!\"}"); return; } } else { context.Response.Write("{\"flag\":\"0\",\"desc\":\"请注册会员信息或者消费后进行兑换!\"}"); return; } } }