From f80d5cdf701b3d3f2e21bffaff6e99a2a240fc0e Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期五, 12 七月 2024 11:25:54 +0800
Subject: [PATCH] 调整erp接口
---
MES.Service/Modes/SalesReturnNoticeDetail.cs | 155 +++
MESApplication/bin/Release/net8.0/publish/MESApplication.pdb | 0
MES.Service/Modes/MesRohInData.cs | 8
MESApplication/Controllers/SJController.cs | 1
MESApplication/Controllers/BasicData/ShipmentDetailController.cs | 162 +++
MESApplication/bin/Release/net8.0/publish/MESApplication.dll | 0
MES.Service/Modes/MesRohIn.cs | 8
MESApplication/bin/Debug/net8.0/MESApplication.pdb | 0
MESApplication/bin/Release/net8.0/MES.Service.dll | 0
MESApplication/bin/Release/net8.0/MESApplication.dll | 0
MESApplication/bin/Release/net8.0/publish/MES.Service.pdb | 0
MESApplication/bin/Release/net8.0/MES.Service.pdb | 0
MESApplication/Controllers/RKJController.cs | 1
MESApplication/bin/Release/net8.0/MESApplication.pdb | 0
MES.Service/bin/Debug/net8.0/MES.Service.pdb | 0
MESApplication/bin/Release/net8.0/publish/MES.Service.dll | 0
MES.Service/Modes/SysDepartment.cs | 4
MES.Service/Modes/SalesOrderDetail.cs | 113 ++
MESApplication/Controllers/BasicData/SalesOrderController.cs | 162 +++
MES.Service/service/BasicData/ShipmentNoticeManager.cs | 75 +
MESApplication/bin/Debug/net8.0/MESApplication.exe | 0
MES.Service/bin/Release/net8.0/MES.Service.dll | 0
MESApplication/Controllers/BasicData/SalesReturnNoticeController.cs | 163 +++
MES.Service/bin/Release/net8.0/MES.Service.pdb | 0
MESApplication/Controllers/XJController.cs | 1
MES.Service/service/BasicData/SalesReturnNoticeManager.cs | 78 +
MES.Service/service/BasicData/SalesOrderManager.cs | 78 +
MES.Service/Modes/SalesReturnNotice.cs | 83 +
MESApplication/bin/Release/net8.0/MESApplication.exe | 0
MES.Service/service/BasicData/MesStaffManager.cs | 6
MES.Service/service/BasicData/MesRohInManager.cs | 488 ++++-----
MESApplication/Controllers/BasicData/SalesReturnNoticeDetailController.cs | 164 +++
MES.Service/Dto/webApi/ErpRohIn.cs | 5
MES.Service/service/BasicData/ShipmentDetailManager.cs | 78 +
MESApplication/bin/Debug/net8.0/MES.Service.pdb | 0
MESApplication/Controllers/BasicData/SalesOrderDetailController.cs | 162 +++
MES.Service/Modes/SalesOrder.cs | 112 ++
MESApplication/bin/Debug/net8.0/MES.Service.dll | 0
MES.Service/Dto/webApi/ErpShipment.cs | 8
MESApplication/Controllers/BaseController.cs | 1
MES.Service/service/BasicData/SalesOrderDetailManager.cs | 78 +
MES.Service/Dto/webApi/ErpShipmentDetail.cs | 20
MES.Service/service/BasicData/MesSupplierManager.cs | 9
MES.Service/Modes/MesSupplier.cs | 4
MESApplication/bin/Release/net8.0/publish/MESApplication.exe | 0
MESApplication/Controllers/BasicData/ShipmentNoticeController.cs | 162 +++
MES.Service/Modes/ShipmentDetail.cs | 155 +++
MES.Service/Dto/webApi/ErpShipmentNotice.cs | 16
MES.Service/Dto/webApi/ErpItems.cs | 2
MESApplication/bin/Debug/net8.0/MESApplication.dll | 0
MES.Service/bin/Debug/net8.0/MES.Service.dll | 0
MESApplication/Controllers/SuspendController.cs | 1
MES.Service/service/BasicData/SalesReturnNoticeDetailManager.cs | 79 +
MES.Service/Modes/ShipmentNotice.cs | 125 ++
MESApplication/Controllers/LoginController.cs | 1
55 files changed, 2,480 insertions(+), 288 deletions(-)
diff --git a/MES.Service/Dto/webApi/ErpItems.cs b/MES.Service/Dto/webApi/ErpItems.cs
index ca68e49..e2b3a76 100644
--- a/MES.Service/Dto/webApi/ErpItems.cs
+++ b/MES.Service/Dto/webApi/ErpItems.cs
@@ -25,7 +25,7 @@
public string? FForbidStatus { get; set; }
public string? FErpClsID { get; set; }
public string? FWorkShopId { get; set; }
-
+
public string? FPRODUCEUNITID { get; set; }
public string? FSUBCONUNITID { get; set; }
}
\ No newline at end of file
diff --git a/MES.Service/Dto/webApi/ErpRohIn.cs b/MES.Service/Dto/webApi/ErpRohIn.cs
index 2515982..bbd2c6b 100644
--- a/MES.Service/Dto/webApi/ErpRohIn.cs
+++ b/MES.Service/Dto/webApi/ErpRohIn.cs
@@ -39,4 +39,9 @@
public string? FModifyDate { get; set; }
public string? FApproverId { get; set; }
public string? FApproveDate { get; set; }
+
+ public string? FCHANGEREASON { get; set; }
+
+ //閲囪喘璁㈠崟A 閲囪喘璁㈠崟鍙樻洿鍗旴
+ public string? FBILLTYPE { get; set; }
}
\ No newline at end of file
diff --git a/MES.Service/Dto/webApi/ErpShipment.cs b/MES.Service/Dto/webApi/ErpShipment.cs
new file mode 100644
index 0000000..d5768a5
--- /dev/null
+++ b/MES.Service/Dto/webApi/ErpShipment.cs
@@ -0,0 +1,8 @@
+锘縩amespace MES.Service.Dto.webApi;
+
+public class ErpShipment
+{
+ public ErpShipmentNotice ShipmentNotice { get; set; }
+
+ public List<ErpShipmentDetail> ShipmentDetails { get; set; }
+}
\ No newline at end of file
diff --git a/MES.Service/Dto/webApi/ErpShipmentDetail.cs b/MES.Service/Dto/webApi/ErpShipmentDetail.cs
new file mode 100644
index 0000000..f75020c
--- /dev/null
+++ b/MES.Service/Dto/webApi/ErpShipmentDetail.cs
@@ -0,0 +1,20 @@
+锘縩amespace MES.Service.Dto.webApi;
+
+public class ErpShipmentDetail
+{
+ public string ErpId { get; set; }
+ public string? ErpHeadId { get; set; }
+ public string? FMaterialID { get; set; }
+ public string? FMaterialName { get; set; }
+ public string? FMateriaModel { get; set; }
+ public string? FAmount { get; set; }
+ public string? FPrice { get; set; }
+ public string? FQty { get; set; }
+ public string? FLot { get; set; }
+ public string? FNoteEntry { get; set; }
+ public string? F_UNW_Text_xsddh { get; set; }
+ public string? FSOEntryId { get; set; }
+ public string? FBasePrice { get; set; }
+ public string? FStockID { get; set; }
+ public string? FBaseUnitID { get; set; }
+}
\ No newline at end of file
diff --git a/MES.Service/Dto/webApi/ErpShipmentNotice.cs b/MES.Service/Dto/webApi/ErpShipmentNotice.cs
new file mode 100644
index 0000000..cabae9d
--- /dev/null
+++ b/MES.Service/Dto/webApi/ErpShipmentNotice.cs
@@ -0,0 +1,16 @@
+锘縩amespace MES.Service.Dto.webApi;
+
+public class ErpShipmentNotice
+{
+ public string? FCreatorId { get; set; }
+ public string? FBillNo { get; set; }
+ public string? FApproverID { get; set; }
+ public string? FCreateDate { get; set; }
+ public string? FApproveDate { get; set; }
+ public string? FSaleDeptId { get; set; }
+ public string? FCustomerID { get; set; }
+ public string? FNote { get; set; }
+ public string? FSalesManID { get; set; }
+ public string ERPId { get; set; }
+ public string? Type { get; set; }
+}
\ No newline at end of file
diff --git a/MES.Service/Modes/MesRohIn.cs b/MES.Service/Modes/MesRohIn.cs
index be2d3ef..abdfd74 100644
--- a/MES.Service/Modes/MesRohIn.cs
+++ b/MES.Service/Modes/MesRohIn.cs
@@ -28,7 +28,7 @@
public string? DocumentStatus { get; set; }
/// <summary>
- /// 鍗曟嵁绫诲瀷 1銆侀噰璐� 2銆佸澶�
+ /// 鍗曟嵁绫诲瀷
/// </summary>
[SugarColumn(ColumnName = "DOCUMENT_TYPE")]
public string? DocumentType { get; set; }
@@ -236,6 +236,12 @@
/// <summary>
/// 鑷畾涔夊瓧娈�1
/// </summary>
+ [SugarColumn(ColumnName = "changereason")]
+ public string? Changereason { get; set; }
+
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�1
+ /// </summary>
[SugarColumn(ColumnName = "REMARK1")]
public string? Remark1 { get; set; }
diff --git a/MES.Service/Modes/MesRohInData.cs b/MES.Service/Modes/MesRohInData.cs
index da6d2ac..0fd7920 100644
--- a/MES.Service/Modes/MesRohInData.cs
+++ b/MES.Service/Modes/MesRohInData.cs
@@ -323,7 +323,7 @@
/// </summary>
[SugarColumn(ColumnName = "ERP_ID")]
public decimal? ErpId { get; set; }
-
+
/// <summary>
/// 閲囪喘璁㈠崟琛屽彿
/// </summary>
@@ -333,18 +333,18 @@
/// <summary>
/// 闇�姹傜粍缁�
/// </summary>
- [SugarColumn(ColumnName = "ERP_ID")]
+ [SugarColumn(ColumnName = "DEMAND")]
public string? Demand { get; set; }
/// <summary>
/// 鏀舵枡缁勭粐
/// </summary>
- [SugarColumn(ColumnName = "ERP_ID")]
+ [SugarColumn(ColumnName = "RECEIVING")]
public string? Receiving { get; set; }
/// <summary>
/// 缁撶畻缁勭粐
/// </summary>
- [SugarColumn(ColumnName = "ERP_ID")]
+ [SugarColumn(ColumnName = "SETTLEMENT")]
public string? Settlement { get; set; }
}
\ No newline at end of file
diff --git a/MES.Service/Modes/MesSupplier.cs b/MES.Service/Modes/MesSupplier.cs
index 7269980..8736c2b 100644
--- a/MES.Service/Modes/MesSupplier.cs
+++ b/MES.Service/Modes/MesSupplier.cs
@@ -11,13 +11,13 @@
/// <summary>
/// ID
/// </summary>
- [SugarColumn(ColumnName = "ID")]
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
public decimal Id { get; set; }
/// <summary>
/// 渚涘簲鍟嗙紪鐮�
/// </summary>
- [SugarColumn(ColumnName = "SUPP_NO", IsPrimaryKey = true)]
+ [SugarColumn(ColumnName = "SUPP_NO")]
public string? SuppNo { get; set; }
/// <summary>
diff --git a/MES.Service/Modes/SalesOrder.cs b/MES.Service/Modes/SalesOrder.cs
new file mode 100644
index 0000000..76d12b9
--- /dev/null
+++ b/MES.Service/Modes/SalesOrder.cs
@@ -0,0 +1,112 @@
+锘縰sing SqlSugar;
+
+namespace MES.Service.Modes;
+
+/// <summary>
+/// 閿�鍞鍗曡〃
+/// </summary>
+[SugarTable("SALES_ORDER")]
+public class SalesOrder
+{
+ /// <summary>
+ /// SEQ_sales搴忓垪
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_sales", IsPrimaryKey = true)]
+ public decimal Id { get; set; }
+
+ /// <summary>
+ /// 璁㈠崟鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "ORDER_ID")]
+ public string OrderId { get; set; }
+
+ /// <summary>
+ /// 璁㈠崟鍗曞埆
+ /// </summary>
+ [SugarColumn(ColumnName = "ORDER_TYPE")]
+ public string OrderType { get; set; }
+
+ /// <summary>
+ /// 鍙楄鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "ORDER_DATE")]
+ public DateTime? OrderDate { get; set; }
+
+ /// <summary>
+ /// 鍗曟嵁鐗堟湰
+ /// </summary>
+ [SugarColumn(ColumnName = "DOCUMENT_VERSION")]
+ public long? DocumentVersion { get; set; }
+
+ /// <summary>
+ /// 鍗曟嵁鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "DOCUMENT_DATE")]
+ public DateTime? DocumentDate { get; set; }
+
+ /// <summary>
+ /// 宸ュ巶缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "FACTORY_ID")]
+ public string FactoryId { get; set; }
+
+ /// <summary>
+ /// 宸ュ巶绠�绉�
+ /// </summary>
+ [SugarColumn(ColumnName = "FACTORY_NAME")]
+ public string FactoryName { get; set; }
+
+ /// <summary>
+ /// 瀹㈡埛缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "CUSTOMER_ID")]
+ public string CustomerId { get; set; }
+
+ /// <summary>
+ /// 瀹㈡埛绠�绉�
+ /// </summary>
+ [SugarColumn(ColumnName = "CUSTOMER_NAME")]
+ public string CustomerName { get; set; }
+
+ /// <summary>
+ /// 瀹㈡埛鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "CUSTOMER_ORDER_ID")]
+ public string CustomerOrderId { get; set; }
+
+ /// <summary>
+ /// 閮ㄩ棬缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "DEPARTMENT_ID")]
+ public string DepartmentId { get; set; }
+
+ /// <summary>
+ /// 鎬绘暟閲�
+ /// </summary>
+ [SugarColumn(ColumnName = "TOTAL_QUANTITY")]
+ public decimal? TotalQuantity { get; set; }
+
+ /// <summary>
+ /// 澶囨敞
+ /// </summary>
+ [SugarColumn(ColumnName = "REMARKS")]
+ public string Remarks { get; set; }
+
+ /// <summary>
+ /// erp瀹℃牳鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "APPROVAL_DATE")]
+ public DateTime? ApprovalDate { get; set; }
+
+ /// <summary>
+ /// erp瀹℃牳鑰�
+ /// </summary>
+ [SugarColumn(ColumnName = "APPROVER")]
+ public string Approver { get; set; }
+
+ /// <summary>
+ /// ERPID
+ /// </summary>
+ [SugarColumn(ColumnName = "ERP_ID")]
+ public string ErpId { get; set; }
+}
\ No newline at end of file
diff --git a/MES.Service/Modes/SalesOrderDetail.cs b/MES.Service/Modes/SalesOrderDetail.cs
new file mode 100644
index 0000000..0dd800e
--- /dev/null
+++ b/MES.Service/Modes/SalesOrderDetail.cs
@@ -0,0 +1,113 @@
+锘縰sing SqlSugar;
+
+namespace MES.Service.Modes;
+
+/// <summary>
+/// 閿�鍞鍗曟槑缁嗚〃
+/// </summary>
+[SugarTable("SALES_ORDER_DETAIL")]
+public class SalesOrderDetail
+{
+ /// <summary>
+ /// SEQ_sales搴忓垪
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_sales",
+ IsPrimaryKey = true)]
+ public decimal Id { get; set; }
+
+ /// <summary>
+ /// 璁㈠崟鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "ORDER_ID")]
+ public string OrderId { get; set; }
+
+ /// <summary>
+ /// 搴忓彿
+ /// </summary>
+ [SugarColumn(ColumnName = "LINE_NUMBER")]
+ public long? LineNumber { get; set; }
+
+ /// <summary>
+ /// 浜у搧缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "PRODUCT_CODE")]
+ public string ProductCode { get; set; }
+
+ /// <summary>
+ /// 浜у搧鍚嶇О
+ /// </summary>
+ [SugarColumn(ColumnName = "PRODUCT_NAME")]
+ public string ProductName { get; set; }
+
+ /// <summary>
+ /// 浜у搧瑙勬牸
+ /// </summary>
+ [SugarColumn(ColumnName = "PRODUCT_SPEC")]
+ public string ProductSpec { get; set; }
+
+ /// <summary>
+ /// 棰勪氦璐ф棩鏈�
+ /// </summary>
+ [SugarColumn(ColumnName = "SCHEDULED_DELIVERY_DATE")]
+ public DateTime? ScheduledDeliveryDate { get; set; }
+
+ /// <summary>
+ /// 璁㈠崟鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "ORDER_QUANTITY")]
+ public decimal? OrderQuantity { get; set; }
+
+ /// <summary>
+ /// 鍗曚綅
+ /// </summary>
+ [SugarColumn(ColumnName = "UNIT")]
+ public string Unit { get; set; }
+
+ /// <summary>
+ /// 鍗曚环
+ /// </summary>
+ [SugarColumn(ColumnName = "UNIT_PRICE")]
+ public decimal? UnitPrice { get; set; }
+
+ /// <summary>
+ /// 閲戦
+ /// </summary>
+ [SugarColumn(ColumnName = "AMOUNT")]
+ public decimal? Amount { get; set; }
+
+ /// <summary>
+ /// 瀹㈡埛浜у搧缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "CUSTOMER_PRODUCT_CODE")]
+ public string CustomerProductCode { get; set; }
+
+ /// <summary>
+ /// 宸蹭氦璐ф暟
+ /// </summary>
+ [SugarColumn(ColumnName = "DELIVERED_QUANTITY")]
+ public decimal? DeliveredQuantity { get; set; }
+
+ /// <summary>
+ /// 缁撴潫
+ /// </summary>
+ [SugarColumn(ColumnName = "IS_CLOSED")]
+ public string IsClosed { get; set; }
+
+ /// <summary>
+ /// 澶囨敞
+ /// </summary>
+ [SugarColumn(ColumnName = "REMARKS")]
+ public string Remarks { get; set; }
+
+ /// <summary>
+ /// ERPID
+ /// </summary>
+ [SugarColumn(ColumnName = "ERP_ID")]
+ public string ErpId { get; set; }
+
+ /// <summary>
+ /// ERP澶碔D
+ /// </summary>
+ [SugarColumn(ColumnName = "ERP_HEAD_ID")]
+ public string ErpHeadId { get; set; }
+}
\ No newline at end of file
diff --git a/MES.Service/Modes/SalesReturnNotice.cs b/MES.Service/Modes/SalesReturnNotice.cs
new file mode 100644
index 0000000..f3c462d
--- /dev/null
+++ b/MES.Service/Modes/SalesReturnNotice.cs
@@ -0,0 +1,83 @@
+锘縰sing SqlSugar;
+
+namespace MES.Service.Modes;
+
+/// <summary>
+/// 閿�鍞��璐ч�氱煡鍗曡〃
+/// </summary>
+[SugarTable("SALES_RETURN_NOTICE")]
+public class SalesReturnNotice
+{
+ /// <summary>
+ /// SEQ_sales
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_sales",
+ IsPrimaryKey = true)]
+ public decimal Id { get; set; }
+
+ /// <summary>
+ /// 鍒跺崟浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATED_BY")]
+ public string CreatedBy { get; set; }
+
+ /// <summary>
+ /// 鍗曟嵁缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "DOCUMENT_ID")]
+ public string DocumentId { get; set; }
+
+ /// <summary>
+ /// 瀹℃牳浜哄悕绉�
+ /// </summary>
+ [SugarColumn(ColumnName = "APPROVED_BY")]
+ public string ApprovedBy { get; set; }
+
+ /// <summary>
+ /// 鍒跺崟/瀹℃牳鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATED_OR_APPROVED_DATE")]
+ public DateTime? CreatedOrApprovedDate { get; set; }
+
+ /// <summary>
+ /// 閮ㄩ棬浠g爜
+ /// </summary>
+ [SugarColumn(ColumnName = "DEPARTMENT_CODE")]
+ public string DepartmentCode { get; set; }
+
+ /// <summary>
+ /// 閮ㄩ棬鍚嶇О
+ /// </summary>
+ [SugarColumn(ColumnName = "DEPARTMENT_NAME")]
+ public string DepartmentName { get; set; }
+
+ /// <summary>
+ /// 璐揣鍗曚綅浠g爜
+ /// </summary>
+ [SugarColumn(ColumnName = "PURCHASER_CODE")]
+ public string PurchaserCode { get; set; }
+
+ /// <summary>
+ /// 璐揣鍗曚綅鍚嶇О
+ /// </summary>
+ [SugarColumn(ColumnName = "PURCHASER_NAME")]
+ public string PurchaserName { get; set; }
+
+ /// <summary>
+ /// 涓氬姟鍛樹唬鐮�
+ /// </summary>
+ [SugarColumn(ColumnName = "SALESPERSON_CODE")]
+ public string SalespersonCode { get; set; }
+
+ /// <summary>
+ /// 涓氬姟鍛樺悕绉�
+ /// </summary>
+ [SugarColumn(ColumnName = "SALESPERSON_NAME")]
+ public string SalespersonName { get; set; }
+
+ /// <summary>
+ /// ERPID
+ /// </summary>
+ [SugarColumn(ColumnName = "ERP_ID")]
+ public string ErpId { get; set; }
+}
\ No newline at end of file
diff --git a/MES.Service/Modes/SalesReturnNoticeDetail.cs b/MES.Service/Modes/SalesReturnNoticeDetail.cs
new file mode 100644
index 0000000..3d64ef4
--- /dev/null
+++ b/MES.Service/Modes/SalesReturnNoticeDetail.cs
@@ -0,0 +1,155 @@
+锘縰sing SqlSugar;
+
+namespace MES.Service.Modes;
+
+/// <summary>
+/// 閿�鍞��璐ч�氱煡鍗曟槑缁嗚〃
+/// </summary>
+[SugarTable("SALES_RETURN_NOTICE_DETAIL")]
+public class SalesReturnNoticeDetail
+{
+ /// <summary>
+ /// SEQ_sales
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_sales",
+ IsPrimaryKey = true)]
+ public decimal Id { get; set; }
+
+ /// <summary>
+ /// 鍗曟嵁琛屽彿
+ /// </summary>
+ [SugarColumn(ColumnName = "LINE_NUMBER")]
+ public long? LineNumber { get; set; }
+
+ /// <summary>
+ /// 浜у搧浠g爜
+ /// </summary>
+ [SugarColumn(ColumnName = "PRODUCT_CODE")]
+ public string ProductCode { get; set; }
+
+ /// <summary>
+ /// 浜у搧鍚嶇О
+ /// </summary>
+ [SugarColumn(ColumnName = "PRODUCT_NAME")]
+ public string ProductName { get; set; }
+
+ /// <summary>
+ /// 浜у搧瑙勬牸
+ /// </summary>
+ [SugarColumn(ColumnName = "PRODUCT_SPEC")]
+ public string ProductSpec { get; set; }
+
+ /// <summary>
+ /// 閲戦
+ /// </summary>
+ [SugarColumn(ColumnName = "AMOUNT")]
+ public decimal? Amount { get; set; }
+
+ /// <summary>
+ /// 鍗曚环
+ /// </summary>
+ [SugarColumn(ColumnName = "UNIT_PRICE")]
+ public decimal? UnitPrice { get; set; }
+
+ /// <summary>
+ /// 鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "QUANTITY")]
+ public decimal? Quantity { get; set; }
+
+ /// <summary>
+ /// 鍑哄簱鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "OUT_QUANTITY")]
+ public decimal? OutQuantity { get; set; }
+
+ /// <summary>
+ /// 鎵瑰彿
+ /// </summary>
+ [SugarColumn(ColumnName = "BATCH_NUMBER")]
+ public string BatchNumber { get; set; }
+
+ /// <summary>
+ /// 閫�璐ф暟閲�
+ /// </summary>
+ [SugarColumn(ColumnName = "RETURN_QUANTITY")]
+ public decimal? ReturnQuantity { get; set; }
+
+ /// <summary>
+ /// 鍙戣揣鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "DELIVERY_QUANTITY")]
+ public decimal? DeliveryQuantity { get; set; }
+
+ /// <summary>
+ /// 澶囨敞
+ /// </summary>
+ [SugarColumn(ColumnName = "REMARKS")]
+ public string Remarks { get; set; }
+
+ /// <summary>
+ /// 閿�鍞鍗曞崟鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "SALES_ORDER_ID")]
+ public string SalesOrderId { get; set; }
+
+ /// <summary>
+ /// 閿�鍞鍗曞垎褰�
+ /// </summary>
+ [SugarColumn(ColumnName = "SALES_ORDER_ENTRY")]
+ public string SalesOrderEntry { get; set; }
+
+ /// <summary>
+ /// 閿�鍞鍗旾D
+ /// </summary>
+ [SugarColumn(ColumnName = "SALES_ORDER_DETAIL_ID")]
+ public string SalesOrderDetailId { get; set; }
+
+ /// <summary>
+ /// 鍩烘湰鍗曚环
+ /// </summary>
+ [SugarColumn(ColumnName = "BASE_UNIT_PRICE")]
+ public decimal? BaseUnitPrice { get; set; }
+
+ /// <summary>
+ /// 鍩烘湰鍗曚綅鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "BASE_UNIT_QUANTITY")]
+ public decimal? BaseUnitQuantity { get; set; }
+
+ /// <summary>
+ /// 浠撳簱浠g爜
+ /// </summary>
+ [SugarColumn(ColumnName = "WAREHOUSE_CODE")]
+ public string WarehouseCode { get; set; }
+
+ /// <summary>
+ /// 浠撳簱鍚嶇О
+ /// </summary>
+ [SugarColumn(ColumnName = "WAREHOUSE_NAME")]
+ public string WarehouseName { get; set; }
+
+ /// <summary>
+ /// 鍩烘湰鍗曚綅鍑哄簱鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "BASE_UNIT_OUT_QUANTITY")]
+ public decimal? BaseUnitOutQuantity { get; set; }
+
+ /// <summary>
+ /// 鍗曚綅
+ /// </summary>
+ [SugarColumn(ColumnName = "UNIT")]
+ public string Unit { get; set; }
+
+ /// <summary>
+ /// ERPID
+ /// </summary>
+ [SugarColumn(ColumnName = "ERP_ID")]
+ public string ErpId { get; set; }
+
+ /// <summary>
+ /// ERP澶碔D
+ /// </summary>
+ [SugarColumn(ColumnName = "ERP_HEAD_ID")]
+ public string ErpHeadId { get; set; }
+}
\ No newline at end of file
diff --git a/MES.Service/Modes/ShipmentDetail.cs b/MES.Service/Modes/ShipmentDetail.cs
new file mode 100644
index 0000000..7462202
--- /dev/null
+++ b/MES.Service/Modes/ShipmentDetail.cs
@@ -0,0 +1,155 @@
+锘縰sing SqlSugar;
+
+namespace MES.Service.Modes;
+
+/// <summary>
+/// 閿�鍞彂璐ч�氱煡鍗曟槑缁嗚〃
+/// </summary>
+[SugarTable("SHIPMENT_DETAIL")]
+public class ShipmentDetail
+{
+ /// <summary>
+ /// SEQ_sales
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_sales",
+ IsPrimaryKey = true)]
+ public decimal Id { get; set; }
+
+ /// <summary>
+ /// ERPID
+ /// </summary>
+ [SugarColumn(ColumnName = "ERP_ID")]
+ public string ErpId { get; set; }
+
+ /// <summary>
+ /// ERP澶碔D
+ /// </summary>
+ [SugarColumn(ColumnName = "ERP_HEAD_ID")]
+ public string ErpHeadId { get; set; }
+
+ /// <summary>
+ /// 鍗曟嵁琛屽彿
+ /// </summary>
+ [SugarColumn(ColumnName = "LINE_NO")]
+ public long? LineNo { get; set; }
+
+ /// <summary>
+ /// 浜у搧浠g爜
+ /// </summary>
+ [SugarColumn(ColumnName = "PROD_CODE")]
+ public string ProdCode { get; set; }
+
+ /// <summary>
+ /// 浜у搧鍚嶇О
+ /// </summary>
+ [SugarColumn(ColumnName = "PROD_NAME")]
+ public string ProdName { get; set; }
+
+ /// <summary>
+ /// 浜у搧瑙勬牸
+ /// </summary>
+ [SugarColumn(ColumnName = "PROD_SPEC")]
+ public string ProdSpec { get; set; }
+
+ /// <summary>
+ /// 閲戦
+ /// </summary>
+ [SugarColumn(ColumnName = "AMOUNT")]
+ public double? Amount { get; set; }
+
+ /// <summary>
+ /// 鍗曚环
+ /// </summary>
+ [SugarColumn(ColumnName = "UNIT_PRICE")]
+ public double? UnitPrice { get; set; }
+
+ /// <summary>
+ /// 鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "QUANTITY")]
+ public double? Quantity { get; set; }
+
+ /// <summary>
+ /// 鍑哄簱鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "OUT_QTY")]
+ public double? OutQty { get; set; }
+
+ /// <summary>
+ /// 鎵瑰彿
+ /// </summary>
+ [SugarColumn(ColumnName = "BATCH_NO")]
+ public string BatchNo { get; set; }
+
+ /// <summary>
+ /// 閫�璐ф暟閲�
+ /// </summary>
+ [SugarColumn(ColumnName = "RETURN_QTY")]
+ public double? ReturnQty { get; set; }
+
+ /// <summary>
+ /// 鍙戣揣鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "SHIP_QTY")]
+ public double? ShipQty { get; set; }
+
+ /// <summary>
+ /// 澶囨敞
+ /// </summary>
+ [SugarColumn(ColumnName = "REMARKS")]
+ public string Remarks { get; set; }
+
+ /// <summary>
+ /// 閿�鍞鍗曞崟鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "ORDER_NO")]
+ public string OrderNo { get; set; }
+
+ /// <summary>
+ /// 閿�鍞鍗曞垎褰�
+ /// </summary>
+ [SugarColumn(ColumnName = "ORDER_ENTRY")]
+ public string OrderEntry { get; set; }
+
+ /// <summary>
+ /// 閿�鍞鍗旾D
+ /// </summary>
+ [SugarColumn(ColumnName = "ORDER_ID")]
+ public string OrderId { get; set; }
+
+ /// <summary>
+ /// 鍩烘湰鍗曚环
+ /// </summary>
+ [SugarColumn(ColumnName = "BASE_PRICE")]
+ public double? BasePrice { get; set; }
+
+ /// <summary>
+ /// 鍩烘湰鍗曚綅鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "BASE_QTY")]
+ public double? BaseQty { get; set; }
+
+ /// <summary>
+ /// 浠撳簱浠g爜
+ /// </summary>
+ [SugarColumn(ColumnName = "WAREHOUSE_CODE")]
+ public string WarehouseCode { get; set; }
+
+ /// <summary>
+ /// 浠撳簱鍚嶇О
+ /// </summary>
+ [SugarColumn(ColumnName = "WAREHOUSE_NAME")]
+ public string WarehouseName { get; set; }
+
+ /// <summary>
+ /// 鍩烘湰鍗曚綅鍑哄簱鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "BASE_OUT_QTY")]
+ public double? BaseOutQty { get; set; }
+
+ /// <summary>
+ /// 鍗曚綅
+ /// </summary>
+ [SugarColumn(ColumnName = "UNIT")]
+ public string Unit { get; set; }
+}
\ No newline at end of file
diff --git a/MES.Service/Modes/ShipmentNotice.cs b/MES.Service/Modes/ShipmentNotice.cs
new file mode 100644
index 0000000..642a9ab
--- /dev/null
+++ b/MES.Service/Modes/ShipmentNotice.cs
@@ -0,0 +1,125 @@
+锘縰sing SqlSugar;
+
+namespace MES.Service.Modes;
+
+/// <summary>
+/// 閿�鍞彂璐ч�氱煡鍗曡〃
+/// </summary>
+[SugarTable("SHIPMENT_NOTICE")]
+public class ShipmentNotice
+{
+ /// <summary>
+ /// SEQ_sales
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_sales",
+ IsPrimaryKey = true)]
+ public decimal Id { get; set; }
+
+ /// <summary>
+ /// 鍒跺崟浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATOR")]
+ public string Creator { get; set; }
+
+ /// <summary>
+ /// 鍗曟嵁缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "DOC_ID")]
+ public string DocId { get; set; }
+
+ /// <summary>
+ /// 瀹℃牳浜哄悕绉�
+ /// </summary>
+ [SugarColumn(ColumnName = "APPROVER")]
+ public string Approver { get; set; }
+
+ /// <summary>
+ /// 鍒跺崟鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_DATE")]
+ public DateTime? CreateDate { get; set; }
+
+ /// <summary>
+ /// 瀹℃牳鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "APPROVE_DATE")]
+ public DateTime? ApproveDate { get; set; }
+
+ /// <summary>
+ /// 閮ㄩ棬浠g爜
+ /// </summary>
+ [SugarColumn(ColumnName = "DEPT_CODE")]
+ public string DeptCode { get; set; }
+
+ /// <summary>
+ /// 閮ㄩ棬鍚嶇О
+ /// </summary>
+ [SugarColumn(ColumnName = "DEPT_NAME")]
+ public string DeptName { get; set; }
+
+ /// <summary>
+ /// 璐揣鍗曚綅浠g爜
+ /// </summary>
+ [SugarColumn(ColumnName = "BUYER_CODE")]
+ public string BuyerCode { get; set; }
+
+ /// <summary>
+ /// 璐揣鍗曚綅鍚嶇О
+ /// </summary>
+ [SugarColumn(ColumnName = "BUYER_NAME")]
+ public string BuyerName { get; set; }
+
+ /// <summary>
+ /// 涓氬姟鍛樹唬鐮�
+ /// </summary>
+ [SugarColumn(ColumnName = "SALES_CODE")]
+ public string SalesCode { get; set; }
+
+ /// <summary>
+ /// 涓氬姟鍛樺悕绉�
+ /// </summary>
+ [SugarColumn(ColumnName = "SALES_NAME")]
+ public string SalesName { get; set; }
+
+ /// <summary>
+ /// 鍗曟嵁ID
+ /// </summary>
+ [SugarColumn(ColumnName = "UNIQUE_ID")]
+ public string UniqueId { get; set; }
+
+ /// <summary>
+ /// 瀹㈡埛浠g爜
+ /// </summary>
+ [SugarColumn(ColumnName = "CUST_CODE")]
+ public string CustCode { get; set; }
+
+ /// <summary>
+ /// 瀹㈡埛鍚嶇О
+ /// </summary>
+ [SugarColumn(ColumnName = "CUST_NAME")]
+ public string CustName { get; set; }
+
+ /// <summary>
+ /// 鍒楄〃澶囨敞
+ /// </summary>
+ [SugarColumn(ColumnName = "LIST_NOTE")]
+ public string ListNote { get; set; }
+
+ /// <summary>
+ /// 閿�鍞憳浠g爜
+ /// </summary>
+ [SugarColumn(ColumnName = "REP_CODE")]
+ public string RepCode { get; set; }
+
+ /// <summary>
+ /// 閿�鍞憳鍚嶇О
+ /// </summary>
+ [SugarColumn(ColumnName = "REP_NAME")]
+ public string RepName { get; set; }
+
+ /// <summary>
+ /// ERPID
+ /// </summary>
+ [SugarColumn(ColumnName = "ERP_ID")]
+ public string ErpId { get; set; }
+}
\ No newline at end of file
diff --git a/MES.Service/Modes/SysDepartment.cs b/MES.Service/Modes/SysDepartment.cs
index f80b5b1..f2b6669 100644
--- a/MES.Service/Modes/SysDepartment.cs
+++ b/MES.Service/Modes/SysDepartment.cs
@@ -23,7 +23,7 @@
/// <summary>
/// 閮ㄩ棬缂栧彿
/// </summary>
- [SugarColumn(ColumnName = "DEPARTMENTCODE", IsPrimaryKey = true)]
+ [SugarColumn(ColumnName = "DEPARTMENTCODE")]
public string? Departmentcode { get; set; }
/// <summary>
@@ -118,7 +118,7 @@
/// <summary>
/// </summary>
- [SugarColumn(ColumnName = "ID")]
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
public decimal Id { get; set; }
/// <summary>
diff --git a/MES.Service/bin/Debug/net8.0/MES.Service.dll b/MES.Service/bin/Debug/net8.0/MES.Service.dll
index 5890005..05385d8 100644
--- a/MES.Service/bin/Debug/net8.0/MES.Service.dll
+++ b/MES.Service/bin/Debug/net8.0/MES.Service.dll
Binary files differ
diff --git a/MES.Service/bin/Debug/net8.0/MES.Service.pdb b/MES.Service/bin/Debug/net8.0/MES.Service.pdb
index 004089e..83bd29f 100644
--- a/MES.Service/bin/Debug/net8.0/MES.Service.pdb
+++ b/MES.Service/bin/Debug/net8.0/MES.Service.pdb
Binary files differ
diff --git a/MES.Service/bin/Release/net8.0/MES.Service.dll b/MES.Service/bin/Release/net8.0/MES.Service.dll
index 5ef17a8..1e5925e 100644
--- a/MES.Service/bin/Release/net8.0/MES.Service.dll
+++ b/MES.Service/bin/Release/net8.0/MES.Service.dll
Binary files differ
diff --git a/MES.Service/bin/Release/net8.0/MES.Service.pdb b/MES.Service/bin/Release/net8.0/MES.Service.pdb
index 2edfdce..b92a605 100644
--- a/MES.Service/bin/Release/net8.0/MES.Service.pdb
+++ b/MES.Service/bin/Release/net8.0/MES.Service.pdb
Binary files differ
diff --git a/MES.Service/service/BasicData/MesRohInManager.cs b/MES.Service/service/BasicData/MesRohInManager.cs
index 32dbef1..5ad7b39 100644
--- a/MES.Service/service/BasicData/MesRohInManager.cs
+++ b/MES.Service/service/BasicData/MesRohInManager.cs
@@ -4,286 +4,244 @@
using MES.Service.util;
using SqlSugar;
-namespace MES.Service.service.BasicData;
-
-public class MesRohInManager : Repository<MesRohIn>
+namespace MES.Service.service.BasicData
{
- //褰撳墠绫诲凡缁忕户鎵夸簡 Repository 澧炪�佸垹銆佹煡銆佹敼鐨勬柟娉�
-
- private readonly MesRohInDataManager rohInDataManager = new();
-
- //杩欓噷闈㈠啓鐨勪唬鐮佷笉浼氱粰瑕嗙洊,濡傛灉瑕侀噸鏂扮敓鎴愯鍒犻櫎 MesRohInManager.cs
-
- public bool Save(RohIn rohIn)
+ public class MesRohInManager : Repository<MesRohIn>
{
- var rohInErpRohIn = rohIn.ErpRohIn;
- var mesRohIn = GetMesRohIn(rohInErpRohIn);
- var mesRohInDatas =
- GetMesRohInDatas(rohIn.ErpRohinDatas, rohInErpRohIn.Type);
- switch (rohInErpRohIn.Type)
+ private readonly MesRohInDataManager rohInDataManager = new();
+
+ // Save 鏂规硶鐢ㄤ簬淇濆瓨鍗曚釜 RohIn 璁板綍锛屾牴鎹被鍨嬫墽琛屼笉鍚岀殑鎿嶄綔
+ public bool Save(RohIn rohIn)
{
- case "1":
- var insert = base.Insert(mesRohIn);
- var insertRange = rohInDataManager.InsertRange(mesRohInDatas);
+ var rohInErpRohIn = rohIn.ErpRohIn;
+ var mesRohIn = GetMesRohIn(rohInErpRohIn);
+ var mesRohInDatas =
+ GetMesRohInDatas(rohIn.ErpRohinDatas, rohInErpRohIn.Type);
- if (insert && insertRange) return true;
- throw new NotImplementedException("鎻掑叆澶辫触");
- case "2":
- var update = base.Update(mesRohIn);
- var insertOrUpdate =
- rohInDataManager.InsertOrUpdate(mesRohInDatas);
-
- if (update && insertOrUpdate) return true;
- throw new NotImplementedException("鏇存柊澶辫触");
- case "4":
- var orUpdate = SaveOrUpdate(mesRohIn);
- var baOrUpdate =
- rohInDataManager.InsertOrUpdate(mesRohInDatas);
- if (orUpdate && baOrUpdate) return true;
- throw new NotImplementedException("鎻掑叆澶辫触");
- default:
- throw new NotImplementedException("type娌℃湁" +
- rohInErpRohIn.Type + "杩欎釜绫诲瀷");
- }
- }
-
- private bool SaveOrUpdate(MesRohIn mesRohIn)
- {
- var mesRohIns = base.GetList(it => it.EbelnK3id == mesRohIn.EbelnK3id);
-
- if (CollectionUtil.IsNullOrEmpty(mesRohIns))
- {
- return base.Insert(mesRohIn);
- }
-
- return base.Update(mesRohIn);
- }
-
- public bool SaveList(List<RohIn> rohIns)
- {
- var result = new List<bool>();
- rohIns.ForEach(s =>
- {
- var save = Save(s);
- result.Add(save);
- });
- return result.All(b => b);
- }
-
- public MesRohIn GetMesRohIn(ErpRohIn rohIn)
- {
- var eid = Convert.ToDecimal(rohIn.id);
- var mesRohIn = new MesRohIn();
- if (!"1".Equals(rohIn.Type))
- {
- var single = base.GetSingle(it => it.EbelnK3id == eid);
- if (single != null) mesRohIn.Id = single.Id;
- }
-
- mesRohIn.EbelnK3id = eid;
-
- mesRohIn.BillNo = rohIn.FBillNo;
- mesRohIn.DocumentStatus = rohIn.FDocumentStatus;
- mesRohIn.DocumentType = rohIn.FBillTypeID;
- mesRohIn.BusinessType = rohIn.FBusinessType;
-
- if (rohIn.FDate != null)
- mesRohIn.PurchaseDate = DateTime.ParseExact(
- rohIn.FDate, "yyyy-MM-dd HH:mm:ss", null);
-
- mesRohIn.Supplier = rohIn.FSupplierId;
- mesRohIn.CloseStatus = rohIn.FCloseStatus;
- mesRohIn.PurchaseOrg = rohIn.FPurchaseOrgId;
- mesRohIn.PurchaseDept = rohIn.FPurchaseDeptId;
- mesRohIn.PurchaseGroup = rohIn.FPurchaserGroupId;
- mesRohIn.QtyAcceptance = rohIn.Facctype;
- mesRohIn.Purchaser = rohIn.FPurchaserId;
- mesRohIn.QualityReq = rohIn.F_UNW_Remarks_zlyq;
- // mesRohIn.SupplierContact = rohIn.F_UNW_GYSLXR;
- // mesRohIn.ContactPhone = rohIn.F_UNW_LXRDH;
- // mesRohIn.Position = rohIn.FProviderJob;
- // mesRohIn.OfficePhone = rohIn.FProviderPhone;
- // mesRohIn.SupplierAddress = rohIn.FProviderAddress;
- mesRohIn.SettlementParty = rohIn.FSettleId;
- mesRohIn.PaymentParty = rohIn.FChargeId;
- mesRohIn.Email = rohIn.FProviderEMail;
- mesRohIn.TransportMethod = rohIn.F_UNW_Text_ysfs;
- mesRohIn.Remarks = rohIn.F_UNW_BZ;
- mesRohIn.FixtureMoldProcurement = rohIn.F_UNW_Combo_zjmj;
- mesRohIn.CancellationStatus = rohIn.FCancelStatus;
- mesRohIn.CancellationPerson = rohIn.FCancellerId;
- if (rohIn.FCancelDate != null)
- mesRohIn.CancellationDate = DateTime.ParseExact(
- rohIn.FCancelDate, "yyyy-MM-dd HH:mm:ss", null);
-
- mesRohIn.CreateBy = rohIn.FCreatorId;
-
- if (rohIn.FCreateDate != null)
- mesRohIn.CreateDate = DateTime.ParseExact(
- rohIn.FCreateDate, "yyyy-MM-dd HH:mm:ss", null);
-
- mesRohIn.LastupdateBy = rohIn.FModifierId;
-
- if (rohIn.FModifyDate != null)
- mesRohIn.LastupdateDate = DateTime.ParseExact(
- rohIn.FModifyDate, "yyyy-MM-dd HH:mm:ss", null);
-
- mesRohIn.ErpCheckBy = rohIn.FApproverId;
- mesRohIn.ErpCheckDate = rohIn.FApproveDate;
-
-
- return mesRohIn;
- }
-
- public List<MesRohInData> GetMesRohInDatas(List<ErpRohinData> ErpRohinDatas,
- string type)
- {
- var list = new List<MesRohInData>();
- ErpRohinDatas.ForEach(s =>
- {
- var entity = new MesRohInData();
-
- var eid = Convert.ToDecimal(s.id);
-
- if (!"1".Equals(type))
+ return UseTransaction(db =>
{
- var single =
- rohInDataManager.GetSingle(it => it.EbelnK3id == eid);
- if (single != null) entity.Id = single.Id;
+ switch (rohInErpRohIn.Type)
+ {
+ case "2":
+ return InsertData(db, mesRohIn, mesRohInDatas,
+ rohInErpRohIn.FBILLTYPE)
+ ? 1
+ : 0;
+ case "3":
+ return UpdateData(db, mesRohIn, mesRohInDatas) ? 1 : 0;
+ case "4":
+ return SaveOrUpdateData(db, mesRohIn, mesRohInDatas)
+ ? 1
+ : 0;
+ default:
+ throw new NotImplementedException(
+ $"type娌℃湁{rohInErpRohIn.Type}杩欎釜绫诲瀷");
+ }
+ }) > 0;
+ }
+
+ // 鎻掑叆鏁版嵁鐨勬柟娉�
+ private bool InsertData(SqlSugarScope db, MesRohIn mesRohIn,
+ List<MesRohInData> mesRohInDatas, string FBILLTYPE)
+ {
+ switch (FBILLTYPE)
+ {
+ case "A":
+ {
+ var insert = base.Insert(mesRohIn);
+ var insertRange =
+ rohInDataManager.InsertRange(mesRohInDatas);
+
+ if (insert && insertRange) return true;
+ throw new NotImplementedException("鎻掑叆澶辫触");
+ }
+ case "B":
+ {
+ var decimals = mesRohInDatas.Select(s => s.Id).ToArray();
+ if (base.DeleteById(mesRohIn.Id) && db
+ .Deleteable<MesRohInData>().In(decimals)
+ .ExecuteCommand() > 0)
+ {
+ var insert = base.Insert(mesRohIn);
+ var insertRange =
+ rohInDataManager.InsertRange(mesRohInDatas);
+
+ if (insert && insertRange) return true;
+ throw new NotImplementedException("鎻掑叆澶辫触");
+ }
+
+ break;
+ }
}
- entity.EbelnK3id = Convert.ToDecimal(s.id);
- entity.ErpId = Convert.ToDecimal(s.Eid);
+ throw new NotImplementedException("閲囪喘璁㈠崟绫诲瀷閿欒");
+ }
- entity.BillNo = s.FBillNo;
- entity.SalesOrderId = s.F_UNW_Text_xsddh;
- entity.ItemId = s.FMaterialId;
- entity.PurchaseUnit = s.FUnitId;
- entity.PurchaseQty = Convert.ToDecimal(s.FQty);
- entity.InventoryUnit = s.FStockUnitID;
- entity.PricingUnit = s.FPriceUnitId;
- entity.PricingQty = Convert.ToDecimal(s.FPriceUnitQty);
-
- if (s.FDeliveryDate != null)
- entity.DeliveryDate = DateTime.ParseExact(
- s.FDeliveryDate, "yyyy-MM-dd HH:mm:ss", null);
-
- if (s.FDeliveryEarlyDate != null)
- entity.EarliestDeliveryDate = DateTime.ParseExact(
- s.FDeliveryEarlyDate, "yyyy-MM-dd HH:mm:ss", null);
-
- if (s.FDeliveryLastDate != null)
- entity.LatestDeliveryDate = DateTime.ParseExact(
- s.FDeliveryLastDate, "yyyy-MM-dd HH:mm:ss", null);
-
- entity.IsGift = s.FGiveAway;
- entity.Remarks = s.FEntryNote;
- entity.SupplierItemCode = s.FSupMatId;
- entity.SupplierItemName = s.FSupMatName;
- entity.OutsourcingOrderId = s.FSUBREQBILLNO;
- entity.BatchNumber = s.FLot;
- entity.BusinessClose = s.FMRPCloseStatus;
- entity.BusinessFreeze = s.FMRPFreezeStatus;
- entity.Freezer = s.FFreezerId;
-
- if (s.FFreezeDate != null)
- entity.FreezeTime = DateTime.ParseExact(
- s.FFreezeDate, "yyyy-MM-dd HH:mm:ss", null);
-
- entity.BusinessTerminate = s.FMRPTerminateStatus;
- entity.Terminator = s.FTerminaterId;
-
- if (s.FTerminateDate != null)
- entity.TerminateTime = DateTime.ParseExact(
- s.FTerminateDate, "yyyy-MM-dd HH:mm:ss", null);
-
- entity.TotalReceivedQty = Convert.ToDecimal(s.FReceiveQty);
- entity.RemainingReceivedQty =
- Convert.ToDecimal(s.FRemainReceiveQty);
- entity.TotalStoredQty = Convert.ToDecimal(s.FStockInQty);
- entity.RemainingStoredQty = Convert.ToDecimal(s.FRemainStockINQty);
- entity.TotalReturnedQty = Convert.ToDecimal(s.FMrbQty);
- entity.ReturnableReceivedQty = Convert.ToDecimal(s.FCHECKRETQTY);
- entity.ReturnableStoredQty = Convert.ToDecimal(s.FSTOCKRETQTY);
- entity.SourceDocumentType = s.FSrcBillTypeId;
- entity.SourceDocumentId = s.FSrcBillNo;
- entity.DemandTrackingId = s.FReqTraceNo;
- entity.PlanTrackingId = s.FMtoNo;
- entity.ChangeFlag = s.FChangeFlag;
- entity.DemandSource = s.FDEMANDTYPE;
- entity.DemandDocumentId = s.FDEMANDBILLNO;
- entity.DemandDocumentLineId = s.FDEMANDBILLENTRYSEQ;
- entity.PurchaseOrderLineNumber = s.PurchaseOrderLineNumber;
- entity.Demand = s.Demand;
- entity.Receiving = s.Receiving;
- entity.Settlement = s.Settlement;
- list.Add(entity);
- });
- return list;
- }
-
- #region 鏁欏鏂规硶
-
- /// <summary>
- /// 浠撳偍鏂规硶婊¤冻涓嶄簡澶嶆潅涓氬姟闇�姹傦紝涓氬姟浠g爜璇峰湪杩欓噷闈㈠畾涔夋柟娉�
- /// </summary>
- public void Study()
- {
- /*********鏌ヨ*********/
-
- var data1 = base.GetById(1); //鏍规嵁ID鏌ヨ
- var data2 = base.GetList(); //鏌ヨ鎵�鏈�
- var data3 = base.GetList(it => 1 == 1); //鏍规嵁鏉′欢鏌ヨ
- //var data4 = base.GetSingle(it => 1 == 1);//鏍规嵁鏉′欢鏌ヨ涓�鏉�,濡傛灉瓒呰繃涓�鏉′細鎶ラ敊
-
- var p = new PageModel { PageIndex = 1, PageSize = 2 }; // 鍒嗛〉鏌ヨ
- var data5 = base.GetPageList(it => 1 == 1, p);
- Console.Write(p.TotalCount); //杩斿洖鎬绘暟
-
- var data6 =
- base.GetPageList(it => 1 == 1, p,
- it => SqlFunc.GetRandom()); // 鍒嗛〉鏌ヨ鍔犳帓搴�
- Console.Write(p.TotalCount); //杩斿洖鎬绘暟
-
- var conModels = new List<IConditionalModel>(); //缁勮鏉′欢鏌ヨ浣滀负鏉′欢瀹炵幇 鍒嗛〉鏌ヨ鍔犳帓搴�
- conModels.Add(new ConditionalModel
+ // 鏇存柊鏁版嵁鐨勬柟娉�
+ private bool UpdateData(SqlSugarScope db, MesRohIn mesRohIn,
+ List<MesRohInData> mesRohInDatas)
{
- FieldName = typeof(MesRohIn).GetProperties()[0].Name,
- ConditionalType = ConditionalType.Equal, FieldValue = "1"
- }); //id=1
- var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom());
+ var update = base.Insert(mesRohIn);
+ var insertOrUpdate = rohInDataManager.InsertRange(mesRohInDatas);
- AsQueryable().Where(x => 1 == 1)
- .ToList(); //鏀寔浜嗚浆鎹㈡垚queryable,鎴戜滑鍙互鐢╭ueryable瀹炵幇澶嶆潅鍔熻兘
+ if (update && insertOrUpdate) return true;
+ throw new NotImplementedException("鏇存柊澶辫触");
+ }
+ // 鎻掑叆鎴栨洿鏂版暟鎹殑鏂规硶
+ private bool SaveOrUpdateData(SqlSugarScope db, MesRohIn mesRohIn,
+ List<MesRohInData> mesRohInDatas)
+ {
+ var orUpdate = base.Insert(mesRohIn);
+ var baOrUpdate = rohInDataManager.InsertRange(mesRohInDatas);
+ if (orUpdate && baOrUpdate) return true;
+ throw new NotImplementedException("鎻掑叆鎴栨洿鏂板け璐�");
+ }
- /*********鎻掑叆*********/
- var insertData = new MesRohIn(); //娴嬭瘯鍙傛暟
- var insertArray = new[] { insertData };
- base.Insert(insertData); //鎻掑叆
- base.InsertRange(insertArray); //鎵归噺鎻掑叆
- var id = base.InsertReturnIdentity(insertData); //鎻掑叆杩斿洖鑷鍒�
- AsInsertable(insertData).ExecuteCommand(); //鎴戜滑鍙互杞垚 Insertable瀹炵幇澶嶆潅鎻掑叆
+ // 鎵归噺淇濆瓨璁板綍鐨勬柟娉�
+ public bool SaveList(List<RohIn> rohIns)
+ {
+ var result = rohIns.Select(Save).ToList();
+ return result.All(b => b);
+ }
+ // 灏� ErpRohIn 瀵硅薄杞崲涓� MesRohIn 瀵硅薄鐨勬柟娉�
+ public MesRohIn GetMesRohIn(ErpRohIn rohIn)
+ {
+ var eid = Convert.ToDecimal(rohIn.id);
+ var mesRohIn = new MesRohIn();
- /*********鏇存柊*********/
- var updateData = new MesRohIn(); //娴嬭瘯鍙傛暟
- var updateArray = new[] { updateData }; //娴嬭瘯鍙傛暟
- base.Update(updateData); //鏍规嵁瀹炰綋鏇存柊
- base.UpdateRange(updateArray); //鎵归噺鏇存柊
- //base.Update(it => new MesRohIn() { ClassName = "a", CreateTime = DateTime.Now }, it => it.id==1);// 鍙洿鏂癈lassName鍒楀拰CreateTime鍒楋紝鍏跺畠鍒椾笉鏇存柊锛屾潯浠秈d=1
- AsUpdateable(updateData).ExecuteCommand(); //杞垚Updateable鍙互瀹炵幇澶嶆潅鐨勬彃鍏�
+ var single = base.GetSingle(it => it.EbelnK3id == eid);
+ if (single != null) mesRohIn.Id = single.Id;
+ mesRohIn.EbelnK3id = eid;
+ mesRohIn.BillNo = rohIn.FBillNo;
+ mesRohIn.DocumentStatus = rohIn.FDocumentStatus;
+ mesRohIn.DocumentType = rohIn.FBillTypeID;
+ mesRohIn.BusinessType = rohIn.FBusinessType;
- /*********鍒犻櫎*********/
- var deldata = new MesRohIn(); //娴嬭瘯鍙傛暟
- base.Delete(deldata); //鏍规嵁瀹炰綋鍒犻櫎
- base.DeleteById(1); //鏍规嵁涓婚敭鍒犻櫎
- base.DeleteById(new[] { 1, 2 }); //鏍规嵁涓婚敭鏁扮粍鍒犻櫎
- base.Delete(it => 1 == 2); //鏍规嵁鏉′欢鍒犻櫎
- AsDeleteable().Where(it => 1 == 2)
- .ExecuteCommand(); //杞垚Deleteable瀹炵幇澶嶆潅鐨勬搷浣�
+ if (rohIn.FDate != null)
+ mesRohIn.PurchaseDate = DateTime.ParseExact(rohIn.FDate,
+ "yyyy-MM-dd HH:mm:ss", null);
+
+ mesRohIn.Supplier = rohIn.FSupplierId;
+ mesRohIn.CloseStatus = rohIn.FCloseStatus;
+ mesRohIn.PurchaseOrg = rohIn.FPurchaseOrgId;
+ mesRohIn.PurchaseDept = rohIn.FPurchaseDeptId;
+ mesRohIn.PurchaseGroup = rohIn.FPurchaserGroupId;
+ mesRohIn.QtyAcceptance = rohIn.Facctype;
+ mesRohIn.Purchaser = rohIn.FPurchaserId;
+ mesRohIn.QualityReq = rohIn.F_UNW_Remarks_zlyq;
+ mesRohIn.SettlementParty = rohIn.FSettleId;
+ mesRohIn.PaymentParty = rohIn.FChargeId;
+ mesRohIn.Email = rohIn.FProviderEMail;
+ mesRohIn.TransportMethod = rohIn.F_UNW_Text_ysfs;
+ mesRohIn.Remarks = rohIn.F_UNW_BZ;
+ mesRohIn.FixtureMoldProcurement = rohIn.F_UNW_Combo_zjmj;
+ mesRohIn.CancellationStatus = rohIn.FCancelStatus;
+ mesRohIn.CancellationPerson = rohIn.FCancellerId;
+
+ if (rohIn.FCancelDate != null)
+ mesRohIn.CancellationDate =
+ DateTime.ParseExact(rohIn.FCancelDate,
+ "yyyy-MM-dd HH:mm:ss", null);
+
+ mesRohIn.CreateBy = rohIn.FCreatorId;
+
+ if (rohIn.FCreateDate != null)
+ mesRohIn.CreateDate = DateTime.ParseExact(rohIn.FCreateDate,
+ "yyyy-MM-dd HH:mm:ss", null);
+
+ mesRohIn.LastupdateBy = rohIn.FModifierId;
+
+ if (rohIn.FModifyDate != null)
+ mesRohIn.LastupdateDate = DateTime.ParseExact(rohIn.FModifyDate,
+ "yyyy-MM-dd HH:mm:ss", null);
+
+ mesRohIn.ErpCheckBy = rohIn.FApproverId;
+ mesRohIn.ErpCheckDate = rohIn.FApproveDate;
+ mesRohIn.Changereason = rohIn.FCHANGEREASON;
+
+ return mesRohIn;
+ }
+
+ // 灏� ErpRohinData 瀵硅薄杞崲涓� MesRohInData 瀵硅薄鐨勬柟娉�
+ public List<MesRohInData> GetMesRohInDatas(
+ List<ErpRohinData> erpRohinDatas, string type)
+ {
+ return erpRohinDatas.Select(s =>
+ {
+ var entity = new MesRohInData
+ {
+ EbelnK3id = Convert.ToDecimal(s.id),
+ ErpId = Convert.ToDecimal(s.Eid),
+ BillNo = s.FBillNo,
+ SalesOrderId = s.F_UNW_Text_xsddh,
+ ItemId = s.FMaterialId,
+ PurchaseUnit = s.FUnitId,
+ PurchaseQty = Convert.ToDecimal(s.FQty),
+ InventoryUnit = s.FStockUnitID,
+ PricingUnit = s.FPriceUnitId,
+ PricingQty = Convert.ToDecimal(s.FPriceUnitQty),
+ DeliveryDate = s.FDeliveryDate != null
+ ? DateTime.ParseExact(s.FDeliveryDate,
+ "yyyy-MM-dd HH:mm:ss", null)
+ : null,
+ EarliestDeliveryDate = s.FDeliveryEarlyDate != null
+ ? DateTime.ParseExact(s.FDeliveryEarlyDate,
+ "yyyy-MM-dd HH:mm:ss", null)
+ : null,
+ LatestDeliveryDate = s.FDeliveryLastDate != null
+ ? DateTime.ParseExact(s.FDeliveryLastDate,
+ "yyyy-MM-dd HH:mm:ss", null)
+ : null,
+ IsGift = s.FGiveAway,
+ Remarks = s.FEntryNote,
+ SupplierItemCode = s.FSupMatId,
+ SupplierItemName = s.FSupMatName,
+ OutsourcingOrderId = s.FSUBREQBILLNO,
+ BatchNumber = s.FLot,
+ BusinessClose = s.FMRPCloseStatus,
+ BusinessFreeze = s.FMRPFreezeStatus,
+ Freezer = s.FFreezerId,
+ FreezeTime = s.FFreezeDate != null
+ ? DateTime.ParseExact(s.FFreezeDate,
+ "yyyy-MM-dd HH:mm:ss", null)
+ : null,
+ BusinessTerminate = s.FMRPTerminateStatus,
+ Terminator = s.FTerminaterId,
+ TerminateTime = s.FTerminateDate != null
+ ? DateTime.ParseExact(s.FTerminateDate,
+ "yyyy-MM-dd HH:mm:ss", null)
+ : null,
+ TotalReceivedQty = Convert.ToDecimal(s.FReceiveQty),
+ RemainingReceivedQty =
+ Convert.ToDecimal(s.FRemainReceiveQty),
+ TotalStoredQty = Convert.ToDecimal(s.FStockInQty),
+ RemainingStoredQty = Convert.ToDecimal(s.FRemainStockINQty),
+ TotalReturnedQty = Convert.ToDecimal(s.FMrbQty),
+ ReturnableReceivedQty = Convert.ToDecimal(s.FCHECKRETQTY),
+ ReturnableStoredQty = Convert.ToDecimal(s.FSTOCKRETQTY),
+ SourceDocumentType = s.FSrcBillTypeId,
+ SourceDocumentId = s.FSrcBillNo,
+ DemandTrackingId = s.FReqTraceNo,
+ PlanTrackingId = s.FMtoNo,
+ ChangeFlag = s.FChangeFlag,
+ DemandSource = s.FDEMANDTYPE,
+ DemandDocumentId = s.FDEMANDBILLNO,
+ DemandDocumentLineId = s.FDEMANDBILLENTRYSEQ,
+ PurchaseOrderLineNumber = s.PurchaseOrderLineNumber,
+ Demand = s.Demand,
+ Receiving = s.Receiving,
+ Settlement = s.Settlement
+ };
+
+ var single = rohInDataManager.GetSingle(it =>
+ it.EbelnK3id == entity.EbelnK3id);
+ if (single != null) entity.Id = single.Id;
+
+ return entity;
+ }).ToList();
+ }
}
-
- #endregion
}
\ No newline at end of file
diff --git a/MES.Service/service/BasicData/MesStaffManager.cs b/MES.Service/service/BasicData/MesStaffManager.cs
index 34eafdf..ec8ed98 100644
--- a/MES.Service/service/BasicData/MesStaffManager.cs
+++ b/MES.Service/service/BasicData/MesStaffManager.cs
@@ -64,7 +64,11 @@
var exists = db.Queryable<SysUser>().Any(u => u.Sid == sysUser.Sid);
if (exists)
{
- var updateUser = db.Updateable(sysUser).ExecuteCommand();
+ var updateUser = db.Updateable<SysUser>()
+ .SetColumns(s=>s.Fcode == sysUser.Fcode)
+ .SetColumns(s=>s.Fname == sysUser.Fname)
+ .Where(s=>s.Sid == sysUser.Sid)
+ .ExecuteCommand();
if (updateUser > 0)
{
var updateStaff = db.Updateable(entity).ExecuteCommand();
diff --git a/MES.Service/service/BasicData/MesSupplierManager.cs b/MES.Service/service/BasicData/MesSupplierManager.cs
index b2e5ac3..f64e2e9 100644
--- a/MES.Service/service/BasicData/MesSupplierManager.cs
+++ b/MES.Service/service/BasicData/MesSupplierManager.cs
@@ -28,7 +28,7 @@
return 1;
break;
case "3":
- if (DeleteSupplier(db, entity.Id))
+ if (DeleteSupplier(entity.Id))
return 1;
break;
case "4":
@@ -108,12 +108,9 @@
throw new NotImplementedException("鎻掑叆澶辫触");
}
- private bool DeleteSupplier(SqlSugarScope db, decimal supplierId)
+ private bool DeleteSupplier(decimal supplierId)
{
- var deleteById = db.Deleteable<MesSupplier>().In(supplierId)
- .ExecuteCommand();
- if (deleteById > 0)
- return true;
+ if (base.DeleteById(supplierId)) return true;
throw new NotImplementedException("鍒犻櫎澶辫触");
}
diff --git a/MES.Service/service/BasicData/SalesOrderDetailManager.cs b/MES.Service/service/BasicData/SalesOrderDetailManager.cs
new file mode 100644
index 0000000..d80f479
--- /dev/null
+++ b/MES.Service/service/BasicData/SalesOrderDetailManager.cs
@@ -0,0 +1,78 @@
+锘縰sing MES.Service.DB;
+using MES.Service.Modes;
+using SqlSugar;
+
+namespace MES.Service.service.BasicData;
+
+public class SalesOrderDetailManager : Repository<SalesOrderDetail>
+{
+ //褰撳墠绫诲凡缁忕户鎵夸簡 Repository 澧炪�佸垹銆佹煡銆佹敼鐨勬柟娉�
+
+ //杩欓噷闈㈠啓鐨勪唬鐮佷笉浼氱粰瑕嗙洊,濡傛灉瑕侀噸鏂扮敓鎴愯鍒犻櫎 SalesOrderDetailManager.cs
+
+
+ #region 鏁欏鏂规硶
+
+ /// <summary>
+ /// 浠撳偍鏂规硶婊¤冻涓嶄簡澶嶆潅涓氬姟闇�姹傦紝涓氬姟浠g爜璇峰湪杩欓噷闈㈠畾涔夋柟娉�
+ /// </summary>
+ public void Study()
+ {
+ /*********鏌ヨ*********/
+
+ var data1 = base.GetById(1); //鏍规嵁ID鏌ヨ
+ var data2 = base.GetList(); //鏌ヨ鎵�鏈�
+ var data3 = base.GetList(it => 1 == 1); //鏍规嵁鏉′欢鏌ヨ
+ //var data4 = base.GetSingle(it => 1 == 1);//鏍规嵁鏉′欢鏌ヨ涓�鏉�,濡傛灉瓒呰繃涓�鏉′細鎶ラ敊
+
+ var p = new PageModel { PageIndex = 1, PageSize = 2 }; // 鍒嗛〉鏌ヨ
+ var data5 = base.GetPageList(it => 1 == 1, p);
+ Console.Write(p.TotalCount); //杩斿洖鎬绘暟
+
+ var data6 =
+ base.GetPageList(it => 1 == 1, p,
+ it => SqlFunc.GetRandom()); // 鍒嗛〉鏌ヨ鍔犳帓搴�
+ Console.Write(p.TotalCount); //杩斿洖鎬绘暟
+
+ var conModels = new List<IConditionalModel>(); //缁勮鏉′欢鏌ヨ浣滀负鏉′欢瀹炵幇 鍒嗛〉鏌ヨ鍔犳帓搴�
+ conModels.Add(new ConditionalModel
+ {
+ FieldName = typeof(SalesOrderDetail).GetProperties()[0].Name,
+ ConditionalType = ConditionalType.Equal, FieldValue = "1"
+ }); //id=1
+ var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom());
+
+ AsQueryable().Where(x => 1 == 1)
+ .ToList(); //鏀寔浜嗚浆鎹㈡垚queryable,鎴戜滑鍙互鐢╭ueryable瀹炵幇澶嶆潅鍔熻兘
+
+
+ /*********鎻掑叆*********/
+ var insertData = new SalesOrderDetail(); //娴嬭瘯鍙傛暟
+ var insertArray = new[] { insertData };
+ base.Insert(insertData); //鎻掑叆
+ base.InsertRange(insertArray); //鎵归噺鎻掑叆
+ var id = base.InsertReturnIdentity(insertData); //鎻掑叆杩斿洖鑷鍒�
+ AsInsertable(insertData).ExecuteCommand(); //鎴戜滑鍙互杞垚 Insertable瀹炵幇澶嶆潅鎻掑叆
+
+
+ /*********鏇存柊*********/
+ var updateData = new SalesOrderDetail(); //娴嬭瘯鍙傛暟
+ var updateArray = new[] { updateData }; //娴嬭瘯鍙傛暟
+ base.Update(updateData); //鏍规嵁瀹炰綋鏇存柊
+ base.UpdateRange(updateArray); //鎵归噺鏇存柊
+ //base.Update(it => new SalesOrderDetail() { ClassName = "a", CreateTime = DateTime.Now }, it => it.id==1);// 鍙洿鏂癈lassName鍒楀拰CreateTime鍒楋紝鍏跺畠鍒椾笉鏇存柊锛屾潯浠秈d=1
+ AsUpdateable(updateData).ExecuteCommand(); //杞垚Updateable鍙互瀹炵幇澶嶆潅鐨勬彃鍏�
+
+
+ /*********鍒犻櫎*********/
+ var deldata = new SalesOrderDetail(); //娴嬭瘯鍙傛暟
+ base.Delete(deldata); //鏍规嵁瀹炰綋鍒犻櫎
+ base.DeleteById(1); //鏍规嵁涓婚敭鍒犻櫎
+ base.DeleteById(new[] { 1, 2 }); //鏍规嵁涓婚敭鏁扮粍鍒犻櫎
+ base.Delete(it => 1 == 2); //鏍规嵁鏉′欢鍒犻櫎
+ AsDeleteable().Where(it => 1 == 2)
+ .ExecuteCommand(); //杞垚Deleteable瀹炵幇澶嶆潅鐨勬搷浣�
+ }
+
+ #endregion
+}
\ No newline at end of file
diff --git a/MES.Service/service/BasicData/SalesOrderManager.cs b/MES.Service/service/BasicData/SalesOrderManager.cs
new file mode 100644
index 0000000..b466f00
--- /dev/null
+++ b/MES.Service/service/BasicData/SalesOrderManager.cs
@@ -0,0 +1,78 @@
+锘縰sing MES.Service.DB;
+using MES.Service.Modes;
+using SqlSugar;
+
+namespace MES.Service.service.BasicData;
+
+public class SalesOrderManager : Repository<SalesOrder>
+{
+ //褰撳墠绫诲凡缁忕户鎵夸簡 Repository 澧炪�佸垹銆佹煡銆佹敼鐨勬柟娉�
+
+ //杩欓噷闈㈠啓鐨勪唬鐮佷笉浼氱粰瑕嗙洊,濡傛灉瑕侀噸鏂扮敓鎴愯鍒犻櫎 SalesOrderManager.cs
+
+
+ #region 鏁欏鏂规硶
+
+ /// <summary>
+ /// 浠撳偍鏂规硶婊¤冻涓嶄簡澶嶆潅涓氬姟闇�姹傦紝涓氬姟浠g爜璇峰湪杩欓噷闈㈠畾涔夋柟娉�
+ /// </summary>
+ public void Study()
+ {
+ /*********鏌ヨ*********/
+
+ var data1 = base.GetById(1); //鏍规嵁ID鏌ヨ
+ var data2 = base.GetList(); //鏌ヨ鎵�鏈�
+ var data3 = base.GetList(it => 1 == 1); //鏍规嵁鏉′欢鏌ヨ
+ //var data4 = base.GetSingle(it => 1 == 1);//鏍规嵁鏉′欢鏌ヨ涓�鏉�,濡傛灉瓒呰繃涓�鏉′細鎶ラ敊
+
+ var p = new PageModel { PageIndex = 1, PageSize = 2 }; // 鍒嗛〉鏌ヨ
+ var data5 = base.GetPageList(it => 1 == 1, p);
+ Console.Write(p.TotalCount); //杩斿洖鎬绘暟
+
+ var data6 =
+ base.GetPageList(it => 1 == 1, p,
+ it => SqlFunc.GetRandom()); // 鍒嗛〉鏌ヨ鍔犳帓搴�
+ Console.Write(p.TotalCount); //杩斿洖鎬绘暟
+
+ var conModels = new List<IConditionalModel>(); //缁勮鏉′欢鏌ヨ浣滀负鏉′欢瀹炵幇 鍒嗛〉鏌ヨ鍔犳帓搴�
+ conModels.Add(new ConditionalModel
+ {
+ FieldName = typeof(SalesOrder).GetProperties()[0].Name,
+ ConditionalType = ConditionalType.Equal, FieldValue = "1"
+ }); //id=1
+ var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom());
+
+ AsQueryable().Where(x => 1 == 1)
+ .ToList(); //鏀寔浜嗚浆鎹㈡垚queryable,鎴戜滑鍙互鐢╭ueryable瀹炵幇澶嶆潅鍔熻兘
+
+
+ /*********鎻掑叆*********/
+ var insertData = new SalesOrder(); //娴嬭瘯鍙傛暟
+ var insertArray = new[] { insertData };
+ base.Insert(insertData); //鎻掑叆
+ base.InsertRange(insertArray); //鎵归噺鎻掑叆
+ var id = base.InsertReturnIdentity(insertData); //鎻掑叆杩斿洖鑷鍒�
+ AsInsertable(insertData).ExecuteCommand(); //鎴戜滑鍙互杞垚 Insertable瀹炵幇澶嶆潅鎻掑叆
+
+
+ /*********鏇存柊*********/
+ var updateData = new SalesOrder(); //娴嬭瘯鍙傛暟
+ var updateArray = new[] { updateData }; //娴嬭瘯鍙傛暟
+ base.Update(updateData); //鏍规嵁瀹炰綋鏇存柊
+ base.UpdateRange(updateArray); //鎵归噺鏇存柊
+ //base.Update(it => new SalesOrder() { ClassName = "a", CreateTime = DateTime.Now }, it => it.id==1);// 鍙洿鏂癈lassName鍒楀拰CreateTime鍒楋紝鍏跺畠鍒椾笉鏇存柊锛屾潯浠秈d=1
+ AsUpdateable(updateData).ExecuteCommand(); //杞垚Updateable鍙互瀹炵幇澶嶆潅鐨勬彃鍏�
+
+
+ /*********鍒犻櫎*********/
+ var deldata = new SalesOrder(); //娴嬭瘯鍙傛暟
+ base.Delete(deldata); //鏍规嵁瀹炰綋鍒犻櫎
+ base.DeleteById(1); //鏍规嵁涓婚敭鍒犻櫎
+ base.DeleteById(new[] { 1, 2 }); //鏍规嵁涓婚敭鏁扮粍鍒犻櫎
+ base.Delete(it => 1 == 2); //鏍规嵁鏉′欢鍒犻櫎
+ AsDeleteable().Where(it => 1 == 2)
+ .ExecuteCommand(); //杞垚Deleteable瀹炵幇澶嶆潅鐨勬搷浣�
+ }
+
+ #endregion
+}
\ No newline at end of file
diff --git a/MES.Service/service/BasicData/SalesReturnNoticeDetailManager.cs b/MES.Service/service/BasicData/SalesReturnNoticeDetailManager.cs
new file mode 100644
index 0000000..78d4c7b
--- /dev/null
+++ b/MES.Service/service/BasicData/SalesReturnNoticeDetailManager.cs
@@ -0,0 +1,79 @@
+锘縰sing MES.Service.DB;
+using MES.Service.Modes;
+using SqlSugar;
+
+namespace MES.Service.service.BasicData;
+
+public class
+ SalesReturnNoticeDetailManager : Repository<SalesReturnNoticeDetail>
+{
+ //褰撳墠绫诲凡缁忕户鎵夸簡 Repository 澧炪�佸垹銆佹煡銆佹敼鐨勬柟娉�
+
+ //杩欓噷闈㈠啓鐨勪唬鐮佷笉浼氱粰瑕嗙洊,濡傛灉瑕侀噸鏂扮敓鎴愯鍒犻櫎 SalesReturnNoticeDetailManager.cs
+
+
+ #region 鏁欏鏂规硶
+
+ /// <summary>
+ /// 浠撳偍鏂规硶婊¤冻涓嶄簡澶嶆潅涓氬姟闇�姹傦紝涓氬姟浠g爜璇峰湪杩欓噷闈㈠畾涔夋柟娉�
+ /// </summary>
+ public void Study()
+ {
+ /*********鏌ヨ*********/
+
+ var data1 = base.GetById(1); //鏍规嵁ID鏌ヨ
+ var data2 = base.GetList(); //鏌ヨ鎵�鏈�
+ var data3 = base.GetList(it => 1 == 1); //鏍规嵁鏉′欢鏌ヨ
+ //var data4 = base.GetSingle(it => 1 == 1);//鏍规嵁鏉′欢鏌ヨ涓�鏉�,濡傛灉瓒呰繃涓�鏉′細鎶ラ敊
+
+ var p = new PageModel { PageIndex = 1, PageSize = 2 }; // 鍒嗛〉鏌ヨ
+ var data5 = base.GetPageList(it => 1 == 1, p);
+ Console.Write(p.TotalCount); //杩斿洖鎬绘暟
+
+ var data6 =
+ base.GetPageList(it => 1 == 1, p,
+ it => SqlFunc.GetRandom()); // 鍒嗛〉鏌ヨ鍔犳帓搴�
+ Console.Write(p.TotalCount); //杩斿洖鎬绘暟
+
+ var conModels = new List<IConditionalModel>(); //缁勮鏉′欢鏌ヨ浣滀负鏉′欢瀹炵幇 鍒嗛〉鏌ヨ鍔犳帓搴�
+ conModels.Add(new ConditionalModel
+ {
+ FieldName = typeof(SalesReturnNoticeDetail).GetProperties()[0].Name,
+ ConditionalType = ConditionalType.Equal, FieldValue = "1"
+ }); //id=1
+ var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom());
+
+ AsQueryable().Where(x => 1 == 1)
+ .ToList(); //鏀寔浜嗚浆鎹㈡垚queryable,鎴戜滑鍙互鐢╭ueryable瀹炵幇澶嶆潅鍔熻兘
+
+
+ /*********鎻掑叆*********/
+ var insertData = new SalesReturnNoticeDetail(); //娴嬭瘯鍙傛暟
+ var insertArray = new[] { insertData };
+ base.Insert(insertData); //鎻掑叆
+ base.InsertRange(insertArray); //鎵归噺鎻掑叆
+ var id = base.InsertReturnIdentity(insertData); //鎻掑叆杩斿洖鑷鍒�
+ AsInsertable(insertData).ExecuteCommand(); //鎴戜滑鍙互杞垚 Insertable瀹炵幇澶嶆潅鎻掑叆
+
+
+ /*********鏇存柊*********/
+ var updateData = new SalesReturnNoticeDetail(); //娴嬭瘯鍙傛暟
+ var updateArray = new[] { updateData }; //娴嬭瘯鍙傛暟
+ base.Update(updateData); //鏍规嵁瀹炰綋鏇存柊
+ base.UpdateRange(updateArray); //鎵归噺鏇存柊
+ //base.Update(it => new SalesReturnNoticeDetail() { ClassName = "a", CreateTime = DateTime.Now }, it => it.id==1);// 鍙洿鏂癈lassName鍒楀拰CreateTime鍒楋紝鍏跺畠鍒椾笉鏇存柊锛屾潯浠秈d=1
+ AsUpdateable(updateData).ExecuteCommand(); //杞垚Updateable鍙互瀹炵幇澶嶆潅鐨勬彃鍏�
+
+
+ /*********鍒犻櫎*********/
+ var deldata = new SalesReturnNoticeDetail(); //娴嬭瘯鍙傛暟
+ base.Delete(deldata); //鏍规嵁瀹炰綋鍒犻櫎
+ base.DeleteById(1); //鏍规嵁涓婚敭鍒犻櫎
+ base.DeleteById(new[] { 1, 2 }); //鏍规嵁涓婚敭鏁扮粍鍒犻櫎
+ base.Delete(it => 1 == 2); //鏍规嵁鏉′欢鍒犻櫎
+ AsDeleteable().Where(it => 1 == 2)
+ .ExecuteCommand(); //杞垚Deleteable瀹炵幇澶嶆潅鐨勬搷浣�
+ }
+
+ #endregion
+}
\ No newline at end of file
diff --git a/MES.Service/service/BasicData/SalesReturnNoticeManager.cs b/MES.Service/service/BasicData/SalesReturnNoticeManager.cs
new file mode 100644
index 0000000..206f0ea
--- /dev/null
+++ b/MES.Service/service/BasicData/SalesReturnNoticeManager.cs
@@ -0,0 +1,78 @@
+锘縰sing MES.Service.DB;
+using MES.Service.Modes;
+using SqlSugar;
+
+namespace MES.Service.service.BasicData;
+
+public class SalesReturnNoticeManager : Repository<SalesReturnNotice>
+{
+ //褰撳墠绫诲凡缁忕户鎵夸簡 Repository 澧炪�佸垹銆佹煡銆佹敼鐨勬柟娉�
+
+ //杩欓噷闈㈠啓鐨勪唬鐮佷笉浼氱粰瑕嗙洊,濡傛灉瑕侀噸鏂扮敓鎴愯鍒犻櫎 SalesReturnNoticeManager.cs
+
+
+ #region 鏁欏鏂规硶
+
+ /// <summary>
+ /// 浠撳偍鏂规硶婊¤冻涓嶄簡澶嶆潅涓氬姟闇�姹傦紝涓氬姟浠g爜璇峰湪杩欓噷闈㈠畾涔夋柟娉�
+ /// </summary>
+ public void Study()
+ {
+ /*********鏌ヨ*********/
+
+ var data1 = base.GetById(1); //鏍规嵁ID鏌ヨ
+ var data2 = base.GetList(); //鏌ヨ鎵�鏈�
+ var data3 = base.GetList(it => 1 == 1); //鏍规嵁鏉′欢鏌ヨ
+ //var data4 = base.GetSingle(it => 1 == 1);//鏍规嵁鏉′欢鏌ヨ涓�鏉�,濡傛灉瓒呰繃涓�鏉′細鎶ラ敊
+
+ var p = new PageModel { PageIndex = 1, PageSize = 2 }; // 鍒嗛〉鏌ヨ
+ var data5 = base.GetPageList(it => 1 == 1, p);
+ Console.Write(p.TotalCount); //杩斿洖鎬绘暟
+
+ var data6 =
+ base.GetPageList(it => 1 == 1, p,
+ it => SqlFunc.GetRandom()); // 鍒嗛〉鏌ヨ鍔犳帓搴�
+ Console.Write(p.TotalCount); //杩斿洖鎬绘暟
+
+ var conModels = new List<IConditionalModel>(); //缁勮鏉′欢鏌ヨ浣滀负鏉′欢瀹炵幇 鍒嗛〉鏌ヨ鍔犳帓搴�
+ conModels.Add(new ConditionalModel
+ {
+ FieldName = typeof(SalesReturnNotice).GetProperties()[0].Name,
+ ConditionalType = ConditionalType.Equal, FieldValue = "1"
+ }); //id=1
+ var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom());
+
+ AsQueryable().Where(x => 1 == 1)
+ .ToList(); //鏀寔浜嗚浆鎹㈡垚queryable,鎴戜滑鍙互鐢╭ueryable瀹炵幇澶嶆潅鍔熻兘
+
+
+ /*********鎻掑叆*********/
+ var insertData = new SalesReturnNotice(); //娴嬭瘯鍙傛暟
+ var insertArray = new[] { insertData };
+ base.Insert(insertData); //鎻掑叆
+ base.InsertRange(insertArray); //鎵归噺鎻掑叆
+ var id = base.InsertReturnIdentity(insertData); //鎻掑叆杩斿洖鑷鍒�
+ AsInsertable(insertData).ExecuteCommand(); //鎴戜滑鍙互杞垚 Insertable瀹炵幇澶嶆潅鎻掑叆
+
+
+ /*********鏇存柊*********/
+ var updateData = new SalesReturnNotice(); //娴嬭瘯鍙傛暟
+ var updateArray = new[] { updateData }; //娴嬭瘯鍙傛暟
+ base.Update(updateData); //鏍规嵁瀹炰綋鏇存柊
+ base.UpdateRange(updateArray); //鎵归噺鏇存柊
+ //base.Update(it => new SalesReturnNotice() { ClassName = "a", CreateTime = DateTime.Now }, it => it.id==1);// 鍙洿鏂癈lassName鍒楀拰CreateTime鍒楋紝鍏跺畠鍒椾笉鏇存柊锛屾潯浠秈d=1
+ AsUpdateable(updateData).ExecuteCommand(); //杞垚Updateable鍙互瀹炵幇澶嶆潅鐨勬彃鍏�
+
+
+ /*********鍒犻櫎*********/
+ var deldata = new SalesReturnNotice(); //娴嬭瘯鍙傛暟
+ base.Delete(deldata); //鏍规嵁瀹炰綋鍒犻櫎
+ base.DeleteById(1); //鏍规嵁涓婚敭鍒犻櫎
+ base.DeleteById(new[] { 1, 2 }); //鏍规嵁涓婚敭鏁扮粍鍒犻櫎
+ base.Delete(it => 1 == 2); //鏍规嵁鏉′欢鍒犻櫎
+ AsDeleteable().Where(it => 1 == 2)
+ .ExecuteCommand(); //杞垚Deleteable瀹炵幇澶嶆潅鐨勬搷浣�
+ }
+
+ #endregion
+}
\ No newline at end of file
diff --git a/MES.Service/service/BasicData/ShipmentDetailManager.cs b/MES.Service/service/BasicData/ShipmentDetailManager.cs
new file mode 100644
index 0000000..67c9435
--- /dev/null
+++ b/MES.Service/service/BasicData/ShipmentDetailManager.cs
@@ -0,0 +1,78 @@
+锘縰sing MES.Service.DB;
+using MES.Service.Modes;
+using SqlSugar;
+
+namespace MES.Service.service.BasicData;
+
+public class ShipmentDetailManager : Repository<ShipmentDetail>
+{
+ //褰撳墠绫诲凡缁忕户鎵夸簡 Repository 澧炪�佸垹銆佹煡銆佹敼鐨勬柟娉�
+
+ //杩欓噷闈㈠啓鐨勪唬鐮佷笉浼氱粰瑕嗙洊,濡傛灉瑕侀噸鏂扮敓鎴愯鍒犻櫎 ShipmentDetailManager.cs
+
+
+ #region 鏁欏鏂规硶
+
+ /// <summary>
+ /// 浠撳偍鏂规硶婊¤冻涓嶄簡澶嶆潅涓氬姟闇�姹傦紝涓氬姟浠g爜璇峰湪杩欓噷闈㈠畾涔夋柟娉�
+ /// </summary>
+ public void Study()
+ {
+ /*********鏌ヨ*********/
+
+ var data1 = base.GetById(1); //鏍规嵁ID鏌ヨ
+ var data2 = base.GetList(); //鏌ヨ鎵�鏈�
+ var data3 = base.GetList(it => 1 == 1); //鏍规嵁鏉′欢鏌ヨ
+ //var data4 = base.GetSingle(it => 1 == 1);//鏍规嵁鏉′欢鏌ヨ涓�鏉�,濡傛灉瓒呰繃涓�鏉′細鎶ラ敊
+
+ var p = new PageModel { PageIndex = 1, PageSize = 2 }; // 鍒嗛〉鏌ヨ
+ var data5 = base.GetPageList(it => 1 == 1, p);
+ Console.Write(p.TotalCount); //杩斿洖鎬绘暟
+
+ var data6 =
+ base.GetPageList(it => 1 == 1, p,
+ it => SqlFunc.GetRandom()); // 鍒嗛〉鏌ヨ鍔犳帓搴�
+ Console.Write(p.TotalCount); //杩斿洖鎬绘暟
+
+ var conModels = new List<IConditionalModel>(); //缁勮鏉′欢鏌ヨ浣滀负鏉′欢瀹炵幇 鍒嗛〉鏌ヨ鍔犳帓搴�
+ conModels.Add(new ConditionalModel
+ {
+ FieldName = typeof(ShipmentDetail).GetProperties()[0].Name,
+ ConditionalType = ConditionalType.Equal, FieldValue = "1"
+ }); //id=1
+ var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom());
+
+ AsQueryable().Where(x => 1 == 1)
+ .ToList(); //鏀寔浜嗚浆鎹㈡垚queryable,鎴戜滑鍙互鐢╭ueryable瀹炵幇澶嶆潅鍔熻兘
+
+
+ /*********鎻掑叆*********/
+ var insertData = new ShipmentDetail(); //娴嬭瘯鍙傛暟
+ var insertArray = new[] { insertData };
+ base.Insert(insertData); //鎻掑叆
+ base.InsertRange(insertArray); //鎵归噺鎻掑叆
+ var id = base.InsertReturnIdentity(insertData); //鎻掑叆杩斿洖鑷鍒�
+ AsInsertable(insertData).ExecuteCommand(); //鎴戜滑鍙互杞垚 Insertable瀹炵幇澶嶆潅鎻掑叆
+
+
+ /*********鏇存柊*********/
+ var updateData = new ShipmentDetail(); //娴嬭瘯鍙傛暟
+ var updateArray = new[] { updateData }; //娴嬭瘯鍙傛暟
+ base.Update(updateData); //鏍规嵁瀹炰綋鏇存柊
+ base.UpdateRange(updateArray); //鎵归噺鏇存柊
+ //base.Update(it => new ShipmentDetail() { ClassName = "a", CreateTime = DateTime.Now }, it => it.id==1);// 鍙洿鏂癈lassName鍒楀拰CreateTime鍒楋紝鍏跺畠鍒椾笉鏇存柊锛屾潯浠秈d=1
+ AsUpdateable(updateData).ExecuteCommand(); //杞垚Updateable鍙互瀹炵幇澶嶆潅鐨勬彃鍏�
+
+
+ /*********鍒犻櫎*********/
+ var deldata = new ShipmentDetail(); //娴嬭瘯鍙傛暟
+ base.Delete(deldata); //鏍规嵁瀹炰綋鍒犻櫎
+ base.DeleteById(1); //鏍规嵁涓婚敭鍒犻櫎
+ base.DeleteById(new[] { 1, 2 }); //鏍规嵁涓婚敭鏁扮粍鍒犻櫎
+ base.Delete(it => 1 == 2); //鏍规嵁鏉′欢鍒犻櫎
+ AsDeleteable().Where(it => 1 == 2)
+ .ExecuteCommand(); //杞垚Deleteable瀹炵幇澶嶆潅鐨勬搷浣�
+ }
+
+ #endregion
+}
\ No newline at end of file
diff --git a/MES.Service/service/BasicData/ShipmentNoticeManager.cs b/MES.Service/service/BasicData/ShipmentNoticeManager.cs
new file mode 100644
index 0000000..c116032
--- /dev/null
+++ b/MES.Service/service/BasicData/ShipmentNoticeManager.cs
@@ -0,0 +1,75 @@
+锘縰sing MES.Service.DB;
+using MES.Service.Dto.webApi;
+using MES.Service.Modes;
+using SqlSugar;
+
+namespace MES.Service.service.BasicData;
+
+public class ShipmentNoticeManager : Repository<ShipmentNotice>
+{
+ private readonly ShipmentDetailManager shipmentDetailManager = new();
+
+ //褰撳墠绫诲凡缁忕户鎵夸簡 Repository 澧炪�佸垹銆佹煡銆佹敼鐨勬柟娉�
+ public bool Save(ErpShipment shipment)
+ {
+ var shipmentNotice = GetShipmentNotice(shipment.ShipmentNotice);
+
+ var shipmentDetails = GetShipmentDetails(shipment.ShipmentDetails);
+
+ return false;
+ }
+
+ private ShipmentNotice GetShipmentNotice(ErpShipmentNotice notice)
+ {
+ ShipmentNotice entity = new ShipmentNotice();
+
+ entity.Creator = notice.FCreatorId;
+ entity.DocId = notice.FBillNo;
+ entity.Approver = notice.FApproverID;
+
+ if (notice.FCreateDate != null)
+ {
+ entity.CreateDate = DateTime.ParseExact(notice.FCreateDate,
+ "yyyy-MM-dd HH:mm:ss", null);
+ }
+
+ if (notice.FApproveDate != null)
+ {
+ entity.ApproveDate = DateTime.ParseExact(notice.FApproveDate,
+ "yyyy-MM-dd HH:mm:ss", null);
+ }
+
+ entity.DeptCode = notice.FSaleDeptId;
+ entity.CustCode = notice.FCustomerID;
+ entity.ListNote = notice.FNote;
+ entity.RepCode = notice.FSalesManID;
+
+ return entity;
+ }
+
+ private List<ShipmentDetail> GetShipmentDetails(
+ List<ErpShipmentDetail> shipmentDetails)
+ {
+ return shipmentDetails.Select(s =>
+ {
+ var entity = new ShipmentDetail
+ {
+ ErpId = s.ErpId,
+ ErpHeadId = s.ErpHeadId,
+ ProdCode = s.FMaterialID,
+ ProdName = s.FMaterialName,
+ Amount = Convert.ToDouble(s.FAmount),
+ UnitPrice = Convert.ToDouble(s.FPrice),
+ Quantity = Convert.ToDouble(s.FQty),
+ BatchNo = s.FLot,
+ Remarks = s.FNoteEntry,
+ OrderNo = s.F_UNW_Text_xsddh,
+ OrderId = s.FSOEntryId,
+ BasePrice = Convert.ToDouble(s.FPrice),
+ WarehouseCode = s.FStockID,
+ Unit = s.FBaseUnitID
+ };
+ return entity;
+ }).ToList();
+ }
+}
\ No newline at end of file
diff --git a/MESApplication/Controllers/BaseController.cs b/MESApplication/Controllers/BaseController.cs
index d6e161b..22ea012 100644
--- a/MESApplication/Controllers/BaseController.cs
+++ b/MESApplication/Controllers/BaseController.cs
@@ -1,6 +1,5 @@
锘縰sing System.Dynamic;
using MES.Service.Dto.service;
-using MES.Service.service;
using MES.Service.service.QC;
using MES.Service.util;
using Microsoft.AspNetCore.Mvc;
diff --git a/MESApplication/Controllers/BasicData/SalesOrderController.cs b/MESApplication/Controllers/BasicData/SalesOrderController.cs
new file mode 100644
index 0000000..74cc41f
--- /dev/null
+++ b/MESApplication/Controllers/BasicData/SalesOrderController.cs
@@ -0,0 +1,162 @@
+锘縰sing System.Dynamic;
+using MES.Service.Modes;
+using MES.Service.service.BasicData;
+using MES.Service.util;
+using Microsoft.AspNetCore.Mvc;
+
+namespace MESApplication.Controllers.BasicData;
+
+[ApiController]
+[Route("api/[controller]")]
+public class SalesOrderController : ControllerBase
+{
+ private readonly SalesOrderManager m = new();
+
+
+ /***杩涘叆妯$増绠$悊鍙互淇敼妯$増***/
+
+ /// <summary>
+ /// 鑾峰彇鎵�鏈�
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("GetList")]
+ public ResponseResult GetList()
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.GetList();
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+
+ /// <summary>
+ /// 鏍规嵁涓婚敭鑾峰彇
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("GetById")]
+ public ResponseResult GetById(int id)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.GetById(id);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ /// <summary>
+ /// 鏍规嵁涓婚敭鍒犻櫎
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("DeleteByIds")]
+ public ResponseResult DeleteByIds([FromBody] object[] ids)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.DeleteByIds(ids);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ /// <summary>
+ /// 娣诲姞
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("Insert")]
+ public ResponseResult Add([FromBody] SalesOrder data)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.Insert(data);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ /// <summary>
+ /// 娣诲姞杩斿洖鑷
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("InsertReturnIdentity")]
+ public ResponseResult InsertReturnIdentity([FromBody] SalesOrder data)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.InsertReturnIdentity(data);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ /// <summary>
+ /// 淇敼
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("Update")]
+ public ResponseResult Update([FromBody] SalesOrder data)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.Update(data);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+}
\ No newline at end of file
diff --git a/MESApplication/Controllers/BasicData/SalesOrderDetailController.cs b/MESApplication/Controllers/BasicData/SalesOrderDetailController.cs
new file mode 100644
index 0000000..ad304ba
--- /dev/null
+++ b/MESApplication/Controllers/BasicData/SalesOrderDetailController.cs
@@ -0,0 +1,162 @@
+锘縰sing System.Dynamic;
+using MES.Service.Modes;
+using MES.Service.service.BasicData;
+using MES.Service.util;
+using Microsoft.AspNetCore.Mvc;
+
+namespace MESApplication.Controllers.BasicData;
+
+[ApiController]
+[Route("api/[controller]")]
+public class SalesOrderDetailController : ControllerBase
+{
+ private SalesOrderDetailManager m = new SalesOrderDetailManager();
+
+
+ /***杩涘叆妯$増绠$悊鍙互淇敼妯$増***/
+
+ /// <summary>
+ /// 鑾峰彇鎵�鏈�
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("GetList")]
+ public ResponseResult GetList()
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.GetList();
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+
+ /// <summary>
+ /// 鏍规嵁涓婚敭鑾峰彇
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("GetById")]
+ public ResponseResult GetById(int id)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.GetById(id);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ /// <summary>
+ /// 鏍规嵁涓婚敭鍒犻櫎
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("DeleteByIds")]
+ public ResponseResult DeleteByIds([FromBody] object[] ids)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.DeleteByIds(ids);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ /// <summary>
+ /// 娣诲姞
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("Insert")]
+ public ResponseResult Add([FromBody] SalesOrderDetail data)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.Insert(data);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ /// <summary>
+ /// 娣诲姞杩斿洖鑷
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("InsertReturnIdentity")]
+ public ResponseResult InsertReturnIdentity([FromBody] SalesOrderDetail data)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.InsertReturnIdentity(data);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ /// <summary>
+ /// 淇敼
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("Update")]
+ public ResponseResult Update([FromBody] SalesOrderDetail data)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.Update(data);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+}
\ No newline at end of file
diff --git a/MESApplication/Controllers/BasicData/SalesReturnNoticeController.cs b/MESApplication/Controllers/BasicData/SalesReturnNoticeController.cs
new file mode 100644
index 0000000..ba82e5d
--- /dev/null
+++ b/MESApplication/Controllers/BasicData/SalesReturnNoticeController.cs
@@ -0,0 +1,163 @@
+锘縰sing System.Dynamic;
+using MES.Service.Modes;
+using MES.Service.service.BasicData;
+using MES.Service.util;
+using Microsoft.AspNetCore.Mvc;
+
+namespace MESApplication.Controllers.BasicData;
+
+[ApiController]
+[Route("api/[controller]")]
+public class SalesReturnNoticeController : ControllerBase
+{
+ private SalesReturnNoticeManager m = new SalesReturnNoticeManager();
+
+
+ /***杩涘叆妯$増绠$悊鍙互淇敼妯$増***/
+
+ /// <summary>
+ /// 鑾峰彇鎵�鏈�
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("GetList")]
+ public ResponseResult GetList()
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.GetList();
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+
+ /// <summary>
+ /// 鏍规嵁涓婚敭鑾峰彇
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("GetById")]
+ public ResponseResult GetById(int id)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.GetById(id);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ /// <summary>
+ /// 鏍规嵁涓婚敭鍒犻櫎
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("DeleteByIds")]
+ public ResponseResult DeleteByIds([FromBody] object[] ids)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.DeleteByIds(ids);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ /// <summary>
+ /// 娣诲姞
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("Insert")]
+ public ResponseResult Add([FromBody] SalesReturnNotice data)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.Insert(data);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ /// <summary>
+ /// 娣诲姞杩斿洖鑷
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("InsertReturnIdentity")]
+ public ResponseResult InsertReturnIdentity(
+ [FromBody] SalesReturnNotice data)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.InsertReturnIdentity(data);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ /// <summary>
+ /// 淇敼
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("Update")]
+ public ResponseResult Update([FromBody] SalesReturnNotice data)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.Update(data);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+}
\ No newline at end of file
diff --git a/MESApplication/Controllers/BasicData/SalesReturnNoticeDetailController.cs b/MESApplication/Controllers/BasicData/SalesReturnNoticeDetailController.cs
new file mode 100644
index 0000000..4e8286f
--- /dev/null
+++ b/MESApplication/Controllers/BasicData/SalesReturnNoticeDetailController.cs
@@ -0,0 +1,164 @@
+锘縰sing System.Dynamic;
+using MES.Service.Modes;
+using MES.Service.service.BasicData;
+using MES.Service.util;
+using Microsoft.AspNetCore.Mvc;
+
+namespace MESApplication.Controllers.BasicData;
+
+[ApiController]
+[Route("api/[controller]")]
+public class SalesReturnNoticeDetailController : ControllerBase
+{
+ private SalesReturnNoticeDetailManager m =
+ new SalesReturnNoticeDetailManager();
+
+
+ /***杩涘叆妯$増绠$悊鍙互淇敼妯$増***/
+
+ /// <summary>
+ /// 鑾峰彇鎵�鏈�
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("GetList")]
+ public ResponseResult GetList()
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.GetList();
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+
+ /// <summary>
+ /// 鏍规嵁涓婚敭鑾峰彇
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("GetById")]
+ public ResponseResult GetById(int id)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.GetById(id);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ /// <summary>
+ /// 鏍规嵁涓婚敭鍒犻櫎
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("DeleteByIds")]
+ public ResponseResult DeleteByIds([FromBody] object[] ids)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.DeleteByIds(ids);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ /// <summary>
+ /// 娣诲姞
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("Insert")]
+ public ResponseResult Add([FromBody] SalesReturnNoticeDetail data)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.Insert(data);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ /// <summary>
+ /// 娣诲姞杩斿洖鑷
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("InsertReturnIdentity")]
+ public ResponseResult InsertReturnIdentity(
+ [FromBody] SalesReturnNoticeDetail data)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.InsertReturnIdentity(data);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ /// <summary>
+ /// 淇敼
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("Update")]
+ public ResponseResult Update([FromBody] SalesReturnNoticeDetail data)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.Update(data);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+}
\ No newline at end of file
diff --git a/MESApplication/Controllers/BasicData/ShipmentDetailController.cs b/MESApplication/Controllers/BasicData/ShipmentDetailController.cs
new file mode 100644
index 0000000..2a08400
--- /dev/null
+++ b/MESApplication/Controllers/BasicData/ShipmentDetailController.cs
@@ -0,0 +1,162 @@
+锘縰sing System.Dynamic;
+using MES.Service.Modes;
+using MES.Service.service.BasicData;
+using MES.Service.util;
+using Microsoft.AspNetCore.Mvc;
+
+namespace MESApplication.Controllers.BasicData;
+
+[ApiController]
+[Route("api/[controller]")]
+public class ShipmentDetailController : ControllerBase
+{
+ private ShipmentDetailManager m = new ShipmentDetailManager();
+
+
+ /***杩涘叆妯$増绠$悊鍙互淇敼妯$増***/
+
+ /// <summary>
+ /// 鑾峰彇鎵�鏈�
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("GetList")]
+ public ResponseResult GetList()
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.GetList();
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+
+ /// <summary>
+ /// 鏍规嵁涓婚敭鑾峰彇
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("GetById")]
+ public ResponseResult GetById(int id)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.GetById(id);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ /// <summary>
+ /// 鏍规嵁涓婚敭鍒犻櫎
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("DeleteByIds")]
+ public ResponseResult DeleteByIds([FromBody] object[] ids)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.DeleteByIds(ids);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ /// <summary>
+ /// 娣诲姞
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("Insert")]
+ public ResponseResult Add([FromBody] ShipmentDetail data)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.Insert(data);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ /// <summary>
+ /// 娣诲姞杩斿洖鑷
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("InsertReturnIdentity")]
+ public ResponseResult InsertReturnIdentity([FromBody] ShipmentDetail data)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.InsertReturnIdentity(data);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ /// <summary>
+ /// 淇敼
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("Update")]
+ public ResponseResult Update([FromBody] ShipmentDetail data)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.Update(data);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+}
\ No newline at end of file
diff --git a/MESApplication/Controllers/BasicData/ShipmentNoticeController.cs b/MESApplication/Controllers/BasicData/ShipmentNoticeController.cs
new file mode 100644
index 0000000..099ca48
--- /dev/null
+++ b/MESApplication/Controllers/BasicData/ShipmentNoticeController.cs
@@ -0,0 +1,162 @@
+锘縰sing System.Dynamic;
+using MES.Service.Modes;
+using MES.Service.service.BasicData;
+using MES.Service.util;
+using Microsoft.AspNetCore.Mvc;
+
+namespace MESApplication.Controllers.BasicData;
+
+[ApiController]
+[Route("api/[controller]")]
+public class ShipmentNoticeController : ControllerBase
+{
+ private ShipmentNoticeManager m = new ShipmentNoticeManager();
+
+
+ /***杩涘叆妯$増绠$悊鍙互淇敼妯$増***/
+
+ /// <summary>
+ /// 鑾峰彇鎵�鏈�
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("GetList")]
+ public ResponseResult GetList()
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.GetList();
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+
+ /// <summary>
+ /// 鏍规嵁涓婚敭鑾峰彇
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("GetById")]
+ public ResponseResult GetById(int id)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.GetById(id);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ /// <summary>
+ /// 鏍规嵁涓婚敭鍒犻櫎
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("DeleteByIds")]
+ public ResponseResult DeleteByIds([FromBody] object[] ids)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.DeleteByIds(ids);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ /// <summary>
+ /// 娣诲姞
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("Insert")]
+ public ResponseResult Add([FromBody] ShipmentNotice data)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.Insert(data);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ /// <summary>
+ /// 娣诲姞杩斿洖鑷
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("InsertReturnIdentity")]
+ public ResponseResult InsertReturnIdentity([FromBody] ShipmentNotice data)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.InsertReturnIdentity(data);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ /// <summary>
+ /// 淇敼
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("Update")]
+ public ResponseResult Update([FromBody] ShipmentNotice data)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.Update(data);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+}
\ No newline at end of file
diff --git a/MESApplication/Controllers/LoginController.cs b/MESApplication/Controllers/LoginController.cs
index f6e73dd..9872e67 100644
--- a/MESApplication/Controllers/LoginController.cs
+++ b/MESApplication/Controllers/LoginController.cs
@@ -1,5 +1,4 @@
锘縰sing System.Dynamic;
-using MES.Service.Dto;
using MES.Service.Dto.@base;
using MES.Service.service;
using MES.Service.util;
diff --git a/MESApplication/Controllers/RKJController.cs b/MESApplication/Controllers/RKJController.cs
index 54113af..a6bed3d 100644
--- a/MESApplication/Controllers/RKJController.cs
+++ b/MESApplication/Controllers/RKJController.cs
@@ -1,7 +1,6 @@
锘縰sing System.Dynamic;
using MES.Service.Dto.service;
using MES.Service.Modes;
-using MES.Service.service;
using MES.Service.service.QC;
using MES.Service.util;
using Microsoft.AspNetCore.Mvc;
diff --git a/MESApplication/Controllers/SJController.cs b/MESApplication/Controllers/SJController.cs
index e5fc8b8..d634958 100644
--- a/MESApplication/Controllers/SJController.cs
+++ b/MESApplication/Controllers/SJController.cs
@@ -1,7 +1,6 @@
锘縰sing System.Dynamic;
using MES.Service.Dto.service;
using MES.Service.Modes;
-using MES.Service.service;
using MES.Service.service.QC;
using MES.Service.util;
using Microsoft.AspNetCore.Mvc;
diff --git a/MESApplication/Controllers/SuspendController.cs b/MESApplication/Controllers/SuspendController.cs
index fd0dd34..54e8bfa 100644
--- a/MESApplication/Controllers/SuspendController.cs
+++ b/MESApplication/Controllers/SuspendController.cs
@@ -1,6 +1,5 @@
锘縰sing System.Dynamic;
using MES.Service.Dto.service;
-using MES.Service.service;
using MES.Service.service.QC;
using MES.Service.util;
using Microsoft.AspNetCore.Mvc;
diff --git a/MESApplication/Controllers/XJController.cs b/MESApplication/Controllers/XJController.cs
index 5950843..93fe18d 100644
--- a/MESApplication/Controllers/XJController.cs
+++ b/MESApplication/Controllers/XJController.cs
@@ -1,7 +1,6 @@
锘縰sing System.Dynamic;
using MES.Service.Dto.service;
using MES.Service.Modes;
-using MES.Service.service;
using MES.Service.service.QC;
using MES.Service.util;
using Microsoft.AspNetCore.Mvc;
diff --git a/MESApplication/bin/Debug/net8.0/MES.Service.dll b/MESApplication/bin/Debug/net8.0/MES.Service.dll
index 5890005..05385d8 100644
--- a/MESApplication/bin/Debug/net8.0/MES.Service.dll
+++ b/MESApplication/bin/Debug/net8.0/MES.Service.dll
Binary files differ
diff --git a/MESApplication/bin/Debug/net8.0/MES.Service.pdb b/MESApplication/bin/Debug/net8.0/MES.Service.pdb
index 004089e..83bd29f 100644
--- a/MESApplication/bin/Debug/net8.0/MES.Service.pdb
+++ b/MESApplication/bin/Debug/net8.0/MES.Service.pdb
Binary files differ
diff --git a/MESApplication/bin/Debug/net8.0/MESApplication.dll b/MESApplication/bin/Debug/net8.0/MESApplication.dll
index 25bb384..1c76424 100644
--- a/MESApplication/bin/Debug/net8.0/MESApplication.dll
+++ b/MESApplication/bin/Debug/net8.0/MESApplication.dll
Binary files differ
diff --git a/MESApplication/bin/Debug/net8.0/MESApplication.exe b/MESApplication/bin/Debug/net8.0/MESApplication.exe
index d55d99f..adddc97 100644
--- a/MESApplication/bin/Debug/net8.0/MESApplication.exe
+++ b/MESApplication/bin/Debug/net8.0/MESApplication.exe
Binary files differ
diff --git a/MESApplication/bin/Debug/net8.0/MESApplication.pdb b/MESApplication/bin/Debug/net8.0/MESApplication.pdb
index 32b92ef..e90d88c 100644
--- a/MESApplication/bin/Debug/net8.0/MESApplication.pdb
+++ b/MESApplication/bin/Debug/net8.0/MESApplication.pdb
Binary files differ
diff --git a/MESApplication/bin/Release/net8.0/MES.Service.dll b/MESApplication/bin/Release/net8.0/MES.Service.dll
index 5ef17a8..1e5925e 100644
--- a/MESApplication/bin/Release/net8.0/MES.Service.dll
+++ b/MESApplication/bin/Release/net8.0/MES.Service.dll
Binary files differ
diff --git a/MESApplication/bin/Release/net8.0/MES.Service.pdb b/MESApplication/bin/Release/net8.0/MES.Service.pdb
index 2edfdce..b92a605 100644
--- a/MESApplication/bin/Release/net8.0/MES.Service.pdb
+++ b/MESApplication/bin/Release/net8.0/MES.Service.pdb
Binary files differ
diff --git a/MESApplication/bin/Release/net8.0/MESApplication.dll b/MESApplication/bin/Release/net8.0/MESApplication.dll
index af8e0ea..523437c 100644
--- a/MESApplication/bin/Release/net8.0/MESApplication.dll
+++ b/MESApplication/bin/Release/net8.0/MESApplication.dll
Binary files differ
diff --git a/MESApplication/bin/Release/net8.0/MESApplication.exe b/MESApplication/bin/Release/net8.0/MESApplication.exe
index d55d99f..adddc97 100644
--- a/MESApplication/bin/Release/net8.0/MESApplication.exe
+++ b/MESApplication/bin/Release/net8.0/MESApplication.exe
Binary files differ
diff --git a/MESApplication/bin/Release/net8.0/MESApplication.pdb b/MESApplication/bin/Release/net8.0/MESApplication.pdb
index fa795c3..3eb6305 100644
--- a/MESApplication/bin/Release/net8.0/MESApplication.pdb
+++ b/MESApplication/bin/Release/net8.0/MESApplication.pdb
Binary files differ
diff --git a/MESApplication/bin/Release/net8.0/publish/MES.Service.dll b/MESApplication/bin/Release/net8.0/publish/MES.Service.dll
index 5ef17a8..1e5925e 100644
--- a/MESApplication/bin/Release/net8.0/publish/MES.Service.dll
+++ b/MESApplication/bin/Release/net8.0/publish/MES.Service.dll
Binary files differ
diff --git a/MESApplication/bin/Release/net8.0/publish/MES.Service.pdb b/MESApplication/bin/Release/net8.0/publish/MES.Service.pdb
index 2edfdce..b92a605 100644
--- a/MESApplication/bin/Release/net8.0/publish/MES.Service.pdb
+++ b/MESApplication/bin/Release/net8.0/publish/MES.Service.pdb
Binary files differ
diff --git a/MESApplication/bin/Release/net8.0/publish/MESApplication.dll b/MESApplication/bin/Release/net8.0/publish/MESApplication.dll
index af8e0ea..523437c 100644
--- a/MESApplication/bin/Release/net8.0/publish/MESApplication.dll
+++ b/MESApplication/bin/Release/net8.0/publish/MESApplication.dll
Binary files differ
diff --git a/MESApplication/bin/Release/net8.0/publish/MESApplication.exe b/MESApplication/bin/Release/net8.0/publish/MESApplication.exe
index d55d99f..adddc97 100644
--- a/MESApplication/bin/Release/net8.0/publish/MESApplication.exe
+++ b/MESApplication/bin/Release/net8.0/publish/MESApplication.exe
Binary files differ
diff --git a/MESApplication/bin/Release/net8.0/publish/MESApplication.pdb b/MESApplication/bin/Release/net8.0/publish/MESApplication.pdb
index fa795c3..3eb6305 100644
--- a/MESApplication/bin/Release/net8.0/publish/MESApplication.pdb
+++ b/MESApplication/bin/Release/net8.0/publish/MESApplication.pdb
Binary files differ
--
Gitblit v1.9.3