/// <summary> /// 导出海关缴款书档案信息到Excel /// </summary> /// <param name="content"></param> /// <param name="query"></param> /// <returns></returns> public FileContentResult ExportHgToExcel(string content, string query) { if (!IsValidAccount(SessionToken)) { return(null); } LogHelper.LoginLog(SessionUserId, "FaArchive/ExportHgToExcel,执行海关缴款书档案信息导出操作."); try { var parameter = new FaArchiveListParameter(); parameter.Content = content; if (!string.IsNullOrEmpty(query)) { parameter = JsonHelper.Deserialize <FaArchiveListParameter>(query); } IList <FaDocDto> list = _faDocService.GetFaDocs(parameter); byte[] faDocsExcel = _faDocExcelService.GetHgFaDocsExcel(list); return(File(faDocsExcel, "application/ms-excel", Server.UrlEncode("海关缴款档案信息.xlsx"))); } catch (Exception ex) { LogHelper.ExceptionLog(SessionUserId, "FaArchive/ExportHgToExcel", ex); return(null); } }
public string GetFaHgReturnDoc(int rows, int page, string query, string content) { if (!IsValidAccount(SessionToken)) { Redirect("../Error/LoginError"); return(string.Empty); } int userId = SessionUserId; int pageIndex = page; int pageSize = rows; var paging = new PagingParameter(pageIndex, pageSize); long count; var parameter = new FaArchiveListParameter(); parameter.Content = content; if (!string.IsNullOrEmpty(query)) { parameter = JsonHelper.Deserialize <FaArchiveListParameter>(query); } IList <JieYueDocDto> list = _faDocService.GetPageFaReturnDocs(paging, parameter, out count); var faReturnDocJsonService = new FaReturnDocJsonService(); string json = faReturnDocJsonService.GetHgJqGridJson(list, count, paging, userId); return(json); }
public IList <JieYueDocDto> Find( PagingParameter paging, FaArchiveListParameter parameter, out long count) { //IList<FaDocDto> result = (from t in DataContext.Jieyues // join t2 in DataContext.FaArchives on t.ArchiveId equals t2.Id into tTemp // from t3 in tTemp.DefaultIfEmpty() // where // select new FaDocDto // { // }).ToList(); IQueryable <Jieyue> queryable = FindFdDocs(parameter); count = queryable.Count(); if (count == 0) { return(new List <JieYueDocDto>()); } int pageSize = paging.PageSize; int pageIndex = paging.PageIndex; pageIndex = pageIndex - 1; queryable = queryable.OrderBy(t => t.Id).Skip(pageSize * pageIndex).Take(pageSize); IList <Jieyue> faDocs = queryable.ToList(); return(GetFaLendDocs(faDocs)); }
public IList <FaDocDto> Find(FaArchiveListParameter parameter) { IQueryable <FaArchive> queryable = FindFdDocs(parameter); IList <FaArchive> faDocs = queryable.ToList(); return(GetFaDocDtos(faDocs)); }
public IList <JieYueDocDto> Find( PagingParameter paging, FaArchiveListParameter parameter, out long count) { IQueryable <Jieyue> queryable = FindFdDocs(parameter); count = queryable.Count(); if (count == 0) { return(new List <JieYueDocDto>()); } int pageSize = paging.PageSize; int pageIndex = paging.PageIndex; pageIndex = pageIndex - 1; queryable = queryable.OrderBy(t => t.Id).Skip(pageSize * pageIndex).Take(pageSize); IList <Jieyue> faDocs = queryable.ToList(); return(GetFaLendDocs(faDocs)); }
private IQueryable <Jieyue> FindFdDocs(FaArchiveListParameter parameter) { IQueryable <Jieyue> queryable = !string.IsNullOrEmpty(parameter.Query) ? DataContext.Jieyues.Where(t => t.Jieyuezhuangtai == (int)JieyueZhuangtaiEnum.YiJieyue && t.Guihuanzhuangtai == (int)GuihuanZhuangtaiEnum.WeiGuihuan) .Where(GetPredicate(parameter.Query)) : DataContext.Jieyues.Where(t => t.Jieyuezhuangtai == (int)JieyueZhuangtaiEnum.YiJieyue && t.Guihuanzhuangtai == (int)GuihuanZhuangtaiEnum.WeiGuihuan); if (!string.IsNullOrEmpty(parameter.Content)) { queryable = queryable.Where(t => t.FaArchive.Content.Contains(parameter.Content)); } if (!string.IsNullOrEmpty(parameter.Company)) { queryable = queryable.Where(t => t.FaArchive.Company.Contains(parameter.Company)); } if (parameter.YearBegin != null) { queryable = queryable.Where(t => t.FaArchive.Year >= parameter.YearBegin); } if (parameter.YearEnd != null) { queryable = queryable.Where(t => t.FaArchive.Year <= parameter.YearEnd); } if (parameter.MonthBegin != null) { queryable = queryable.Where(t => t.FaArchive.Month >= parameter.MonthBegin); } if (parameter.MonthEnd != null) { queryable = queryable.Where(t => t.FaArchive.Month <= parameter.MonthEnd); } if (!string.IsNullOrEmpty(parameter.VoucherWord)) { queryable = queryable.Where(t => t.FaArchive.VoucherWord.Contains(parameter.VoucherWord)); } if (parameter.VoucherNumber != null) { queryable = queryable.Where(t => t.FaArchive.VoucherNumber == parameter.VoucherNumber); } if (!string.IsNullOrEmpty(parameter.VoucherNo)) { queryable = queryable.Where(t => t.FaArchive.VoucherNo.Contains(parameter.VoucherNo)); } if (parameter.VoucherNos != null) { queryable = queryable.Where(t => t.FaArchive.VoucherNos == parameter.VoucherNos); } //if (!string.IsNullOrEmpty(parameter.Path)) //{ // queryable = queryable.Where(t => t.FaArchive.Path.Contains(parameter.Path)); //} //if (!string.IsNullOrEmpty(parameter.CabinetNo)) //{ // queryable = queryable.Where(t => t.FaArchive.CabinetNo.Contains(parameter.CabinetNo)); //} if (parameter.JieyueShijianStart != null) { queryable = queryable.Where(t => t.JieyueShijian >= parameter.JieyueShijianStart); } if (parameter.JieyueShijianEnd != null) { queryable = queryable.Where(t => t.JieyueShijian <= parameter.JieyueShijianEnd); } return(queryable); }
public IList <JieYueDocDto> GetPageFaReturnDocs( PagingParameter paging, FaArchiveListParameter parameter, out long count) { return(_faReturnDocRepository.Find(paging, parameter, out count)); }
public IList <FaDocDto> GetFaDocs(FaArchiveListParameter parameter) { return(_faDocRepository.Find(parameter)); }
private IQueryable <FaArchive> FindFdDocs(FaArchiveListParameter parameter) { IQueryable <FaArchive> queryable = !string.IsNullOrEmpty(parameter.Query) ? DataContext.FaArchives.Where(GetPredicate(parameter.Query)) : DataContext.FaArchives; if (!string.IsNullOrEmpty(parameter.Content)) { queryable = queryable.Where(t => t.Content.Contains(parameter.Content)); } if (!string.IsNullOrEmpty(parameter.Company)) { queryable = queryable.Where(t => t.Company.Contains(parameter.Company)); } if (parameter.YearBegin != null) { queryable = queryable.Where(t => t.Year >= parameter.YearBegin); } if (parameter.YearEnd != null) { queryable = queryable.Where(t => t.Year <= parameter.YearEnd); } if (parameter.MonthBegin != null) { queryable = queryable.Where(t => t.Month >= parameter.MonthBegin); } if (parameter.MonthEnd != null) { queryable = queryable.Where(t => t.Month <= parameter.MonthEnd); } if (!string.IsNullOrEmpty(parameter.VoucherWord)) { queryable = queryable.Where(t => t.VoucherWord.Contains(parameter.VoucherWord)); } if (parameter.VoucherNumber != null) { queryable = queryable.Where(t => t.VoucherNumber == parameter.VoucherNumber); } if (!string.IsNullOrEmpty(parameter.VoucherNo)) { queryable = queryable.Where(t => t.VoucherNo.Contains(parameter.VoucherNo)); } if (parameter.VoucherNos != null) { queryable = queryable.Where(t => t.VoucherNos == parameter.VoucherNos); } if (!string.IsNullOrEmpty(parameter.BaogaoMingcheng)) { queryable = queryable.Where(t => t.BaogaoMingcheng.Contains(parameter.BaogaoMingcheng)); } if (!string.IsNullOrEmpty(parameter.Hetonghao)) { queryable = queryable.Where(t => t.HetongHao.Contains(parameter.Hetonghao)); } if (!string.IsNullOrEmpty(parameter.Path)) { queryable = queryable.Where(t => t.Path.Contains(parameter.Path)); } if (!string.IsNullOrEmpty(parameter.CabinetNo)) { queryable = queryable.Where(t => t.CabinetNo.Contains(parameter.CabinetNo)); } return(queryable); }