/***********************************************************************
|
* Project: baifenBinfa
|
* ProjectName: 百分兵法管理系统
|
* Web: http://chuanyin.com
|
* Author:
|
* Email:
|
* CreateTime: 202403/02
|
* Description: 暂无
|
***********************************************************************/
|
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Linq.Expressions;
|
using System.Threading.Tasks;
|
using CoreCms.Net.Caching.Manual;
|
using CoreCms.Net.Configuration;
|
using CoreCms.Net.IRepository;
|
using CoreCms.Net.IRepository.UnitOfWork;
|
using CoreCms.Net.IServices;
|
using CoreCms.Net.Loging;
|
using CoreCms.Net.Model.Entities;
|
using CoreCms.Net.Model.ViewModels.Basics;
|
using CoreCms.Net.Model.ViewModels.DTO;
|
using CoreCms.Net.Model.ViewModels.UI;
|
using CoreCms.Net.Utility.Extensions;
|
using SqlSugar;
|
|
namespace CoreCms.Net.Services.Basic
|
{
|
public class CoreCmsAreaServices : BaseServices<CoreCmsArea>, ICoreCmsAreaServices
|
{
|
private readonly ICoreCmsAreaRepository _dal;
|
private readonly IUnitOfWork _unitOfWork;
|
public CoreCmsAreaServices(IUnitOfWork unitOfWork, ICoreCmsAreaRepository dal)
|
{
|
this._dal = dal;
|
base.BaseDal = dal;
|
_unitOfWork = unitOfWork;
|
}
|
|
#region 实现重写增删改查操作==========================================================
|
|
/// <summary>
|
/// 重写异步插入方法
|
/// </summary>
|
/// <param name="entity">实体数据</param>
|
/// <returns></returns>
|
public async Task<AdminUiCallBack> InsertAsync(CoreCmsArea entity)
|
{
|
return await _dal.InsertAsync(entity);
|
}
|
|
/// <summary>
|
/// 重写异步更新方法方法
|
/// </summary>
|
/// <param name="entity"></param>
|
/// <returns></returns>
|
public async Task<AdminUiCallBack> UpdateAsync(CoreCmsArea entity)
|
{
|
return await _dal.UpdateAsync(entity);
|
}
|
|
/// <summary>
|
/// 重写删除指定ID的数据
|
/// </summary>
|
/// <param name="id"></param>
|
/// <returns></returns>
|
public async Task<AdminUiCallBack> DeleteByIdAsync(object id)
|
{
|
return await _dal.DeleteByIdAsync(id);
|
}
|
|
#endregion
|
|
#region 获取缓存的所有数据==========================================================
|
|
/// <summary>
|
/// 获取缓存的所有数据
|
/// </summary>
|
/// <returns></returns>
|
public async Task<List<CoreCmsArea>> GetCaChe()
|
{
|
return await _dal.GetCaChe();
|
}
|
|
#endregion
|
|
#region 获取所有省市区信息
|
/// <summary>
|
/// 获取所有省市区信息
|
/// </summary>
|
/// <returns></returns>
|
public async Task<List<AreaTreeDto>> GetTreeArea(List<PostAreasTreeNode> checkedAreases, int parentId = 0,
|
int currentChecked = 0)
|
{
|
var list = await GetCaChe();
|
var areaTrees = GetTrees(list, parentId, checkedAreases, currentChecked);
|
return areaTrees;
|
}
|
|
/// <summary>
|
/// 迭代方法
|
/// </summary>
|
/// <param name="oldNavs"></param>
|
/// <param name="parentId"></param>
|
/// <returns></returns>
|
private static List<AreaTreeDto> GetTrees(List<CoreCmsArea> allDatas, int parentId, List<PostAreasTreeNode> checkedAreases, int currentChecked = 0)
|
{
|
List<AreaTreeDto> childTree = new List<AreaTreeDto>();
|
var model = allDatas.Where(p => p.parentId == parentId).ToList();
|
foreach (var item in model)
|
{
|
var areaTree = new AreaTreeDto();
|
areaTree.id = item.id;
|
areaTree.title = item.name;
|
areaTree.isLast = allDatas.Exists(p => p.parentId == item.id) == false;
|
areaTree.level = (int)item.depth;
|
areaTree.parentId = (int)item.parentId;
|
|
var isChecked = "0";
|
var idStr = item.id.ToString();
|
var parentIdStr = item.parentId.ToString();
|
//判断是否选中的数据
|
if (checkedAreases != null)
|
{
|
var areaModel = checkedAreases.Find(p => p.id == idStr);
|
if (areaModel != null)
|
{
|
isChecked = areaModel.ischecked.ToString();
|
}
|
var parentModel = checkedAreases.Find(p => p.id == parentIdStr);
|
if (parentModel != null && parentModel.ischecked == 1)
|
{
|
isChecked = "1";
|
}
|
}
|
//当前父节点是1，下面肯定都是1
|
if (currentChecked == 1)
|
{
|
isChecked = "1";
|
}
|
|
var checkArr = new AreaTreeCheckArr()
|
{
|
@checked = isChecked,
|
type = "0"
|
};
|
areaTree.checkArr = new List<AreaTreeCheckArr>();
|
areaTree.checkArr.Add(checkArr);
|
|
childTree.Add(areaTree);
|
areaTree.children = GetTrees(allDatas, item.id, checkedAreases, currentChecked);
|
}
|
return childTree;
|
}
|
|
|
#endregion
|
|
#region 组装地区数据
|
/// <summary>
|
/// 组装地区数据
|
/// </summary>
|
public List<AreaTreeDto> resolve2(List<CoreCmsArea> allDatas, int parentId, List<PostAreasTreeNode> checkedAreases, int currentChecked = 0)
|
{
|
var areaTreeList = new List<AreaTreeDto>();
|
var nowList = allDatas.Where(p => p.parentId == parentId).ToList();
|
foreach (var item in nowList)
|
{
|
var isChecked = "0";
|
var idStr = item.id.ToString();
|
var parentIdStr = item.parentId.ToString();
|
|
//判断是否选中的数据
|
if (checkedAreases != null)
|
{
|
var model = checkedAreases.Find(p => p.id == idStr);
|
if (model != null)
|
{
|
isChecked = model.ischecked.ToString();
|
}
|
var parentModel = checkedAreases.Find(p => p.id == parentIdStr);
|
if (parentModel != null && parentModel.ischecked == 1)
|
{
|
isChecked = "1";
|
}
|
}
|
//当前父节点是1，下面肯定都是1
|
if (currentChecked == 1)
|
{
|
isChecked = "1";
|
}
|
|
var isLast = false;
|
var isChild = allDatas.Exists(p => p.parentId == item.id);
|
if (!isChild)
|
{
|
isLast = true;
|
}
|
|
var areaTree = new AreaTreeDto();
|
areaTree.id = item.id;
|
areaTree.title = item.name;
|
areaTree.isLast = isLast;
|
areaTree.level = (int)item.depth;
|
areaTree.parentId = (int)item.parentId;
|
var checkArr = new AreaTreeCheckArr()
|
{
|
@checked = isChecked,
|
type = "0"
|
};
|
areaTree.checkArr = new List<AreaTreeCheckArr>();
|
areaTree.checkArr.Add(checkArr);
|
areaTreeList.Add(areaTree);
|
}
|
return areaTreeList;
|
}
|
|
#endregion
|
|
#region 根据areaId获取三级区域名称
|
|
/// <summary>
|
/// 根据areaId获取三级区域名称
|
/// </summary>
|
/// <param name="areaId"></param>
|
/// <param name="cacheAreas"></param>
|
/// <returns></returns>
|
public async Task<WebApiCallBack> GetAreaFullName(int areaId, List<CoreCmsArea> cacheAreas = null)
|
{
|
var jm = new WebApiCallBack { status = true };
|
|
cacheAreas ??= await GetCaChe();
|
var arr = GetArea(cacheAreas, areaId);
|
var str = string.Empty;
|
if (arr.Any())
|
{
|
arr.Reverse();//倒序
|
arr.ForEach(p => { str += p.name + " "; });
|
}
|
jm.data = str;
|
|
return jm;
|
}
|
#endregion
|
|
#region 根据id来返回省市区信息，如果没有查到，就返回省的列表
|
/// <summary>
|
/// 根据id来返回省市区信息，如果没有查到，就返回省的列表
|
/// </summary>
|
public List<CoreCmsArea> GetArea(List<CoreCmsArea> cacheAreas, int id = 0)
|
{
|
var outAreas = new List<CoreCmsArea>();
|
|
if (id > 0)
|
{
|
GetParentArea(cacheAreas, id, outAreas);
|
}
|
return outAreas;
|
}
|
|
#endregion
|
|
#region 递归取得父节点信息
|
|
/// <summary>
|
/// 递归取得父节点信息
|
/// </summary>
|
/// <param name=""></param>
|
/// <param name="id"></param>
|
/// <param name="outAreas"></param>
|
/// <param name="cacheAreas"></param>
|
/// <returns></returns>
|
private void GetParentArea(List<CoreCmsArea> cacheAreas, int id, List<CoreCmsArea> outAreas)
|
{
|
//获取当前级别
|
var model = cacheAreas.FirstOrDefault(p => p.id == id);
|
if (model != null)
|
{
|
if (outAreas.All(p => p.id != model.id)) outAreas.Add(model);
|
//获取父级
|
var parentModel = cacheAreas.Find(p => p.id == model.parentId);
|
if (parentModel != null)
|
{
|
if (outAreas.All(p => p.id != parentModel.id)) outAreas.Add(parentModel);
|
if (parentModel.parentId != 0)
|
{
|
//上面还有节点
|
var parentParentModel = cacheAreas.Find(p => p.id == parentModel.parentId);
|
if (parentParentModel != null && outAreas.All(p => p.id != parentParentModel.id)) outAreas.Add(parentParentModel);
|
}
|
}
|
}
|
}
|
#endregion
|
|
#region 获取最终地区ID
|
/// <summary>
|
/// 获取最终地区ID
|
/// </summary>
|
/// <param name="provinceName">省</param>
|
/// <param name="cityName">市</param>
|
/// <param name="countyName">县</param>
|
/// <param name="postalCode">邮编</param>
|
/// <returns></returns>
|
public async Task<WebApiCallBack> GetAreaId(string provinceName, string cityName, string countyName, string postalCode)
|
{
|
var jm = new WebApiCallBack();
|
|
if (string.IsNullOrEmpty(provinceName) || string.IsNullOrEmpty(cityName) || string.IsNullOrEmpty(countyName))
|
{
|
jm.msg = "请提交合法参数信息";
|
return jm;
|
}
|
|
jm = new WebApiCallBack
|
{
|
status = true,
|
data = await GetThreeAreaId(provinceName, cityName, countyName, postalCode)
|
};
|
return jm;
|
}
|
|
/// <summary>
|
/// 获取最终地区ID
|
/// </summary>
|
/// <param name="provinceName">省</param>
|
/// <param name="cityName">市</param>
|
/// <param name="countyName">县</param>
|
/// <param name="postalCode">邮编</param>
|
/// <returns></returns>
|
public async Task<int> GetThreeAreaId(string provinceName, string cityName, string countyName, string postalCode)
|
{
|
var areaData = await GetCaChe();
|
var id = 0;
|
var countyList = areaData.Where(p => p.depth == (int)GlobalEnumVars.AreaDepth.County && p.name == countyName).ToList();
|
if (countyList.Any())
|
{
|
if (countyList.Count > 1)
|
{
|
var cityModel = areaData.Find(p => p.depth == (int)GlobalEnumVars.AreaDepth.City && p.name == cityName);
|
if (cityModel != null)
|
{
|
//foreach (var item in countyList)
|
//{
|
// if (item.parentId == cityModel.id)
|
// {
|
// id = item.id;
|
// }
|
//}
|
var result = countyList.Find(p => p.parentId == cityModel.id);
|
return result?.id ?? 0;
|
}
|
}
|
else
|
{
|
id = countyList[0].id;
|
}
|
}
|
else
|
{
|
//var cityModel = areaData.Find(p => p.depth == (int)GlobalEnumVars.AreaDepth.City && p.name == cityName);
|
//if (cityModel != null)
|
//{
|
// //创建区域
|
// var area = new CoreCmsArea();
|
// area.depth = (int)GlobalEnumVars.AreaDepth.County;
|
// area.name = countyName;
|
// area.postalCode = postalCode;
|
// area.parentId = cityModel.id;
|
// area.sort = 100;
|
// id = await base.InsertAsync(area);
|
|
// await UpdateCaChe();
|
|
//}
|
//else
|
//{
|
// var province = areaData.Find(p => p.depth == (int)GlobalEnumVars.AreaDepth.Province && p.name == provinceName);
|
// if (province != null)
|
// {
|
// //创建城市
|
// var areaCity = new CoreCmsArea();
|
// areaCity.depth = (int)GlobalEnumVars.AreaDepth.City;
|
// areaCity.name = cityName;
|
// //areaCity.postalCode = postalCode;
|
// areaCity.parentId = province.id;
|
// areaCity.sort = 100;
|
// var cityId = await base.InsertAsync(areaCity);
|
|
// //创建区域
|
// var areaCounty = new CoreCmsArea();
|
// areaCounty.depth = (int)GlobalEnumVars.AreaDepth.County;
|
// areaCounty.name = countyName;
|
// areaCounty.postalCode = postalCode;
|
// areaCounty.parentId = cityId;
|
// areaCounty.sort = 100;
|
// id = await base.InsertAsync(areaCounty);
|
// }
|
// else
|
// {
|
// //创建省
|
// var areaProvince = new CoreCmsArea();
|
// areaProvince.depth = (int)GlobalEnumVars.AreaDepth.Province;
|
// areaProvince.name = cityName;
|
// //areaCity.postalCode = postalCode;
|
// areaProvince.parentId = (int)GlobalEnumVars.AreaDepth.ProvinceParentId;
|
// areaProvince.sort = 100;
|
// var provinceId = await base.InsertAsync(areaProvince);
|
|
// //创建城市
|
// var areaCity = new CoreCmsArea();
|
// areaCity.depth = (int)GlobalEnumVars.AreaDepth.City;
|
// areaCity.name = cityName;
|
// //areaCity.postalCode = postalCode;
|
// areaCity.parentId = provinceId;
|
// areaCity.sort = 100;
|
// var cityId = await base.InsertAsync(areaCity);
|
|
// //创建区域
|
// var areaCounty = new CoreCmsArea();
|
// areaCounty.depth = (int)GlobalEnumVars.AreaDepth.County;
|
// areaCounty.name = countyName;
|
// areaCounty.postalCode = postalCode;
|
// areaCounty.parentId = cityId;
|
// areaCounty.sort = 100;
|
// id = await base.InsertAsync(areaCounty);
|
// }
|
// await UpdateCaChe();
|
//}
|
}
|
|
return id;
|
}
|
|
|
#endregion
|
#region 根据code获取信息
|
/// <summary>
|
/// liao
|
/// </summary>
|
/// <param name="Code"></param>
|
/// <returns></returns>
|
|
public async Task<string> GetAreaString(string Code)
|
{
|
List<CoreCmsArea> areaData = await GetCaChe();
|
var name = areaData.Where(x => x.id == Code.ToInt32OrDefault(-1)).Select(x => x.name).FirstOrDefault();
|
|
return areaData.Where(x => x.id == Code.ToInt32OrDefault(-1)).Select(x=>x.name).FirstOrDefault();
|
|
}
|
#endregion
|
|
}
|
}
|
