智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
YL
2022-01-26 524d09e52b7bbe183595c289ec93ca8f2b26a4e8 
 WebAPI/Controllers/²Ö´æ¹ÜÀí/µ÷²¦Å̵ã/Kf_MoveStockRequestBillController.cs


@@ -15,14 +15,22 @@


        public DataSet ds = new DataSet();


        public SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();




        #region è°ƒæ‹¨å•åˆ—表


        #region è°ƒæ‹¨ç”³è¯·å•åˆ—表


        [Route("Kf_MoveStockRequestBill/GetMoveStockRequestBillList")]


        [HttpGet]


        public object GetMoveStockRequestBillList(string sWhere)


        public object GetMoveStockRequestBillList(string sWhere,string user)


        {


            try


            {


                //判断权限(略)


                //判断是否有查询权限


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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


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


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                string sql1 = string.Format("select * from h_v_IF_MoveStockRequestBillList_Litee where 1=1 ");


                if (sWhere == null || sWhere.Equals(""))