/// <summary>
/// 发票保存
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public static string FaPiaoSave(InputDto input)
{
var sb = new StringBuilder();
//
sb.AppendLine($@"
-- 保存发票
INSERT INTO po_invoice (
cinvoiceid, pk_corp, vinvoicecode, iinvoicetype, cdeptid, cfreecustid, cvendormangid, cvendorbaseid, cemployeeid
, dinvoicedate, darrivedate, cbiztype, caccountbankid, cpayunit, finitflag, cvoucherid, ctermprotocolid, coperator
, caccountyear, cbilltype, ibillstatus, dauditdate, cauditpsn, vmemo, vdef1, vdef2, vdef3, vdef4, vdef5, vdef6
, vdef7, vdef8, vdef9, vdef10, vdef11, vdef12, vdef13, vdef14, vdef15, vdef16, vdef17, vdef18, vdef19, vdef20
, pk_defdoc1, pk_defdoc2, pk_defdoc3, pk_defdoc4, pk_defdoc5, pk_defdoc6, pk_defdoc7, pk_defdoc8, pk_defdoc9
, pk_defdoc10, pk_defdoc11, pk_defdoc12, pk_defdoc13, pk_defdoc14, pk_defdoc15, pk_defdoc16, pk_defdoc17
,pk_defdoc18, pk_defdoc19, pk_defdoc20, dr, cstoreorganization, pk_purcorp, tmaketime, taudittime, tlastmaketime
, invoicenum, bjtgyflag ,ts
) values
(
'100966100000000SLB1G' -- cinvoiceid 主键 发票ID
, '1009'
, 'My_FaPiaoWeiHu_0128001'
, '0'
, '1009A8100000000000RL', NULL, '0001O110000000020Q6S', '0001O1100000000209N1'
, '1002O11000000002JQYD', '2021-01-28', '2021-01-28', '0001O110000000001GTR'
, NULL, '0001O110000000020Q6S', '0', NULL, NULL, '000166100000001HGVJC'
, '2021', '25', '0', NULL, NULL, '备注', NULL, NULL, NULL, NULL, NULL, NULL
, '500.00', '4', '销售部', '深圳', '报销事由_0128001，2938元', '2938.00'
, NULL, NULL, NULL, NULL, '是', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
, NULL, '0001O11000000013MKEG', '0001O1100000000FMC20', NULL, NULL, NULL, NULL, NULL, NULL
, '0001O11000000002S8KM', NULL, NULL, NULL, '0', '1009O1100000000000T0', '1009', '2021-02-01 11:25:04'
, NULL, '2021-02-01 11:25:04', 'My_fph_0128001', 'N', '2021-02-01 11:25:05'
);
");
return(sb.ToString());
}
/// <summary>
/// 应付单审核
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public static string YFApproval(InputDto input)
{
var sb = new StringBuilder();
//更新主表状态
var dateStr = input.BillDate.ToString("yyyy-MM-dd");
sb.AppendLine($@"
-- 应付单审核
update ARAP_DJZB set ts = '{GetDateTimeString()}'
, sxbz = 10
, sxr = '{input.Creator}'
, sxkjnd = '{input.BillDate:yyyy}'
, sxkjqj = '{input.BillDate:MM}'
, sxrq = '{dateStr}'
where vouchid = '{input.YFVouchid}';
update arap_djzb set ts = '{GetDateTimeString()}'
, spzt = '1'
, djzt = 2
, sxbz = 10
, shr = '{input.Creator}'
, shkjnd = '{input.BillDate:yyyy}'
, shkjqj = '{input.BillDate:MM}'
, shrq = '{dateStr}'
, sxr = '{input.Creator}'
, sxkjnd = '{input.BillDate:yyyy}'
, sxkjqj = '{input.BillDate:MM}'
, sxrq = '{dateStr}'
where vouchid = '{input.YFVouchid}' and djzt = 1;
");
return(sb.ToString());
input.DapRtvouchKey = $"{input.DwbmParentId}6610000000{input.RandNo}CF";
//生成 实时凭证
sb.AppendLine($@"
-- 生成 实时凭证
insert into
dap_rtvouch(
pk_voucher, pk_corp, year, period, type, no, prepareddate, tallydate, attachment, prepared, checker, casher
, manager, signflag, headmodflag, discardflag, sysid, addclass, deleteclass , assino,pk_glorg,pk_glbook
, def1,def2,def3,def4,def5,def6,def7,def8,def9,def10,freevalue1,freevalue2,freevalue3,freevalue4,freevalue5
,voucherkind,ts
)
values(
'{input.DapRtvouchKey}' -- pk_voucher 实时凭证主键 102266100000000VDLJU
,'{input.Dwbm}' -- pk_corp 单位编码 1009
,'{input.BillDate.Year}' -- year 会计年度
,'{input.BillDate:MM}' -- period 会计期间
,'0001O110000000020ZN7' -- type 凭证类别 0001O110000000020ZN3 0001O110000000020ZN7
, 0 -- no 凭证编码 integer
, '{input.BillDate:yyyy-MM-dd}' -- prepareddate 制单日期
, NULL -- tallydate 记帐日期
,{input.DanJuNum} -- attachment 附单据数
,NULL -- prepared 制单人
,NULL -- checker 审核人
,NULL -- casher 出纳
,NULL -- manager 记帐人
,NULL -- signflag 签字标志
,'YYYYYYYYYYYYYYY' -- headmodflag 修改标志
,NULL -- discardflag 作废标志
,'ARAP' -- sysid 制单系统
,NULL -- addclass 增加接口类
,NULL -- deleteclass 删除接口类
,NULL -- assino 业务关联号
,'{input.GlorgKey}' -- pk_glorg 会计主体
,'{input.GlbookKey}' -- pk_glbook 财务账簿
, def1,def2,def3,def4,def5,def6,def7,def8,def9,def10,freevalue1,freevalue2,freevalue3,freevalue4,freevalue5
,0 -- voucherkind 凭证类型
,'{GetDateTimeString()}' -- ts
);
");
// 实时凭证明细
var fuzhuID = $"1009O110000000003VI1";
for (int i = 0; i < input.GoodsList.Count; i++)
{
var item = input.GoodsList[i];
var detailId1 = $"{input.DwbmParentId}6610000000{input.RandNo + i}BE";
var detailId2 = $"{input.DwbmParentId}6610000000{input.RandNo + i}BD";
var detailId3 = $"{input.DwbmParentId}6610000000{input.RandNo + i}BC";
var iindex = i + 1;
sb.AppendLine($@"
-- 实时凭证明细
insert into
dap_rtvouch_b(
pk_detail, pk_voucher, pk_corp, iindex, fk_accsubj, id, explanation, no,opposingsubj, price, excrate1, excrate2, debitaquality
, debitamount, fracdebitamount, localdebitamount, creditquality, creditamount, fraccreditamount, localcreditamount, modifyflag
, reciepclass, pk_currtype
-- , fk_jsfs, checkno, checkdate,pk_innercorp
-- ,def1,def2,def3,def4,def5,def6,def7,def8,def9,def10,def11
-- ,def12,def13,def14,def15,def16,def17,def18,def19,def20,def21,def22,def23,def24,def25,def26,def27,def28,def29,def30,freevalue1
-- ,freevalue2,freevalue3,freevalue4,freevalue5,freevalue6,freevalue7,freevalue8,freevalue9,freevalue10,freevalue11,freevalue12
-- ,freevalue13,freevalue14,freevalue15,freevalue16,freevalue17,freevalue18,freevalue19,freevalue20,freevalue21,freevalue22
-- ,freevalue23,freevalue24,freevalue25,freevalue26,freevalue27,freevalue28,freevalue29,freevalue30
-- ,tradeno,tradedate ,fk_pjlx,pk_account,pk_contract,startrestdate,assino,coorno,creditsign,bankcode
,pk_glorg,pk_glbook,ts
) values(
'{detailId1}' -- pk_detail 实时凭证分录主键
,'{input.DapRtvouchKey}' -- pk_voucher 实时凭证主键
,'{input.Dwbm}' -- pk_corp 公司编码
,{iindex} -- iindex 分录号，从1开始
, fk_accsubj 科目编码
, id 辅助核算标识
, explanation
, no,opposingsubj, price, excrate1, excrate2, debitaquality
, debitamount, fracdebitamount, localdebitamount, creditquality, creditamount, fraccreditamount, localcreditamount, modifyflag
, reciepclass, pk_currtype
-- , fk_jsfs, checkno, checkdate,pk_innercorp
-- ,def1,def2,def3,def4,def5,def6,def7,def8,def9,def10,def11
-- ,def12,def13,def14,def15,def16,def17,def18,def19,def20,def21,def22,def23,def24,def25,def26,def27,def28,def29,def30,freevalue1
-- ,freevalue2,freevalue3,freevalue4,freevalue5,freevalue6,freevalue7,freevalue8,freevalue9,freevalue10,freevalue11,freevalue12
-- ,freevalue13,freevalue14,freevalue15,freevalue16,freevalue17,freevalue18,freevalue19,freevalue20,freevalue21,freevalue22
-- ,freevalue23,freevalue24,freevalue25,freevalue26,freevalue27,freevalue28,freevalue29,freevalue30
-- ,tradeno,tradedate ,fk_pjlx,pk_account,pk_contract,startrestdate,assino,coorno,creditsign,bankcode
,pk_glorg,pk_glbook,ts
);
");
}
return(sb.ToString());
}
public string JeiSuan(InputDto input)
{
return("");
#region 付款单结算
/*
* for (int i = 0; i < goodsList.Count; i++)
* {
* var item = goodsList[i];
*
* sb.AppendLine($@"
* -- 付款单结算 附表 （{i + 1}/{goodsList.Count}）
*
* update arap_djfb set ts='{DateTime.Now:yyyy-MM-dd HH:mm:ss}'
* ,payman = '{creator}' -- payman 支付人 000166100000001HGVJC
* , paydate = '{date:yyyy-MM-dd}' -- paydate 支付日期 2021-01-15
* , payflag = 1 -- payflag 支付状态 1
* where fb_oid = '{item.FkItemBillNo}';
*
* ");
* }
*
* sb.AppendLine($@"
* -- 付款单结算
* update arap_djzb set ts='{DateTime.Now:yyyy-MM-dd HH:mm:ss}'
* ,payman = '{creator}'
* , paydate = '{date:yyyy-MM-dd}'
* , jszxzf = 3 -- jszxzf 结算中心支付
* , zzzt = 1 -- zzzt 支付状态
* where vouchid = '{fk_vouchid}';
*
* ");
*
#endregion
*
#region 添加结算信息
*
* sb.AppendLine($@"
* -- 结算信息 cmp_settlement
* INSERT INTO cmp_settlement (
* iswagelisting, isbusicontrol, pk_finorg, busistatus, settlestatus, arithmetic, effectstatus, busi_billdate
* , pk_settlement, isbusieffect, pk_operator, def7, def8, def5, def6, def9, systemcode, pk_tradetype, pk_ftsbill
* , pk_executor, lastupdatedate, iscmcandeal, busi_auditdate, settletype, pk_busibill, def20, def4, pk_signer
* , def3, def2, def1, def12, def13, def10, pk_auditor, def11, isautosign, isautopay, direction, def18, def19, def16
* , def17, def14, def15, isautogenerate, pk_busitype, dr, isapplybill, pk_corp, billcode, payway, signdate, issettleeffect
* , setlledate, fts_billtype, setlleno, primal, pk_billoperator, ispay, local, aduitstatus, lastupdater ,ts
* )
* VALUES
* (
* NULL, -- iswagelisting 是否携带工资清单
* NULL, -- isbusicontrol 是否业务控制数据处理
* NULL, -- pk_finorg 财务组织（预留）
* 4, -- busistatus 业务单据状态 2,4
* 5, -- settlestatus 结算状态 0,5 Update
* 0, -- arithmetic 结算信息处理算法
* 10 -- effectstatus 业务单据生效状态 0,10 Update
* ,'{dateStr}' -- busi_billdate 业务单据日期
* ,'{pk_settlement}' -- pk_settlement 主键 11076610000000009NTX
* ,'Y' -- isbusieffect 业务单据是否已生效 Update
* ,'{creator}' -- pk_operator 录入人
* ,NULL, NULL, NULL, NULL, NULL -- def7, def8, def5, def6, def9, ,
* ,'arap' -- systemcode 归属系统 归属系统
* , 'D3' -- pk_tradetype 业务单单据类型 D3付款单 D1采购应付单
* ,NULL -- pk_ftsbill 委托收付款单主键
* ,'{creator}' -- pk_executor 结算人 Update
* ,'{dateStr}' -- lastupdatedate 最新更新日期
* ,'Y' -- iscmcandeal 是否结算平台可处理
* ,'{dateStr}' -- busi_auditdate 业务单据审核日期 Update
* ,0 -- settletype 完成结算方式 0
* ,'{fk_vouchid}' -- pk_busibill 付款单 主键 11076610000000009NTT
* ,NULL, NULL -- def20, def4
* ,'{creator}' -- pk_signer 签字确认人 Update
* , NULL, NULL, NULL, NULL, NULL, NULL -- def3, def2, def1, def12, def13, def10
* ,'{creator}' -- pk_auditor 业务单据审核人
* ,NULL -- def11 自定义项
* ,'Y' -- isautosign 是否自动签字
* ,NULL -- isautopay 是否自动支付
* ,1 -- direction 方向
* , NULL, NULL, NULL, NULL, NULL, NULL -- def18, def19, def16, def17, def14, def15
* , NULL -- isautogenerate 是否自动生成
* ,'0001O110000000001GTR' -- pk_busitype 单据业务类型 0001O110000000001GTE 一般采购业务； 0001O110000000001GTR 采购补录业务
* ,0 -- dr 删除标志
* ,'N' -- isapplybill 收付申请单
* ,'{dwbm}' -- pk_corp 公司pk
* , '{fkDanJuHao}' -- billcode 付款单 业务单据编号 FK***21012500007
* , NULL -- payway 收付款方式
* ,'{dateStr}' -- signdate 签字确认日期 Update
* ,'N' -- issettleeffect 结算单是否生效
* , '{dateStr}' -- setlledate 结算日期
* , NULL -- fts_billtype 委托收付款单单据类型
* , '{setlleno}' -- setlleno 结算号 Update
* , {taxTotal:F2} -- primal 原币金额
* , '{creator}' -- pk_billoperator 业务单据录入人
* , 'Y' -- ispay 是否委付
* , {taxTotal * huilv:F2} -- local 本币金额
* , 0 -- aduitstatus 业务单据审批状态 0
* , '{creator}' -- lastupdater 最新更新人
* , '{GetDateTimeString()}' -- ts 时间戳
*
* );
*
* ");
*
* for (int i = 0; i < goodsList.Count; i++)
* {
* var item = goodsList[i];
*
* sb.AppendLine($@"
* -- 结算明细 cmp_detail
* INSERT INTO cmp_detail (
* settlelineno, lastest_paydate, isacccord, pk_finorg, oppbank, pk_notetype, pk_account, processtype, expectate_date
* , issamebank, def7, def8, def5, def6, def9, systemcode, tallystatus, oppaccount, checkcount, def4, fundformcode
* , def3, def2, def1, def12, pk_psndoc, def13, def10, def11, memo, paylocal, def18, def19, def16, def17, def14, def15
* , pk_balatype, billtime, checkdate, fracrate, pk_busitype, pk_oppbank, pk_innercorp, bankrelated_code, pk_trader
* , dr, transtype, pk_billdetail, tradertype, signdate, pk_cashflow, tradername, pk_job, pk_deptdoc, busilineno
* , exectime, tallydate, pk_paybill, settlestatus, pk_rescenter, execdate, pk_currtype, pay_type, signtime, pk_settlement
* , pk_bill, pk_billtype, receivelocal, payfrac, code, localrate, modifyflag, pk_jobphase, paybillcode, fundsflag
* , def20, bankmsg, notenumber, pk_detail, pk_invcl, pk_plansubj, pk_cubasdoc, notedirection, pk_assaccount, direction
* , pk_bank, groupno, pk_oppaccount, pk_invbasdoc, billdate, pay, receivefrac, receive
* , pk_costsubj, pk_corp, billcode, issamecity, pk_billbalatype, pk_mngaccount, isbillrecord ,ts
* )
* VALUES
* (
* {i} -- settlelineno 结算单行号
* , NULL -- lastest_paydate 最迟支付日期
* , 'N' -- isacccord 是否记账记录
* -- pk_finorg, oppbank, pk_notetype, pk_account, processtype, expectate_date, issamebank, def7, def8, def5, def6, def9
* , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
* , 'arap' -- systemcode 来源系统
* , 4 -- tallystatus 记账状态 1->4
* , NULL -- oppaccount 对方银行账号
* , 0 -- checkcount 对帐次数
* , NULL -- def4
* , 3 -- fundformcode 资金形态
* , NULL, NULL, NULL, NULL -- def3, def2, def1, def12
* , '{ywybm}' -- pk_psndoc 人员档案
* , NULL, NULL, NULL -- def13, def10, def11
* -- memo 摘要
* , '{zy}'
* , {item.TaxTotal} -- paylocal 付款本币
* , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL -- def18, def19, def16, def17, def14, def15 pk_balatype 结算方式, billtime 单据时间
* , '{dateStr}' -- checkdate 对账日期
* , NULL -- fracrate 辅币汇率
* , '0001O110000000001GTR' -- pk_busitype 业务类型 0001O110000000001GTE 一般采购业务员；0001O110000000001GTR 采购补录业务
* , '{bankNumber}' -- pk_oppbank 对方银行主键
* , NULL, NULL -- pk_innercorp 内部单位, bankrelated_code 银行标识码
* , '{hbbm}' -- pk_trader 对方 供应商 主键 0001O11000000009FZVJ
* , 0 -- dr 删除标志
* , 1 -- transtype 交易种类
* , '{item.FkItemBillNo}' -- pk_billdetail 来源单据行id
* , 0 -- tradertype 对方类型
* , '{dateStr}' -- signdate 签字确认日期 Update
* , NULL, NULL -- pk_cashflow 现金流量项目, tradername 对方对象名称
* , '{jobid}' -- pk_job 项目
* , '{deptid}' -- pk_deptdoc 部门 11076610000000009JDD
* , 0 -- busilineno 业务单据行号
* , NULL -- exectime 转帐成功时间
* , '{dateStr}' -- tallydate 结算日期 Update
* , NULL -- pk_paybill 支付单ID
* , 5 -- settlestatus 结算状态 Update NULL->5 已结算
* , NULL -- pk_rescenter 责任中心
* , NULL -- execdate 转帐成功日期
* , '{bizhong}' -- pk_currtype 币种
* , NULL -- pay_type 汇款速度
* , NULL -- signtime 签字时间
* , '{pk_settlement}' -- pk_settlement 结算信息主键
* , '{fk_vouchid}' -- pk_bill 付款单主键 来源单据id
* , 'D3' -- pk_billtype 来源单据类型 D3付款单
* , 0 -- receivelocal 收款本币
* , 0 -- payfrac 付款辅币
* , 'MCNzb2Z0c2lnbra40mJOBdblHlI2sfA13+3a1ghspL3IHSE9wn4=' -- code 数字签名 Update
* , {huilv} -- localrate 本币汇率
* , 'n,n,n,n,n,n,n,n,n,n,n,n,n' -- modifyflag 手工修改标志
* , NULL -- pk_jobphase 项目阶段
* , NULL -- paybillcode 结算号
* , 1 -- fundsflag 资金流向
* , NULL, NULL, NULL -- def20,bankmsg 银行返回信息,notenumber 票据号
* , '{pk_settlement}.{i + 1}' -- pk_detail 银行账主键 主键 11076610000000009NTY
* , NULL, NULL -- pk_invcl 存货分类，pk_plansubj 计划项目
* , '{hbbm}' -- pk_cubasdoc 供应商主键
* , 0 -- notedirection 票据方向
* , NULL -- pk_assaccount 辅助帐号
* , 1 -- direction 方向
* , NULL, NULL -- pk_bank 本方银行主键, groupno 分组号
* , '{bankNumber}' -- pk_oppaccount 对方帐户主键
* , '{item.GoodsNCCode}' -- pk_invbasdoc 存货档案
* , '{dateStr}' -- billdate 单据日期
* , {item.TaxTotal:F2} -- pay 付款原币
* , 0 -- receivefrac 收款辅币
* , 0 -- receive 收款原币
* , NULL -- pk_costsubj 收支项目
* , '{dwbm}' -- pk_corp 单位公司
* , '{fkDanJuHao}' -- billcode 单据编号
* , NULL, NULL, NULL, NULL -- issamecity 同城标志, pk_billbalatype 协议结算方式, pk_mngaccount 管理账户, isbillrecord 是否单据记录
* , '{GetDateTimeString()}'
* );
*
*
* ");
* }
*/
#endregion
}