private IEnumerable <PackageView> GetPackageList(int packageId = 0, Constants.PackageType packageType = Constants.PackageType.LimitFree, int pageSize = 10, int pageIndex = 1)
{
string where = "AND p.id = @packageId ";
string orderby = " order by pn.sortid desc, pn.id asc ";
int rowCount = 0;
return(_packageService.GetPagerList(packageType, where, orderby, pageIndex, pageSize, out rowCount, new { packageId }));
}
public IEnumerable <PackageView> GetPagerList(Constants.PackageType packageType, string where, string orderby, int pageIndex, int pageSize, out int rowCount, object param, int status = 1, int showType = 1)
{
using (var conn = DbConnection(DbOperation.Read))
{
var repo = new Repository.PackageRepo(conn);
return(repo.GetPagerList(packageType, where, orderby, pageIndex, pageSize, out rowCount, param, status, showType));
}
}
public PackageView GetNovelPackage(Constants.PackageType packageType, int novelId)
{
PackageView result = null;
if (novelId > 0)
{
using (var conn = DbConnection(DbOperation.Read))
{
var repo = new Repository.PackageRepo(conn);
result = repo.GetNovelPackage(packageType, novelId);
}
}
return(result);
}
/// <summary>
/// Считать пакет из буфера
/// </summary>
/// <returns>Пакет</returns>
public IPackage ReadPackage(Constants.PackageType packageType)
{
var package = new Package();
package.RecordTime = ReadLong();
var audioDataLenght = ReadInt();
package.AudioData = ReadBytes(audioDataLenght);
if (packageType == Constants.PackageType.AudioData)
{
return(package);
}
var videoDataLenght = ReadInt();
package.VideoData = ReadBytes(videoDataLenght);
return(package);
}
public PackageView GetNovelPackage(Constants.PackageType packageType, int novelId)
{
StringBuilder sql = new StringBuilder(" select pn.*, p.BeginTime, p.EndTime, p.AutoOpenTime, p.AutoCloseTime");
sql.Append(" from users.PackageNovel pn with (nolock) INNER JOIN Users.Package p with (nolock) ON p.Id = pn.PackageId ");
string where = " where pn.status = 1 and p.status = 1 and pn.novelId = @novelId ";
switch (packageType)
{
case Constants.PackageType.LimitFree:
where += " AND GETDATE() BETWEEN BeginTime AND EndTime ";
break;
case Constants.PackageType.Topic:
case Constants.PackageType.Free:
case Constants.PackageType.Rebate:
where += " AND ((AutoTurn = 1 AND GETDATE() BETWEEN AutoOpenTime AND AutoCloseTime) OR AutoTurn = 0) ";
break;
}
sql.Append(where);
return(DbManage.Query <PackageView>(sql.ToString(), new { novelId }, CommandType.Text).FirstOrDefault());
}
//推荐位列表
public IEnumerable <PackageView> GetPagerList(Constants.PackageType packageType, string where, string orderby, int pageIndex, int pageSize, out int rowCount, object param, int status, int showType)
{
string columns = "pn.*, n.Title AS NovelTitle, n.ShortDescription AS NovelShortDesc, n.LargeCover, n.ThumbCover, n.SmallCover, n.UpdateStatus, nc.ClassName, n.ShortWordSize, p.BeginTime, p.EndTime, p.AutoOpenTime, p.AutoCloseTime";
string table = string.Format(" users.PackageNovel pn with (nolock) INNER JOIN dbo.Novel n with (nolock) ON pn.NovelId = n.Id and n.status = {0} INNER JOIN Users.Package p with (nolock) ON p.Id = pn.PackageId INNER JOIN dbo.NovelClass nc ON nc.Id = n.ClassId ", status);
where += string.Format("AND pn.Status = {0} AND p.Status = {0} AND p.ShowType = {1} ", status, showType);
switch (packageType)
{
case Constants.PackageType.LimitFree:
where += " AND GETDATE() BETWEEN p.BeginTime AND p.EndTime ";
break;
//case Constants.PackageType.Topic:
//case Constants.PackageType.Free:
//case Constants.PackageType.Rebate:
// where += " AND ((AutoTurn = 1 AND GETDATE() BETWEEN AutoOpenTime AND AutoCloseTime) OR AutoTurn = 0) ";
// break;
default:
break;
}
return(DbManage.GetPagerList <PackageView>(columns, table, where, orderby, out rowCount, pageIndex, pageSize, param));
}