| | |
|---|
| | | ID = dtl.LineID.ToString(), |
|---|
| | | ITEM_CODE = dtl.ItemCode, |
|---|
| | | QTY_PACKING = dtl.PackQty.ToDouble(), |
|---|
| | | QTY = dtl.POQtyTU.ToDouble(), |
|---|
| | | QTY = dtl.ShipQtyTU.ToDouble(), |
|---|
| | | PO_QTY = dtl.POQtyTU, |
|---|
| | | SUPP_CODE = dtl.SupplierCode, |
|---|
| | | SUPP_LOTNO = dtl.SupplierLot, |
|---|
| | | LOTNO = dtl.LotMater, |
|---|
| | |
|---|
| | | .WhereColumns(t => new { t.ORDER_NO, t.GHOST_ROW }) |
|---|
| | | .ToStorage(); |
|---|
| | | y.AsInsertable.ExecuteCommand(); |
|---|
| | | y.AsUpdateable.IgnoreColumns(x => x.ID).UpdateColumns(q => new { q.ORDER_NO, q.SUPP_CODE, q.SUPP_NAME, q.DELIVERY_DATE, q.PLANARRIVED_DATE, q.ORDER_DATE, q.CREATE_USER, q.UPDATE_TIME, q.AUTH_ORG, q.UPDATE_USER, }).ExecuteCommand(); |
|---|
| | | y.AsUpdateable.IgnoreColumns(x => x.ID).UpdateColumns(q => new { q.ORDER_NO, q.SUPP_CODE, q.SUPP_NAME, q.DELIVERY_DATE,q.PLANARRIVED_DATE, q.ORDER_DATE, q.CREATE_USER, q.UPDATE_TIME, q.AUTH_ORG, q.UPDATE_USER, }).ExecuteCommand(); |
|---|
| | | }); |
|---|
| | | } |
|---|
| | | if (dtls.Any()) |
|---|
| | |
|---|
| | | .WhereColumns(t => new { t.ORDER_NO, t.ID, t.GHOST_ROW }) |
|---|
| | | .ToStorage(); |
|---|
| | | y.AsInsertable.ExecuteCommand(); |
|---|
| | | y.AsUpdateable.UpdateColumns(q => new { q.ORDER_NO, q.LINE_NO, q.SUPP_CODE, q.ID, q.ITEM_CODE, q.QTY_PACKING, q.QTY, q.SUPP_LOTNO, q.LOTNO, q.AUTH_ORG, q.CREATE_USER, q.UPDATE_TIME, q.UPDATE_USER, }).ExecuteCommand(); |
|---|
| | | y.AsUpdateable.UpdateColumns(q => new { q.ORDER_NO, q.LINE_NO, q.SUPP_CODE, q.ID, q.ITEM_CODE, q.QTY_PACKING, q.QTY,q.PO_QTY, q.SUPP_LOTNO, q.LOTNO, q.AUTH_ORG, q.CREATE_USER, q.UPDATE_TIME, q.UPDATE_USER, }).ExecuteCommand(); |
|---|
| | | }); |
|---|
| | | } |
|---|
| | | if (sns.Any()) |
|---|
| | |
|---|
| | | ORDER_NO = item.DocNo, //单据号 |
|---|
| | | LINE_NO = item.DocLineNo.ToString(), //单据行号 |
|---|
| | | ITEM_CODE = item.ItemCode, //物料编码 |
|---|
| | | QTY = item.RtnFillQtyTU.ToDouble(), // mes单据数量 --U9退补数量 |
|---|
| | | QTY = item.EyeballingQtyTU.ToDouble(), // mes单据数量 --U9退补数量 |
|---|
| | | AUTH_ORG = orgs.FirstOrDefault(q => q.ID == item.Org.ToString())?.ORG_CODE, //生产单元授权标识字符 |
|---|
| | | CREATE_TIME = item.ModifiedOn,//--时间不更新 |
|---|
| | | CREATE_USER = UserCode, |
|---|
