/// <summary>
/// 分页显示所有项目
/// </summary>
/// <returns></returns>
//public ProjectProcGetResponse ProjectShow(ProjectProcGetRequest request)
//{
// ProjectProcGetResponse response = new ProjectProcGetResponse();
// var PageIndex = request.PageIndex;
// var PageSize = request.PageSize;
// var ProjectNumber = request.ProjectNumber;
// var Count = request.TotalCount;
// var Projectstage = request.Projectstage;
// response.Project = dal.ProjectShow(PageIndex, PageSize, ProjectNumber, Projectstage, out Count);
// if (response.Project.Count > 0)
// {
// response.Message = "项目执行成功";
// response.IsRegistSuccess = true;
// }
// else
// {
// response.Message = "项目执行失败";
// response.IsRegistSuccess = false;
// }
// return response;
//}
/// <summary>
/// 分页显示所有项目
/// </summary>
/// <returns></returns>
public ProjectProcGetResponse ProjectShow(ProjectProcGetRequest request)
{
ProjectProcGetResponse response = new ProjectProcGetResponse();
PageProperty page = new PageProperty()
{
PageIndex = request.PageIndex,
PageSize = request.PageSize,
ProjectNumber = request.ProjectNumber,
Projectstage = request.Projectstage,
};
var list = dal.ProjectShow(page);
response.Project = list.Project;
response.TotalCount = list.TotalCount;
if (response.Project.Count > 0)
{
response.Message = "项目执行成功";
response.IsRegistSuccess = true;
}
else
{
response.Message = "项目执行失败";
response.IsRegistSuccess = false;
}
return(response);
}
/// <summary>
/// 获取当前页面的页面设置参数
/// </summary>
/// <param name="pageSettings">页面设置参数</param>
/// <returns>DataLayer.SystemData.ReturnValue</returns>
private void InitPageSettings()
{
if (this.m_pageSettings == null)
{
this.m_pageSettings = new PageSettings();
}
if (this.TextEditor == null)
{
return;
}
try
{
PageProperty pageProperty = new PageProperty();
pageProperty.SetPropertyText(this.TextEditor.GetPageSetupInfo());
if (pageProperty == null)
{
return;
}
float zoom = this.TextEditor.ZoomPercentage / 100f;
this.m_pageSettings.Width = (int)Math.Round(pageProperty.Width / zoom);
this.m_pageSettings.Height = (int)Math.Round(pageProperty.Height / zoom);
this.m_pageSettings.Landscape = pageProperty.Landscape;
this.m_pageSettings.LeftMargin = (int)pageProperty.LeftMargin;
this.m_pageSettings.RightMargin = (int)pageProperty.RightMargin;
this.m_pageSettings.TopMargin = (int)pageProperty.TopMargin;
this.m_pageSettings.BottomMargin = (int)pageProperty.BottomMargin;
this.m_pageSettings.PageLayout = pageProperty.PageLayout;
}
catch (Exception ex)
{
LogManager.Instance.WriteLog("ChenPadCtrl.InitPageSettings", ex);
}
}
public IEnumerable <Pet> GetPage(PageProperty pageProperty)
{
//Updates data.
for (int i = 0; i < _pets.Count; i++)
{
_pets[i].Colour = _crep.GetById(_pets[i].Colour.Id);
_pets[i].Type = _ptrep.GetById(_pets[i].Type.Id);
_pets[i].PreviousOwner = _prep.GetById(_pets[i].PreviousOwner.Id);
}
return(_pets.Skip((pageProperty.Page - 1) * pageProperty.Limit).Take(pageProperty.Limit));
}
public ActionResult <IEnumerable <Pet> > Get([FromQuery] PageProperty pageProperty)
{
try
{
return(_petService.GetPage(pageProperty));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
/// <summary>
/// To be used when paging is involved.
/// </summary>
public virtual IEnumerable <TEntity> GetPaged(PageProperty pageProperty,
Expression <Func <TEntity, bool> > filter = null,
string includeProperties = "")
{
IQueryable <TEntity> query = dbSet;
Filter(query, filter);
IncludeProperties(query, includeProperties);
var orderedData = OrderBy(query, pageProperty.OrderByColumn, pageProperty.SortDirection);
return(PagedData(orderedData, pageProperty));
}
/// <summary>
/// 分页显示所有项目
/// </summary>
/// <returns></returns>
//public List<ProjectInfo> ProjectShow(int PageIndex, int PageSize, string ProjectNumber, int Projectstage, out int TotalCount)
//{
// var p = new DynamicParameters();
// p.Add("@Pageindex", PageIndex);
// p.Add("@PageSize", PageSize);
// p.Add("@ProjectNumber", ProjectNumber);
// p.Add("@Projectstage", Projectstage);
// p.Add("@TotalCount", 0, DbType.Int32, ParameterDirection.Output);
// var list = DapperHelper<ProjectInfo>.ExecutePro("dbo.P_ProjectShow", p);
// TotalCount = p.Get<int>("@TotalCount");
// return list;
//}
/// <summary>
/// 分页显示所有项目
/// </summary>
/// <returns></returns>
public PageProjectInfo ProjectShow(PageProperty page)
{
PageProjectInfo info = new PageProjectInfo();
var p = new DynamicParameters();
p.Add("@Pageindex", page.PageIndex);
p.Add("@PageSize", page.PageSize);
p.Add("@ProjectNumber", page.ProjectNumber);
p.Add("@Projectstage", page.Projectstage);
p.Add("@TotalCount", page.Projectstage, DbType.Int32, ParameterDirection.Output);
info.Project = DapperHelper <ProjectInfo> .ExecutePro("dbo.P_ProjectShow", p);
info.TotalCount = p.Get <int>("@TotalCount");
return(info);
}
public IEnumerable <Pet> GetPage(PageProperty pageProperty)
{
if (pageProperty == null)
{
return(GetAll());
}
IQueryable <Pet> quaryPets = _ctx.Pets
.Include(s => s.Colours).ThenInclude(pc => pc.Colour)
.Include(s => s.Type)
.Include(s => s.PreviousOwner);
if (pageProperty.SortBy != null)
{
PropertyInfo propertyInfo = typeof(Pet).GetProperty(pageProperty.SortBy, BindingFlags.IgnoreCase | BindingFlags.Public | BindingFlags.Instance);
if (propertyInfo == null)
{
throw new RepositoryException($"Cannot sort by {pageProperty.SortBy} because it is not a property in Pet! Try another.");
}
if (pageProperty.SortOrder == null || pageProperty.SortOrder.ToLower().Equals("asc"))
{
quaryPets = quaryPets.OrderBy(p => propertyInfo.GetValue(p, null));
}
else if (pageProperty.SortOrder.ToLower().Equals("desc"))
{
quaryPets = quaryPets.OrderByDescending(p => propertyInfo.GetValue(p, null));
}
else
{
throw new RepositoryException($"Sort order can only be 'asc' or 'desc'! Not {pageProperty.SortOrder}.");
}
}
List <Pet> pets = quaryPets
.Skip((pageProperty.Page - 1) * pageProperty.Limit)
.Take(pageProperty.Limit)
.ToList();
return(pets);
}
public void Delete_DeletesProperty()
{
//arrange
var property = new PageProperty {
Id = 1
};
_dbContextMock.Setup(x => x.GetDbSet <PageProperty>()).Returns(new InMemoryDbSet <PageProperty>
{
property
});
//act
_propertyService.Delete(property.Id);
//assert
var deletedProperty = _dbContextMock.Object.GetDbSet <PageProperty>().FirstOrDefault(x => x.Id == property.Id);
deletedProperty.Should().Be.Null();
}
public List <Pet> GetPage(PageProperty pageProperty)
{
if (pageProperty != null)
{
if (pageProperty.Page < 1)
{
throw new ArgumentException("The page cannot be less than 1! Try another page.");
}
else if ((pageProperty.Page - 1) * pageProperty.Limit >= _prep.Count())
{
throw new ArgumentException("Page not found! Try another page.");
}
}
try
{
return(_prep.GetPage(pageProperty).ToList());
}
catch (Exception e)
{
throw new ServiceException("Error getting all pets: " + e.Message, e);
}
}
public IEnumerable <Colour> GetPage(PageProperty pageProperty)
{
throw new NotImplementedException();
}
set => SetValue(PageProperty, value);
public void Read(TProtocol iprot)
{
iprot.IncrementRecursionDepth();
try
{
TField field;
iprot.ReadStructBegin();
while (true)
{
field = iprot.ReadFieldBegin();
if (field.Type == TType.Stop)
{
break;
}
switch (field.ID)
{
case 1:
if (field.Type == TType.Struct)
{
Person_property = new PersonProperty();
Person_property.Read(iprot);
}
else
{
TProtocolUtil.Skip(iprot, field.Type);
}
break;
case 2:
if (field.Type == TType.Struct)
{
Page_property = new PageProperty();
Page_property.Read(iprot);
}
else
{
TProtocolUtil.Skip(iprot, field.Type);
}
break;
case 3:
if (field.Type == TType.Struct)
{
Equiv = new EquivEdge();
Equiv.Read(iprot);
}
else
{
TProtocolUtil.Skip(iprot, field.Type);
}
break;
case 4:
if (field.Type == TType.Struct)
{
Page_view = new PageViewEdge();
Page_view.Read(iprot);
}
else
{
TProtocolUtil.Skip(iprot, field.Type);
}
break;
default:
TProtocolUtil.Skip(iprot, field.Type);
break;
}
iprot.ReadFieldEnd();
}
iprot.ReadStructEnd();
}
finally
{
iprot.DecrementRecursionDepth();
}
}
public static void AddProperty(this PageNode pageNode, IUnitOfWork unitOfWork, PageProperty property)
{
//when creating entities EF doesn't instantiate proxy collections, so we need to force it to be instantiated using this hack :(
if (pageNode.Properties == null)
{
var propertyDbSet = unitOfWork.Context.GetDbSet <PageProperty>();
var newProperty = propertyDbSet.Create();
newProperty.ParentPageNode = pageNode;
propertyDbSet.Add(newProperty);
propertyDbSet.Remove(newProperty);
}
pageNode.Properties.Add(property);
}
private IEnumerable <TEntity> PagedData(IQueryable <TEntity> query, PageProperty pageProperty)
{
pageProperty.TotalRecords = query.Count();
pageProperty.TotalPages = (int)Math.Ceiling(pageProperty.TotalRecords / (float)pageProperty.Rows);
return(query.Skip((pageProperty.Page - 1) * pageProperty.Rows).Take(pageProperty.Rows));
}
