| | |
| | | var qsItemOqcItems = db |
| | | .Queryable<MesQualityStandard>() |
| | | .Where(b => b.QsType == "3" |
| | | && b.ItemNo == itemNo).Select( |
| | | b => new QsItemOqcItem |
| | | && b.ItemNo == itemNo).Select(b => new QsItemOqcItem |
| | | { |
| | | ProjName = b.ProjName, |
| | | ItemMod = b.ItemMod, |
| | |
| | | result = 1; |
| | | else if (count - passCount < QsItemOqcItem.FreQty) result = 1; |
| | | |
| | | var useTransactionWithOracle = SqlSugarHelper.UseTransactionWithOracle( |
| | | db => |
| | | var useTransactionWithOracle = |
| | | SqlSugarHelper.UseTransactionWithOracle(db => |
| | | { |
| | | var commit = 0; |
| | | commit += db.Updateable<QsItemOqcItem>() |
| | |
| | | private void setBarCodes(string? FcheckResu, QsItemOqcItemDetail detail, |
| | | SqlSugarClient db) |
| | | { |
| | | var oqcReqList = db.Queryable<QsItemOqcReq, MesInvItemIns, Womdaa>( |
| | | (a, b, c) => |
| | | var oqcReqList = db |
| | | .Queryable<QsItemOqcReq, MesInvItemIns, Womdaa>((a, b, c) => |
| | | new JoinQueryInfos( |
| | | JoinType.Left, a.BillNo == b.BillNo, |
| | | JoinType.Left, c.Daa001 == b.RbillNo |
| | |
| | | |
| | | var qsItemOqcReqs = db |
| | | .Queryable<QsItemOqcReq, MesItems, MesInvItemIns, MesInvTransaction, |
| | | RKJDaa001, Womdaa, VLineUser>( |
| | | (a, b, c, ca, m, da, z) => new JoinQueryInfos( |
| | | RKJDaa001, Womdaa, VLineUser>((a, b, c, ca, m, da, z) => |
| | | new JoinQueryInfos( |
| | | JoinType.Left, a.ItemNo == b.ItemNo, |
| | | JoinType.Left, a.BillNo == c.BillNo, |
| | | JoinType.Left, |
| | |
| | | var db = SqlSugarHelper.GetInstance(); |
| | | return db |
| | | .Queryable<QsItemOqcReq, MesInvItemIns, MesInvItemInCDetails2, |
| | | MesInvItemStocks>( |
| | | (a, b, c, d) => new JoinQueryInfos( |
| | | MesInvItemStocks>((a, b, c, d) => new JoinQueryInfos( |
| | | JoinType.Inner, a.BillNo == b.BillNo, |
| | | JoinType.Inner, b.Id == c.ItemInId, |
| | | JoinType.Inner, c.ItemBarcode == d.ItemBarcode |