using Masuit.Tools;
|
using MES.Service.DB;
|
using MES.Service.Dto.webApi.SRM;
|
using MES.Service.Modes.SRM;
|
using SqlSugar;
|
|
public class MesDeliveryNoteBarcodeManager : Repository<MesDeliveryNoteBarcode>
|
{
|
|
public dynamic Save(PrintBarcode barcode)
|
{
|
var mesDeliveryBarcode= GetMesDeliveryBarcode(barcode);
|
|
return UseTransaction(db =>
|
{
|
return SaveOrUpdateData(db, mesDeliveryBarcode) ? 1 : 0;
|
}) > 0;
|
}
|
|
public dynamic SaveList(List<PrintBarcode> barcode)
|
{
|
var result = barcode.Select(Save).ToList();
|
return result.All(b => b);
|
}
|
|
public dynamic DeleteBarcode(ErpBarcode barcode)
|
{
|
return UseTransaction(db =>
|
{
|
return DeleteData(db, barcode) ? 1 : 0;
|
}) > 0;
|
}
|
public dynamic DeleteBarcodeList(List<ErpBarcode> barcode)
|
{
|
var result = barcode.Select(DeleteBarcode).ToList();
|
return result.All(b => b);
|
}
|
|
public dynamic DeleteByNo(ErpDelivery delivery)
|
{
|
return UseTransaction(db =>
|
{
|
return DeleteDataByShd(db, delivery) ? 1 : 0;
|
}) > 0;
|
}
|
|
public dynamic DeleteListByNo(List<ErpDelivery> delivery)
|
{
|
var result = delivery.Select(DeleteByNo).ToList();
|
return result.All(b => b);
|
}
|
|
public dynamic DeleteByItem(DeliveryItem dt)
|
{
|
return UseTransaction(db =>
|
{
|
return DeleteDataByItem(db, dt) ? 1 : 0;
|
}) > 0;
|
}
|
|
public dynamic DeleteListByItem(List<DeliveryItem> dts)
|
{
|
var result = dts.Select(DeleteByItem).ToList();
|
return result.All(b => b);
|
}
|
|
// 删除数据的方法
|
private bool DeleteDataByItem(SqlSugarScope db, DeliveryItem dt)
|
{
|
var del = db.Deleteable<MesDeliveryNoteBarcode>().Where(s => s.DeliveryNo == dt.DeliveryNo && s.ProductCode==dt.ItemNo).ExecuteCommand() > 0;
|
|
if (del)
|
{
|
return true;
|
}
|
throw new NotImplementedException("删除失败");
|
}
|
|
// 删除数据的方法
|
private bool DeleteData(SqlSugarScope db, ErpBarcode barcode)
|
{
|
var del = db.Deleteable<MesDeliveryNoteBarcode>().Where(s => s.SmallBarcode == barcode.SmallBarcode).ExecuteCommand() > 0;
|
|
if (del) {
|
return true;
|
}
|
throw new NotImplementedException("删除失败");
|
}
|
|
// 删除数据的方法
|
private bool DeleteDataByShd(SqlSugarScope db, ErpDelivery delivery)
|
{
|
var del = db.Deleteable<MesDeliveryNoteBarcode>().
|
Where(s => s.DeliveryNo == delivery.DeliveryNo)
|
.ExecuteCommand() > 0;
|
|
if (del)
|
{
|
return true;
|
}
|
throw new NotImplementedException("删除失败");
|
}
|
|
// 插入或更新数据的方法
|
private bool SaveOrUpdateData(SqlSugarScope db, MesDeliveryNoteBarcode mesDeliveryBarcode)
|
{
|
if (mesDeliveryBarcode.Id != null)
|
{
|
base.DeleteById(mesDeliveryBarcode.Id);
|
}
|
|
var orUpdate = base.Insert(mesDeliveryBarcode);
|
if (orUpdate)
|
{
|
return true;
|
}
|
throw new NotImplementedException("插入或更新失败");
|
}
|
|
|
|
public MesDeliveryNoteBarcode GetMesDeliveryBarcode(PrintBarcode barcode)
|
{
|
var mesDeliveryBarcode = new MesDeliveryNoteBarcode();
|
var single = base.GetSingle(it => it.SmallBarcode == barcode.SmallBarcode);
|
if (single != null)
|
{
|
mesDeliveryBarcode.Id = single.Id;
|
}
|
|
|
mesDeliveryBarcode.DeliveryNo = barcode.DeliveryNo;
|
mesDeliveryBarcode.ProductCode = barcode.ProductCode;
|
|
mesDeliveryBarcode.LineNo = barcode.LineNo;
|
mesDeliveryBarcode.SmallBarcode = barcode.SmallBarcode;
|
mesDeliveryBarcode.IncludeQty = Convert.ToDecimal(barcode.IncludeQty);
|
mesDeliveryBarcode.CreateDate = DateTime.Now;
|
mesDeliveryBarcode.OuterBarcode = barcode.OuterBarcode;
|
mesDeliveryBarcode.BarcodeType = barcode.BarcodeType;
|
mesDeliveryBarcode.IsMegre = Convert.ToDecimal(barcode.IsMerge);
|
|
return mesDeliveryBarcode;
|
}
|
|
}
|
