From 78552e2fb411f5a86abd31c24bece97af8edd110 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期二, 20 八月 2024 18:02:03 +0800
Subject: [PATCH] 添加期初条码打印
---
MESApplication/Controllers/Warehouse/OrganizeController.cs | 54 ++
MESApplication/Startup.cs | 2
MES.Service/service/Warehouse/OrganizeService.cs | 261 ++++++++++
MESApplication/Controllers/BasicData/MesItemsController.cs | 24 +
MES.Service/Modes/MesBarcodeType.cs | 214 ++++++++
MES.Service/Dto/service/WarehouseQuery.cs | 9
MES.Service/service/BasicData/MesItemsManager.cs | 9
MES.Service/Modes/MesInvItemBarcodes.cs | 637 ++++++++++++++------------
MES.Service/Modes/Organize.cs | 37 +
MES.Service/Modes/MesRfPrnbarcode.cs | 155 ++++++
10 files changed, 1,101 insertions(+), 301 deletions(-)
diff --git a/MES.Service/Dto/service/WarehouseQuery.cs b/MES.Service/Dto/service/WarehouseQuery.cs
index a7422e3..925d2e2 100644
--- a/MES.Service/Dto/service/WarehouseQuery.cs
+++ b/MES.Service/Dto/service/WarehouseQuery.cs
@@ -23,4 +23,13 @@
public string? Factory { get; set; }
public string? Company { get; set; }
+ public string? ItemNo { get; set; }
+
+ public string? ItemModel { get; set; }
+ public string? OrgName { get; set; }
+ public string? OrgOwner { get; set; }
+ public string? ItemNum { get; set; }
+ public string? Printnumn { get; set; }
+
+ public string? ItemName { get; set; }
}
\ No newline at end of file
diff --git a/MES.Service/Modes/MesBarcodeType.cs b/MES.Service/Modes/MesBarcodeType.cs
new file mode 100644
index 0000000..f11c46e
--- /dev/null
+++ b/MES.Service/Modes/MesBarcodeType.cs
@@ -0,0 +1,214 @@
+锘縰sing System;
+using System.Collections.Generic;
+using System.Linq;
+using SqlSugar;
+namespace MES.Service.Modes
+{
+ /// <summary>
+ /// 鏉＄爜绫诲瀷琛�
+ ///</summary>
+ [SugarTable("MES_BARCODE_TYPE")]
+ public class MesBarcodeType
+ {
+ /// <summary>
+ /// 鏉＄爜绫诲瀷ID(seq_me_id)
+ ///</summary>
+ [SugarColumn(ColumnName="ID" ,IsPrimaryKey = true )]
+ public decimal Id { get; set; }
+ /// <summary>
+ /// 浣跨敤鍦烘墍
+ ///</summary>
+ [SugarColumn(ColumnName="USE_SITE" )]
+ public string UseSite { get; set; }
+ /// <summary>
+ /// 鏉＄爜绫诲瀷鍚嶇О
+ ///</summary>
+ [SugarColumn(ColumnName="BARCODE_TYPE_NAME" )]
+ public string BarcodeTypeName { get; set; }
+ /// <summary>
+ /// 鐮佸埗
+ ///</summary>
+ [SugarColumn(ColumnName="CODE" )]
+ public string Code { get; set; }
+ /// <summary>
+ /// 鏉＄爜绾稿
+ ///</summary>
+ [SugarColumn(ColumnName="PAPER_WIDTH" )]
+ public decimal? PaperWidth { get; set; }
+ /// <summary>
+ /// 鏉＄爜绾搁珮
+ ///</summary>
+ [SugarColumn(ColumnName="PAPER_HEIGHT" )]
+ public decimal? PaperHeight { get; set; }
+ /// <summary>
+ /// 鏉＄爜寮�濮嬩綅缃甔
+ ///</summary>
+ [SugarColumn(ColumnName="BARCODE_BEGIN_POSITION_X" )]
+ public decimal? BarcodeBeginPositionX { get; set; }
+ /// <summary>
+ /// 鏉＄爜寮�濮嬩綅缃甕
+ ///</summary>
+ [SugarColumn(ColumnName="BARCODE_BEGIN_POSITION_Y" )]
+ public decimal? BarcodeBeginPositionY { get; set; }
+ /// <summary>
+ /// 涓�寮犳潯鐮佺焊涓婃潯鐮佷釜鏁�
+ ///</summary>
+ [SugarColumn(ColumnName="PAPER_NUM" )]
+ public decimal? PaperNum { get; set; }
+ /// <summary>
+ /// 涓�寮犳潯鐮佺焊涓婃瘡琛屾潯鐮佷釜鏁�
+ ///</summary>
+ [SugarColumn(ColumnName="PAPER_ROW_NUM" )]
+ public decimal? PaperRowNum { get; set; }
+ /// <summary>
+ /// 涓�寮犳潯鐮佺焊涓婃潯鐮佸垪鏁�
+ ///</summary>
+ [SugarColumn(ColumnName="PAPER_COLUMN_NUM" )]
+ public decimal? PaperColumnNum { get; set; }
+ /// <summary>
+ /// 鏉＄爜娴佹按鍙峰惊鐜被鍨�(鎺у埗鏉＄爜娴佹按鍙�)
+ ///</summary>
+ [SugarColumn(ColumnName="CYCLE_TYPE" )]
+ public string CycleType { get; set; }
+ /// <summary>
+ /// 鏄惁鏈夋晥(0-鏃犳晥,1-鏈夋晥)
+ ///</summary>
+ [SugarColumn(ColumnName="AVAILABLE_FLAG" )]
+ public decimal? AvailableFlag { get; set; }
+ /// <summary>
+ /// 鏉＄爜楂樺害
+ ///</summary>
+ [SugarColumn(ColumnName="BARCODE_HEIGHT" )]
+ public decimal? BarcodeHeight { get; set; }
+ /// <summary>
+ /// 鏉＄爜瀛椾綋鏂瑰悜
+ ///</summary>
+ [SugarColumn(ColumnName="BARCODE_ORIENTATION" )]
+ public string BarcodeOrientation { get; set; }
+ /// <summary>
+ /// 鏉＄爜鎵撳嵃娉ㄩ噴琛�(1-鎵撳嵃锛�0-涓嶆墦鍗�)
+ ///</summary>
+ [SugarColumn(ColumnName="BARCODE_INTERPRETATION" )]
+ public decimal? BarcodeInterpretation { get; set; }
+ /// <summary>
+ /// 鏉＄爜鎵撳嵃娉ㄩ噴琛屾墦鍦ㄦ潯鐮佷笂鏂�(1-鎵撳嵃鍦ㄦ潯鐮佷笂鏂癸紝0-涓嶆墦鍗板湪鏉＄爜涓婃柟)
+ ///</summary>
+ [SugarColumn(ColumnName="BARCODE_INTERPRETATION_ABOVE" )]
+ public decimal? BarcodeInterpretationAbove { 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="BARCODE_WIDTH" )]
+ public decimal? BarcodeWidth { get; set; }
+ /// <summary>
+ /// [鏀瑰彉鏉＄爜榛樿鍙傛暟]妯″潡锛堢獎鏉★級瀹�
+ ///</summary>
+ [SugarColumn(ColumnName="BY_W" )]
+ public decimal? ByW { get; set; }
+ /// <summary>
+ /// [鏀瑰彉鏉＄爜榛樿鍙傛暟]瀹芥潯涓庣獎鏉＄殑姣斾緥
+ ///</summary>
+ [SugarColumn(ColumnName="BY_R" )]
+ public decimal? ByR { get; set; }
+ /// <summary>
+ /// [鏀瑰彉鏉＄爜榛樿鍙傛暟]鏉＄爜楂樺害
+ ///</summary>
+ [SugarColumn(ColumnName="BY_H" )]
+ public decimal? ByH { get; set; }
+ /// <summary>
+ /// 鐐规暟/姣背
+ ///</summary>
+ [SugarColumn(ColumnName="JM" )]
+ public string Jm { get; set; }
+ /// <summary>
+ /// 铏氭嫙鏁版嵁鏍囧織(1-鏄紝0锛嶅惁)
+ ///</summary>
+ [SugarColumn(ColumnName="JVM_DATA_FLAG" )]
+ public decimal? JvmDataFlag { get; set; }
+ /// <summary>
+ /// 铏氭嫙鏁版嵁娴佹按鍙蜂綅鏁�
+ ///</summary>
+ [SugarColumn(ColumnName="JVM_SERIAL_DIGIT" )]
+ public decimal? JvmSerialDigit { get; set; }
+ /// <summary>
+ /// 铏氭嫙鏁版嵁鏉＄爜闀垮害
+ ///</summary>
+ [SugarColumn(ColumnName="JVM_BARCODE_LENGTH" )]
+ public decimal? JvmBarcodeLength { get; set; }
+ /// <summary>
+ /// 鎵撳嵃鍛戒护
+ ///</summary>
+ [SugarColumn(ColumnName="PRINT_COMMAND" )]
+ public string PrintCommand { get; set; }
+ /// <summary>
+ /// 鎵撳嵃鍛戒护寮�濮�
+ ///</summary>
+ [SugarColumn(ColumnName="PRINT_COMMAND_BEGIN" )]
+ public string PrintCommandBegin { get; set; }
+ /// <summary>
+ /// 鎵撳嵃鍛戒护缁撴潫
+ ///</summary>
+ [SugarColumn(ColumnName="PRINT_COMMAND_END" )]
+ public string PrintCommandEnd { get; set; }
+ /// <summary>
+ /// 鏉＄爜娉ㄩ噴琛屾暟
+ ///</summary>
+ [SugarColumn(ColumnName="BARCODE_INTERPRETATION_ROW" )]
+ public decimal? BarcodeInterpretationRow { get; set; }
+ /// <summary>
+ /// 鏉＄爜鍊煎甫鐗╂枡缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="BARCODE_ITEM" )]
+ public decimal? BarcodeItem { get; set; }
+ /// <summary>
+ /// 鏉＄爜绫诲瀷缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="TYPE_CODE" )]
+ public decimal TypeCode { get; set; }
+ /// <summary>
+ /// 鏄惁浣跨敤
+ ///</summary>
+ [SugarColumn(ColumnName="ISUSED" )]
+ public short? Isused { get; set; }
+ /// <summary>
+ /// 鎵撳嵃妯℃澘
+ ///</summary>
+ [SugarColumn(ColumnName="MBTYPE" )]
+ public decimal? Mbtype { get; set; }
+ /// <summary>
+ /// 鍒嗗巶缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="FACTORY" )]
+ public string Factory { get; set; }
+ /// <summary>
+ /// 鍏徃浠ｇ爜
+ ///</summary>
+ [SugarColumn(ColumnName="COMPANY" )]
+ public string Company { get; set; }
+ /// <summary>
+ /// 娴佹按鍙蜂綅鏁�
+ ///</summary>
+ [SugarColumn(ColumnName="ORDER_NUM" )]
+ public decimal? OrderNum { get; set; }
+ }
+}
diff --git a/MES.Service/Modes/MesInvItemBarcodes.cs b/MES.Service/Modes/MesInvItemBarcodes.cs
index 078ac04..11af555 100644
--- a/MES.Service/Modes/MesInvItemBarcodes.cs
+++ b/MES.Service/Modes/MesInvItemBarcodes.cs
@@ -8,453 +8,490 @@
[SugarTable("MES_INV_ITEM_BARCODES")]
public class MesInvItemBarcodes
{
- /// <summary>
- /// SEQ_BARCODE_PSN_ID
- /// </summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+ /// <summary>
+ /// SEQ_BARCODE_PSN_ID
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_EQBASE",
+ IsPrimaryKey = true)]
public decimal Id { get; set; }
- /// <summary>
- /// 鐗╂枡鏉＄爜
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_BARCODE")]
+ /// <summary>
+ /// 鐗╂枡鏉＄爜
+ ///</summary>
+ [SugarColumn(ColumnName = "ITEM_BARCODE")]
public string ItemBarcode { get; set; }
- /// <summary>
- /// 瀹㈡埛鎴愬搧缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "C_PRODUCT_CODE")]
+ /// <summary>
+ /// 瀹㈡埛鎴愬搧缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName = "C_PRODUCT_CODE")]
public string CProductCode { get; set; }
- /// <summary>
- /// 瀹㈡埛鐗╂枡鏉＄爜
- /// </summary>
- [SugarColumn(ColumnName = "C_ITEM_BARCODE")]
+ /// <summary>
+ /// 瀹㈡埛鐗╂枡鏉＄爜
+ ///</summary>
+ [SugarColumn(ColumnName = "C_ITEM_BARCODE")]
public string CItemBarcode { get; set; }
- /// <summary>
- /// 瀹㈡埛鐗╂枡缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "C_ITEM_CODE")]
+ /// <summary>
+ /// 瀹㈡埛鐗╂枡缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName = "C_ITEM_CODE")]
public string CItemCode { get; set; }
- /// <summary>
- /// 鏈徃鐗╂枡缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_NO")]
+ /// <summary>
+ /// 鏈徃鐗╂枡缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName = "ITEM_NO")]
public string ItemNo { get; set; }
- /// <summary>
- /// 鍘傚鎵规
- /// </summary>
- [SugarColumn(ColumnName = "LOT_NO")]
+ /// <summary>
+ /// 鍘傚鎵规
+ ///</summary>
+ [SugarColumn(ColumnName = "LOT_NO")]
public string LotNo { get; set; }
- /// <summary>
- /// 鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "QUANTITY")]
+ /// <summary>
+ /// 鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName = "QUANTITY")]
public decimal? Quantity { get; set; }
- /// <summary>
- /// 鏄惁鐜繚(0:鍚�,1:鏄�)
- /// </summary>
- [SugarColumn(ColumnName = "EP_FLAG")]
+ /// <summary>
+ /// 鏄惁鐜繚(0:鍚�,1:鏄�)
+ ///</summary>
+ [SugarColumn(ColumnName = "EP_FLAG")]
public short? EpFlag { get; set; }
- /// <summary>
- /// 鐢熶骇宸ュ崟
- /// </summary>
- [SugarColumn(ColumnName = "TASK_NO")]
+ /// <summary>
+ /// 鐢熶骇宸ュ崟
+ ///</summary>
+ [SugarColumn(ColumnName = "TASK_NO")]
public string TaskNo { get; set; }
- /// <summary>
- /// 鍒涘缓浜�
- /// </summary>
- [SugarColumn(ColumnName = "CREATE_BY")]
+ /// <summary>
+ /// 鍒涘缓浜�
+ ///</summary>
+ [SugarColumn(ColumnName = "CREATE_BY")]
public string CreateBy { get; set; }
- /// <summary>
- /// 鍒涘缓鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "CREATE_DATE")]
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName = "CREATE_DATE")]
public DateTime? CreateDate { get; set; }
- /// <summary>
- /// 鏈�鍚庢洿鏂颁汉
- /// </summary>
- [SugarColumn(ColumnName = "LASTUPDATE_BY")]
+ /// <summary>
+ /// 鏈�鍚庢洿鏂颁汉
+ ///</summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_BY")]
public string LastupdateBy { get; set; }
- /// <summary>
- /// 鏈�鍚庢洿鏂版椂闂�
- /// </summary>
- [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
+ /// <summary>
+ /// 鏈�鍚庢洿鏂版椂闂�
+ ///</summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
public DateTime? LastupdateDate { get; set; }
- /// <summary>
- /// 瀹㈡埛缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "CUST_NO")]
+ /// <summary>
+ /// 瀹㈡埛缂栧彿
+ ///</summary>
+ [SugarColumn(ColumnName = "CUST_NO")]
public string CustNo { get; set; }
- /// <summary>
- /// 鐗╂枡鏉＄爜娉ㄩ噴琛孾鍐椾綑锛屾潯鐮侀噸鎵撲娇鐢╙
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_BARCODE_TEXT")]
+ /// <summary>
+ /// 鐗╂枡鏉＄爜娉ㄩ噴琛孾鍐椾綑锛屾潯鐮侀噸鎵撲娇鐢╙
+ ///</summary>
+ [SugarColumn(ColumnName = "ITEM_BARCODE_TEXT")]
public string ItemBarcodeText { get; set; }
- /// <summary>
- /// 鍘烶SN鐗╂枡鏉＄爜
- /// </summary>
- [SugarColumn(ColumnName = "OLD_ITEM_BARCODE")]
+ /// <summary>
+ /// 鍘烶SN鐗╂枡鏉＄爜
+ ///</summary>
+ [SugarColumn(ColumnName = "OLD_ITEM_BARCODE")]
public string OldItemBarcode { get; set; }
- /// <summary>
- /// SAP鏀惰揣鐗╂枡鍑瘉鍙� --閲囪喘鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "MBLNR")]
+ /// <summary>
+ /// SAP鏀惰揣鐗╂枡鍑瘉鍙� --閲囪喘鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName = "MBLNR")]
public string Mblnr { get; set; }
- /// <summary>
- /// SAP鏀惰揣鐗╂枡鍑瘉琛屽彿 --閲囪喘鍗曡鍙�
- /// </summary>
- [SugarColumn(ColumnName = "ZEILE")]
+ /// <summary>
+ /// SAP鏀惰揣鐗╂枡鍑瘉琛屽彿 --閲囪喘鍗曡鍙�
+ ///</summary>
+ [SugarColumn(ColumnName = "ZEILE")]
public decimal? Zeile { get; set; }
- /// <summary>
- /// 鏀舵枡琛↖D
- /// </summary>
- [SugarColumn(ColumnName = "ROH_IN_ID")]
+ /// <summary>
+ /// 鏀舵枡琛↖D
+ ///</summary>
+ [SugarColumn(ColumnName = "ROH_IN_ID")]
public decimal? RohInId { get; set; }
- /// <summary>
- /// 0涓烘湁鏁堟潯鐮侊紱1涓烘棤鏁堟潯鐮�
- /// </summary>
- [SugarColumn(ColumnName = "BARCODESTATUS")]
+ /// <summary>
+ /// 0涓烘湁鏁堟潯鐮侊紱1涓烘棤鏁堟潯鐮�
+ ///</summary>
+ [SugarColumn(ColumnName = "BARCODESTATUS")]
public short? Barcodestatus { get; set; }
- /// <summary>
- /// 鍘熷鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "OLDQTY")]
+ /// <summary>
+ /// 鍘熷鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName = "OLDQTY")]
public decimal? Oldqty { get; set; }
- /// <summary>
- /// 浣跨敤鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "USEQTY")]
+ /// <summary>
+ /// 浣跨敤鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName = "USEQTY")]
public decimal? Useqty { get; set; }
- /// <summary>
- /// 0鍦ㄥ簱锛�1鍦ㄧ嚎锛�2浣滃簾
- /// </summary>
- [SugarColumn(ColumnName = "LOCATION")]
+ /// <summary>
+ /// 0鍦ㄥ簱锛�1鍦ㄧ嚎锛�2浣滃簾
+ ///</summary>
+ [SugarColumn(ColumnName = "LOCATION")]
public short? Location { get; set; }
- /// <summary>
- /// 鍗曚綅
- /// </summary>
- [SugarColumn(ColumnName = "UNIT")]
+ /// <summary>
+ /// 鍗曚綅
+ ///</summary>
+ [SugarColumn(ColumnName = "UNIT")]
public string Unit { get; set; }
- /// <summary>
- /// 閲嶉噺锛堝崟浣嶏細鍏枻锛�
- /// </summary>
- [SugarColumn(ColumnName = "WEIGHT_UNIT")]
+ /// <summary>
+ /// 閲嶉噺锛堝崟浣嶏細鍏枻锛�
+ ///</summary>
+ [SugarColumn(ColumnName = "WEIGHT_UNIT")]
public decimal? WeightUnit { get; set; }
- /// <summary>
- /// 鍗曚环
- /// </summary>
- [SugarColumn(ColumnName = "PRICE")]
+ /// <summary>
+ /// 鍗曚环
+ ///</summary>
+ [SugarColumn(ColumnName = "PRICE")]
public decimal? Price { get; set; }
- /// <summary>
- /// 鍘熸潯鐮佹暟閲�
- /// </summary>
- [SugarColumn(ColumnName = "OLD_BAR_QUANTITY")]
+ /// <summary>
+ /// 鍘熸潯鐮佹暟閲�
+ ///</summary>
+ [SugarColumn(ColumnName = "OLD_BAR_QUANTITY")]
public decimal? OldBarQuantity { get; set; }
- /// <summary>
- /// 姹囨�绘潯鐮�
- /// </summary>
- [SugarColumn(ColumnName = "SUM_BARCODE")]
+ /// <summary>
+ /// 姹囨�绘潯鐮�
+ ///</summary>
+ [SugarColumn(ColumnName = "SUM_BARCODE")]
public string SumBarcode { get; set; }
- /// <summary>
- /// 鐢熶骇鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "LOT_DATE")]
+ /// <summary>
+ /// 鐢熶骇鏃ユ湡
+ ///</summary>
+ [SugarColumn(ColumnName = "LOT_DATE")]
public string LotDate { get; set; }
- /// <summary>
- /// 妯″彿
- /// </summary>
- [SugarColumn(ColumnName = "MOCODE")]
+ /// <summary>
+ /// 妯″彿
+ ///</summary>
+ [SugarColumn(ColumnName = "MOCODE")]
public string Mocode { get; set; }
- /// <summary>
- /// 鏉ユ簮
- /// </summary>
- [SugarColumn(ColumnName = "MEMO")]
+ /// <summary>
+ /// 鏉ユ簮
+ ///</summary>
+ [SugarColumn(ColumnName = "MEMO")]
public string Memo { get; set; }
- /// <summary>
- /// 渚涘簲鍟嗙紪鐮�
- /// </summary>
- [SugarColumn(ColumnName = "SUPP_NO")]
+ /// <summary>
+ /// 渚涘簲鍟嗙紪鐮�
+ ///</summary>
+ [SugarColumn(ColumnName = "SUPP_NO")]
public string SuppNo { get; set; }
- /// <summary>
- /// 妗ｄ綅浣庡��
- /// </summary>
- [SugarColumn(ColumnName = "SPOSTION")]
+ /// <summary>
+ /// 妗ｄ綅浣庡��
+ ///</summary>
+ [SugarColumn(ColumnName = "SPOSTION")]
public string Spostion { get; set; }
- /// <summary>
- /// 妗ｄ綅楂樺��
- /// </summary>
- [SugarColumn(ColumnName = "EPOSTION")]
+ /// <summary>
+ /// 妗ｄ綅楂樺��
+ ///</summary>
+ [SugarColumn(ColumnName = "EPOSTION")]
public string Epostion { get; set; }
- /// <summary>
- /// 鐗╂枡绠�绉�
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_SNAME")]
+ /// <summary>
+ /// 鐗╂枡绠�绉�
+ ///</summary>
+ [SugarColumn(ColumnName = "ITEM_SNAME")]
public string ItemSname { get; set; }
- /// <summary>
- /// 鏄惁宸插喕缁�,1鍐荤粨
- /// </summary>
- [SugarColumn(ColumnName = "VISABLE")]
+ /// <summary>
+ /// 鏄惁宸插喕缁�,1鍐荤粨
+ ///</summary>
+ [SugarColumn(ColumnName = "VISABLE")]
public short? Visable { get; set; }
- /// <summary>
- /// 渚涘簲鍟嗘壒娆�
- /// </summary>
- [SugarColumn(ColumnName = "TR_LOTNO")]
+ /// <summary>
+ /// 渚涘簲鍟嗘壒娆�
+ ///</summary>
+ [SugarColumn(ColumnName = "TR_LOTNO")]
public string TrLotno { get; set; }
- /// <summary>
- /// 鍐荤粨鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "FLEZZ_DATE")]
+ /// <summary>
+ /// 鍐荤粨鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName = "FLEZZ_DATE")]
public DateTime? FlezzDate { get; set; }
- /// <summary>
- /// 鍐荤粨鍘熷洜
- /// </summary>
- [SugarColumn(ColumnName = "FLEZZ_REASON")]
+ /// <summary>
+ /// 鍐荤粨鍘熷洜
+ ///</summary>
+ [SugarColumn(ColumnName = "FLEZZ_REASON")]
public string FlezzReason { get; set; }
- /// <summary>
- /// 鍐荤粨浜�
- /// </summary>
- [SugarColumn(ColumnName = "FLEZZ_BY")]
+ /// <summary>
+ /// 鍐荤粨浜�
+ ///</summary>
+ [SugarColumn(ColumnName = "FLEZZ_BY")]
public string FlezzBy { get; set; }
- /// <summary>
- /// 寤堕暱淇濊川鏈�
- /// </summary>
- [SugarColumn(ColumnName = "DELANY_MONTH")]
+ /// <summary>
+ /// 寤堕暱淇濊川鏈�
+ ///</summary>
+ [SugarColumn(ColumnName = "DELANY_MONTH")]
public decimal? DelanyMonth { get; set; }
- /// <summary>
- /// 鏈�灏忓寘瑁呮爣璇�
- /// </summary>
- [SugarColumn(ColumnName = "MINPACK_FLAG")]
+ /// <summary>
+ /// 鏈�灏忓寘瑁呮爣璇�
+ ///</summary>
+ [SugarColumn(ColumnName = "MINPACK_FLAG")]
public short? MinpackFlag { get; set; }
- /// <summary>
- /// 鎵撳嵃ID锛岀敤鏉ュ尯鍒嗘墦鍗版鏁�
- /// </summary>
- [SugarColumn(ColumnName = "PRINT_ID")]
+ /// <summary>
+ /// 鎵撳嵃ID锛岀敤鏉ュ尯鍒嗘墦鍗版鏁�
+ ///</summary>
+ [SugarColumn(ColumnName = "PRINT_ID")]
public string PrintId { get; set; }
- /// <summary>
- /// 鐜繚椤圭洰
- /// </summary>
- [SugarColumn(ColumnName = "EP_ITEM")]
+ /// <summary>
+ /// 鐜繚椤圭洰
+ ///</summary>
+ [SugarColumn(ColumnName = "EP_ITEM")]
public string EpItem { get; set; }
- /// <summary>
- /// 宸ュ巶缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "FACTORY")]
+ /// <summary>
+ /// 宸ュ巶缂栧彿
+ ///</summary>
+ [SugarColumn(ColumnName = "FACTORY")]
public string Factory { get; set; }
- /// <summary>
- /// 鍏徃缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "COMPANY")]
+ /// <summary>
+ /// 鍏徃缂栧彿
+ ///</summary>
+ [SugarColumn(ColumnName = "COMPANY")]
public string Company { get; set; }
- /// <summary>
- /// 鍗℃澘缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "CB_NO")]
+ /// <summary>
+ /// 鍗℃澘缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName = "CB_NO")]
public string CbNo { get; set; }
- /// <summary>
- /// 鍘傚鐢熶骇绾�
- /// </summary>
- [SugarColumn(ColumnName = "LINFLINE")]
+ /// <summary>
+ /// 鍘傚鐢熶骇绾�
+ ///</summary>
+ [SugarColumn(ColumnName = "LINFLINE")]
public string Linfline { get; set; }
- /// <summary>
- /// 鏈夋晥鏈�
- /// </summary>
- [SugarColumn(ColumnName = "VALID_TIME")]
+ /// <summary>
+ /// 鏈夋晥鏈�
+ ///</summary>
+ [SugarColumn(ColumnName = "VALID_TIME")]
public DateTime? ValidTime { get; set; }
- /// <summary>
- /// 璐ㄦ缁撴灉
- /// </summary>
- [SugarColumn(ColumnName = "IQC_STATUS")]
+ /// <summary>
+ /// 璐ㄦ缁撴灉
+ ///</summary>
+ [SugarColumn(ColumnName = "IQC_STATUS")]
public string IqcStatus { get; set; }
- /// <summary>
- /// 灏忚溅鏉＄爜
- /// </summary>
- [SugarColumn(ColumnName = "FCAR")]
+ /// <summary>
+ /// 灏忚溅鏉＄爜
+ ///</summary>
+ [SugarColumn(ColumnName = "FCAR")]
public string Fcar { get; set; }
- /// <summary>
- /// 姣涢噸
- /// </summary>
- [SugarColumn(ColumnName = "GWEIGHT")]
+ /// <summary>
+ /// 姣涢噸
+ ///</summary>
+ [SugarColumn(ColumnName = "GWEIGHT")]
public string Gweight { get; set; }
- /// <summary>
- /// 鍑�閲�
- /// </summary>
- [SugarColumn(ColumnName = "NWEIGHT")]
+ /// <summary>
+ /// 鍑�閲�
+ ///</summary>
+ [SugarColumn(ColumnName = "NWEIGHT")]
public string Nweight { get; set; }
- /// <summary>
- /// 淇濊川鏈�
- /// </summary>
- [SugarColumn(ColumnName = "EXT_DATE")]
+ /// <summary>
+ /// 淇濊川鏈�
+ ///</summary>
+ [SugarColumn(ColumnName = "EXT_DATE")]
public decimal? ExtDate { get; set; }
- /// <summary>
- /// 渚涘簲鍟嗐�佽禒鍝併�佸渚涙枡銆佸澶�
- /// </summary>
- [SugarColumn(ColumnName = "BARCODETYPE")]
+ /// <summary>
+ /// 渚涘簲鍟嗐�佽禒鍝併�佸渚涙枡銆佸澶�
+ ///</summary>
+ [SugarColumn(ColumnName = "BARCODETYPE")]
public string Barcodetype { get; set; }
- /// <summary>
- /// 渚涘簲鍟嗗悕绉�
- /// </summary>
- [SugarColumn(ColumnName = "SUPP_NAME")]
+ /// <summary>
+ /// 渚涘簲鍟嗗悕绉�
+ ///</summary>
+ [SugarColumn(ColumnName = "SUPP_NAME")]
public string SuppName { get; set; }
- /// <summary>
- /// 鍒拌揣鍗曞彿/鍏ュ簱鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "BILL_NO")]
+ /// <summary>
+ /// 鍒拌揣鍗曞彿/鍏ュ簱鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName = "BILL_NO")]
public string BillNo { get; set; }
- /// <summary>
- /// 鎬ユ枡鏍囪瘑
- /// </summary>
- [SugarColumn(ColumnName = "URGENT_FLAG")]
+ /// <summary>
+ /// 鎬ユ枡鏍囪瘑
+ ///</summary>
+ [SugarColumn(ColumnName = "URGENT_FLAG")]
public short? UrgentFlag { get; set; }
- /// <summary>
- /// 棰滆壊
- /// </summary>
- [SugarColumn(ColumnName = "COLOR_NAME")]
+ /// <summary>
+ /// 棰滆壊
+ ///</summary>
+ [SugarColumn(ColumnName = "COLOR_NAME")]
public string ColorName { get; set; }
- /// <summary>
- /// 浜у搧鍨嬪彿
- /// </summary>
- [SugarColumn(ColumnName = "BOARD_STYLE")]
+ /// <summary>
+ /// 浜у搧鍨嬪彿
+ ///</summary>
+ [SugarColumn(ColumnName = "BOARD_STYLE")]
public string BoardStyle { get; set; }
- /// <summary>
- /// 鏉ユ枡鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "INS_DATE")]
+ /// <summary>
+ /// 鏉ユ枡鏃ユ湡
+ ///</summary>
+ [SugarColumn(ColumnName = "INS_DATE")]
public DateTime? InsDate { get; set; }
- /// <summary>
- /// 鍒拌揣鍗曡鍙�
- /// </summary>
- [SugarColumn(ColumnName = "WORK_LINE")]
+ /// <summary>
+ /// 鍒拌揣鍗曡鍙�
+ ///</summary>
+ [SugarColumn(ColumnName = "WORK_LINE")]
public decimal? WorkLine { get; set; }
- /// <summary>
- /// 涓嶈壇鍘熷洜
- /// </summary>
- [SugarColumn(ColumnName = "MEMO_BAD")]
+ /// <summary>
+ /// 涓嶈壇鍘熷洜
+ ///</summary>
+ [SugarColumn(ColumnName = "MEMO_BAD")]
public string MemoBad { get; set; }
- /// <summary>
- /// 浠诲姟鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "WORK_NO")]
+ /// <summary>
+ /// 浠诲姟鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName = "WORK_NO")]
public string WorkNo { get; set; }
- /// <summary>
- /// 鏉＄爜鏉ユ簮鏍囪瘑锛�0-鍒濇湡鐗╂枡,1-閲囪喘鍏ュ簱锛�2銆佺敓浜ч��鏂欙紝3銆佸叾瀹冨叆搴擄紝4-瀹緵鏂�,5-鍦ㄥ簱鍒嗘枡锛�6-鍒剁▼鏉＄爜
- /// </summary>
- [SugarColumn(ColumnName = "COME_FLG")]
+ /// <summary>
+ /// 鏉＄爜鏉ユ簮鏍囪瘑锛�0-鍒濇湡鐗╂枡,1-閲囪喘鍏ュ簱锛�2銆佺敓浜ч��鏂欙紝3銆佸叾瀹冨叆搴擄紝4-瀹緵鏂�,5-鍦ㄥ簱鍒嗘枡锛�6-鍒剁▼鏉＄爜
+ ///</summary>
+ [SugarColumn(ColumnName = "COME_FLG")]
public short? ComeFlg { get; set; }
- /// <summary>
- /// 鐢熶骇绾夸綋
- /// </summary>
- [SugarColumn(ColumnName = "LINE_NO")]
+ /// <summary>
+ /// 鐢熶骇绾夸綋
+ ///</summary>
+ [SugarColumn(ColumnName = "LINE_NO")]
public string LineNo { get; set; }
- /// <summary>
- /// 涓濆嵃娆℃暟
- /// </summary>
- [SugarColumn(ColumnName = "SILK_PQTY")]
+ /// <summary>
+ /// 涓濆嵃娆℃暟
+ ///</summary>
+ [SugarColumn(ColumnName = "SILK_PQTY")]
public decimal? SilkPqty { get; set; }
- /// <summary>
- /// 涓濆嵃娆℃暟姣�
- /// </summary>
- [SugarColumn(ColumnName = "SILK")]
+ /// <summary>
+ /// 涓濆嵃娆℃暟姣�
+ ///</summary>
+ [SugarColumn(ColumnName = "SILK")]
public string Silk { get; set; }
- /// <summary>
- /// 涓濆嵃娲惧伐浠庤〃ID
- /// </summary>
- [SugarColumn(ColumnName = "SILK_ID")]
+ /// <summary>
+ /// 涓濆嵃娲惧伐浠庤〃ID
+ ///</summary>
+ [SugarColumn(ColumnName = "SILK_ID")]
public decimal? SilkId { get; set; }
- /// <summary>
- /// 宸叉姤宸ユ爣璇�
- /// </summary>
- [SugarColumn(ColumnName = "WORK_FLG")]
+ /// <summary>
+ /// 宸叉姤宸ユ爣璇�
+ ///</summary>
+ [SugarColumn(ColumnName = "WORK_FLG")]
public decimal? WorkFlg { get; set; }
- /// <summary>
- /// 鏈�鍚庡伐搴�
- /// </summary>
- [SugarColumn(ColumnName = "WORK_LAST")]
+ /// <summary>
+ /// 鏈�鍚庡伐搴�
+ ///</summary>
+ [SugarColumn(ColumnName = "WORK_LAST")]
public decimal? WorkLast { get; set; }
- /// <summary>
- /// 0-鏈悎骞舵墦鍗帮紝1-鍚堝苟鎵撳嵃
- /// </summary>
- [SugarColumn(ColumnName = "HBDY")]
+ /// <summary>
+ /// 0-鏈悎骞舵墦鍗帮紝1-鍚堝苟鎵撳嵃
+ ///</summary>
+ [SugarColumn(ColumnName = "HBDY")]
public decimal? Hbdy { get; set; }
- /// <summary>
- /// 0-鏈夋晥鏉＄爜锛�1-鍚堝苟鎷嗗垎鐨勬潯鐮侊紝鏃犳晥
- /// </summary>
- [SugarColumn(ColumnName = "HBDYTM")]
+ /// <summary>
+ /// 0-鏈夋晥鏉＄爜锛�1-鍚堝苟鎷嗗垎鐨勬潯鐮侊紝鏃犳晥
+ ///</summary>
+ [SugarColumn(ColumnName = "HBDYTM")]
public decimal? Hbdytm { get; set; }
- /// <summary>
- /// 鎶ュ伐鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "WORK_FLGTIME")]
+ /// <summary>
+ /// 鎶ュ伐鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName = "WORK_FLGTIME")]
public string WorkFlgtime { get; set; }
+
+ /// <summary>
+ /// 閲囪喘璁㈠崟ID
+ ///</summary>
+ [SugarColumn(ColumnName = "EBELN_K3ID")]
+ public decimal? EbelnK3id { get; set; }
+
+ /// <summary>
+ /// 閲囪喘璁㈠崟琛孖D
+ ///</summary>
+ [SugarColumn(ColumnName = "LINE_K3ID")]
+ public decimal? LineK3id { get; set; }
+
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName = "ITEM_ID")]
+ public decimal? ItemId { get; set; }
+
+ /// <summary>
+ /// 鐢熶骇宸ュ簭ID
+ ///</summary>
+ [SugarColumn(ColumnName = "GX_ID")]
+ public decimal? GxId { get; set; }
+
+ /// <summary>
+ /// 缁勭粐id
+ ///</summary>
+ [SugarColumn(ColumnName = "ORG_NAME")]
+ public string OrgName { get; set; }
+
+ /// <summary>
+ /// 璐т富id
+ ///</summary>
+ [SugarColumn(ColumnName = "ORG_OWNER")]
+ public string OrgOwner { get; set; }
}
\ No newline at end of file
diff --git a/MES.Service/Modes/MesRfPrnbarcode.cs b/MES.Service/Modes/MesRfPrnbarcode.cs
new file mode 100644
index 0000000..ab60c94
--- /dev/null
+++ b/MES.Service/Modes/MesRfPrnbarcode.cs
@@ -0,0 +1,155 @@
+锘縰sing SqlSugar;
+
+namespace MES.Service.Modes
+{
+ /// <summary>
+ /// 鎵嬫寔鏉＄爜鎵撳嵃鏆傚瓨琛�
+ ///</summary>
+ [SugarTable("MES_RF_PRNBARCODE")]
+ public class MesRfPrnbarcode
+ {
+ /// <summary>
+ /// ID
+ ///</summary>
+ [SugarColumn(ColumnName = "ID")]
+ public decimal? Id { get; set; }
+
+ /// <summary>
+ /// 鎵撳嵃椤哄簭
+ ///</summary>
+ [SugarColumn(ColumnName = "FORDER")]
+ public string? Forder { get; set; }
+
+ /// <summary>
+ /// 鎵撳嵃浠芥暟
+ ///</summary>
+ [SugarColumn(ColumnName = "FNO")]
+ public string? Fno { get; set; }
+
+ /// <summary>
+ /// 瀛楁1
+ ///</summary>
+ [SugarColumn(ColumnName = "STRP1")]
+ public string? Strp1 { get; set; }
+
+ /// <summary>
+ /// 瀛楁2
+ ///</summary>
+ [SugarColumn(ColumnName = "STRP2")]
+ public string? Strp2 { get; set; }
+
+ /// <summary>
+ /// 瀛楁3
+ ///</summary>
+ [SugarColumn(ColumnName = "STRP3")]
+ public string? Strp3 { get; set; }
+
+ /// <summary>
+ /// 瀛楁4
+ ///</summary>
+ [SugarColumn(ColumnName = "STRP4")]
+ public string? Strp4 { get; set; }
+
+ /// <summary>
+ /// 瀛楁5
+ ///</summary>
+ [SugarColumn(ColumnName = "STRP5")]
+ public string? Strp5 { get; set; }
+
+ /// <summary>
+ /// 瀛楁6
+ ///</summary>
+ [SugarColumn(ColumnName = "STRP6")]
+ public string? Strp6 { get; set; }
+
+ /// <summary>
+ /// 瀛楁7
+ ///</summary>
+ [SugarColumn(ColumnName = "STRP7")]
+ public string? Strp7 { get; set; }
+
+ /// <summary>
+ /// 瀛楁8
+ ///</summary>
+ [SugarColumn(ColumnName = "STRP8")]
+ public string? Strp8 { get; set; }
+
+ /// <summary>
+ /// 瀛楁9
+ ///</summary>
+ [SugarColumn(ColumnName = "STRP9")]
+ public string? Strp9 { get; set; }
+
+ /// <summary>
+ /// 瀛楁10
+ ///</summary>
+ [SugarColumn(ColumnName = "STRP10")]
+ public string? Strp10 { get; set; }
+
+ /// <summary>
+ /// 瀛楁11
+ ///</summary>
+ [SugarColumn(ColumnName = "STRP11")]
+ public string? Strp11 { get; set; }
+
+ /// <summary>
+ /// 瀛楁12
+ ///</summary>
+ [SugarColumn(ColumnName = "STRP12")]
+ public string? Strp12 { get; set; }
+
+ /// <summary>
+ /// 瀛楁13
+ ///</summary>
+ [SugarColumn(ColumnName = "STRP13")]
+ public string? Strp13 { get; set; }
+
+ /// <summary>
+ /// 瀛楁14
+ ///</summary>
+ [SugarColumn(ColumnName = "STRP14")]
+ public string? Strp14 { get; set; }
+
+ /// <summary>
+ /// 瀛楁15
+ ///</summary>
+ [SugarColumn(ColumnName = "STRP15")]
+ public string? Strp15 { get; set; }
+
+ /// <summary>
+ /// 瀛楁16
+ ///</summary>
+ [SugarColumn(ColumnName = "STRP16")]
+ public string? Strp16 { get; set; }
+
+ /// <summary>
+ /// 瀛楁17
+ ///</summary>
+ [SugarColumn(ColumnName = "STRP17")]
+ public string? Strp17 { get; set; }
+
+ /// <summary>
+ /// 瀛楁18
+ ///</summary>
+ [SugarColumn(ColumnName = "STRP18")]
+ public string? Strp18 { get; set; }
+
+ /// <summary>
+ /// 瀛楁19
+ ///</summary>
+ [SugarColumn(ColumnName = "STRP19")]
+ public string? Strp19 { get; set; }
+
+ /// <summary>
+ /// 瀛楁20
+ ///</summary>
+ [SugarColumn(ColumnName = "STRP20")]
+ public string? Strp20 { get; set; }
+
+ /// <summary>
+ /// 鐢熸垚鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName = "CREATE_DATE")]
+ public DateTime? CreateDate { get; set; }
+ }
+}
\ No newline at end of file
diff --git a/MES.Service/Modes/Organize.cs b/MES.Service/Modes/Organize.cs
new file mode 100644
index 0000000..50d4342
--- /dev/null
+++ b/MES.Service/Modes/Organize.cs
@@ -0,0 +1,37 @@
+锘縰sing SqlSugar;
+
+namespace MES.Service.Modes;
+
+/// <summary>
+/// </summary>
+[SugarTable("ORGANIZE")]
+public class Organize
+{
+ /// <summary>
+ ///
+ /// </summary>
+ [SugarColumn(ColumnName = "ID")]
+ public decimal? Id { get; set; }
+
+ /// <summary>
+ /// 缁勭粐鑻辨枃
+ /// </summary>
+ [SugarColumn(ColumnName = "FNUMBER")]
+ public string Fnumber { get; set; }
+
+ /// <summary>
+ /// 缁勭粐鍚�
+ /// </summary>
+ [SugarColumn(ColumnName = "FNAME")]
+ public string Fname { get; set; }
+
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "FFORBIDSTATUS")]
+ public string Fforbidstatus { get; set; }
+
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "TYPE")]
+ public string Type { get; set; }
+}
\ No newline at end of file
diff --git a/MES.Service/service/BasicData/MesItemsManager.cs b/MES.Service/service/BasicData/MesItemsManager.cs
index 2d42a7b..321b39a 100644
--- a/MES.Service/service/BasicData/MesItemsManager.cs
+++ b/MES.Service/service/BasicData/MesItemsManager.cs
@@ -1,4 +1,5 @@
锘縰sing MES.Service.DB;
+using MES.Service.Dto.service;
using MES.Service.Dto.webApi;
using MES.Service.Modes;
using SqlSugar;
@@ -7,6 +8,14 @@
public class MesItemsManager : Repository<MesItems>
{
+ public MesItems GetItemQcPrint(WarehouseQuery query)
+ {
+ return Db.Queryable<MesItems>()
+ .Where(c => c.Factory == query.Factory
+ && c.Company == query.Company
+ && c.ItemNo == query.ItemNo).First();
+ }
+
public bool Save(ErpItems item)
{
var entity = GetMesItems(item);
diff --git a/MES.Service/service/Warehouse/OrganizeService.cs b/MES.Service/service/Warehouse/OrganizeService.cs
new file mode 100644
index 0000000..817525d
--- /dev/null
+++ b/MES.Service/service/Warehouse/OrganizeService.cs
@@ -0,0 +1,261 @@
+锘縰sing System.Data;
+using MES.Service.DB;
+using MES.Service.Dto.service;
+using MES.Service.Modes;
+using SqlSugar;
+using DbType = System.Data.DbType;
+
+namespace MES.Service.service.Warehouse;
+
+public class OrganizeService : RepositoryNoEntity
+{
+ public List<Organize> GetOrganizes()
+ {
+ return Db.Queryable<Organize>()
+ .GroupBy(s => new
+ {
+ s.Fname, s.Fnumber
+ }).Select<Organize>(s => new Organize
+ {
+ Fname = s.Fname,
+ Fnumber = s.Fnumber,
+ Id = SqlFunc.AggregateMax(s.Id)
+ }).ToList();
+ }
+
+ public List<MesRfPrnbarcode> GetBarcodeQcok(WarehouseQuery query)
+ {
+ var printCommandResult = Db.Queryable<MesBarcodeType>()
+ .Where(t => t.TypeCode == 108)
+ .First();
+ if (printCommandResult == null)
+ {
+ throw new Exception("妯＄増ID涓虹┖锛岃璁剧疆鎵撳嵃鏍煎紡锛�");
+ }
+
+ var cPrintCommand = printCommandResult.Mbtype;
+ var cBid = printCommandResult.Id;
+
+ var cMesItems = Db.Queryable<MesItems>()
+ .Where(s =>
+ s.ItemNo == query.ItemNo && s.Factory == "1000" &&
+ s.Company == "1000")
+ .First();
+ if (cMesItems == null)
+ {
+ throw new Exception("鐗╂枡淇℃伅涓嶅瓨鍦ㄨ鐗╂枡缂栫爜锛岃缁存姢锛�");
+ }
+
+ if (string.IsNullOrEmpty(query.ItemNo))
+ {
+ throw new Exception("璇峰綍鍏ョ墿鏂欑紪鐮�");
+ }
+
+ if (string.IsNullOrEmpty(query.ItemModel))
+ {
+ throw new Exception("璇疯緭鍏ュ畬鐗╂枡缂栫爜鍚庯紝鐐瑰嚮纭鐢熸垚瑙勬牸锛�");
+ }
+
+ if (string.IsNullOrEmpty(query.OrgName))
+ {
+ throw new Exception("璇峰綍鍏ョ粍缁�");
+ }
+
+ if (string.IsNullOrEmpty(query.OrgOwner))
+ {
+ throw new Exception("璇峰綍鍏ヨ揣涓�");
+ }
+
+ if (string.IsNullOrEmpty(query.ItemNum))
+ {
+ throw new Exception("璇峰綍鍏ョ墿鏂欐暟閲�");
+ }
+
+ if (string.IsNullOrEmpty(query.Printnumn))
+ {
+ throw new Exception("璇峰綍鍏ユ潯鐮佹暟閲�");
+ }
+
+ var cId =
+ Db.Ado.GetInt(
+ "SELECT F_GETSEQNEXTVALUE('MES_RF_PRNBARCODE') FROM DUAL");
+
+ string itemBarcode = null;
+ try
+ {
+ Db.Ado.BeginTran();
+ //鍒犻櫎10澶╁墠鐨勮祫鏂欙紝闃叉琛ㄨ繃澶�
+ Db.Deleteable<MesRfPrnbarcode>()
+ .Where(it => it.CreateDate < DateTime.Now.AddDays(-10))
+ .ExecuteCommand();
+
+ for (int i = 1; i <= int.Parse(query.Printnumn); i++)
+ {
+ var cIndate = DateTime.Now.ToString("yyyyMMdd");
+
+ string serial = null;
+ string poBarcodeComand = null;
+ string cBarcode2 = null;
+ if (Db.Ado.GetInt(
+ "SELECT GETSYSLOOKUPVALUE('1000', '1000', 'ItemBarcodeType') FROM DUAL") ==
+ 0)
+ {
+ var barcodeResult = SpGetBarcode2("1000", "1000", cBid,
+ query.ItemNo + cIndate, query.ItemNo + cIndate, 0);
+ serial = barcodeResult.Value;
+ poBarcodeComand = barcodeResult.Msg;
+ if (!string.IsNullOrEmpty(poBarcodeComand))
+ {
+ return null;
+ }
+
+ cBarcode2 = "9" + serial.Substring(1);
+ itemBarcode = query.ItemNo + cIndate + cBarcode2;
+ }
+ else
+ {
+ itemBarcode = Db.Queryable<MesInvItemBarcodes>()
+ .Where(s =>
+ s.LotNo == cIndate && s.ItemNo == query.ItemNo &&
+ s.TrLotno == cIndate &&
+ s.Mblnr == null && s.Memo == "鍒濆搴撳瓨" &&
+ s.Factory == "1000" && s.Company == "1000")
+ .Select(s => s.ItemBarcode)
+ .First();
+ if (string.IsNullOrEmpty(itemBarcode))
+ {
+ var barcodeResult = SpGetBarcode2("1000", "1000", cBid,
+ query.ItemNo + cIndate, query.ItemNo + cIndate, 0);
+ serial = barcodeResult.Value;
+ poBarcodeComand = barcodeResult.Msg;
+ if (!string.IsNullOrEmpty(poBarcodeComand))
+ {
+ return null;
+ }
+
+ cBarcode2 = "9" + serial.Substring(1);
+ itemBarcode = query.ItemNo + cIndate +
+ cBarcode2;
+ }
+ }
+
+ var poBarcode = itemBarcode;
+
+ // Check if barcode exists
+ var cCount = Db.Queryable<MesInvItemBarcodes>()
+ .Where(s =>
+ s.ItemBarcode == itemBarcode && s.Factory == "1000" &&
+ s.Company == "1000")
+ .Count();
+ if (cCount == 0)
+ {
+ // Insert new barcode
+ Db.Insertable(new MesInvItemBarcodes
+ {
+ ItemBarcode = poBarcode,
+ ItemNo = query.ItemNo,
+ Quantity = int.Parse(query.ItemNum),
+ CreateBy = query.userName,
+ CreateDate = DateTime.Now,
+ LastupdateBy = query.userName,
+ LastupdateDate = DateTime.Now,
+ ItemSname = cMesItems.ItemName,
+ Factory = "1000",
+ Company = "1000",
+ LotDate = DateTime.Now.ToString("yyyy-MM-dd"),
+ Memo = "鍒濆搴撳瓨",
+ OrgName = query.OrgName,
+ OrgOwner = query.OrgOwner
+ }).ExecuteCommand();
+ }
+
+ // Insert record into MES_RF_PRNBARCODE
+ Db.Insertable(new MesRfPrnbarcode
+ {
+ Id = cId,
+ Forder = "1",
+ Fno = "1",
+ CreateDate = DateTime.Now,
+ Strp1 = poBarcode,
+ Strp3 = query.ItemNo,
+ Strp4 = query.ItemName ?? " ",
+ Strp5 = query.ItemNum + " " + cMesItems.ItemUnit,
+ Strp6 = DateTime.ParseExact(cIndate, "yyyyMMdd", null)
+ .ToString("yyyy-MM-dd"),
+ Strp7 = query.ItemModel ?? " ",
+ Strp8 = poBarcode,
+ Strp9 = query.ItemModel ?? " ",
+ Strp10 = poBarcode,
+ Strp11 = poBarcode,
+ Strp12 = query.ItemName ?? " ",
+ Strp15 = query.OrgName ?? " ",
+ Strp16 = query.OrgOwner ?? " ",
+ }).ExecuteCommand();
+ }
+
+ Db.Ado.CommitTran();
+ }
+ catch (Exception ex)
+ {
+ Db.Ado.RollbackTran();
+ throw new Exception("鎶ラ敊" + ex.Message);
+ }
+
+ return Db.Queryable<MesRfPrnbarcode>()
+ .Where(s => s.Id == cId).ToList();
+ }
+
+ private dynamic SpGetBarcode2(string p0, string p1, decimal cBid,
+ string cItemNo, string cIndate, int p5)
+ {
+ try
+ {
+ // 瀹氫箟杈撳嚭鍙傛暟
+ var outputResult = new SugarParameter("PO_VALUE", null,
+ DbType.Int32, ParameterDirection.Output,
+ 4000);
+
+ var outputMessage = new SugarParameter("PO_MSG", null,
+ DbType.String,
+ ParameterDirection.Output, 4000);
+
+ // 瀹氫箟杈撳叆鍙傛暟
+ var parameters = new List<SugarParameter>
+ {
+ new("PI_FACTORY", p0,
+ DbType.String, ParameterDirection.Input),
+ new("PI_COMPANY", p1, DbType.String,
+ ParameterDirection.Input),
+ new("P_BARCODE_TYPE_ID", cBid, DbType.String,
+ ParameterDirection.Input),
+ new("P_TASK_NO", cItemNo, DbType.String,
+ ParameterDirection.Input),
+ new("P_TASK_ITEM", cIndate, DbType.String,
+ ParameterDirection.Input),
+ new("P_IF_COMMIT", p5, DbType.String,
+ ParameterDirection.Input),
+ outputResult,
+ outputMessage
+ };
+
+ // 浣跨敤 SqlSugar 鎵ц瀛樺偍杩囩▼
+ Db.Ado.ExecuteCommand(
+ "BEGIN SP_GET_BARCODE2(:PI_FACTORY, :PI_COMPANY, :P_BARCODE_TYPE_ID, :P_TASK_NO, :P_TASK_ITEM, :P_IF_COMMIT, :PO_VALUE, :PO_MSG); END;",
+ parameters.ToArray());
+
+ // 鑾峰彇杈撳嚭鍙傛暟鐨勫��
+ var resultValue = outputResult.Value?.ToString();
+ var messageValue = outputMessage.Value?.ToString();
+
+ dynamic m = new System.Dynamic.ExpandoObject();
+ m.Value = resultValue;
+ m.Msg = messageValue;
+
+ return m;
+ }
+ catch (Exception ex)
+ {
+ throw new Exception(ex.Message);
+ }
+ }
+}
\ No newline at end of file
diff --git a/MESApplication/Controllers/BasicData/MesItemsController.cs b/MESApplication/Controllers/BasicData/MesItemsController.cs
index c095307..8792e05 100644
--- a/MESApplication/Controllers/BasicData/MesItemsController.cs
+++ b/MESApplication/Controllers/BasicData/MesItemsController.cs
@@ -1,4 +1,5 @@
锘縰sing System.Dynamic;
+using MES.Service.Dto.service;
using MES.Service.Dto.webApi;
using MES.Service.Modes;
using MES.Service.service;
@@ -21,6 +22,29 @@
private readonly string TableName = "MES_ITEMS";
private readonly string URL = "http://localhost:10054/api/MesItems/";
+
+ //GetItemQcPrint
+ [HttpPost("GetItemQcPrint")]
+ public ResponseResult GetItemQcPrint(WarehouseQuery query)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ var save = m.GetItemQcPrint(query);
+ resultInfos.tbBillList = save;
+
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
[HttpPost("Save")]
public ResponseResult Save(ErpItems unit)
diff --git a/MESApplication/Controllers/Warehouse/OrganizeController.cs b/MESApplication/Controllers/Warehouse/OrganizeController.cs
new file mode 100644
index 0000000..c768452
--- /dev/null
+++ b/MESApplication/Controllers/Warehouse/OrganizeController.cs
@@ -0,0 +1,54 @@
+锘縰sing System.Dynamic;
+using MES.Service.Dto.service;
+using MES.Service.service.Warehouse;
+using MES.Service.util;
+using Microsoft.AspNetCore.Mvc;
+
+namespace MESApplication.Controllers.Warehouse;
+
+[ApiController]
+[Route("api/[controller]")]
+public class OrganizeController : ControllerBase
+{
+ private readonly OrganizeService m = new();
+
+ [HttpPost("GetOrganizes")]
+ public ResponseResult GetOrganizes()
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.GetOrganizes();
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ [HttpPost("GetBarcodeQcok")]
+ public ResponseResult GetBarcodeQcok(WarehouseQuery query)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.GetBarcodeQcok(query);
+ 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/Startup.cs b/MESApplication/Startup.cs
index 0b7bc42..50bfa25 100644
--- a/MESApplication/Startup.cs
+++ b/MESApplication/Startup.cs
@@ -111,7 +111,7 @@
app.UseEndpoints(endpoints => { endpoints.MapControllers(); });
//////////////////////////
-
+
///////////////////////////
}
}
\ No newline at end of file
--
Gitblit v1.9.3