/// <summary>
/// 增加一条数据
/// </summary>
public int Add(UserGoodEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into sns_userGood(");
strSql.Append("User_id,WorkId,Status)");
strSql.Append(" values (");
strSql.Append("@User_id,@WorkId,@Status)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@User_id", SqlDbType.VarChar, 50),
new SqlParameter("@WorkId", SqlDbType.VarChar, 50),
new SqlParameter("@Status", SqlDbType.Int, 4)
};
parameters[0].Value = model.User_id;
parameters[1].Value = model.WorkId;
parameters[2].Value = model.Status;
object obj = SqlHelper.Instance.ExecSqlScalar(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(UserGoodEntity model)
{
try
{
return(UserGoodDb.Instance.Add(model));
}
catch (Exception ex)
{
WriteLog.WriteError(ex);
throw ex;
}
}
public void ProcessRequest(HttpContext context)
{
string workId = context.Request.Form["WorksId"];
string userId = context.Request.Form["UserId"];
int i;
bool b = UserGoodBll.Instance.ExistsByUserId(userId, workId);
if (b)
{
i = 0; //已赞
}
else
{
//记录点赞表
UserGoodEntity userGoodEntity = new UserGoodEntity();
userGoodEntity.User_id = userId;
userGoodEntity.WorkId = workId;
userGoodEntity.Status = 1;
i = UserGoodBll.Instance.Add(userGoodEntity);
if (i > 0)
{
//记录积分变更表
IntegralChangeEntity integralChangeEntity = new IntegralChangeEntity();
integralChangeEntity.UserId = userId;
integralChangeEntity.source = "clickLike";
integralChangeEntity.Cnbi = "0";
integralChangeEntity.integral = 1;
integralChangeEntity.ardent = 1;
integralChangeEntity.Growth = 1;
integralChangeEntity.AddTime = DateTime.Now;
integralChangeEntity.Status = 1;
IntegralChangeBll.Instance.Add(integralChangeEntity);
//更新帖子
WorksBll.Instance.UpdateIntegral(workId, "GoodNo", "1");
//更新会员表
MemberBll.Instance.UpdateIntegral(userId, "integral", "1");
MemberBll.Instance.UpdateIntegral(userId, "ardent", "1");
MemberBll.Instance.UpdateIntegral(userId, "Growth", "1");
}
}
context.Response.ContentType = "text/plain";
context.Response.Charset = "utf-8";
context.Response.Write(i);
}
