/// <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;
}