From cfe1773e9d576a93e1ec6e3425468e6361f98f63 Mon Sep 17 00:00:00 2001 From: duhe <226547893@qq.com> Date: 星期五, 10 十一月 2023 11:21:55 +0800 Subject: [PATCH] 生产订单变更单:反写销售订单数据改为使用存储过程反写 --- PlanM/计划管理/Gy_RoutingBillList.cs | 7 ++++++- 1 files changed, 6 insertions(+), 1 deletions(-) diff --git "a/PlanM/\350\256\241\345\210\222\347\256\241\347\220\206/Gy_RoutingBillList.cs" "b/PlanM/\350\256\241\345\210\222\347\256\241\347\220\206/Gy_RoutingBillList.cs" index 564de88..f9032a6 100644 --- "a/PlanM/\350\256\241\345\210\222\347\256\241\347\220\206/Gy_RoutingBillList.cs" +++ "b/PlanM/\350\256\241\345\210\222\347\256\241\347\220\206/Gy_RoutingBillList.cs" @@ -46,7 +46,7 @@ //杩囨护鏉′欢 if (frmCondition.SqlStr.Trim().Length == 0) return; - sSql = frmCondition.SqlStr + sWhere + " order by 鍗曟嵁鍙� desc,hsubid "; + sSql = frmCondition.SqlStr + sWhere + " and HPRDORGID='"+DBUtility.ClsPub.HOrgID.ToString()+"' order by 鍗曟嵁鍙� desc,hsubid "; // DSet = SubCn.RunProcReturn(sSql, ViewName, ref DBUtility.ClsPub.sExeReturnInfo); //鐢熸垚棣栬鏍囬 @@ -438,6 +438,11 @@ private void sy_Click(object sender, EventArgs e) { long sOldInterID = 0; + //鍒ゆ柇鏉冮檺 + if (!ClsPub.Security_Log(ModRightNameCheck, 1, true, DBUtility.ClsPub.CurUserName)) + { + return; + } for (int i = 0; i <= grdMain.SelectedRows.Count - 1; i++) { long HInterID = DBUtility.ClsPub.isLong(grdMain.SelectedRows[i].Cells[Fun_GetCol("HMainID")].Value); -- Gitblit v1.9.1