| | |
|---|
| | | var qsItemOqcReq = |
|---|
| | | db.Queryable<QsItemOqcReq>().Single(s => s.Id == gid); |
|---|
| | | |
|---|
| | | var mesInvItemIns = db.Queryable<MesInvItemIns>() |
|---|
| | | .Single(s => s.BillNo == qsItemOqcReq.BillNo); |
|---|
| | | //var mesInvItemIns = db.Queryable<MesInvItemIns>() |
|---|
| | | // .Single(s => s.BillNo == qsItemOqcReq.BillNo); |
|---|
| | | |
|---|
| | | var mesSchemeResult = db.Queryable<Womdaa>() |
|---|
| | | .Single(s => s.Daa001 == mesInvItemIns.CbillNo); |
|---|
| | | |
|---|
| | | //.Single(s => s.Daa001 == mesInvItemIns.CbillNo); |
|---|
| | | .Single(s => s.Daa001 == qsItemOqcReq.BillNo); |
|---|
| | | var entity = new MesQaItemsDetect02(); |
|---|
| | | // entity.ItemNo = mesSchemeResult.BoardItem; |
|---|
| | | // entity.BoardItem = mesSchemeResult.BoardItem; |
|---|
| | |
|---|
| | | entity.CreateBy = createBy; |
|---|
| | | entity.FcheckBy = createBy; |
|---|
| | | |
|---|
| | | return SqlSugarHelper.UseTransactionWithOracle(db => db |
|---|
| | | .Insertable(entity) |
|---|
| | | .ExecuteCommand()); |
|---|
| | | // 跳过MES_QA_ITEMS_DETECT_02表的插入操作 |
|---|
| | | // 不再自动生成入库检异常对策记录 |
|---|
| | | return 0; |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
