/// <summary>
/// 新增冲帐记录
/// </summary>
/// <param name="data"></param>
/// <param name="listDetail"></param>
/// <param name="nOpStaffId"></param>
/// <param name="strOpStaffName"></param>
/// <param name="strErrText"></param>
/// <returns></returns>
public long InsertContractReverse(ContractReverse data, List<ContractReverseDetail> listDetail, long nOpStaffId, string strOpStaffName, out string strErrText)
{
ContractRule rule = new ContractRule();
return rule.InsertContractReverse(data, listDetail, nOpStaffId, strOpStaffName, out strErrText);
}
/// <summary>
/// 新增冲帐记录
/// </summary>
/// <param name="data"></param>
/// <param name="listDetail"></param>
/// <param name="nOpStaffId"></param>
/// <param name="strOpStaffName"></param>
/// <param name="strErrText"></param>
/// <returns></returns>
public long InsertContractReverse(ContractReverse data, List<ContractReverseDetail> listDetail, long nOpStaffId, string strOpStaffName, out string strErrText)
{
long nReverseId = 0;
try
{
using (TransactionScope transScope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(2, 0, 0)))
{
using (ContractDAO dao = new ContractDAO())
{
//新增冲帐数据
nReverseId = dao.InsertContractReverse(data, nOpStaffId, strOpStaffName, out strErrText);
if (nReverseId <= 0)
return 0;
//新增冲帐明细数据
foreach (ContractReverseDetail detail in listDetail)
{
detail.ReverseId = nReverseId;
if (!dao.InsertContractReverseDetail(detail, nOpStaffId, strOpStaffName, out strErrText))
{
return 0;
}
}
}
transScope.Complete();
}
return nReverseId;
}
catch (Exception e)
{
strErrText = e.Message;
return 0;
}
}
public ActionResult ReverseContracts(ContractReverseViewModel model)
{
if (ModelState.IsValid)
{
//创建数据
ContractReverse data = new ContractReverse();
data.Id = model.Id;
data.ReverseAmount = model.ReverseAmount;
data.WithholdAmount = model.WithholdAmount;
data.FactpaymentAmount = model.FactpaymentAmount;
data.CreatorId = model.CreatorId;
data.CreatorName = model.CreatorName;
List<ContractReverseDetail> listDetail = new List<ContractReverseDetail>();
if (model.Details != null)
{
foreach (ContractReverseDetailViewModel m in model.Details)
{
ContractReverseDetail d = new ContractReverseDetail();
d.Id = m.Id;
d.ReverseId = 0;
d.ContractId = m.ContractId;
d.ReverseAmount = m.ReverseAmount;
d.WithholdAmount = m.WithholdAmount;
d.FactpaymentAmount = m.FactpaymentAmount;
listDetail.Add(d);
}
}
//保存数据
string strErrText;
ContractSystem contract = new ContractSystem();
if (contract.InsertContractReverse(data, listDetail, LoginAccountId, LoginStaffName, out strErrText) > 0)
{
return Json(string.Empty);
}
else
{
return Json(strErrText);
}
}
return View(model);
}
/// <summary>
/// 新增冲帐记录
/// </summary>
/// <param name="data"></param>
/// <param name="nOpStaffId"></param>
/// <param name="strOpStaffName"></param>
/// <param name="strErrText"></param>
/// <returns></returns>
public long InsertContractReverse(ContractReverse data, long nOpStaffId, string strOpStaffName, out string strErrText)
{
//创建存储过程参数
SqlParameter[] Params =
{
MakeParam(ID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.InputOutput, (object)data.Id),
MakeParam(REVERSEAMOUNT_PARAM, SqlDbType.Decimal, 13, ParameterDirection.Input, (object)data.ReverseAmount),
MakeParam(WITHHOLDAMOUNT_PARAM, SqlDbType.Decimal, 13, ParameterDirection.Input, (object)data.WithholdAmount),
MakeParam(FACTPAYMENTAMOUNT_PARAM, SqlDbType.Decimal, 13, ParameterDirection.Input, (object)data.FactpaymentAmount),
MakeParam(CREATORID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)data.CreatorId),
MakeParam(CREATORNAME_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.CreatorName),
MakeParam(OPSTAFFID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)nOpStaffId),
MakeParam(OPSTAFFNAME_PARAM, SqlDbType.NVarChar, 50, ParameterDirection.Input, (object)strOpStaffName),
};
SqlParameterCollection outParams;
if (Execute("InsertContractReverse", Params, out outParams, out strErrText) < 0)
{
return 0;
}
else
{
return (long)outParams[ID_PARAM].Value;
}
}