using Masuit.Tools;
|
using MES.Service.DB;
|
using MES.Service.Dto.service;
|
using MES.Service.Modes;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using System.Data;
|
|
namespace MES.Service.service.Warehouse
|
{
|
public class WomdaaManager
|
{
|
/// <summary>
|
/// 获取产测登录号对应工单信息
|
/// </summary>
|
/// <param name="id"></param>
|
/// <returns></returns>
|
public DataTable GetTickeInfo(string id)
|
{
|
OracleSQLHelper SQLHelper = new();
|
//查工单信息
|
var sql1 = @"select DAA001 tickeNo,s.ITEM_NO itemNo,s.ITEM_NAME itemName,s.ITEM_MODEL itemModel,DAA008 plannedNum from MESLINE_LIKE_CCLOGIN A
|
join MES_LINE b on A.LINEID=b.ID
|
left join WOMDAA C on C.DAA015=B.LINE_NO
|
left join mes_items s on s.id = C.daa002
|
where LOGINID='" + id+ "' and DAA018='已开工' order by DAA016 asc";
|
|
return SQLHelper.ExecuteQuery(sql1);
|
}
|
|
|
/// <summary>
|
/// 记录产测过站信息
|
/// </summary>
|
/// <param name="id"></param>
|
/// <returns></returns>
|
public bool AddAsnInfo(AsnInfo asnInfo)
|
{
|
OracleSQLHelper SQLHelper = new();
|
//记录产测过站信息
|
var sql1 = @"INSERT INTO MES_SN_STATUS_DETAILS (ID,TICKET_NO,SN_NO,WORKSTATION_NO,SN_STATE) VALUES (SEQ_MES_SN_STATUS_DETAILS_ID.NEXTVAL,'"+ asnInfo.tickeNo+ "','"+ asnInfo.snNo+ "','"+ asnInfo.workstationNo+ "','"+ asnInfo.snState+ "')";
|
bool result = true;
|
int i= SQLHelper.ExecuteNonQuery(sql1);
|
if (i > 0) {result = true;} else { result = false; }
|
|
return result;
|
}
|
|
|
|
}
|
}
|
