using iWareCommon.Common.EnumType;
|
using iWareCommon.Common.Service;
|
using iWareCommon.Utils;
|
using iWareDataCore.BASE.Dao;
|
using iWareDataCore.BASE.Entity;
|
using iWareDataCore.BASE.EnumType;
|
using iWareDataCore.ORM;
|
using iWareDataCore.Properties;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
|
namespace iWareDataCore.BASE.Service
|
{
|
public class PlaceService : CommonService<PlaceEntity, BASEPlace, DbModelCore>
|
{
|
private static object Lock = new object();
|
private PlaceService() : base(PlaceDao.GetInstance()) { }
|
|
private static PlaceService Instance = null;
|
|
/// <summary>
|
/// 获取单例的方法
|
/// </summary>
|
/// <returns>角色服务的单例实体</returns>
|
public static PlaceService GetInstance()
|
{
|
|
if (Instance == null)
|
{
|
lock (Lock)
|
{
|
if (Instance == null)
|
{
|
Instance = new PlaceService();
|
}
|
}
|
}
|
return Instance;
|
}
|
|
/// <summary>
|
/// 获取指定字符串开头的库位列表
|
/// </summary>
|
/// <param name="term">指定字符串</param>
|
/// <param name="size">返回的最大条数</param>
|
/// <param name="msg">异常错误消息</param>
|
/// <returns>订单号列表</returns>
|
public List<string> GetCodes(string term, int size, out string msg)
|
{
|
using (var dbModel = new DbModelCore())
|
{
|
try
|
{
|
msg = "";
|
if (string.IsNullOrEmpty(term)) { return new List<string>(); }
|
var places = dbModel.BASEPlaces.Select(x => new { x.id, x.code }).OrderBy(x => x.code).Where(x => x.code.StartsWith(term)).Skip(0).Take(size).ToList();
|
return places.Select(x => x.code).Distinct().ToList();
|
}
|
catch (Exception ex)
|
{
|
msg = ex.Message;
|
LogTextHelper.WriteLog(Resources.LogDir, this.ToString(), "GetCodes", ex.Message);
|
return new List<string>();
|
}
|
}
|
}
|
|
/// <summary>
|
/// 获取空库位和出入库口
|
/// </summary>
|
/// <returns></returns>
|
public List<PlaceViewEntity> GetEmptyAndInOutGate()
|
{
|
using (var dbModel = new DbModelCore())
|
{
|
try
|
{
|
List<PlaceViewEntity> placelst = new List<PlaceViewEntity>();
|
var places = dbModel.BASEPlaceViews.Where(x => x.placetypename == "gate11" || x.placetypename == "gate22" || x.placetypename == EPlaceType.普通库位.ToString() && x.status == 0 && x.placetypename != EPlaceType.不合格缓存位.ToString()).ToList();
|
places.ForEach(x =>{
|
placelst.Add(new PlaceViewEntity(x));
|
});
|
return placelst;
|
}
|
catch (Exception ex)
|
{
|
LogTextHelper.WriteLog(Resources.LogDir, this.ToString(), "GetEmptyAndInOutGate", ex.Message);
|
return new List<PlaceViewEntity>();
|
}
|
}
|
}
|
|
/// <summary>
|
/// 库位状态重置
|
/// </summary>
|
/// <param name="ids"></param>
|
/// <param name="msg"></param>
|
/// <returns></returns>
|
public int PlaceReset(List<int> ids, out string msg)
|
{
|
msg = "";
|
using (var dbModel = new DbModelCore())
|
{
|
try
|
{
|
var placelst = dbModel.BASEPlaces.Where(x => ids.Contains(x.id)).ToList();
|
placelst.ForEach(x =>
|
{
|
x.status=(int)EPlaceStatus.空库位;
|
x.islock = (int)EYesOrNo.否;
|
x.isexecute = (int)EYesOrNo.否;
|
});
|
return dbModel.SaveChanges();
|
}
|
catch (Exception ex)
|
{
|
msg = "更新失败";
|
LogTextHelper.WriteLog(Resources.LogDir, this.ToString(), "PlaceReset", ex.Message);
|
return 0;
|
}
|
}
|
}
|
/// <summary>
|
/// 库位解锁
|
/// </summary>
|
/// <param name="ids"></param>
|
/// <param name="msg"></param>
|
/// <returns></returns>
|
public int PlaceUnLock(List<int> ids, out string msg)
|
{
|
msg = "";
|
using (var dbModel = new DbModelCore())
|
{
|
try
|
{
|
var placelst = dbModel.BASEPlaces.Where(x => ids.Contains(x.id)).ToList();
|
placelst.ForEach(x =>
|
{
|
x.islock = (int)EYesOrNo.否;
|
x.isexecute = (int)EYesOrNo.否;
|
});
|
return dbModel.SaveChanges();
|
}
|
catch (Exception ex)
|
{
|
msg = "更新失败";
|
LogTextHelper.WriteLog(Resources.LogDir, this.ToString(), "PlaceReset", ex.Message);
|
return 0;
|
}
|
}
|
}
|
|
/// <summary>
|
/// 库位锁定
|
/// </summary>
|
/// <param name="ids"></param>
|
/// <param name="msg"></param>
|
/// <returns></returns>
|
public int PlaceLock(List<int> ids, out string msg)
|
{
|
msg = "";
|
using (var dbModel = new DbModelCore())
|
{
|
try
|
{
|
var placelst = dbModel.BASEPlaces.Where(x => ids.Contains(x.id)).ToList();
|
placelst.ForEach(x =>
|
{
|
x.islock = (int)EYesOrNo.是;
|
});
|
return dbModel.SaveChanges();
|
}
|
catch (Exception ex)
|
{
|
msg = "更新失败";
|
LogTextHelper.WriteLog(Resources.LogDir, this.ToString(), "库位锁定", ex.Message);
|
return 0;
|
}
|
}
|
}
|
}
|
}
|
