From 00a72adae3be35f91d3edecb50a14b691104bdb4 Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期四, 10 八月 2023 13:45:18 +0800
Subject: [PATCH] 工艺路线保存时 图号版本,总装图号,材质,成品编号,版本 改为 必录项目 jit 完善 产量汇报 删除反写 瑞琪生产入库包装标识
---
WebAPI/Controllers/基础资料/基础资料/Gy_SOPBillController.cs | 8 ++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diff --git "a/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_SOPBillController.cs" "b/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_SOPBillController.cs"
index c9a5385..e6769f8 100644
--- "a/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_SOPBillController.cs"
+++ "b/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_SOPBillController.cs"
@@ -40,7 +40,7 @@
// objJsonResult.data = null;
// return objJsonResult;
//}
- string sql1 = string.Format(@"select * from h_v_Sc_WorkOrderList where HMainID='" + sWhere + "'");
+ string sql1 = string.Format(@"select * from h_v_Sc_WorkOrderList where 寮�宸ユ爣璁� = 1 and HMainID='" + sWhere + "'");
ds = oCN.RunProcReturn(sql1, "h_v_Sc_WorkOrderList");
@@ -68,7 +68,7 @@
/// </summary>
[Route("Sc_ICMOBillStatus_Tmp/Filelist")]
[HttpGet]
- public object Filelist()
+ public object Filelist(int sWhere)
{
try
{
@@ -81,9 +81,9 @@
// objJsonResult.data = null;
// return objJsonResult;
//}
- string sql1 = string.Format(@"select HSno 搴忓彿,HFileName 鏂囦欢鍚嶇О from Gy_SOPBillSub2");
+ string sql1 = string.Format(@"select * from h_v_Sc_GetFileList where 鏂囦欢ID = " + sWhere);
- ds = oCN.RunProcReturn(sql1, "Gy_SOPBillSub2");
+ ds = oCN.RunProcReturn(sql1, "h_v_Sc_GetFileList");
objJsonResult.code = "1";
--
Gitblit v1.9.1