using IWareDataAccess.EF;
|
using IWareDataAccess.Entity.Base;
|
using IWareDataAccess.Entity.Summary;
|
using IWareDataAccess.Helper;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
|
namespace IWareDataAccess.Base.CONTAINER
|
{
|
public static class ContainerSqlFunc
|
{
|
/// <summary>
|
/// 搜索表
|
/// </summary>
|
/// <param name="keyValue"></param>
|
/// <param name="page"></param>
|
/// <returns></returns>
|
public static List<BASE_CONTAINER> Search(ContainerWebEntity webEntity, int page, int onePageNum, out string msg)
|
{
|
msg = "";
|
using (Model edm = new Model())
|
{
|
var f = PredicateBuilder.True<BASE_CONTAINER>();
|
//便利所有属性
|
Type type = webEntity.GetType();
|
foreach (var i in type.GetProperties())
|
{
|
object v = Helper.Helper.GetFieldValueByName(webEntity, i.Name);
|
if (i.PropertyType == typeof(String))
|
{
|
string value;
|
if (v != null)
|
{
|
value = v.ToString();
|
f = f.And(x => Helper.Helper.GetFieldValueByName(x, i.Name) != null ? Helper.Helper.GetFieldValueByName(x, i.Name).ToString().Contains(value) : false);
|
}
|
}
|
else
|
{
|
if (v != null)
|
{
|
f = f.And(x => Object.Equals(Helper.Helper.GetFieldValueByName(x, i.Name), v));
|
}
|
}
|
}
|
List<BASE_CONTAINER> list = edm.BASE_CONTAINER.Where(f.Compile()).Skip((page - 1) * onePageNum).Take(onePageNum).ToList();
|
|
return list;
|
}
|
}
|
|
/// <summary>
|
/// 搜索视图
|
/// </summary>
|
/// <param name="keyValue"></param>
|
/// <param name="page"></param>
|
/// <returns></returns>
|
public static List<View_BASE_CONTAINER> SearchView(ContainerWebEntity webEntity, int page, int onePageNum, out string msg)
|
{
|
msg = "";
|
using (Model edm = new Model())
|
{
|
var f = PredicateBuilder.True<View_BASE_CONTAINER>();
|
//便利所有属性
|
Type type = webEntity.GetType();
|
foreach (var i in type.GetProperties())
|
{
|
object v = Helper.Helper.GetFieldValueByName(webEntity, i.Name);
|
if (i.PropertyType == typeof(String))
|
{
|
string value;
|
if (v != null)
|
{
|
value = v.ToString();
|
f = f.And(x => Helper.Helper.GetFieldValueByName(x, i.Name) != null ? Helper.Helper.GetFieldValueByName(x, i.Name).ToString().Contains(value) : false);
|
}
|
}
|
else
|
{
|
if (v != null)
|
{
|
f = f.And(x => Object.Equals(Helper.Helper.GetFieldValueByName(x, i.Name), v));
|
}
|
}
|
}
|
|
List<View_BASE_CONTAINER> list = edm.View_BASE_CONTAINER.OrderByDescending(x=>x.id).Where(f.Compile()).Skip((page - 1) * onePageNum).Take(onePageNum).ToList();
|
|
return list;
|
}
|
}
|
|
/// <summary>
|
/// 搜索视图
|
/// </summary>
|
/// <param name="keyValue"></param>
|
/// <param name="page"></param>
|
/// <returns></returns>
|
public static List<View_BASE_CONTAINER> SearchAllView(ContainerWebEntity webEntity, out string msg)
|
{
|
msg = "";
|
using (Model edm = new Model())
|
{
|
var f = PredicateBuilder.True<View_BASE_CONTAINER>();
|
//便利所有属性
|
Type type = webEntity.GetType();
|
foreach (var i in type.GetProperties())
|
{
|
object v = Helper.Helper.GetFieldValueByName(webEntity, i.Name);
|
if (i.PropertyType == typeof(String))
|
{
|
string value;
|
if (v != null)
|
{
|
value = v.ToString();
|
f = f.And(x => Helper.Helper.GetFieldValueByName(x, i.Name) != null ? Helper.Helper.GetFieldValueByName(x, i.Name).ToString().Contains(value) : false);
|
}
|
}
|
else
|
{
|
if (v != null)
|
{
|
f = f.And(x => Object.Equals(Helper.Helper.GetFieldValueByName(x, i.Name), v));
|
}
|
}
|
}
|
|
List<View_BASE_CONTAINER> list = edm.View_BASE_CONTAINER.OrderByDescending(x => x.id).Where(f.Compile()).ToList();
|
|
return list;
|
}
|
}
|
/// <summary>
|
/// 搜索视图数量
|
/// </summary>
|
/// <param name="keyValue"></param>
|
/// <param name="page"></param>
|
/// <returns></returns>
|
public static int SearchViewNum(ContainerWebEntity webEntity)
|
{
|
using (Model edm = new Model())
|
{
|
var f = PredicateBuilder.True<View_BASE_CONTAINER>();
|
|
//便利所有属性
|
Type type = webEntity.GetType();
|
foreach (var i in type.GetProperties())
|
{
|
object v = Helper.Helper.GetFieldValueByName(webEntity, i.Name);
|
if (i.PropertyType == typeof(String))
|
{
|
string value;
|
if (v != null)
|
{
|
value = v.ToString();
|
f = f.And(x => Helper.Helper.GetFieldValueByName(x, i.Name) != null ? Helper.Helper.GetFieldValueByName(x, i.Name).ToString().Contains(value) : false);
|
}
|
}
|
else
|
{
|
if (v != null)
|
{
|
f = f.And(x => Object.Equals(Helper.Helper.GetFieldValueByName(x, i.Name), v));
|
}
|
}
|
}
|
|
int num = edm.View_BASE_CONTAINER.Where(f.Compile()).Count();
|
|
return num;
|
}
|
}
|
|
|
/// <summary>
|
/// 添加修改托盘
|
/// </summary>
|
/// <param name="role"></param>
|
/// <returns></returns>
|
public static bool AddOrUpdate(ContainerWebEntity webEntity,out string msg)
|
{
|
msg = "";
|
using (Model edm = new Model())
|
{
|
//查询是否已存在此托盘
|
BASE_CONTAINER container = edm.BASE_CONTAINER.FirstOrDefault(x => x.CONTAINERNAME == webEntity.containerName);
|
if (container == null)
|
{
|
//无此库位，属于新建
|
container = new BASE_CONTAINER();
|
}
|
else
|
{
|
msg = "该器具编号已存在！";
|
}
|
container.CONTAINERNAME = webEntity.containerName ?? container.CONTAINERNAME;
|
BASE_PALLET pallet = edm.BASE_PALLET.FirstOrDefault(x => x.PALLETCODE == webEntity.palletCode);
|
if (pallet != null)
|
{
|
container.PALLETTYPEID = pallet.ID;
|
//判断尺寸是否合格
|
if (pallet.LENGTHMAX != null && webEntity.length != null && pallet.LENGTHMAX < webEntity.length)
|
{
|
msg = "超长";
|
return false;
|
}
|
if (pallet.LENGTHMIN != null && webEntity.length != null && pallet.LENGTHMIN > webEntity.length)
|
{
|
msg = "超短";
|
return false;
|
}
|
if (pallet.WIDTHMAX != null && webEntity.width != null && pallet.WIDTHMAX < webEntity.width)
|
{
|
msg = "超宽";
|
return false;
|
}
|
if (pallet.WIDTHMIN != null && webEntity.width != null && pallet.WIDTHMIN > webEntity.width)
|
{
|
msg = "超窄";
|
return false;
|
}
|
if (pallet.HEIGHTMAX != null && webEntity.height != null && pallet.HEIGHTMAX < webEntity.height)
|
{
|
msg = "超高";
|
return false;
|
}
|
if (pallet.HEIGHTMIN != null && webEntity.height != null && pallet.HEIGHTMIN > webEntity.height)
|
{
|
msg = "超低";
|
return false;
|
}
|
}
|
container.CONTAINERTYPE= webEntity.containerType ??container.CONTAINERTYPE;
|
container.STATUS = webEntity.status ?? container.STATUS;
|
container.WEIGHT = webEntity.weight ?? container.WEIGHT;
|
container.LENGTH = webEntity.length ?? container.LENGTH;
|
container.HEIGHT = webEntity.height ?? container.HEIGHT;
|
container.WIDTH = webEntity.width ?? container.WIDTH;
|
container.WEIGHTDIFFERENCE = webEntity.weightDifference ?? container.WEIGHTDIFFERENCE;
|
container.ENABLE = webEntity.enable ?? container.ENABLE;
|
container.CONTAINERDES = webEntity.containerDes ?? container.CONTAINERTYPE;
|
container.ISLOCK = webEntity.isLock ?? container.ISLOCK;
|
|
edm.BASE_CONTAINER.AddOrUpdateExtension(container);
|
if (edm.SaveChanges() > 0)
|
{
|
return true;
|
}
|
else
|
{
|
return false;
|
}
|
}
|
}
|
|
/// <summary>
|
/// 删除托盘
|
/// </summary>
|
/// <param name="webDevice"></param>
|
/// <returns></returns>
|
public static bool Delete(ContainerWebEntity webDevice,out string msg)
|
{
|
msg = "";
|
using (Model edm = new Model())
|
{
|
//查询是否已存在此权限
|
BASE_CONTAINER container = edm.BASE_CONTAINER.FirstOrDefault(x => x.CONTAINERNAME == webDevice.containerName);
|
if (container == null)
|
{
|
//无此角色
|
msg = "无此托盘";
|
return false;
|
}
|
else
|
{
|
return DeleteContainerRelevance(container,out msg);
|
}
|
}
|
}
|
|
/// <summary>
|
/// 关联删除
|
/// </summary>
|
/// <param name="user"></param>
|
/// <returns></returns>
|
public static bool DeleteContainerRelevance(BASE_CONTAINER container,out string msg)
|
{
|
msg = "";
|
using (Model edm = new Model())
|
{
|
//因已释放连接，故重新指向数据库对象进行索引
|
BASE_CONTAINER containerDelete = edm.BASE_CONTAINER.FirstOrDefault(x => x.CONTAINERNAME == container.CONTAINERNAME);
|
////删除角色关系
|
//edm.SYS_USER_VS_ROLE.RemoveRange(roleDelete.SYS_USER_VS_ROLE);
|
//edm.SYS_ROLE_VS_PERMISSION.RemoveRange(roleDelete.SYS_ROLE_VS_PERMISSION);
|
//删除角色
|
//edm.SYS_ROLE.Remove(roleDelete);
|
containerDelete.ENABLE = 0;
|
if (edm.SaveChanges() > 0)
|
{
|
return true;
|
}
|
else
|
{
|
msg = "保存失败";
|
return false;
|
}
|
}
|
}
|
|
public static List<HomeNumDataEntity> GetContainerType(out string msg)
|
{
|
msg = "";
|
try
|
{
|
using (Model edm = new Model())
|
{
|
List<HomeNumDataEntity> hnlst = new List<HomeNumDataEntity>();
|
var containerlst = edm.BASE_CONTAINER.Where(x => x.ENABLE == 1).ToList();
|
List<string> lst = containerlst.Select(x => x.CONTAINERTYPE).Distinct().ToList();
|
int i=1;
|
lst.ForEach(x =>
|
{
|
hnlst.Add(new HomeNumDataEntity { titel = x, no = i });
|
i++;
|
});
|
return hnlst;
|
}
|
}
|
catch (Exception)
|
{
|
|
return null;
|
}
|
}
|
}
|
}
|
