WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Controllers/SBGL/Sb_EquipDotCheckBillController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs
@@ -2358,8 +2358,17 @@ oCn.BeginTran(); ds = oCn.RunProcReturn($"select * from Sc_AssemblyBillMain where HMainSourceInterID={oBill.omodel.HProcExchInterID} and HMainSourceEntryID={oBill.omodel.HProcExchEntryID} and HBarCode_P='{HBardcode}'", "Sc_AssemblyBillMain"); if (ds.Tables[0].Rows.Count > 0) { oCn.RunProc($"delete from Sc_AssemblyBillMain where HMainSourceInterID={oBill.omodel.HProcExchInterID} and HMainSourceEntryID={oBill.omodel.HProcExchEntryID} and HBarCode_P='{HBardcode}'"); oCn.RunProc($"delete from Sc_AssemblyBillMain where HInterID={ds.Tables[0].Rows[0]["HInterID"].ToString()} and HBarCode_P='{HBardcode}'"); } oCn.RunProc("delete from Sc_StationOutBillSub_SN where HInterID=" + HInterID + " and HBarCode='" + HBardcode + "'"); oCn.RunProc("update Sc_StationOutBillMain set HQty-=1 where HInterID=" + HInterID); oCn.Commit(); WebAPI/Controllers/SBGL/Sb_EquipDotCheckBillController.cs
@@ -457,6 +457,49 @@ } #endregion #region 根据设备条码查找设备档案信息PDA 查询条码档案列表 [Route("Sb_PDA_EquipDotCheckBill/txtHBarCode_KeyDown_List")] [HttpGet] public object txtHBarCode_KeyDown_List(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_Gy_EquipFileMainList where 设备代码= '" + HBarCode + "'", "h_v_Gy_EquipFileMainList"); //写入信息 if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "未查询到设备信息!"; objJsonResult.data = null; return objJsonResult; } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess!"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exception!" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region 设备点检记录提交PDA [Route("Sb_PDA_EquipDotCheckBill/SaveGetEquipDotCheckBillList")]