| | |
| | | Fpurchaseunitid = item.FPurchaseUnitId, |
| | | Storeunit = item.FStoreUnitID, |
| | | Saleunit = item.FSaleUnitId, |
| | | //Fforbidstatus = item.FForbidStatus, |
| | | Fforbidstatus = item.FForbidStatus,//启用与禁用 |
| | | MaterialProperti = item.FErpClsID, |
| | | ProductionWorkshop = item.FWorkShopId, |
| | | ProduceUnit = item.FPRODUCEUNITID, |
| | |
| | | entity.SubconUnit = "0"; |
| | | } |
| | | |
| | | // ERP: Y=未禁用, N=禁用 |
| | | // MES: A=未禁用, B=禁用 |
| | | if (string.IsNullOrEmpty(item.FForbidStatus)) |
| | | { |
| | | entity.Fforbidstatus = "A"; |
| | | } |
| | | else |
| | | { |
| | | //我期望的值是A=启用,B=禁用 |
| | | //实际给我的值是Y或N,我希望为我转换从A和B的方式 |
| | | entity.Fforbidstatus = item.FForbidStatus == "N" ? "B" : "A"; |
| | | } |
| | | //// ERP: Y=未禁用, N=禁用 |
| | | //// MES: A=未禁用, B=禁用 |
| | | //if (string.IsNullOrEmpty(item.FForbidStatus)) |
| | | //{ |
| | | // entity.Fforbidstatus = "A"; |
| | | //} |
| | | //else |
| | | //{ |
| | | // //我期望的值是A=启用,B=禁用 |
| | | // //实际给我的值是Y或N,我希望为我转换从A和B的方式 |
| | | // entity.Fforbidstatus = item.FForbidStatus == "N" ? "B" : "A"; |
| | | //} |
| | | |
| | | return entity; |
| | | } |
| | |
| | | return newId; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 启用与禁用"Y"、"N" 转换为 "A"、"B" |
| | | /// </summary> |
| | | /// <param name="db"></param> |
| | | /// <param name="itemList"></param> |
| | | /// <param name="inputStatus"></param> |
| | | /// <returns></returns> |
| | | /// <exception cref="NotImplementedException"></exception> |
| | | private bool UpdateItemStatusBatch(SqlSugarScope db,List<MesItems> itemList, string inputStatus) |
| | | private bool UpdateItemStatusBatch(SqlSugarScope db,List<MesItems> itemList, string status) |
| | | { |
| | | var status = (inputStatus == "Y") ? "A" : (inputStatus == "N") ? "B" : inputStatus; |
| | | var ids = itemList.Select(it => it.Id).ToArray(); |
| | | var result = db.Updateable<MesItems>() |
| | | .SetColumns(s => s.Fforbidstatus == status) |