/// <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 JsonResult LoadCustomerTransportPrice(string planId, string carType)
{
string strErrText;
CustomerSystem customer = new CustomerSystem();
CustomerTransportPrice data = customer.LoadCustomerTransportPriceByPlanId(long.Parse(planId), carType, LoginAccountId, LoginStaffName, out strErrText);
if (data == null)
{
return(Json(0, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(data.TransportPrice, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// 读取指定发货计划的客户结算价格数据
/// </summary>
/// <param name="nPlanId"></param>
/// <param name="strCarType"></param>
/// <param name="nOpStaffId"></param>
/// <param name="strOpStaffName"></param>
/// <param name="strErrText"></param>
/// <returns></returns>
public CustomerTransportPrice LoadCustomerTransportPriceByPlanId(long nPlanId, string strCarType, long nOpStaffId, string strOpStaffName, out string strErrText)
{
try
{
CustomerTransportPrice dataResult = null;
strErrText = String.Empty;
using (TransactionScope transScope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(2, 0, 0)))
{
using (CustomerDAO dao = new CustomerDAO())
{
dataResult = dao.LoadCustomerTransportPriceByPlanId(nPlanId, strCarType, nOpStaffId, strOpStaffName, out strErrText);
}
transScope.Complete();
}
return(dataResult);
}
catch (Exception e)
{
strErrText = e.Message;
return(null);
}
}
