| | |
|---|
| | | |
|---|
| | | //return (mesItemBl.Bl001, blDetails); |
|---|
| | | var sql = string.Format(@"SELECT c.item_no ItemNo,c.item_name ItemName,c.item_model ItemModel,A.BLD007 FQty,A.BLD008 SQty,A.BLD007 - A.BLD008 DSQty, |
|---|
| | | dbo.F_QX_GETRECODEPOTSE(A.bld012) as RecoKw,D.daa001 |
|---|
| | | dbo.F_QX_GETRECODEPOTSE(A.bld012,'','','') as RecoKw,D.daa001 |
|---|
| | | fROM MES_ITEM_BL_DETAIL A |
|---|
| | | LEFT JOIN MES_ITEM_BL B ON A.MID = B.ID |
|---|
| | | LEFT JOIN MES_ITEMS C ON A.bld012 = CAST(C.item_id AS VARCHAR(50)) |
|---|
| | |
|---|
| | | PbillNo = query.billNo, |
|---|
| | | ItemId = blDetail.Bld012, |
|---|
| | | Unit = blDetail.Bld009, |
|---|
| | | DepotId = (int)stockBarcode.DepotsId, |
|---|
| | | DepotId = (int)stockBarcode.DepotId, |
|---|
| | | Dabid = womdab.Guid, |
|---|
| | | }).IgnoreColumns(true).ExecuteCommand(); |
|---|
| | | |
|---|
