public Response <string> GetHiltiDriverPhone(AddOrUpdateServicePeriodRequest request)
{
Response <string> response = new Response <string>();
if (request == null)
{
ArgumentNullException ex = new ArgumentNullException("GetHiltiDriverPhone request");
LogError(ex);
response.ErrorCode = ErrorCode.Argument;
response.Exception = ex;
return(response);
}
try
{
HiltiAccessor accessor = new HiltiAccessor();
response.Result = accessor.GetHiltiDriverPhone(request.SellName);
}
catch (Exception ex)
{
LogError(ex);
response.IsSuccess = false;
response.ErrorCode = ErrorCode.Technical;
response.Exception = ex;
}
return(response);
}
public Response <AddOrUpdateServicePeriodRequest> AddOrUpdateServicePeriod(AddOrUpdateServicePeriodRequest request)
{
Response <AddOrUpdateServicePeriodRequest> response = new Response <AddOrUpdateServicePeriodRequest>();
if (request == null)
{
ArgumentNullException ex = new ArgumentNullException("AddOrUpdateServicePeriod request");
LogError(ex);
response.ErrorCode = ErrorCode.Argument;
response.Exception = ex;
return(response);
}
try
{
HiltiAccessor accessor = new HiltiAccessor();
response.Result = accessor.AddOrUpdateServicePeriod(new AddOrUpdateServicePeriodRequest()
{
EndCity = request.EndCity, EndCityID = request.EndCityID, Period = request.Period
});
response.IsSuccess = response.Result.ErrorValue.ObjectToBoolean();
}
catch (Exception ex)
{
LogError(ex);
response.IsSuccess = false;
response.ErrorCode = ErrorCode.Technical;
response.Exception = ex;
}
return(response);
}
public Response <int> GetServicePeriodInfo(AddOrUpdateServicePeriodRequest request)
{
Response <int> response = new Response <int>();
if (request == null)
{
ArgumentNullException ex = new ArgumentNullException("GetServicePeriodInfo request");
LogError(ex);
response.ErrorCode = ErrorCode.Argument;
response.Exception = ex;
return(response);
}
try
{
HiltiAccessor accessor = new HiltiAccessor();
response.Result = accessor.GetServicePeriodInfo(request.EndCity);
}
catch (Exception ex)
{
LogError(ex);
response.IsSuccess = false;
response.ErrorCode = ErrorCode.Technical;
response.Exception = ex;
}
return(response);
}
/// <summary>
/// 更新或添加时效
/// </summary>
/// <param name="Info"></param>
/// <returns></returns>
public AddOrUpdateServicePeriodRequest AddOrUpdateServicePeriod(AddOrUpdateServicePeriodRequest Info)
{
using (SqlConnection conn = new SqlConnection(BaseAccessor._dataBase.ConnectionString))
{
DataTable dtable = new DataTable();
SqlCommand cmd = new SqlCommand("Proc_Hilti_AddOrUpdateServicePeriod", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@EndCity", Info.EndCity);
cmd.Parameters[0].SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.AddWithValue("@EndCityID", Info.EndCityID);
cmd.Parameters[1].SqlDbType = SqlDbType.Int;
cmd.Parameters.AddWithValue("@Period", Info.Period);
cmd.Parameters[2].SqlDbType = SqlDbType.Int;
cmd.Parameters.AddWithValue("@ErrorValue", "");
cmd.Parameters[3].Direction = ParameterDirection.Output;
cmd.Parameters[3].SqlDbType = SqlDbType.NVarChar;
cmd.Parameters[3].Size = 2000;
conn.Open();
cmd.ExecuteNonQuery();
Info.ErrorValue = cmd.Parameters[3].Value.ToString();
return(Info);
}
}
