ch
2022-10-25 43efa9e547e6c7dc79767571c0186707519e4702
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
    }
}