/// <summary> /// 查询年检代办配置 /// </summary> /// <param name="servicePid"></param> /// <param name="carNoPrefix"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public Tuple <List <VehicleAnnualInspectionAgentModel>, int> SelectVehicleAnnualInspectionAgent (string servicePid, string carNoPrefix, int pageIndex, int pageSize) { var result = null as List <VehicleAnnualInspectionAgentModel>; var totalCount = 0; try { var configs = dbScopeManagerConfigurationRead.Execute(conn => DalVehicleAnnualInspectionAgent.SelectVehicleAnnualInspectionAgent(conn, servicePid, carNoPrefix, pageIndex, pageSize, out totalCount)) ?? new List <VehicleAnnualInspectionAgentModel>(); var allService = GetAllAnnualInspectionService(); configs.ForEach( f => { var service = allService.Where(w => string.Equals(w.ServicePid, f.ServicePid))?.FirstOrDefault(); f.ServiceName = service?.ServiceName; }); result = configs; } catch (Exception ex) { result = null; Logger.Error("SelectVehicleAnnualInspectionAgent", ex); } return(Tuple.Create(result, totalCount)); }
/// <summary> /// 判断年检配置唯一性 /// 同PID同城市(车牌前缀),只能有一条启用的数据 /// PID、车牌前缀、供应商简称 作唯一性约束 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool IsExistAnnualInspectionAgent(VehicleAnnualInspectionAgentModel model) { var result = true; try { result = dbScopeManagerConfigurationRead.Execute (conn => DalVehicleAnnualInspectionAgent.IsExistAnnualInspectionAgent(conn, model)); } catch (Exception ex) { Logger.Error("IsExistAnnualInspectionAgent", ex); } return(result); }
/// <summary> /// 获取所有车牌前缀 /// </summary> /// <returns></returns> public Dictionary <string, List <string> > GetAllCarNoPrefix() { var result = null as Dictionary <string, List <string> >; try { var prefix = dbScopeManagerGungnirRead.Execute(conn => DalVehicleAnnualInspectionAgent.GetAllCarNoPrefix(conn)); result = prefix.GroupBy(s => s.ProvinceName).ToDictionary(c => c.Key, c => c.Select(s => s.PlatePrefix).Distinct().ToList()); } catch (Exception ex) { Logger.Error("GetAllCarNoPrefix", ex); } return(result); }
/// <summary> /// 获取所有年检代办服务 /// </summary> /// <returns></returns> public List <AnnualInspectionServiceModel> GetAllAnnualInspectionService() { var result = null as List <AnnualInspectionServiceModel>; try { result = dbScopeManagerProductcatalogRead.Execute (conn => DalVehicleAnnualInspectionAgent.GetAllAnnualInspectionService(conn)); } catch (Exception ex) { Logger.Error("GetAllAnnualInspectionService", ex); } return(result ?? new List <AnnualInspectionServiceModel>()); }
/// <summary> /// 查询年检代办操作日志 /// </summary> /// <param name="logType"></param> /// <param name="identityId"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public List <AnnualInspectionOprLogModel> SelectAnnualInspectionOprLog (string logType, string identityId, int pageIndex = 1, int pageSize = 20) { var result = null as List <AnnualInspectionOprLogModel>; try { result = dbScopeManagerTuhulog.Execute (conn => DalVehicleAnnualInspectionAgent.SelectAnnualInspectionOprLog(conn, logType, identityId, pageIndex, pageSize)); } catch (Exception ex) { Logger.Error("SelectAnnualInspectionOprLog", ex); } return(result); }
public bool AddVehicleOnlineAnnualInspectionAgent(VehicleAnnualInspectionAgentModel model, string user) { var result = false; try { var oldValue = GetVehicleOnlineAnnualInspectionAgent(model.ServicePid, model.Province, model.City, model.Village); if (oldValue == null) { var pkid = dbScopeManagerConfiguration.Execute (conn => DalVehicleAnnualInspectionAgent.AddVehicleOnlineAnnualInspectionAgent(conn, model)); result = pkid > 0; model.PKID = pkid; } else if (oldValue.IsDeleted) { model.PKID = oldValue.PKID; result = dbScopeManagerConfiguration.Execute (conn => DalVehicleAnnualInspectionAgent.UpdateVehicleOnlineAnnualInspectionAgent(conn, model)); } model.CreateDateTime = DateTime.Now; model.LastUpdateDateTime = DateTime.Now; var log = new AnnualInspectionOprLogModel { LogType = "VehicleOnlineAnnualInspectionAgent", IdentityId = $"{model.Province}_{model.City}_{model.Village}", OperationType = "Add", OldValue = null, NewValue = JsonConvert.SerializeObject(model), Remarks = $"添加{model.Province}_{model.City}_{model.Village},供应商:{model.VenderShortName}," + $"服务Pid:{model.ServicePid},联系电话:{model.TelNum},联系邮箱:{model.Email} " + $"的{model.ServiceName}服务", Operator = user, }; LoggerManager.InsertLog("AnnualInspectOprLog", log); } catch (Exception ex) { result = false; Logger.Error("AddVehicleOnlineAnnualInspectionAgent", ex); } return(result); }
/// <summary> /// 删除年检代办配置 /// </summary> /// <param name="carNoPrefix"></param> /// <param name="telNum"></param> /// <param name="servicePid"></param> /// <param name="user"></param> /// <returns></returns> public bool DeleteVehicleOnlineAnnualInspectionAgent (string servicePid, string province, string city, string village, string user) { var result = false; try { var oldValue = GetVehicleOnlineAnnualInspectionAgent(servicePid, province, city, village); if (oldValue != null && !oldValue.IsDeleted) { result = dbScopeManagerConfiguration.Execute(conn => DalVehicleAnnualInspectionAgent.DeleteVehicleAnnualInspectionAgent(conn, oldValue.PKID)); if (!result) { throw new Exception($"DeleteVehicleOnlineAnnualInspectionAgent,待删除数据{JsonConvert.SerializeObject(oldValue)}"); } var log = new AnnualInspectionOprLogModel { LogType = "VehicleAnnualInspectionAgent", IdentityId = $"{province}_{city}_{village}", OperationType = "Delete", OldValue = JsonConvert.SerializeObject(oldValue), NewValue = null, Remarks = $"删除{oldValue.Province}_{oldValue.City}_{oldValue.Village},供应商:{oldValue.VenderShortName}," + "服务Pid:{model.ServicePid},联系电话:{model.TelNum},联系邮箱:{model.Email}" + "的{model.ServiceName}服务的年检代办服务", Operator = user, }; LoggerManager.InsertLog("AnnualInspectOprLog", log); } else { result = true; } } catch (Exception ex) { result = false; Logger.Error("DeleteVehicleOnlineAnnualInspectionAgent", ex); } return(result); }
/// <summary> /// 删除年检代办配置 /// </summary> /// <param name="carNoPrefix"></param> /// <param name="telNum"></param> /// <param name="servicePid"></param> /// <param name="user"></param> /// <returns></returns> public bool DeleteVehicleAnnualInspectionAgent (string servicePid, string telNum, string carNoPrefix, string user) { var result = false; try { var oldValue = GetVehicleAnnualInspectionAgent(servicePid, telNum, carNoPrefix); if (oldValue != null && !oldValue.IsDeleted) { result = dbScopeManagerConfiguration.Execute(conn => DalVehicleAnnualInspectionAgent.DeleteVehicleAnnualInspectionAgent(conn, oldValue.PKID)); if (!result) { throw new Exception($"DeleteVehicleAnnualInspectionAgent失败,待删除数据{JsonConvert.SerializeObject(oldValue)}"); } var log = new AnnualInspectionOprLogModel { LogType = "VehicleAnnualInspectionAgent", IdentityId = $"{carNoPrefix}_{servicePid}_{telNum}", OperationType = "Delete", OldValue = JsonConvert.SerializeObject(oldValue), NewValue = null, Remarks = $"删除{oldValue.CarNoPrefix},供应商:{oldValue.VenderShortName},服务Pid:{oldValue.ServicePid}," + $"联系人:{oldValue.Contact},联系电话:{oldValue.TelNum}的年检代办服务", Operator = user, }; LoggerManager.InsertLog("AnnualInspectOprLog", log); } else { result = true; } } catch (Exception ex) { result = false; Logger.Error("DeleteVehicleAnnualInspectionAgent", ex); } return(result); }
/// <summary> /// 更新年检代办配置 /// </summary> /// <param name="model"></param> /// <param name="user"></param> /// <returns></returns> public bool UpdateVehicleAnnualInspectionAgent (VehicleAnnualInspectionAgentModel model, string user) { var result = false; try { var oldValue = GetVehicleAnnualInspectionAgent(model.ServicePid, model.TelNum, model.CarNoPrefix); if (oldValue != null) { result = dbScopeManagerConfiguration.Execute(conn => DalVehicleAnnualInspectionAgent.UpdateVehicleAnnualInspectionAgent(conn, model)); if (!result) { throw new Exception($"UpdateVehicleAnnualInspectionAgent失败,待更新数据{JsonConvert.SerializeObject(model)}"); } model.CreateDateTime = oldValue.CreateDateTime; model.LastUpdateDateTime = DateTime.Now; var log = new AnnualInspectionOprLogModel { LogType = "VehicleAnnualInspectionAgent", IdentityId = $"{model.CarNoPrefix}_{model.ServicePid}_{model.TelNum}", OperationType = "Update", OldValue = JsonConvert.SerializeObject(oldValue), NewValue = JsonConvert.SerializeObject(model), Remarks = $"更新{model.CarNoPrefix},供应商:{model.VenderShortName},服务Pid:{model.ServicePid}," + $"联系人:{model.Contact},联系电话{model.TelNum}的{model.ServiceName}服务", Operator = user, }; LoggerManager.InsertLog("AnnualInspectOprLog", log); } } catch (Exception ex) { result = false; Logger.Error("UpdateVehicleAnnualInspectionAgent", ex); } return(result); }
/// <summary> /// 刷新年检代办服务缓存 /// </summary> /// <returns></returns> public bool RefreshAnnualInspectionAgentCache() { var result = false; try { var models = dbScopeManagerGungnirRead.Execute(conn => DalVehicleAnnualInspectionAgent.GetAllCarNoPrefix(conn)); var carNoPrefix = models?.Select(s => s.PlatePrefix).ToList(); if (carNoPrefix != null && carNoPrefix.Any()) { using (var client = new Service.Config.CacheClient()) { var cacheResult = client.RefreshVehicleAnnualInspectionAgentCache(carNoPrefix); cacheResult.ThrowIfException(true); result = cacheResult.Result; } } } catch (Exception ex) { Logger.Error("RefreshAnnualInspectionAgentCache", ex); } return(result); }
/// <summary> /// 获取年检代办配置 /// </summary> /// <param name="servicePid"></param> /// <param name="telNum"></param> /// <param name="carNoPrefix"></param> /// <returns></returns> private VehicleAnnualInspectionAgentModel GetVehicleAnnualInspectionAgent (string servicePid, string telNum, string carNoPrefix) { return(dbScopeManagerConfigurationRead.Execute (conn => DalVehicleAnnualInspectionAgent.GetAnnualInspectionAgent(conn, servicePid, telNum, carNoPrefix))); }
private VehicleAnnualInspectionAgentModel GetVehicleOnlineAnnualInspectionAgent (string servicePid, string province, string city, string village) { return(dbScopeManagerConfigurationRead.Execute (conn => DalVehicleAnnualInspectionAgent.GetAnnualOnlineInspectionAgent(conn, servicePid, province, city, village))); }