using Model.ModelDto;
|
using Model.ModelDto.SysDto;
|
using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
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 MaterialCategory : DbHelper<SysMaterialCategory>, IMaterialCategory
|
{
|
|
private static readonly SqlSugarScope Db = DataContext.Db;
|
public MaterialCategory() : 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();
|
|
return list;
|
}
|
catch (Exception ex)
|
{
|
throw new Exception(ex.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>().First(a => a.AreaNo == category.AreaNo && a.IsDel == "0");
|
|
if (categoryInfo != null)
|
{
|
msg = "当前类别信息已被创建，请重新填写信息！";
|
return msg;
|
}
|
if (area == null)
|
{
|
msg = "当前选择区域信息异常，请重新选择或联系管理员！";
|
return msg;
|
}
|
|
Db.BeginTran();
|
SysMaterialCategory list = new SysMaterialCategory()
|
{
|
CategoryNo = category.CategoryNo, //类别号
|
CategoryName = category.CategoryName, //类别名称
|
|
AreaNo = category.AreaNo, //区域编码
|
WareHouseNo = area.WareHouseNo, //所属仓库
|
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.CategoryNo == category.CategoryNo);
|
//获取区域信息
|
var area = Db.Queryable<SysStorageArea>().First(a => a.AreaNo == category.AreaNo && a.IsDel == "0");
|
|
if (categoryInfo != null)
|
{
|
msg = "当前类别信息已被创建，请重新填写信息！";
|
return msg;
|
}
|
|
if (area == null)
|
{
|
msg = "当前选择区域信息异常，请重新选择或联系管理员！";
|
return msg;
|
}
|
|
Db.BeginTran();
|
categoryInfo = new SysMaterialCategory()
|
{
|
CategoryNo = category.CategoryNo, //类别号
|
CategoryName = category.CategoryName, //类别名称
|
|
AreaNo = category.AreaNo, //区域编码
|
WareHouseNo = area.WareHouseNo, //所属仓库
|
Demo = category.Demo, //备注
|
|
IsDel = "0", //是否删除
|
UpdateUser = category.CreateUser, //更改人
|
UpdateTime = Db.GetDate(), //更改时间
|
};
|
|
Db.Updateable(categoryInfo).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(SysMaterialCategory category)
|
{
|
try
|
{
|
string msg = "";
|
//获取类别信息
|
var categoryInfo = Db.Queryable<SysMaterialCategory>().First(a => a.IsDel == "0" && a.CategoryNo == category.CategoryNo);
|
//获取区域信息
|
var area = Db.Queryable<SysStorageArea>().First(a => a.AreaNo == category.AreaNo && a.IsDel == "0");
|
|
|
if (categoryInfo != null)
|
{
|
msg = "当前类别信息已被删除，请重新选择！";
|
return msg;
|
}
|
if (area == null)
|
{
|
msg = "当前选择区域信息异常，请重新选择或联系管理员！";
|
return msg;
|
}
|
|
Db.BeginTran();
|
|
categoryInfo.IsDel = "1";
|
|
Db.Updateable(categoryInfo).ExecuteCommand();
|
|
Db.CommitTran();
|
|
msg = "删除类别信息成功！";
|
return msg;
|
|
|
}
|
catch (Exception ex)
|
{
|
Db.RollbackTran();
|
throw new Exception(ex.Message);
|
}
|
}
|
}
|
}
|
