From 797b531dda2a48d3011657db03b9af205c615a27 Mon Sep 17 00:00:00 2001
From: 况洋洋 <3283105747@qq.com>
Date: 星期四, 10 七月 2025 11:30:20 +0800
Subject: [PATCH] 入库前拆分
---
service/Warehouse/MesInvItemInCDetailsManager.cs | 65 +++++++++++++++++++++++++++++---
1 files changed, 59 insertions(+), 6 deletions(-)
diff --git a/service/Warehouse/MesInvItemInCDetailsManager.cs b/service/Warehouse/MesInvItemInCDetailsManager.cs
index 648e17b..8749729 100644
--- a/service/Warehouse/MesInvItemInCDetailsManager.cs
+++ b/service/Warehouse/MesInvItemInCDetailsManager.cs
@@ -1,4 +1,5 @@
-锘縰sing Masuit.Tools.Models;
+锘縰sing Masuit.Tools;
+using Masuit.Tools.Models;
using NewPdaSqlServer.DB;
using NewPdaSqlServer.Dto.service;
using NewPdaSqlServer.entity;
@@ -7,6 +8,8 @@
using NewPdaSqlServer.util;
using Newtonsoft.Json;
using SqlSugar;
+using System.Data;
+using System.Data.SqlClient;
using static Microsoft.EntityFrameworkCore.DbLoggerCategory;
namespace NewPdaSqlServer.service.Warehouse;
@@ -14,6 +17,56 @@
public class MesInvItemInCDetailsManager : Repository<MesInvItemInCDetails>
{
//褰撳墠绫诲凡缁忕户鎵夸簡 Repository 澧炪�佸垹銆佹煡銆佹敼鐨勬柟娉�
+
+
+ // public ItemInBaseModel SaveBarCodes(WarehouseQuery entity)
+ // {
+ // var _strMsg = "";
+ // var _intSum = "";
+ // using (var conn = new SqlConnection(DbHelperSQL.strConn))
+ // {
+ // if (entity.userName.IsNullOrEmpty()) throw new Exception("鐢ㄦ埛鍚嶄笉鍏佽涓虹┖");
+ // if (entity.sectionCode.IsNullOrEmpty()) throw new Exception("搴撲綅缂栧彿涓嶅厑璁镐负绌�");
+ // if (entity.barcode.IsNullOrEmpty()) throw new Exception("鏉＄爜涓嶅厑璁镐负绌�");
+ // if (entity.cgrkType.IsNullOrEmpty()) throw new Exception("閲囪喘鍏ュ簱绫诲瀷涓嶅厑璁镐负绌�");
+
+ // using (var cmd = new SqlCommand("[prc_pda_inv_cgrk]", conn))
+ // {
+ // try
+ // {
+ // conn.Open();
+ // cmd.CommandType = CommandType.StoredProcedure;
+ // SqlParameter[] parameters =
+ // {
+ // new("@pi_user", SqlDbType.NVarChar, 100) { Value = entity.userName },
+ // new("@pi_barcode", SqlDbType.NVarChar, 100) { Value = entity.barcode },
+ // new("@pi_cgrkType", SqlDbType.NVarChar, 30) { Value = entity.cgrkType },
+ // new("@po_outMsg", SqlDbType.NVarChar, 300),
+ // new("@po_outSum", SqlDbType.NVarChar, 300)
+ //};
+
+ // foreach (var parameter in parameters)
+ // cmd.Parameters.Add(parameter);
+ // cmd.ExecuteNonQuery();
+ // _strMsg = parameters[4].Value.ToString();
+ // _intSum = parameters[5].Value.ToString();
+
+ // var result = Convert.ToInt32(_intSum);
+ // if (result <= 0) throw new Exception(_strMsg);
+
+ // return _strMsg;
+ // }
+ // catch (Exception ex)
+ // {
+ // throw new Exception(ex.Message);
+ // }
+ // finally
+ // {
+ // conn.Close();
+ // }
+ // }
+ // }
+ // }
public ItemInBaseModel SaveBarCodes(WarehouseQuery entity)
{
@@ -40,7 +93,7 @@
throw new Exception("姝ゆ潯鐮佷笉灞炰簬鍒拌揣鏉＄爜锛屾棤娉曠敤閲囪喘鍏ュ簱锛�");
var inventory = Db.Queryable<MesInvItemArn>()
- .Where(it => it.BillNo == itemBarcodeDetails.BillNo && it.Fstatus == true )
+ .Where(it => it.BillNo == itemBarcodeDetails.BillNo && it.Fstatus == true)
.First();
if (inventory == null)
@@ -69,7 +122,7 @@
var sql1 = @"SELECT *FROM v_dhmx WHERE dhmxGuid = @dhmxGuid ";
var dhjymx = Db.Ado.SqlQuery<vDhmx>(sql1, sqlParams).First();
//鍒ゅ畾妫�楠岃兘鍚﹀叆搴�
- if (dhjymx.CanStore!= 1)
+ if (dhjymx.CanStore != 1)
{
throw new Exception($"璇ユ潯鐮佸搴旂殑鏀舵枡鍗曟楠岀粨鏋�:銆恵dhjymx.InspectionResult}銆�,鍒ゅ畾缁撴灉锛氥�恵dhjymx.JudgmentResult}銆戯紝澶勭悊鎰忚锛氥�恵dhjymx.HandlingSuggestion}銆�,鏃犳硶鍏ュ簱");
}
@@ -758,13 +811,13 @@
result.itemDetail = mesItems;
- result.ItemInDetails = db.Queryable<MesInvItemInCItems,MesItems>(
+ result.ItemInDetails = db.Queryable<MesInvItemInCItems, MesItems>(
(a, b) => new JoinQueryInfos(
JoinType.Left,
a.ItemId == b.ItemId)
)
.Where(a => a.ItemInId == cId && a.ItemId == itemBarcodeDetails.ItemId)
- .Select<dynamic>((a, b) => new
+ .Select<dynamic>((a, b) => new
{
ItemNo = b.ItemNo,
ItemName = b.ItemName,
@@ -871,7 +924,7 @@
var purchaseInventory = getPurchaseInventory(entity);
-
+
//result.ItemInDetails = purchaseInventory.ItemInDetails;
//result.InvItemInCDetails = purchaseInventory.InvItemInCDetails;
--
Gitblit v1.9.3