/// <summary> /// 增加一条数据 /// </summary> public int Add(Book.Model.Navigation model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Navigation("); strSql.Append("pid,Name)"); strSql.Append(" values ("); strSql.Append("@pid,@Name)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@pid", SqlDbType.Int, 4), new SqlParameter("@Name", SqlDbType.VarChar, 50) }; parameters[0].Value = model.pid; parameters[1].Value = model.Name; object obj = SqlHelperBook.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Book.Model.ShuSelf model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ShuSelf("); strSql.Append("aid,name,sex,city,addtime)"); strSql.Append(" values ("); strSql.Append("@aid,@name,@sex,@city,@addtime)"); strSql.Append(";select @@IDENTITY"); 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), new SqlParameter("@addtime", SqlDbType.DateTime) }; parameters[0].Value = model.aid; parameters[1].Value = model.name; parameters[2].Value = model.sex; parameters[3].Value = model.city; parameters[4].Value = DateTime.Now; object obj = SqlHelperBook.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 计算未审核的章节数量 /// </summary> public int GetCount(int shi) { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT Count(ID) from Contents"); strSql.Append(" where "); if (shi > 0) { strSql.Append(" shi=" + shi + " and "); } strSql.Append(" state=@state and isdel=0"); SqlParameter[] parameters = { new SqlParameter("@state", SqlDbType.Int, 4) }; parameters[0].Value = 0; object obj = SqlHelperBook.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Book.Model.ShuFav model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ShuFav("); strSql.Append("name,usid)"); strSql.Append(" values ("); strSql.Append("@name,@usid)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@name", SqlDbType.NVarChar, 50), new SqlParameter("@usid", SqlDbType.Int, 4) }; parameters[0].Value = model.name; parameters[1].Value = model.usid; object obj = SqlHelperBook.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Book.Model.ShuMu model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ShuMu("); strSql.Append("nid,title,summary,img,aid,author,addtime,state,tags,types,length,click,good,gxtime,isover,isgood)"); strSql.Append(" values ("); strSql.Append("@nid,@title,@summary,@img,@aid,@author,@addtime,@state,@tags,@types,@length,@click,@good,@gxtime,@isover,@isgood)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { 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("@click", SqlDbType.Int, 4), new SqlParameter("@good", SqlDbType.Int, 4), new SqlParameter("@gxtime", SqlDbType.DateTime), new SqlParameter("@isover", SqlDbType.TinyInt, 1), new SqlParameter("@isgood", SqlDbType.TinyInt, 1) }; parameters[0].Value = model.nid; parameters[1].Value = model.title; parameters[2].Value = model.summary; parameters[3].Value = model.img; parameters[4].Value = model.aid; parameters[5].Value = model.author; parameters[6].Value = model.addtime; parameters[7].Value = model.state; parameters[8].Value = model.tags; parameters[9].Value = model.types; parameters[10].Value = model.length; parameters[11].Value = 0; parameters[12].Value = 0; parameters[13].Value = DateTime.Now; parameters[14].Value = 0; parameters[15].Value = model.isgood; object obj = SqlHelperBook.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 计算某用户收藏数量 /// </summary> public int GetCount(int usid, int types) { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT Count(ID) from Favorites"); strSql.Append(" where types=" + types + ""); strSql.Append(" and usid=" + usid + ""); object obj = SqlHelperBook.GetSingle(strSql.ToString()); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Book.Model.Contents model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Contents("); strSql.Append("shi,title,summary,contents,addtime,state,jid,tags,aid,pid)"); strSql.Append(" values ("); strSql.Append("@shi,@title,@summary,@contents,@addtime,@state,@jid,@tags,@aid,@pid)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { 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.shi; parameters[1].Value = model.title; parameters[2].Value = model.summary; parameters[3].Value = model.contents; parameters[4].Value = model.addtime; parameters[5].Value = model.state; parameters[6].Value = model.jid; parameters[7].Value = model.tags; parameters[8].Value = model.aid; parameters[9].Value = model.pid; object obj = SqlHelperBook.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 计算某书本章节或分卷数量types(0单节/1分卷) /// </summary> public int GetCount(int shi, int jid, int types) { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT Count(ID) from Contents"); strSql.Append(" where "); strSql.Append(" shi=@shi and "); if (jid > 0) { strSql.Append(" jid=" + jid + " "); } else { if (types == 0) { strSql.Append(" jid<>-1 "); } else { strSql.Append(" jid=-1 "); } } SqlParameter[] parameters = { new SqlParameter("@shi", SqlDbType.Int, 4) }; parameters[0].Value = shi; object obj = SqlHelperBook.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Book.Model.Favorites model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Favorites("); strSql.Append("favid,types,title,nid,sid,purl,usid,addtime)"); strSql.Append(" values ("); strSql.Append("@favid,@types,@title,@nid,@sid,@purl,@usid,@addtime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@favid", 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.favid; 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; object obj = SqlHelperBook.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 计算某用户书架数量 /// </summary> public int GetCount(int UsID) { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT Count(ID) from ShuFav"); strSql.Append(" where UsID=@UsID "); SqlParameter[] parameters = { new SqlParameter("@UsID", SqlDbType.Int, 4) }; parameters[0].Value = UsID; object obj = SqlHelperBook.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }