//(后台)获取要审核的章节 public List <Model.SectionsInfo> getCheckSections(int pageindex, int pagesize, out int recoredCount) { SqlParameter[] parm = new SqlParameter[] { new SqlParameter("@pageindex", pageindex), new SqlParameter("@pageSize", pagesize), new SqlParameter("@recordCount", SqlDbType.Int, 4) }; parm[2].Direction = ParameterDirection.Output; List <Model.SectionsInfo> list = new List <Model.SectionsInfo>(); using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "getCheckSections", parm)) { while (dr.Read()) { Model.SectionsInfo item = new Model.SectionsInfo(); item.BookId = Convert.ToInt32(dr["bookId"]); item.BookName = dr["BookName"].ToString(); item.SectionTitle = dr["SectionTitle"].ToString(); item.Contents = dr["Contents"].ToString(); item.CharNum = Convert.ToInt32(dr["CharNum"]); item.ShortAddTime = Convert.ToDateTime(dr["addtime"]).ToShortDateString(); item.StateName = dr["stateName"].ToString(); item.SectiuonId = Convert.ToInt32(dr["SectiuonId"]); item.BookId = Convert.ToInt32(dr["BookId"]); list.Add(item); } } recoredCount = Convert.ToInt32(parm[2].Value); return(list); }
//根据卷获得章 public List <Model.SectionsInfo> getVolumeSecionts(int pageindex, int pagesize, int volumenid, out int recordCount) { List <Model.SectionsInfo> list = new List <Model.SectionsInfo>(); SqlParameter[] parm = new SqlParameter[] { new SqlParameter("@pageindex", pageindex), new SqlParameter("@pagesize", pagesize), new SqlParameter("@volumenid", volumenid), new SqlParameter("@recoredCount", SqlDbType.Int, 4) }; parm[3].Direction = ParameterDirection.Output; using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "getVolumeSecionts", parm)) { while (dr.Read()) { Model.SectionsInfo item = new Model.SectionsInfo(); item.SectiuonId = Convert.ToInt32(dr["SectiuonId"]); item.VolumeId = Convert.ToInt32(dr["VolumeId"]); item.SectionTitle = dr["SectionTitle"].ToString(); item.CharNum = Convert.ToInt32(dr["CharNum"]); list.Add(item); } } recordCount = Convert.ToInt32(parm[3].Value); return(list); }
//(作者专区)获取审核章节 public List <Model.SectionsInfo> getExsetions(int userid) { SqlParameter[] parm = new SqlParameter[] { new SqlParameter("@userid", userid) }; List <Model.SectionsInfo> list = new List <Model.SectionsInfo>(); using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "isExamine", parm)) { while (dr.Read()) { Model.SectionsInfo item = new Model.SectionsInfo(); item.BookName = dr["BookName"].ToString(); item.CharNum = Convert.ToInt32(dr["CharNum"]); item.SectionTitle = dr["sectionTitle"].ToString(); item.ValumeName = dr["ValumeName"].ToString(); item.ShortAddTime = Convert.ToDateTime(dr["addtime"]).ToShortDateString(); list.Add(item); } } return(list); }
//给已有小说添加新章 public int addSections(Model.SectionsInfo item) { return(novel.addSections(item)); }