/// <summary> /// 得到书卷名称 /// </summary> public string GetTitle(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 title from Contents "); strSql.Append(" where id=@id and jid=0"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; using (SqlDataReader reader = SqlHelperBook.ExecuteReader(strSql.ToString(), parameters)) { if (reader.HasRows) { reader.Read(); return(reader.GetString(0)); } else { return(""); } } }
/// <summary> /// 得到一个对象实体 /// </summary> public Book.Model.Navigation GetNavigation(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,pid,Name from Navigation "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Book.Model.Navigation model = new Book.Model.Navigation(); using (SqlDataReader reader = SqlHelperBook.ExecuteReader(strSql.ToString(), parameters)) { if (reader.HasRows) { reader.Read(); model.id = reader.GetInt32(0); model.pid = reader.GetInt32(1); model.Name = reader.GetString(2); return(model); } else { return(null); } } }
/// <summary> /// 得到提醒的书本ID /// </summary> public string Getgxids(int aid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 gxids from ShuSelf "); strSql.Append(" where aid=@aid"); SqlParameter[] parameters = { new SqlParameter("@aid", SqlDbType.Int, 4) }; parameters[0].Value = aid; using (SqlDataReader reader = SqlHelperBook.ExecuteReader(strSql.ToString(), parameters)) { if (reader.HasRows) { reader.Read(); if (!reader.IsDBNull(0)) { return(reader.GetString(0)); } else { return(""); } } else { return(""); } } }
/// <summary> /// 得到默认字数 /// </summary> public int GetPageNum(int aid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 pagenum from ShuSelf "); strSql.Append(" where aid=@aid "); SqlParameter[] parameters = { new SqlParameter("@aid", SqlDbType.Int, 4) }; parameters[0].Value = aid; using (SqlDataReader reader = SqlHelperBook.ExecuteReader(strSql.ToString(), parameters)) { if (reader.HasRows) { reader.Read(); return(reader.GetInt32(0)); } else { return(0); } } }
/// <summary> /// 得到一个对象实体 /// </summary> public Book.Model.Favorites GetFavorites(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,favid,types,title,nid,sid,purl,usid,addtime from Favorites "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Book.Model.Favorites model = new Book.Model.Favorites(); using (SqlDataReader reader = SqlHelperBook.ExecuteReader(strSql.ToString(), parameters)) { if (reader.HasRows) { reader.Read(); model.id = reader.GetInt32(0); model.favid = reader.GetInt32(1); model.types = reader.GetInt32(2); model.title = reader.GetString(3); model.nid = reader.GetInt32(4); model.sid = reader.GetInt32(5); model.purl = reader.GetString(6); model.usid = reader.GetInt32(7); model.addtime = reader.GetDateTime(8); return(model); } else { return(null); } } }
/// <summary> /// 得到一个对象实体 /// </summary> public Book.Model.Contents GetContents(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,shi,title,summary,contents,addtime,state,jid,tags,aid,pid,isdel from Contents "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Book.Model.Contents model = new Book.Model.Contents(); using (SqlDataReader reader = SqlHelperBook.ExecuteReader(strSql.ToString(), parameters)) { if (reader.HasRows) { reader.Read(); model.id = reader.GetInt32(0); model.shi = reader.GetInt32(1); model.title = reader.GetString(2); if (!reader.IsDBNull(3)) { model.summary = reader.GetString(3); } if (!reader.IsDBNull(4)) { model.contents = reader.GetString(4); } if (!reader.IsDBNull(5)) { model.addtime = reader.GetDateTime(5); } if (!reader.IsDBNull(6)) { model.state = reader.GetInt32(6); } if (!reader.IsDBNull(7)) { model.jid = reader.GetInt32(7); } if (!reader.IsDBNull(8)) { model.tags = reader.GetString(8); } model.aid = reader.GetInt32(9); model.pid = reader.GetInt32(10); model.isdel = reader.GetInt32(11); return(model); } else { return(null); } } }
/// <summary> /// 得到一个对象实体 /// </summary> public Book.Model.ShuMu GetShuMu(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,nid,title,summary,img,aid,author,addtime,state,tags,types,length,click,good,gxtime,isover,isgood,pl,gxids,isdel from ShuMu "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Book.Model.ShuMu model = new Book.Model.ShuMu(); using (SqlDataReader reader = SqlHelperBook.ExecuteReader(strSql.ToString(), parameters)) { if (reader.HasRows) { reader.Read(); model.id = reader.GetInt32(0); model.nid = reader.GetInt32(1); model.title = reader.GetString(2); model.summary = reader.GetString(3); model.img = reader.GetString(4); if (!reader.IsDBNull(5)) { model.aid = reader.GetInt32(5); } model.author = reader.GetString(6); model.addtime = reader.GetDateTime(7); if (!reader.IsDBNull(8)) { model.state = reader.GetInt32(8); } model.tags = reader.GetString(9); model.types = reader.GetByte(10); model.length = reader.GetInt32(11); model.click = reader.GetInt32(12); model.good = reader.GetInt32(13); model.gxtime = reader.GetDateTime(14); model.isover = reader.GetByte(15); model.isgood = reader.GetByte(16); model.pl = reader.GetInt32(17); if (!reader.IsDBNull(18)) { model.gxids = reader.GetString(18); } model.isdel = reader.GetInt32(19); return(model); } else { return(null); } } }
/// <summary> /// 得到一个对象实体 /// </summary> public Book.Model.ShuSelf GetShuSelf(int aid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,aid,name,sex,city,pagenum,gxids,addtime from ShuSelf "); strSql.Append(" where aid=@aid "); SqlParameter[] parameters = { new SqlParameter("@aid", SqlDbType.Int, 4) }; parameters[0].Value = aid; Book.Model.ShuSelf model = new Book.Model.ShuSelf(); using (SqlDataReader reader = SqlHelperBook.ExecuteReader(strSql.ToString(), parameters)) { if (reader.HasRows) { reader.Read(); model.id = reader.GetInt32(0); model.aid = reader.GetInt32(1); model.name = reader.GetString(2); model.sex = reader.GetString(3); model.city = reader.GetString(4); model.pagenum = reader.GetInt32(5); if (!reader.IsDBNull(6)) { model.gxids = reader.GetString(6); } else { model.gxids = ""; } model.addtime = reader.GetDateTime(7); return(model); } else { model.id = 0; model.aid = 0; model.name = "未定义"; model.sex = "未定义"; model.city = "未定义"; model.pagenum = 0; model.gxids = ""; model.addtime = DateTime.Parse("1990-1-1"); return(model); } } }
/// <summary> /// 取得上(下)一条记录 /// </summary> public Book.Model.Contents GetPreviousNextContents(int ID, int shi, int jid, bool p_next) { List <Book.Model.Contents> listContents = new List <Book.Model.Contents>(); // 搜索部分 SqlParameter[] tmpSqlParam = { new SqlParameter("@shi", SqlDbType.Int, 4), new SqlParameter("@jid", SqlDbType.Int, 4), new SqlParameter("@ID", SqlDbType.Int, 4) }; string where = ""; if (shi != 0) { where += " shi=@shi AND"; where += " jid=@jid AND"; tmpSqlParam[0].Value = shi; tmpSqlParam[1].Value = jid; } where += !p_next ? " ID<@ID AND" : " ID>@ID AND"; tmpSqlParam[2].Value = ID; if (where != "") { where = " WHERE" + where.Substring(0, where.Length - 4); } // 重新整理 SqlParameter 顺序 int i = 0; SqlParameter[] SqlParam = new SqlParameter[3]; foreach (SqlParameter p in tmpSqlParam) { if (p.Value != null) { SqlParam[i] = new SqlParameter(); SqlParam[i].ParameterName = p.ParameterName; SqlParam[i].SqlDbType = p.SqlDbType; SqlParam[i].Size = p.Size; SqlParam[i].Value = p.Value; i++; } } string order = string.Empty; if (!p_next) { order = " ORDER BY ID DESC"; } else { order = " ORDER BY ID ASC"; } // 取出相关记录 Book.Model.Contents objContents = new Book.Model.Contents(); string queryString = "SELECT TOP 1 ID, Title" + " FROM Contents" + where + " and state=1 and isdel=0 " + order; using (SqlDataReader reader = SqlHelperBook.ExecuteReader(queryString.ToString(), SqlParam)) { while (reader.Read()) { objContents.id = reader.GetInt32(0); objContents.title = reader.GetString(1); } } return(objContents); }