/// <summary> /// 增加一条数据 /// </summary> /// <param name="model">Model.user_sign</param> /// <returns>ID</returns> public int Add(Model.user_sign model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [" + databaseprefix + "user_sign]("); strSql.Append("user_id,time,day"); strSql.Append(") values("); strSql.Append("@user_id,@time,@day)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@user_id", SqlDbType.Int, 4), new SqlParameter("@time", SqlDbType.DateTime), new SqlParameter("@day", SqlDbType.Int, 4) }; parameters[0].Value = model.user_id; parameters[1].Value = model.time; parameters[2].Value = model.day; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (null != obj) { return(Convert.ToInt32(obj)); } else { return(0); } }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">Model.user_sign</param> /// <returns>True or False</returns> public bool Update(Model.user_sign model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update [" + databaseprefix + "user_sign] set "); strSql.Append("user_id=@user_id,"); strSql.Append("time=@time,"); strSql.Append("day=@day"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@user_id", SqlDbType.Int, 4), new SqlParameter("@time", SqlDbType.DateTime), new SqlParameter("@day", SqlDbType.Int, 4), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.user_id; parameters[1].Value = model.time; parameters[2].Value = model.day; parameters[3].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } return(false); }
/// <summary> /// 组合成对象实体 /// </summary> /// <param name="row">一行数据</param> /// <returns>Model.user_sign</returns> private Model.user_sign DataRowToModel(DataRow row) { Model.user_sign model = new Model.user_sign(); if (row != null) { if (null != row["id"] && "" != row["id"].ToString()) { model.id = int.Parse(row["id"].ToString()); } if (null != row["user_id"] && "" != row["user_id"].ToString()) { model.user_id = int.Parse(row["user_id"].ToString()); } if (null != row["time"] && "" != row["time"].ToString()) { model.time = DateTime.Parse(row["time"].ToString()); } if (null != row["day"] && "" != row["day"].ToString()) { model.day = int.Parse(row["day"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">Model.user_sign</param> /// <returns>True Or False</returns> public bool Update(Model.user_sign model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="model">Model.user_sign</param> /// <returns>ID</returns> public int Add(Model.user_sign model) { return(dal.Add(model)); }
/// <summary> /// 积分记录 /// </summary> /// <param name="context"></param> private void point_log(HttpContext context) { //type:1签到,2发表评论,3每天分享3个50人以上群或分享资讯到朋友圈,4联系产品经理 int type = DTRequest.GetInt("type", 0); int uid = DTRequest.GetInt("uid", 0); int val = DTRequest.GetInt("val", 0); string remark = DTRequest.GetString("remark"); Model.point model = new Model.point(); model.user_id = uid; //model.value = val; //model.remark = remark; model.add_time = DateTime.Now; switch (type) { case 1: //签到 #region 签到 if (new BLL.user_sign().GetCount("user_id=" + uid + " and DateDiff(dd,time,getdate())=0") == 0) { model.value = 5; //每日签到5点积分 DataTable dt = new BLL.user_sign().GetList(0, "user_id=" + uid + " and DateDiff(dd,time,getdate())=1", "").Tables[0]; Model.user_sign sign = new Model.user_sign(); sign.user_id = uid; sign.time = DateTime.Now; if (new BLL.user_sign().GetCount("user_id=" + uid + " and DateDiff(dd,time,getdate())=1") > 0) { int day = Convert.ToInt32(dt.Rows[0]["day"]) + 1; sign.day = day; model.remark = "连续签到第" + day + "天"; if (day == 10 || day == 30) { //连续签到10天或30天送红包 Model.amount amount = new Model.amount(); amount.user_id = uid; amount.type = 1; amount.remark = "连续签到"; amount.time = DateTime.Now; if (day == 10 && new BLL.amount().GetCount("user_id=" + uid + " and type=1 and amount=0.88") == 0) { amount.Amount = 0.88M; } if (day == 10 && new BLL.amount().GetCount("user_id=" + uid + " and type=1 and amount=1.88") == 0) { amount.Amount = 1.88M; } new BLL.amount().Add(amount); new BLL.user().UpdateField(uid, "amount=amount+" + amount.Amount); } } else { sign.day = 1; model.remark = "连续签到第1天"; } new BLL.user_sign().Add(sign); new BLL.point().Add(model); context.Response.Write("{\"status\":1,\"msg\":\"" + model.remark + ",签到成功!\"}"); } else { context.Response.Write("{\"status\":1,\"msg\":\"今天已经签到过了!\"}"); return; } #endregion break; case 2: //发表评论 #region 评论 int isPN = DTRequest.GetInt("isPN", 0); int nid = DTRequest.GetInt("nid", 0); if (new BLL.news_commend().GetCount("user_id=" + uid + " and isPN=" + isPN + " and news_id=" + nid) > 1) { context.Response.Write("{\"status\":1,\"msg\":\"已经评论过,无法重复获得积分!\"}"); return; } else { model.value = 5; model.remark = "发表评论"; new BLL.point().Add(model); context.Response.Write("{\"status\":1,\"msg\":\"评论成功获得积分!\"}"); } #endregion break; case 3: //分享 break; case 4: //联系产品经理 break; } new BLL.user().UpdateField(uid, "point=point+" + model.value); }