/// <summary>
/// 新增承运单位结算记录
/// </summary>
/// <param name="data"></param>
/// <param name="nOpStaffId"></param>
/// <param name="strOpStaffName"></param>
/// <param name="strErrText"></param>
/// <returns></returns>
public long InsertCarrierTransportChargesSettlement(CarrierTransportChargesSettlement data, long nOpStaffId, string strOpStaffName, out string strErrText)
{
//创建存储过程参数
SqlParameter[] Params =
{
MakeParam(ID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Output, (object)data.Id),
MakeParam(CARRIERID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)data.CarrierId),
MakeParam(CARRIERNAME_PARAM, SqlDbType.NVarChar, 50, ParameterDirection.Input, (object)data.CarrierName),
MakeParam(SETTLEMENTAMOUNT_PARAM, SqlDbType.Decimal, 13, ParameterDirection.Input, (object)data.SettlementAmount),
MakeParam(WITHHOLDAMOUNT_PARAM, SqlDbType.Decimal, 13, ParameterDirection.Input, (object)data.WithholdAmount),
MakeParam(FACTPAYMENTAMOUNT_PARAM, SqlDbType.Decimal, 13, ParameterDirection.Input, (object)data.FactpaymentAmount),
MakeParam(REMARK_PARAM, SqlDbType.NVarChar, 100, ParameterDirection.Input, (object)data.Remark ?? System.DBNull.Value),
MakeParam(OPSTAFFID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)nOpStaffId),
MakeParam(OPSTAFFNAME_PARAM, SqlDbType.NVarChar, 50, ParameterDirection.Input, (object)strOpStaffName),
};
SqlParameterCollection outParams;
if (Execute("InsertCarrierTransportChargesSettlement", Params, out outParams, out strErrText) < 0)
{
return(0);
}
else
{
return((long)outParams[ID_PARAM].Value);
}
}
/// <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 InsertCarrierTransportChargesSettlement(CarrierTransportChargesSettlement data, List <CarrierTransportChargesSettlementDetail> listDetail, long nOpStaffId, string strOpStaffName, out string strErrText)
{
long nCarrierTransportChargesSettlementId = 0;
try
{
using (TransactionScope transScope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(2, 0, 0)))
{
using (SettlementDAO dao = new SettlementDAO())
{
//新增结算数据
nCarrierTransportChargesSettlementId = dao.InsertCarrierTransportChargesSettlement(data, nOpStaffId, strOpStaffName, out strErrText);
if (nCarrierTransportChargesSettlementId <= 0)
{
return(0);
}
//新增结算明细数据
foreach (CarrierTransportChargesSettlementDetail detail in listDetail)
{
detail.CarrierTransportChargesSettlementId = nCarrierTransportChargesSettlementId;
if (!dao.InsertCarrierTransportChargesSettlementDetail(detail, nOpStaffId, strOpStaffName, out strErrText))
{
return(0);
}
}
}
transScope.Complete();
}
return(nCarrierTransportChargesSettlementId);
}
catch (Exception e)
{
strErrText = e.Message;
return(0);
}
}
/// <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 InsertCarrierTransportChargesSettlement(CarrierTransportChargesSettlement data, List <CarrierTransportChargesSettlementDetail> listDetail, long nOpStaffId, string strOpStaffName, out string strErrText)
{
SettlementRule rule = new SettlementRule();
return(rule.InsertCarrierTransportChargesSettlement(data, listDetail, nOpStaffId, strOpStaffName, out strErrText));
}
