using DTO;
|
using IServices;
|
using Microsoft.AspNetCore.Http;
|
using Microsoft.AspNetCore.Mvc;
|
using Microsoft.Extensions.Logging;
|
using Newtonsoft.Json;
|
using OfficeOpenXml;
|
using OfficeOpenXml.Style;
|
using System;
|
using System.Collections.Generic;
|
using System.IO;
|
using System.Linq;
|
using System.Threading.Tasks;
|
using System.Transactions;
|
using zhengcaioa.IService;
|
using zhengcaioa.Models;
|
|
namespace zhengcaioa.Controllers.Finance
|
{
|
[CheckLogin]
|
public class FiAccountIncomeController : Controller
|
{
|
private readonly ILogger<FiAccountIncomeController> _logger;
|
private readonly IFiAccountService _fiAccountService;
|
private readonly ILiaotianService _liaotianService;
|
|
private readonly IFiAccountRecordService _iFiAccountRecordService;
|
private readonly IFiSubjectService _ifiSubjectService;
|
private readonly IPltPageService _pltPageService;
|
|
public FiAccountIncomeController(ILogger<FiAccountIncomeController> logger, IFiAccountService fiAccountService, ILiaotianService liaotianService, IFiAccountRecordService iFiAccountRecordService, IFiSubjectService ifiSubjectService
|
, IPltPageService pltPageService)
|
{
|
_logger = logger;
|
_fiAccountService = fiAccountService;
|
_liaotianService = liaotianService;
|
_iFiAccountRecordService = iFiAccountRecordService;
|
_ifiSubjectService = ifiSubjectService;
|
_pltPageService = pltPageService;
|
}
|
|
|
public IActionResult Index()
|
{
|
var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));
|
ViewData["curentuser"] = curentuser;
|
List<ActionEntity> actionlist = new List<ActionEntity>();
|
ActionEntity actionEntity = new ActionEntity();
|
actionEntity.OpenType = 0;
|
actionEntity.ActionUrl = "";
|
actionEntity.ActionFun = "Search";
|
actionEntity.PageIco = "fa fa-search";
|
actionEntity.ActionName = "查询";
|
actionlist.Add(actionEntity);
|
//ActionEntity actionEntity1 = new ActionEntity();
|
//actionEntity1.OpenType = 0;
|
//actionEntity1.ActionUrl = "";
|
//actionEntity1.ActionFun = "Add";
|
//actionEntity1.PageIco = "fa fa-plus";
|
//actionEntity1.ActionName = "新增";
|
//actionlist.Add(actionEntity1);
|
//ActionEntity actionEntity2 = new ActionEntity();
|
//actionEntity2.OpenType = 0;
|
//actionEntity2.ActionUrl = "";
|
//actionEntity2.ActionFun = "PrintDetail";
|
//actionEntity2.PageIco = "fa fa-plus";
|
//actionEntity2.ActionName = "打印明细";
|
//actionlist.Add(actionEntity2);
|
var pageEntities = _pltPageService.GetUserPage(curentuser.Id, "/FiAccountIncome/Index/");
|
var pageEntities1 = pageEntities.Where(x => x.PageMethod == "01").ToList();
|
foreach (var pageEntity in pageEntities1)
|
{
|
ActionEntity actionEntity1 = new ActionEntity();
|
actionEntity1.OpenType = pageEntity.OpenType;
|
actionEntity1.ActionUrl = "";
|
actionEntity1.ActionFun = pageEntity.PageShortcut;
|
actionEntity1.PageIco = pageEntity.PageIco;
|
actionEntity1.ActionName = pageEntity.PageName;
|
actionlist.Add(actionEntity1);
|
}
|
|
|
|
ViewData["ActionInfo"] = actionlist;
|
ViewBag.accounttype = _liaotianService.GetSYScode("fi_account", "accounttype").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();
|
ViewBag.FiSubject = _ifiSubjectService.GetList().Where(x=>x.Subjecttype=="01").Select(x => new { code = x.Id, label = x.Subjectname }).ToList();
|
return View();
|
}
|
|
|
public IActionResult GetList(FiAccountRecordDTOSearch search)
|
{
|
var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));
|
ViewData["curentuser"] = curentuser;
|
search.RecordTypeId = "1";
|
search.Creater = "1111";
|
return new JsonResult(_iFiAccountRecordService.SearchByPaging(search));
|
}
|
|
|
/// <summary>
|
/// 获取市
|
/// </summary>
|
/// <param name="Accounttype">账户类型</param>
|
/// <returns></returns>
|
///
|
[CheckLogin]
|
public string getAccount(string Accounttype = "")
|
{
|
var shi = _fiAccountService.GetList().Where(x=>x.Accounttype== Accounttype);
|
|
return JsonConvert.SerializeObject(shi);
|
|
}
|
|
|
public IActionResult Edit(string id = null)
|
{
|
var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));
|
ViewData["curentuser"] = curentuser;
|
|
FiAccountRecordDTO fiAccountRecordDTO = new FiAccountRecordDTO();
|
if (!String.IsNullOrEmpty(id))
|
{
|
fiAccountRecordDTO = _iFiAccountRecordService.Get(id);
|
fiAccountRecordDTO.Accounttype = _fiAccountService.Get(fiAccountRecordDTO.AccountId).Accounttype;
|
}
|
ViewBag.accounttype = _liaotianService.GetSYScode("fi_account", "accounttype");
|
ViewBag.FiSubject = _ifiSubjectService.GetList().Where(x => x.Subjecttype == "01").ToList();
|
|
|
|
ViewData.Model = fiAccountRecordDTO;
|
return View();
|
}
|
|
|
/// <summary>
|
/// 保存
|
/// </summary>
|
/// <param name="data">岗位实体类对象</param>
|
/// <returns></returns>
|
///
|
[HttpPost]
|
public IActionResult Save(FiAccountRecordDTO data)
|
{
|
var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));
|
ViewData["curentuser"] = curentuser;
|
data.RecStatus = "A";
|
if (String.IsNullOrEmpty(data.Id))
|
{
|
data.Creater = curentuser.Id;
|
data.Createtime = DateTime.Now;
|
}
|
data.Modifier = curentuser.Id;
|
data.Modifytime = DateTime.Now;
|
ResultEntity resultEntity = new ResultEntity();
|
resultEntity.Result = false;
|
using (TransactionScope scope = new TransactionScope())
|
{
|
FiAccountDTO firmAccount = _fiAccountService.Get(data.AccountId);
|
|
|
data.RecordTypeId = "1";//收入
|
data.Department = "";
|
|
|
firmAccount.AllIncome = (firmAccount.AllIncome ?? 0) + data.Money ;
|
firmAccount.Balance = (firmAccount.Balance??0) + data.Money;
|
|
data.AccountMoney = firmAccount.Balance;
|
|
resultEntity = _iFiAccountRecordService.save(data);
|
|
resultEntity = _fiAccountService.save(firmAccount);
|
scope.Complete();
|
}
|
|
|
|
return new JsonResult(resultEntity);
|
}
|
|
|
public IActionResult Check(string id = null)
|
{
|
var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));
|
ViewData["curentuser"] = curentuser;
|
|
FiAccountRecordDTO fiAccountRecordDTO = new FiAccountRecordDTO();
|
if (!String.IsNullOrEmpty(id))
|
{
|
fiAccountRecordDTO = _iFiAccountRecordService.Get(id);
|
FiAccountDTO fiAccountDTO=_fiAccountService.Get(fiAccountRecordDTO.AccountId);
|
fiAccountRecordDTO.Accounttype = fiAccountDTO.Accounttype;
|
fiAccountRecordDTO.AccounttypeName = _liaotianService.GetSYScode("fi_account", "accounttype").Where(x => x.CodeSn == fiAccountRecordDTO.Accounttype).FirstOrDefault().Comments;
|
fiAccountRecordDTO.SubjectName = _ifiSubjectService.GetList().Where(x => x.Id == fiAccountRecordDTO.SubjectId).FirstOrDefault().Subjectname;
|
fiAccountRecordDTO.AccountName = fiAccountDTO.Accountname;
|
}
|
|
|
|
|
|
ViewData.Model = fiAccountRecordDTO;
|
return View();
|
}
|
|
|
|
|
|
|
public IActionResult PrintAll(string RecordTypeId = "")
|
{
|
var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));
|
ViewData["curentuser"] = curentuser;
|
List<ActionEntity> actionlist = new List<ActionEntity>();
|
ActionEntity actionEntity = new ActionEntity();
|
actionEntity.OpenType = 0;
|
actionEntity.ActionUrl = "";
|
actionEntity.ActionFun = "Search";
|
actionEntity.PageIco = "fa fa-search";
|
actionEntity.ActionName = "查询";
|
actionlist.Add(actionEntity);
|
ActionEntity actionEntity1 = new ActionEntity();
|
actionEntity1.OpenType = 0;
|
actionEntity1.ActionUrl = "";
|
actionEntity1.ActionFun = "Print";
|
actionEntity1.PageIco = "fa fa-plus";
|
actionEntity1.ActionName = "打印";
|
actionlist.Add(actionEntity1);
|
|
ActionEntity actionEntity2 = new ActionEntity();
|
actionEntity2.OpenType = 0;
|
actionEntity2.ActionUrl = "";
|
actionEntity2.ActionFun = "Daochu";
|
actionEntity2.PageIco = "fa fa-plus";
|
actionEntity2.ActionName = "导出";
|
actionlist.Add(actionEntity2);
|
|
ViewData["ActionInfo"] = actionlist;
|
ViewBag.accounttype = _liaotianService.GetSYScode("fi_account", "accounttype").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();
|
ViewBag.FiSubject = _ifiSubjectService.GetList().Select(x => new { code = x.Id, label = x.Subjectname }).ToList();
|
ViewBag.RecordTypeId = _liaotianService.GetSYScode("fi_account_record", "RecordTypeId").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();
|
ViewBag.RecordTypeId1 = RecordTypeId;
|
return View();
|
}
|
|
|
public IActionResult GetListPrint(FiAccountRecordDTOSearch search)
|
{
|
var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));
|
ViewData["curentuser"] = curentuser;
|
//search.RecordTypeId = "1";
|
return new JsonResult(_iFiAccountRecordService.SearchByPaging(search));
|
}
|
|
|
public IActionResult GetDaochu(FiAccountRecordDTOSearch search)
|
{
|
|
search.page = 1;
|
search.rows = 10000;
|
var aaa = _iFiAccountRecordService.SearchByPaging(search);
|
var data1 = aaa.DataList;
|
|
ExcelPackage.LicenseContext = OfficeOpenXml.LicenseContext.NonCommercial;
|
using var ep = new ExcelPackage();
|
|
//添加sheet
|
using var worksheet = ep.Workbook.Worksheets.Add("档案客户资料");
|
|
|
|
int x = 1;
|
int y = 1;
|
var columnTitles = new List<string>()
|
{
|
"记录类型","账户类型","账户名称","科目名称","金额","余额","收(支)款单位"
|
,"操作人","摘要","订单号","操作时间"
|
|
};
|
foreach (var columnTitle in columnTitles)
|
{
|
//设置样式
|
var cell = worksheet.Cells[x, y++];
|
cell.Style.Font.Bold = true;
|
cell.Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
|
cell.Style.VerticalAlignment = ExcelVerticalAlignment.Center;
|
cell.Value = columnTitle;
|
}
|
foreach (var item in data1)
|
{
|
x++;
|
y = 1;
|
|
|
var cell = worksheet.Cells[x, y++];
|
cell.Value = item.RecordTypeName;
|
cell = worksheet.Cells[x, y++];
|
cell.Value = item.AccounttypeName;
|
cell = worksheet.Cells[x, y++];
|
cell.Value = item.AccountName;
|
cell = worksheet.Cells[x, y++];
|
cell.Value = item.SubjectName;
|
cell = worksheet.Cells[x, y++];
|
cell.Value = item.Money;
|
cell = worksheet.Cells[x, y++];
|
cell.Value = item.AccountMoney;
|
cell = worksheet.Cells[x, y++];
|
cell.Value = item.PaymentUnit;
|
cell = worksheet.Cells[x, y++];
|
cell.Value = item.CreaterName;
|
cell = worksheet.Cells[x, y++];
|
cell.Value = item.OperationalMatters;
|
cell = worksheet.Cells[x, y++];
|
cell.Value = item.Remark;
|
cell = worksheet.Cells[x, y++];
|
cell.Value = item.CreatetimeName;
|
|
|
|
|
}
|
|
worksheet.Cells[worksheet.Dimension.Address].AutoFitColumns();
|
|
using (var stream = new MemoryStream())
|
{
|
ep.SaveAs(stream);
|
return new FileContentResult(stream.ToArray(),
|
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")
|
{
|
FileDownloadName = "导出收入支出资料" + DateTime.Now.ToString("yyyyMMdd") + ".xlsx"
|
};
|
}
|
|
|
|
|
}
|
|
|
|
public IActionResult print(FiAccountRecordDTOSearch search)
|
{
|
|
search.rows = 10000;
|
search.page = 1;
|
List<FiAccountRecordDTO> fiAccountRecordDTOs = _iFiAccountRecordService.SearchByPaging(search).DataList as List<FiAccountRecordDTO>;
|
ViewBag.listLiaotianDTO = fiAccountRecordDTOs;
|
decimal? shouru = fiAccountRecordDTOs.Where(x => x.RecordTypeId == "1").Sum(x => x.Money);
|
decimal? zhichu = fiAccountRecordDTOs.Where(x => x.RecordTypeId == "2").Sum(x => x.Money);
|
|
ViewBag.shourusum = shouru.HasValue? shouru.Value.ToString("F2") : "0.00";
|
|
ViewBag.zhichusum = zhichu.HasValue ? zhichu.Value.ToString("F2") : "0.00";
|
|
return View();
|
}
|
|
}
|
}
|
