智云MES后端API代码
parent: 8abaa814 | 补丁 | 提交 | ignore whitespace
王 垚
2022-09-08 0ca6d52415eafec449e74fa346724bdf3d1a56fc 
代码提交
1个文件已修改
34 ■■■■■ 已修改文件
WebAPI/Controllers/LMESController.cs 34 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 
 WebAPI/Controllers/LMESController.cs


@@ -60,14 +60,14 @@


            try


            {


                //判断是否有查询权限


                if (!DBUtility.ClsPub.Security_Log("Sc_ProcessExchangeBill_Query", 1, false, user))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无查询权限!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                //if (!DBUtility.ClsPub.Security_Log("Sc_ProcessExchangeBill_Query", 1, false, user))


                //{


                //    objJsonResult.code = "0";


                //    objJsonResult.count = 0;


                //    objJsonResult.Message = "无查询权限!";


                //    objJsonResult.data = null;


                //    return objJsonResult;


                //}




                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();


                ds = oCN.RunProcReturn("select * from h_v_Sc_ProcessExchangeBillQuery where 1 = 1 " + sWhere+ " order by hmainid desc ", "h_v_Sc_ProcessExchangeBillQuery");


@@ -140,15 +140,15 @@


            DataSet ds;


            try


            {


                //判断是否有查询权限


                if (!DBUtility.ClsPub.Security_Log("Sc_ProcessExchangeBill_Query", 1, false, user))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无查询权限!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                ////判断是否有查询权限


                //if (!DBUtility.ClsPub.Security_Log("Sc_ProcessExchangeBill_Query", 1, false, user))


                //{


                //    objJsonResult.code = "0";


                //    objJsonResult.count = 0;


                //    objJsonResult.Message = "无查询权限!";


                //    objJsonResult.data = null;


                //    return objJsonResult;


                //}


                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();


                ds = oCN.RunProcReturn("select * from h_v_Sc_ProcessExchangeIssueBillQuery where 1 = 1 " + sWhere + " order by hmainid desc ", "h_v_Sc_ProcessExchangeIssueBillQuery");


                objJsonResult.code = "1";