From ab7c79d12c1fdd8b4046b7e7616e730df71f50a2 Mon Sep 17 00:00:00 2001
From: wangyi <2946747746@qq.com>
Date: 星期一, 12 一月 2026 15:29:13 +0800
Subject: [PATCH] 1
---
WebAPI/Controllers/MJGL/Sc_MouldOutRequestBillController.cs | 150 ++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 150 insertions(+), 0 deletions(-)
diff --git a/WebAPI/Controllers/MJGL/Sc_MouldOutRequestBillController.cs b/WebAPI/Controllers/MJGL/Sc_MouldOutRequestBillController.cs
index a4cee17..349edb9 100644
--- a/WebAPI/Controllers/MJGL/Sc_MouldOutRequestBillController.cs
+++ b/WebAPI/Controllers/MJGL/Sc_MouldOutRequestBillController.cs
@@ -10,6 +10,7 @@
using WebAPI.Models;
using System.Windows.Forms;
using SyntacticSugar.constant;
+
namespace WebAPI.Controllers
{
@@ -792,5 +793,154 @@
+ #region 鍣ㄥ叿鍑哄簱鐢宠鍗� 淇濆瓨1
+ /// <summary>
+ /// 鍣ㄥ叿鍑哄簱鐢宠鍗曚繚瀛�
+ /// </summary>
+ [Route("Sc_MouldOutRequestBillController/GetSc_MouldOutRequestBill_Save_Json1")]
+ [HttpPost]
+ public object GetSc_MouldOutRequestBill_Save_Json1([FromBody] JObject sMainSub)
+ {
+ var _value = sMainSub["sMainSub"].ToString();
+ string msg1 = _value.ToString();
+ string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
+ string sMainStr = sArray[0].ToString(); //涓昏〃鏁版嵁
+ string sSubStr = sArray[1].ToString(); //瀛愯〃鏁版嵁
+ string sErrMsg = "";
+ string HBillNo = "";
+ HBillNo = DBUtility.ClsPub.CreateBillCode_Prod("3849", ref sErrMsg, true);
+
+ try
+ {
+ //琛ㄥご璧嬪��
+ sMainStr = sMainStr.Replace("\\", "");
+ sMainStr = sMainStr.Replace("\n", "");
+ sMainStr = "[" + sMainStr.ToString() + "]";
+ List<Model.ClsSc_MouldOutRequestBillMain> lsmain = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_MouldOutRequestBillMain>>(sMainStr);
+ foreach (Model.ClsSc_MouldOutRequestBillMain oItem in lsmain)
+ {
+ //鍗曟嵁鍙锋槸鍚﹂噸澶�
+ if (oBill.IsExistBillNo(ref ClsPub.sExeReturnInfo, HBillNo, BillStatus, oItem.HInterID))
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鍗曟嵁鍙烽噸澶嶏紒涓嶅厑璁镐繚瀛橈紒";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ //鍒ゆ柇浼氳鏈熸槸鍚﹀悎鐞�
+ string s = "";
+ int sYear = 0;
+ int sPeriod = 0;
+ oItem.HDate = DateTime.Now;
+ if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(oItem.HDate, ref sYear, ref sPeriod, ref s) == false)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = s;
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+
+ oItem.HYear = sYear;
+ oItem.HPeriod = sPeriod;
+ oItem.HMaker = "閽夐拤";
+ oItem.HRemark = "閽夐拤鏁版嵁鍚屾鍒涘缓";
+ oItem.HBillNo = HBillNo;
+ oItem.HSTOCKORGID = 100038;
+ oItem.HSupTypeID = 1;
+ oBill.omodel = oItem;
+ DBUtility.ClsPub.CurUserName = oItem.HMaker;
+
+ }
+ //琛ㄤ綋璧嬪��
+ //鎸� },{鏉ユ媶鍒嗘暟缁� //鍘绘帀銆愬拰銆�
+ sSubStr = sSubStr.Substring(1, sSubStr.Length-2);
+ sSubStr = sSubStr.Replace("\\", "");
+ sSubStr = sSubStr.Replace("\n", "");
+ sSubStr = "[" + sSubStr.ToString() + "]";
+ List<Model.ClsSc_MouldOutRequestBillSub> ls = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_MouldOutRequestBillSub>>(sSubStr);
+ int i = 0;
+ foreach (Model.ClsSc_MouldOutRequestBillSub oItemSub in ls)
+ {
+ i++;
+ oItemSub.HEntryID = i;
+ DataTable dtMould = GetMaterialByMouldNo(oItemSub.HMaterID);
+ DataRow row = dtMould.Rows[0];
+ // 浣跨敤涓夊厓杩愮畻绗﹀鐞咲BNull
+ oItemSub.HUnitID = row["HUnitID"] != DBNull.Value ? Convert.ToInt32(row["HUnitID"]) : 0;
+ oItemSub.HWHID = row["HWhID"] != DBNull.Value ? Convert.ToInt32(row["HWhID"]) : 0;
+ oItemSub.HSPID = row["HSPID"] != DBNull.Value ? Convert.ToInt32(row["HSPID"]) : 0;
+ oItemSub.HMaterID = row["hmainid"] != DBNull.Value ? Convert.ToInt32(row["hmainid"]) : 0;
+ oItemSub.HStockOrgID = 100038;
+ oItemSub.HQty = 1;
+ oBill.DetailColl.Add(oItemSub);
+ }
+
+ //淇濆瓨
+ bool bResult;
+
+ bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
+
+ if (bResult)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo; //鎴愬姛锛�
+ objJsonResult.data = null;
+ objJsonResult.HInterID = oBill.omodel.HInterID.ToString(); //杩斿洖涓籌D
+ return objJsonResult;
+ }
+ else
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "淇濆瓨澶辫触锛�" + DBUtility.ClsPub.sExeReturnInfo;
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+ catch (Exception e)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "淇濆瓨澶辫触锛�" + e.Message;
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+
+ #endregion
+
+
+
+
+ #region 鏍规嵁鍐呯爜鑾峰彇鑾峰彇鍣ㄥ叿淇℃伅
+
+ public DataTable GetMaterialByMouldNo(long HMaterID)
+ {
+ SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
+
+ string sql = @"SELECT
+ HMaterID,
+ HUnitID,
+ HWhID,
+ HSPID,
+ hmainid
+ FROM h_v_Gy_MouldFileList as a
+ WHERE a.HMaterID= '" + HMaterID + "' AND a.HBillType = '3899'";
+
+ var dataSet = oCN.RunProcReturn(sql, "h_v_Gy_MouldFileList");
+
+ if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
+ return null;
+
+ return dataSet.Tables[0];
+ }
+
+ #endregion
+
+
+
}
}
\ No newline at end of file
--
Gitblit v1.9.1