王 垚
2021-10-26 b8c84d84575a088b6d957bfee494275ae3a086c0
WebAPI/Controllers/MJJY/Mj_PDA_MoudlCheckController.cs
@@ -33,8 +33,70 @@
        #region 根据模治具条码查找模具档案信息
        [Route("Mj_PDA_MoudlCheckBill/txtHBarCode_KeyDown")]
        [HttpGet]
        public object txtHBarCode_KeyDown(string HBarCode,long HInterID,long HWHID,long HSPID)
        public object txtHBarCode_KeyDown(string HBarCode)
        {
            //try
            //{
            //    if (HBarCode == null || HBarCode.Equals(""))
            //    {
            //        objJsonResult.code = "0";
            //        objJsonResult.count = 0;
            //        objJsonResult.Message = "条形码不能为空!";
            //        objJsonResult.data = null;
            //        return objJsonResult;
            //    }
            //    //得到信息
            //    ds = oCN.RunProcReturn("select top 1 * from h_v_IF_Mould  where HBarCode = '" + HBarCode + "'", "h_v_IF_Mould");
            //    //ds = oWebs.get_InfoByBarCode(HBarCode, ref DBUtility.ClsPub.sErrInfo);
            //    //写入信息
            //    if (ds == null )
            //    {
            //        objJsonResult.code = "0";
            //        objJsonResult.count = 0;
            //        objJsonResult.Message = "未查询到模具信息!";
            //        objJsonResult.data = null;
            //        return objJsonResult;
            //    }
            //    else
            //    {
            //        omodel.HInterID = HInterID;
            //        omodel.HBillType = "3796";
            //        omodel.HMaker = DBUtility.ClsPub.CurUserName;
            //        omodel.HMaterID = Convert.ToInt64(ds.Tables[0].Rows[0]["HMaterID"]);
            //        omodel.HQty = 0;
            //        omodel.HBarCode = Convert.ToString(ds.Tables[0].Rows[0]["HBarCode"]);
            //        omodel.HWhID = HWHID;
            //        omodel.HStockPlaceID = HSPID;
            //        omodel.HSourceBillNo = "1";
            //        omodel.HSourceBillType = "1";
            //        omodel.HSourceEntryID = 0;
            //        omodel.HSourceInterID = 0;
            //        if (set_SavePonderationBillMain_Temp(omodel, ref DBUtility.ClsPub.sErrInfo))
            //        {
            //            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;
            //        }
            //    }
            //}
            //catch (Exception e)
            //{
            //    objJsonResult.code = "0";
            //    objJsonResult.count = 0;
            //    objJsonResult.Message = "Exception!" + e.ToString();
            //    objJsonResult.data = null;
            //    return objJsonResult;
            //}
            try
            {
                if (HBarCode == null || HBarCode.Equals(""))
@@ -49,7 +111,7 @@
                ds = oCN.RunProcReturn("select top 1 * from h_v_IF_Mould  where HBarCode = '" + HBarCode + "'", "h_v_IF_Mould");
                //ds = oWebs.get_InfoByBarCode(HBarCode, ref DBUtility.ClsPub.sErrInfo);
                //写入信息
                if (ds == null )
                if (ds == null)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
@@ -59,34 +121,11 @@
                }
                else
                {
                    omodel.HInterID = HInterID;
                    omodel.HBillType = "3796";
                    omodel.HMaker = DBUtility.ClsPub.CurUserName;
                    omodel.HMaterID = Convert.ToInt64(ds.Tables[0].Rows[0]["HMaterID"]);
                    omodel.HQty = 0;
                    omodel.HBarCode = Convert.ToString(ds.Tables[0].Rows[0]["HBarCode"]);
                    omodel.HWhID = HWHID;
                    omodel.HStockPlaceID = HSPID;
                    omodel.HSourceBillNo = "1";
                    omodel.HSourceBillType = "1";
                    omodel.HSourceEntryID = 0;
                    omodel.HSourceInterID = 0;
                    if (set_SavePonderationBillMain_Temp(omodel, ref DBUtility.ClsPub.sErrInfo))
                    {
                        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;
                    }
                    objJsonResult.code = "0";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "获取信息成功!";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
            }
            catch (Exception e)