/// <summary> /// 机构列表页面 Pwp 2015-09-16 /// </summary> /// <param name="queryCond"></param> /// <returns></returns> public CustomPagedList<CollectInvoiceViewModel> GetList(PagedParam<CollectInvoiceQuery> queryCond) { return _paymentRepository.GetModel(o => o.Status == PaymentStatus.HasPayment) .Include(o => o.SellerSupplier) .Include(o => o.Special) .Include(o => o.CollectInvoice) .GetPagedList(queryCond.PageDto.PageNo, queryCond.PageDto.PageSize, BuildQueryCondition(queryCond.QueryDto), queryCond.SortField).ToCustomPagedList<Payment, CollectInvoiceViewModel>((u) => { var s = u.MapNew<Payment, CollectInvoiceViewModel>(); s.SupplyName = u.SellerSupplier.Name; if (u.CollectInvoice != null && u.CollectInvoice.Count > 0) { CollectInvoice c = u.CollectInvoice.OrderByDescending(o => o.CreateTime).FirstOrDefault(); s.CollectInvoiceStatus = (int)c.Status; s.ConfirmTime = c.CreateTime; } else { s.CollectInvoiceStatus = (int)CollectInvoiceQueryStatus.NotSubmit; } return s; }); }
public HttpResponseMessage GetList(PagedParam<GatheringQuery> queryCond) { queryCond.QueryDto.LoginUserId = LoginUser.ID; _dataResult.Code = ResponseStatusCode.Success; _dataResult.Msg = BusinessResourceMessage.Success; _dataResult.Data = _gatheringService.GetList(queryCond); return Request.CreateResponse(HttpStatusCode.OK, _dataResult); }
public void TestGetList() { PagedParam<BranchQuery> queryCond = new PagedParam<BranchQuery>() { PageDto = new PageDto { PageNo = 1, PageSize = 10 }, }; branchService.GetList(queryCond); }
public ActionResult List(PagedParam<dynamic> queryCond) { using (CTSContext context = new CTSContext()) { var result = context.CourierCompanys .Where(p => !p.IsDeleted) .OrderByDescending(p => p.CreatedTime).ToPagedList(queryCond.PageNo, queryCond.PageSize); return Json(new AjaxResult("查询成功", AjaxResultType.Success, new { rows = result.ToList(), total = result.TotalItemCount })); } }
public IPagedList<Send> List(PagedParam<SendQueryDto> queryCond) { using (CTSContext context = new CTSContext()) { var express = context.Sends .Include(p => p.BelongCompany) .Where(p => !p.IsDeleted); if (queryCond.QueryDto != null) { if (!string.IsNullOrEmpty(queryCond.QueryDto.CourierNumber)) { express = express.Where(p => p.CourierNumber.Equals(queryCond.QueryDto.CourierNumber)); } if (!string.IsNullOrEmpty(queryCond.QueryDto.CustomerPhone)) { express = express.Where(p => p.CustomerPhone.Equals(queryCond.QueryDto.CustomerPhone) || p.CustomerPhone.Contains(queryCond.QueryDto.CustomerPhone)); } if (queryCond.QueryDto.BelongCompanyId.HasValue) { if (queryCond.QueryDto.BelongCompanyId.Value != 0) { express = express.Where(p => p.BelongCompany.Id == queryCond.QueryDto.BelongCompanyId.Value); } } if (queryCond.QueryDto.State.HasValue) { if (queryCond.QueryDto.State != 0) { if (queryCond.QueryDto.State == 1) { express = express.Where(p => !p.IsSendOut); } else { express = express.Where(p => p.IsSendOut); } } } if (queryCond.QueryDto.CreatedTimeStart.HasValue) { express = express.Where(p => p.CreatedTime >= queryCond.QueryDto.CreatedTimeStart.Value); } if (queryCond.QueryDto.CreatedTimeEnd.HasValue) { var dt = queryCond.QueryDto.CreatedTimeEnd.Value.AddDays(1); express = express.Where(p => p.CreatedTime < dt); } } express = express.OrderByDescending(p => p.CreatedTime); var result = express.ToPagedList(queryCond.PageNo, queryCond.PageSize); return result; } }
public static PagedData <Students.Student> GetIndexStudentList() { CreateAllStudentData(); PagedParam pagedParam = new PagedParam(); List <Students.Student> list = (from s in AllStudentData select s) .Skip((pagedParam.Page - 1) * pagedParam.Limit) .Take(pagedParam.Limit) .ToList(); pagedParam = new PagedParam(pagedParam.Page, pagedParam.Limit, AllStudentData.Count); PagedData <Students.Student> pagedData = new PagedData <Models.Students.Student>(pagedParam); pagedData.Data = list; return(pagedData); }
public DataResult GetBranchList(PagedParam<CollectInvoiceQuery> inputBranch) { #region 角色验证 //总公司访问 if(LoginUser.Type != 0&& LoginUser.Type != UserType.Company ){ throw new DataOperationPermissions(BusinessResourceMessage.NoPower); } #endregion #region 输入验证 //if (string.IsNullOrEmpty(inputBranch.QueryDto.Type)) // throw new DataValidationException(string.Format(BusinessResourceMessage.ItemCanNotNull, "机构类型")); #endregion dataResult.Code = ResponseStatusCode.Success; dataResult.Msg = BusinessResourceMessage.Success; dataResult.Data = debitService.GetList(inputBranch); return dataResult; }
/// <summary> /// 保险对账 /// 统计方式:'专线' /// </summary> /// <param name="queryCond"></param> /// <returns></returns> public CustomPagedList<InsuranceCombineBasicViewModel> CombineListBySpecial(PagedParam<InsuranceCombineQuery> queryCond) { this.ValidateUser(queryCond); if (queryCond.QueryDto.DisplayType != InsuranceCombineDisplayType.Special) throw new DataValidationException("统计方式错误"); //排序 List<OrderDto> order = new List<OrderDto>(); order.Add(new OrderDto() { OrderField = "BuyTime", OrderSort = "desc" }); queryCond.OrderListDto = order; var tmp = this._insuranceRepository.GetModel().Include(c => c.Buyer) .GetPagedList(queryCond.PageDto.PageNo, queryCond.PageDto.PageSize, (e) => { if (queryCond.QueryDto.StartDate.HasValue && queryCond.QueryDto.EndDate.HasValue) { e = e.Where(c => c.BuyTime >= queryCond.QueryDto.StartDate && c.BuyTime <= queryCond.QueryDto.EndDate); } else { if (queryCond.QueryDto.StartDate.HasValue) e = e.Where(c => c.BuyTime >= queryCond.QueryDto.StartDate); if (queryCond.QueryDto.EndDate.HasValue) e = e.Where(c => c.BuyTime <= queryCond.QueryDto.EndDate); } if (!string.IsNullOrWhiteSpace(queryCond.QueryDto.BranchID)) { var arrB = Array.ConvertAll<string, string>(queryCond.QueryDto.BranchID.Split(','), x => x); e = e.Where(c => arrB.Contains(c.BranchId.ToString())); } return e; }, queryCond.SortField).ToCustomPagedList<Insurance, InsuranceCombineBasicViewModel>((u) => { var s = new InsuranceCombineBasicViewModel() { DisplayType = InsuranceCombineDisplayType.Special }; s.DataBySpecial = new List<InsuranceCombineViewModelBySpecial>(); s.DataBySpecial.Add(new InsuranceCombineViewModelBySpecial() { ID = u.ID, BranchName = u.BranchName, SpecialName = u.SpecialName, Money = u.Money, BuyName = u.Buyer.Name, BuyTime = u.BuyTime, InsuranceNumber = u.InsuranceNumber, InsuranceUrl = u.InsuranceUrl }); s.DisplaySumMoney = s.DataBySpecial.Sum(c => c.Money); return s; }); return tmp; }
/// <summary> /// 得到发票列表 /// </summary> /// <param name="queryCond"></param> /// <returns></returns> public CustomPagedList<GatheringViewModel> GetList(PagedParam<GatheringQuery> queryCond) { //得到分页数据 var result = _gatheringRepository.GetModel().GetPagedList(queryCond.PageDto.PageNo, queryCond.PageDto.PageSize, BuildQueryCondition(queryCond.QueryDto), queryCond.SortField) .ToCustomPagedList(u => { var s = u.MapNew<Gathering, GatheringViewModel>(); return s; }); return result; }
/// <summary> /// 供应商/销售商列表页面 Pwp 2015-09-23 /// </summary> /// <param name="queryCond"></param> /// <returns></returns> public CustomPagedList<ContractListViewModel> GetSellerSupplierList(PagedParam<SpecialContractQuery> queryCond) { return _contractRepository.GetModel() .Where(o => o.Type == queryCond.QueryDto.Type)//专线合同 .Include(p => p.Attachments) .Include(p => p.SellerSupplier) .GetPagedList(queryCond.PageDto.PageNo, queryCond.PageDto.PageSize, BuildSellerSupplierQuery(queryCond.QueryDto), queryCond.SortField).ToCustomPagedList<Contract, ContractListViewModel>((u) => { var s = u.MapNew<Contract, ContractListViewModel>(); //s.Name = u.Name return s; }); }
/// <summary> /// 专线合同列表页面 Pwp 2015-09-21 /// </summary> /// <param name="queryCond"></param> /// <returns></returns> public CustomPagedList<ContractListViewModel> GetBranchList(PagedParam<SpecialContractQuery> queryCond) { return _contractRepository.GetModel(o => o.Status == ContractStatus.Normal || o.Status == ContractStatus.Renewal) .Where(o => o.Type == ContractType.SpecialLine)//专线合同 .Include(p => p.Attachments) .Include(p => p.Special) .GetPagedList(queryCond.PageDto.PageNo, queryCond.PageDto.PageSize, BuildContractQuery(queryCond.QueryDto), queryCond.SortField).ToCustomPagedList<Contract, ContractListViewModel>((u) => { var s = u.MapNew<Contract, ContractListViewModel>(); //s.Name = u.Name return s; }); }
/// <summary> /// 专线列表 /// </summary> /// <param name="queryCond">查询条件</param> /// <returns></returns> public CustomPagedList<SpecialViewModel> GetList(PagedParam<SpecialMainQuery> queryCond) { //只有分社才能查询 if (queryCond.QueryDto.BranchID.HasValue) { var branch = this._baranchRepository.Find(c => c.ID == queryCond.QueryDto.BranchID); if (branch.Type != Framework.Enums.BranchType.Branch) { throw new DataOperationPermissions("非分社不能使用该功能"); } } List<OrderDto> order = new List<OrderDto>(); order.Add(new OrderDto() { OrderField = "UpdateTime", OrderSort = "desc" }); queryCond.OrderListDto = order; var tmp = _specialMainRepository.GetModel().Include(c => c.SpecialCapital) .GetPagedList(queryCond.PageDto.PageNo, queryCond.PageDto.PageSize, BuildQueryCondition(queryCond.QueryDto), queryCond.SortField).ToCustomPagedList<Special, SpecialViewModel>((u) => { var s = u.MapNew<Special, SpecialViewModel>("Balance"); s.Balance = u.SpecialCapital == null ? 0M : u.SpecialCapital.Balance; return s; }); return tmp; }
/// <summary> /// 付款管控 列表 /// </summary> /// <param name="queryCond"></param> /// <returns></returns> public CustomPagedList<PaymentViewModel> ManageList(PagedParam<PaymentQuery> queryCond) { #region valid var user = this.ValidIsBranch(queryCond.QueryDto.Sys_LoginUserID); #endregion //排序 List<OrderDto> order = new List<OrderDto>(); order.Add(new OrderDto() { OrderField = "ApplicationTime", OrderSort = "desc" }); queryCond.OrderListDto = order; //超级管理员可以查询所有数据 if ((int)user.Type == 0) { var tmp = this._paymentRepository.GetModel() .Include(c => c.Special) .GetPagedList(queryCond.PageDto.PageNo, queryCond.PageDto.PageSize, BuildQueryCondition(queryCond.QueryDto), queryCond.SortField).ToCustomPagedList<Payment, PaymentViewModel>((u) => { var s = new PaymentViewModel() { ID = u.ID, SpecialId = u.Special.ID, SpecialName = u.Special.Name, Payee = u.Payee, Money = u.Money, Status = u.Status, ApplicationTime = u.ApplicationTime, AuditTime = u.AuditTime }; return s; }); return tmp; } else { var tmp = this._paymentRepository.GetModel() .Include(c => c.Special) .Where(c => c.Special.BranchId == user.Branch.ID)//当前登录用户(分社)下的专线 .GetPagedList(queryCond.PageDto.PageNo, queryCond.PageDto.PageSize, BuildQueryCondition(queryCond.QueryDto), queryCond.SortField).ToCustomPagedList<Payment, PaymentViewModel>((u) => { var s = new PaymentViewModel() { ID = u.ID, SpecialId = u.Special.ID, SpecialName = u.Special.Name, Payee = u.Payee, Money = u.Money, Status = u.Status, ApplicationTime = u.ApplicationTime, AuditTime = u.AuditTime }; return s; }); return tmp; } }
public ActionResult List(PagedParam<SendQueryDto> queryCond) { var result = _service.List(queryCond); return Json(new { rows = result.ToList(), total = result.TotalItemCount }); }
/// <summary> /// 机构列表页面 Pwp 2015-09-16 /// </summary> /// <param name="queryCond"></param> /// <returns></returns> public CustomPagedList<DebitViewModel> GetList(PagedParam<DebitQuery> queryCond) { return _debitRepository.GetModel() .Include(o => o.Special) .Include(o => o.Special.Branch) .Include(o => o.Type) .GetPagedList(queryCond.PageDto.PageNo, queryCond.PageDto.PageSize, BuildQueryCondition(queryCond.QueryDto), queryCond.SortField).ToCustomPagedList<Debit, DebitViewModel>((u) => { var s = u.MapNew<Debit, DebitViewModel>(); s.SpecialName = u.Special.Name; s.TypeName = u.Type.Name; return s; }); }
/// <summary> /// 得到发票列表 /// </summary> /// <param name="queryCond"></param> /// <returns></returns> public CustomPagedList<InvoiceViewModel> GetList(PagedParam<InvoiceQuery> queryCond) { //得到分页数据 var result = _invoiceRepository.GetModel().GetPagedList(queryCond.PageDto.PageNo, queryCond.PageDto.PageSize, BuildQueryCondition(queryCond.QueryDto), queryCond.SortField) .ToCustomPagedList(u => u.MapNew<Invoice, InvoiceViewModel>("Special", "SellerSupplier", "Applicant", "Auditor")); return result; }
public DataResult GetContractSellerSupplierList(PagedParam<SpecialContractQuery> inputSpecial) { #region 角色验证 //分社权限 if (LoginUser.Type != 0 && LoginUser.Type != UserType.Branch) { throw new DataOperationPermissions(BusinessResourceMessage.NoPower); } #endregion #region 输入验证 //if (inputSpecial.QueryDto.SpecialId == 0) // throw new DataOperationPermissions(string.Format(BusinessResourceMessage.ItemCanNotNull,"专线")); #endregion dataResult.Code = ResponseStatusCode.Success; dataResult.Msg = BusinessResourceMessage.Success; dataResult.Data = contractService.GetSellerSupplierList(inputSpecial); return dataResult; }
public DataResult GetContractList(PagedParam<SpecialContractQuery> inputSpecial) { #region 角色验证 //分社访问 if (LoginUser.Type != 0 && LoginUser.Type != UserType.Branch) { throw new DataOperationPermissions(BusinessResourceMessage.NoPower); } #endregion //获取分社ID if (LoginUser.Type == UserType.Branch) { inputSpecial.QueryDto.BranchId = (int)LoginUser.BranchId; } dataResult.Code = ResponseStatusCode.Success; dataResult.Msg = BusinessResourceMessage.Success; dataResult.Data = contractService.GetBranchList(inputSpecial); return dataResult; }
public DataResult GetCollectInvoiceList(PagedParam<CollectInvoiceQuery> inputCollectInvoice) { #region 角色验证 //if (LoginUser.Type != 0 && LoginUser.Type != UserType.SpecialLine) //{ // throw new DataOperationPermissions(BusinessResourceMessage.NoPower); //} //如果当前用户为专线角色,只能查看专线下的付款列表 if (LoginUser.Type == UserType.SpecialLine) { inputCollectInvoice.QueryDto.SpecialId = (int)LoginUser.SpecialId; } //如果当前用户为专线角色,只能查看专线下的付款列表 if (LoginUser.Type == UserType.Branch) { inputCollectInvoice.QueryDto.BranchId = (int)LoginUser.BranchId; } #endregion #region 输入验证 if (inputCollectInvoice.QueryDto.StartData.HasValue && inputCollectInvoice.QueryDto.EndData.HasValue) { if (inputCollectInvoice.QueryDto.StartData > inputCollectInvoice.QueryDto.EndData) throw new DataValidationException(string.Format(BusinessResourceMessage.ItemComparison, "提交开始时间", "提交结束时间")); } #endregion dataResult.Code = ResponseStatusCode.Success; dataResult.Msg = BusinessResourceMessage.Success; dataResult.Data = collectinvoiceService.GetList(inputCollectInvoice); return dataResult; }
private User ValidateUser(PagedParam<InsuranceCombineQuery> queryCond) { var user = this._userRepository.GetModel().Include(c => c.Branch).Where(c => c.ID == queryCond.QueryDto.Sys_LoginUserID).SingleOrDefault(); if (user == null) throw new DataOperationPermissions("用户无权限访问该资源,请求失败"); //总公司、系统管理员 可以选择机构 if (user.Type == UserType.Company || (int)user.Type == 0) { if ((int)user.Type != 0) { queryCond.QueryDto.BranchID = user.Branch.ID.ToString(); } } else { if (!string.IsNullOrWhiteSpace(queryCond.QueryDto.BranchID)) throw new BusinessException("非总公司账号,不能选择机构进行查询"); } return user; }
public ActionResult List(PagedParam<VoucherQuery> queryCond) { var result = new VoucherService().List(queryCond); return Json(new AjaxResult("查询成功", AjaxResultType.Success, new { rows = result.ToList(), total = result.TotalItemCount })); }
/// <summary> /// 查询得到列表 /// </summary> /// <param name="queryCond"></param> /// <returns></returns> public CustomPagedList<UserViewModel> GetList(PagedParam<UserQuery> queryCond) { return _userRepository.GetModel() .Include(p => p.Special) .Include(p => p.Branch) .GetPagedList(queryCond.PageDto.PageNo, queryCond.PageDto.PageSize, BuildQueryCondition(queryCond.QueryDto), queryCond.SortField).ToCustomPagedList(u => { var s = u.MapNew<User, UserViewModel>("Menus"); s.Branch = u.Branch.MapNew<Branch, BranchViewModel>(); s.Special = u.Special.MapNew<Special, SpecialViewModel>(); return s; }); }
public ActionResult List(PagedParam<ReceiptQueryDto> queryCond) { using (CTSContext context = new CTSContext()) { var express = context.Receipts .Include(p => p.BelongCompany) .Include(p => p.TakeInfo) .Where(p => !p.IsDeleted); if (queryCond.QueryDto != null) { if (!string.IsNullOrEmpty(queryCond.QueryDto.CourierNumber)) { express = express.Where(p => p.CourierNumber.Equals(queryCond.QueryDto.CourierNumber)); } if (!string.IsNullOrEmpty(queryCond.QueryDto.CustomerName)) { express = express.Where(p => p.CustomerName.Contains(queryCond.QueryDto.CustomerName)); } if (!string.IsNullOrEmpty(queryCond.QueryDto.CustomerPhone)) { express = express.Where(p => p.CustomerPhone.Equals(queryCond.QueryDto.CustomerPhone)||p.CustomerPhone.Contains(queryCond.QueryDto.CustomerPhone)); } if (queryCond.QueryDto.BelongCompanyId.HasValue) { if (queryCond.QueryDto.BelongCompanyId.Value != 0) { express = express.Where(p => p.BelongCompany.Id == queryCond.QueryDto.BelongCompanyId.Value); } } if (queryCond.QueryDto.State.HasValue) { if (queryCond.QueryDto.State != 0) { if (queryCond.QueryDto.State == 1) { express = express.Where(p => p.TakeInfo == null); } else { express = express.Where(p => p.TakeInfo != null); } } } if (queryCond.QueryDto.CreatedTimeStart.HasValue) { express = express.Where(p => p.CreatedTime >= queryCond.QueryDto.CreatedTimeStart.Value); } if (queryCond.QueryDto.CreatedTimeEnd.HasValue) { var dt=queryCond.QueryDto.CreatedTimeEnd.Value.AddDays(1); express = express.Where(p => p.CreatedTime < dt); } } express=express.OrderByDescending(p => p.CreatedTime); var result = express.ToPagedList(queryCond.PageNo, queryCond.PageSize); return Json(new AjaxResult("查询成功", AjaxResultType.Success, new { rows = result.ToList(), total = result.TotalItemCount })); } }
public DataResult GetDebitList(PagedParam<DebitQuery> inputDebit) { #region 角色验证 //总公司/管理员无法访问 //if (LoginUser.Type == 0 ||LoginUser.Type == UserType.Company) //{ // throw new DataOperationPermissions(BusinessResourceMessage.NoPower); //} //如果当前用户为专线角色,只能查看专线下的付款列表 if (LoginUser.Type == UserType.SpecialLine) { inputDebit.QueryDto.SpecialId = (int)LoginUser.SpecialId; } //如果当前用户为专线角色,只能查看专线下的付款列表 if (LoginUser.Type == UserType.Branch) { inputDebit.QueryDto.BranchId = (int)LoginUser.BranchId; } #endregion #region 输入验证 //if (string.IsNullOrEmpty(inputDebit.QueryDto.Type)) // throw new DataValidationException(string.Format(BusinessResourceMessage.ItemCanNotNull, "机构类型")); #endregion dataResult.Code = ResponseStatusCode.Success; dataResult.Msg = BusinessResourceMessage.Success; dataResult.Data = debitService.GetList(inputDebit); return dataResult; }