using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using IWareDataAccess.EF;
|
using IWareDataAccess.Entity.Base;
|
using IWareDataAccess.Helper;
|
|
namespace IWareDataAccess.Base.PALLET
|
{
|
public class PalletSqlFunc
|
{
|
/// <summary>
|
/// 搜索表
|
/// </summary>
|
/// <param name="keyValue"></param>
|
/// <param name="page"></param>
|
/// <returns></returns>
|
public static List<PalletWebEntity> Search(PalletWebEntity webEntity, int page, int onePageNum, out string msg)
|
{
|
msg = "";
|
using (Model edm = new Model())
|
{
|
var f = PredicateBuilder.True<BASE_PALLET>();
|
//便利所有属性
|
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_PALLET> list = edm.BASE_PALLET.Where(f.Compile()).Skip((page - 1) * onePageNum).Take(onePageNum).ToList();
|
List<PalletWebEntity> pwlst=new List<PalletWebEntity>();
|
list.ForEach(x =>
|
{
|
pwlst.Add(new PalletWebEntity() {
|
id=x.ID,
|
PalletType=x.PALLETTYPE,
|
PalletCode=x.PALLETCODE,
|
HeightMax=x.HEIGHTMAX,
|
HeightMin=x.HEIGHTMIN,
|
LengthMax=x.LENGTHMAX,
|
LengthMin=x.LENGTHMIN,
|
WidthMax=x.WIDTHMAX,
|
WidthMin=x.WIDTHMIN
|
});
|
});
|
return pwlst;
|
}
|
}
|
|
|
|
/// <summary>
|
/// 搜索视图数量
|
/// </summary>
|
/// <param name="keyValue"></param>
|
/// <param name="page"></param>
|
/// <returns></returns>
|
public static int SearchViewNum(PalletWebEntity webEntity)
|
{
|
using (Model edm = new Model())
|
{
|
var f = PredicateBuilder.True<BASE_PALLET>();
|
|
//便利所有属性
|
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.BASE_PALLET.Where(f.Compile()).Count();
|
|
return num;
|
}
|
}
|
|
|
/// <summary>
|
/// 添加修改托盘
|
/// </summary>
|
/// <param name="role"></param>
|
/// <returns></returns>
|
public static bool AddOrUpdate(PalletWebEntity webEntity, out string msg)
|
{
|
msg = "";
|
using (Model edm = new Model())
|
{
|
//查询是否已存在此托盘
|
BASE_PALLET pallet = edm.BASE_PALLET.FirstOrDefault(x => x.PALLETCODE==webEntity.PalletCode);
|
if (pallet == null)
|
{
|
//无此库位，属于新建
|
pallet = new BASE_PALLET();
|
}
|
else
|
{
|
msg = "该器具编号规格已存在！";
|
}
|
pallet.PALLETCODE = webEntity.PalletCode ?? pallet.PALLETCODE;
|
pallet.PALLETTYPE = webEntity.PalletType ?? pallet.PALLETTYPE;
|
|
edm.BASE_PALLET.AddOrUpdateExtension(pallet);
|
if (edm.SaveChanges() > 0)
|
{
|
return true;
|
}
|
else
|
{
|
return false;
|
}
|
}
|
}
|
|
/// <summary>
|
/// 删除托盘
|
/// </summary>
|
/// <param name="webDevice"></param>
|
/// <returns></returns>
|
public static bool Delete(PalletWebEntity webDevice, out string msg)
|
{
|
msg = "";
|
using (Model edm = new Model())
|
{
|
//查询是否已存在此权限
|
BASE_PALLET pallet = edm.BASE_PALLET.FirstOrDefault(x => x.PALLETCODE == webDevice.PalletCode);
|
if (pallet == null)
|
{
|
//无此角色
|
msg = "无此规格";
|
return false;
|
}
|
else
|
{
|
edm.BASE_PALLET.Remove(pallet);
|
|
return edm.SaveChanges()>0?true:false;
|
}
|
}
|
}
|
|
}
|
}
|
