1125 lines
42 KiB
C#
1125 lines
42 KiB
C#
using ADODB;
|
|
using log4net;
|
|
using Microsoft.VisualBasic;
|
|
using MSXML2;
|
|
using System;
|
|
using System.Collections.Generic;
|
|
using System.Diagnostics;
|
|
using System.Linq;
|
|
using System.Reflection.Emit;
|
|
using System.Text;
|
|
using System.Threading.Tasks;
|
|
using System.Xml.Linq;
|
|
using UFGeneralFilterOCX;
|
|
using UFIDA.U8.Framework.Api.ControlObject.Common;
|
|
using UFIDA.U8.Framework.Api.ControlObject.Entity;
|
|
using UFIDA.U8.Framework.Api.ControlObject.ST;
|
|
using UFIDA.U8.Framework.Api.ControlObject.U8M;
|
|
// ReSharper disable InconsistentNaming
|
|
|
|
namespace UFIDA.U8.Framework.Api.ControlObject.PU
|
|
{
|
|
/// <summary>
|
|
/// 采购管理
|
|
/// </summary>
|
|
public class clsVoucherCO_PU
|
|
{
|
|
protected readonly ILog _logInfo = LogManager.GetLogger("logInfo");
|
|
|
|
private dynamic InitCo(BaseLogin login, vouchertype enmVoucherType, bool bPositive = true, string sBillType = null, string sBusType = null, UseMode UserMode = UseMode.CS, string sOverDetailsXml = null)
|
|
{
|
|
var errorMsg = "";
|
|
|
|
var infor = "Info_PU.ClsS_Infor".GetComObject();
|
|
|
|
errorMsg = infor.Init(login._vbLogin, sBusType);
|
|
|
|
if (!string.IsNullOrWhiteSpace(errorMsg))
|
|
{
|
|
throw new Exception(errorMsg);
|
|
}
|
|
|
|
var co = "VoucherCO_PU.clsVoucherCO_PU".GetComObject();
|
|
|
|
co.Init(enmVoucherType, login._vbLogin, login.Connection, infor, bPositive, sBillType, sBusType, UserMode, sOverDetailsXml);
|
|
|
|
return co;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 保存单据
|
|
/// </summary>
|
|
/// <param name="baseLogin"></param>
|
|
/// <param name="dictionary"></param>
|
|
/// <param name="cardNumber"></param>
|
|
/// <param name="enmVoucherType"></param>
|
|
/// <param name="bPositive"></param>
|
|
/// <param name="sBillType"></param>
|
|
/// <param name="sBusType"></param>
|
|
/// <param name="VoucherState"></param>
|
|
/// <param name="UserMode"></param>
|
|
/// <param name="sOverDetailsXml"></param>
|
|
/// <param name="bGetCode"></param>
|
|
/// <param name="codeKey"></param>
|
|
/// <param name="bAudit"></param>
|
|
/// <param name="bPrintDom"></param>
|
|
/// <param name="iswfcontrolled"></param>
|
|
/// <param name="cFlowFieldName"></param>
|
|
/// <returns></returns>
|
|
public async Task<BaseResult<string>> VoucherSave(BaseLogin baseLogin, Dictionary<string, object> dictionary, string cardNumber, vouchertype enmVoucherType, bool bPositive = true, string sBillType = null, string sBusType = null, int VoucherState = 2, UseMode UserMode = UseMode.CS, string sOverDetailsXml = null, bool bGetCode = false, string codeKey = null, bool bAudit = false, bool bPrintDom = false,bool iswfcontrolled=false,string cFlowFieldName= "IsWfControlled")
|
|
{
|
|
try
|
|
{
|
|
var errorMsg = "";
|
|
_logInfo.Debug("开始输出登录信息");
|
|
_logInfo.Debug(baseLogin._vbLogin.userToken);
|
|
|
|
var co = InitCo(baseLogin, enmVoucherType, bPositive, sBillType, sBusType, UserMode, sOverDetailsXml);
|
|
|
|
IXMLDOMDocument2 domHead = new DOMDocument();
|
|
IXMLDOMDocument2 domBody = new DOMDocument();
|
|
IXMLDOMDocument2 domCur = new DOMDocument();
|
|
|
|
_logInfo.Debug("开始获取单据默认模板...");
|
|
co.GetVoucherData(ref domHead, ref domBody, "1=2");
|
|
|
|
_logInfo.Debug("填充表头DOM...");
|
|
|
|
domHead = dictionary.ToDocument2(domHead);
|
|
|
|
if (!dictionary.TryGetValue("body", out var bodys))
|
|
{
|
|
await Task.Delay(1);
|
|
throw new Exception("无法获取表体数据");
|
|
}
|
|
|
|
if (!(bodys is List<Dictionary<string, object>> dictionarys) || dictionarys.Count <= 0)
|
|
{
|
|
await Task.Delay(1);
|
|
throw new Exception("无法获取表体数据");
|
|
}
|
|
|
|
if (bGetCode)
|
|
{
|
|
errorMsg = "";
|
|
var newCode = "";
|
|
|
|
if (!co.GetVoucherNO(ref domHead, $"{enmVoucherType}", ref errorMsg, ref newCode))
|
|
{
|
|
throw new Exception(errorMsg);
|
|
}
|
|
|
|
_logInfo.Debug($"获取新单号:{newCode}");
|
|
|
|
if (!string.IsNullOrWhiteSpace(newCode))
|
|
{
|
|
domHead.SetDomKeyValue(codeKey, newCode);
|
|
}
|
|
}
|
|
|
|
_logInfo.Debug("填充表体DOM...");
|
|
domBody = dictionarys.ToDocument2(domBody);
|
|
|
|
if (bPrintDom)
|
|
{
|
|
_logInfo.Debug("开始输入DOM...");
|
|
|
|
_logInfo.Debug(domHead.xml);
|
|
|
|
_logInfo.Debug(domBody.xml);
|
|
}
|
|
|
|
object vouchId = "";
|
|
IXMLDOMDocument2 domMsg = new DOMDocument();
|
|
IXMLDOMDocument2 curDom = new DOMDocument();
|
|
|
|
|
|
|
|
|
|
_logInfo.Debug($"{baseLogin.Connection.State},{baseLogin.Connection.ConnectionString}");
|
|
|
|
_logInfo.Debug("开始查询单据配置...");
|
|
var vouchers = CommonHelper.GetVouchers(baseLogin.Connection, cardNumber);
|
|
|
|
var res = new BaseResult<string>();
|
|
|
|
if (bAudit)
|
|
{
|
|
_logInfo.Debug("开始事务...");
|
|
co.bOutTrans = true;
|
|
|
|
baseLogin.Connection.BeginTrans();
|
|
}
|
|
|
|
try
|
|
{
|
|
|
|
_logInfo.Debug("开始保存...");
|
|
|
|
errorMsg = bAudit
|
|
? (string)co.VoucherSave2(ref domHead, ref domBody, VoucherState, ref vouchId, sOverDetailsXml, ref domMsg)
|
|
: (string)co.VoucherSave(ref domHead, ref domBody, VoucherState, ref vouchId, ref curDom, UserMode, sOverDetailsXml, ref domMsg);
|
|
|
|
|
|
_logInfo.Debug("保存结束...");
|
|
_logInfo.Debug(errorMsg);
|
|
_logInfo.Debug($"{vouchId}");
|
|
|
|
res.bSuccess = string.IsNullOrWhiteSpace(errorMsg) && !string.IsNullOrWhiteSpace($"{vouchId}");
|
|
|
|
if (!res.bSuccess)
|
|
{
|
|
if (!string.IsNullOrWhiteSpace(errorMsg))
|
|
{
|
|
throw new Exception(errorMsg);
|
|
}
|
|
|
|
if (!string.IsNullOrWhiteSpace(domMsg.xml))
|
|
{
|
|
throw new Exception(domMsg.xml);
|
|
}
|
|
|
|
if (!string.IsNullOrWhiteSpace(curDom.xml))
|
|
{
|
|
throw new Exception(curDom.xml);
|
|
}
|
|
|
|
throw new Exception("未知错误");
|
|
|
|
}
|
|
|
|
if (iswfcontrolled == false && VoucherState == 2)
|
|
{
|
|
var strSql = $"UPDATE {vouchers.cBTTblName} SET {cFlowFieldName} = 0 WHERE {vouchers.voucherIdFieldName}={vouchId}";
|
|
|
|
object rsts = new Recordset();
|
|
|
|
baseLogin.Connection.Execute(strSql,out rsts);
|
|
}
|
|
|
|
|
|
res.voucherCode = CommonHelper.GetVoucherCode(baseLogin.Connection, vouchId, vouchers);
|
|
res.voucherId = $"{vouchId}";
|
|
res.result = errorMsg;
|
|
|
|
}
|
|
catch (Exception)
|
|
{
|
|
try
|
|
{
|
|
if (bAudit)
|
|
baseLogin.Connection.RollbackTrans();
|
|
}
|
|
catch(Exception ex)
|
|
{
|
|
Trace.WriteLine(ex.Message);
|
|
}
|
|
|
|
throw;
|
|
}
|
|
|
|
|
|
if (!res.bSuccess)
|
|
{
|
|
res.message = "保存失败";
|
|
if (bAudit)
|
|
baseLogin.Connection.RollbackTrans();
|
|
return res;
|
|
}
|
|
|
|
res.message = "保存成功";
|
|
|
|
_logInfo.Debug($"{baseLogin.Connection.State},{baseLogin.Connection.ConnectionString}");
|
|
|
|
var strWhere = CommonHelper.GetVoucherWhereSqlById(vouchers, vouchId);
|
|
|
|
if (res.bSuccess && bAudit)
|
|
{
|
|
try
|
|
{
|
|
errorMsg = Confirm(co, baseLogin.Connection, enmVoucherType, res.voucherCode, res.voucherId, strWhere);
|
|
|
|
if (!string.IsNullOrWhiteSpace(errorMsg))
|
|
{
|
|
baseLogin.Connection.RollbackTrans();
|
|
|
|
throw new Exception(errorMsg);
|
|
}
|
|
}
|
|
catch (Exception)
|
|
{
|
|
baseLogin.Connection.RollbackTrans();
|
|
res.bSuccess = false;
|
|
throw;
|
|
}
|
|
}
|
|
|
|
|
|
|
|
if (bAudit)
|
|
{
|
|
_logInfo.Debug("提交事务...");
|
|
|
|
baseLogin.Connection.CommitTrans();
|
|
}
|
|
|
|
|
|
return res;
|
|
|
|
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
_logInfo.Error(ex.Message, ex);
|
|
|
|
await Task.Delay(1);
|
|
|
|
return new BaseResult<string> { bSuccess = false, message = "保存失败", result = ex.Message };
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// 批量审核单据(单号)
|
|
/// </summary>
|
|
/// <param name="baseLogin"></param>
|
|
/// <param name="sCardNum"></param>
|
|
/// <param name="enmVoucherType"></param>
|
|
/// <param name="cCodes"></param>
|
|
/// <param name="bPositive"></param>
|
|
/// <param name="sBillType"></param>
|
|
/// <param name="sBusType"></param>
|
|
/// <param name="UserMode"></param>
|
|
/// <param name="sOverDetailsXml"></param>
|
|
/// <returns></returns>
|
|
/// <exception cref="Exception"></exception>
|
|
public async Task<List<BaseResult<string>>> Confirm(BaseLogin baseLogin, string sCardNum, vouchertype enmVoucherType, List<string> cCodes, bool bPositive = true, string sBillType = null, string sBusType = null, UseMode UserMode = UseMode.CS, string sOverDetailsXml = null)
|
|
{
|
|
_logInfo.Debug("开始输出登录信息");
|
|
_logInfo.Debug(baseLogin._vbLogin.userToken);
|
|
|
|
var co = InitCo(baseLogin, enmVoucherType, bPositive, sBillType, sBusType, UserMode, sOverDetailsXml);
|
|
|
|
var conn = baseLogin.Connection;
|
|
|
|
var vouchers = CommonHelper.GetVouchers(conn, sCardNum);
|
|
|
|
var resList = new List<BaseResult<string>>();
|
|
|
|
foreach (var cCode in cCodes)
|
|
{
|
|
try
|
|
{
|
|
var strWhere = CommonHelper.GetPUVoucherWhereSqlByCode(vouchers, cCode);
|
|
|
|
var curId = CommonHelper.GetVoucherId(conn, cCode, vouchers);
|
|
|
|
var verifyResult = await Confirm(co, conn, enmVoucherType, cCode, curId, strWhere);
|
|
|
|
resList.Add(verifyResult);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
await Task.Delay(1);
|
|
_logInfo.Error(ex.Message, ex);
|
|
}
|
|
}
|
|
|
|
return resList;
|
|
|
|
}
|
|
|
|
/// <summary>
|
|
/// 批量审核单据(ID)
|
|
/// </summary>
|
|
/// <param name="baseLogin"></param>
|
|
/// <param name="sCardNum"></param>
|
|
/// <param name="enmVoucherType"></param>
|
|
/// <param name="vouchIds"></param>
|
|
/// <param name="bPositive"></param>
|
|
/// <param name="sBillType"></param>
|
|
/// <param name="sBusType"></param>
|
|
/// <param name="UserMode"></param>
|
|
/// <param name="sOverDetailsXml"></param>
|
|
/// <returns></returns>
|
|
/// <exception cref="Exception"></exception>
|
|
public async Task<List<BaseResult<string>>> Confirm(BaseLogin baseLogin, string sCardNum, vouchertype enmVoucherType, List<long> vouchIds, bool bPositive = true, string sBillType = null, string sBusType = null, UseMode UserMode = UseMode.CS, string sOverDetailsXml = null)
|
|
{
|
|
var co = InitCo(baseLogin, enmVoucherType, bPositive, sBillType, sBusType, UserMode, sOverDetailsXml);
|
|
|
|
var conn = baseLogin.Connection;
|
|
|
|
var vouchers = CommonHelper.GetVouchers(conn, sCardNum);
|
|
|
|
var resList = new List<BaseResult<string>>();
|
|
|
|
foreach (var vouchId in vouchIds)
|
|
{
|
|
var strWhere = CommonHelper.GetPUVoucherWhereSqlById(vouchers, vouchId);
|
|
|
|
var cCode = CommonHelper.GetVoucherCode(conn, vouchId, vouchers);
|
|
|
|
var verifyResult = await Confirm(co, conn, enmVoucherType, cCode, vouchId, strWhere);
|
|
|
|
resList.Add(verifyResult);
|
|
}
|
|
|
|
return resList;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 审核单据(单号)
|
|
/// </summary>
|
|
/// <param name="baseLogin"></param>
|
|
/// <param name="sCardNum"></param>
|
|
/// <param name="enmVoucherType"></param>
|
|
/// <param name="cCode"></param>
|
|
/// <param name="bPositive"></param>
|
|
/// <param name="sBillType"></param>
|
|
/// <param name="sBusType"></param>
|
|
/// <param name="UserMode"></param>
|
|
/// <param name="sOverDetailsXml"></param>
|
|
/// <returns></returns>
|
|
/// <exception cref="Exception"></exception>
|
|
public async Task<BaseResult<string>> Confirm(BaseLogin baseLogin, string sCardNum, vouchertype enmVoucherType, string cCode, bool bPositive = true, string sBillType = null, string sBusType = null, UseMode UserMode = UseMode.CS, string sOverDetailsXml = null)
|
|
{
|
|
var co = InitCo(baseLogin, enmVoucherType, bPositive, sBillType, sBusType, UserMode, sOverDetailsXml);
|
|
|
|
var conn = baseLogin.Connection;
|
|
|
|
var vouchers = CommonHelper.GetVouchers(conn, sCardNum);
|
|
|
|
var curId = CommonHelper.GetVoucherId(conn, cCode, vouchers);
|
|
|
|
var strWhere = CommonHelper.GetPUVoucherWhereSqlByCode(vouchers, cCode);
|
|
|
|
var verifyResult = await Confirm(co, conn, enmVoucherType, cCode, curId, strWhere);
|
|
|
|
return verifyResult;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 审核单据(ID)
|
|
/// </summary>
|
|
/// <param name="baseLogin"></param>
|
|
/// <param name="sCardNum"></param>
|
|
/// <param name="enmVoucherType"></param>
|
|
/// <param name="vouchId"></param>
|
|
/// <param name="bPositive"></param>
|
|
/// <param name="sBillType"></param>
|
|
/// <param name="sBusType"></param>
|
|
/// <param name="UserMode"></param>
|
|
/// <param name="sOverDetailsXml"></param>
|
|
/// <returns></returns>
|
|
/// <exception cref="Exception"></exception>
|
|
public async Task<BaseResult<string>> Confirm(BaseLogin baseLogin, string sCardNum, vouchertype enmVoucherType, long vouchId, bool bPositive = true, string sBillType = null, string sBusType = null, UseMode UserMode = UseMode.CS, string sOverDetailsXml = null)
|
|
{
|
|
var co = InitCo(baseLogin, enmVoucherType, bPositive, sBillType, sBusType, UserMode, sOverDetailsXml);
|
|
|
|
var conn = baseLogin.Connection;
|
|
|
|
var vouchers = CommonHelper.GetVouchers(conn, sCardNum);
|
|
|
|
var strWhere = CommonHelper.GetPUVoucherWhereSqlById(vouchers, vouchId);
|
|
|
|
var cCode = CommonHelper.GetVoucherCode(conn, vouchId, vouchers);
|
|
|
|
var verifyResult = await Confirm(co, conn, enmVoucherType, cCode, vouchId, strWhere);
|
|
|
|
return verifyResult;
|
|
|
|
}
|
|
|
|
/// <summary>
|
|
/// 审核单据
|
|
/// </summary>
|
|
/// <param name="voucherCO"></param>
|
|
/// <param name="conn"></param>
|
|
/// <param name="sVouchType"></param>
|
|
/// <param name="cCode"></param>
|
|
/// <param name="vouchId"></param>
|
|
/// <param name="strWhere"></param>
|
|
/// <returns></returns>
|
|
public async Task<BaseResult<string>> Confirm(dynamic voucherCO, Connection conn, vouchertype sVouchType, string cCode, object vouchId, string strWhere)
|
|
{
|
|
IXMLDOMDocument2 domHead = new DOMDocument();
|
|
IXMLDOMDocument2 domBody = new DOMDocument();
|
|
IXMLDOMDocument2 domMsg = new DOMDocument();
|
|
|
|
_logInfo.Debug("开始获取单据数据...");
|
|
voucherCO.GetVoucherData(ref domHead, ref domBody, strWhere);
|
|
|
|
var res = new BaseResult<string>
|
|
{
|
|
voucherCode = cCode,
|
|
voucherId = $"{vouchId}"
|
|
};
|
|
|
|
var errorMsg = "";
|
|
|
|
switch (sVouchType)
|
|
{
|
|
case vouchertype.采购请购单:
|
|
{
|
|
#if DEBUG
|
|
errorMsg = voucherCO.ConfirmApp(ref domHead);
|
|
#else
|
|
errorMsg = voucherCO.ConfirmApp(ref domHead, ref domMsg);
|
|
#endif
|
|
break;
|
|
}
|
|
case vouchertype.采购订单:
|
|
{
|
|
#if DEBUG
|
|
errorMsg = voucherCO.ConfirmPO(ref domHead, ref domMsg);
|
|
#else
|
|
errorMsg = voucherCO.ConfirmPO(ref domHead, ref domMsg,ref domBody);
|
|
#endif
|
|
break;
|
|
}
|
|
case vouchertype.采购到货单:
|
|
{
|
|
errorMsg = voucherCO.ConfirmArr(ref domHead);
|
|
break;
|
|
}
|
|
case vouchertype.采购发票:
|
|
{
|
|
errorMsg = voucherCO.ConfirmBill(ref domHead);
|
|
break;
|
|
}
|
|
default:
|
|
await Task.Delay(1);
|
|
errorMsg = "未知业务";
|
|
break;
|
|
}
|
|
|
|
res.bSuccess = string.IsNullOrWhiteSpace(errorMsg);
|
|
|
|
if (res.bSuccess)
|
|
{
|
|
res.message = "审核成功";
|
|
res.result = res.voucherId;
|
|
|
|
}
|
|
else
|
|
{
|
|
res.message = "审核失败";
|
|
res.result = string.IsNullOrWhiteSpace(errorMsg) ? domMsg.xml : errorMsg;
|
|
}
|
|
|
|
return res;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 批量弃审单据(单号)
|
|
/// </summary>
|
|
/// <param name="baseLogin"></param>
|
|
/// <param name="sCardNum"></param>
|
|
/// <param name="enmVoucherType"></param>
|
|
/// <param name="cCodes"></param>
|
|
/// <param name="bPositive"></param>
|
|
/// <param name="sBillType"></param>
|
|
/// <param name="sBusType"></param>
|
|
/// <param name="UserMode"></param>
|
|
/// <param name="sOverDetailsXml"></param>
|
|
/// <returns></returns>
|
|
/// <exception cref="Exception"></exception>
|
|
public async Task<List<BaseResult<string>>> CancelConfirm(BaseLogin baseLogin, string sCardNum, vouchertype enmVoucherType, List<string> cCodes, bool bPositive = true, string sBillType = null, string sBusType = null, UseMode UserMode = UseMode.CS, string sOverDetailsXml = null)
|
|
{
|
|
_logInfo.Debug("开始输出登录信息");
|
|
_logInfo.Debug(baseLogin._vbLogin.userToken);
|
|
|
|
var co = InitCo(baseLogin, enmVoucherType, bPositive, sBillType, sBusType, UserMode, sOverDetailsXml);
|
|
|
|
var conn = baseLogin.Connection;
|
|
|
|
var vouchers = CommonHelper.GetVouchers(conn, sCardNum);
|
|
|
|
var resList = new List<BaseResult<string>>();
|
|
|
|
foreach (var cCode in cCodes)
|
|
{
|
|
try
|
|
{
|
|
var strWhere = CommonHelper.GetPUVoucherWhereSqlByCode(vouchers, cCode);
|
|
|
|
var curId = CommonHelper.GetVoucherId(conn, cCode, vouchers);
|
|
|
|
var verifyResult = await CancelConfirm(co, conn, enmVoucherType, cCode, curId, strWhere);
|
|
|
|
resList.Add(verifyResult);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
await Task.Delay(1);
|
|
_logInfo.Error(ex.Message, ex);
|
|
}
|
|
}
|
|
|
|
return resList;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 批量弃审单据(ID)
|
|
/// </summary>
|
|
/// <param name="baseLogin"></param>
|
|
/// <param name="sCardNum"></param>
|
|
/// <param name="enmVoucherType"></param>
|
|
/// <param name="vouchIds"></param>
|
|
/// <param name="bPositive"></param>
|
|
/// <param name="sBillType"></param>
|
|
/// <param name="UserMode"></param>
|
|
/// <param name="sOverDetailsXml"></param>
|
|
/// <returns></returns>
|
|
/// <exception cref="Exception"></exception>
|
|
public async Task<List<BaseResult<string>>> CancelConfirm(BaseLogin baseLogin, string sCardNum, vouchertype enmVoucherType, List<long> vouchIds, bool bPositive = true, string sBillType = null, string sBusType = null, UseMode UserMode = UseMode.CS, string sOverDetailsXml = null)
|
|
{
|
|
var co = InitCo(baseLogin, enmVoucherType, bPositive, sBillType, sBusType, UserMode, sOverDetailsXml);
|
|
|
|
var conn = baseLogin.Connection;
|
|
|
|
var vouchers = CommonHelper.GetVouchers(conn, sCardNum);
|
|
|
|
var resList = new List<BaseResult<string>>();
|
|
|
|
foreach (var vouchId in vouchIds)
|
|
{
|
|
var strWhere = CommonHelper.GetPUVoucherWhereSqlById(vouchers, vouchId);
|
|
|
|
var cCode = CommonHelper.GetVoucherCode(conn, vouchId, vouchers);
|
|
|
|
var verifyResult = await CancelConfirm(co, conn, enmVoucherType, cCode, vouchId, strWhere);
|
|
|
|
resList.Add(verifyResult);
|
|
}
|
|
|
|
return resList;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 弃审单据(单号)
|
|
/// </summary>
|
|
/// <param name="baseLogin"></param>
|
|
/// <param name="sCardNum"></param>
|
|
/// <param name="enmVoucherType"></param>
|
|
/// <param name="cCode"></param>
|
|
/// <param name="bPositive"></param>
|
|
/// <param name="sBillType"></param>
|
|
/// <param name="sBusType"></param>
|
|
/// <param name="UserMode"></param>
|
|
/// <param name="sOverDetailsXml"></param>
|
|
/// <returns></returns>
|
|
/// <exception cref="Exception"></exception>
|
|
public async Task<BaseResult<string>> CancelConfirm(BaseLogin baseLogin, string sCardNum, vouchertype enmVoucherType, string cCode, bool bPositive = true, string sBillType = null, string sBusType = null, UseMode UserMode = UseMode.CS, string sOverDetailsXml = null)
|
|
{
|
|
var co = InitCo(baseLogin, enmVoucherType, bPositive, sBillType, sBusType, UserMode, sOverDetailsXml);
|
|
|
|
var conn = baseLogin.Connection;
|
|
|
|
var vouchers = CommonHelper.GetVouchers(conn, sCardNum);
|
|
|
|
var curId = CommonHelper.GetVoucherId(conn, cCode, vouchers);
|
|
|
|
var strWhere = CommonHelper.GetPUVoucherWhereSqlByCode(vouchers, cCode);
|
|
|
|
var verifyResult = await CancelConfirm(co, conn, enmVoucherType, cCode, curId, strWhere);
|
|
|
|
return verifyResult;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 弃审单据(ID)
|
|
/// </summary>
|
|
/// <param name="baseLogin"></param>
|
|
/// <param name="sCardNum"></param>
|
|
/// <param name="enmVoucherType"></param>
|
|
/// <param name="vouchId"></param>
|
|
/// <param name="bPositive"></param>
|
|
/// <param name="sBillType"></param>
|
|
/// <param name="sBusType"></param>
|
|
/// <param name="UserMode"></param>
|
|
/// <param name="sOverDetailsXml"></param>
|
|
/// <returns></returns>
|
|
/// <exception cref="Exception"></exception>
|
|
public async Task<BaseResult<string>> CancelConfirm(BaseLogin baseLogin, string sCardNum, vouchertype enmVoucherType, long vouchId, bool bPositive = true, string sBillType = null, string sBusType = null, UseMode UserMode = UseMode.CS, string sOverDetailsXml = null)
|
|
{
|
|
var co = InitCo(baseLogin, enmVoucherType, bPositive, sBillType, sBusType, UserMode, sOverDetailsXml);
|
|
|
|
var conn = baseLogin.Connection;
|
|
|
|
var vouchers = CommonHelper.GetVouchers(conn, sCardNum);
|
|
|
|
var strWhere = CommonHelper.GetPUVoucherWhereSqlById(vouchers, vouchId);
|
|
|
|
var cCode = CommonHelper.GetVoucherCode(conn, vouchId, vouchers);
|
|
|
|
var verifyResult = await CancelConfirm(co, conn, enmVoucherType, cCode, vouchId, strWhere);
|
|
|
|
return verifyResult;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 弃审单据
|
|
/// </summary>
|
|
/// <param name="voucherCO"></param>
|
|
/// <param name="conn"></param>
|
|
/// <param name="sVouchType"></param>
|
|
/// <param name="cCode"></param>
|
|
/// <param name="vouchId"></param>
|
|
/// <param name="strWhere"></param>
|
|
/// <returns></returns>
|
|
public async Task<BaseResult<string>> CancelConfirm(dynamic voucherCO, Connection conn, vouchertype sVouchType, string cCode, object vouchId, string strWhere)
|
|
{
|
|
IXMLDOMDocument2 domHead = new DOMDocument();
|
|
IXMLDOMDocument2 domBody = new DOMDocument();
|
|
IXMLDOMDocument2 domMsg = new DOMDocument();
|
|
|
|
_logInfo.Debug("开始获取单据数据...");
|
|
voucherCO.GetVoucherData(ref domHead, ref domBody, strWhere);
|
|
|
|
var res = new BaseResult<string>
|
|
{
|
|
voucherCode = cCode,
|
|
voucherId = $"{vouchId}"
|
|
};
|
|
|
|
var errorMsg = "";
|
|
|
|
switch (sVouchType)
|
|
{
|
|
case vouchertype.采购请购单:
|
|
{
|
|
errorMsg = voucherCO.CancelconfirmApp(ref domHead);
|
|
break;
|
|
}
|
|
case vouchertype.采购订单:
|
|
{
|
|
#if DEBUG
|
|
errorMsg = voucherCO.CancelconfirmPO(ref domHead);
|
|
#else
|
|
errorMsg = voucherCO.CancelconfirmPO(ref domHead,ref domBody);
|
|
#endif
|
|
break;
|
|
}
|
|
case vouchertype.采购到货单:
|
|
{
|
|
errorMsg = voucherCO.CancelconfirmArr(ref domHead);
|
|
break;
|
|
}
|
|
case vouchertype.采购发票:
|
|
{
|
|
errorMsg = voucherCO.CancelconfirmBill(ref domHead);
|
|
break;
|
|
}
|
|
default:
|
|
await Task.Delay(1);
|
|
errorMsg = "未知业务";
|
|
break;
|
|
}
|
|
|
|
res.bSuccess = string.IsNullOrWhiteSpace(errorMsg);
|
|
|
|
if (res.bSuccess)
|
|
{
|
|
res.message = "弃审成功";
|
|
res.result = res.voucherId;
|
|
|
|
}
|
|
else
|
|
{
|
|
res.message = "弃审失败";
|
|
res.result = string.IsNullOrWhiteSpace(errorMsg) ? domMsg.xml : errorMsg;
|
|
}
|
|
|
|
return res;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 批量删除单据(单号)
|
|
/// </summary>
|
|
/// <param name="baseLogin"></param>
|
|
/// <param name="sCardNum"></param>
|
|
/// <param name="enmVoucherType"></param>
|
|
/// <param name="cCodes"></param>
|
|
/// <param name="bPositive"></param>
|
|
/// <param name="sBillType"></param>
|
|
/// <param name="sBusType"></param>
|
|
/// <param name="UserMode"></param>
|
|
/// <param name="sOverDetailsXml"></param>
|
|
/// <returns></returns>
|
|
/// <exception cref="Exception"></exception>
|
|
public async Task<List<BaseResult<string>>> Delete(BaseLogin baseLogin, string sCardNum, vouchertype enmVoucherType, List<string> cCodes, bool bPositive = true, string sBillType = null, string sBusType = null, UseMode UserMode = UseMode.CS, string sOverDetailsXml = null)
|
|
{
|
|
_logInfo.Debug("开始输出登录信息");
|
|
_logInfo.Debug(baseLogin._vbLogin.userToken);
|
|
|
|
var co = InitCo(baseLogin, enmVoucherType, bPositive, sBillType, sBusType, UserMode, sOverDetailsXml);
|
|
|
|
var conn = baseLogin.Connection;
|
|
|
|
var vouchers = CommonHelper.GetVouchers(conn, sCardNum);
|
|
|
|
var resList = new List<BaseResult<string>>();
|
|
|
|
foreach (var cCode in cCodes)
|
|
{
|
|
try
|
|
{
|
|
var strWhere = CommonHelper.GetPUVoucherWhereSqlByCode(vouchers, cCode);
|
|
|
|
var curId = CommonHelper.GetVoucherId(conn, cCode, vouchers);
|
|
|
|
var verifyResult = await Delete(co, conn, enmVoucherType, cCode, curId, strWhere);
|
|
|
|
resList.Add(verifyResult);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
await Task.Delay(1);
|
|
_logInfo.Error(ex.Message, ex);
|
|
}
|
|
}
|
|
|
|
return resList;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 批量删除单据(ID)
|
|
/// </summary>
|
|
/// <param name="baseLogin"></param>
|
|
/// <param name="sCardNum"></param>
|
|
/// <param name="enmVoucherType"></param>
|
|
/// <param name="vouchIds"></param>
|
|
/// <param name="bPositive"></param>
|
|
/// <param name="sBillType"></param>
|
|
/// <param name="UserMode"></param>
|
|
/// <param name="sOverDetailsXml"></param>
|
|
/// <returns></returns>
|
|
/// <exception cref="Exception"></exception>
|
|
public async Task<List<BaseResult<string>>> Delete(BaseLogin baseLogin, string sCardNum, vouchertype enmVoucherType, List<long> vouchIds, bool bPositive = true, string sBillType = null, string sBusType = null, UseMode UserMode = UseMode.CS, string sOverDetailsXml = null)
|
|
{
|
|
var co = InitCo(baseLogin, enmVoucherType, bPositive, sBillType, sBusType, UserMode, sOverDetailsXml);
|
|
|
|
var conn = baseLogin.Connection;
|
|
|
|
var vouchers = CommonHelper.GetVouchers(conn, sCardNum);
|
|
|
|
var resList = new List<BaseResult<string>>();
|
|
|
|
foreach (var vouchId in vouchIds)
|
|
{
|
|
var strWhere = CommonHelper.GetPUVoucherWhereSqlById(vouchers, vouchId);
|
|
|
|
var cCode = CommonHelper.GetVoucherCode(conn, vouchId, vouchers);
|
|
|
|
var verifyResult = await Delete(co, conn, enmVoucherType, cCode, vouchId, strWhere);
|
|
|
|
resList.Add(verifyResult);
|
|
}
|
|
|
|
return resList;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 删除单据(单号)
|
|
/// </summary>
|
|
/// <param name="baseLogin"></param>
|
|
/// <param name="sCardNum"></param>
|
|
/// <param name="enmVoucherType"></param>
|
|
/// <param name="cCode"></param>
|
|
/// <param name="bPositive"></param>
|
|
/// <param name="sBillType"></param>
|
|
/// <param name="sBusType"></param>
|
|
/// <param name="UserMode"></param>
|
|
/// <param name="sOverDetailsXml"></param>
|
|
/// <returns></returns>
|
|
/// <exception cref="Exception"></exception>
|
|
public async Task<BaseResult<string>> Delete(BaseLogin baseLogin, string sCardNum, vouchertype enmVoucherType, string cCode, bool bPositive = true, string sBillType = null, string sBusType = null, UseMode UserMode = UseMode.CS, string sOverDetailsXml = null)
|
|
{
|
|
var co = InitCo(baseLogin, enmVoucherType, bPositive, sBillType, sBusType, UserMode, sOverDetailsXml);
|
|
|
|
var conn = baseLogin.Connection;
|
|
|
|
var vouchers = CommonHelper.GetVouchers(conn, sCardNum);
|
|
|
|
var curId = CommonHelper.GetVoucherId(conn, cCode, vouchers);
|
|
|
|
var strWhere = CommonHelper.GetPUVoucherWhereSqlByCode(vouchers, cCode);
|
|
|
|
var verifyResult = await Delete(co, conn, enmVoucherType, cCode, curId, strWhere);
|
|
|
|
return verifyResult;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 删除单据(ID)
|
|
/// </summary>
|
|
/// <param name="baseLogin"></param>
|
|
/// <param name="sCardNum"></param>
|
|
/// <param name="enmVoucherType"></param>
|
|
/// <param name="vouchId"></param>
|
|
/// <param name="bPositive"></param>
|
|
/// <param name="sBillType"></param>
|
|
/// <param name="sBusType"></param>
|
|
/// <param name="UserMode"></param>
|
|
/// <param name="sOverDetailsXml"></param>
|
|
/// <returns></returns>
|
|
/// <exception cref="Exception"></exception>
|
|
public async Task<BaseResult<string>> Delete(BaseLogin baseLogin, string sCardNum, vouchertype enmVoucherType, long vouchId, bool bPositive = true, string sBillType = null, string sBusType = null, UseMode UserMode = UseMode.CS, string sOverDetailsXml = null)
|
|
{
|
|
var co = InitCo(baseLogin, enmVoucherType, bPositive, sBillType, sBusType, UserMode, sOverDetailsXml);
|
|
|
|
var conn = baseLogin.Connection;
|
|
|
|
var vouchers = CommonHelper.GetVouchers(conn, sCardNum);
|
|
|
|
var strWhere = CommonHelper.GetPUVoucherWhereSqlById(vouchers, vouchId);
|
|
|
|
var cCode = CommonHelper.GetVoucherCode(conn, vouchId, vouchers);
|
|
|
|
var verifyResult = await Delete(co, conn, enmVoucherType, cCode, vouchId, strWhere);
|
|
|
|
return verifyResult;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 删除单据
|
|
/// </summary>
|
|
/// <param name="voucherCO"></param>
|
|
/// <param name="conn"></param>
|
|
/// <param name="sVouchType"></param>
|
|
/// <param name="cCode"></param>
|
|
/// <param name="vouchId"></param>
|
|
/// <param name="strWhere"></param>
|
|
/// <returns></returns>
|
|
public async Task<BaseResult<string>> Delete(dynamic voucherCO, Connection conn, vouchertype sVouchType, string cCode, object vouchId, string strWhere)
|
|
{
|
|
IXMLDOMDocument2 domHead = new DOMDocument();
|
|
IXMLDOMDocument2 domBody = new DOMDocument();
|
|
IXMLDOMDocument2 domMsg = new DOMDocument();
|
|
|
|
_logInfo.Debug("开始获取单据数据...");
|
|
voucherCO.GetVoucherData(ref domHead, ref domBody, strWhere);
|
|
|
|
var res = new BaseResult<string>
|
|
{
|
|
voucherCode = cCode,
|
|
voucherId = $"{vouchId}"
|
|
};
|
|
|
|
var errorMsg = voucherCO.Delete(domHead, domBody);
|
|
|
|
res.bSuccess = string.IsNullOrWhiteSpace(errorMsg);
|
|
|
|
if (res.bSuccess)
|
|
{
|
|
res.message = "删除成功";
|
|
res.result = res.voucherId;
|
|
|
|
}
|
|
else
|
|
{
|
|
res.message = "删除失败";
|
|
res.result = string.IsNullOrWhiteSpace(errorMsg) ? "未知错误" : errorMsg;
|
|
await Task.Delay(1);
|
|
}
|
|
|
|
return res;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 批量提交工作流(单号)
|
|
/// </summary>
|
|
/// <param name="baseLogin"></param>
|
|
/// <param name="sCardNum"></param>
|
|
/// <param name="enmVoucherType"></param>
|
|
/// <param name="cCodes"></param>
|
|
/// <param name="bPositive"></param>
|
|
/// <param name="sBillType"></param>
|
|
/// <param name="sBusType"></param>
|
|
/// <param name="UserMode"></param>
|
|
/// <param name="sOverDetailsXml"></param>
|
|
/// <returns></returns>
|
|
/// <exception cref="Exception"></exception>
|
|
public async Task<List<BaseResult<string>>> SubmintWf(BaseLogin baseLogin, string sCardNum, vouchertype enmVoucherType, List<string> cCodes, bool bPositive = true, string sBillType = null, string sBusType = null, UseMode UserMode = UseMode.CS, string sOverDetailsXml = null)
|
|
{
|
|
_logInfo.Debug("开始输出登录信息");
|
|
_logInfo.Debug(baseLogin._vbLogin.userToken);
|
|
|
|
var co = InitCo(baseLogin, enmVoucherType, bPositive, sBillType, sBusType, UserMode, sOverDetailsXml);
|
|
|
|
var conn = baseLogin.Connection;
|
|
|
|
var vouchers = CommonHelper.GetVouchers(conn, sCardNum);
|
|
|
|
var resList = new List<BaseResult<string>>();
|
|
|
|
foreach (var cCode in cCodes)
|
|
{
|
|
try
|
|
{
|
|
var strWhere = CommonHelper.GetPUVoucherWhereSqlByCode(vouchers, cCode);
|
|
|
|
var curId = CommonHelper.GetVoucherId(conn, cCode, vouchers);
|
|
|
|
var verifyResult = await SubmintWf(co, conn, enmVoucherType, cCode, curId, strWhere);
|
|
|
|
resList.Add(verifyResult);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
await Task.Delay(1);
|
|
_logInfo.Error(ex.Message, ex);
|
|
}
|
|
}
|
|
|
|
return resList;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 批量提交工作流(ID)
|
|
/// </summary>
|
|
/// <param name="baseLogin"></param>
|
|
/// <param name="sCardNum"></param>
|
|
/// <param name="enmVoucherType"></param>
|
|
/// <param name="vouchIds"></param>
|
|
/// <param name="bPositive"></param>
|
|
/// <param name="sBillType"></param>
|
|
/// <param name="UserMode"></param>
|
|
/// <param name="sOverDetailsXml"></param>
|
|
/// <returns></returns>
|
|
/// <exception cref="Exception"></exception>
|
|
public async Task<List<BaseResult<string>>> SubmintWf(BaseLogin baseLogin, string sCardNum, vouchertype enmVoucherType, List<long> vouchIds, bool bPositive = true, string sBillType = null, string sBusType = null, UseMode UserMode = UseMode.CS, string sOverDetailsXml = null)
|
|
{
|
|
var co = InitCo(baseLogin, enmVoucherType, bPositive, sBillType, sBusType, UserMode, sOverDetailsXml);
|
|
|
|
var conn = baseLogin.Connection;
|
|
|
|
var vouchers = CommonHelper.GetVouchers(conn, sCardNum);
|
|
|
|
var resList = new List<BaseResult<string>>();
|
|
|
|
foreach (var vouchId in vouchIds)
|
|
{
|
|
var strWhere = CommonHelper.GetPUVoucherWhereSqlById(vouchers, vouchId);
|
|
|
|
var cCode = CommonHelper.GetVoucherCode(conn, vouchId, vouchers);
|
|
|
|
var verifyResult = await SubmintWf(co, conn, enmVoucherType, cCode, vouchId, strWhere);
|
|
|
|
resList.Add(verifyResult);
|
|
}
|
|
|
|
return resList;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 提交工作流(单号)
|
|
/// </summary>
|
|
/// <param name="baseLogin"></param>
|
|
/// <param name="sCardNum"></param>
|
|
/// <param name="enmVoucherType"></param>
|
|
/// <param name="cCode"></param>
|
|
/// <param name="bPositive"></param>
|
|
/// <param name="sBillType"></param>
|
|
/// <param name="sBusType"></param>
|
|
/// <param name="UserMode"></param>
|
|
/// <param name="sOverDetailsXml"></param>
|
|
/// <returns></returns>
|
|
/// <exception cref="Exception"></exception>
|
|
public async Task<BaseResult<string>> SubmintWf(BaseLogin baseLogin, string sCardNum, vouchertype enmVoucherType, string cCode, bool bPositive = true, string sBillType = null, string sBusType = null, UseMode UserMode = UseMode.CS, string sOverDetailsXml = null)
|
|
{
|
|
var co = InitCo(baseLogin, enmVoucherType, bPositive, sBillType, sBusType, UserMode, sOverDetailsXml);
|
|
|
|
var conn = baseLogin.Connection;
|
|
|
|
var vouchers = CommonHelper.GetVouchers(conn, sCardNum);
|
|
|
|
var curId = CommonHelper.GetVoucherId(conn, cCode, vouchers);
|
|
|
|
var strWhere = CommonHelper.GetPUVoucherWhereSqlByCode(vouchers, cCode);
|
|
|
|
var verifyResult = await SubmintWf(co, conn, enmVoucherType, cCode, curId, strWhere);
|
|
|
|
return verifyResult;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 提交工作流(ID)
|
|
/// </summary>
|
|
/// <param name="baseLogin"></param>
|
|
/// <param name="sCardNum"></param>
|
|
/// <param name="enmVoucherType"></param>
|
|
/// <param name="vouchId"></param>
|
|
/// <param name="bPositive"></param>
|
|
/// <param name="sBillType"></param>
|
|
/// <param name="sBusType"></param>
|
|
/// <param name="UserMode"></param>
|
|
/// <param name="sOverDetailsXml"></param>
|
|
/// <returns></returns>
|
|
/// <exception cref="Exception"></exception>
|
|
public async Task<BaseResult<string>> SubmintWf(BaseLogin baseLogin, string sCardNum, vouchertype enmVoucherType, long vouchId, bool bPositive = true, string sBillType = null, string sBusType = null, UseMode UserMode = UseMode.CS, string sOverDetailsXml = null)
|
|
{
|
|
var co = InitCo(baseLogin, enmVoucherType, bPositive, sBillType, sBusType, UserMode, sOverDetailsXml);
|
|
|
|
var conn = baseLogin.Connection;
|
|
|
|
var vouchers = CommonHelper.GetVouchers(conn, sCardNum);
|
|
|
|
var strWhere = CommonHelper.GetPUVoucherWhereSqlById(vouchers, vouchId);
|
|
|
|
var cCode = CommonHelper.GetVoucherCode(conn, vouchId, vouchers);
|
|
|
|
var verifyResult = await SubmintWf(co, conn, enmVoucherType, cCode, vouchId, strWhere);
|
|
|
|
return verifyResult;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 提交工作流
|
|
/// </summary>
|
|
/// <param name="voucherCO"></param>
|
|
/// <param name="conn"></param>
|
|
/// <param name="sVouchType"></param>
|
|
/// <param name="cCode"></param>
|
|
/// <param name="vouchId"></param>
|
|
/// <param name="strWhere"></param>
|
|
/// <returns></returns>
|
|
public async Task<BaseResult<string>> SubmintWf(dynamic voucherCO, Connection conn, vouchertype sVouchType, string cCode, object vouchId, string strWhere)
|
|
{
|
|
IXMLDOMDocument2 domHead = new DOMDocument();
|
|
IXMLDOMDocument2 domBody = new DOMDocument();
|
|
IXMLDOMDocument2 domMsg = new DOMDocument();
|
|
|
|
_logInfo.Debug("开始获取单据数据...");
|
|
voucherCO.GetVoucherData(ref domHead, ref domBody, strWhere);
|
|
|
|
var res = new BaseResult<string>
|
|
{
|
|
voucherCode = cCode,
|
|
voucherId = $"{vouchId}"
|
|
};
|
|
|
|
var errorMsg = "";
|
|
|
|
voucherCO.SubmintWf(domHead, ref errorMsg, vouchId);
|
|
|
|
res.bSuccess = string.IsNullOrWhiteSpace(errorMsg);
|
|
|
|
if (res.bSuccess)
|
|
{
|
|
res.message = "提交成功";
|
|
res.result = res.voucherId;
|
|
|
|
}
|
|
else
|
|
{
|
|
res.message = "提交失败";
|
|
res.result = string.IsNullOrWhiteSpace(errorMsg) ? "未知错误" : errorMsg;
|
|
await Task.Delay(1);
|
|
}
|
|
|
|
return res;
|
|
}
|
|
}
|
|
}
|