From 852cd93a3e65988a2354a0b96b79d5e2d05bf646 Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期五, 14 四月 2023 09:23:25 +0800
Subject: [PATCH] 工序流转卡  工艺参数 应该 可编辑; 1.生产资源 有异常; 删除有问题,删除后出来 异常数据(  );    其他信息 里的  几个字段 输入 字符时 报错,应提示; 2.工序 :  9999的 转工序 , 有个 转工序 字段,是否没显示出来; 其他信息 里的  几个字段 输入 字符时 报错,应提示; 3.工作中心:  其他信息 里的  几个字段 输入 字符时 报错,应提示; 4.生产班组: 刷新出来 异常数据;    其他信息 里的  几个字段 输入 字符时 报错,应提示; 5.基础资料的  一些 复选框 标题不对; 6. ADMIN 的账号 工艺路线 的模块 无法进行 新增 编辑; 7.工艺路线查询;工序号,工序代码,工序,工艺参数,表体备注, 其他的放后面  子表 的 委外标记 放到最后面去; 并且 把  供应商代码和供应商 放出来(也放在最后几个); 8.部门有 很多异常数据;   选择的时候 出来了; 9.流转卡维护, 表头 很多没有用的列,单据号 日期 都没有显示;     转工序 是否要打印(跟客户确认); 10. 流转卡拆分时,一些 列的 排序;

---
 WebAPI/Controllers/基础资料/基础资料/Xt_CheckFlowBillController.cs |   62 +++++++++++++++++-------------
 1 files changed, 35 insertions(+), 27 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/Xt_CheckFlowBillController.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/Xt_CheckFlowBillController.cs"
index b22ae29..9e9e8ab 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/Xt_CheckFlowBillController.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/Xt_CheckFlowBillController.cs"
@@ -126,34 +126,21 @@
                          ",HRemark,HStandard,HName" + ") " +
                          " values('" + main.HBillTypeID.ToString() + "'," + main.HInterID.ToString() + "," + main.HDeptID.ToString() +
                          ",'" + main.HRemark + "'," + Convert.ToString(main.HStandard ? 1 : 0) + ",'" + main.HName.ToString() + "') ");
-
-                    int i = 0;
-                    foreach (Xt_CheckFlowSub oSub in lsmain)
-                    {
-                        i++;
-                        bool bResult = false;
-
-                        oCN.RunProc("Insert into Xt_CheckFlowSub " +
-                                " (HInterID,HEntryID,HCheckMan" +
-                                ",HFlowNo,HJumpFlag,HMakerSelf,HCheckItemID" +
-                                " )values("
-                                + main.HInterID.ToString() + "," + i + ",'" + oSub.HCheckMan + "'" +
-                                "," + oSub.HFlowNo + "," + Convert.ToString(oSub.HJumpFlag ? 1 : 0) + "," + Convert.ToString(oSub.HMakerSelf ? 1 : 0) + "," + oSub.HCheckItemID + ") ");
-
-                        bResult = true;
-
-
-                        if (!bResult)
-                        {
-                            objJsonResult.code = "0";
-                            objJsonResult.count = 0;
-                            objJsonResult.Message = "淇濆瓨澶辫触锛�" + DBUtility.ClsPub.sExeReturnInfo;
-                            objJsonResult.data = 1;
-                            return objJsonResult;
-                        }
-
-                    }
                 }
+                else
+                {
+                    //鏇存柊涓昏〃
+                    oCN.RunProc("UpDate Xt_CheckFlowMain set  " +
+                    "HRemark='" + main.HRemark + "'" +
+                    ",HName='" + main.HName + "'" +
+                    ",HDeptID=" + main.HDeptID.ToString() +
+                    ",HBillTypeID='" + main.HBillTypeID + "'" +
+                    ",HStandard='" + Convert.ToString(main.HStandard ? 1 : 0) + "'" +
+                    " where HInterID=" + main.HInterID.ToString());
+                    //鍒犻櫎瀛愯〃
+                    oCN.RunProc("delete from Xt_CheckFlowSub where HInterID=" + main.HInterID.ToString());
+                }
+                AddBillSub(lsmain, main.HInterID);
 
                 oCN.Commit();
 
@@ -174,6 +161,27 @@
             }
         }
 
+        public json AddBillSub(List<Xt_CheckFlowSub> DetailColl, long HInterID)
+        {
+            int i = 1;
+            foreach (Xt_CheckFlowSub oSub in DetailColl)
+            {
+
+                oCN.RunProc("Insert into Xt_CheckFlowSub " +
+                             " (HInterID,HEntryID,HCheckMan" +
+                             ",HFlowNo,HJumpFlag,HMakerSelf,HCheckItemID" +
+                             " )values("
+                             + HInterID + "," + i + ",'" + oSub.HCheckMan + "'" +
+                             "," + oSub.HFlowNo + "," + Convert.ToString(oSub.HJumpFlag ? 1 : 0) + "," + Convert.ToString(oSub.HMakerSelf ? 1 : 0) + "," + oSub.HCheckItemID + ") ");
+                i++;
+            }
+            objJsonResult.code = "1";
+            objJsonResult.count = 1;
+            objJsonResult.Message = null;
+            objJsonResult.data = null;
+            return objJsonResult;
+        }
+
         #endregion
 
         #region  瀹℃牳娴佺▼鍗� 鍒犻櫎

--
Gitblit v1.9.1