| | |
| | | #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("")) |
| | |
| | | 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; |
| | |
| | | } |
| | | 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) |