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); } }