private void post_news_commend(HttpContext context) { int uid = DTRequest.GetInt("uid", 0); string name = DTRequest.GetString("name"); string avatar = DTRequest.GetString("avatar"); int isPN = DTRequest.GetInt("isPN", 0); int news_id = DTRequest.GetInt("news_id", 0); string cont = DTRequest.GetString("cont"); Model.news_commend model = new Model.news_commend(); model.user_id = uid; model.name = name; model.avatar = avatar; model.ispn = isPN; model.news_id = news_id; model.ishide = 0; model.time = DateTime.Now; model.cont = cont; if (isPN == 1 && new BLL.user().GetCount("id=" + uid + " and phone!=''") == 0) {//判断为产品,需要填写手机号 context.Response.Write("{\"status\":0,\"msg\":\"请先在个人信息中补充联系电话!\"}"); return; } if (new BLL.news_commend().Add(model) > 0) { context.Response.Write("{\"status\":1,\"msg\":\"提交成功!\"}"); } else { context.Response.Write("{\"status\":0,\"msg\":\"提交失败!\"}"); } }
/// <summary> /// 组合成对象实体 /// </summary> /// <param name="row">一行数据</param> /// <returns>Model.news_commend</returns> private Model.news_commend DataRowToModel(DataRow row) { Model.news_commend model = new Model.news_commend(); 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["name"]) { model.name = row["name"].ToString(); } if (null != row["avatar"]) { model.avatar = row["avatar"].ToString(); } if (null != row["cont"]) { model.cont = row["cont"].ToString(); } if (null != row["ispn"] && "" != row["ispn"].ToString()) { model.ispn = int.Parse(row["ispn"].ToString()); } if (null != row["news_id"] && "" != row["news_id"].ToString()) { model.news_id = int.Parse(row["news_id"].ToString()); } if (null != row["ishide"] && "" != row["ishide"].ToString()) { model.ishide = int.Parse(row["ishide"].ToString()); } if (null != row["time"] && "" != row["time"].ToString()) { model.time = DateTime.Parse(row["time"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">Model.news_commend</param> /// <returns>True or False</returns> public bool Update(Model.news_commend model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update [" + databaseprefix + "news_commend] set "); strSql.Append("user_id=@user_id,"); strSql.Append("name=@name,"); strSql.Append("avatar=@avatar,"); strSql.Append("cont=@cont,"); strSql.Append("ispn=@ispn,"); strSql.Append("news_id=@news_id,"); strSql.Append("ishide=@ishide,"); strSql.Append("time=@time"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@user_id", SqlDbType.Int, 4), new SqlParameter("@name", SqlDbType.NVarChar, 100), new SqlParameter("@avatar", SqlDbType.NVarChar, 200), new SqlParameter("@cont", SqlDbType.NText), new SqlParameter("@ispn", SqlDbType.Int, 4), new SqlParameter("@news_id", SqlDbType.Int, 4), new SqlParameter("@ishide", SqlDbType.Int, 4), new SqlParameter("@time", SqlDbType.DateTime), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.user_id; parameters[1].Value = model.name; parameters[2].Value = model.avatar; parameters[3].Value = model.cont; parameters[4].Value = model.ispn; parameters[5].Value = model.news_id; parameters[6].Value = model.ishide; parameters[7].Value = model.time; parameters[8].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } return(false); }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="model">Model.news_commend</param> /// <returns>ID</returns> public int Add(Model.news_commend model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [" + databaseprefix + "news_commend]("); strSql.Append("user_id,name,avatar,cont,ispn,news_id,ishide,time"); strSql.Append(") values("); strSql.Append("@user_id,@name,@avatar,@cont,@ispn,@news_id,@ishide,@time)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@user_id", SqlDbType.Int, 4), new SqlParameter("@name", SqlDbType.NVarChar, 100), new SqlParameter("@avatar", SqlDbType.NVarChar, 200), new SqlParameter("@cont", SqlDbType.NText), new SqlParameter("@ispn", SqlDbType.Int, 4), new SqlParameter("@news_id", SqlDbType.Int, 4), new SqlParameter("@ishide", SqlDbType.Int, 4), new SqlParameter("@time", SqlDbType.DateTime) }; parameters[0].Value = model.user_id; parameters[1].Value = model.name; parameters[2].Value = model.avatar; parameters[3].Value = model.cont; parameters[4].Value = model.ispn; parameters[5].Value = model.news_id; parameters[6].Value = model.ishide; parameters[7].Value = model.time; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (null != obj) { return(Convert.ToInt32(obj)); } else { return(0); } }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="model">Model.news_commend</param> /// <returns>ID</returns> public int Add(Model.news_commend model) { return(dal.Add(model)); }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">Model.news_commend</param> /// <returns>True Or False</returns> public bool Update(Model.news_commend model) { return(dal.Update(model)); }