1

zrg

1 天以前 639ea7256f10697d19c19cc878e999bcb7b1e6a1

 WebAPI/Controllers/Sc_EmployeeSignInNoteBillController.cs

@@ -62,7 +62,7 @@


                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.count = ds.Tables[0].Rows.Count;
                objJsonResult.Message = "Sucess！";
                objJsonResult.data = ds.Tables[0];
                objJsonResult.list = columnNameList;
@@ -78,7 +78,6 @@
            }
        }
        #endregion


        #region 根据源单传物料列表
        [Route("WLYayBillController/GetMesByOrginBill_1")]
@@ -350,22 +349,97 @@
        #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)
        {
            oCN.BeginTran();
            DataSet ds = oCN.RunProcReturn("exec h_p_getMESByEquipmentCode_app '" + HBarCode+"'", "h_p_getMESByEquipmentCode_app");
            //DataSet ds = oCN.RunProcReturn("select * from Gy_EquipFileBillMain where HBarCode='" + HBarCode + "'", "Gy_EquipFileBillMain");
            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;
                    oCN.Commit();
                    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_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
            {
@@ -375,10 +449,8 @@
                objJsonResult.data = null;
                return objJsonResult;
            }
            return objJsonResult;
        }
        #endregion


        #region  保存/编辑

@@ -556,5 +628,37 @@
            }
        }
        #endregion


        #region 出站单 查询当前机台的操作员、模具工、机修 （华舟）
        [Route("Sc_EmployeeSignInNoteBillController/Get_HSourceRoulsList")]
        [HttpGet]
        public object Get_HSourceRoulsList(int HSourceID)
        {
            try
            {
                List<object> columnNameList = new List<object>();


                ds = oCN.RunProcReturn("exec h_p_Cj_StationOutBill_Roules_HZ  '" + HSourceID + "'", "h_p_Cj_StationOutBill_Roules_HZ");

                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "Sucess！";
                objJsonResult.data = ds;
                objJsonResult.list = null;
                return objJsonResult;
            }
            catch (Exception ex)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

    }
}