1

yangle

2023-05-22 680b605296b299a426438579b8a271882521dc8a

 WebAPI/Controllers/SBGL/Gy_EquipFileMainController.cs

@@ -464,5 +464,37 @@
            return objJsonResult;
        }
        #endregion

        #region[根据条码返回设备信息]
        [Route("Gy_EquipFileMain/Gy_MouldFileBillBarCodeInfo")]
        [HttpGet]
        public object Gy_MouldFileBillBarCodeInfo(string HBarCode)
        { 
            DataTable ds; 
            List<object> list = new List<object>();
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                //获取配件项目编辑数据
                string sql1 = string.Format($"exec h_p_Gy_EquipFileGetInfoByBarCode {HBarCode}");
                ds = oCN.RunProcReturn(sql1, "h_p_Gy_EquipFileGetInfoByBarCode").Tables[0]; 

                list.Add(ds);//设备档案 

                objJsonResult.code = "0";
                objJsonResult.count = 1;
                objJsonResult.Message = "获取设备信息成功！";
                objJsonResult.list = list;
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "没有返回任何记录！请检查条形码！" + e.ToString();
                objJsonResult.data = null;
            }
            return objJsonResult;
        }
        #endregion
    }
}