using iWareCommon.Common.Service;
|
using iWareDataCore.BASE.Dao;
|
using iWareDataCore.BASE.Entity;
|
using iWareDataCore.ORM;
|
using System;
|
using System.Linq;
|
|
namespace iWareDataCore.BASE.Service
|
{
|
public class MaterialClassService : CommonService<MaterialClassEntity, BASEMaterialClass, DbModelCore>
|
{
|
|
private static object Lock = new object();
|
|
private MaterialClassService() : base(MaterialClassDao.GetInstance()) { }
|
|
private static MaterialClassService Instance = null;
|
|
/// <summary>
|
/// 获取单例的方法
|
/// </summary>
|
/// <returns>角色服务的单例实体</returns>
|
public static MaterialClassService GetInstance()
|
{
|
|
if (Instance == null)
|
{
|
lock (Lock)
|
{
|
if (Instance == null)
|
{
|
Instance = new MaterialClassService();
|
}
|
}
|
}
|
return Instance;
|
}
|
|
public int DeleteMaterialClass(int id, out string msg)
|
{
|
msg = "";
|
using (var dbModel = new DbModelCore())
|
{
|
try
|
{
|
var materialClass = dbModel.BASEMaterialClass.FirstOrDefault(x => x.id == id);
|
if (materialClass != null)
|
{
|
var materialCodeLs = dbModel.BASEMaterials.Where(x => x.materialno == materialClass.materialno).Select(x =>x.code).Distinct().ToList();
|
if (materialCodeLs != null && materialCodeLs.Count > 0)
|
{
|
msg = "物料信息存在，不能删除";
|
return 0;
|
}
|
else
|
{
|
dbModel.BASEMaterialClass.Remove(materialClass);
|
dbModel.SaveChanges();
|
return 1;
|
}
|
}
|
else
|
{
|
msg = "规格不存在";
|
return 0;
|
}
|
}
|
catch (Exception ex) {
|
msg = ex.ToString();
|
return 0;
|
}
|
}
|
}
|
|
|
}
|
}
|
