/// <summary>
/// 新增客户结算价格数据
/// </summary>
/// <param name="data"></param>
/// <param name="nOpStaffId"></param>
/// <param name="strOpStaffName"></param>
/// <param name="strErrText"></param>
/// <returns></returns>
public bool InsertCustomerTransportPrice(CustomerTransportPrice data, long nOpStaffId, string strOpStaffName, out string strErrText)
{
//创建存储过程参数
SqlParameter[] Params =
{
MakeParam(CUSTOMERID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)data.CustomerId),
MakeParam(STARTCOUNTRY_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.StartCountry),
MakeParam(STARTPROVINCE_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.StartProvince),
MakeParam(STARTCITY_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.StartCity),
MakeParam(DESTCOUNTRY_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.DestCountry),
MakeParam(DESTPROVINCE_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.DestProvince),
MakeParam(DESTCITY_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.DestCity),
MakeParam(MINTUNNAGESORPILES_PARAM, SqlDbType.Decimal, 13, ParameterDirection.Input, (object)data.MinTunnagesOrPiles),
MakeParam(MAXTUNNAGESORPILES_PARAM, SqlDbType.Decimal, 13, ParameterDirection.Input, (object)data.MaxTunnagesOrPiles),
MakeParam(STARTTIME_PARAM, SqlDbType.DateTime, 8, ParameterDirection.Input, (object)data.StartTime),
MakeParam(ENDTIME_PARAM, SqlDbType.DateTime, 8, ParameterDirection.Input, (object)data.EndTime),
MakeParam(CARTYPE_PARAM, SqlDbType.NVarChar, 10, ParameterDirection.Input, (object)data.CarType??string.Empty),
MakeParam(TRANSPORTPRICE_PARAM, SqlDbType.Decimal, 13, ParameterDirection.Input, (object)data.TransportPrice),
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("InsertCustomerTransportPrice", Params, out strErrText) >= 0)
return true;
else
return false;
}
public ActionResult NewCustomer(CustomerViewModel model)
{
if (ModelState.IsValid)
{
//创建数据
Customer data = new Customer();
data.Name = model.Name;
data.FullName = model.FullName;
data.WarningStock = model.WarningStock;
data.StopStock = model.StopStock;
data.SettlementExpression = model.SettlementExpression;
data.ValuationMode = model.ValuationMode;
data.GrossWeightRate = decimal.Parse(model.GrossWeightRate);
data.OwnOrganId = model.OwnOrganId;
data.Remark = model.Remark ?? string.Empty;
List<CustomerTransportPrice> listTransportPrice = new List<CustomerTransportPrice>();
if (model.TransportPrices != null)
{
foreach (CustomerTransportPriceViewModel m in model.TransportPrices)
{
CustomerTransportPrice p = new CustomerTransportPrice();
p.CustomerId = m.CustomerId;
p.StartCountry = m.StartCountry;
p.StartProvince = m.StartProvince;
p.StartCity = m.StartCity;
p.DestCountry = m.DestCountry;
p.DestProvince = m.DestProvince;
p.DestCity = m.DestCity;
p.MinTunnagesOrPiles = m.MinTunnagesOrPiles;
p.MaxTunnagesOrPiles = m.MaxTunnagesOrPiles;
p.StartTime = DateTime.Parse(m.StartTime);
p.EndTime = DateTime.Parse(m.EndTime);
p.CarType = m.CarType;
p.TransportPrice = m.TransportPrice;
p.RiverCrossingCharges = m.RiverCrossingCharges;
listTransportPrice.Add(p);
}
}
List<CustomerForceFeePrice> listForceFeePrice = new List<CustomerForceFeePrice>();
if (model.ForceFeePrices != null)
{
foreach (CustomerForceFeePriceViewModel m in model.ForceFeePrices)
{
CustomerForceFeePrice p = new CustomerForceFeePrice();
p.CustomerId = m.CustomerId;
p.StartTime = DateTime.Parse(m.ForceFeePriceStartTime);
p.EndTime = DateTime.Parse(m.ForceFeePriceEndTime);
p.LoadingForceFeePrice = m.LoadingForceFeePrice;
p.UnloadingForceFeePrice = m.UnloadingForceFeePrice;
listForceFeePrice.Add(p);
}
}
List<CustomerStorageFeePrice> listStorageFeePrice = new List<CustomerStorageFeePrice>();
if (model.StorageFeePrices != null)
{
foreach (CustomerStorageFeePriceViewModel m in model.StorageFeePrices)
{
CustomerStorageFeePrice p = new CustomerStorageFeePrice();
p.CustomerId = m.CustomerId;
p.StartTime = DateTime.Parse(m.StorageFeePriceStartTime);
p.EndTime = DateTime.Parse(m.StorageFeePriceEndTime);
p.StorageFeePrice = m.StorageFeePrice;
listStorageFeePrice.Add(p);
}
}
//保存数据
string strErrText;
CustomerSystem customer = new CustomerSystem();
if (customer.InsertCustomer(data, listTransportPrice, listForceFeePrice, listStorageFeePrice, LoginAccountId, LoginStaffName, out strErrText) > 0)
{
return Json(string.Empty);
}
else
{
return Json(strErrText);
}
}
return View(model);
}
