| | |
|---|
| | | VBELN = notice.OrderCode, |
|---|
| | | WERKS = notice.CustomerNo, |
|---|
| | | LFART = notice.Type, |
|---|
| | | WADAT_IST = Convert.ToDateTime(notice.CompleteTime).ToString("yyyy-MM-dd"), |
|---|
| | | WADAT_IST = Convert.ToDateTime(notice.UpdateTime).ToString("yyyy-MM-dd"), |
|---|
| | | ITEM = list |
|---|
| | | }; |
|---|
| | | #region 通过接口发送至erp |
|---|
| | |
|---|
| | | decimal needQty = detail.Qty - (detail.AllotQty == null ? 0 : decimal.Parse(detail.AllotQty.ToString())); |
|---|
| | | |
|---|
| | | //排除车间库存 |
|---|
| | | List<string> areaNoList = new List<string>() { "B06", "B07", "B09", "B24", "B26", "B27", "B28", "B29" }; |
|---|
| | | string areaNoSql = $@"select AreaNo from SysStorageArea where IsDel='0' and AreaType='1'"; |
|---|
| | | DataTable areaNoDt = Db.Ado.GetDataTable(areaNoSql); |
|---|
| | | List<string> areaNoList = areaNoDt.Rows.Cast<DataRow>().Select(e => e["AreaNo"] + "").ToList(); |
|---|
| | | |
|---|
| | | //库存明细 Status 0：待分配 1：部分分配 2：已分配 |
|---|
| | | var stockDetail = Db.Queryable<DataStockDetail>().Where(m => m.SkuNo == detail.SkuNo && (m.Qty - m.FrozenQty - m.LockQty + m.InspectQty) > 0 && (m.Status == "0" || m.Status == "1") && m.IsDel == "0" && !areaNoList.Contains(m.AreaNo)).ToList(); |
|---|
| | | |
|---|
