/// <summary> /// 更新一条数据 /// </summary> public void Update(Book.Model.Favorites model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Favorites set "); strSql.Append("types=@types,"); strSql.Append("title=@title,"); strSql.Append("nid=@nid,"); strSql.Append("sid=@sid,"); strSql.Append("purl=@purl,"); strSql.Append("usid=@usid,"); strSql.Append("addtime=@addtime"); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@types", SqlDbType.Int, 4), new SqlParameter("@title", SqlDbType.NVarChar, 50), new SqlParameter("@nid", SqlDbType.Int, 4), new SqlParameter("@sid", SqlDbType.Int, 4), new SqlParameter("@purl", SqlDbType.NVarChar, 200), new SqlParameter("@usid", SqlDbType.Int, 4), new SqlParameter("@addtime", SqlDbType.DateTime) }; parameters[0].Value = model.id; parameters[1].Value = model.types; parameters[2].Value = model.title; parameters[3].Value = model.nid; parameters[4].Value = model.sid; parameters[5].Value = model.purl; parameters[6].Value = model.usid; parameters[7].Value = model.addtime; SqlHelperBook.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 删除一组数据 /// </summary> public void Delete(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from Favorites "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } SqlHelperBook.ExecuteSql(strSql.ToString()); }
/// <summary> /// 删除一条数据 /// </summary> public void Delete(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from Navigation "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; SqlHelperBook.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Book.Model.ShuMu model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ShuMu set "); strSql.Append("nid=@nid,"); strSql.Append("title=@title,"); strSql.Append("summary=@summary,"); strSql.Append("img=@img,"); strSql.Append("aid=@aid,"); strSql.Append("author=@author,"); strSql.Append("addtime=@addtime,"); strSql.Append("state=@state,"); strSql.Append("tags=@tags,"); strSql.Append("types=@types,"); strSql.Append("length=@length,"); strSql.Append("isover=@isover"); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@nid", SqlDbType.Int, 4), new SqlParameter("@title", SqlDbType.VarChar, 200), new SqlParameter("@summary", SqlDbType.VarChar, 500), new SqlParameter("@img", SqlDbType.VarChar, 200), new SqlParameter("@aid", SqlDbType.Int, 4), new SqlParameter("@author", SqlDbType.VarChar, 50), new SqlParameter("@addtime", SqlDbType.DateTime), new SqlParameter("@state", SqlDbType.Int, 4), new SqlParameter("@tags", SqlDbType.VarChar, 100), new SqlParameter("@types", SqlDbType.TinyInt, 1), new SqlParameter("@length", SqlDbType.Int, 4), new SqlParameter("@isover", SqlDbType.TinyInt, 1) }; parameters[0].Value = model.id; parameters[1].Value = model.nid; parameters[2].Value = model.title; parameters[3].Value = model.summary; parameters[4].Value = model.img; parameters[5].Value = model.aid; parameters[6].Value = model.author; parameters[7].Value = model.addtime; parameters[8].Value = model.state; parameters[9].Value = model.tags; parameters[10].Value = model.types; parameters[11].Value = model.length; parameters[12].Value = model.isover; SqlHelperBook.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 增加人气 /// </summary> public void UpdateClick(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ShuMu set "); strSql.Append("click=click+1"); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; SqlHelperBook.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 写入书评数目 /// </summary> public void Updatepl(int id, int pl) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ShuMu set "); strSql.Append("pl=pl+@pl"); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@pl", SqlDbType.Int, 4) }; parameters[0].Value = id; parameters[1].Value = pl; SqlHelperBook.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 写入更新时间 /// </summary> public void Updategxtime(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ShuMu set "); strSql.Append("gxtime=@gxtime"); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@gxtime", SqlDbType.DateTime) }; parameters[0].Value = id; parameters[1].Value = DateTime.Now; SqlHelperBook.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 审核书本 /// </summary> public void Updatestate(int id, int state) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ShuMu set "); strSql.Append("state=@state"); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@state", SqlDbType.Int, 4) }; parameters[0].Value = id; parameters[1].Value = state; SqlHelperBook.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 写入提醒ID /// </summary> public void Updategxids(int aid, string gxids) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ShuSelf set "); strSql.Append("gxids=@gxids"); strSql.Append(" where aid=@aid "); SqlParameter[] parameters = { new SqlParameter("@aid", SqlDbType.Int, 4), new SqlParameter("@gxids", SqlDbType.NText) }; parameters[0].Value = aid; parameters[1].Value = gxids; SqlHelperBook.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 更新默认字数 /// </summary> public void UpdatePageNum(int aid, int pagenum) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ShuSelf set "); strSql.Append("pagenum=@pagenum"); strSql.Append(" where aid=@aid "); SqlParameter[] parameters = { new SqlParameter("@aid", SqlDbType.Int, 4), new SqlParameter("@pagenum", SqlDbType.Int, 4) }; parameters[0].Value = aid; parameters[1].Value = pagenum; SqlHelperBook.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 恢复和删除 /// </summary> public void Updateisdel(int id, int isdel) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Contents set "); strSql.Append("isdel=@isdel"); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@isdel", SqlDbType.Int, 4) }; parameters[0].Value = id; parameters[1].Value = isdel; SqlHelperBook.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Book.Model.Contents model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Contents set "); strSql.Append("shi=@shi,"); strSql.Append("title=@title,"); strSql.Append("summary=@summary,"); strSql.Append("contents=@contents,"); strSql.Append("addtime=@addtime,"); strSql.Append("state=@state,"); strSql.Append("jid=@jid,"); strSql.Append("tags=@tags,"); strSql.Append("aid=@aid,"); strSql.Append("pid=@pid"); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@shi", SqlDbType.Int, 4), new SqlParameter("@title", SqlDbType.VarChar, 255), new SqlParameter("@summary", SqlDbType.VarChar, 500), new SqlParameter("@contents", SqlDbType.Text), new SqlParameter("@addtime", SqlDbType.DateTime), new SqlParameter("@state", SqlDbType.Int, 4), new SqlParameter("@jid", SqlDbType.Int, 4), new SqlParameter("@tags", SqlDbType.VarChar, 100), new SqlParameter("@aid", SqlDbType.Int, 4), new SqlParameter("@pid", SqlDbType.Int, 4) }; parameters[0].Value = model.id; parameters[1].Value = model.shi; parameters[2].Value = model.title; parameters[3].Value = model.summary; parameters[4].Value = model.contents; parameters[5].Value = model.addtime; parameters[6].Value = model.state; parameters[7].Value = model.jid; parameters[8].Value = model.tags; parameters[9].Value = model.aid; parameters[10].Value = model.pid; SqlHelperBook.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 删除一组数据 /// </summary> public void Delete(string strWhere) { StringBuilder strSql = new StringBuilder(); if (Utils.getPageAll().ToLower().Contains("book/")) { strSql.Append("update Contents set isdel=1"); } else { strSql.Append("delete from Contents "); } if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } SqlHelperBook.ExecuteSql(strSql.ToString()); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Book.Model.Navigation model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Navigation set "); strSql.Append("pid=@pid,"); strSql.Append("Name=@Name"); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@pid", SqlDbType.Int, 4), new SqlParameter("@Name", SqlDbType.VarChar, 50) }; parameters[0].Value = model.id; parameters[1].Value = model.pid; parameters[2].Value = model.Name; SqlHelperBook.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Book.Model.ShuFav model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ShuFav set "); strSql.Append("name=@name,"); strSql.Append("usid=@usid"); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@name", SqlDbType.NVarChar, 50), new SqlParameter("@usid", SqlDbType.Int, 4) }; parameters[0].Value = model.id; parameters[1].Value = model.name; parameters[2].Value = model.usid; SqlHelperBook.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 删除一条数据 /// </summary> public void Delete(int id) { StringBuilder strSql = new StringBuilder(); if (Utils.getPageAll().ToLower().Contains("book/")) { strSql.Append("update Contents set isdel=1"); } else { strSql.Append("delete from Contents "); } strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; SqlHelperBook.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Book.Model.ShuSelf model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ShuSelf set "); strSql.Append("name=@name,"); strSql.Append("sex=@sex,"); strSql.Append("city=@city"); strSql.Append(" where aid=@aid "); SqlParameter[] parameters = { new SqlParameter("@aid", SqlDbType.Int, 4), new SqlParameter("@name", SqlDbType.NVarChar, 50), new SqlParameter("@sex", SqlDbType.NVarChar, 50), new SqlParameter("@city", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.aid; parameters[1].Value = model.name; parameters[2].Value = model.sex; parameters[3].Value = model.city; SqlHelperBook.ExecuteSql(strSql.ToString(), parameters); }