/// <summary> /// 增加一条数据 /// </summary> /// <param name="model">Model.news_view</param> /// <returns>ID</returns> public int Add(Model.news_view model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [" + databaseprefix + "news_view]("); strSql.Append("user_id,ispn,type,news_id,time"); strSql.Append(") values("); strSql.Append("@user_id,@ispn,@type,@news_id,@time)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@user_id", SqlDbType.Int, 4), new SqlParameter("@ispn", SqlDbType.Int, 4), new SqlParameter("@type", SqlDbType.Int, 4), new SqlParameter("@news_id", SqlDbType.Int, 4), new SqlParameter("@time", SqlDbType.DateTime) }; parameters[0].Value = model.user_id; parameters[1].Value = model.ispn; parameters[2].Value = model.type; parameters[3].Value = model.news_id; parameters[4].Value = model.time; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (null != obj) { return(Convert.ToInt32(obj)); } else { return(0); } }
/// <summary> /// 组合成对象实体 /// </summary> /// <param name="row">一行数据</param> /// <returns>Model.news_view</returns> private Model.news_view DataRowToModel(DataRow row) { Model.news_view model = new Model.news_view(); 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["ispn"] && "" != row["ispn"].ToString()) { model.ispn = int.Parse(row["ispn"].ToString()); } if (null != row["type"] && "" != row["type"].ToString()) { model.type = int.Parse(row["type"].ToString()); } if (null != row["news_id"] && "" != row["news_id"].ToString()) { model.news_id = int.Parse(row["news_id"].ToString()); } if (null != row["time"] && "" != row["time"].ToString()) { model.time = DateTime.Parse(row["time"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">Model.news_view</param> /// <returns>True or False</returns> public bool Update(Model.news_view model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update [" + databaseprefix + "news_view] set "); strSql.Append("user_id=@user_id,"); strSql.Append("ispn=@ispn,"); strSql.Append("type=@type,"); strSql.Append("news_id=@news_id,"); strSql.Append("time=@time"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@user_id", SqlDbType.Int, 4), new SqlParameter("@ispn", SqlDbType.Int, 4), new SqlParameter("@type", SqlDbType.Int, 4), new SqlParameter("@news_id", SqlDbType.Int, 4), new SqlParameter("@time", SqlDbType.DateTime), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.user_id; parameters[1].Value = model.ispn; parameters[2].Value = model.type; parameters[3].Value = model.news_id; parameters[4].Value = model.time; parameters[5].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } return(false); }
//取消收藏处理 private string news_collect_cancel(Model.news_view model) { int id = Convert.ToInt32(new BLL.news_view().GetList(0, "user_id=" + model.user_id + " and isPN=" + model.ispn + " and type=" + model.type, "").Tables[0].Rows[0]["id"]); if (new BLL.news_view().Delete(id)) { return("{\"status\":1,\"msg\":\"取消收藏成功\"}"); } else { return("{\"status\":0}"); } }
//更新浏览记录处理 private string news_view_update(Model.news_view model) { int id = Convert.ToInt32(new BLL.news_view().GetList(0, "user_id=" + model.user_id + " and isPN=" + model.ispn + " and type=" + model.type, "").Tables[0].Rows[0]["id"]); model.id = id; if (new BLL.news_view().Update(model)) { return("{\"status\":1,\"msg\":\"更新浏览时间\"}"); } else { return("{\"status\":0}"); } }
private void news_view(HttpContext context) { int uid = DTRequest.GetInt("uid", 0); int isPN = DTRequest.GetInt("isPN", 0); int type = DTRequest.GetInt("type", 0); int newsId = DTRequest.GetInt("id", 0); Model.news_view model = new Model.news_view(); model.user_id = uid; model.ispn = isPN; model.type = type; model.news_id = newsId; model.time = DateTime.Now; if (uid == 0 || new BLL.news_view().GetCount("user_id=" + uid + " and isPN=" + isPN + " and type=" + type + " and news_id=" + newsId) == 0) { new BLL.news_view().Add(model); if (model.type == 2) { context.Response.Write("{\"status\":1,\"msg\":\"收藏成功!\"}"); } else { context.Response.Write("{\"status\":1,\"msg\":\"浏览量+1\"}"); } } else {//更新浏览时间,取消收藏 if (type == 1) { context.Response.Write(news_view_update(model)); } else { context.Response.Write(news_collect_cancel(model)); } } }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">Model.news_view</param> /// <returns>True Or False</returns> public bool Update(Model.news_view model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="model">Model.news_view</param> /// <returns>ID</returns> public int Add(Model.news_view model) { return(dal.Add(model)); }