1

zrg

2026-01-27 cdcea41c825c121e634061446f7a27c0d9d6d4e6

 WebAPI/Controllers/Sc_EmployeeSignInNoteBillController.cs

@@ -79,7 +79,6 @@
        }
        #endregion


        #region 根据源单传物料列表
        [Route("WLYayBillController/GetMesByOrginBill_1")]
        [HttpGet]
@@ -350,17 +349,19 @@
        #endregion

        #region app扫码模块
        [Route("Sc_EmployeeSignInNoteBillController/APP_Edit_json")]
        //获取设备信息
        [Route("Sc_EmployeeSignInNoteBillController/txtHBarCode_KeyDown")]
        [HttpGet]
        public object APP_Edit_json(int HInterID, string HBarCode)
        public object txtHBarCode_KeyDown(string HBarCode)
        {
            DataSet ds = oCN.RunProcReturn("exec h_p_getMESByEquipmentCode_app '" + HBarCode+"'", "h_p_getMESByEquipmentCode_app");            
            DataSet ds = oCN.RunProcReturn("select  * from h_v_Gy_EquipFileBill_KeyDown_PDA where 条形码= '" + HBarCode+"'", "h_v_Gy_EquipFileBill_KeyDown_PDA");    

            if (ds != null || ds.Tables.Count > 0)
            {
                    objJsonResult.code = "1";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "成功";
                    objJsonResult.data = ds.Tables;
                    objJsonResult.Message = "查询成功";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                
            }
@@ -368,6 +369,82 @@
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "设备档案未找到条码对应的设备信息！";
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        //获取模具信息
        [Route("Sc_EmployeeSignInNoteBillController/Get_HMouldList")]
        [HttpGet]
        public object Get_HMouldList(int HInterID,string UserNmae)
        {
            DataSet ds = oCN.RunProcReturn("exec  h_p_SB_HEquipHMould_Query '" + HInterID + "'", "h_p_SB_HEquipHMould_Query");

            if (ds != null || ds.Tables.Count > 0)
            {
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "查询成功";
                objJsonResult.data = ds.Tables[0];
                return objJsonResult;

            }
            else
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "当前设备无模具信息！";
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        //获取工单信息
        [Route("Sc_EmployeeSignInNoteBillController/Get_HIcmoList")]
        [HttpGet]
        public object Get_HIcmoList(int HInterID, string UserNmae)
        {
            DataSet ds = oCN.RunProcReturn("exec  h_p_Sc_ICMOBillStatus_Tmp_QD '" + HInterID + "'", "h_p_Sc_ICMOBillStatus_Tmp_QD");

            if (ds != null || ds.Tables.Count > 0)
            {
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "查询成功";
                objJsonResult.data = ds.Tables[0];
                return objJsonResult;

            }
            else
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "当前设备无模具信息！";
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        [Route("Sc_EmployeeSignInNoteBillController/Get_equipmentMes")]
        [HttpGet]
        public object Get_MouldMes(int HInterID, string HBarCode)
        {

            
            DataSet dss = oCN.RunProcReturn("select HInterID from Gy_EquipFileBillMain where HBarCode='"+ HBarCode + "'", "Gy_EquipFileBillMain");
            DataSet ds = oCN.RunProcReturn("exec h_p_SB_HEquipHMould_Query '" + dss.Tables[0].Rows[0]["HInterID"] + "'", "h_p_SB_HEquipHMould_Query");
            if (ds != null || ds.Tables.Count > 0)
            {
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "成功";
                objJsonResult.data = ds.Tables[0];
                return objJsonResult;

            }
            else
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "没有返回任何记录！";
                objJsonResult.data = null;
                return objJsonResult;