public async Task <bool> wip_QTY(GlueCloseParam model) { //添加 string strAddUpdate = ""; strAddUpdate = string.Format("update T_MES_WIP_QTY w set w.qty_out='{0}' where w.mo_number='{1}' and w.station_name='{2}'and w.shipt_no='{3}' and w.statue=0", model.outQTY, model.moNumber, model.device_sn, model.shipCard); return(await base.ExecuteCommand(strAddUpdate, new { }) > 0); }
/// <summary> /// 打胶关结 /// </summary> /// <param name="jsondata"></param> /// <returns></returns> public async Task <MessageModel <string> > GlueClose(GlueCloseParam jsondata) { MessageModel <string> message = new MessageModel <string>(); try { //更新出货牌状态 await _dal.UpdateShipCartState(jsondata); await _dal.wip_QTY(jsondata); message.success = true; message.msg = "关结成功"; } catch (Exception ex) { message.success = false; message.msg = "关结失败"; } return(message); }
/// <summary> /// 更新出货牌状态 /// </summary> /// <param name="jsondata"></param> /// <returns></returns> public async Task <bool> UpdateShipCartState(GlueCloseParam jsondata) { string strUpdate = string.Format(@"update T_MES_MACHINE_USEINFO t set t.print=0,t.statue=1,t.out_qty='{1}',t.CURRENT_STEPS='{2}',t.NEXT_STEP='{3}',t.UPDATE_DATE=sysdate where t.shipment_no='{0}' and t.statue=0", jsondata.shipCard, jsondata.outQTY, jsondata.productType, jsondata.productItem); return(await base.ExecuteCommand(strUpdate) > 0); }