/// <summary> /// 删除对应关系 /// </summary> /// <param name="pkid"></param> /// <param name="user"></param> /// <returns></returns> public bool DeletePingAnRegionPackageMap(int pkid, string user) { var result = false; try { result = dbScopeManager.Execute(conn => DALRegionPackageMap.DeletePingAnRegionPackageMap(conn, pkid)); } catch (Exception ex) { Logger.Error(ex); } return(result); }
/// <summary> /// 新增对应关系 /// </summary> /// <param name="data"></param> /// <param name="user"></param> /// <returns></returns> public Tuple <bool, string> UpsertPingAnRegionPackageMap(PingAnRegionPackageMap data, string user) { var result = false; var msg = ""; try { dbScopeManager.CreateTransaction(conn => { var allConfig = DALRegionPackageMap.GetAllPingAnRegionPackageMapList(conn); var isExist = false; if (!string.IsNullOrEmpty(data.BYPackagePID)) { isExist = allConfig?.Where(_ => String.Equals(_.BYPackagePID, data.BYPackagePID))?.Count() > 0; } else if (data.PackageId != null && data.PackageId != Guid.Empty) { isExist = allConfig?.Where(_ => String.Equals(_.PackageId, data.PackageId))?.Count() > 0; } data.RegionId = data.CityId > 0 ? data.CityId : (data.ProvinceId > 0 ? data.ProvinceId : 0); if (!isExist) { result = DALRegionPackageMap.InsertPingAnRegionPackageMap(conn, data); } else { msg = "该美容包或保养套餐已存在关联关系"; } }); } catch (Exception ex) { Logger.Error(ex); } return(Tuple.Create(result, msg)); }
/// <summary> /// 获取地区和包的对应关系 /// </summary> /// <param name="packageId"></param> /// <param name="byPackagePID"></param> /// <param name="businessId"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public List <PingAnRegionPackageMap> GetPingAnRegionPackageMapList(Guid?packageId, string byPackagePID, string businessId, int pageIndex, int pageSize) { List <PingAnRegionPackageMap> result = null; try { result = dbScopeReadManager.Execute(conn => DALRegionPackageMap.GetPingAnRegionPackageMapList(conn, packageId, byPackagePID, businessId, pageIndex, pageSize)); if (result != null && result.Any()) { result.ForEach(x => { var region = ShopService.GetRegionByRegionId(x.RegionId); if (region != null && region.RegionId > 0) { if (region.IsBelongMunicipality) { if (region.RegionType == RegionType.District) { x.ProvinceId = region.ProvinceId; x.ProvinceName = region.ProvinceName; x.CityId = region.RegionId; x.CityName = region.RegionName; x.RegionName = region.ProvinceName + "-" + region.RegionName; } else { x.ProvinceId = region.RegionId; x.ProvinceName = region.RegionName; x.RegionName = region.RegionName; } } else { switch (region.RegionType) { case RegionType.Province: x.ProvinceId = region.RegionId; x.ProvinceName = region.RegionName; x.RegionName = region.RegionName; break; case RegionType.City: x.ProvinceId = region.ProvinceId; x.ProvinceName = region.ProvinceName; x.CityId = region.RegionId; x.CityName = region.RegionName; x.RegionName = region.ProvinceName + "-" + region.CityName; break; case RegionType.District: x.ProvinceId = region.ProvinceId; x.ProvinceName = region.ProvinceName; x.CityId = region.RegionId; x.CityName = region.RegionName; x.RegionName = region.ProvinceName + "-" + region.CityName + "-" + region.DistrictName; break; } } } //if (!string.IsNullOrEmpty(x.BYPackagePID)) //{ // x.BYPakageName = new VipBaoYangPackageManager().SelectVipBaoYangPackageByPkid(Convert.ToInt32(x.BYPackagePID.Split('|')[1]))?.PackageName; //} //else if (x.PackageId != null && x.PackageId != Guid.Empty) //{ // x.PackageName = GeneralBeautyServerCodeManager.Instanse.GetGeneralBeautyServerCodeTmpDetail(x.PackageId.Value)?.PackageName; //} }); } } catch (Exception ex) { Logger.Error(ex); } return(result); }