public bool UpdateTipBannerDetailConfig(TipBannerConfigDetailModel model, string user) { var result = false; try { var oldValue = dbScopeManagerConfigRead.Execute(conn => DalTipBannerConfig.GetTipBannerDetailConfigByPKID(conn, model.PKID)); if (oldValue != null) { result = dbScopeManagerConfig.Execute(conn => DalTipBannerConfig.UpdateTipBannerDetailConfig(conn, model)); if (result) { model.LastUpdateDateTime = DateTime.Now; var log = new BaoYangOprLog { LogType = "TipBannerDetailConfig", IdentityID = oldValue.TypeName, OldValue = JsonConvert.SerializeObject(oldValue), NewValue = JsonConvert.SerializeObject(model), Remarks = "Update", OperateUser = user, }; LoggerManager.InsertLog("BYOprLog", log); } } } catch (Exception ex) { Logger.Error("UpdateTipBannerDetailConfig", ex); } return(result); }
public bool AddTipBannerDetailConfig(TipBannerConfigDetailModel model, string user) { var result = false; try { var pkid = dbScopeManagerConfig.Execute(conn => DalTipBannerConfig.AddTipBannerDetailConfig(conn, model)); if (pkid > 0) { result = true; model.PKID = pkid; model.CreateDateTime = DateTime.Now; model.LastUpdateDateTime = DateTime.Now; var log = new BaoYangOprLog { LogType = "TipBannerDetailConfig", IdentityID = model.TypeName, OldValue = null, NewValue = JsonConvert.SerializeObject(model), Remarks = "Add", OperateUser = user, }; LoggerManager.InsertLog("BYOprLog", log); } } catch (Exception ex) { Logger.Error("AddTipBannerDetailConfig", ex); } return(result); }
public bool DeleteTipBannerDetailConfigByPKID(int pkid, string user) { var result = false; try { var oldValue = dbScopeManagerConfigRead.Execute(conn => DalTipBannerConfig.GetTipBannerDetailConfigByPKID(conn, pkid)); if (oldValue != null) { result = dbScopeManagerConfig.Execute(conn => DalTipBannerConfig.DeleteTipBannerDetailConfigByPKID(conn, pkid)); if (result) { var log = new BaoYangOprLog { LogType = "TipBannerDetailConfigByPKID", IdentityID = oldValue.TypeName, OldValue = JsonConvert.SerializeObject(oldValue), NewValue = null, Remarks = "Delete", OperateUser = user, }; LoggerManager.InsertLog("BYOprLog", log); } } } catch (Exception ex) { Logger.Error("DeleteTipBannerDetailConfigByPKID", ex); } return(result); }
public static bool UsertEnterpriseUserConfig(EnterpriseUserViewModel data, string user) { var result = false; try { using (var dbhelper = new SqlDbHelper(BeautyServicePackageDal.GetTuhuGrouponWriteConnstr())) { dbhelper.BeginTransaction(); var userConfig = BeautyServicePackageDal.SelectEnterpriseUserConfigByUserId(dbhelper, data.UserId); var moduleConfig = BeautyServicePackageDal.SelectEnterpriseUserModuleConfigByUserId(dbhelper, data.UserId); if (userConfig != null && userConfig.Any()) { BeautyServicePackageDal.DeleteEnterpriseUserConfigByUserId(dbhelper, data.UserId); } if (moduleConfig != null && moduleConfig.Any()) { BeautyServicePackageDal.DeleteEnterpriseModuleConfigByUserId(dbhelper, data.UserId); } if (data.PackageDetailIds != null && data.PackageDetailIds.Any()) { foreach (var item in data.PackageDetailIds) { BeautyServicePackageDal.InsertEnterpriseUserConfig(dbhelper, data.UserId, item, data.Remark); } } else { BeautyServicePackageDal.InsertEnterpriseUserConfig(dbhelper, data.UserId, 0, data.Remark);//允许不配服务模板 } if (data.UserModuleDetails != null && data.UserModuleDetails.Any()) { foreach (var item in data.UserModuleDetails) { BeautyServicePackageDal.InsertEnterpriseUserModuleConfig(dbhelper, data.UserId, item.ModuleType); } } dbhelper.Commit(); result = true; var log = new BaoYangOprLog { LogType = "EnterpriseUserConfig", IdentityID = data.UserId.ToString(), OldValue = "[]", NewValue = JsonConvert.SerializeObject(data), Remarks = $"发码服务权限修改 {data.UserMobile}", OperateUser = user, }; LoggerManager.InsertLog("BeautyOprLog", log); } } catch (Exception ex) { Logger.Error(ex.Message, ex); } return(result); }
/// <summary> /// 批量删除保养活动地区配置 /// </summary> /// <param name="regionIds"></param> /// <param name="user"></param> /// <returns></returns> public Tuple <bool, bool> MultDeleteBaoYangActivityRegion(List <int> regionIds, string user) { var result = false; var cacheResult = false; try { var logData = new List <BaoYangOprLog>(); if (regionIds != null && regionIds.Any()) { dbScopeManagerGungnir.CreateTransaction(conn => { foreach (var regionId in regionIds) { if (regionId > 0) { var oldValue = GetBaoYangActivityRegionByRegionId(regionId); if (oldValue != null) { var delResult = DalBaoYangActivitySetting.DeleteBaoYangActivityRegion(conn, regionId); if (!delResult) { throw new Exception($"DeleteBaoYangActivityRegion失败,{JsonConvert.SerializeObject(oldValue)}"); } var log = new BaoYangOprLog { LogType = "BaoYangActivityRegion", IdentityID = regionId.ToString(), OldValue = JsonConvert.SerializeObject(oldValue), NewValue = null, Remarks = "Delete", OperateUser = user, }; logData.Add(log); } } } result = true; }); foreach (var log in logData) { LoggerManager.InsertLog("BYOprLog", log); } cacheResult = CleanBaoYangActivityRegionCache(regionIds); } } catch (Exception ex) { Logger.Error("MultDeleteBaoYangActivityRegion", ex); } return(Tuple.Create(result, cacheResult)); }
/// <summary> /// 批量删除机油粘度特殊地区配置 /// </summary> /// <param name="regionIds"></param> /// <param name="user"></param> /// <returns></returns> public bool MultDeleteOilViscosityRegionConfig(List <int> regionIds, string user) { var result = false; try { var logData = new List <BaoYangOprLog>(); if (regionIds != null && regionIds.Any()) { dbScopeManagerGungnir.CreateTransaction(conn => { foreach (var regionId in regionIds) { if (regionId > 0) { var oldValue = GetOilViscosityRegionConfigByRegionId(regionId); if (oldValue != null && !oldValue.IsDeleted) { var delResult = DalBaoYangOilViscosityPriorityConfig.DeleteOilViscosityRegionConfig(conn, regionId); if (!delResult) { throw new Exception($"DeleteOilViscosityRegionConfig失败,{JsonConvert.SerializeObject(oldValue)}"); } var log = new BaoYangOprLog { LogType = "OilViscosityRegionConfig", IdentityID = regionId.ToString(), OldValue = JsonConvert.SerializeObject(oldValue), NewValue = null, Remarks = $"删除机油粘度配置:{oldValue.OilViscosity}", OperateUser = user, }; logData.Add(log); } } } result = true; }); foreach (var log in logData) { LoggerManager.InsertLog("BYOprLog", log); } } } catch (Exception ex) { Logger.Error("MultDeleteOilViscosityRegionConfig", ex); } return(result); }
/// <summary> /// 删除保养项目加价配置 --只做逻辑删除 /// </summary> /// <param name="pkid"></param> /// <param name="user"></param> /// <returns></returns> public bool DeleteBaoYangInstallFeeConfig(string serviceId, string user) { var result = true; try { var logs = new List <BaoYangOprLog>(); var configs = dbScopeManagerGungnirRead.Execute(conn => DalBaoYangInstallFeeConfig.SelectBaoYangInstallFeeConfig(conn, serviceId)); var oldValues = configs.Where(s => s.PKID > 0).ToList(); if (oldValues != null && oldValues.Any()) { dbScopeManagerGungnir.CreateTransaction(conn => { foreach (var oldValue in oldValues) { var isDel = DalBaoYangInstallFeeConfig.DeleteBaoYangInstallFeeConfigByPKID(conn, oldValue.PKID); if (!isDel) { throw new Exception($"DeleteBaoYangInstallFeeConfigByPKID失败,待删除数据{JsonConvert.SerializeObject(oldValue)}"); } var log = new BaoYangOprLog { LogType = "BaoYangInstallFeeConfig", IdentityID = oldValue.PKID.ToString(), OldValue = JsonConvert.SerializeObject(oldValues), NewValue = null, Remarks = $"删除保养项目:{oldValue.ServiceName}的加价配置", OperateUser = user, }; logs.Add(log); } }); foreach (var log in logs) { LoggerManager.InsertLog("BYOprLog", log); } } } catch (Exception ex) { result = false; Logger.Error("DeleteBaoYangInstallFeeConfig", ex); } return(result); }
/// <summary> /// 添加日志 /// </summary> /// <param name="model"></param> /// <param name="name"></param> /// <returns></returns> public BaoYangResultEntity <bool> SaveBatteryLevelUpLog(BatteryLevelUpEntity oldbatteryLevelUp, BatteryLevelUpEntity newbatteryLevelUp, string name) { BaoYangResultEntity <bool> result = new BaoYangResultEntity <bool>() { Status = true }; var log = new BaoYangOprLog() { CreateTime = DateTime.Now, LogType = "BaoYangProductBatteryLevelUpSetting", Remarks = oldbatteryLevelUp == null ? "添加" : (newbatteryLevelUp == null ? "删除" : "修改"), IdentityID = newbatteryLevelUp == null ? oldbatteryLevelUp.OriginalPID : newbatteryLevelUp.OriginalPID, NewValue = JsonConvert.SerializeObject(newbatteryLevelUp ?? new BatteryLevelUpEntity()), OldValue = JsonConvert.SerializeObject(oldbatteryLevelUp ?? new BatteryLevelUpEntity()), OperateUser = name }; LoggerManager.InsertLog("BYOprLog", log); return(result); }
/// <summary> /// 添加日志 /// </summary> /// <param name="model"></param> /// <param name="name"></param> /// <returns></returns> public BaoYangResultEntity <bool> SaveCouponActivityConfigLog(CouponActivityConfigV2Model oldModel, CouponActivityConfigV2Model newmodel, string name) { BaoYangResultEntity <bool> result = new BaoYangResultEntity <bool>() { Status = true }; var log = new BaoYangOprLog() { CreateTime = DateTime.Now, LogType = "BaoYangCouponActivityConfigSetting", Remarks = oldModel == null ? "添加" : (newmodel == null ? "删除" : "修改"), IdentityID = newmodel == null?oldModel.Id.ToString() : newmodel.Id.ToString(), NewValue = JsonConvert.SerializeObject(newmodel ?? new CouponActivityConfigV2Model()), OldValue = JsonConvert.SerializeObject(oldModel ?? new CouponActivityConfigV2Model()), OperateUser = name }; LoggerManager.InsertLog("BYOprLog", log); return(result); }
/// <summary> /// 添加保养关联项目配置 /// </summary> /// <param name="model"></param> /// <param name="user"></param> /// <returns></returns> public bool AddBaoYangPackageTypeRelation(BaoYangPackageTypeRelationViewModel model, string user) { var result = false; try { var oldValue = GetBaoYangPackageTypeRelation(model.MainPackageType); if (oldValue == null) { var pkid = dbScopeManagerBaoYang.Execute (conn => DalBaoYangPackageTypeRelation.AddBaoYangPackageTypeRelation(conn, model)); result = pkid > 0; model.PKID = pkid; } else if (oldValue.IsDeleted) { model.PKID = oldValue.PKID; result = dbScopeManagerBaoYang.Execute (conn => DalBaoYangPackageTypeRelation.UpdateBaoYangPackageTypeRelation(conn, model)); } model.CreateDateTime = DateTime.Now; model.LastUpdateDateTime = DateTime.Now; var log = new BaoYangOprLog { LogType = "BaoYangPackageTypeRelation", IdentityID = $"{model.MainPackageType}", OldValue = null, NewValue = JsonConvert.SerializeObject(model), Remarks = $"添加主项目为{model.MainPackageType}的保养关联项目配置", OperateUser = user, }; LoggerManager.InsertLog("BYOprLog", log); } catch (Exception ex) { result = false; Logger.Error("AddBaoYangPackageTypeRelation", ex); } return(result); }
/// <summary> /// 删除保养关联项目配置 /// </summary> /// <param name="carNoPrefix"></param> /// <param name="surfaceCount"></param> /// <param name="servicePid"></param> /// <param name="user"></param> /// <returns></returns> public bool DeleteBaoYangPackageTypeRelation(string mainPackageType, string user) { var result = false; try { var oldValue = GetBaoYangPackageTypeRelation(mainPackageType); if (oldValue != null && !oldValue.IsDeleted) { result = dbScopeManagerBaoYang.Execute(conn => DalBaoYangPackageTypeRelation.DeleteBaoYangPackageTypeRelation(conn, oldValue.PKID)); if (!result) { throw new Exception($"DeleteBaoYangPackageTypeRelation失败,待删除数据{JsonConvert.SerializeObject(oldValue)}"); } var log = new BaoYangOprLog { LogType = "BaoYangPackageTypeRelation", IdentityID = mainPackageType, OldValue = JsonConvert.SerializeObject(oldValue), NewValue = null, Remarks = $"删除主项目为{mainPackageType}的保养关联项目配置", OperateUser = user, }; LoggerManager.InsertLog("BYOprLog", log); } else { result = true; } } catch (Exception ex) { result = false; Logger.Error("DeleteBaoYangPackageTypeRelation", ex); } return(result); }
/// <summary> /// 更新保养关联项目配置 /// </summary> /// <param name="model"></param> /// <param name="user"></param> /// <returns></returns> public bool UpdateBaoYangPackageTypeRelation(BaoYangPackageTypeRelationViewModel model, string user) { var result = false; try { var oldValue = GetBaoYangPackageTypeRelation(model.MainPackageType); if (oldValue != null) { model.PKID = oldValue.PKID; result = dbScopeManagerBaoYang.Execute(conn => DalBaoYangPackageTypeRelation.UpdateBaoYangPackageTypeRelation(conn, model)); if (!result) { throw new Exception($"UpdateBaoYangPackageTypeRelation失败,待更新数据{JsonConvert.SerializeObject(model)}"); } model.CreateDateTime = oldValue.CreateDateTime; model.LastUpdateDateTime = DateTime.Now; var log = new BaoYangOprLog { LogType = "BaoYangPackageTypeRelation", IdentityID = model.MainPackageType, OldValue = JsonConvert.SerializeObject(oldValue), NewValue = JsonConvert.SerializeObject(model), Remarks = $"更新主项目为{model.MainPackageType}的保养关联项目配置", OperateUser = user, }; LoggerManager.InsertLog("BYOprLog", log); } } catch (Exception ex) { result = false; Logger.Error("UpdateBaoYangPackageTypeRelation", ex); } return(result); }
/// <summary> /// 删除保养项目加价配置 --只做逻辑删除 /// </summary> /// <param name="pkid"></param> /// <param name="user"></param> /// <returns></returns> public bool DeleteBaoYangOilViscosityPriorityConfig(string originViscosity, string configType, string user) { var result = false; try { var oldValue = dbScopeManagerGungnirRead.Execute(conn => DalBaoYangOilViscosityPriorityConfig.GetBaoYangOilViscosityPriorityConfig(conn, originViscosity, configType)); if (oldValue != null && !oldValue.IsDeleted) { result = dbScopeManagerGungnir.Execute(conn => DalBaoYangOilViscosityPriorityConfig.DeleteBaoYangOilViscosityPriorityConfig(conn, oldValue.PKID)); if (!result) { throw new Exception($"DeleteBaoYangOilViscosityPriorityConfig失败,待删除数据{JsonConvert.SerializeObject(oldValue)}"); } var log = new BaoYangOprLog { LogType = "BaoYangOilViscosityPriorityConfig", IdentityID = oldValue.OriginViscosity, OldValue = JsonConvert.SerializeObject(oldValue), NewValue = null, Remarks = $"删除{oldValue.ConfigType}类原厂机油粘度{oldValue.OriginViscosity}推荐优先级:{oldValue.ViscosityPriority}", OperateUser = user, }; LoggerManager.InsertLog("BYOprLog", log); } else { result = true; } } catch (Exception ex) { result = false; Logger.Error("DeleteBaoYangOilViscosityPriorityConfig", ex); } return(result); }
/// <summary> /// 记录操作日志 /// </summary> /// <param name="log"></param> /// <returns></returns> private bool RecordOperationLog(BaoYangOprLog log) => Business.Logger.LoggerManager.InsertLog("BYOprLog", log);
/// <summary> /// 修改大客户美容服务码 /// </summary> /// <param name="model"></param> /// <param name="pkids"></param> /// <returns></returns> public static bool UpdateBeautyServicePackageDetailCodes(ServiceCodeDetail model, string user, ServiceCodeDetail oldCode) { var result = false; try { if (model.StartTime != null && model.EndTime != null) { using (var dbhelper = new Tuhu.Component.Common.SqlDbHelper(writeConnStr)) { dbhelper.BeginTransaction(); var upResult = true; if (model.PackageDetailCodeId > 0) { var oldValue = BeautyServicePackageDal.GetBeautyServicePackageDetailCodeByPKID(model.PackageDetailCodeId); if (oldValue != null) { #region 只更新服务码起止时间 其余数据保持不变 var newValue = new BeautyServicePackageDetailCode { PKID = model.PackageDetailCodeId, UserId = oldValue.UserId, PackageDetailId = oldValue.PackageDetailId, ServiceCode = oldValue.ServiceCode, IsActive = oldValue.IsActive, StartTime = model.StartTime, EndTime = model.EndTime, PackageCode = oldValue.PackageCode, VipUserId = oldValue.VipUserId }; #endregion upResult = BeautyServicePackageDal.UpdateBeautyServicePackageDetailCodes(dbhelper, newValue); } else { upResult = false; } } if (upResult) { using (var client = new ServiceCodeClient()) { var kxChangeCodeTimeModel = new ChangeCodeTimeRequest { ServiceCodes = new List <string>() { model.ServiceCode }, OverdueTime = model.EndTime }; var kxChangeResult = client.ChangeOverdueTime(kxChangeCodeTimeModel); kxChangeResult.ThrowIfException(true); if (kxChangeResult.Success && kxChangeResult.Result != null && kxChangeResult.Result.SuccessServiceCode.Count() > 0 && string.Equals(kxChangeResult.Result.SuccessServiceCode.FirstOrDefault(), model.ServiceCode)) { result = true; dbhelper.Commit(); var log = new BaoYangOprLog { LogType = "修改大客户美容服务码", IdentityID = oldCode.ServiceCode, OldValue = JsonConvert.SerializeObject(oldCode), NewValue = JsonConvert.SerializeObject(model), Remarks = $"修改服务码有效期:服务码开始时间从{oldCode.StartTime}变更为{model.StartTime},结束时间从{oldCode.EndTime}变更为{model.EndTime}", OperateUser = user, }; LoggerManager.InsertLog("BeautyOprLog", log); } else { throw new Exception($"快修服务修改服务码有效期失败,请求信息:{JsonConvert.SerializeObject(kxChangeCodeTimeModel)},返回信息:{JsonConvert.SerializeObject(kxChangeResult)}"); } } } } } } catch (Exception ex) { Logger.Error(ex.Message, ex); } return(result); }
/// <summary> /// 批量新增或更新保养活动地区配置 /// </summary> /// <param name="regionIds"></param> /// <param name="activityId"></param> /// <param name="user"></param> /// <returns></returns> public Tuple <bool, bool> MultiAddOrEditBaoYangActivityRegion(List <int> regionIds, string activityId, string user) { var result = false; var cacheResult = false; try { if (regionIds != null && regionIds.Any() && !string.IsNullOrWhiteSpace(activityId)) { var insertModels = new List <BaoYangActivityVehicleAndRegionModel>(); var updateModels = new List <BaoYangActivityVehicleAndRegionModel>(); var logData = new List <BaoYangOprLog>(); foreach (var regionId in regionIds) { var oldValue = GetBaoYangActivityRegionByRegionId(regionId); if (oldValue == null) { var insertModel = new BaoYangActivityVehicleAndRegionModel { VehicleId = null, ActivityId = activityId, RegionId = regionId, Type = "Region", CreateDateTime = DateTime.Now, LastUpdateDateTime = DateTime.Now }; insertModels.Add(insertModel); } else { updateModels.Add(oldValue); } } dbScopeManagerGungnir.CreateTransaction(conn => { foreach (var insertModel in insertModels) { var pkid = DalBaoYangActivitySetting.AddBaoYangActivityRegion(conn, insertModel); if (pkid < 1) { throw new Exception($"AddBaoYangActivityRegion失败,{JsonConvert.SerializeObject(insertModel)}"); } insertModel.PKID = pkid; var log = new BaoYangOprLog { LogType = "BaoYangActivityRegion", IdentityID = insertModel.RegionId.ToString(), OldValue = null, NewValue = JsonConvert.SerializeObject(insertModel), Remarks = "Add", OperateUser = user, }; logData.Add(log); } foreach (var oldValue in updateModels) { var updateModel = new BaoYangActivityVehicleAndRegionModel { PKID = oldValue.PKID, VehicleId = oldValue.VehicleId, ActivityId = activityId, RegionId = oldValue.RegionId, Type = oldValue.Type, CreateDateTime = oldValue.CreateDateTime, LastUpdateDateTime = DateTime.Now }; var updateResult = DalBaoYangActivitySetting.UpdateBaoYangActivityRegion(conn, updateModel); if (!updateResult) { throw new Exception($"UpdateBaoYangActivityRegion失败,{JsonConvert.SerializeObject(updateModel)}"); } var log = new BaoYangOprLog { LogType = "BaoYangActivityRegion", IdentityID = updateModel.RegionId.ToString(), OldValue = JsonConvert.SerializeObject(oldValue), NewValue = JsonConvert.SerializeObject(updateModel), Remarks = "Update", OperateUser = user, }; logData.Add(log); } result = true; }); foreach (var log in logData) { LoggerManager.InsertLog("BYOprLog", log); } cacheResult = CleanBaoYangActivityRegionCache(regionIds); } } catch (Exception ex) { Logger.Error("MultiAddOrEditBaoYangActivityRegion", ex); } return(Tuple.Create(result, cacheResult)); }
private bool InsertBaoYangOprLog(BaoYangOprLog log) => LoggerManager.InsertLog("BYOprLog", log);
/// <summary> /// 添加或编辑保养项目加价配置 /// </summary> /// <param name="models"></param> /// <param name="user"></param> /// <returns></returns> public bool AddOrEditBaoYangInstallFeeConfig(List <BaoYangInstallFeeConfigModel> models, string user) { var result = false; try { var delList = new List <BaoYangInstallFeeConfigModel>(); var logs = new List <BaoYangOprLog>(); var serviceId = models.Select(s => s.ServiceId).FirstOrDefault(); var configs = dbScopeManagerGungnirRead.Execute(conn => DalBaoYangInstallFeeConfig.SelectBaoYangInstallFeeConfig(conn, serviceId)); var existConfig = configs.Where(s => s.PKID > 0).ToList(); foreach (var oldValue in existConfig) { var sameValue = models.Where(model => (string.Equals(model.ServiceId, oldValue.ServiceId) && model.CarMinPrice.Equals(oldValue.CarMinPrice) && model.CarMaxPrice.Equals(oldValue.CarMaxPrice) && model.AddInstallFee.Equals(oldValue.AddInstallFee))).FirstOrDefault(); if (sameValue == null) { delList.Add(oldValue);//删除旧数据 } else { models.Remove(sameValue);//数据没变的不做任何操作 } } dbScopeManagerGungnir.CreateTransaction(conn => { #region 除旧数据 foreach (var oldValue in delList) { var log = new BaoYangOprLog { LogType = "BaoYangInstallFeeConfig", IdentityID = oldValue.PKID.ToString(), OldValue = JsonConvert.SerializeObject(oldValue), NewValue = null, Remarks = $"删除保养项目:{oldValue.ServiceName}的加价配置", OperateUser = user, }; logs.Add(log); DalBaoYangInstallFeeConfig.DeleteBaoYangInstallFeeConfigByPKID(conn, oldValue.PKID); } #endregion #region 插入新数据 foreach (var model in models) { var deletedModel = dbScopeManagerGungnirRead.Execute(co => DalBaoYangInstallFeeConfig.GetDeletedBaoYangInstallFeeConfig(co, model)); if (deletedModel != null) { var backUpResult = DalBaoYangInstallFeeConfig.BackUpBaoYangInstallFeeConfigByPKID(conn, deletedModel.PKID); if (!backUpResult) { throw new Exception($"BackUpBaoYangInstallFeeConfigByPKID失败,待插入数据{JsonConvert.SerializeObject(deletedModel)}"); } var log = new BaoYangOprLog { LogType = "BaoYangInstallFeeConfig", IdentityID = deletedModel.PKID.ToString(), OldValue = null, NewValue = JsonConvert.SerializeObject(deletedModel), Remarks = $"添加保养项目:{model.ServiceName}的加价配置", OperateUser = user, }; logs.Add(log); } else { var pkid = DalBaoYangInstallFeeConfig.AddBaoYangInstallFeeConfig(conn, model); if (pkid < 1) { throw new Exception($"AddBaoYangInstallFeeConfig失败,待插入数据{JsonConvert.SerializeObject(model)}"); } model.PKID = pkid; model.CreateDateTime = DateTime.Now; model.LastUpdateDateTime = DateTime.Now; var log = new BaoYangOprLog { LogType = "BaoYangInstallFeeConfig", IdentityID = model.PKID.ToString(), OldValue = null, NewValue = JsonConvert.SerializeObject(model), Remarks = $"添加保养项目:{model.ServiceName}的加价配置", OperateUser = user, }; logs.Add(log); } } #endregion result = true; }); foreach (var log in logs) { LoggerManager.InsertLog("BYOprLog", log); } } catch (Exception ex) { Logger.Error("AddOrEditBaoYangInstallFeeConfig", ex); } return(result); }
/// <summary> /// 添加或编辑机油粘度优先级配置 /// </summary> /// <param name="model"></param> /// <param name="user"></param> /// <returns></returns> public bool AddOrEditBaoYangOilViscosityPriorityConfig(BaoYangOilViscosityPriorityConfigModel model, string user) { var result = false; var log = null as BaoYangOprLog; try { var oldValue = dbScopeManagerGungnirRead.Execute(conn => DalBaoYangOilViscosityPriorityConfig.GetBaoYangOilViscosityPriorityConfig(conn, model.OriginViscosity, model.ConfigType)); #region 添加 判断是否存在该原厂粘度被逻辑删除的记录 存在则更新 不存在则插入 if (oldValue == null) { #region 插入记录 var pkid = dbScopeManagerGungnir.Execute(conn => DalBaoYangOilViscosityPriorityConfig.AddBaoYangOilViscosityPriorityConfig(conn, model)); if (pkid > 0) { result = true; model.PKID = pkid; log = new BaoYangOprLog { LogType = "BaoYangOilViscosityPriorityConfig", IdentityID = model.OriginViscosity, OldValue = null, NewValue = JsonConvert.SerializeObject(model), Remarks = $"添加{model.ConfigType}类原厂机油粘度{model.OriginViscosity}推荐优先级:{model.ViscosityPriority}", OperateUser = user, }; } #endregion } else if (oldValue.IsDeleted) { #region 更新逻辑删除的记录 result = dbScopeManagerGungnir.Execute(conn => DalBaoYangOilViscosityPriorityConfig.UpdateBaoYangOilViscosityPriorityConfig(conn, model)); log = new BaoYangOprLog { LogType = "BaoYangOilViscosityPriorityConfig", IdentityID = model.OriginViscosity, OldValue = null, NewValue = JsonConvert.SerializeObject(model), Remarks = $"添加{model.ConfigType}类原厂机油粘度{model.OriginViscosity}推荐优先级:{model.ViscosityPriority}", OperateUser = user, }; #endregion } #endregion #region 更新 else { result = dbScopeManagerGungnir.Execute(conn => DalBaoYangOilViscosityPriorityConfig.UpdateBaoYangOilViscosityPriorityConfig(conn, model)); log = new BaoYangOprLog { LogType = "BaoYangOilViscosityPriorityConfig", IdentityID = model.OriginViscosity, OldValue = JsonConvert.SerializeObject(oldValue), NewValue = JsonConvert.SerializeObject(model), Remarks = $"更新{model.ConfigType}类原厂机油粘度{model.OriginViscosity}推荐优先级:{model.ViscosityPriority}", OperateUser = user, }; } #endregion if (result && log != null) { LoggerManager.InsertLog("BYOprLog", log); } } catch (Exception ex) { Logger.Error("AddOrEditBaoYangOilViscosityPriorityConfig", ex); } return(result); }
/// <summary> /// 批量新增或更新机油粘度特殊地区配置 /// </summary> /// <param name="regionIds"></param> /// <param name="oilViscosity"></param> /// <param name="user"></param> /// <returns></returns> public bool MultAddOrEditOilViscosityRegionConfig(List <int> regionIds, string oilViscosity, string user) { var result = false; try { if (regionIds != null && regionIds.Any() && !string.IsNullOrWhiteSpace(oilViscosity)) { var insertModels = new List <OilViscosityRegionModel>(); var backupModels = new List <OilViscosityRegionModel>(); var updateModels = new List <OilViscosityRegionModel>(); var logData = new List <BaoYangOprLog>(); foreach (var regionId in regionIds) { var oldValue = GetOilViscosityRegionConfigByRegionId(regionId); if (oldValue == null) { var insertModel = new OilViscosityRegionModel { RegionId = regionId, OilViscosity = oilViscosity, CreateDateTime = DateTime.Now, LastUpdateDateTime = DateTime.Now }; insertModels.Add(insertModel); } else { if (oldValue.IsDeleted) { backupModels.Add(oldValue); } else { updateModels.Add(oldValue); } } } dbScopeManagerGungnir.CreateTransaction(conn => { foreach (var insertModel in insertModels) { var pkid = DalBaoYangOilViscosityPriorityConfig.AddOilViscosityRegionConfig(conn, insertModel); if (pkid < 1) { throw new Exception($"AddOilViscosityRegionConfig失败,{JsonConvert.SerializeObject(insertModel)}"); } insertModel.PKID = pkid; var log = new BaoYangOprLog { LogType = "OilViscosityRegionConfig", IdentityID = insertModel.RegionId.ToString(), OldValue = null, NewValue = JsonConvert.SerializeObject(insertModel), Remarks = $"添加机油粘度配置:{oilViscosity}", OperateUser = user, }; logData.Add(log); } foreach (var oldValue in updateModels) { var updateModel = new OilViscosityRegionModel { PKID = oldValue.PKID, RegionId = oldValue.RegionId, OilViscosity = oilViscosity, CreateDateTime = oldValue.CreateDateTime, LastUpdateDateTime = DateTime.Now, IsDeleted = false }; var updateResult = DalBaoYangOilViscosityPriorityConfig.UpdateOilViscosityRegionConfig(conn, updateModel); if (!updateResult) { throw new Exception($"UpdateOilViscosityRegionConfig失败,{JsonConvert.SerializeObject(updateModel)}"); } var log = new BaoYangOprLog { LogType = "OilViscosityRegionConfig", IdentityID = updateModel.RegionId.ToString(), OldValue = JsonConvert.SerializeObject(oldValue), NewValue = JsonConvert.SerializeObject(updateModel), Remarks = $"更新机油粘度配置:{oilViscosity}", OperateUser = user, }; logData.Add(log); } foreach (var backupModel in backupModels) { var updateModel = new OilViscosityRegionModel { PKID = backupModel.PKID, RegionId = backupModel.RegionId, OilViscosity = oilViscosity, CreateDateTime = backupModel.CreateDateTime, LastUpdateDateTime = DateTime.Now, IsDeleted = false }; var updateResult = DalBaoYangOilViscosityPriorityConfig.UpdateOilViscosityRegionConfig(conn, updateModel); if (!updateResult) { throw new Exception($"UpdateOilViscosityRegionConfig失败,{JsonConvert.SerializeObject(updateModel)}"); } var log = new BaoYangOprLog { LogType = "OilViscosityRegionConfig", IdentityID = updateModel.RegionId.ToString(), OldValue = JsonConvert.SerializeObject(backupModel), NewValue = JsonConvert.SerializeObject(updateModel), Remarks = $"添加机油粘度配置:{oilViscosity}", OperateUser = user, }; logData.Add(log); } result = true; }); foreach (var log in logData) { LoggerManager.InsertLog("BYOprLog", log); } } } catch (Exception ex) { Logger.Error("MultiAddOrEditOilViscosityRegionConfig", ex); } return(result); }