/// <summary>
/// 保存用户积分
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private string SavaUserScore(HttpContext context)
{
string signUpId = context.Request["signUpId"];
BLLJIMP.Model.JuActivityInfo juActivityInfo = bllJuactivity.Get <BLLJIMP.Model.JuActivityInfo>(string.Format(" WebsiteOwner='{0}' and SignUpActivityID='{1}'", bll.WebsiteOwner, signUpId));
if ((this.currentUserInfo.TotalScore >= juActivityInfo.ActivityIntegral) && (juActivityInfo.ActivityIntegral > 0))
{
this.currentUserInfo.TotalScore -= juActivityInfo.ActivityIntegral;
if (bllJuactivity.Update(this.currentUserInfo))
{
BLLJIMP.Model.WBHScoreRecord record = new BLLJIMP.Model.WBHScoreRecord()
{
NameStr = "参加" + juActivityInfo.ActivityName,
Nums = "b55",
InsertDate = DateTime.Now,
ScoreNum = "-" + juActivityInfo.ActivityIntegral,
WebsiteOwner = bll.WebsiteOwner,
UserId = this.currentUserInfo.UserID,
RecordType = "1"
};
bllJuactivity.Add(record);
resp.Status = 0;
}
}
else
{
resp.Status = 0;
resp.Msg = "";
}
return(Common.JSONHelper.ObjectToJson(resp));
}
//保存加分历史记录，返回加分值，0为保存失败。
private double SaveScoreRecord(UserScore userScore, BLLTransaction transaction)
{
string deltaScoreStr = string.Empty;
if (userScore.Score > 0)
{
deltaScoreStr = string.Format("+{0}", userScore.Score);
}
else
{
deltaScoreStr = string.Format("{0}", userScore.Score);
}
BLLJIMP.Model.WBHScoreRecord srInfo = new BLLJIMP.Model.WBHScoreRecord()
{
InsertDate = DateTime.Now,
ScoreNum = deltaScoreStr,
WebsiteOwner = this.userInfo.WebsiteOwner,
UserId = this.UserID,
NameStr = userScore.RecordTypeString,
Nums = userScore.nums,
RecordType = userScore.RecordType,
};
if (this.Add(srInfo))
{
return(userScore.Score);
}
return(0);
}
/// <summary>
/// 删除
/// </summary>
private string Delete(HttpContext context)
{
string uids = context.Request["ids"];
string activityId = context.Request["ActivityID"];
if (bllActivity.Update(new ActivityDataInfo(), " IsDelete = 1 ", string.Format("UID in({0}) And ActivityID='{1}'", uids, activityId)) > 0)
{
foreach (var uid in uids.Split(','))//积分返还
{
ActivityDataInfo model = bllActivity.GetActivityDataInfo(activityId, int.Parse(uid));
JuActivityInfo juActivityInfo = bllJuActivity.GetJuActivityByActivityID(model.ActivityID);
if ((juActivityInfo != null) && (juActivityInfo.ActivityIntegral > 0))
{
UserInfo userInfo = bllUser.GetUserInfoByOpenId(model.WeixinOpenID);
if (userInfo != null)
{
userInfo.TotalScore += juActivityInfo.ActivityIntegral;
if (bllUser.Update(new UserInfo(), string.Format(" TotalScore={0}", userInfo.TotalScore), string.Format(" AutoID={0}", userInfo.AutoID)) > 0)
{
//积分记录
BLLJIMP.Model.WBHScoreRecord record = new BLLJIMP.Model.WBHScoreRecord()
{
InsertDate = DateTime.Now,
ScoreNum = "+" + juActivityInfo.ActivityIntegral.ToString(),
WebsiteOwner = bllUser.WebsiteOwner,
UserId = userInfo.UserID,
NameStr = "取消参加" + juActivityInfo.ActivityName,
Nums = "b55",
RecordType = "2",
};
bllUser.Add(record);
//积分记录
}
else
{
resp.Msg = "返还用户积分失败";
return(Common.JSONHelper.ObjectToJson(resp));
}
}
}
}
resp.Status = 1;
bllLog.Add(BLLJIMP.Enums.EnumLogType.Activity, BLLJIMP.Enums.EnumLogTypeAction.Delete, bllLog.GetCurrUserID(), "删除活动报名数据[报名id=" + uids + ",活动id=" + activityId + "]");
}
return(Common.JSONHelper.ObjectToJson(resp));
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string activityId = context.Request["activity_id"];
if (string.IsNullOrEmpty(activityId))
{
apiResp.code = 1;
apiResp.msg = "activity_id 为必填项,请检查";
bll.ContextResponse(context, apiResp);
return;
}
JuActivityInfo juInfo = bll.GetJuActivity(int.Parse(activityId), true);
if (juInfo == null)
{
apiResp.code = 4;
apiResp.msg = "活动不存在!";
bll.ContextResponse(context, apiResp);
return;
}
#region 是否可以报名
if (juInfo.ActivityStatus.Equals(1))
{
apiResp.code = 2;
apiResp.msg = "活动已停止";
bll.ContextResponse(context, apiResp);
return;
}
if (juInfo.MaxSignUpTotalCount > 0)//检查报名人数
{
if (juInfo.SignUpTotalCount > (juInfo.MaxSignUpTotalCount - 1))
{
apiResp.code = 3;
apiResp.msg = "报名人数已满";
bll.ContextResponse(context, apiResp);
return;
}
}
if (juInfo.ActivityIntegral > 0)
{
if (CurrentUserInfo.TotalScore < juInfo.ActivityIntegral)
{
apiResp.code = 4;
apiResp.msg = "您的积分不足";
bll.ContextResponse(context, apiResp);
return;
}
}
if (juInfo.GuaranteeCreditAcount > 0)
{
if (CurrentUserInfo.CreditAcount < juInfo.GuaranteeCreditAcount)
{
apiResp.code = 6;
apiResp.msg = "您的信用金不足";
bll.ContextResponse(context, apiResp);
return;
}
}
#endregion
dicPar = bll.GetRequestParameter();
//string weixinOpenID = null;
string activityIdBySignUp = juInfo.SignUpActivityID;
string spreadUserId = null;
dicPar.TryGetValue("SpreadUserID", out spreadUserId);
string strDistinctKeys = null;//检查重复的字段，多个字段用,分隔， //没有此参数默认用手机检查
dicPar.TryGetValue("DistinctKeys", out strDistinctKeys);
string monitorPlanID = null;
dicPar.TryGetValue("MonitorPlanID", out monitorPlanID);
string name = null;
dicPar.TryGetValue("Name", out name);
string phone = null;
dicPar.TryGetValue("Phone", out phone);
ActivityInfo activity = bll.Get <ActivityInfo>(string.Format("ActivityID='{0}'", activityIdBySignUp));
#region IP限制
//获取用户IP;
string userHostAddress = context.Request.UserHostAddress;
var count = DataCache.GetCache(userHostAddress);
if (count != null)
{
int newCount = int.Parse(count.ToString()) + 1;
DataCache.SetCache(userHostAddress, newCount);
int limitCount = 1000;
if (activity != null)
{
limitCount = activity.LimitCount;
}
if (newCount >= limitCount)
{
apiResp.code = 5;
apiResp.msg = "您的提交过于频繁，请稍后再试";
bll.ContextResponse(context, apiResp);
return;
}
}
else
{
DataCache.SetCache(userHostAddress, 1, DateTime.MaxValue, new TimeSpan(4, 0, 0));
}
#endregion
#region 活动权限验证
if (juInfo == null)
{
apiResp.code = 6;
apiResp.msg = "活动不存在!";
bll.ContextResponse(context, apiResp);
return;
}
if (juInfo.ActivityStatus.Equals(1))
{
apiResp.code = 7;
apiResp.msg = "活动已关闭!";
bll.ContextResponse(context, apiResp);
return;
}
if (activity.IsDelete.Equals(1))
{
apiResp.code = 8;
apiResp.msg = "活动已删除!";
bll.ContextResponse(context, apiResp);
return;
}
#endregion
#region 判断必填项
if (string.IsNullOrEmpty(name) || string.IsNullOrEmpty(phone))
{
apiResp.code = 9;
apiResp.msg = "姓名和手机不能为空!";
bll.ContextResponse(context, apiResp);
return;
}
if ((!phone.StartsWith("1")) || (!phone.Length.Equals(11)))
{
apiResp.code = 10;
apiResp.msg = "手机号码无效!";
bll.ContextResponse(context, apiResp);
return;
}
#endregion
#region 检查自定义必填项
List <ActivityFieldMappingInfo> listRequiredField = bll.GetList <ActivityFieldMappingInfo>(string.Format("ActivityID='{0}' And FieldIsNull=1", activity.ActivityID));
if (listRequiredField.Count > 0)
{
foreach (var requiredField in listRequiredField)
{
if (string.IsNullOrEmpty(dicPar.SingleOrDefault(p => p.Key.Equals(string.Format("K{0}", requiredField.ExFieldIndex))).Value))
{
apiResp.code = 11;
apiResp.msg = string.Format(" {0} 必填", requiredField.MappingName);
bll.ContextResponse(context, apiResp);
return;
}
}
}
#endregion
#region 检查数据格式
//检查数据格式
List <ActivityFieldMappingInfo> activityFieldMapping = bll.GetList <ActivityFieldMappingInfo>(string.Format("ActivityID='{0}'", activity.ActivityID));
foreach (var item in activityFieldMapping)
{
string value = dicPar.SingleOrDefault(p => p.Key.Equals(string.Format("K{0}", item.ExFieldIndex))).Value;
if (string.IsNullOrWhiteSpace(value))
{
continue;
}
//检查数据格式
if (item.FormatValiFunc == "email")//email检查
{
if (!ZentCloud.Common.ValidatorHelper.EmailLogicJudge(value))
{
apiResp.code = 12;
apiResp.msg = string.Format("{0}格式不正确", item.MappingName);
bll.ContextResponse(context, apiResp);
return;
}
}
if (item.FormatValiFunc == "url") //url检查
{
System.Text.RegularExpressions.Regex regUrl = new System.Text.RegularExpressions.Regex(@"http(s)?://([\w-]+\.)+[\w-]+(/[\w- ./?%&=]*)?"); //网址
System.Text.RegularExpressions.Match m = regUrl.Match(value);
if (!m.Success)
{
apiResp.code = 13;
apiResp.msg = string.Format("{0}格式不正确", item.MappingName);
bll.ContextResponse(context, apiResp);
return;
}
}
}
#endregion
#region 检查是否已经报名
if (!string.IsNullOrEmpty(strDistinctKeys))
{
if (!strDistinctKeys.Equals("none"))//自定义检查重复
{
System.Text.StringBuilder sb = new System.Text.StringBuilder("1=1 ");
string[] distinctKeys = strDistinctKeys.Split(',');
foreach (var item in distinctKeys)
{
sb.AppendFormat("And {0}='{1}' ", item, dicPar.Single(p => p.Key.Equals(item)).Value);
}
sb.Append(" and IsDelete = 0 ");
if (bll.GetCount <ActivityDataInfo>(sb.ToString()) > 0)
{
apiResp.code = 14;
apiResp.msg = "重复的报名!";
bll.ContextResponse(context, apiResp);
return;
}
}
else//不检查重复
{
}
}
else//默认检查
{
if (bll.GetCount <ActivityDataInfo>(string.Format("ActivityID='{0}' And Phone='{1}' and IsDelete = 0 ", activityIdBySignUp, phone)) > 0)
{
apiResp.code = 15;
apiResp.msg = "已经报过名了!";
bll.ContextResponse(context, apiResp);
return;
}
}
#endregion
var newActivityUID = 1001;
var lastActivityDataInfo = bll.Get <ActivityDataInfo>(string.Format("ActivityID='{0}' order by UID DESC", activityIdBySignUp));
if (lastActivityDataInfo != null)
{
newActivityUID = lastActivityDataInfo.UID + 1;
}
ActivityDataInfo model = bll.ConvertRequestToModel <ActivityDataInfo>(new ActivityDataInfo());
model.UID = newActivityUID;
model.SpreadUserID = spreadUserId;
model.ActivityID = activityIdBySignUp;
if (juInfo.GuaranteeCreditAcount > 0)
{
if (model.GuaranteeCreditAcount < juInfo.GuaranteeCreditAcount)
{
apiResp.code = 18;
apiResp.msg = string.Format("担保信用金不能少于{0}!", Convert.ToDouble(juInfo.GuaranteeCreditAcount));
bll.ContextResponse(context, apiResp);
return;
}
}
if (!string.IsNullOrEmpty(monitorPlanID))
{
model.MonitorPlanID = int.Parse(monitorPlanID);
}
model.WebsiteOwner = bll.WebsiteOwner;
model.UserId = CurrentUserInfo.UserID;
model.WeixinOpenID = CurrentUserInfo.WXOpenId;
if (context.Request["limit_userid_signupcount"] == "1")//限制每个登录账号只能报名一次
{
if (bll.GetCount <ActivityDataInfo>(string.Format(" UserId='{0}' AND ActivityID={1} AND IsDelete=0 "
, model.UserId, juInfo.SignUpActivityID)) > 0)
{
apiResp.code = 14;
apiResp.msg = "重复的报名!";
bll.ContextResponse(context, apiResp);
return;
}
}
if (context.Request["limit_wxopenid_signupcount"] == "1")//限制每个微信只能报名一次
{
if (bll.GetCount <ActivityDataInfo>(string.Format(" UserId='{0}' AND ActivityID={1} AND IsDelete=0 "
, model.WeixinOpenID, juInfo.SignUpActivityID)) > 0)
{
apiResp.code = 14;
apiResp.msg = "重复的报名!";
bll.ContextResponse(context, apiResp);
return;
}
}
model.ArticleType = juInfo.ArticleType;
model.CategoryId = juInfo.CategoryId;
if (bll.Add(model))
{
bll.PlusNumericalCol("SignUpCount", juInfo.JuActivityID);//报名数+1
//发消息给发布约会的人
PubUser = bllUser.GetUserInfo(juInfo.UserID);
if (PubUser != null && context.Request["notice_publisher"] == "1")
{
bllSystemNotice.SendSystemMessage("“" + bllUser.GetUserDispalyName(CurrentUserInfo) + "”报名您的约会", juInfo.ActivityName, BLLJIMP.BLLSystemNotice.NoticeType.AppointmentNotice, BLLJIMP.BLLSystemNotice.SendType.Personal, PubUser.UserID, juInfo.JuActivityID.ToString());
}
//发消息给自己
if (CurrentUserInfo != null && context.Request["notice_signupuser"] == "1")
{
bllSystemNotice.SendSystemMessage("你报名了一个约会冻结" + Convert.ToDouble(model.GuaranteeCreditAcount) + "信用金", juInfo.ActivityName, BLLJIMP.BLLSystemNotice.NoticeType.FinancialNotice, BLLJIMP.BLLSystemNotice.SendType.Personal, CurrentUserInfo.UserID, juInfo.JuActivityID.ToString());
}
apiResp.msg = "ok";
apiResp.code = 0;
apiResp.status = true;
#region 当ActivityIntegral>0 扣积分
if (juInfo.ActivityIntegral > 0)//扣积分
{
CurrentUserInfo.TotalScore -= juInfo.ActivityIntegral;
if (bll.Update(CurrentUserInfo, string.Format("TotalScore={0}", CurrentUserInfo.TotalScore), string.Format(" AutoID={0}", CurrentUserInfo.AutoID)) <= 0)
{
apiResp.code = 16;
apiResp.msg = "扣除用户积分失败";
bll.ContextResponse(context, apiResp);
return;
}
else
{
//
BLLJIMP.Model.WBHScoreRecord scoreRecord = new BLLJIMP.Model.WBHScoreRecord();
scoreRecord.Nums = "b55";
scoreRecord.InsertDate = DateTime.Now;
scoreRecord.WebsiteOwner = bll.WebsiteOwner;
scoreRecord.UserId = CurrentUserInfo.UserID;
scoreRecord.RecordType = "2";
scoreRecord.NameStr = "参加活动:" + juInfo.ActivityName;
scoreRecord.ScoreNum = string.Format("-{0}", juInfo.ActivityIntegral);
if (!bll.Add(scoreRecord))
{
apiResp.code = 17;
apiResp.msg = "插入积分记录失败";
bll.ContextResponse(context, apiResp);
return;
}
}
}
#endregion
#region 当ActivityIntegral>0 扣信用金
if (juInfo.GuaranteeCreditAcount > 0)//扣积分
{
bllUser.AddUserCreditAcountDetails(CurrentUserInfo.UserID, "ApplyCost", bllUser.WebsiteOwner, 0 - model.GuaranteeCreditAcount
, string.Format("报名【{0}】消耗{1}信用金", juInfo.ActivityName, Convert.ToDouble(model.GuaranteeCreditAcount)));
}
#endregion
}
else
{
apiResp.code = 1;
apiResp.msg = "报名失败，请重试或联系管理员!";
}
bll.ContextResponse(context, apiResp);
}
