From 1a6c5cb19353ef7b56a8bd0a0eb01b623971fd43 Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期四, 24 三月 2022 16:07:56 +0800
Subject: [PATCH] 叫料单列表 查询 退料申请单 退料确认页面列表 生产叫料平台 退料单新增 拣料配送单 删除
---
WebAPI/Controllers/SCGL/Sc_CallGoodsBackRequestBillController.cs | 131 +++++++++++++++++++++++++++++++++++++++++++
1 files changed, 130 insertions(+), 1 deletions(-)
diff --git a/WebAPI/Controllers/SCGL/Sc_CallGoodsBackRequestBillController.cs b/WebAPI/Controllers/SCGL/Sc_CallGoodsBackRequestBillController.cs
index bc179df..3381916 100644
--- a/WebAPI/Controllers/SCGL/Sc_CallGoodsBackRequestBillController.cs
+++ b/WebAPI/Controllers/SCGL/Sc_CallGoodsBackRequestBillController.cs
@@ -5,6 +5,8 @@
using Newtonsoft.Json;
using DBUtility;
using System;
+using Newtonsoft.Json.Linq;
+using System.Collections.Generic;
namespace WebAPI.Controllers.SCGL
{
@@ -37,7 +39,7 @@
try
{
//鏌ョ湅鏉冮檺
- if (!DBUtility.ClsPub.Security_Log("JIT_ComplementGoods", 1, false, user))
+ if (!DBUtility.ClsPub.Security_Log("JIT_ComplementGoods_Query", 1, false, user))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
@@ -111,5 +113,132 @@
}
}
#endregion
+
+ #region 閫�鏂欑敵璇峰崟 閫�鏂欑‘璁ら〉闈㈠垪琛�
+ [Route("Sc_CallGoodsBackRequestBill/JIT_BackGoodsList")]
+ [HttpGet]
+ public object JIT_BackGoodsList(string HInterID, string user)
+ {
+ try
+ {
+ ds = oCN.RunProcReturn($"exec h_p_JIT_BackGoods_Load '{HInterID}'", "h_p_JIT_BackGoods_Load");
+
+ 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 = "Exception锛�" + e.ToString();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+ #endregion
+
+ #region 閫�鏂欑‘璁� 鍝佽川纭
+ //浼犻�掑弬鏁�
+ public class JIT_BackGoods_PZQR {
+ public int? hmainid = 0;
+ public int? Hsubid = 0;
+ public int? HSupID = 0;
+ public int? HWHID = 0;
+ public string 閫�鏂欏師鍥� { get; set; }
+ public int? 閫�鍥炴暟閲� = 0;
+ }
+
+ [Route("Sc_CallGoodsBackRequestBill/JIT_BackGoodsList_PZQR")]
+ [HttpPost]
+ public object JIT_BackGoodsList_PZQR([FromBody] JObject msg)
+ {
+ var _value = msg["msg"].ToString();
+ string[] sArray = _value.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
+ string msg2 = sArray[0].ToString();
+ try
+ {
+ msg2 = msg2.Replace("\\", "");
+ msg2 = msg2.Replace("\n", "");
+
+ List<JIT_BackGoods_PZQR> listCa = new List<JIT_BackGoods_PZQR>();
+ //鑾峰彇琛ㄦ牸鏁版嵁闆嗗悎
+ listCa = JsonConvert.DeserializeObject<List<JIT_BackGoods_PZQR>>(msg2.ToString());
+
+ int a = 0;
+ for (int i = 0; i < listCa.Count; i++)
+ {
+ ds = oCN.RunProcReturn($"exec h_p_JIT_BackGoods_QACheck '{listCa[i].hmainid}','{listCa[i].Hsubid}'," +
+ $"{listCa[i].HSupID},{listCa[i].HWHID},'{listCa[i].閫�鏂欏師鍥爙',{listCa[i].閫�鍥炴暟閲弣", "h_p_JIT_BackGoods_QACheck");
+ if (ds.Tables[0].Rows[0][0].ToString() == "1")
+ {
+ a++;
+ }
+ }
+ if (a == listCa.Count)
+ {
+ objJsonResult.code = ds.Tables[0].Rows[0][0].ToString();
+ objJsonResult.count = int.Parse(ds.Tables[0].Rows[0][0].ToString());
+ objJsonResult.Message = ds.Tables[0].Rows[0][1].ToString();
+ objJsonResult.data = ds.Tables[0];
+ return objJsonResult;
+ }
+ else if(a>0&&a<listCa.Count)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鏈叏閮ㄥ搧璐ㄧ‘璁�!";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ else
+ {
+ objJsonResult.code = ds.Tables[0].Rows[0][0].ToString();
+ objJsonResult.count = int.Parse(ds.Tables[0].Rows[0][0].ToString());
+ objJsonResult.Message = ds.Tables[0].Rows[0][1].ToString();
+ objJsonResult.data = ds.Tables[0];
+ return objJsonResult;
+ }
+ }
+ catch (Exception e)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "Exception锛�" + e.ToString();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+ #endregion
+
+ #region 閫�鏂欑‘璁� 浠撳簱鎺ユ敹
+ [Route("Sc_CallGoodsBackRequestBill/JIT_BackGoodsList_CKJS")]
+ [HttpPost]
+ public object JIT_BackGoodsList_CKJS([FromBody] JObject msg)
+ {
+ var _value = msg["msg"].ToString();
+ string[] sArray = _value.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
+ string msg2 = sArray[0].ToString();
+ try
+ {
+
+ objJsonResult.code = ds.Tables[0].Rows[0][0].ToString();
+ objJsonResult.count = int.Parse(ds.Tables[0].Rows[0][0].ToString());
+ objJsonResult.Message = ds.Tables[0].Rows[0][1].ToString();
+ objJsonResult.data = ds.Tables[0];
+ return objJsonResult;
+ }
+ catch (Exception e)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "Exception锛�" + e.ToString();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+ #endregion
}
}
\ No newline at end of file
--
Gitblit v1.9.1