using Model.ModelDto;
|
using Model.ModelDto.BllSoDto;
|
using Model.ModelDto.SysDto;
|
using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
using System.Diagnostics;
|
using System.Linq;
|
using System.Linq.Expressions;
|
using System.Text;
|
using WMS.DAL;
|
using WMS.Entity.BllSoEntity;
|
using WMS.Entity.Context;
|
using WMS.Entity.SysEntity;
|
using WMS.IBLL.ISysServer;
|
|
namespace WMS.BLL.SysServer
|
{
|
/// <summary>
|
/// 物料类别管理方法
|
/// </summary>
|
public class MaterialCategoryServer : DbHelper<SysMaterialCategory>, IMaterialCategoryServer
|
{
|
|
private static readonly SqlSugarScope Db = DataContext.Db;
|
public MaterialCategoryServer() : base(Db)
|
{
|
}
|
|
/// <summary>
|
/// 获取物料类别信息
|
/// </summary>
|
/// <param name="categoryName">类别名称</param>
|
/// <param name="areaNo">区域编码</param>
|
/// <returns></returns>
|
/// <exception cref="Exception"></exception>
|
public List<MaterialCategoryDto> GetMaterialCategories(string categoryName, string areaNo)
|
{
|
try
|
{
|
//var list = Db.Queryable<MaterialCategoryDto>()
|
// .WhereIF(!string.IsNullOrWhiteSpace(categoryName), a => a.CategoryName == categoryName)
|
// .WhereIF(!string.IsNullOrWhiteSpace(areaNo), a => a.AreaNo == areaNo)
|
// .Where(a => a.IsDel == "0").ToList();
|
|
|
Expression<Func<SysMaterialCategory, bool>> item = Expressionable.Create<SysMaterialCategory>()
|
.AndIF(!string.IsNullOrWhiteSpace(categoryName), it => it.CategoryName.Contains(categoryName))
|
.AndIF(!string.IsNullOrWhiteSpace(areaNo), it => it.AreaNo.Contains(areaNo))
|
.And(it => it.IsDel == "0")
|
.ToExpression();//注意 这一句 不能少
|
|
var data = GetAllWhereAsync(item)
|
.Includes(x => x.CreateUserInfo)
|
.Includes(x => x.UpdateUserInfo).ToList();
|
//.LeftJoin<SysWareHouse>((a, b) => a.WareHouseNo == b.WareHouseNo)
|
//.LeftJoin<SysUserInfor>((a, b, c) => a.CreateUser == c.Id)
|
//.LeftJoin<SysUserInfor>((a, b, c, d) => a.UpdateUser == d.Id)
|
var data2 = data.Select(a => new MaterialCategoryDto()
|
{
|
Id = a.Id,
|
|
CategoryNo = a.CategoryNo, //类别编码
|
CategoryName = a.CategoryName, //类别名称
|
|
AreaNo = a.AreaNo, //区域号
|
AreaName = GetStorageArea(a.AreaNo), //区域名称
|
|
//WareHouseNo = a.WareHouseNo, //仓库号
|
//WareHouseName = a.WareHouseInfo.WareHouseName, //仓库名称
|
|
Demo = a.Demo, //备注
|
IsDel = a.IsDel,
|
|
CreateName = a.CreateUserInfo.RealName,
|
UpdateName = a.UpdateUserInfo == null ? "" : a.UpdateUserInfo.RealName,
|
|
CreateTime = a.CreateTime,
|
UpdateTime = a.UpdateTime,
|
}).ToList();
|
|
|
|
return data2;
|
}
|
catch (Exception ex)
|
{
|
throw new Exception(ex.Message);
|
}
|
}
|
|
/// <summary>
|
/// 获取物料类别下拉菜单信息
|
/// </summary>
|
/// <returns></returns>
|
/// <exception cref="Exception"></exception>
|
public List<SysMaterialCategory> GetMaterialCategories()
|
{
|
try
|
{
|
//var list = Db.Queryable<MaterialCategoryDto>()
|
// .WhereIF(!string.IsNullOrWhiteSpace(categoryName), a => a.CategoryName == categoryName)
|
// .WhereIF(!string.IsNullOrWhiteSpace(areaNo), a => a.AreaNo == areaNo)
|
// .Where(a => a.IsDel == "0").ToList();
|
|
var list = Db.Queryable<SysMaterialCategory>().Where(a => a.IsDel == "0").ToList();
|
return list;
|
}
|
catch (Exception ex)
|
{
|
throw new Exception(ex.Message);
|
}
|
}
|
|
/// <summary>
|
/// 根据Id获取物料类别信息
|
/// </summary>
|
/// <param name="Id">Id</param>
|
/// <returns></returns>
|
/// <exception cref="Exception"></exception>
|
public SysMaterialCategory GetMaterialCategoriesById(int Id)
|
{
|
try
|
{
|
var list = Db.Queryable<SysMaterialCategory>().Where(a => a.IsDel == "0" && a.Id == Id).First();
|
return list;
|
}
|
catch (Exception ex)
|
{
|
|
throw new Exception(ex.Message);
|
}
|
}
|
|
/// <summary>
|
/// 获取巷道信息
|
/// </summary>
|
/// <param name="AreaNo">巷道号</param>
|
/// <returns></returns>
|
/// <exception cref="Exception"></exception>
|
public string GetStorageArea(string AreaNo)
|
{
|
try
|
{
|
string str = "";
|
if (string.IsNullOrWhiteSpace(AreaNo))
|
{
|
return str;
|
}
|
else
|
{
|
//判断是否需要进行分割字符串
|
var arr = AreaNo.Split(',');
|
//获取区域信息
|
var list = Db.Queryable<SysStorageArea>().Where(a => a.IsDel == "0" && arr.Contains(a.AreaNo)).ToList();
|
//拼接字符串
|
|
foreach (var item in list)
|
{
|
str += item.AreaName + ";";
|
}
|
return str;
|
}
|
|
}
|
catch (Exception ex)
|
{
|
|
throw new Exception("获取巷道信息异常" + ex.Message);
|
}
|
}
|
|
/// <summary>
|
/// 获取库区域信息
|
/// </summary>
|
/// <returns></returns>
|
public List<SysStorageArea> GetStorageAreaList()
|
{
|
try
|
{
|
var list = Db.Queryable<SysStorageArea>().Where(a => a.IsDel == "0").ToList();
|
return list;
|
}
|
catch (Exception e)
|
{
|
throw new Exception(e.Message);
|
}
|
}
|
|
/// <summary>
|
/// 新增类别信息
|
/// </summary>
|
/// <param name="category">物料类别实体</param>
|
/// <returns></returns>
|
/// <exception cref="Exception"></exception>
|
public string InsertMaterialCategories(SysMaterialCategory category)
|
{
|
try
|
{
|
string msg = "";
|
//获取类别信息
|
var categoryInfo = Db.Queryable<SysMaterialCategory>().First(a => a.IsDel == "0" && a.CategoryNo == category.CategoryNo);
|
//获取区域信息
|
var area = Db.Queryable<SysStorageArea>().Where(a => category.AreaNo.Contains(a.AreaNo) && a.IsDel == "0").ToList();
|
if (categoryInfo != null)
|
{
|
throw new Exception("当前类别信息已被创建，请重新填写信息！");
|
}
|
if (area.Count == 0)
|
{
|
throw new Exception("当前选择区域信息异常，请重新选择或联系管理员！");
|
}
|
|
Db.BeginTran();
|
SysMaterialCategory list = new SysMaterialCategory()
|
{
|
CategoryNo = category.CategoryNo, //类别编码
|
CategoryName = category.CategoryName, //类别名称
|
|
AreaNo = category.AreaNo, //区域编码
|
Demo = category.Demo, //备注
|
|
IsDel = "0", //是否删除
|
CreateUser = category.CreateUser, //创建人
|
CreateTime = Db.GetDate(), //创建时间
|
};
|
|
Db.Insertable(list).ExecuteCommand();
|
|
|
Db.CommitTran();
|
|
msg = "新增类别信息成功！";
|
return msg;
|
|
|
}
|
catch (Exception ex)
|
{
|
Db.RollbackTran();
|
throw new Exception(ex.Message);
|
}
|
}
|
|
/// <summary>
|
/// 编辑类别信息
|
/// </summary>
|
/// <param name="category">物料类别实体</param>
|
/// <returns></returns>
|
/// <exception cref="Exception"></exception>
|
public string ExitMaterialCategories(SysMaterialCategory category)
|
{
|
try
|
{
|
string msg = "";
|
//获取类别信息
|
var categoryInfo = Db.Queryable<SysMaterialCategory>().First(a => a.IsDel == "0" && a.Id == category.Id);
|
//获取类别对应物料信息
|
var matelist = Db.Queryable<SysMaterials>().Where(a=>a.IsDel == "0" && a.CategoryNo == categoryInfo.CategoryNo).ToList();
|
//获取区域信息
|
var area = Db.Queryable<SysStorageArea>().First(a => category.AreaNo.Contains(a.AreaNo) && a.IsDel == "0");
|
|
if (area == null)
|
{
|
throw new Exception("当前选择区域信息异常，请重新选择或联系管理员！");
|
}
|
|
Db.BeginTran();
|
categoryInfo.CategoryNo = category.CategoryNo; //类别编码
|
categoryInfo.CategoryName = category.CategoryName; //类别名称
|
categoryInfo.AreaNo = category.AreaNo; //区域编码
|
categoryInfo.Demo = category.Demo; //备注
|
categoryInfo.UpdateUser = category.CreateUser; //更改人
|
categoryInfo.UpdateTime = Db.GetDate(); //更改时间
|
|
Db.Updateable(categoryInfo).ExecuteCommand();
|
|
foreach (var item in matelist)
|
{
|
item.CategoryNo = categoryInfo.CategoryNo;
|
}
|
Db.Updateable(matelist).ExecuteCommand();
|
|
Db.CommitTran();
|
|
msg = "编辑类别信息成功！";
|
return msg;
|
|
|
}
|
catch (Exception ex)
|
{
|
Db.RollbackTran();
|
throw new Exception(ex.Message);
|
}
|
}
|
|
/// <summary>
|
/// 删除类别信息
|
/// </summary>
|
/// <param name="category">物料类别实体</param>
|
/// <returns></returns>
|
/// <exception cref="Exception"></exception>
|
public string DeleteMaterialCategories(MaterialCategoryDto category)
|
{
|
try
|
{
|
string msg = "";
|
//获取类别信息
|
var categoryInfo = Db.Queryable<SysMaterialCategory>().First(a => a.IsDel == "0" && a.Id == category.Id);
|
//获取区域信息
|
var area = Db.Queryable<SysStorageArea>().First(a => categoryInfo.AreaNo.Contains(a.AreaNo) && a.IsDel == "0");
|
//获取是否存在有物料已绑定当前类别
|
var mate = Db.Queryable<SysMaterials>().Where(a => a.IsDel == "0" && a.CategoryNo == categoryInfo.CategoryNo).ToList();
|
|
//判断是否存在有物料已绑定当前类别
|
if (mate.Count > 0)
|
{
|
throw new Exception("当前类别已有物料进行绑定，无法删除！");
|
}
|
if (categoryInfo == null)
|
{
|
throw new Exception("当前类别信息已被删除，请重新选择！");
|
}
|
if (area == null)
|
{
|
throw new Exception("当前选择区域信息异常，请重新选择或联系管理员！");
|
}
|
|
Db.BeginTran();
|
|
categoryInfo.IsDel = "1";
|
categoryInfo.UpdateUser = int.Parse(category.UpdateUser);
|
categoryInfo.UpdateTime = Db.GetDate();
|
|
Db.Updateable(categoryInfo).ExecuteCommand();
|
|
Db.CommitTran();
|
|
msg = "删除类别信息成功！";
|
return msg;
|
|
|
}
|
catch (Exception ex)
|
{
|
Db.RollbackTran();
|
throw new Exception(ex.Message);
|
}
|
}
|
}
|
}
|
