void GenerateVoucher(string taskId, List <VoucherHeader> lstHeader, List <VoucherEntry> lstEntries, Dictionary <string, Dictionary <string, Dictionary <string, object> > > lstUdefenties)
{
var success = true;
var sb = new StringBuilder();
foreach (var header in lstHeader)
{
if (!lstEntries.Exists(e => e.linkNo == header.linkNo))
{
sb.AppendLine(string.Format("关联单号[{0}]生成凭证失败，未找到关联的分录;", header.linkNo));
success = false;
continue;
}
var voucher = new Voucher();
voucher.header = header;
voucher.entries = lstEntries.FindAll(e => e.linkNo == header.linkNo);
if (lstUdefenties.ContainsKey(header.linkNo))
{
voucher.udefenties = lstUdefenties[header.linkNo];
}
try
{
var id = VoucherService.GetInstance(mContext).Add(voucher);
var h = VoucherService.GetInstance(mContext).FindHeader(id);
sb.AppendLine(string.Format("关联单号[{0}]生成凭证成功，凭证字号：{1} - {2};", header.linkNo, h.word, h.no));
}
catch (Exception ex)
{
sb.AppendLine(string.Format("关联单号[{0}]生成凭证失败，{1};", header.linkNo, ex.Message));
success = false;
}
}
RefreshTaskResult(taskId, ExecTaskType.CreateVoucher.ToString(), 100, "", sb.ToString(), success?1:0);
}
/// <summary>
/// 统计发生额
/// </summary>
/// <param name="year"></param>
/// <param name="perid"></param>
/// <returns></returns>
public List <AccountAmountItem> QueryOccurs(long beginYear, long beginPerid, long endYear, long endPerid)
{
VoucherService voucherService = new VoucherService(mContext);
Dictionary <string, object> filter = new Dictionary <string, object>();
filter.Add("beginYear", beginYear);
filter.Add("beginPerid", beginPerid);
filter.Add("endYear", endYear);
filter.Add("endPerid", endPerid);
var lst = voucherService.List(filter);
Dictionary <long, AccountAmountItem> dict = new Dictionary <long, AccountAmountItem>();
foreach (Voucher v in lst)
{
foreach (VoucherEntry entry in v.entries)
{
if (!dict.ContainsKey(entry.accountSubjectId))
{
dict.Add(entry.accountSubjectId, new AccountAmountItem {
accountSubjectId = entry.accountSubjectId
});
}
if (entry.direction == 1)
{
dict[entry.accountSubjectId].debitsAmount += entry.amount;
}
else
{
dict[entry.accountSubjectId].creditAmount += entry.amount;
}
}
}
return(dict.Values.ToList());
}
void ExecCarriedForward(string taskId, string procName, Dictionary <string, object> paramMap)
{
if (paramMap == null)
{
paramMap = new Dictionary <string, object>();
}
RefreshTaskResult(taskId, ExecTaskType.CarriedForward.ToString(), 0, "开始执行", "");
Auxiliary auxFilter = new Auxiliary()
{
type = (int)AuxiliaryType.CarriedForward, no = procName
};
var lst = DataManager.GetInstance(mContext).Query(auxFilter);
if (lst == null || lst.Count == 0)
{
throw new FinanceException(FinanceResult.RECORD_NOT_EXIST, "结转方式不存在");
}
var auxObj = lst.FirstOrDefault();
var templateList = TemplateSevice.GetInstance(mContext).ListCarriedForwardTemplate(auxObj.id);
if (templateList == null || templateList.Count == 0)
{
throw new FinanceException(FinanceResult.RECORD_NOT_EXIST, "结转模板不存在");
}
var year = SystemProfileService.GetInstance(mContext).GetInt(SystemProfileCategory.Account, SystemProfileKey.CurrentYear);
var period = SystemProfileService.GetInstance(mContext).GetInt(SystemProfileCategory.Account, SystemProfileKey.CurrentPeriod);
var dbHelper = DBHelper.GetInstance(mContext);
//1、检查是否还有未过账
if (dbHelper.Exist(string.Format("select 1 from _VoucherHeader where _year = {0} and _period = {1} and _status < {2} and _status <> {3}"
, year, period, (int)VoucherStatus.Posted, (int)VoucherStatus.Canceled)))
{
throw new FinanceException(FinanceResult.INCORRECT_STATE, "当前凭证没有全部过账");
}
//2、生成凭证
var direction = 1;
switch (auxObj.description)
{
case "income":
break;
case "cost":
direction = -1;
break;
case "investment":
break;
case "profits":
break;
}
var word = "转";
if (paramMap.ContainsKey("word"))
{
word = paramMap["word"].ToString();
}
var explanation = auxObj.name;
if (paramMap.ContainsKey("explanation"))
{
explanation = paramMap["explanation"].ToString();
}
var lstAccountObject = AccountSubjectService.GetInstance(mContext).List();
var lstEntries = new List <VoucherEntry>();
var index = 0;
foreach (var temp in templateList)
{
var srcActObj = lstAccountObject.FirstOrDefault(actObj => actObj.id == temp.src);
var dstActObj = lstAccountObject.FirstOrDefault(actObj => actObj.id == temp.dst);
if (srcActObj == null || dstActObj == null)
{
throw new FinanceException(FinanceResult.RECORD_NOT_EXIST, "结转模板数据错误");
}
var amountObj = dbHelper.ExecuteScalar(string.Format(@"select sum(_amount * _direction) as _amount
from _VoucherEntry where _accountSubjectId = {0}
and _id in (select _id from _VoucherHeader where _year = {1} and _period = {2})", temp.src, year, period));
if (amountObj == null || amountObj == DBNull.Value)
{
continue;
}
var amount = (decimal)amountObj;
if (amount < 0)
{
direction = -1 * direction;
amount = -1 * amount;
}
var voucherEntrySrc = new VoucherEntry();
voucherEntrySrc.index = index++;
voucherEntrySrc.accountSubjectId = temp.src;
voucherEntrySrc.accountSubjectNo = srcActObj.no;
voucherEntrySrc.amount = amount;
voucherEntrySrc.direction = direction;
voucherEntrySrc.explanation = explanation;
lstEntries.Add(voucherEntrySrc);
var voucherEntryDst = new VoucherEntry();
voucherEntryDst.index = index++;
voucherEntryDst.accountSubjectId = temp.dst;
voucherEntryDst.accountSubjectNo = dstActObj.no;
voucherEntryDst.amount = amount;
voucherEntryDst.direction = -1 * direction;
voucherEntryDst.explanation = explanation;
lstEntries.Add(voucherEntryDst);
}
if (lstEntries.Count == 0)
{
throw new FinanceException(FinanceResult.RECORD_NOT_EXIST, "没有需要结转的凭证");
}
var voucherHeader = new VoucherHeader();
voucherHeader.word = word;
voucherHeader.year = year;
voucherHeader.period = period;
voucherHeader.date = CommonUtils.CalcMaxPeriodDate(year, period);
var now = DateTime.Now;
voucherHeader.businessDate = now;
voucherHeader.creatTime = now;
voucherHeader.creater = 13594;
Voucher voucher = new Voucher();
voucher.header = voucherHeader;
voucher.entries = lstEntries;
var id = VoucherService.GetInstance(mContext).Add(voucher);
var h = VoucherService.GetInstance(mContext).FindHeader(id);
var msg = string.Format("结转成功，凭证字号：{0} - {1};", h.word, h.no);
RefreshTaskResult(taskId, ExecTaskType.CreateVoucher.ToString(), 100, "", msg, 1);
}
