/// <summary>
/// 新增发票明细数据
/// </summary>
/// <param name="data"></param>
/// <param name="nOpStaffId"></param>
/// <param name="strOpStaffName"></param>
/// <param name="strErrText"></param>
/// <returns></returns>
public bool InsertCustomerTransportChargesSettlementDetail(CustomerTransportChargesSettlementDetail data, long nOpStaffId, string strOpStaffName, out string strErrText)
{
//创建存储过程参数
SqlParameter[] Params =
{
MakeParam(CUSTOMERTRANSPORTCHARGESSETTLEMENTID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)data.CustomerTransportChargesSettlementId),
MakeParam(DELIVERBILLID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)data.DeliverBillId),
MakeParam(TRANSPORTPRICE_PARAM, SqlDbType.Decimal, 13, ParameterDirection.Input, (object)data.TransportPrice),
MakeParam(TRANSPORTCHARGES_PARAM, SqlDbType.Decimal, 13, ParameterDirection.Input, (object)data.TransportCharges),
MakeParam(CARPOOLFEE_PARAM, SqlDbType.Decimal, 13, ParameterDirection.Input, (object)data.CarpoolFee),
MakeParam(RIVERCROSSINGCHARGES_PARAM, SqlDbType.Decimal, 13, ParameterDirection.Input, (object)data.RiverCrossingCharges),
MakeParam(OPSTAFFID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)nOpStaffId),
MakeParam(OPSTAFFNAME_PARAM, SqlDbType.NVarChar, 50, ParameterDirection.Input, (object)strOpStaffName),
};
if (Execute("InsertCustomerTransportChargesSettlementDetail", Params, out strErrText) >= 0)
return true;
else
return false;
}
public ActionResult NewCustomerTransportChargesSettlement(CustomerTransportChargesSettlementViewModel model)
{
if (ModelState.IsValid)
{
//创建数据
CustomerTransportChargesSettlement data = new CustomerTransportChargesSettlement();
data.InvoiceNo = model.InvoiceNo;
data.CustomerId = model.CustomerId;
data.CustomerName = model.CustomerName;
data.InvoiceType = model.InvoiceType;
data.InvoiceAmount = model.InvoiceAmount;
data.Remark = model.Remark;
List<CustomerTransportChargesSettlementDetail> listDetail = new List<CustomerTransportChargesSettlementDetail>();
foreach (CustomerTransportChargesSettlementDetailViewModel m in model.Details)
{
CustomerTransportChargesSettlementDetail d = new CustomerTransportChargesSettlementDetail();
d.CustomerTransportChargesSettlementId = m.CustomerTransportChargesSettlementId;
d.DeliverBillId = m.DeliverBillId;
d.TransportPrice = m.TransportPrice;
d.TransportCharges = m.TransportCharges;
d.CarpoolFee = m.CarpoolFee;
d.RiverCrossingCharges = m.RiverCrossingCharges;
listDetail.Add(d);
}
//保存数据
string strErrText;
SettlementSystem settlement = new SettlementSystem();
if (settlement.InsertCustomerTransportChargesSettlement(data, listDetail, LoginAccountId, LoginStaffName, out strErrText) > 0)
{
return Json(string.Empty);
}
else
{
return Json(strErrText);
}
}
return View(model);
}
