blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
YL
2022-02-07 b67b1c28ef34c89cd1420ad5c414533658bc7206 
 WebAPI/Controllers/LMESController.cs


@@ -54,11 +54,21 @@


        /// </summary>


        [Route("LEMS/MES_Sc_ProcessExchangeBillQuery_Json")]


        [HttpGet]


        public object MES_Sc_ProcessExchangeBillList_Json(string sWhere)


        public object MES_Sc_ProcessExchangeBillList_Json(string sWhere,string user)


        {


            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;


                }




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


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


                if (ds == null || ds.Tables[0].Rows.Count <= 0)