using iWareCommon.Common.Service;
|
using iWareCommon.Utils;
|
using iWareDataCore.BASE.Dao;
|
using iWareDataCore.BASE.Entity;
|
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 InOutListService : CommonService<InOutListEntity, BASEInOutList, DbModelCore>
|
{
|
private static object Lock = new object();
|
|
private InOutListService() : base(InOutListDao.GetInstance()) { }
|
|
private static InOutListService Instance = null;
|
|
/// <summary>
|
/// 获取单例的方法
|
/// </summary>
|
/// <returns>用户服务的单例实体</returns>
|
public static InOutListService GetInstance()
|
{
|
|
if (Instance == null)
|
{
|
lock (Lock)
|
{
|
if (Instance == null)
|
{
|
Instance = new InOutListService();
|
}
|
}
|
}
|
return Instance;
|
}
|
|
/// <summary>
|
/// 转换子表ORM
|
/// </summary>
|
/// <param name="iol"></param>
|
/// <param name="msg"></param>
|
/// <returns></returns>
|
public int CreateListAndDetial(InOutListEntity iol, out string msg)
|
{
|
try
|
{
|
using (var DbModel = new DbModelCore())
|
{
|
List<BASEInOutListDetail> inldlst = new List<BASEInOutListDetail>();
|
msg = "";
|
iol.InOutListDetail.ForEach(x => { inldlst.Add(x.ToOrm()); });
|
BASEInOutList biol = new BASEInOutList();
|
biol = iol.ToOrm();
|
biol.BASEInOutListDetails = inldlst;
|
DbModel.BASEInOutLists.Add(biol);
|
return DbModel.SaveChanges();
|
}
|
}
|
catch (Exception ex)
|
{
|
msg = ex.Message;
|
|
return -1;
|
|
}
|
}
|
public bool AddOutInDetail(string inoutNo, string maritalNo, out string msg)
|
{
|
try
|
{
|
msg = "";
|
using (var dbModel = new DbModelCore())
|
{
|
var cutInOut = dbModel.BASEInOutLists.FirstOrDefault(x=>x.listno== inoutNo);
|
if (cutInOut == null)
|
{
|
msg = "出入库单号不存在";
|
return false;
|
}
|
var cutMarital = dbModel.BASEMaterials.FirstOrDefault(x => x.code == maritalNo);
|
if (cutMarital == null)
|
{
|
msg = "物料不存在";
|
return false;
|
}
|
var findInOutDetail = dbModel.BASEInOutListDetails.FirstOrDefault(x => x.inoutlistid == cutInOut.id && x.materialid== cutMarital.id);
|
if (findInOutDetail != null)
|
{
|
msg = "此单号和物料已存在";
|
return false;
|
}
|
BASEInOutListDetail newDetail = new BASEInOutListDetail();
|
newDetail.inoutlistid = cutInOut.id;
|
newDetail.placeid = 0;
|
newDetail.materialid = cutMarital.id;
|
newDetail.isfinish = 0;
|
dbModel.BASEInOutListDetails.Add(newDetail);
|
dbModel.SaveChanges();
|
msg = "新增成功";
|
return true;
|
}
|
}
|
catch (Exception ex)
|
{
|
msg = ex.Message;
|
return false;
|
}
|
}
|
|
public override int Delete(int id, out string msg)
|
{
|
msg = "";
|
using (var dbModel = new DbModelCore())
|
{
|
try
|
{
|
var inoutlist = dbModel.BASEInOutLists.Where(x => id == x.id).ToList();
|
|
var inoutdetail = dbModel.BASEInOutListDetails.Where(x => id == x.inoutlistid).ToList();
|
inoutdetail.ForEach(x => dbModel.BASEInOutListDetails.Remove(x));
|
inoutlist.ForEach(x => dbModel.BASEInOutLists.Remove(x));
|
|
dbModel.SaveChanges();
|
return inoutdetail.Count;
|
}
|
catch (Exception ex)
|
{
|
msg = ex.Message;
|
LogTextHelper.WriteLog(Resources.LogDir, this.ToString(), "Delete", ex.Message);
|
return 0;
|
}
|
}
|
}
|
|
public int DeleteInOut(int id, out string msg)
|
{
|
msg = "";
|
using (var dbModel = new DbModelCore())
|
{
|
try
|
{
|
var inoutlist = dbModel.BASEInOutLists.Where(x => id == x.id).ToList();
|
|
var inoutdetail = dbModel.BASEInOutListDetails.Where(x => x.inoutlistid == id).ToList();
|
inoutdetail.ForEach(x => dbModel.BASEInOutListDetails.Remove(x));
|
dbModel.BASEInOutLists.RemoveRange(inoutlist);
|
|
dbModel.SaveChanges();
|
return inoutlist.Count;
|
}
|
catch (Exception ex)
|
{
|
msg = ex.Message;
|
LogTextHelper.WriteLog(Resources.LogDir, this.ToString(), "DeleteInOut", ex.Message);
|
return 0;
|
}
|
}
|
}
|
|
//public override int Delete(List<int> id, out string msg)
|
//{
|
// msg = "";
|
// using (var dbModel = new DbModelCore())
|
// {
|
// try
|
// {
|
// var inoutlist = dbModel.BASEInOutLists.Where(x => id == x.id).ToList();
|
|
// var inoutdetail = dbModel.BASEInOutListDetails.Where(x => id == x.inoutlistid).ToList();
|
// inoutdetail.ForEach(x => dbModel.BASEInOutListDetails.Remove(x));
|
// inoutlist.ForEach(x => dbModel.BASEInOutLists.Remove(x));
|
|
// dbModel.SaveChanges();
|
// return inoutdetail.Count;
|
// }
|
// catch (Exception ex)
|
// {
|
// msg = ex.Message;
|
// LogTextHelper.WriteLog(Resources.LogDir, this.ToString(), "Delete", ex.Message);
|
// return 0;
|
// }
|
// }
|
//}
|
|
}
|
}
|
