using cylsg.Model.ECTEModel;
|
using cylsg.Model.utilityViewModel;
|
using cylsg.utility.Extend;
|
using ECTESTOA;
|
using EzCoreNet.Redis;
|
using Furion.LinqBuilder;
|
using Models;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Linq.Expressions;
|
using System.Text;
|
using System.Threading.Tasks;
|
|
namespace cylsg.Application.CyOS
|
{
|
/// <summary>
|
/// 川印配送控制器
|
/// </summary>
|
[Authorize]
|
[ApiDescriptionSettings("CYOA")]
|
public class CyOsDeliverManage : IDynamicApiController
|
{
|
|
private readonly ISqlSugarClient _client;
|
private readonly IOAServices _oAServices;
|
private readonly IEzCoreNetRedisService _eZCoreNetRedisService;
|
private ECTESTOAPermissions Permissions;
|
public CyOsDeliverManage(ISqlSugarClient client, IOAServices oAServices, IEzCoreNetRedisService netRedisService)
|
{
|
_client = client.AsTenant().GetConnection("ECTESTOADB");
|
_oAServices = oAServices;
|
_eZCoreNetRedisService = netRedisService;
|
}
|
[HttpGet]
|
[AllowAnonymous]
|
public async Task<string> testc()
|
{
|
return await CreatDeliverPlanSn();
|
}
|
|
/// <summary>
|
/// 获取预约配送信息
|
/// </summary>
|
/// <param name="Param"></param>
|
/// <returns></returns>
|
[HttpPost]
|
public async Task<AppointmentDeliverRet> GetListAppointmentDeliverList(ApoointmentDeliverSearchParam Param)
|
{
|
|
if (!await CheckRols())
|
{
|
throw Oops.Oh("没有权限");
|
}
|
|
Expression<Func<OA_DeliverTixing, bool>> SearchList = (x) => true;
|
SearchList = SearchList.And(x => x.FirmId == _oAServices.firmId);
|
if (!string.IsNullOrEmpty(Param.Content))
|
{
|
SearchList = SearchList.And(x => x.Remark.Contains(Param.Content));
|
}
|
if (Param.MemberId != null)
|
{
|
SearchList = SearchList.And(x => x.FirmId == Param.MemberId);
|
}
|
if (Param.TimeStart != null)
|
{
|
SearchList = SearchList.And(x => x.CreateTime > Param.TimeStart);
|
}
|
if (Param.TimeEnd != null)
|
{
|
SearchList = SearchList.And(x => x.CreateTime < Param.TimeEnd);
|
}
|
|
|
//报销状态
|
if (Param.DeliverState != null)
|
{
|
SearchList = SearchList.And(x => x.Chulistatus == Param.DeliverState);
|
}
|
//强制增加员工过滤
|
RefAsync<int> totle = 0;
|
var data = await _client.Queryable<OA_DeliverTixing>().Includes(x => x.SentStaff)
|
.Where(SearchList).OrderByDescending(x => x.ChuliTime).ToPageListAsync(Param.page.PageIndex, Param.page.PageSize, totle);
|
|
Param.page.TotalCount = totle;
|
|
return new AppointmentDeliverRet
|
|
{
|
Data = data,
|
page = Param.page,
|
|
};
|
}
|
|
/// <summary>
|
/// 送货预约单详情
|
/// </summary>
|
/// <param name="KeiId"></param>
|
/// <returns></returns>
|
public async Task<OA_DeliverTixing> GetAppointmentDeliverInfo(int KeiId)
|
{
|
|
|
if (!await CheckRols())
|
{
|
throw Oops.Oh("没有权限");
|
}
|
var data = await _client.Queryable<OA_DeliverTixing>().Includes(x => x.SentStaff).Where(x => x.Keyid == KeiId && x.FirmId == _oAServices.firmId).FirstAsync();
|
|
return data;
|
|
|
}
|
/// <summary>
|
/// 受理
|
/// </summary>
|
/// <param name="Param"></param>
|
/// <returns></returns>
|
public async Task<int> AcceptAppointmentDeliver(int KeiId)
|
{
|
if (!(KeiId > 0))
|
throw Oops.Oh("Keyid不能为空");
|
|
|
if (!await CheckRols())
|
{
|
throw Oops.Oh("没有权限");
|
}
|
var data = await _client.Queryable<OA_DeliverTixing>().Where(x => x.Keyid == KeiId && x.FirmId == _oAServices.firmId).FirstAsync();
|
if (data == null)
|
throw Oops.Oh("没找到数据");
|
if (data.Chulistatus != AppointmentDeliverState.unAccept)
|
throw Oops.Oh("订单已处理");
|
|
data.Chulistatus = AppointmentDeliverState.Accept;
|
data.LastUpdateTime = DateTime.Now;
|
data.Updater = Permissions.MemberId;
|
return await _client.Updateable(data).ExecuteCommandAsync();
|
|
|
|
|
}
|
|
/// <summary>
|
/// 创建配送单
|
/// </summary>
|
/// <param name="Param"> 只需要传递</param>
|
/// <returns></returns>
|
[HttpPost]
|
public async Task<int> CreatDeliverPlan(OA_DeliverPlan Param)
|
{
|
OA_CarManage car = null;
|
if (Param.DriverId != null)
|
car = await _client.Queryable<OA_CarManage>().Where(x => x.StaffID == Param.DriverId && x.MemberID == _oAServices.firmId).FirstAsync();
|
|
if (!await CheckRols())
|
{
|
throw Oops.Oh("没有权限");
|
}
|
OA_CorporateClients cor = null;
|
if (Param.BuyerId != null)
|
cor = await _client.Queryable<OA_CorporateClients>().Where(x => x.Keyid == Param.BuyerId).FirstAsync();
|
OA_DeliverPlan DeliverPlan = new OA_DeliverPlan()
|
{
|
Keyid = Guid.NewGuid(),
|
FirmId = _oAServices.firmId,
|
BuyerId = Param.BuyerId ?? Guid.Empty,
|
DeliverTime = Param.DeliverTime,
|
CarId = car == null ? 0 : car.Keyid,
|
Wentifankui = "",
|
Xingzhengzhuize = "",
|
Yichangchuli = "",
|
Zhuyishixiang = "",
|
Gongzuokaoping = "",
|
|
|
Transferstatus = 1,
|
Sort = 1,
|
Creater = Param.Creater ?? Permissions.MemberId,
|
CreateTime = DateTime.Now,
|
DriverId = Param.DriverId,
|
SellerOrderId = await CreatDeliverPlanSn(),
|
Dianhua = Param.Dianhua,
|
Dizhi = Param.Dizhi,
|
Remark = Param.Remark,
|
BusinessManagerId = cor == null ? 0 : cor.BusinessManagerId,
|
Biddingcompany = cor == null ? 0 : (cor.Biddingcompany ?? 0),
|
ShifouDelivery = 1,
|
Lianxiren = Param.Lianxiren,
|
Deliveredstatus = (int)DeliveredType.Undeliver,
|
CompanyName = Param.CompanyName,
|
}; return await _client.Insertable(DeliverPlan).ExecuteCommandAsync();
|
}
|
|
|
|
/// <summary>
|
/// 获取送货单
|
/// </summary>
|
/// <param name="Param"></param>
|
/// <returns></returns>
|
[HttpPost]
|
public async Task<DeliverOderPageRet> GetDeliverPlans(DeliverPlanSearchParam Param)
|
{
|
if (!await CheckRols())
|
{
|
throw Oops.Oh("没有权限");
|
}
|
|
Expression<Func<OA_DeliverPlan, bool>> SearchList = (x) => true;
|
SearchList = SearchList.And(x => x.FirmId == _oAServices.firmId);
|
//SearchList = SearchList.And(x => x.Creater == Permissions.MemberId);//只看自己
|
SearchList = SearchList.And(x => x.ShifouDelivery != 2);//过滤有效
|
if (Param.DeliverKeyID != null)
|
{
|
SearchList = SearchList.And(x => x.DriverId == Param.DeliverKeyID);
|
}
|
//客户名称
|
if (!string.IsNullOrEmpty(Param.CorporateClient))
|
{
|
SearchList = SearchList.And(x => x.CompanyName.Contains(Param.CorporateClient));
|
}
|
if (Param.TimeStart != null)
|
{
|
SearchList = SearchList.And(x => x.DeliverTime > Param.TimeStart);
|
}
|
if (Param.TimeEnd != null)
|
{
|
SearchList = SearchList.And(x => x.DeliverTime < Param.TimeEnd.Value.AddDays(1));
|
}
|
if (Param.DeliveredState != null)
|
{
|
if (Param.DeliveredState != DeliveredType.Delivered)
|
{
|
SearchList = SearchList.And(x => x.Deliveredstatus != DeliveredType.Delivered);
|
}
|
else
|
{
|
SearchList = SearchList.And(x => x.Deliveredstatus == DeliveredType.Delivered);
|
}
|
}
|
|
//强制增加员工过滤
|
RefAsync<int> totle = 0;
|
var data = await _client.Queryable<OA_DeliverPlan>().Includes(x => x.Driver).Includes(x => x.SentStaff)
|
.Where(SearchList).OrderBy(x => x.Dizhi).OrderBy(x => x.Sort).ToPageListAsync(Param.page.PageIndex, Param.page.PageSize, totle);
|
|
Param.page.TotalCount = totle;
|
return new DeliverOderPageRet
|
|
{
|
Data = data,
|
page = Param.page,
|
|
};
|
|
|
}
|
|
/// <summary>
|
/// 修改订单
|
/// </summary>
|
/// <param name="Param"></param>
|
/// <returns></returns>
|
public async Task<bool> UpDataDeliverPlans(OA_DeliverPlan Param)
|
{
|
|
if (Param.Keyid == null)
|
throw Oops.Oh("ID错误");
|
if (!await CheckRols())
|
{
|
throw Oops.Oh("没有权限");
|
}
|
var data = await _client.Queryable<OA_DeliverPlan>().Where(x => x.ShifouDelivery != 2 && x.Keyid == Param.Keyid).FirstAsync();
|
data.LastUpdateTime = DateTime.Now;
|
data.Updater = Permissions.MemberId;
|
if (data.DriverId != Param.DriverId)
|
{
|
data.DriverId = Param.DriverId;
|
var car = await _client.Queryable<OA_CarManage>().Where(x => x.StaffID == Param.DriverId && x.MemberID == _oAServices.firmId).FirstAsync();
|
data.CarId = car == null ? 0 : car.Keyid;
|
}
|
|
data.DeliverTime = Param.DeliverTime;
|
data.Remark = Param.Remark;
|
|
data.CompanyName = Param.CompanyName;
|
data.Dizhi = Param.Dizhi;
|
data.Lianxiren = Param.Lianxiren;
|
data.Dianhua = Param.Dianhua;
|
data.Sort = Param.Sort;
|
if (Param.Attachments != null)
|
foreach (var item in Param.Attachments)
|
{
|
if (item.Keyid > 0)
|
{
|
|
}
|
else
|
{
|
item.OA_Id = data.Keyid;
|
item.CreateTime = DateTime.Now;
|
item.Operator = Permissions.Name;
|
}
|
}
|
data.Attachments = Param.Attachments;
|
|
return await _client.UpdateNav(data).Include(x => x.Attachments, new UpdateNavOptions()
|
{
|
OneToManyInsertOrUpdate = true,
|
}).ExecuteCommandAsync();
|
|
|
|
}
|
|
|
/// <summary>
|
/// 修改订单
|
/// </summary>
|
/// <param name="Param"></param>
|
/// <returns></returns>
|
public async Task<bool> SortDeliverPlans(SortPlanIn Param)
|
{
|
|
|
|
if (!await CheckRols())
|
{
|
throw Oops.Oh("没有权限");
|
}
|
|
var Active = await _client.Queryable<OA_DeliverPlan>().Where(x => x.Keyid == Param.ActiveKeyId).FirstAsync();
|
if (Active == null)
|
throw Oops.Oh("当前无法排序");
|
|
var ActiveList = await _client.Queryable<OA_DeliverPlan>().Where(x => x.CreateTime < Active.CreateTime.Value.AddDays(1).Date && x.CreateTime > Active.CreateTime.Value.Date).ToListAsync();
|
|
return true;
|
|
|
}
|
|
/// <summary>
|
/// 获取送货单详情
|
/// </summary>
|
/// <param name="KeyId"></param>
|
/// <returns></returns>
|
public async Task<OA_DeliverPlan> GetDeliverPlanInfo(Guid KeyId)
|
{
|
|
if (!await CheckRols())
|
{
|
throw Oops.Oh("没有权限");
|
}
|
return await _client.Queryable<OA_DeliverPlan>().Includes(x => x.SentStaff).Includes(x => x.Attachments).Includes(x => x.Driver).Includes(x => x.Manager)
|
.Where(x => x.Keyid == KeyId && x.ShifouDelivery != 2).FirstAsync();
|
|
}
|
/// <summary>
|
/// 判断是否具有权限
|
/// </summary>
|
/// <returns></returns>
|
private async Task<bool> CheckRols()
|
{
|
var pr = await _oAServices.GetOAPermissions();
|
Permissions = pr;
|
if (pr != null && pr.MemberId != null)
|
{
|
if (pr.BF_IsDeliverManage == true)
|
|
|
return true;
|
else
|
return false;
|
|
}
|
else
|
return false;
|
}
|
|
/// <summary>
|
/// 生成sn号
|
/// </summary>
|
/// <returns></returns>
|
private async Task<string> CreatDeliverPlanSn()
|
{
|
// var sn = await _client.Queryable<OA_DeliverPlan>().Where(x => x.CreateTime >= DateTime.Now.Date && x.CreateTime < DateTime.Now.AddDays(1).Date).OrderByDescending(x => x.SellerOrderId).Select(x => x.SellerOrderId).FirstAsync();
|
|
var sn = await _client.Queryable<OA_DeliverPlan>().Where(x => x.CreateTime.Value.Date == DateTime.Now.Date).OrderByDescending(x => x.SellerOrderId).Select(x => x.SellerOrderId).FirstAsync();
|
if (sn != null)
|
{
|
try
|
{
|
var datasn = sn.Length > 3
|
? sn.Substring(sn.Length - 3)
|
: sn; ;
|
int data = datasn.toInt();
|
data += 1;
|
var str = DateTime.Now.ToString("yyyyMMdd");
|
return DateTime.Now.ToString("yyyyMMdd") + data.ToString("D3");
|
}
|
catch (Exception)
|
{
|
|
return DateTime.Now.ToString("yyyyMMdd") + 1.ToString("D3");
|
}
|
|
}
|
|
return DateTime.Now.ToString("yyyymmdd") + 1.ToString("D3");
|
}
|
|
}
|
public class ApoointmentDeliverSearchParam
|
{
|
/// <summary>
|
/// 起始时间
|
/// </summary>
|
public DateTime? TimeStart { get; set; }
|
/// <summary>
|
/// 结束时间
|
/// </summary>
|
public DateTime? TimeEnd { get; set; }
|
|
/// <summary>
|
/// 内容
|
/// </summary>
|
public string Content { get; set; }
|
|
/// <summary>
|
/// 员工ID
|
/// </summary>
|
public Guid? MemberId { get; set; }
|
|
/// <summary>
|
/// 受理状态
|
/// </summary>
|
public AppointmentDeliverState? DeliverState { get; set; }
|
|
/// <summary>
|
/// 页面参数
|
/// </summary>
|
public PageModel page { get; set; }
|
}
|
|
|
public class DeliverPlanSearchParam
|
{
|
|
/// <summary>
|
/// 起始时间
|
/// </summary>
|
public DateTime? TimeStart { get; set; }
|
/// <summary>
|
/// 结束时间
|
/// </summary>
|
public DateTime? TimeEnd { get; set; }
|
|
/// <summary>
|
/// 司机KeyID
|
/// </summary>
|
public int? DeliverKeyID { get; set; }
|
|
|
/// <summary>
|
/// 客户名称
|
/// </summary>
|
public string CorporateClient { get; set; }
|
|
/// <summary>
|
/// 配送状态
|
/// </summary>
|
public DeliveredType? DeliveredState { get; set; }
|
/// <summary>
|
/// 页面参数
|
/// </summary>
|
public PageModel page { get; set; }
|
}
|
|
/// <summary>
|
/// 拖动时最后变量
|
/// </summary>
|
public class SortPlanIn()
|
{
|
/// <summary>
|
/// 拖动的KeyID
|
/// </summary>
|
public Guid ActiveKeyId { get; set; }
|
|
|
/// <summary>
|
/// 下一层的项的KeyID
|
/// </summary>
|
public Guid LowerKeyId { get; set; }
|
|
|
/// <summary>
|
/// 上一层的邻居的KeyId
|
/// </summary>
|
public Guid SuperiorKeyId { get; set; }
|
/// <summary>
|
/// 拖动方向
|
/// </summary>
|
public DirectionalType Directional { get; set; }
|
|
}
|
|
public enum DirectionalType
|
{
|
/// <summary>
|
/// 向上拖动
|
/// </summary>
|
Up,
|
/// <summary>
|
/// 向下拖动
|
/// </summary>
|
Down,
|
}
|
}
|
