From 3db477ccda04b391872cbd570b7d1c1253e1f6e0 Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期二, 23 五月 2023 14:11:00 +0800 Subject: [PATCH] 生产订单备注字段改成白坯要求,底部备注下推流转卡的时候带到流转卡底部备注中去 生产订单 已经下推过 流转卡或 生产入库单 或生产领料单 后,就不能删除; 生产资源新增模块增加 负责人 HEmpID int 字段(gy_Employee) 非必录入,打印的时候打印出来 生产订单列表里增加关闭和反关闭按钮(在生产订单编辑模块里有这个功能,将一样的功能复制出来),列表显示关闭状态 工序流转卡维护列表增加当前工序过滤条件(下拉框形式,取值取工序列表) 网格选中行, 背景行 浅蓝色 显示;(优先改 生产订单列表,流转卡列表,出站单列表,进站单列表)(最好改JS底层方法) --- WebAPI/Controllers/PublicPageMethodController.cs | 36 +++++++++++++++++++++++++++++++----- 1 files changed, 31 insertions(+), 5 deletions(-) diff --git a/WebAPI/Controllers/PublicPageMethodController.cs b/WebAPI/Controllers/PublicPageMethodController.cs index 2c8564e..80faac1 100644 --- a/WebAPI/Controllers/PublicPageMethodController.cs +++ b/WebAPI/Controllers/PublicPageMethodController.cs @@ -3410,7 +3410,7 @@ #region 鏉′欢鏌ヨ鏉冮檺鍒楄〃 [Route("PublicPageMethod/PowerList")] [HttpGet] - public object PowerList(string czybm, string sGnbm) + public object PowerList(string czybm, string sGnbm,string HSouceBillType) { try { @@ -3426,10 +3426,17 @@ sName = sGnbm; } } + if (HSouceBillType == "yh") + { + ds = oCN.RunProcReturn("select * from Gy_Czygl where czybm='" + czybm + "'", "Gy_Czygl"); + } + else if (HSouceBillType == "js") + { + ds = oCN.RunProcReturn("select * from System_UserGroup where GroupID='" + czybm + "'", "System_UserGroup"); + } - ds = oCN.RunProcReturn("select * from Gy_Czygl where czybm='" + czybm + "'", "Gy_Czygl"); string AuthorityID = ClsPub.isStrNull(ds.Tables[0].Rows[0]["AuthorityID"]); - ds = oCN.RunProcReturn("SELECT id hid,case when id<=" + AuthorityID.Length + " then case when SUBSTRING('" + AuthorityID + "',id,1)=1 then 1 else 0 end else 0 end AuthorityID,'' AuthorityHID, gnms ,gnbm hgnbm FROM xt_xtgnb where useflag=1 and sjgnbm='" + sName + "' and rightflag=1 order by gnbm", "xt_xtgnb"); + ds = oCN.RunProcReturn("SELECT id hid,case when id<=" + AuthorityID.Length + " then case when SUBSTRING('" + AuthorityID + "',id,1)=1 then 1 else 0 end else 0 end AuthorityID,case when id<=" + AuthorityID.Length + " then case when SUBSTRING('" + AuthorityID + "',id,1)=1 then 1 else 0 end else 0 end AuthorityHID, gnms ,gnbm hgnbm FROM xt_xtgnb where useflag=1 and sjgnbm='" + sName + "' and rightflag=1 order by gnbm", "xt_xtgnb"); if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; @@ -3503,6 +3510,7 @@ string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); string msg4 = sArray[2].ToString(); + string HSouceBillType = sArray[3].ToString(); ListModels oListModels = new ListModels(); try { @@ -3511,7 +3519,16 @@ msg3 = msg3.Replace("\\", ""); msg3 = msg3.Replace("\n", ""); //\n lsmain = oListModels.getObjectByJson_UserPower(msg3); - ds = oCN.RunProcReturn("select * from Gy_Czygl where czybm='" + msg4.Trim() + "'", "Gy_Czygl"); + + if (HSouceBillType == "yh") + { + ds = oCN.RunProcReturn("select * from Gy_Czygl where czybm='" + msg4.Trim() + "'", "Gy_Czygl"); + } + else if (HSouceBillType == "js") + { + ds = oCN.RunProcReturn("select * from System_UserGroup where GroupID='" + msg4 + "'", "System_UserGroup"); + } + string AuthorityID = ClsPub.isStrNull(ds.Tables[0].Rows[0]["AuthorityID"]); string Auth_str = AuthorityID; string MKID = ""; @@ -3565,7 +3582,16 @@ } oDs = null; } - oCN.RunProc("UPDATE Gy_Czygl SET AuthorityID='" + Auth_str + "' WHERE czybm='" + msg4.Trim() + "'"); + + if (HSouceBillType == "yh") + { + oCN.RunProc("UPDATE Gy_Czygl SET AuthorityID='" + Auth_str + "' WHERE czybm='" + msg4.Trim() + "'"); + } + else if (HSouceBillType == "js") + { + oCN.RunProc("UPDATE System_UserGroup SET AuthorityID='" + Auth_str + "' WHERE GroupID='" + msg4.Trim() + "'"); + } + objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "鎺堟潈鎴愬姛锛�"; -- Gitblit v1.9.1