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