//根据书本ID获取书本卷
public List <Model.VolumeInfo> getBookVolumes(int AuthorId, int bookId)
{
List <Model.VolumeInfo> list = new List <Model.VolumeInfo>();
SqlParameter[] parm = new SqlParameter[] {
new SqlParameter("@AuthorId", AuthorId),
new SqlParameter("@bookId", bookId)
};
using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "getBookVolumes", parm))
{
while (dr.Read())
{
Model.VolumeInfo item = new Model.VolumeInfo();
item.ValumeName = dr["valumeName"].ToString();
item.VolumeId = Convert.ToInt32(dr["volumeId"]);
item.ValumeNumber = Convert.ToInt32(dr["ValumeNumber"]);
item.BookId = Convert.ToInt32(dr["BookId"]);
item.BookName = dr["BookName"].ToString();
list.Add(item);
}
}
return(list);
}
//给已有小说添加新卷
public int addVolume(Model.VolumeInfo item)
{
return(novel.addVolume(item));
}
