From 175b53e6f0adb40a0d861981f56f120615d55897 Mon Sep 17 00:00:00 2001
From: wtt <1985833171@qq.com>
Date: 星期三, 13 十一月 2024 14:52:31 +0800
Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API
---
WebAPI/Controllers/SCGL/日计划管理/JIT_CompleteController..cs | 143 ++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 140 insertions(+), 3 deletions(-)
diff --git "a/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/JIT_CompleteController..cs" "b/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/JIT_CompleteController..cs"
index f5b247d..ab2a68d 100644
--- "a/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/JIT_CompleteController..cs"
+++ "b/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/JIT_CompleteController..cs"
@@ -1,4 +1,5 @@
锘縰sing DBUtility;
+using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using System;
using System.Collections.Generic;
@@ -14,6 +15,7 @@
{
private json objJsonResult = new json();
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
+ Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();
DataSet ds;
#region 榻愬鍒嗘瀽淇℃伅鏄庣粏鍒楄〃
@@ -25,16 +27,67 @@
/// <returns></returns>
[Route("JIT_Complete/JIT_CompleteDetailList")]
[HttpGet]
- public object JIT_CompleteDetailList(string sWhere, string HMainICMOEntryID)
+ public object JIT_CompleteDetailList(string sWhere, string HMainICMOEntryID,string HMainICMOInterID,string HICMOInterID)
{
try
{
- ds = oCN.RunProcReturn("select * from h_v_JIT_MOMaterReadysBill where 涓荤敓浜ц鍗曞瓙鍐呯爜 = '" + HMainICMOEntryID + "' " + sWhere + " order by 鏃ヨ鍒掓棩鏈�,鐗╂枡ID desc ", "h_v_JIT_Gy_WorkWarehouseBillList");
+ string sql = "";
+ if (HMainICMOEntryID != "-1" && HMainICMOInterID != "-1" && HICMOInterID != "-1")
+ {
+ sql = "and 涓荤敓浜ц鍗曞瓙鍐呯爜 = '" + HMainICMOEntryID + "' and 涓荤敓浜ц鍗曚富鍐呯爜='" + HMainICMOInterID + "' and 鏃ヨ鍒掕鍗曚富鍐呯爜='" + HICMOInterID + "'";
+ }
+ ds = oCN.RunProcReturn("select * from h_v_JIT_MOMaterReadysBill where 1=1 " +sql + sWhere + " order by 鏃ヨ鍒掓棩鏈�,鐗╂枡ID desc ", "h_v_JIT_MOMaterReadysBill");
objJsonResult.code = "1";
objJsonResult.count = 1;
objJsonResult.Message = "Sucess锛�";
objJsonResult.data = ds.Tables[0];
+ return objJsonResult;
+ }
+ catch (Exception e)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = e.ToString();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+ #endregion
+
+
+ #region 榻愬鐗╂枡淇℃伅鏄庣粏鍒楄〃
+ /// <summary>
+ ///
+ /// </summary>
+ /// <param name="sWhere">鏌ヨ鏉′欢</param>
+ /// <param name="HMainICMOEntryID">鐢熶骇璁㈠崟鏄庣粏琛╥d</param>
+ /// <returns></returns>
+ [Route("JIT_Complete/JIT_CompleteMaterlDetailList")]
+ [HttpGet]
+ public object JIT_CompleteMaterlDetailList(string sWhere )
+ {
+ try
+ {
+
+ ds = oCN.RunProcReturn("exec h_p_JIT_MaterDetailList " + sWhere, "h_p_JIT_MaterDetailList");
+
+
+ List<object> columnNameList = new List<object>();
+ //娣诲姞鍒楀悕
+ foreach (DataColumn col in ds.Tables[0].Columns)
+ {
+ Type dataType = col.DataType;
+ string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
+ columnNameList.Add(JsonConvert.DeserializeObject(ColmString)); //鑾峰彇鍒癉ataColumn鍒楀璞＄殑鍒楀悕
+ }
+
+
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "Sucess锛�";
+ objJsonResult.data = ds.Tables[0];
+ objJsonResult.list = columnNameList;
return objJsonResult;
}
catch (Exception e)
@@ -61,7 +114,91 @@
{
try
{
- ds = oCN.RunProcReturn("select * from h_v_JIT_MOMaterReadysBill where 鐗╂枡ID = '" + HMaterID + "' " + sWhere + " ORDER BY 鏃ヨ鍒掓棩鏈� ASC,鍙敤鏁伴噺 DESC,鐢熶骇杞﹂棿 ", "h_v_JIT_Gy_WorkWarehouseBillList");
+ ds = oCN.RunProcReturn("select * from h_v_JIT_MOMaterReadysBill where 鐗╂枡ID = '" + HMaterID + "' " + sWhere + " ORDER BY 鏃ヨ鍒掓棩鏈� ASC,鍙敤鏁伴噺 DESC,鐢熶骇杞﹂棿 ", "h_v_JIT_MOMaterReadysBill");
+
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "Sucess锛�";
+ objJsonResult.data = ds.Tables[0];
+ return objJsonResult;
+ }
+ catch (Exception e)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = e.ToString();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+ #endregion
+
+ #region 鍗虫椂搴撳瓨鍒楄〃
+ /// <summary>
+ ///
+ /// </summary>
+ /// <param name="sWhere">鏌ヨ鏉′欢</param>
+ /// <returns></returns>
+ [Route("JIT_Complete/JIT_InventoryList")]
+ [HttpGet]
+ public object JIT_InventoryList(string sWhere)
+ {
+ try
+ {
+
+ string Ret = "";
+ oSystemParameter.ShowBill(ref Ret);
+
+ if (oSystemParameter.omodel.WMS_CampanyName == "鍑礉濂堢壒")
+ {
+ ds = oCN.RunProcReturn("select top 1000 * from h_v_STK_Inventory where 1=1 " + sWhere + "", "h_v_STK_Inventory");
+ }
+ else
+ {
+ ds = oCN.RunProcReturn("select * from h_v_STK_Inventory where 1=1 " + sWhere + "", "h_v_STK_Inventory");
+ }
+
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "Sucess锛�";
+ objJsonResult.data = ds.Tables[0];
+ return objJsonResult;
+ }
+ catch (Exception e)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = e.ToString();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+ #endregion
+
+ #region 榻愬鍒嗘瀽鎶ヨ〃
+ public class ReportMOMaterReadysBill
+ {
+ public int? HORGID;//缁勭粐
+ public int? HMATERIALID;//鐗╂枡
+ public int? HDeptID;//鐢熶骇杞﹂棿
+ public int? HSCZYID;//鐢熶骇璧勬簮
+ public string HXQD;//闇�姹傚崟鍙�
+ public string HMOBILLNO;//鐢熶骇璁㈠崟鍙�
+ }
+ /// <summary>
+ ///
+ /// </summary>
+ /// <returns></returns>
+ [Route("JIT_Complete/ReportMOMaterReadysBillList")]
+ [HttpGet]
+ public object ReportMOMaterReadysBillList(string sWhere)
+ {
+ try
+ {
+
+ ReportMOMaterReadysBill Report = JsonConvert.DeserializeObject<ReportMOMaterReadysBill>(sWhere);
+
+ ds = oCN.RunProcReturn($"exec PR_Complete_Report '{Report.HXQD}','{Report.HMOBILLNO}',{Report.HORGID},{Report.HDeptID},{Report.HSCZYID},{Report.HMATERIALID}", "PR_Complete_Report");
objJsonResult.code = "1";
objJsonResult.count = 1;
--
Gitblit v1.9.1