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/SBGL/Sb_EquipDotCheckPlanBillController.cs |   75 ++++++++++++++++++++++---------------
 1 files changed, 44 insertions(+), 31 deletions(-)

diff --git a/WebAPI/Controllers/SBGL/Sb_EquipDotCheckPlanBillController.cs b/WebAPI/Controllers/SBGL/Sb_EquipDotCheckPlanBillController.cs
index b36ced9..245bd93 100644
--- a/WebAPI/Controllers/SBGL/Sb_EquipDotCheckPlanBillController.cs
+++ b/WebAPI/Controllers/SBGL/Sb_EquipDotCheckPlanBillController.cs
@@ -20,10 +20,19 @@
         /// <returns></returns>
         [Route("Sb_EquipDotCheckPlanBill/GetEquipDotCheckPlanBillList")]
         [HttpGet]
-        public object GetEquipDotCheckPlanBillList(string sWhere)
+        public object GetEquipDotCheckPlanBillList(string sWhere,string user)
         {
             try
             {
+                if (!DBUtility.ClsPub.Security_Log("Sb_EquipDotCheckPlanBillList", 1, false, user))
+                {
+                    objJsonResult.code = "0";
+                    objJsonResult.count = 0;
+                    objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒";
+                    objJsonResult.data = null;
+                    return objJsonResult;
+                }
+
                 if (sWhere == null || sWhere.Equals(""))
                 {
                     ds = oCN.RunProcReturn("select * from h_v_Sb_EquipDotCheckPlanBillList " + sWhere + " order by hmainid desc", "h_v_Sb_EquipDotCheckPlanBillList");
@@ -34,28 +43,23 @@
                     string sql = sql1 + sWhere + " order by hmainid desc";
                     ds = oCN.RunProcReturn(sql, "h_v_Sb_EquipDotCheckPlanBillList");
                 }
-                if (ds == null || ds.Tables[0].Rows.Count == 0)
-                {
-                    objJsonResult.code = "0";
-                    objJsonResult.count = 0;
-                    objJsonResult.Message = "娌℃湁浣犺鎵剧殑璁板綍锛�";
-                    objJsonResult.data = null;
-                    return objJsonResult;
-                }
-                else
-                {
-                    objJsonResult.code = "1";
-                    objJsonResult.count = 1;
-                    objJsonResult.Message = "杩斿洖璁板綍鎴愬姛锛�";
-                    objJsonResult.data = ds.Tables[0];
-                    return objJsonResult;
-                }
-                //ds = Sb_EquipDotCheckPlanBillList_s(sWhere);
-                //objJsonResult.code = "1";
-                //objJsonResult.count = 1;
-                //objJsonResult.Message = "杩斿洖璁板綍鎴愬姛锛�";
-                //objJsonResult.data = ds.Tables[0];
+
+                //if (ds.Tables[0].Rows.Count != 0 || ds != null)
+                //{
+                objJsonResult.code = "1";
+                objJsonResult.count = 1;
+                objJsonResult.Message = "Sucess锛�";
+                objJsonResult.data = ds.Tables[0];
+                return objJsonResult;
+                //}
+                //else
+                //{
+                //objJsonResult.code = "0";
+                //objJsonResult.count = 0;
+                //objJsonResult.Message = "鏃犳暟鎹�";
+                //objJsonResult.data = null;
                 //return objJsonResult;
+                //}
             }
             catch (Exception ex)
             {
@@ -91,12 +95,21 @@
             string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
             string msg2 = sArray[0].ToString();
             string msg3 = sArray[1].ToString();
+            string msg4 = sArray[2].ToString();
 
 
             string UserName = "";
             ListModels oListModels = new ListModels();
             try
             {
+                if (!DBUtility.ClsPub.Security_Log("Sb_EquipDotCheckPlanBill_Edit", 1, false, msg4))
+                {
+                    objJsonResult.code = "0";
+                    objJsonResult.count = 0;
+                    objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒";
+                    objJsonResult.data = null;
+                    return objJsonResult;
+                }
                 DAL.ClsSb_EquipDotCheckPlanBill oBill = new DAL.ClsSb_EquipDotCheckPlanBill();
                 List<Model.ClsSb_EquipDotCheckPlanBillMain> lsmain = new List<Model.ClsSb_EquipDotCheckPlanBillMain>();
                 msg2 = msg2.Replace("\\", "");
@@ -215,17 +228,17 @@
         /// <returns></returns>
         [Route("Sb_EquipDotCheckPlanBill/DeltetEquipDotCheckPlanBillList")]
         [HttpGet]
-        public object DeltetEquipDotCheckPlanBillList(string HInterID)
+        public object DeltetEquipDotCheckPlanBillList(string HInterID,string user)
         {
             //缂栬緫鏉冮檺
-            //if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBill_Delete", 1, true, DBUtility.ClsPub.CurUserName))
-            //{
-            //    objJsonResult.code = "0";
-            //    objJsonResult.count = 0;
-            //    objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒";
-            //    objJsonResult.data = null;
-            //    return objJsonResult;
-            //}
+            if (!DBUtility.ClsPub.Security_Log("Sb_EquipDotCheckPlanBill_Delete", 1, false, user))
+            {
+                objJsonResult.code = "0";
+                objJsonResult.count = 0;
+                objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒";
+                objJsonResult.data = null;
+                return objJsonResult;
+            }
 
 
             Int64 lngBillKey = 0;

--
Gitblit v1.9.1