From 1f41e51bfa04d8c324dace8ae16d166fdfa90866 Mon Sep 17 00:00:00 2001
From: hao <1836460075@qq.com>
Date: 星期二, 25 十一月 2025 11:08:27 +0800
Subject: [PATCH] 分布式调拨新表
---
StandardInterface/MES.Service/service/BasicData/Organization/MesStaffManager.cs | 2
StandardInterface/MES.Service/Modes/MesInvItemDbsqItems2.cs | 176 ++++++++++++++++++++++
StandardInterface/MES.Service/service/DbckaManager.cs | 24 +-
StandardInterface/MES.Service/Modes/MesInvItemDbsq2.cs | 258 ++++++++++++++++++++++++++++++++
4 files changed, 447 insertions(+), 13 deletions(-)
diff --git a/StandardInterface/MES.Service/Modes/MesInvItemDbsq2.cs b/StandardInterface/MES.Service/Modes/MesInvItemDbsq2.cs
new file mode 100644
index 0000000..b2ea50e
--- /dev/null
+++ b/StandardInterface/MES.Service/Modes/MesInvItemDbsq2.cs
@@ -0,0 +1,258 @@
+锘縰sing System;
+using System.Collections.Generic;
+using System.Linq;
+using SqlSugar;
+namespace MES.Service.Modes
+{
+ /// <summary>
+ /// 璋冩嫧鐢宠鍗�
+ ///</summary>
+ [SugarTable("MES_INV_ITEM_DBSQ2")]
+ public class MesInvItemDbsq2
+ {
+ /// <summary>
+ /// SEQ_INV_ID
+ ///</summary>
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true, OracleSequenceName = "SEQ_DBSQ2")]
+ //[SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+ public decimal Id { get; set; }
+ /// <summary>
+ /// 璋冩嫧鐢宠鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName = "BILL_NO")]
+ public string? BillNo { get; set; }
+ /// <summary>
+ /// 绉诲叆瀛愬簱id
+ ///</summary>
+ [SugarColumn(ColumnName = "INV_DEPOTS_ID")]
+ public decimal? InvDepotsId { get; set; }
+ /// <summary>
+ /// 绉诲叆璐т綅id
+ ///</summary>
+ [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_ID")]
+ public decimal? InvDepotSectionsId { get; set; }
+ /// <summary>
+ /// 鍒涘缓浜�
+ ///</summary>
+ [SugarColumn(ColumnName = "CREATE_BY")]
+ public string? CreateBy { get; set; }
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName = "CREATE_DATE")]
+ public DateTime? CreateDate { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂颁汉
+ ///</summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_BY")]
+ public string? LastupdateBy { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂版椂闂�
+ ///</summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
+ public DateTime? LastupdateDate { get; set; }
+ /// <summary>
+ /// 鐘舵�亅0-鍒跺崟1-瀹℃牳2-杩囪处
+ ///</summary>
+ [SugarColumn(ColumnName = "STATUS")]
+ public decimal? Status { get; set; }
+ /// <summary>
+ /// 澶囨敞
+ ///</summary>
+ [SugarColumn(ColumnName = "REMARK")]
+ public string? Remark { get; set; }
+ /// <summary>
+ /// 鍗曟嵁绫诲瀷ID
+ ///</summary>
+ [SugarColumn(ColumnName = "BILL_TYPE_ID")]
+ public decimal? BillTypeId { get; set; }
+ /// <summary>
+ /// 浜嬪姟绫诲瀷ID
+ ///</summary>
+ [SugarColumn(ColumnName = "TRANSACTION_ID")]
+ public decimal? TransactionId { get; set; }
+ /// <summary>
+ /// 瀹℃牳浜�
+ ///</summary>
+ [SugarColumn(ColumnName = "CHECKUSER")]
+ public string? Checkuser { get; set; }
+ /// <summary>
+ /// 瀹℃牳鏃ユ湡
+ ///</summary>
+ [SugarColumn(ColumnName = "CHECKDATE")]
+ public DateTime? Checkdate { get; set; }
+ /// <summary>
+ /// 绉诲叆瀛愬簱code
+ ///</summary>
+ [SugarColumn(ColumnName = "INV_DEPOTS_CODE")]
+ public string? InvDepotsCode { get; set; }
+ /// <summary>
+ /// 绉诲叆璐т綅code
+ ///</summary>
+ [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_CODE")]
+ public string? InvDepotSectionsCode { get; set; }
+ /// <summary>
+ /// 浜嬪姟绫诲瀷缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName = "TRANSACTION_NO")]
+ public decimal? TransactionNo { get; set; }
+ /// <summary>
+ /// 绉诲嚭瀛愬簱code
+ ///</summary>
+ [SugarColumn(ColumnName = "FROM_DEPOTS_CODE")]
+ public string? FromDepotsCode { get; set; }
+ /// <summary>
+ /// 宸ュ巶缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName = "FACTORY_CODE")]
+ public string? FactoryCode { get; set; }
+ /// <summary>
+ /// SAP杩斿洖鍗曟嵁
+ ///</summary>
+ [SugarColumn(ColumnName = "SAPNO")]
+ public string? Sapno { get; set; }
+ /// <summary>
+ /// 宸插洖鍐橲AP
+ ///</summary>
+ [SugarColumn(ColumnName = "SAPSTATUS")]
+ public short? Sapstatus { get; set; }
+ /// <summary>
+ /// SAP杩斿洖骞翠唤
+ ///</summary>
+ [SugarColumn(ColumnName = "SAPYEAR")]
+ public short? Sapyear { get; set; }
+ /// <summary>
+ /// SAP杩斿洖淇℃伅
+ ///</summary>
+ [SugarColumn(ColumnName = "SAPTEXT")]
+ public string? Saptext { get; set; }
+ /// <summary>
+ /// 鍒嗗巶缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName = "FACTORY")]
+ public string? Factory { get; set; }
+ /// <summary>
+ /// 鍏徃浠ｇ爜
+ ///</summary>
+ [SugarColumn(ColumnName = "COMPANY")]
+ public string? Company { get; set; }
+ /// <summary>
+ /// 鏄惁鎺ㄩ�丒RP1-鏄紝2-鍚�
+ ///</summary>
+ [SugarColumn(ColumnName = "TS")]
+ public decimal? Ts { get; set; }
+ /// <summary>
+ /// 0鏈皟鎷�1宸茶皟鎷�
+ ///</summary>
+ [SugarColumn(ColumnName = "DB_STATUS")]
+ public string? DbStatus { get; set; }
+ /// <summary>
+ /// 璋冨嚭缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName = "FSTOCKOUTORGID")]
+ public decimal? Fstockoutorgid { get; set; }
+ /// <summary>
+ /// 璋冨叆缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName = "FSTOCKORGID")]
+ public decimal? Fstockorgid { get; set; }
+ /// <summary>
+ /// 鍗曟嵁绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName = "DJ_LX")]
+ public string? Djlx { get; set; }
+ /// <summary>
+ /// 璋冩嫧绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName = "DB_LX1")]
+ public string? DbLx1 { get; set; }
+ /// <summary>
+ /// 璋冩嫧鏂瑰悜
+ ///</summary>
+ [SugarColumn(ColumnName = "DB_FX")]
+ public string? DbFx { get; set; }
+ /// <summary>
+ /// 璋冩嫧绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName = "DB_LX")]
+ public string? DbLx { get; set; }
+ /// <summary>
+ /// 涓氬姟绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName = "YW_LX")]
+ public string? YwLx { get; set; }
+ /// <summary>
+ /// 鍗曟嵁鐘舵��
+ ///</summary>
+ [SugarColumn(ColumnName = "DJ_ZT")]
+ public string? DjZt { get; set; }
+ /// <summary>
+ /// 鐢宠閮ㄩ棬
+ ///</summary>
+ [SugarColumn(ColumnName = "SQ_BM")]
+ public string? SqBm { get; set; }
+ /// <summary>
+ /// 鐢宠缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName = "SQ_ZZ")]
+ public string? SqZz { get; set; }
+ /// <summary>
+ /// 鐢宠鏃ユ湡
+ ///</summary>
+ [SugarColumn(ColumnName = "SQ_TIME")]
+ public string? SqTime { get; set; }
+ /// <summary>
+ /// 璋冨嚭璐т富绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName = "DC_HZ")]
+ public string? DcHz { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName = "ERPID")]
+ public string? Erpid { get; set; }
+
+ /// <summary>
+ /// 璋冨嚭搴撳瓨缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName = "DC_KC")]
+ public string? DcKc { get; set; }
+ /// <summary>
+ /// 璋冨叆搴撳瓨缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName = "DR_KC")]
+ public string? DrKc { get; set; }
+
+
+ /// <summary>
+ /// 璋冨叆璐т富
+ ///</summary>
+ [SugarColumn(ColumnName = "DR_HZ")]
+ public string? DrHz { get; set; }
+ /// <summary>
+ /// 璋冨叆浠撳簱
+ ///</summary>
+ [SugarColumn(ColumnName = "DR_CK")]
+ public string? DrCk { get; set; }
+ /// <summary>
+ /// 璋冨嚭閮ㄩ棬
+ ///</summary>
+ [SugarColumn(ColumnName = "DC_BM")]
+ public string? DcBm { get; set; }
+ /// <summary>
+ /// 璋冨叆閮ㄩ棬
+ ///</summary>
+ [SugarColumn(ColumnName = "DR_BM")]
+ public string? DrBm { get; set; }
+ /// <summary>
+ /// MES绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName = "TYPE2")]
+ public string? Type2 { get; set; }
+ /// <summary>
+ /// 渚涘簲鍟�
+ ///</summary>
+ [SugarColumn(ColumnName = "GYS")]
+ public string? Gys { get; set; }
+ }
+}
diff --git a/StandardInterface/MES.Service/Modes/MesInvItemDbsqItems2.cs b/StandardInterface/MES.Service/Modes/MesInvItemDbsqItems2.cs
new file mode 100644
index 0000000..7c75219
--- /dev/null
+++ b/StandardInterface/MES.Service/Modes/MesInvItemDbsqItems2.cs
@@ -0,0 +1,176 @@
+锘縰sing System;
+using System.Collections.Generic;
+using System.Linq;
+using SqlSugar;
+namespace MES.Service.Modes
+{
+ /// <summary>
+ /// 璋冩嫧鐢宠鍗曟槑缁嗚〃
+ ///</summary>
+ [SugarTable("MES_INV_ITEM_DBSQ_ITEMS2")]
+ public class MesInvItemDbsqItems2
+ {
+ /// <summary>
+ /// SEQ_MOVE_DETAIL
+ ///</summary>
+
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true, OracleSequenceName = "SEQ_DBSQ_DETAIL2")]
+ //[SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+ public decimal Id { get; set; }
+ /// <summary>
+ /// 涓昏〃id
+ ///</summary>
+ [SugarColumn(ColumnName = "ITEM_MOVE_ID")]
+ public decimal? ItemMoveId { get; set; }
+ /// <summary>
+ /// 鐗╂枡鍐呯爜
+ ///</summary>
+ [SugarColumn(ColumnName = "ITEM_ID")]
+ public decimal? ItemId { get; set; }
+ /// <summary>
+ /// 鐗╂枡缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName = "ITEM_NO")]
+ public string? ItemNo { get; set; }
+ /// <summary>
+ /// 鐢宠鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName = "SQ_NUM")]
+ public decimal? SqNum { get; set; }
+ /// <summary>
+ /// 璋冨嚭鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName = "DC_NUM")]
+ public decimal? DcNum { get; set; }
+ /// <summary>
+ /// 璋冨叆鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName = "DR_NUM")]
+ public decimal? DrNum { get; set; }
+ /// <summary>
+ /// 褰撳墠搴撳瓨鏁�
+ ///</summary>
+ [SugarColumn(ColumnName = "KC")]
+ public decimal? Kc { get; set; }
+ /// <summary>
+ /// 澶囨敞
+ ///</summary>
+ [SugarColumn(ColumnName = "REMARK")]
+ public string? Remark { get; set; }
+ /// <summary>
+ /// 椤规
+ ///</summary>
+ [SugarColumn(ColumnName = "LINE_NO")]
+ public decimal? LineNo { get; set; }
+ /// <summary>
+ /// 璋冩嫧鐢宠鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName = "BILL_NO")]
+ public string? BillNo { get; set; }
+ /// <summary>
+ /// 璋冨嚭鐘舵��
+ ///</summary>
+ [SugarColumn(ColumnName = "MOVE_OUT")]
+ public decimal? MoveOut { get; set; }
+ /// <summary>
+ /// 璋冨叆鐘舵��
+ ///</summary>
+ [SugarColumn(ColumnName = "MOVE_IN")]
+ public decimal? MoveIn { get; set; }
+ /// <summary>
+ /// 鍒涘缓浜�
+ ///</summary>
+ [SugarColumn(ColumnName = "CREATE_BY")]
+ public string? CreateBy { get; set; }
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName = "CREATE_DATE")]
+ public DateTime? CreateDate { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂颁汉
+ ///</summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_BY")]
+ public string? LastupdateBy { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂版椂闂�
+ ///</summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
+ public DateTime? LastupdateDate { get; set; }
+ /// <summary>
+ /// 鍗曚綅
+ ///</summary>
+ [SugarColumn(ColumnName = "ITEM_UNIT")]
+ public decimal? ItemUnit { get; set; }
+ /// <summary>
+ /// 鏄惁鍚屾ERP
+ ///</summary>
+ [SugarColumn(ColumnName = "IS_TB")]
+ public decimal? IsTb { get; set; }
+ /// <summary>
+ /// 璋冨嚭缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName = "DC_ORG")]
+ public string? DcOrg { get; set; }
+ /// <summary>
+ /// 璋冨嚭浠撳簱
+ ///</summary>
+ [SugarColumn(ColumnName = "DC_DEPOT")]
+ public string? DcDepot { get; set; }
+ /// <summary>
+ /// 璋冨叆缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName = "DR_ORG")]
+ public string? DrOrg { get; set; }
+ /// <summary>
+ /// 璋冨叆浠撳簱
+ ///</summary>
+ [SugarColumn(ColumnName = "DR_DEPOT")]
+ public string? DrDepot { get; set; }
+ /// <summary>
+ /// 璋冨嚭璐т富
+ ///</summary>
+ [SugarColumn(ColumnName = "DC_HZ")]
+ public string? DcHz { get; set; }
+ /// <summary>
+ /// 璋冨叆璐т富
+ ///</summary>
+ [SugarColumn(ColumnName = "DR_HZ")]
+ public string? DrHz { get; set; }
+ /// <summary>
+ /// erpid
+ ///</summary>
+ [SugarColumn(ColumnName = "ERPID")]
+ public string? Erpid { get; set; }
+ /// <summary>
+ /// erp澶磇d
+ ///</summary>
+ [SugarColumn(ColumnName = "EID")]
+ public string? Eid { get; set; }
+ /// <summary>
+ /// 婧愬崟绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName = "YD_LX")]
+ public string? YdLx { get; set; }
+ /// <summary>
+ /// 婧愬崟缂栧彿
+ ///</summary>
+ [SugarColumn(ColumnName = "YD_BM")]
+ public string? YdBm { get; set; }
+ /// <summary>
+ /// 璁㈠崟绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName = "DD_LX")]
+ public string? DdLx { get; set; }
+ /// <summary>
+ /// 璁㈠崟缂栧彿
+ ///</summary>
+ [SugarColumn(ColumnName = "DD_BM")]
+ public string? DdBm { get; set; }
+ /// <summary>
+ /// 閫氱煡鍗曞崟鍙�
+ ///</summary>
+ [SugarColumn(ColumnName = "TZD_DH")]
+ public string? TzdDh { get; set; }
+ }
+}
diff --git a/StandardInterface/MES.Service/service/BasicData/Organization/MesStaffManager.cs b/StandardInterface/MES.Service/service/BasicData/Organization/MesStaffManager.cs
index 85a2730..b89ad03 100644
--- a/StandardInterface/MES.Service/service/BasicData/Organization/MesStaffManager.cs
+++ b/StandardInterface/MES.Service/service/BasicData/Organization/MesStaffManager.cs
@@ -332,7 +332,7 @@
public bool SaveList(List<ErpStaff> departments)
{
var list = new List<MesStaff>();
- var userList = new List<SysUser>();
+ var userList = new List<SysUser>();
var mesStaffPositionLinkList = new List<MesStaffPositionLink>();
departments.ForEach(s =>
diff --git a/StandardInterface/MES.Service/service/DbckaManager.cs b/StandardInterface/MES.Service/service/DbckaManager.cs
index 7bfdc3a..322906e 100644
--- a/StandardInterface/MES.Service/service/DbckaManager.cs
+++ b/StandardInterface/MES.Service/service/DbckaManager.cs
@@ -10,7 +10,7 @@
namespace MES.Service.service
{
- public class DbckaManager : Repository<MesInvItemDbsq>
+ public class DbckaManager : Repository<MesInvItemDbsq2>
{
public bool SaveList(List<ERPDBCK> list)
{
@@ -39,9 +39,9 @@
}) > 0;
}
- private MesInvItemDbsq MapErpToMesHead(ErpDBCKA dto)
+ private MesInvItemDbsq2 MapErpToMesHead(ErpDBCKA dto)
{
- var entity = new MesInvItemDbsq
+ var entity = new MesInvItemDbsq2
{
BillNo = dto.billno,
Djlx = dto.dj_lx,
@@ -66,7 +66,7 @@
// var single = base.GetSingle(it => it.Erpid == entity.Erpid);
/* if (single != null && single.Id.HasValue)
entity.Id = single.Id.Value;*/
- var single = Db.Queryable<MesInvItemDbsq>()
+ var single = Db.Queryable<MesInvItemDbsq2>()
.Where(it => it.Erpid == entity.Erpid)
.First();
if (single != null)
@@ -76,13 +76,13 @@
}
- private List<MesInvItemDbsqItems> MapErpDbckbToDbckb(List<ErpDBCKB> list)
+ private List<MesInvItemDbsqItems2> MapErpDbckbToDbckb(List<ErpDBCKB> list)
{
- var result = new List<MesInvItemDbsqItems>();
+ var result = new List<MesInvItemDbsqItems2>();
foreach (var dto in list)
{
- var item = new MesInvItemDbsqItems
+ var item = new MesInvItemDbsqItems2
{
ItemId = Convert.ToDecimal(dto.itemid),
ItemUnit = Convert.ToDecimal(dto.unit),
@@ -99,7 +99,7 @@
};
- var existing = Db.Queryable<MesInvItemDbsqItems>().Where(s => s.Erpid == item.Erpid).Single();
+ var existing = Db.Queryable<MesInvItemDbsqItems2>().Where(s => s.Erpid == item.Erpid).Single();
if (existing != null) item.Id = existing.Id;
result.Add(item);
@@ -108,12 +108,12 @@
return result;
}
- private bool SaveOrUpdateData(SqlSugarScope db, MesInvItemDbsq head, List<MesInvItemDbsqItems> details)
+ private bool SaveOrUpdateData(SqlSugarScope db, MesInvItemDbsq2 head, List<MesInvItemDbsqItems2> details)
{
if (head.Id != null)
base.DeleteById(head.Id);
- db.Deleteable<MesInvItemDbsqItems>()
+ db.Deleteable<MesInvItemDbsqItems2>()
.Where(d => d.Eid == head.Erpid)
.ExecuteCommand();
@@ -135,11 +135,11 @@
throw new NotImplementedException("鎻掑叆鎴栨洿鏂板け璐�");
}
- private bool UpdateData(SqlSugarScope db, MesInvItemDbsq head, List<MesInvItemDbsqItems> details)
+ private bool UpdateData(SqlSugarScope db, MesInvItemDbsq2 head, List<MesInvItemDbsqItems2> details)
{
var ids = details.Select(d => d.Id).ToArray();
var deletedHead = base.DeleteById(head.Id);
- var deletedDetails = db.Deleteable<MesInvItemDbsqItems>().In(ids).ExecuteCommand() > 0;
+ var deletedDetails = db.Deleteable<MesInvItemDbsqItems2>().In(ids).ExecuteCommand() > 0;
if (deletedHead && deletedDetails) return true;
--
Gitblit v1.9.3