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);
}
