/// <summary>
/// 添加用户
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddUserInfo(AttendUserModel model)
{
string strSql = string.Format(@"insert into Hot_AttendUser(customerid,openid,nickname,headimgurl,unionid,city,couponcode,money,isattend,defmoney) values(@customerid,@openid,@nickname,@headimgurl,@unionid,@city,@couponcode,@money,@isattend,@defmoney);select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@customerid", model.customerid),
new SqlParameter("@openid", model.openid),
new SqlParameter("@nickname", model.nickname),
new SqlParameter("@headimgurl", model.headimgurl),
new SqlParameter("@unionid", model.unionId),
new SqlParameter("@city", model.city),
new SqlParameter("@couponcode", model.couponCode),
new SqlParameter("@money", model.money),
new SqlParameter("@isattend", model.isAttend),
new SqlParameter("@defmoney", model.defmoney)
};
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 获取分页数据
/// </summary>
private void GethelpUserList()
{
string shareopenid = this.GetFormValue("shareopenid", "");//分享用户
int customerid = this.GetFormValue("customerid", 0);
int pageIndex = this.GetFormValue("pageIndex", 0);
int pageSize = this.GetFormValue("pageSize", 0);
AttendUserModel userModel = UserService.Instance.GetAttendUserInfo(customerid, shareopenid);
if (userModel != null)
{
List <HelpUserModel> lst = UserService.Instance.GethelpUserList(pageIndex, pageSize, customerid, userModel.id);
this.Data["data"] = lst;
this.Data["count"] = lst.Count();
this.code = 1;
}
this.Data["pageIndex"] = pageIndex;
}
/// <summary>
/// 根据优惠券码获取用户信息
/// </summary>
/// <param name="customerid"></param>
/// <param name="couponCode"></param>
/// <returns></returns>
public AttendUserModel GetUserCouponInfo(int customerid, string couponCode)
{
string sql = "select top 1 id,customerid,openid,nickname,headimgurl,unionid,city,couponcode,money,isattend,defmoney,useStatus,shopUserId from Hot_AttendUser where couponCode=@couponCode and customerid=@customerid";
SqlParameter[] parameters =
{
new SqlParameter("@customerid", customerid),
new SqlParameter("@couponCode", couponCode)
};
AttendUserModel model = new AttendUserModel();
using (SqlDataReader dr = DbHelperSQL.ExecuteReader(sql, parameters))
{
model = DbHelperSQL.GetEntity <AttendUserModel>(dr);
}
return(model);
}
protected void Page_Load(object sender, EventArgs e)
{
int shopid = UserService.Instance.GetShopId(CurrentCustomerID, this.GetOpenIdVal());
if (shopid > 0)
{
userModel = UserService.Instance.GetUserCouponInfo(CurrentCustomerID, couponCode);
if (UserService.Instance.ShopUseCoupon(CurrentCustomerID, shopid, couponCode) > 0)
{
isSuccess = true;
showText = "使用成功";
}
else
{
isSuccess = false;
showText = "优惠券已使用";
}
}
else
{
isSuccess = false;
showText = "您不是经销商，请去绑定账号！";
}
}
/// <summary>
/// 注册用户
/// </summary>
/// <param name="customerId"></param>
/// <param name="oauth"></param>
/// <returns></returns>
public int RegisterUser(int customerId, WeixinOAuthUserInfoModel oauth)
{
AttendUserModel model = new AttendUserModel()
{
customerid = customerId,
headimgurl = oauth.Headimgurl,
openid = oauth.Openid,
nickname = oauth.Nickname,
city = oauth.City,
isAttend = 0,
unionId = oauth.UnionID,
couponCode = StringHelper.RandomNo(new Random(Guid.NewGuid().GetHashCode()), 16)
};
string couponValue = ConfigHelper.GetConfigString("couponValue", "0");
if (!string.IsNullOrEmpty(couponValue))
{
model.money = Convert.ToDecimal(couponValue);
}
model.defmoney = model.money;
return(dal.AddUserInfo(model));
}
/// <summary>
/// 帮忙砍价
/// </summary>
private void HelpBargain()
{
string shareopenid = this.GetFormValue("shareopenid", ""); //分享用户
string openid = this.GetFormValue("openid", ""); //当前用户
int customerid = this.GetFormValue("customerid", 0);
decimal money = 0;
string[] arr = sectionVal.Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries);
int minV = Convert.ToInt32(arr[0]);
int maxV = Convert.ToInt32(arr[1]);
string[] arr2 = sectionVal2.Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries);
int minV2 = Convert.ToInt32(arr2[0]);
int maxV2 = Convert.ToInt32(arr2[1]);
try
{
AttendUserModel userModel = UserService.Instance.GetAttendUserInfo(customerid, shareopenid);
if (userModel != null && userModel.isAttend == 1)
{
bool isHelped = UserService.Instance.GethelpUser(customerid, openid, userModel.id);
if (isHelped)//已经助力过
{
this.code = 2;
msg = getTipContent(customerid, 2);
return;
}
//已经砍到最大额度了
if (couponMaxValue <= userModel.money)
{
this.code = 3;
msg = getTipContent(customerid, 3);
return;
}
if (userModel.useStatus == 1)
{
this.code = 5;
msg = getTipContent(customerid, 5);
return;
}
string endTime = ConfigHelper.GetConfigString("endTime", "2016-05-02");
DateTime outime;
DateTime.TryParse(endTime, out outime);
if (DateTime.Now > outime)//判断活动是否结束
{
this.code = 4;
msg = getTipContent(customerid, 4);
return;
}
Random random = new Random(Guid.NewGuid().GetHashCode());
if (userModel.money < 500)
{
money = Convert.ToDecimal((random.Next(minV, maxV) - random.NextDouble()));
}
else //用户助力到500元后，取另外一个金额区间
{
money = Convert.ToDecimal((random.Next(minV2, maxV2) - random.NextDouble()));
}
//当前看的价格加当前的价格，大于优惠券最大价格时
if (couponMaxValue <= (userModel.money + money))
{
money = couponMaxValue - userModel.money;
}
//更新优惠券额度
UserService.Instance.UpdateAttendUserMoney(customerid, shareopenid, money);
//添加砍价记录
UserService.Instance.AddHelpUser(customerid, userModel.id, openid, money);
code = 1;
}
else
{
msg = getTipContent(customerid, 1);
}
}
catch (Exception ex)
{
msg = ex.Message;
}
finally
{
this.Data["money"] = money.ToString("f2");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(shareOpenId))
{
WriteLog("invalid URL");
}
DateTime outime;
DateTime.TryParse(actEndTime, out outime);
if (DateTime.Now < outime)
{
isEnd = false;
}
else
{
isEnd = true;
}
if (currentOpenid == shareOpenId)//当前是自己访问自己的页面
{
userModel = UserService.Instance.GetAttendUserInfo(CurrentCustomerID, currentOpenid);
_self = true;
if (userModel != null)
{
if (userModel.isAttend == 0 && !isEnd)
{
//修改用户参与状态
UserService.Instance.UpdateAttendUserStatus(CurrentCustomerID, currentOpenid);
}
if (userModel.isAttend == 0 && isEnd)
{
WriteLog("活动已结束");
}
if (userModel.useStatus == 0)
{
this.ShowText = "朋友已帮 <span style='color:red'>wo</span> 砍价" + (userModel.money - userModel.defmoney) + "元";
}
else
{
this.ShowText = "您的优惠券已使用！";
}
}
}
else
{
_self = false;
userModel = UserService.Instance.GetAttendUserInfo(CurrentCustomerID, shareOpenId);
if (userModel != null)
{
if (userModel.useStatus == 0)
{
this.ShowText = "<span style='color:red'>" + userModel.nickname + "</span>邀请您帮TA砍价";
}
else
{
this.ShowText = "<span style='color:red'>" + userModel.nickname + "</span>的优惠券已使用";
}
}
}
if (userModel != null)
{
myCouponCode.Value = userModel.couponCode;
attendCount = UserService.Instance.GetAttendActCount(CurrentCustomerID, userModel.id);
}
}
