private void EditLink() { ClassLibrary.Model.InternalLink linksModel = new ClassLibrary.Model.InternalLink(); linksModel.ID = newsId; if (string.IsNullOrEmpty(Request.Form["Title"])) { Response.Write("<script>alert('请输入标题!');history.back(-1);</script>"); return; } else { linksModel.Title = Request.Form["Title"]; } linksModel.LinkURL = Request.Form["LinkURL"]; if (linksBLL.Update(linksModel) > 0) { Function.goMessagePage("修改友情链接", "操作成功", "Links/InternalLinkList.aspx"); } else { Function.goMessagePage("修改友情链接", "操作失败,请稍后再试", "Links/InternalLinkList.aspx"); } }
/// <summary> /// 得到一个对象实体 /// </summary> /// <param name="ID">主键ID</param> /// <returns>Links对象</returns> public ClassLibrary.Model.InternalLink GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT ID,Title,LinkURL"); strSql.Append(" FROM "); strSql.Append(table); strSql.Append(string.Format(" WHERE {0}=@{0}", pk)); SqlParameter[] parameters = { new SqlParameter("@" + pk, SqlDbType.Int, 4) }; parameters[0].Value = ID; ClassLibrary.Model.InternalLink model = new ClassLibrary.Model.InternalLink(); DataTable dt = SQLHelper.Query(strSql.ToString(), parameters); model.ID = ID; if (dt.Rows.Count > 0) { if (dt.Rows[0]["Title"] != DBNull.Value) { model.Title = Convert.ToString(dt.Rows[0]["Title"]); } if (dt.Rows[0]["LinkURL"] != DBNull.Value) { model.LinkURL = Convert.ToString(dt.Rows[0]["LinkURL"]); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="model">Links对象</param> public int Add(ClassLibrary.Model.InternalLink model) { StringBuilder strSql = new StringBuilder(); strSql.Append(string.Format("INSERT INTO {0}(", table)); strSql.Append("Title,LinkURL"); strSql.Append(") VALUES ("); strSql.Append("@Title,@LinkURL)"); SqlParameter[] parameters = { new SqlParameter("@Title", SqlDbType.NVarChar, 100), new SqlParameter("@LinkURL", SqlDbType.NVarChar, 500) }; parameters[0].Value = model.Title; parameters[1].Value = model.LinkURL; return(SQLHelper.Execute(strSql.ToString(), parameters)); }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">Links对象</param> /// <returns>影响行数</returns> public int Update(ClassLibrary.Model.InternalLink model) { StringBuilder strSql = new StringBuilder(); strSql.Append(string.Format("UPDATE {0} SET ", table)); strSql.Append("Title=@Title,"); strSql.Append("LinkURL=@LinkURL"); strSql.Append(" WHERE ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@Title", SqlDbType.NVarChar, 100), new SqlParameter("@LinkURL", SqlDbType.NVarChar, 500) }; parameters[0].Value = model.ID; parameters[1].Value = model.Title; parameters[2].Value = model.LinkURL; return(SQLHelper.Execute(strSql.ToString(), parameters)); }