/// <summary> /// 添加违章查询城市配置 /// </summary> /// <param name="model"></param> /// <param name="user"></param> /// <returns></returns> public bool AddPeccancyCityConfig(PeccancyQueryCityModel model, string user) { var result = false; try { using (var dbhelper = new Tuhu.Component.Common.SqlDbHelper(grconnectionString)) { result = DalPeccancyQueryConfig.AddPeccancyCityConfig(dbhelper, model); if (result) { var log = new PeccancyConfigOprLogModel { LogType = "PeccancyCityConfig", IdentityId = $"{model.CityId}", OperationType = "Add", OldValue = null, NewValue = JsonConvert.SerializeObject(model), Remarks = $"添加 违章查询城市:{model.CityName} 的配置", Operator = user, }; LoggerManager.InsertLog("PeccancyConfigOprLog", log); } } } catch (Exception ex) { Logger.Error("AddPeccancyCityConfig", ex); } return(result); }
/// <summary> /// 更新违章查询省份配置 /// </summary> /// <param name="province"></param> /// <param name="user"></param> /// <returns></returns> public bool UpdatePeccancyProvinceConfig(PeccancyQueryProvinceModel province, string user) { var result = false; try { var oldValue = DalPeccancyQueryConfig.GetPeccancyProvinceConfigByProvinceId(province.ProvinceId); if (oldValue != null) { using (var dbhelper = new Tuhu.Component.Common.SqlDbHelper(grconnectionString)) { result = DalPeccancyQueryConfig.UpdatePeccancyProvinceConfig(dbhelper, province); } if (result) { var log = new PeccancyConfigOprLogModel { LogType = "PeccancyProvinceConfig", IdentityId = $"{province.ProvinceId}", OperationType = "Update", OldValue = JsonConvert.SerializeObject(oldValue), NewValue = JsonConvert.SerializeObject(province), Remarks = $"更新 违章查询省份:{province.ProvinceName} 的配置", Operator = user, }; LoggerManager.InsertLog("PeccancyConfigOprLog", log); } } } catch (Exception ex) { Logger.Error("UpdatePeccancyProvinceConfig", ex); } return(result); }
/// <summary> /// 查看违章配置操作记录详情 /// </summary> /// <param name="pkid"></param> /// <returns></returns> public PeccancyConfigOprLogModel GetPeccancyConfigOprLog(int pkid) { var result = null as PeccancyConfigOprLogModel; try { result = DalPeccancyQueryConfig.GetPeccancyConfigOprLog(pkid); } catch (Exception ex) { Logger.Error("GetPeccancyConfigOprLog", ex); } return(result); }
/// <summary> /// 查看违章配置操作日志 /// </summary> /// <param name="logType"></param> /// <param name="identityId"></param> /// <returns></returns> public List <PeccancyConfigOprLogModel> SelectPeccancyConfigOprLog(string logType, string identityId) { var result = null as List <PeccancyConfigOprLogModel>; try { result = DalPeccancyQueryConfig.SelectPeccancyConfigOprLog(logType, identityId); } catch (Exception ex) { Logger.Error("SelectPeccancyConfigOprLog", ex); } return(result); }
/// <summary> /// 根据城市Id获取违章查询城市配置 /// </summary> /// <param name="cityId"></param> /// <returns></returns> public PeccancyQueryCityModel GetPeccancyCityConfigByCityId(int cityId) { PeccancyQueryCityModel peccancyCityModel = null; try { peccancyCityModel = DalPeccancyQueryConfig.GetPeccancyCityConfigByCityId(cityId); } catch (Exception ex) { Logger.Error("GetPeccancyCityConfigByCityId", ex); } return(peccancyCityModel); }
/// <summary> /// 根据省份Id获取违章查询省份配置 /// </summary> /// <param name="provinceId"></param> /// <returns></returns> public PeccancyQueryProvinceModel GetPeccancyProvinceConfigByProvinceId(int provinceId) { PeccancyQueryProvinceModel model = null; try { model = DalPeccancyQueryConfig.GetPeccancyProvinceConfigByProvinceId(provinceId); } catch (Exception ex) { Logger.Error("GetPeccancyProvinceConfigByProvinceId", ex); } return(model); }
/// <summary> /// 查询违章查询城市配置 /// </summary> /// <param name="provinceId"></param> /// <param name="cityId"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public Tuple <List <PeccancyQueryCityModel>, int> SelectPeccancyCityConfig(int provinceId, int cityId, int pageIndex, int pageSize) { var result = new Tuple <List <PeccancyQueryCityModel>, int>(null, 0); try { result = DalPeccancyQueryConfig.SelectPeccancyCityConfig(provinceId, cityId, pageIndex, pageSize); } catch (Exception ex) { Logger.Error("SelectPeccancyCityConfig", ex); } return(result); }
/// <summary> /// 获取所有配置的省份 /// </summary> /// <returns></returns> public List <PeccancyRegionMiniModel> GetAllPeccancyProvinces() { List <PeccancyRegionMiniModel> result = null; try { result = DalPeccancyQueryConfig.GetAllPeccancyProvinces(); } catch (Exception ex) { Logger.Error("GetAllPeccancyProvinces", ex); } return(result); }
/// <summary> /// 获取该省份下的城市配置数量 /// </summary> /// <param name="provinceId"></param> /// <returns></returns> public int GetPeccancyCityConfigCountByPrvinceId(int provinceId) { var cityCount = -1; try { cityCount = DalPeccancyQueryConfig.GetPeccancyCityConfigCountByPrvinceId(provinceId); } catch (Exception ex) { Logger.Error("GetPeccancyCityConfigCountByPrvinceId", ex); } return(cityCount); }
/// <summary> /// 省份配置是否重复 /// </summary> /// <param name="peccancyProvinceModel"></param> /// <returns></returns> public PeccancyQueryProvinceModel GetRepeatPeccancyProvinceConfig(PeccancyQueryProvinceModel peccancyProvinceModel) { PeccancyQueryProvinceModel result = null; try { result = DalPeccancyQueryConfig.GetRepeatPeccancyProvinceConfig(peccancyProvinceModel); } catch (Exception ex) { Logger.Error("GetRepeatPeccancyProvinceConfig", ex); } return(result); }
/// <summary> /// 获取该省份下的城市--下拉框选项 /// </summary> /// <param name="provinceId"></param> /// <returns></returns> public List <PeccancyRegionMiniModel> GetPeccancyCitiesByProvinceId(int provinceId) { List <PeccancyRegionMiniModel> result = null; try { var configs = DalPeccancyQueryConfig.GetPeccancyCitiesByProvinceId(provinceId); result = configs?.Select(s => new PeccancyRegionMiniModel { RegionId = s.CityId, RegionName = s.CityName }).ToList(); } catch (Exception ex) { Logger.Error("GetPeccancyCitiesByProvinceId", ex); } return(result); }
/// <summary> /// 删除违章查询城市配置 /// </summary> /// <param name="cityId"></param> /// <returns></returns> public bool DeletePeccancyCityConfig(int cityId, string user) { var result = false; try { var oldValue = DalPeccancyQueryConfig.GetPeccancyCityConfigByCityId(cityId); if (oldValue != null) { using (var dbhelper = new Tuhu.Component.Common.SqlDbHelper(grconnectionString)) { result = DalPeccancyQueryConfig.DeletePeccancyCityConfigByCityId(dbhelper, cityId); } if (result) { var log = new PeccancyConfigOprLogModel { LogType = "PeccancyCityConfig", IdentityId = $"{oldValue.CityId}", OperationType = "Delete", OldValue = JsonConvert.SerializeObject(oldValue), NewValue = null, Remarks = $"删除 违章查询城市:{oldValue.CityName} 的配置", Operator = user, }; LoggerManager.InsertLog("PeccancyConfigOprLog", log); } } else { result = true; } } catch (Exception ex) { Logger.Error("DeletePeccancyCityConfig", ex); } return(result); }
/// <summary> /// 删除违章查询省份配置 /// </summary> /// <param name="provinceId"></param> /// <returns></returns> public bool DeletePeccancyProvinceConfig(int provinceId, string user) { var result = false; try { using (var dbhelper = new Tuhu.Component.Common.SqlDbHelper(grconnectionString)) { var oldValue = DalPeccancyQueryConfig.GetPeccancyProvinceConfigByProvinceId(provinceId); if (oldValue != null) { var cityConfigs = DalPeccancyQueryConfig.GetPeccancyCitiesByProvinceId(provinceId); if (cityConfigs != null && cityConfigs.Any()) { dbhelper.BeginTransaction(); var deleteProvince = DalPeccancyQueryConfig.DeletePeccancyCityConfigByProvinceId(dbhelper, provinceId); var deleteCity = DalPeccancyQueryConfig.DeletePeccancyProvinceConfig(dbhelper, provinceId);//同时删除该省份下的所有城市配置 if (deleteProvince && deleteCity) { dbhelper.Commit(); result = true; #region 除的省份和城市记录日志 var logs = new List <PeccancyConfigOprLogModel>(); var provinceLog = new PeccancyConfigOprLogModel { LogType = "PeccancyProvinceConfig", IdentityId = $"{oldValue.ProvinceId}", OperationType = "Delete", OldValue = JsonConvert.SerializeObject(oldValue), NewValue = null, Remarks = $"删除 违章查询省份:{oldValue.ProvinceName} 的配置", Operator = user, }; logs.Add(provinceLog); foreach (var city in cityConfigs) { var cityLog = new PeccancyConfigOprLogModel { LogType = "PeccancyCityConfig", IdentityId = $"{city.CityId}", OperationType = "Delete", OldValue = JsonConvert.SerializeObject(city), NewValue = null, Remarks = $"删除 违章查询城市:{city.CityName} 的配置", Operator = user, }; logs.Add(cityLog); } if (logs.Any()) { logs.ForEach(s => LoggerManager.InsertLog("PeccancyConfigOprLog", s)); } #endregion } } else { result = DalPeccancyQueryConfig.DeletePeccancyProvinceConfig(dbhelper, provinceId); if (result) { var log = new PeccancyConfigOprLogModel { LogType = "PeccancyProvinceConfig", IdentityId = $"{oldValue.ProvinceId}", OperationType = "Delete", OldValue = JsonConvert.SerializeObject(oldValue), NewValue = null, Remarks = $"删除 违章查询省份:{oldValue.ProvinceName} 的配置", Operator = user, }; LoggerManager.InsertLog("PeccancyConfigOprLog", log); } } } else { result = true; } } } catch (Exception ex) { Logger.Error("DeletePeccancyProvinceConfig", ex); } return(result); }