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;
}
}
}
