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