using IWareDataAccess.EF;
|
using IWareDataAccess.Entity.Car;
|
using IWareDataAccess.Helper;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
|
namespace IWareDataAccess.Car.CARTASK
|
{
|
public static class CarTaskSqlFunc
|
{
|
|
/// <summary>
|
/// 搜索表
|
/// </summary>
|
/// <param name="keyValue"></param>
|
/// <param name="page"></param>
|
/// <returns></returns>
|
public static List<CAR_CARTASK> Search(CarTaskWebEntity webEntity, int page, int onePageNum, out string msg)
|
{
|
msg = "";
|
using (Model edm = new Model())
|
{
|
var f = PredicateBuilder.True<CAR_CARTASK>();
|
//便利所有属性
|
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 (i.PropertyType == typeof(DateTime?))
|
{
|
if (v != null)
|
{
|
DateTime value = DateTime.Parse(v.ToString());
|
if (i.Name == "updateTimeStart")
|
{
|
f = f.And(x => x.UPDATETIME > value);
|
}
|
if (i.Name == "updateTimeEnd")
|
{
|
f = f.And(x => x.UPDATETIME < value);
|
}
|
}
|
}
|
else
|
{
|
if (v != null)
|
{
|
f = f.And(x => Object.Equals(Helper.Helper.GetFieldValueByName(x, i.Name), v));
|
}
|
}
|
}
|
List<CAR_CARTASK> list = edm.CAR_CARTASK.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_CAR_CARTASK> SearchView(CarTaskWebEntity webEntity, int page, int onePageNum, string typeInput, out string msg)
|
{
|
msg = "";
|
using (Model edm = new Model())
|
{
|
var f = PredicateBuilder.True<View_CAR_CARTASK>();
|
//便利所有属性
|
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)
|
{
|
if (i.Name == "taskStatusNot")
|
{
|
string name = i.Name.Replace("Not", "");
|
value = v.ToString();
|
f = f.And(x => Helper.Helper.GetFieldValueByName(x, name) != null ? Helper.Helper.GetFieldValueByName(x, name).ToString() != value : false);
|
}
|
else
|
{
|
value = v.ToString();
|
f = f.And(x => Helper.Helper.GetFieldValueByName(x, i.Name) != null ? Helper.Helper.GetFieldValueByName(x, i.Name).ToString().Contains(value) : false);
|
}
|
}
|
|
if (i.Name == "taskStatus")
|
{
|
if (typeInput == "1")
|
{
|
f = f.And(x => x.taskStatus == "新建");
|
|
}
|
}
|
if (i.Name == "fromDestination")
|
{
|
if (typeInput == "1")
|
{
|
f = f.And(x => x.fromDestination == "一号出口");
|
}
|
}
|
}
|
else if (i.PropertyType == typeof(DateTime?))
|
{
|
if (v != null)
|
{
|
DateTime value = DateTime.Parse(v.ToString());
|
if (i.Name == "updateTimeStart")
|
{
|
f = f.And(x => x.updateTime > value);
|
}
|
if (i.Name == "updateTimeEnd")
|
{
|
f = f.And(x => x.updateTime < value);
|
}
|
}
|
}
|
else
|
{
|
if (v != null)
|
{
|
f = f.And(x => Object.Equals(Helper.Helper.GetFieldValueByName(x, i.Name), v));
|
}
|
}
|
}
|
|
List<View_CAR_CARTASK> list = edm.View_CAR_CARTASK.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 int SearchViewNum(CarTaskWebEntity webEntity)
|
{
|
using (Model edm = new Model())
|
{
|
var f = PredicateBuilder.True<View_CAR_CARTASK>();
|
//便利所有属性
|
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)
|
{
|
if (i.Name == "taskStatusNot")
|
{
|
string name = i.Name.Replace("Not", "");
|
value = v.ToString();
|
f = f.And(x => Helper.Helper.GetFieldValueByName(x, name) != null ? Helper.Helper.GetFieldValueByName(x, name).ToString() != value : false);
|
}
|
else
|
{
|
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 (i.PropertyType == typeof(DateTime?))
|
{
|
if (v != null)
|
{
|
DateTime value = DateTime.Parse(v.ToString());
|
if (i.Name == "updateTimeStart")
|
{
|
f = f.And(x => x.updateTime > value);
|
}
|
if (i.Name == "updateTimeEnd")
|
{
|
f = f.And(x => x.updateTime < value);
|
}
|
}
|
}
|
else
|
{
|
if (v != null)
|
{
|
f = f.And(x => Object.Equals(Helper.Helper.GetFieldValueByName(x, i.Name), v));
|
}
|
}
|
}
|
|
int num = edm.View_CAR_CARTASK.Where(f.Compile()).Count();
|
|
return num;
|
}
|
}
|
|
|
/// <summary>
|
/// 添加叉车任务
|
/// </summary>
|
/// <param name="role"></param>
|
/// <returns></returns>
|
public static bool AddOrUpdate(CarTaskWebEntity webEntity, out string msg)
|
{
|
msg = "";
|
using (Model edm = new Model())
|
{
|
|
CAR_CARTASK carTask = new CAR_CARTASK();
|
carTask = edm.CAR_CARTASK.FirstOrDefault(x => x.CARTASKNAME == webEntity.carTaskName);
|
if (carTask == null)
|
{
|
carTask = new CAR_CARTASK();
|
}
|
carTask.CARTASKNAME = webEntity.carTaskName ?? carTask.CARTASKNAME;
|
BASE_CONTAINER container = edm.BASE_CONTAINER.FirstOrDefault(x => x.CONTAINERNAME == webEntity.containerName);
|
if (container == null)
|
{
|
msg = "无此托盘";
|
return false;
|
}
|
carTask.BASE_CONTAINER = container;
|
|
BASE_PRODUCTIONLINE lineFrom = edm.BASE_PRODUCTIONLINE.FirstOrDefault(x => x.PRODUCTIONLINENAME == webEntity.fromDestination);
|
if (lineFrom != null)
|
{
|
carTask.FROMDESTINATION = webEntity.fromDestination;
|
|
}
|
else
|
{
|
msg = "无此起始工位";
|
return false;
|
}
|
BASE_PRODUCTIONLINE lineTo = edm.BASE_PRODUCTIONLINE.FirstOrDefault(x => x.PRODUCTIONLINENAME == webEntity.toDestination);
|
if (lineTo != null)
|
{
|
carTask.TODESTINATION = webEntity.toDestination;
|
|
}
|
else
|
{
|
//msg = "无此目标工位";
|
//return false;
|
carTask.TODESTINATION = webEntity.toDestination;
|
}
|
carTask.TASKSTATUS = webEntity.taskStatus ?? carTask.TASKSTATUS;
|
carTask.ENABLE = webEntity.enable ?? carTask.ENABLE;
|
SYS_USER user = edm.SYS_USER.FirstOrDefault(x => x.USERNAME == webEntity.userName);
|
if (user != null)
|
{
|
carTask.CREATORID = user.ID;
|
carTask.CREATEUSERID = user.ID;
|
}
|
carTask.UPDATETIME = DateTime.Now;
|
edm.CAR_CARTASK.AddOrUpdateExtension(carTask);
|
if (edm.SaveChanges() > 0)
|
{
|
return true;
|
}
|
else
|
{
|
msg = "保存失败";
|
return false;
|
}
|
}
|
}
|
|
/// <summary>
|
/// 修改叉车任务状态
|
/// </summary>
|
/// <returns></returns>
|
public static bool CarGetTask(CarTaskWebEntity carTaskEntity, out string msg)
|
{
|
msg = "";
|
using (Model edm = new Model())
|
{
|
CAR_CARTASK carTask = edm.CAR_CARTASK.FirstOrDefault(x => x.CARTASKNAME == carTaskEntity.carTaskName);
|
if (carTask == null)
|
{
|
msg = "无此任务";
|
return false;
|
}
|
SYS_USER user = edm.SYS_USER.FirstOrDefault(x => x.USERNAME == carTaskEntity.getUserName);
|
if (user != null)
|
{
|
carTask.USERID = user.ID;
|
}
|
else
|
{
|
msg = "获取领用人失败！";
|
return false;
|
}
|
carTask.TASKSTATUS = carTaskEntity.taskStatus;
|
carTask.CREATETIME = DateTime.Now;
|
//CAR_CAR car = edm.CAR_CAR.FirstOrDefault(x => x.CARNAME == carTaskEntity.carName);
|
//if (car == null)
|
//{
|
// msg = "无此叉车";
|
// return false;
|
//}
|
//car.CARTASKID = carTask.ID;
|
|
if (edm.SaveChanges() > 0)
|
{
|
return true;
|
}
|
else
|
{
|
msg = "保存失败";
|
return false;
|
}
|
}
|
|
}
|
|
/// <summary>
|
/// 删除
|
/// </summary>
|
/// <param name="webDevice"></param>
|
/// <returns></returns>
|
public static bool Delete(CarTaskWebEntity webEntity, out string msg)
|
{
|
msg = "";
|
using (Model edm = new Model())
|
{
|
|
CAR_CARTASK carTask = edm.CAR_CARTASK.FirstOrDefault(x => x.CARTASKNAME == webEntity.carTaskName);
|
if (carTask == null)
|
{
|
//无此角色
|
msg = "无此叉车任务";
|
return false;
|
}
|
else
|
{
|
//edm.BASE_CONTAINER_VS_ITEM.Remove(cvi);
|
carTask.ENABLE = 0;
|
if (edm.SaveChanges() > 0)
|
{
|
return true;
|
}
|
else
|
{
|
msg = "保存失败";
|
return false;
|
}
|
}
|
}
|
}
|
|
/// <summary>
|
/// 获取组盘号
|
/// </summary>
|
/// <returns></returns>
|
public static string GetCode()
|
{
|
using (Model edm = new Model())
|
{
|
|
string month = DateTime.Now.Month.ToString("00");
|
string day = DateTime.Now.Day.ToString("00");
|
string hour = DateTime.Now.Hour.ToString("00");
|
string minute = DateTime.Now.Minute.ToString("00");
|
string second = DateTime.Now.Second.ToString("00");
|
string millSecond = DateTime.Now.Millisecond.ToString("0000");
|
string time = DateTime.Now.Year.ToString() + month + day + hour + minute + second + millSecond;
|
|
return "CT" + time;
|
}
|
}
|
|
public static List<string> GetCarUser(out string msg)
|
{
|
msg = "";
|
using (Model edm = new Model())
|
{
|
var carlst = edm.CAR_CAR.Where(x => x.ENABLE == 1).ToList();
|
var uidlst = carlst.Select(x => x.USERID).Distinct().ToList();
|
var userlst = edm.SYS_USER.Where(x => x.ENABLE == 1).ToList();
|
List<string> namelst = new List<string>();
|
uidlst.ForEach(x =>
|
{
|
var uer = userlst.FirstOrDefault(y => y.ID == x);
|
if (uer != null)
|
{
|
namelst.Add(uer.USERNAME);
|
}
|
|
});
|
return namelst;
|
}
|
}
|
}
|
}
|
