ProductionScheduleAppService.cs 268 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623262426252626262726282629263026312632263326342635263626372638263926402641264226432644264526462647264826492650265126522653265426552656265726582659266026612662266326642665266626672668266926702671267226732674267526762677267826792680268126822683268426852686268726882689269026912692269326942695269626972698269927002701270227032704270527062707270827092710271127122713271427152716271727182719272027212722272327242725272627272728272927302731273227332734273527362737273827392740274127422743274427452746274727482749275027512752275327542755275627572758275927602761276227632764276527662767276827692770277127722773277427752776277727782779278027812782278327842785278627872788278927902791279227932794279527962797279827992800280128022803280428052806280728082809281028112812281328142815281628172818281928202821282228232824282528262827282828292830283128322833283428352836283728382839284028412842284328442845284628472848284928502851285228532854285528562857285828592860286128622863286428652866286728682869287028712872287328742875287628772878287928802881288228832884288528862887288828892890289128922893289428952896289728982899290029012902290329042905290629072908290929102911291229132914291529162917291829192920292129222923292429252926292729282929293029312932293329342935293629372938293929402941294229432944294529462947294829492950295129522953295429552956295729582959296029612962296329642965296629672968296929702971297229732974297529762977297829792980298129822983298429852986298729882989299029912992299329942995299629972998299930003001300230033004300530063007300830093010301130123013301430153016301730183019302030213022302330243025302630273028302930303031303230333034303530363037303830393040304130423043304430453046304730483049305030513052305330543055305630573058305930603061306230633064306530663067306830693070307130723073307430753076307730783079308030813082308330843085308630873088308930903091309230933094309530963097309830993100310131023103310431053106310731083109311031113112311331143115311631173118311931203121312231233124312531263127312831293130313131323133313431353136313731383139314031413142314331443145314631473148314931503151315231533154315531563157315831593160316131623163316431653166316731683169317031713172317331743175317631773178317931803181318231833184318531863187318831893190319131923193319431953196319731983199320032013202320332043205320632073208320932103211321232133214321532163217321832193220322132223223322432253226322732283229323032313232323332343235323632373238323932403241324232433244324532463247324832493250325132523253325432553256325732583259326032613262326332643265326632673268326932703271327232733274327532763277327832793280328132823283328432853286328732883289329032913292329332943295329632973298329933003301330233033304330533063307330833093310331133123313331433153316331733183319332033213322332333243325332633273328332933303331333233333334333533363337333833393340334133423343334433453346334733483349335033513352335333543355335633573358335933603361336233633364336533663367336833693370337133723373337433753376337733783379338033813382338333843385338633873388338933903391339233933394339533963397339833993400340134023403340434053406340734083409341034113412341334143415341634173418341934203421342234233424342534263427342834293430343134323433343434353436343734383439344034413442344334443445344634473448344934503451345234533454345534563457345834593460346134623463346434653466346734683469347034713472347334743475347634773478347934803481348234833484348534863487348834893490349134923493349434953496349734983499350035013502350335043505350635073508350935103511351235133514351535163517351835193520352135223523352435253526352735283529353035313532353335343535353635373538353935403541354235433544354535463547354835493550355135523553355435553556355735583559356035613562356335643565356635673568356935703571357235733574357535763577357835793580358135823583358435853586358735883589359035913592359335943595359635973598359936003601360236033604360536063607360836093610361136123613361436153616361736183619362036213622362336243625362636273628362936303631363236333634363536363637363836393640364136423643364436453646364736483649365036513652365336543655365636573658365936603661366236633664366536663667366836693670367136723673367436753676367736783679368036813682368336843685368636873688368936903691369236933694369536963697369836993700370137023703370437053706370737083709371037113712371337143715371637173718371937203721372237233724372537263727372837293730373137323733373437353736373737383739374037413742374337443745374637473748374937503751375237533754375537563757375837593760376137623763376437653766376737683769377037713772377337743775377637773778377937803781378237833784378537863787378837893790379137923793379437953796379737983799380038013802380338043805380638073808380938103811381238133814381538163817381838193820382138223823382438253826382738283829383038313832383338343835383638373838383938403841384238433844384538463847384838493850385138523853385438553856385738583859386038613862386338643865386638673868386938703871387238733874387538763877387838793880388138823883388438853886388738883889389038913892389338943895389638973898389939003901390239033904390539063907390839093910391139123913391439153916391739183919392039213922392339243925392639273928392939303931393239333934393539363937393839393940394139423943394439453946394739483949395039513952395339543955395639573958395939603961396239633964396539663967396839693970397139723973397439753976397739783979398039813982398339843985398639873988398939903991399239933994399539963997399839994000400140024003400440054006400740084009401040114012401340144015401640174018401940204021402240234024402540264027402840294030403140324033403440354036403740384039404040414042404340444045404640474048404940504051405240534054405540564057405840594060406140624063406440654066406740684069407040714072407340744075407640774078407940804081408240834084408540864087408840894090409140924093409440954096409740984099410041014102410341044105410641074108410941104111411241134114411541164117411841194120412141224123412441254126412741284129413041314132413341344135413641374138413941404141414241434144414541464147414841494150415141524153415441554156415741584159416041614162416341644165416641674168416941704171417241734174417541764177417841794180418141824183418441854186418741884189419041914192419341944195419641974198419942004201420242034204420542064207420842094210421142124213421442154216421742184219422042214222422342244225422642274228422942304231423242334234423542364237423842394240424142424243424442454246
  1. using Business.Business.Dto;
  2. using Business.Core.Utilities;
  3. using Business.Domain;
  4. using Business.Dto;
  5. using Business.EntityFrameworkCore.SqlRepositories;
  6. using Business.ResourceExamineManagement.Dto;
  7. using Business.StructuredDB.Production;
  8. using System;
  9. using System.Collections.Generic;
  10. using System.Collections.Immutable;
  11. using System.Configuration;
  12. using System.Linq;
  13. using System.Threading.Tasks;
  14. using System.Transactions;
  15. using Volo.Abp.Application.Services;
  16. using Volo.Abp.MultiTenancy;
  17. using Microsoft.Extensions.Configuration;
  18. using MongoDB.Driver.Linq;
  19. using Amazon.Runtime.Internal.Util;
  20. using IdentityModel.Client;
  21. using Amazon.Runtime;
  22. using Magicodes.ExporterAndImporter.Core.Extension;
  23. namespace Business.ResourceExamineManagement
  24. {
  25. /// <summary>
  26. /// 生产排产服务
  27. /// </summary>
  28. public class ProductionScheduleAppService : ApplicationService
  29. {
  30. #region 服务
  31. /// <summary>
  32. /// 物料
  33. /// </summary>
  34. private ISqlRepository<ItemMaster> _itemMaster;
  35. /// <summary>
  36. /// 工单
  37. /// </summary>
  38. private ISqlRepository<WorkOrdMaster> _workOrdMaster;
  39. /// <summary>
  40. /// 工单物料明细
  41. /// </summary>
  42. private ISqlRepository<WorkOrdDetail> _workOrdDetail;
  43. /// <summary>
  44. /// 工单工艺路线明细
  45. /// </summary>
  46. private ISqlRepository<WorkOrdRouting> _workOrdRouting;
  47. /// <summary>
  48. /// 库存主数据
  49. /// </summary>
  50. private ISqlRepository<InvMaster> _invMaster;
  51. /// <summary>
  52. /// 生产线明细
  53. /// </summary>
  54. private ISqlRepository<ProdLineDetail> _prodLineDetail;
  55. /// <summary>
  56. /// 生产周期明细
  57. /// </summary>
  58. private ISqlRepository<PeriodSequenceDet> _periodSequenceDet;
  59. /// <summary>
  60. /// 排产结果明细
  61. /// </summary>
  62. private ISqlRepository<ScheduleResultOpMaster> _scheduleResultOpMaster;
  63. /// <summary>
  64. /// 工作日历数据
  65. /// </summary>
  66. private ISqlRepository<ShopCalendarWorkCtr> _shopCalendarWorkCtr;
  67. /// <summary>
  68. /// 产线休息时间记录表
  69. /// </summary>
  70. private ISqlRepository<QualityLineWorkDetail> _qualityLineWorkDetail;
  71. /// <summary>
  72. /// 产线人员配置表
  73. /// </summary>
  74. private ISqlRepository<ProdLineDetailRunCrew> _prodLineDetailRunCrew;
  75. /// <summary>
  76. /// 加班设置表
  77. /// </summary>
  78. private ISqlRepository<ResourceOccupancyTime> _resourceOccupancyTime;
  79. /// <summary>
  80. /// 加班设置表
  81. /// </summary>
  82. private ISqlRepository<GeneralizedCodeMaster> _generalizedCodeMaster;
  83. /// <summary>
  84. /// 节假日记录表
  85. /// </summary>
  86. private ISqlRepository<HolidayMaster> _holidayMaster;
  87. /// <summary>
  88. /// 排产异常记录
  89. /// </summary>
  90. private ISqlRepository<ScheduleExceptionMaster> _scheduleExceptionMaster;
  91. /// <summary>
  92. /// 雪花算法
  93. /// </summary>
  94. SnowFlake help = new SnowFlake();
  95. private readonly ICurrentTenant _currentTenant;
  96. /// <summary>
  97. /// 工作日历数据
  98. /// </summary>
  99. private List<ShopCalendarWorkCtr> calendars;
  100. /// <summary>
  101. /// 产线休息记录数据
  102. /// </summary>
  103. private List<QualityLineWorkDetail> qualityLines;
  104. /// <summary>
  105. /// 节假日记录数据
  106. /// </summary>
  107. private List<HolidayMaster> holidays;
  108. /// <summary>
  109. /// 生产线UPH设置
  110. /// </summary>
  111. private List<ProdLineDetailRunCrew> prodLineDetailRunCrews;
  112. /// <summary>
  113. /// 加班设置
  114. /// </summary>
  115. private List<ResourceOccupancyTime> resourceOccupancyTimes;
  116. /// <summary>
  117. /// 领料单
  118. /// </summary>
  119. private ISqlRepository<NbrMaster> _nbrMaster;
  120. /// <summary>
  121. /// 工厂id
  122. /// </summary>
  123. private string domain = "";
  124. #endregion
  125. #region 构造函数
  126. /// <summary>
  127. /// 构造函数
  128. /// </summary>
  129. public ProductionScheduleAppService(
  130. ISqlRepository<ItemMaster> itemMaster,
  131. ISqlRepository<WorkOrdMaster> workOrdMaster,
  132. ISqlRepository<WorkOrdDetail> workOrdDetail,
  133. ISqlRepository<WorkOrdRouting> workOrdRouting,
  134. ISqlRepository<ProdLineDetail> prodLineDetail,
  135. ISqlRepository<ProdLineDetailRunCrew> prodLineDetailRunCrew,
  136. ISqlRepository<ResourceOccupancyTime> resourceOccupancyTime,
  137. ISqlRepository<PeriodSequenceDet> periodSequenceDet,
  138. ISqlRepository<ScheduleResultOpMaster> scheduleResultOpMaster,
  139. ISqlRepository<InvMaster> invMaster,
  140. ISqlRepository<ShopCalendarWorkCtr> shopCalendarWorkCtr,
  141. ISqlRepository<QualityLineWorkDetail> qualityLineWorkDetail,
  142. ISqlRepository<HolidayMaster> holidayMaster,
  143. ISqlRepository<GeneralizedCodeMaster> generalizedCodeMaster,
  144. ICurrentTenant currentTenant,
  145. ISqlRepository<ScheduleExceptionMaster> scheduleExceptionMaster,
  146. ISqlRepository<NbrMaster> nbrMaster
  147. )
  148. {
  149. _itemMaster = itemMaster;
  150. _workOrdMaster = workOrdMaster;
  151. _workOrdDetail = workOrdDetail;
  152. _workOrdRouting = workOrdRouting;
  153. _nbrMaster = nbrMaster;
  154. _prodLineDetail = prodLineDetail;
  155. _prodLineDetailRunCrew = prodLineDetailRunCrew;
  156. _resourceOccupancyTime = resourceOccupancyTime;
  157. _periodSequenceDet = periodSequenceDet;
  158. _scheduleResultOpMaster = scheduleResultOpMaster;
  159. _invMaster = invMaster;
  160. _shopCalendarWorkCtr = shopCalendarWorkCtr;
  161. _qualityLineWorkDetail = qualityLineWorkDetail;
  162. _holidayMaster = holidayMaster;
  163. _generalizedCodeMaster = generalizedCodeMaster;
  164. _currentTenant = currentTenant;
  165. _scheduleExceptionMaster = scheduleExceptionMaster;
  166. }
  167. #endregion
  168. /// <summary>
  169. /// 生产排产-定时任务
  170. /// </summary>
  171. public async void DoExt()
  172. {
  173. //定时任务排产:获取工厂id
  174. IConfiguration configuration = new ConfigurationBuilder().AddJsonFile("appsettings.json", optional: true, reloadOnChange: true).Build();
  175. domain = configuration.GetConnectionString("Factory_id");
  176. //获取需要排产的工单(获取四周的工单:正常工单+已审批通过的特殊工单)
  177. DateTime endDate = DateTime.Now.Date.AddDays(28).AddDays(1);
  178. //取数开始时间为当前天的下一天
  179. DateTime startDate = DateTime.Now.Date.AddDays(1);
  180. //尚未开始生产的工单+正在生产的工单
  181. var workOrds = _workOrdMaster.Select(p => p.IsActive && p.Domain == domain && ((p.OrdDate < endDate && p.OrdDate >= startDate && (string.IsNullOrEmpty(p.Typed) || (!string.IsNullOrEmpty(p.Typed) && p.BusinessID >0 ))) || p.Status.ToLower() == "w")).ToList();
  182. if (workOrds.Any())
  183. {
  184. await DoProductSchedule(workOrds, domain, 1);
  185. }
  186. }
  187. /// <summary>
  188. /// 生产排产
  189. /// </summary>
  190. /// <param name="workOrds">需要重新排产的工单</param>
  191. /// <param name="factoryid">工单的工厂id</param>
  192. /// <param name="type">排产类型:1-自动排产;2-手动排产</param>
  193. /// <returns></returns>
  194. public async Task<string> DoProductSchedule(List<WorkOrdMaster> workOrds, string factoryid,int type)
  195. {
  196. //记录工厂id
  197. domain = factoryid;
  198. //工单排产的最早日期
  199. DateTime earlist = DateTime.Now.Date.AddDays(1);
  200. //特殊工单指定时间开工,不需要计算产能,只需要计算时长即可
  201. var tsWorkOrds = workOrds.Where(p => !string.IsNullOrEmpty(p.Typed)).ToList();
  202. //正常工单
  203. var zcWorkOrds = workOrds.Where(p => string.IsNullOrEmpty(p.Typed)).ToList();
  204. //2、获取数据
  205. //获取工单工艺路径数据
  206. List<WorkOrdRouting> workOrdRoutings = _workOrdRouting.Select(p => workOrds.Select(m => m.WorkOrd).Contains(p.WorkOrd) && p.ParentOp == 0 && p.Domain == domain && p.Status != "C" && p.IsActive);
  207. //特殊工单的工艺路线
  208. List<WorkOrdRouting> tsWoRoutings = workOrdRoutings.Where(p => tsWorkOrds.Select(m => m.WorkOrd).Contains(p.WorkOrd)).ToList();
  209. //获取物料对应的生产线信息:物料、工序对应的生产线
  210. List<ProdLineDetail> prodLines = _prodLineDetail.Select(p => workOrds.Select(m => m.ItemNum).Contains(p.Part) && p.Domain == domain && p.IsActive);
  211. List<string> lines = prodLines.Select(p => p.Line).ToList();
  212. //获取非标准产线人员配置
  213. prodLineDetailRunCrews = _prodLineDetailRunCrew.Select(x => prodLines.Select(p => p.RecID).Contains(x.ProdLineDetailRecID) && x.IsActive && x.Domain == domain).ToList();
  214. //获取加班设置
  215. resourceOccupancyTimes = _resourceOccupancyTime.Select(x => prodLines.Select(p => p.Line).Contains(x.Resource) && x.IsActive && x.Domain == domain && x.StartTime.Value > DateTime.Now).ToList();
  216. //获取生产周期数据
  217. List<PeriodSequenceDet> dbPeriodSequences = _periodSequenceDet.Select(p => lines.Contains(p.Line) && p.PlanDate >= earlist && p.Domain == domain && p.IsActive);
  218. //获取当前日期往后的排产记录数据
  219. List<ScheduleResultOpMaster> dbSchedules = _scheduleResultOpMaster.Select(p => lines.Contains(p.Line) && p.WorkDate >= earlist && p.Domain == domain);
  220. ////获取锁定期之外的工单排产数据
  221. //List<PeriodSequenceDet> delPeriodSequences = dbPeriodSequences.Where(p => workOrds.Select(m => m.WorkOrd).Contains(p.WorkOrds)).ToList();
  222. //List<ScheduleResultOpMaster> delSchedules = dbSchedules.Where(p => workOrds.Select(m => m.WorkOrd).Contains(p.WorkOrd)).ToList();
  223. ////产线占用记录排除锁定期之前的工单
  224. //dbSchedules = dbSchedules.Where(p => !workOrds.Select(m => m.WorkOrd).Contains(p.WorkOrd)).ToList();
  225. //获取工作日历数据:产线的工作日历+默认的工作日历
  226. calendars = _shopCalendarWorkCtr.Select(p => (lines.Contains(p.ProdLine) || string.IsNullOrEmpty(p.ProdLine)) && p.Domain == domain && p.IsActive);
  227. //获取产线休息记录数据
  228. qualityLines = _qualityLineWorkDetail.Select(p => lines.Contains(p.ProdLine) && p.Domain == domain && p.IsActive);
  229. //获取节假日记录数据
  230. holidays = _holidayMaster.Select(p => p.Domain == domain && p.IsActive && p.Dated >= earlist);
  231. //排产前校验
  232. List<ScheduleExceptionMaster> exceptions = BeforeScheduleCheck(workOrds, workOrdRoutings, prodLines,type);
  233. if (exceptions.Any())
  234. {
  235. using (TransactionScope scope = new TransactionScope())
  236. {
  237. try
  238. {
  239. //记录排产异常数据
  240. _scheduleExceptionMaster.Insert(exceptions);
  241. scope.Complete();
  242. }
  243. catch (Exception ex)
  244. {
  245. new NLogHelper("ProductionScheduleAppService").WriteLog("DoProductSchedule", "保存排产异常数据失败:" + ex.Message, _currentTenant.Id.ToString());
  246. scope.Dispose();
  247. }
  248. }
  249. return "NO|请查看排产异常日志!";
  250. }
  251. //3、排产
  252. //生产周期
  253. List<PeriodSequenceDet> periodSequenceDtls = new List<PeriodSequenceDet>();
  254. //排产记录表
  255. List<ScheduleResultOpMaster> scheduleMasters = new List<ScheduleResultOpMaster>();
  256. //记录排产结果
  257. List<ScheduleResultOpMaster> allResults = new List<ScheduleResultOpMaster>();
  258. //allResults.AddRange(dbSchedules);
  259. //记录特殊工单排产结果
  260. List<string> ypcWorkOrds = new List<string>();
  261. //按照优先级排序
  262. zcWorkOrds = zcWorkOrds.OrderBy(p=>p.Priority).ToList();
  263. foreach (var item in zcWorkOrds)
  264. {
  265. //记录产线占用情况
  266. allResults.AddRange(scheduleMasters);
  267. //当前工单工艺路线主产线的关键工序
  268. var curRoutings = workOrdRoutings.Where(p => p.ItemNum == item.ItemNum && p.ParentOp == 0 && p.MilestoneOp).OrderBy(p=>p.OP).ToList();
  269. //当前工单的产线明细
  270. var curProdLines = prodLines.Where(p => p.Part == item.ItemNum).ToList();
  271. //产线排产
  272. LineSchedule(item, curRoutings, curProdLines, periodSequenceDtls, scheduleMasters, allResults, tsWorkOrds, ypcWorkOrds, tsWoRoutings);
  273. List<ScheduleResultOpMaster> scheduleList = scheduleMasters.Where(s => s.WorkOrd == item.WorkOrd).ToList();
  274. if (scheduleList.Any())
  275. {
  276. item.OrdDate = scheduleList.Min(s => s.WorkStartTime);
  277. item.DueDate = scheduleList.Max(s => s.WorkEndTime);
  278. }
  279. }
  280. //判断是否有特殊工单没有排产,如果有,则对剩余特殊工单排产
  281. var notSchedules = tsWorkOrds.Where(p => !ypcWorkOrds.Contains(p.WorkOrd)).ToList();
  282. List<WorkOrdMstDto> workDtos = new List<WorkOrdMstDto>();
  283. foreach (var item in notSchedules)
  284. {
  285. var curOp = tsWoRoutings.Where(p => p.WorkOrd == item.WorkOrd).OrderByDescending(p => p.OP).First();
  286. //剩余排产数量
  287. decimal qtyNeed = item.QtyOrded - curOp.QtyComplete;
  288. //剩余工作时长(分钟)
  289. decimal usedTime = Math.Ceiling(qtyNeed / item.QtyOrded * item.LbrVar * 60);
  290. //特殊工单排产开始时间
  291. DateTime startTime = item.OrdDate.GetValueOrDefault();
  292. //如果当前特殊工单正在生产,则开工日期为当天的下一个工作日
  293. if (item.Status.ToLower() == "w" && item.JointTyped.ToUpper() != "B")
  294. {
  295. DateTime nowDate = DateTime.Now.Date;
  296. //当前产线的工作日历
  297. var mLCalendars = calendars.Where(p => p.ProdLine == item.ProdLine || string.IsNullOrEmpty(p.ProdLine)).ToList();
  298. //获取下一个工作日
  299. startTime = GetNextWorkDay((int)nowDate.DayOfWeek, nowDate, mLCalendars);
  300. }
  301. workDtos.Add(new WorkOrdMstDto
  302. {
  303. WorkOrd = item.WorkOrd,
  304. ItemNum = item.ItemNum,
  305. QtyOrded = qtyNeed,
  306. OrdDate = startTime,
  307. ProdLine = item.ProdLine,
  308. LbrVar = usedTime,
  309. Worked = 0,
  310. QtyWorked = 0,
  311. Op = curOp.OP,
  312. WaitTime = curOp.WaitTime * 60
  313. });
  314. }
  315. TsLineSchedule(workDtos, periodSequenceDtls, scheduleMasters);
  316. //处理特殊工单计划开始日期、计划结束日期
  317. foreach (var item in tsWorkOrds)
  318. {
  319. List<ScheduleResultOpMaster> scheduleList = scheduleMasters.Where(s => s.WorkOrd == item.WorkOrd).ToList();
  320. if (scheduleList.Any())
  321. {
  322. item.OrdDate = scheduleList.Min(s => s.WorkStartTime);
  323. item.DueDate = scheduleList.Max(s => s.WorkEndTime);
  324. }
  325. }
  326. using (TransactionScope scope = new TransactionScope())
  327. {
  328. try
  329. {
  330. //更新工单计划开工时间、计划结束时间
  331. _workOrdMaster.Update(workOrds);
  332. //删除当前日期下一天开始的工单排产记录
  333. _periodSequenceDet.Delete(dbPeriodSequences);
  334. _scheduleResultOpMaster.Delete(dbSchedules);
  335. //保存排产记录
  336. _periodSequenceDet.Insert(periodSequenceDtls);
  337. _scheduleResultOpMaster.Insert(scheduleMasters);
  338. scope.Complete();
  339. }
  340. catch (Exception ex)
  341. {
  342. new NLogHelper("ProductionScheduleAppService").WriteLog("DoProductSchedule", "保存排产数据失败:" + ex.Message, _currentTenant.Id.ToString());
  343. scope.Dispose();
  344. }
  345. }
  346. //领料单重新处理
  347. AdjustNbrDate(workOrds);
  348. return "OK";
  349. }
  350. /// <summary>
  351. /// 排产前校验
  352. /// </summary>
  353. /// <param name="workOrds">待排产工单</param>
  354. /// <param name="workOrdRoutings">工单工艺路线</param>
  355. /// <param name="prodLines">产线明细</param>
  356. /// <param name="type">排产类型:1-自动排产,2-手动排产</param>
  357. /// <returns></returns>
  358. public List<ScheduleExceptionMaster> BeforeScheduleCheck(List<WorkOrdMaster> workOrds,List<WorkOrdRouting> workOrdRoutings, List<ProdLineDetail> prodLines,int type)
  359. {
  360. //记录操作时间
  361. string optTime = DateTime.Now.ToString("yyyyMMddHHmmss");
  362. List<ScheduleExceptionMaster> exceptions = new List<ScheduleExceptionMaster>();
  363. ScheduleExceptionMaster entity;
  364. foreach (var item in workOrds)
  365. {
  366. if (!string.IsNullOrEmpty(item.Typed))//特殊工单
  367. {
  368. //校验有没有维护工艺路线即可
  369. var routings = workOrdRoutings.Where(p=>p.ItemNum == item.ItemNum).ToList();
  370. if (!routings.Any())
  371. {
  372. entity = new ScheduleExceptionMaster();
  373. entity.Domain = item.Domain;
  374. entity.WorkOrd = item.WorkOrd;
  375. entity.ItemNum = item.ItemNum;
  376. entity.CreateTime = DateTime.Now;
  377. entity.Remark = "排产异常:工单没有维护工艺路线,请维护后再操作!";
  378. entity.Type = type == 1 ? "自动排产" : "手动排产";
  379. entity.OptTime = optTime;
  380. exceptions.Add(entity);
  381. }
  382. //获取当前产线维护的工作日历
  383. var lineCals = calendars.Where(p => p.ProdLine == item.ProdLine).ToList();
  384. //获取默认工作日历
  385. var mrCals = calendars.Where(p => string.IsNullOrEmpty(p.ProdLine)).ToList();
  386. if (!lineCals.Any())//当前产线未维护工作日历
  387. {
  388. if (!mrCals.Any() || mrCals.Select(p => p.WeekDay).Distinct().Count() != 7)
  389. {
  390. entity = new ScheduleExceptionMaster();
  391. entity.Domain = item.Domain;
  392. entity.WorkOrd = item.WorkOrd;
  393. entity.ItemNum = item.ItemNum;
  394. entity.CreateTime = DateTime.Now;
  395. entity.Remark = "排产异常:产线[" + item.ProdLine + "]没有维护工作日历且标准工作日历未维护完全,请维护后再操作!";
  396. entity.Type = type == 1 ? "自动排产" : "手动排产";
  397. entity.OptTime = optTime;
  398. exceptions.Add(entity);
  399. }
  400. }
  401. else if (lineCals.Select(p => p.WeekDay).Distinct().Count() != 7)//当前产线维护了工作日历,但是没有维护完全
  402. {
  403. entity = new ScheduleExceptionMaster();
  404. entity.Domain = item.Domain;
  405. entity.WorkOrd = item.WorkOrd;
  406. entity.ItemNum = item.ItemNum;
  407. entity.CreateTime = DateTime.Now;
  408. entity.Remark = "排产异常:产线[" + item.ProdLine + "]工作日历没有维护完整,请维护后再操作!";
  409. entity.Type = type == 1 ? "自动排产" : "手动排产";
  410. entity.OptTime = optTime;
  411. exceptions.Add(entity);
  412. }
  413. continue;
  414. }
  415. var curRoutings = workOrdRoutings.Where(p => p.ItemNum == item.ItemNum && p.MilestoneOp).OrderBy(p=>p.OP).Select(p=>p.OP).ToList();
  416. //判断当前工单主产线是否设置了关键工序
  417. if (!curRoutings.Any())//当前工单没有维护关键工序
  418. {
  419. entity = new ScheduleExceptionMaster();
  420. entity.Domain = item.Domain;
  421. entity.WorkOrd = item.WorkOrd;
  422. entity.ItemNum = item.ItemNum;
  423. entity.CreateTime = DateTime.Now;
  424. entity.Remark = "排产异常:工单的工艺路径没有维护关键工序,请维护后再操作!";
  425. entity.Type = type == 1 ? "自动排产" : "手动排产";
  426. entity.OptTime = optTime;
  427. exceptions.Add(entity);
  428. continue;
  429. }
  430. //获取当前工单物料对应的产线信息
  431. var lineDetails = prodLines.Where(x => x.Part == item.ItemNum && curRoutings.Contains(x.Op)).ToList();
  432. if (!lineDetails.Any())
  433. {
  434. entity = new ScheduleExceptionMaster();
  435. entity.Domain = item.Domain;
  436. entity.WorkOrd = item.WorkOrd;
  437. entity.ItemNum = item.ItemNum;
  438. entity.CreateTime = DateTime.Now;
  439. entity.Remark = "排产异常:工单的关键工序没有维护产线数据,请维护后再操作!";
  440. entity.Type = type == 1 ? "自动排产" : "手动排产";
  441. entity.OptTime = optTime;
  442. exceptions.Add(entity);
  443. continue;
  444. }
  445. //校验关键工序是否维护了产线
  446. List<LineStartDto> lines = new List<LineStartDto>();
  447. foreach (var op in curRoutings)
  448. {
  449. var curLines = lineDetails.Where(p => p.Op == op).ToList();
  450. if (!curLines.Any())//当前Op没有维护产线
  451. {
  452. entity = new ScheduleExceptionMaster();
  453. entity.Domain = item.Domain;
  454. entity.WorkOrd = item.WorkOrd;
  455. entity.ItemNum = item.ItemNum;
  456. entity.CreateTime = DateTime.Now;
  457. entity.Remark = "排产异常:工单的关键工序["+ op + "]没有维护产线数据,请维护后再操作!";
  458. entity.Type = type == 1 ? "自动排产" : "手动排产";
  459. entity.OptTime = optTime;
  460. exceptions.Add(entity);
  461. }
  462. foreach (var line in curLines)
  463. {
  464. lines.Add(new LineStartDto {
  465. Line = line.Line,
  466. Op = op
  467. });
  468. }
  469. }
  470. //校验一条产线是否维护了多个关键工序
  471. List<string> pdLines = lines.Select(p => p.Line).Distinct().ToList();
  472. foreach (var line in pdLines)
  473. {
  474. var curLines = lines.Where(p => p.Line == line).ToList();
  475. if (curLines.Count() > 1)//当前物料的多个关键工序对应一条产线
  476. {
  477. entity = new ScheduleExceptionMaster();
  478. entity.Domain = item.Domain;
  479. entity.WorkOrd = item.WorkOrd;
  480. entity.ItemNum = item.ItemNum;
  481. entity.CreateTime = DateTime.Now;
  482. entity.Remark = "排产异常:工单的多个关键工序[" + string.Join("、",curLines.Select(p=>p.Op).ToList()) + "]对应同一条产线,请调整后再操作!";
  483. entity.Type = type == 1 ? "自动排产" : "手动排产";
  484. entity.OptTime = optTime;
  485. exceptions.Add(entity);
  486. }
  487. }
  488. //校验主产线关键工序对应的产线是否维护了工作日历
  489. var curCalendars = calendars.Where(x => lineDetails.Select(p => p.Line).Contains(x.ProdLine) || string.IsNullOrEmpty(x.ProdLine)).ToList();
  490. foreach (var rut in lineDetails)
  491. {
  492. //获取当前产线维护的工作日历
  493. var lineCals = curCalendars.Where(p => p.ProdLine == rut.Line).ToList();
  494. if (!lineCals.Any())//当前产线未维护工作日历
  495. {
  496. lineCals = calendars.Where(p => string.IsNullOrEmpty(p.ProdLine)).ToList();
  497. if (!lineCals.Any() || lineCals.Select(p => p.WeekDay).Distinct().Count() != 7)
  498. {
  499. entity = new ScheduleExceptionMaster();
  500. entity.Domain = item.Domain;
  501. entity.WorkOrd = item.WorkOrd;
  502. entity.ItemNum = item.ItemNum;
  503. entity.CreateTime = DateTime.Now;
  504. entity.Remark = "排产异常:产线["+rut.Line+ "]没有维护工作日历且标准工作日历未维护完全,请维护后再操作!";
  505. entity.Type = type == 1 ? "自动排产" : "手动排产";
  506. entity.OptTime = optTime;
  507. exceptions.Add(entity);
  508. }
  509. }
  510. else if (lineCals.Select(p => p.WeekDay).Distinct().Count() != 7)//当前产线维护了工作日历,但是没有维护完全
  511. {
  512. entity = new ScheduleExceptionMaster();
  513. entity.Domain = item.Domain;
  514. entity.WorkOrd = item.WorkOrd;
  515. entity.ItemNum = item.ItemNum;
  516. entity.CreateTime = DateTime.Now;
  517. entity.Remark = "排产异常:产线[" + rut.Line + "]工作日历没有维护完整,请维护后再操作!";
  518. entity.Type = type == 1 ? "自动排产" : "手动排产";
  519. entity.OptTime = optTime;
  520. exceptions.Add(entity);
  521. }
  522. }
  523. }
  524. return exceptions;
  525. }
  526. /// <summary>
  527. /// 排产
  528. /// </summary>
  529. /// <param name="workOrd">工单</param>
  530. /// <param name="workOrdRoutings">当前工单的工艺路线的关键工序(有几个关键工序就有几条产线)</param>
  531. /// <param name="prodLines">当前工单的产线明细</param>
  532. /// <param name="periodsDet">生产周期</param>
  533. /// <param name="scheduleResults">排产结果</param>
  534. /// <param name="allResults">产线占用记录</param>
  535. /// <param name="tsWorkOrds">特殊工单</param>
  536. /// <param name="ypcWorkOrds">已排产特殊工单的工单编号</param>
  537. /// <param name="tsWoRoutings">特殊工单的工艺路线</param>
  538. public void LineSchedule(WorkOrdMaster workOrd, List<WorkOrdRouting> workOrdRoutings, List<ProdLineDetail> prodLines,List<PeriodSequenceDet> periodsDet, List<ScheduleResultOpMaster> scheduleResults, List<ScheduleResultOpMaster> allResults,List<WorkOrdMaster> tsWorkOrds,List<string> ypcWorkOrds, List<WorkOrdRouting> tsWoRoutings)
  539. {
  540. //生产周期
  541. List<PeriodSequenceDet> curSequences = new List<PeriodSequenceDet>();
  542. //排产明细
  543. List<ScheduleResultOpMaster> curScheduleRsts = new List<ScheduleResultOpMaster>();
  544. //记录上一产线排产开始时间
  545. LineStartDto lineStart = new LineStartDto();
  546. //产线开工时间默认为当前日期的下一天
  547. lineStart.StartTime = DateTime.Now.Date.AddDays(1);
  548. TimeSpan span = TimeSpan.Zero;
  549. //第一层级工序有几个关键工序,就有几条产线
  550. for (int i = 0; i < workOrdRoutings.Count; i++)
  551. {
  552. //如果当前工序已经生产完成,则跳过
  553. if (workOrdRoutings[i].QtyComplete == workOrd.QtyOrded)
  554. {
  555. continue;
  556. }
  557. //产线实际排产开始时间
  558. if (i == 0)//第一条产线
  559. {
  560. lineStart = DealStartTime(workOrd, workOrdRoutings[i], prodLines, allResults);
  561. }
  562. else
  563. {
  564. //获取前一产线排产开始时间,通过提前期计算当前产线排产开始时间
  565. lineStart = DealNextStartTime(workOrd, lineStart, workOrdRoutings[i], prodLines, allResults);
  566. }
  567. //当前产线的工作日历
  568. var mLCalendars = calendars.Where(p => p.ProdLine == lineStart.Line || string.IsNullOrEmpty(p.ProdLine)).ToList();
  569. //当前产线的休息时间设置
  570. var mlqtyWorkDtls = qualityLines.Where(p => p.ProdLine == lineStart.Line).ToList();
  571. //产线排产开始时间
  572. DateTime workStartTime = lineStart.StartTime;
  573. //记录特殊工单:获取第一天是否有特殊工单
  574. List<WorkOrdMaster> fstWOMasters = tsWorkOrds.Where(p => p.ProdLine == lineStart.Line && p.OrdDate.Value.Date == workStartTime.Date).OrderBy(p => p.Priority).ToList();
  575. List<WorkOrdMstDto> workDtos = new List<WorkOrdMstDto>();
  576. //记录排产开始第二天及以后安排的特殊工单
  577. var secWOMasters = new List<WorkOrdMaster>();
  578. //特殊工单总清场时长(分钟)
  579. decimal sumCleanTimes = 0m;
  580. //最后一个特殊工单的清场时长(分钟)
  581. decimal lstCleanTime = 0m;
  582. //新增特殊工单最后一个清场时长
  583. decimal secCleanTime = 0m;
  584. //特殊工单排产需要考虑的时长
  585. decimal sumTsTimes = 0m;
  586. if (fstWOMasters.Any())
  587. {
  588. foreach (var item in fstWOMasters)
  589. {
  590. var curOp = tsWoRoutings.Where(p => p.WorkOrd == item.WorkOrd).OrderByDescending(p => p.OP).First();
  591. //剩余排产数量
  592. decimal qtyNeed = item.QtyOrded - curOp.QtyComplete;
  593. //剩余工作时长(分钟)
  594. decimal usedTime = Math.Ceiling(qtyNeed / item.QtyOrded * item.LbrVar * 60);
  595. workDtos.Add(new WorkOrdMstDto
  596. {
  597. WorkOrd = item.WorkOrd,
  598. ItemNum = item.ItemNum,
  599. QtyOrded = qtyNeed,
  600. LbrVar = usedTime,
  601. Worked = 0,
  602. QtyWorked = 0,
  603. Op = curOp.OP,
  604. WaitTime = curOp.WaitTime * 60,
  605. Priority = item.Priority
  606. });
  607. sumCleanTimes += curOp.WaitTime * 60;
  608. }
  609. //获取最后一个特殊工单的清场时长
  610. var last = fstWOMasters.Last();
  611. lstCleanTime = tsWoRoutings.Where(p => p.WorkOrd == last.WorkOrd).OrderByDescending(p => p.OP).First().WaitTime * 60;
  612. //特殊工单排产需要考虑的时长=特殊工单工作时长(分钟)+除最后一个特殊工单之外的清场时长
  613. sumTsTimes = workDtos.Sum(p => p.LbrVar) + sumCleanTimes - lstCleanTime;
  614. }
  615. //工单排产第一天标识
  616. bool isFstDay = true;
  617. //产线排产开始当天安排了特殊工单,则先安排特殊工单
  618. while (sumTsTimes > 0)
  619. {
  620. secWOMasters.Clear();
  621. //获取当天的产能
  622. LineScheduledDto dto = GetScheduledPoint(lineStart, workStartTime, mLCalendars, mlqtyWorkDtls);
  623. //获取当天的工作时间段
  624. var curCalendar = mLCalendars.FirstOrDefault(p => !string.IsNullOrEmpty(p.ProdLine) && p.WeekDay == (int)workStartTime.DayOfWeek);
  625. if (curCalendar == null)
  626. {
  627. curCalendar = mLCalendars.FirstOrDefault(p => string.IsNullOrEmpty(p.ProdLine) && p.WeekDay == (int)workStartTime.DayOfWeek);
  628. }
  629. List<LineWorkPointDto> workPoints = DealWorkDayToLevels(lineStart.Line, workStartTime, curCalendar, mlqtyWorkDtls);
  630. //特殊工单排产第一天之后:如果当天的可用产能大于特殊工单生产时长,此时需要考虑当天是否安排了其他的特殊工单
  631. if (dto.EffTime > sumTsTimes && !isFstDay)
  632. {
  633. //获取特殊工单
  634. secWOMasters = tsWorkOrds.Where(p => p.ProdLine == lineStart.Line && p.OrdDate.Value.Date == workStartTime.Date).OrderBy(p => p.Priority).ToList();
  635. if (secWOMasters.Any())
  636. {
  637. sumCleanTimes = 0m;
  638. //新增特殊工单最后一个清场时长
  639. secCleanTime = 0m;
  640. //生产时长
  641. decimal sumLbrVar = 0m;
  642. //记录新增待排产特殊工单
  643. foreach (var item in secWOMasters)
  644. {
  645. var curOp = tsWoRoutings.Where(p => p.WorkOrd == item.WorkOrd).OrderByDescending(p => p.OP).First();
  646. //剩余排产数量
  647. decimal qtyNeed = item.QtyOrded - curOp.QtyComplete;
  648. //剩余工作时长(分钟)
  649. decimal usedTime = Math.Ceiling(qtyNeed / item.QtyOrded * item.LbrVar * 60);
  650. workDtos.Add(new WorkOrdMstDto
  651. {
  652. WorkOrd = item.WorkOrd,
  653. ItemNum = item.ItemNum,
  654. QtyOrded = qtyNeed,
  655. LbrVar = usedTime,
  656. Worked = 0,
  657. QtyWorked = 0,
  658. Op = curOp.OP,
  659. WaitTime = curOp.WaitTime * 60,
  660. Priority = item.Priority
  661. });
  662. sumLbrVar += usedTime;
  663. sumCleanTimes += curOp.WaitTime * 60;
  664. }
  665. //获取最后一个特殊工单的清场时长
  666. var last = secWOMasters.Last();
  667. secCleanTime = tsWoRoutings.Where(p => p.WorkOrd == last.WorkOrd).OrderByDescending(p => p.OP).First().WaitTime * 60;
  668. //特殊工单待排产时长=前一天特殊工单到最后一个清场时长+新增的特殊工单生产时长+新增特殊工单除最后一个清场时长之外的清场时长之和
  669. sumTsTimes += (lstCleanTime + sumLbrVar + sumCleanTimes - secCleanTime);
  670. lstCleanTime = secCleanTime;
  671. }
  672. }
  673. //特殊工单排序
  674. workDtos = workDtos.OrderBy(p => p.Priority).ToList();
  675. //当天的可用生产时长满足特殊工单生产时长+清场时间(最后一个工单清场时间除外)
  676. if (dto.EffTime >= sumTsTimes)
  677. {
  678. //可用生产时长(分钟)
  679. decimal remainTime = dto.EffTime;
  680. DateTime beginTime = workStartTime;
  681. DateTime endTime = dto.EndTime;
  682. //获取最后一个工单
  683. var lastWork = workDtos.Last();
  684. //开始或结束时间所处时间段
  685. var curPoint = new LineWorkPointDto();
  686. //特殊工单排产
  687. foreach (var item in workDtos)
  688. {
  689. //当前工单已排产,跳过
  690. if (item.LbrVar == item.Worked)
  691. {
  692. continue;
  693. }
  694. //当前工单排产需要时长
  695. decimal needTime = 0m;
  696. //最后一个特殊工单
  697. if (item.WorkOrd == lastWork.WorkOrd)
  698. {
  699. //最后一个工单的生产时长+清场时长
  700. needTime = lastWork.LbrVar - lastWork.Worked + lastWork.WaitTime;
  701. //剩余可用工作时长满足最后一个特殊工单的生产时长+清场时长
  702. if (remainTime >= needTime)
  703. {
  704. //计算工单排产结束时间
  705. curPoint = workPoints.Find(p => p.StartPoint <= beginTime && beginTime <= p.EndPoint);
  706. //获取排产结束时间所处以及之后的生产时间段
  707. var nextPoints = workPoints.Where(p => p.Level >= curPoint.Level).OrderBy(p => p.Level).ToList();
  708. //处理第一个时间段的开始时间
  709. nextPoints[0].StartPoint = beginTime;
  710. foreach (var p in nextPoints)
  711. {
  712. span = p.EndPoint - p.StartPoint;
  713. //当前工作时间段的有效生产时间
  714. decimal effMins = (decimal)span.TotalMinutes;
  715. if (effMins >= needTime)
  716. {
  717. endTime = p.StartPoint.AddMinutes((double)needTime);
  718. break;
  719. }
  720. needTime -= effMins;
  721. remainTime -= effMins;
  722. }
  723. remainTime -= needTime;
  724. }
  725. //剩余可用工作时长不能满足清场时长
  726. else
  727. {
  728. //还需排产的清场时间
  729. decimal qcTime = needTime - remainTime;
  730. endTime = dto.EndTime.AddMinutes((double)qcTime);
  731. remainTime = 0;
  732. }
  733. //最后一个工单的清场时长
  734. lstCleanTime = 0m;
  735. }
  736. //最后一个特殊工单之前的工单:剩余排产时长和清场时间全部排产
  737. else {
  738. //当前工单还需工作时长+工单的清场时长
  739. needTime = item.LbrVar - item.Worked + item.WaitTime;
  740. //计算工单排产结束时间
  741. curPoint = workPoints.Find(p => p.StartPoint <= beginTime && beginTime <= p.EndPoint);
  742. span = curPoint.EndPoint - beginTime;
  743. //当天工作时间段的有效生产时间(分钟)
  744. decimal effMins = (decimal)span.TotalMinutes;
  745. if (effMins >= needTime)//当前工作时间段即可满足产能
  746. {
  747. endTime = beginTime.AddMinutes((double)needTime);
  748. }
  749. else
  750. {
  751. //获取后续生产时间段
  752. var nextPoints = workPoints.Where(p => p.Level > curPoint.Level).OrderBy(p => p.Level).ToList();
  753. //剩余需要工作时长
  754. decimal nextMins = needTime - effMins;
  755. foreach (var p in nextPoints)
  756. {
  757. if (p.WorkMinutes >= nextMins)
  758. {
  759. endTime = p.StartPoint.AddMinutes((double)nextMins);
  760. break;
  761. }
  762. nextMins -= p.WorkMinutes;
  763. }
  764. }
  765. remainTime -= needTime;
  766. }
  767. //记录生产周期
  768. curSequences.Add(new PeriodSequenceDet
  769. {
  770. Domain = domain,
  771. Line = lineStart.Line,
  772. ItemNum = item.ItemNum,
  773. PlanDate = beginTime.Date,
  774. Period = dto.Period,
  775. OrdQty = item.QtyOrded - item.QtyWorked,
  776. WorkOrds = item.WorkOrd,
  777. Op = item.Op,
  778. IsActive = true,
  779. Status = "",
  780. CreateTime = DateTime.Now
  781. });
  782. //记录排产记录
  783. curScheduleRsts.Add(new ScheduleResultOpMaster
  784. {
  785. Domain = domain,
  786. WorkOrd = item.WorkOrd,
  787. Line = lineStart.Line,
  788. ItemNum = item.ItemNum,
  789. Op = item.Op,
  790. WorkDate = beginTime.Date,
  791. WorkQty = item.QtyOrded - item.QtyWorked,
  792. WorkStartTime = beginTime,
  793. WorkEndTime = endTime,
  794. CreateTime = DateTime.Now
  795. });
  796. //下一工单开始时间=当前工单结束时间,如果位于工作区间结尾,则为下一工作区间开始时间
  797. curPoint = workPoints.FirstOrDefault(p => p.StartPoint <= endTime && endTime <= p.EndPoint);
  798. //结束时间位于工作区间结尾
  799. if (curPoint != null && endTime == curPoint.EndPoint)
  800. {
  801. //获取后续生产时间段
  802. curPoint = workPoints.FirstOrDefault(p => p.Level == curPoint.Level + 1);
  803. //存在后续工作区间
  804. if (curPoint != null)
  805. {
  806. endTime = curPoint.StartPoint;
  807. }
  808. }
  809. beginTime = endTime;
  810. //工单排产完成,排产时长=工单工作时长
  811. item.Worked = item.LbrVar;
  812. item.QtyWorked = item.QtyOrded;
  813. }
  814. //当天产能完全占用,且最后一个工单的清场时间刚好下班或者在下班后
  815. if (endTime >= dto.EndTime)
  816. {
  817. sumTsTimes = 0;//排产完毕,特殊工单时长置0
  818. //获取下一个工作日
  819. workStartTime = GetNextWorkDay((int)workStartTime.DayOfWeek, workStartTime, mLCalendars);
  820. isFstDay = true;
  821. //特殊工单排产完成,占用了当天的全部产能,则需要判断下一个工作日是否存在特殊工单,如果存在,则需要继续排特殊工单
  822. secWOMasters = tsWorkOrds.Where(p => p.ProdLine == lineStart.Line && p.OrdDate.Value.Date == workStartTime.Date).OrderBy(p => p.Priority).ToList();
  823. //记录新增待排产特殊工单
  824. if (secWOMasters.Any())
  825. {
  826. sumCleanTimes = 0m;
  827. //新增特殊工单最后一个清场时长(分钟)
  828. secCleanTime = 0m;
  829. //生产时长
  830. decimal sumLbrVar = 0m;
  831. foreach (var item in secWOMasters)
  832. {
  833. var curOp = tsWoRoutings.Where(p => p.WorkOrd == item.WorkOrd).OrderByDescending(p => p.OP).First();
  834. //剩余排产数量
  835. decimal qtyNeed = item.QtyOrded - curOp.QtyComplete;
  836. //剩余工作时长(分钟)
  837. decimal usedTime = Math.Ceiling(qtyNeed / item.QtyOrded * item.LbrVar * 60);
  838. workDtos.Add(new WorkOrdMstDto
  839. {
  840. WorkOrd = item.WorkOrd,
  841. ItemNum = item.ItemNum,
  842. QtyOrded = qtyNeed,
  843. LbrVar = usedTime,
  844. Worked = 0,
  845. QtyWorked = 0,
  846. Op = curOp.OP,
  847. WaitTime = curOp.WaitTime * 60,
  848. Priority = item.Priority
  849. });
  850. sumCleanTimes += curOp.WaitTime * 60;
  851. sumLbrVar += usedTime;
  852. }
  853. //获取最后一个特殊工单的清场时长
  854. var last = secWOMasters.Last();
  855. secCleanTime = tsWoRoutings.Where(p => p.WorkOrd == last.WorkOrd).OrderByDescending(p => p.OP).First().WaitTime * 60;
  856. //特殊工单待排产时长=前一天特殊工单到最后一个清场时长+新增的特殊工单生产时长+新增特殊工单除最后一个清场时长之外的清场时长之和
  857. sumTsTimes += (lstCleanTime + sumLbrVar + sumCleanTimes - secCleanTime);
  858. lstCleanTime = secCleanTime;
  859. }
  860. }
  861. //当天可用生产时长大于特殊工单生产时长+最后一个工单的清场时长
  862. else
  863. {
  864. //排产完毕,特殊工单时长置0
  865. sumTsTimes = 0;
  866. //处理workStartTime
  867. workStartTime = endTime;
  868. }
  869. }
  870. //当天的可用产能不满足特殊工单生产时长,则当天产能全部排特殊工单(至少最后一个特殊工单的生产时长不能满足)
  871. else
  872. {
  873. decimal residueTime = dto.EffTime;//当天产能剩余产能(分钟)
  874. DateTime beginTime = workStartTime;//排产开始时间
  875. DateTime endTime = dto.EndTime;//排产结束时间
  876. foreach (var item in workDtos)
  877. {
  878. if (item.LbrVar == item.Worked)//当前工单已排产
  879. {
  880. continue;
  881. }
  882. //当前工单剩余待排产时长(分钟)
  883. decimal needTime = item.LbrVar - item.Worked;
  884. //当天剩余产能满足当前工单的剩余待排产时长(则当前工单的清场时间必定排完)
  885. if (residueTime >= needTime)
  886. {
  887. //计算工单排产结束时间
  888. var curPoint = workPoints.Find(p => p.StartPoint <= beginTime && beginTime <= p.EndPoint);
  889. span = curPoint.EndPoint - beginTime;
  890. //当前工作时间段的有效生产时间(分钟)
  891. decimal effMins = (decimal)span.TotalMinutes;
  892. if (effMins >= needTime)//当前工作时间段即可满足产能
  893. {
  894. endTime = beginTime.AddMinutes((double)needTime);
  895. }
  896. else
  897. {
  898. //获取后续生产时间段
  899. var nextPoints = workPoints.Where(p => p.Level > curPoint.Level).OrderBy(p => p.Level).ToList();
  900. //剩余需要工作时长
  901. decimal nextMins = needTime - effMins;
  902. foreach (var p in nextPoints)
  903. {
  904. if (p.WorkMinutes >= nextMins)
  905. {
  906. endTime = p.StartPoint.AddMinutes((double)nextMins);
  907. break;
  908. }
  909. nextMins -= p.WorkMinutes;
  910. }
  911. }
  912. //当天剩余可用生产时长
  913. residueTime -= needTime;
  914. //处理清场时间,两种场景:
  915. //1、residueTime<=item.WaitTime,结束时间加上剩余清场时长
  916. if (residueTime <= item.WaitTime)
  917. {
  918. //仍需排产的清场时长
  919. decimal otherTime = item.WaitTime - residueTime;
  920. endTime = dto.EndTime.AddMinutes((double)otherTime);
  921. residueTime = 0;
  922. }
  923. //2、residueTime>item.WaitTime,剩余时长大于清场时长,需要过滤休息时间
  924. else
  925. {
  926. //清场时长
  927. needTime = item.WaitTime;
  928. //获取工单排产结束时间所处时间段
  929. curPoint = workPoints.Find(p => p.StartPoint <= endTime && endTime <= p.EndPoint);
  930. span = curPoint.EndPoint - endTime;
  931. //当前工作时间段的有效生产时间(分钟)
  932. effMins = (decimal)span.TotalMinutes;
  933. //当前工作时间段即可清场时长
  934. if (effMins >= needTime)
  935. {
  936. endTime = endTime.AddMinutes((double)needTime);
  937. }
  938. else
  939. {
  940. //获取后续生产时间段
  941. var nextPoints = workPoints.Where(p => p.Level > curPoint.Level).OrderBy(p => p.Level).ToList();
  942. //剩余需要工作时长
  943. decimal nextMins = needTime - effMins;
  944. foreach (var p in nextPoints)
  945. {
  946. if (p.WorkMinutes >= nextMins)
  947. {
  948. endTime = p.StartPoint.AddMinutes((double)nextMins);
  949. break;
  950. }
  951. nextMins -= p.WorkMinutes;
  952. }
  953. }
  954. residueTime -= needTime;
  955. }
  956. //处理特殊工单剩余时长减去当前工单待排产时长和清场时长
  957. sumTsTimes -= (item.LbrVar - item.Worked + item.WaitTime);
  958. //记录生产周期
  959. curSequences.Add(new PeriodSequenceDet
  960. {
  961. Domain = domain,
  962. Line = lineStart.Line,
  963. ItemNum = item.ItemNum,
  964. PlanDate = beginTime.Date,
  965. Period = dto.Period,
  966. OrdQty = item.QtyOrded - item.QtyWorked,
  967. WorkOrds = item.WorkOrd,
  968. Op = item.Op,
  969. IsActive = true,
  970. Status = "",
  971. CreateTime = DateTime.Now
  972. });
  973. //记录排产记录
  974. curScheduleRsts.Add(new ScheduleResultOpMaster
  975. {
  976. Domain = domain,
  977. WorkOrd = item.WorkOrd,
  978. Line = lineStart.Line,
  979. ItemNum = item.ItemNum,
  980. Op = item.Op,
  981. WorkDate = beginTime.Date,
  982. WorkQty = item.QtyOrded - item.QtyWorked,
  983. WorkStartTime = beginTime,
  984. WorkEndTime = endTime,
  985. CreateTime = DateTime.Now
  986. });
  987. //当前工单已排产完成,已排产时间=工单生产时长,已排产数量=工单数量
  988. item.Worked = item.LbrVar;
  989. item.QtyWorked = item.QtyOrded;
  990. beginTime = endTime;
  991. //当天可用生产时长还有剩余
  992. if (residueTime > 0)
  993. {
  994. //获取结束时间所处时间段
  995. curPoint = workPoints.FirstOrDefault(p => p.StartPoint <= endTime && endTime <= p.EndPoint);
  996. if (endTime == curPoint.EndPoint)
  997. {
  998. var nextPoint = workPoints.FirstOrDefault(p => p.Level == curPoint.Level + 1);
  999. endTime = nextPoint == null ? endTime : nextPoint.StartPoint;
  1000. }
  1001. beginTime = endTime;
  1002. }
  1003. //当天可用产能已全部用完
  1004. else {
  1005. break;
  1006. }
  1007. }
  1008. //当天剩余产能不满足当前工单的剩余待排产时长
  1009. else
  1010. {
  1011. //计算生产数量
  1012. decimal qty = Math.Ceiling(residueTime / item.LbrVar * item.QtyOrded);
  1013. //记录生产周期
  1014. curSequences.Add(new PeriodSequenceDet
  1015. {
  1016. Domain = domain,
  1017. Line = lineStart.Line,
  1018. ItemNum = item.ItemNum,
  1019. PlanDate = beginTime.Date,
  1020. Period = dto.Period,
  1021. OrdQty = qty,
  1022. WorkOrds = item.WorkOrd,
  1023. Op = item.Op,
  1024. IsActive = true,
  1025. Status = "",
  1026. CreateTime = DateTime.Now
  1027. });
  1028. //记录排产记录
  1029. curScheduleRsts.Add(new ScheduleResultOpMaster
  1030. {
  1031. Domain = domain,
  1032. WorkOrd = item.WorkOrd,
  1033. Line = lineStart.Line,
  1034. ItemNum = item.ItemNum,
  1035. Op = item.Op,
  1036. WorkDate = beginTime.Date,
  1037. WorkQty = qty,
  1038. WorkStartTime = beginTime,
  1039. WorkEndTime = endTime,
  1040. CreateTime = DateTime.Now
  1041. });
  1042. item.Worked += residueTime;
  1043. item.QtyWorked += qty;
  1044. //特殊工单剩余待排产时长(分钟)
  1045. sumTsTimes -= residueTime;
  1046. residueTime = 0;
  1047. break;
  1048. }
  1049. }
  1050. //获取下一个工作日
  1051. workStartTime = GetNextWorkDay((int)workStartTime.DayOfWeek, workStartTime, mLCalendars);
  1052. isFstDay = false;
  1053. }
  1054. }
  1055. //记录已排产特殊工单
  1056. ypcWorkOrds.AddRange(workDtos.Select(p => p.WorkOrd).ToList());
  1057. //正常工单排产
  1058. //正常工单产线已排产数量
  1059. decimal sumQty = 0m;
  1060. //产线准备时间(分钟)
  1061. decimal sumTimes = 0m;
  1062. fstWOMasters.Clear();
  1063. workDtos.Clear();
  1064. sumTsTimes = 0m;
  1065. lstCleanTime = 0m;
  1066. //工单排产第一天标识
  1067. isFstDay = true;
  1068. //前一天是否有特殊工单未排产完全
  1069. bool isFullPC = true;
  1070. while (sumQty < lineStart.QtyRemain || sumTsTimes > 0)
  1071. {
  1072. secWOMasters.Clear();
  1073. sumCleanTimes = 0m;
  1074. secCleanTime = 0m;
  1075. //获取当天的产能
  1076. LineScheduledDto dto = GetScheduledPoint(lineStart, workStartTime, mLCalendars, mlqtyWorkDtls);
  1077. //获取当天的工作时间段
  1078. var curCalendar = mLCalendars.FirstOrDefault(p => !string.IsNullOrEmpty(p.ProdLine) && p.WeekDay == (int)workStartTime.DayOfWeek);
  1079. if (curCalendar == null)
  1080. {
  1081. curCalendar = mLCalendars.FirstOrDefault(p => string.IsNullOrEmpty(p.ProdLine) && p.WeekDay == (int)workStartTime.DayOfWeek);
  1082. }
  1083. List<LineWorkPointDto> workPoints = DealWorkDayToLevels(lineStart.Line, workStartTime, curCalendar, mlqtyWorkDtls);
  1084. //正常工单排产第一天没有特殊工单,第一天之后才需要考虑是否有特殊工单
  1085. if (!isFstDay)
  1086. {
  1087. //获取特殊工单
  1088. secWOMasters = tsWorkOrds.Where(p => p.ProdLine == lineStart.Line && p.OrdDate.Value.Date == workStartTime.Date).OrderBy(p => p.Priority).ToList();
  1089. if (secWOMasters.Any())
  1090. {
  1091. //生产时长
  1092. decimal sumLbrVar = 0m;
  1093. foreach (var item in secWOMasters)
  1094. {
  1095. var curOp = tsWoRoutings.Where(p => p.WorkOrd == item.WorkOrd).OrderByDescending(p => p.OP).First();
  1096. //剩余排产数量
  1097. decimal qtyNeed = item.QtyOrded - curOp.QtyComplete;
  1098. //剩余工作时长(分钟)
  1099. decimal usedTime = Math.Ceiling(qtyNeed / item.QtyOrded * item.LbrVar * 60);
  1100. workDtos.Add(new WorkOrdMstDto
  1101. {
  1102. WorkOrd = item.WorkOrd,
  1103. ItemNum = item.ItemNum,
  1104. QtyOrded = qtyNeed,
  1105. LbrVar = usedTime,
  1106. Worked = 0,
  1107. QtyWorked = 0,
  1108. Op = curOp.OP,
  1109. WaitTime = curOp.WaitTime * 60,
  1110. Priority = item.Priority
  1111. });
  1112. sumLbrVar += usedTime;
  1113. sumCleanTimes += curOp.WaitTime * 60;
  1114. }
  1115. //获取最后一个特殊工单的清场时长
  1116. var last = secWOMasters.Last();
  1117. secCleanTime = tsWoRoutings.Where(p => p.WorkOrd == last.WorkOrd).OrderByDescending(p => p.OP).First().WaitTime * 60;
  1118. //特殊工单待排产时长=前一天特殊工单到最后一个清场时长+新增的特殊工单生产时长+新增特殊工单除最后一个清场时长之外的清场时长之和
  1119. sumTsTimes += (lstCleanTime + sumLbrVar + sumCleanTimes - secCleanTime);
  1120. lstCleanTime = secCleanTime;
  1121. }
  1122. }
  1123. //排产开始时,需要先减去产线准备时间(产线提前期满足的当天排产)
  1124. if (sumTimes < lineStart.setupTime * 60)
  1125. {
  1126. //当天的可用生产时长能满足提前期
  1127. if (dto.EffTime > lineStart.setupTime * 60 - sumTimes)
  1128. {
  1129. //当天剩余时长(分钟)=当天可用上产时长-剩余产线准备时间
  1130. decimal residueTime = dto.EffTime - (lineStart.setupTime * 60 - sumTimes);
  1131. //产线提前期安排完之后,需要考虑当前是否存在特殊工单:
  1132. //1、如果当天是排产的最后一天,则先排完正常工单,再安排特殊工单;
  1133. //2、如果是排产中间日期,则先安排特殊工单排产
  1134. //当天剩余产能
  1135. decimal sumAmount = Math.Floor(dto.Rate * residueTime / 60);
  1136. //已排产数量+当天的剩余产能小于工单剩余需排产数量,当天的产能需要全部排产
  1137. if (sumQty + sumAmount < lineStart.QtyRemain)
  1138. {
  1139. //当天有特殊工单,且当天的产能不能满足工单剩余需排产数量,则优先排特殊工单
  1140. if (sumTsTimes > 0)
  1141. {
  1142. //特殊工单排序
  1143. workDtos = workDtos.OrderBy(p => p.Priority).ToList();
  1144. DateTime beginTime = workStartTime;//排产开始时间
  1145. DateTime endTime = dto.EndTime;//排产结束时间
  1146. //当天的可用生产时长满足特殊工单生产时长+清场时长(最后一个特殊工单的清场时长除外)
  1147. if (residueTime >= sumTsTimes)
  1148. {
  1149. //获取最后一个工单
  1150. var lastWork = workDtos.Last();
  1151. //开始或结束时间所处时间段
  1152. var curPoint = new LineWorkPointDto();
  1153. //特殊工单排产
  1154. foreach (var item in workDtos)
  1155. {
  1156. //当前工单已排产,跳过
  1157. if (item.LbrVar == item.Worked)
  1158. {
  1159. continue;
  1160. }
  1161. //当前工单排产需要时长
  1162. decimal needTime = 0m;
  1163. //最后一个特殊工单
  1164. if (item.WorkOrd == lastWork.WorkOrd)
  1165. {
  1166. //最后一个工单的生产时长+清场时长
  1167. needTime = lastWork.LbrVar - lastWork.Worked + lastWork.WaitTime;
  1168. //剩余可用工作时长满足最后一个特殊工单的生产时长+清场时长,需要过滤掉休息时间
  1169. if (residueTime >= needTime)
  1170. {
  1171. //计算工单排产结束时间
  1172. curPoint = workPoints.Find(p => p.StartPoint <= beginTime && beginTime <= p.EndPoint);
  1173. //获取排产结束时间所处以及之后的生产时间段
  1174. var nextPoints = workPoints.Where(p => p.Level >= curPoint.Level).OrderBy(p => p.Level).ToList();
  1175. //处理第一个时间段的开始时间
  1176. nextPoints[0].StartPoint = beginTime;
  1177. foreach (var p in nextPoints)
  1178. {
  1179. span = p.EndPoint - p.StartPoint;
  1180. //当前工作时间段的有效生产时间
  1181. decimal effMins = (decimal)span.TotalMinutes;
  1182. if (effMins >= needTime)
  1183. {
  1184. endTime = p.StartPoint.AddMinutes((double)needTime);
  1185. break;
  1186. }
  1187. needTime -= effMins;
  1188. residueTime -= effMins;
  1189. }
  1190. //剩余可用生产时长
  1191. residueTime -= needTime;
  1192. }
  1193. //剩余可用工作时长不能满足清场时长
  1194. else
  1195. {
  1196. //还需排产的清场时间
  1197. decimal qcTime = needTime - residueTime;
  1198. endTime = dto.EndTime.AddMinutes((double)qcTime);
  1199. residueTime = 0;
  1200. }
  1201. }
  1202. //最后一个特殊工单之前的工单:剩余排产时长和清场时间全部排产
  1203. else
  1204. {
  1205. //当前工单还需工作时长+清场时长
  1206. needTime = item.LbrVar - item.Worked + item.WaitTime;
  1207. //计算工单排产结束时间
  1208. curPoint = workPoints.Find(p => p.StartPoint <= beginTime && beginTime <= p.EndPoint);
  1209. span = curPoint.EndPoint - beginTime;
  1210. //当天工作时间段的有效生产时间(分钟)
  1211. decimal effMins = (decimal)span.TotalMinutes;
  1212. //当前工作时间段即可满足产能
  1213. if (effMins >= needTime)
  1214. {
  1215. endTime = beginTime.AddMinutes((double)needTime);
  1216. }
  1217. else
  1218. {
  1219. //获取后续生产时间段
  1220. var nextPoints = workPoints.Where(p => p.Level > curPoint.Level).OrderBy(p => p.Level).ToList();
  1221. //剩余需要工作时长
  1222. decimal nextMins = needTime - effMins;
  1223. foreach (var p in nextPoints)
  1224. {
  1225. if (p.WorkMinutes >= nextMins)
  1226. {
  1227. endTime = p.StartPoint.AddMinutes((double)nextMins);
  1228. break;
  1229. }
  1230. nextMins -= p.WorkMinutes;
  1231. }
  1232. }
  1233. residueTime -= needTime;
  1234. }
  1235. //记录生产周期
  1236. curSequences.Add(new PeriodSequenceDet
  1237. {
  1238. Domain = domain,
  1239. Line = lineStart.Line,
  1240. ItemNum = item.ItemNum,
  1241. PlanDate = beginTime.Date,
  1242. Period = dto.Period,
  1243. OrdQty = item.QtyOrded - item.QtyWorked,
  1244. WorkOrds = item.WorkOrd,
  1245. Op = item.Op,
  1246. IsActive = true,
  1247. Status = "",
  1248. CreateTime = DateTime.Now
  1249. });
  1250. //记录排产记录
  1251. curScheduleRsts.Add(new ScheduleResultOpMaster
  1252. {
  1253. Domain = domain,
  1254. WorkOrd = item.WorkOrd,
  1255. Line = lineStart.Line,
  1256. ItemNum = item.ItemNum,
  1257. Op = item.Op,
  1258. WorkDate = beginTime.Date,
  1259. WorkQty = item.QtyOrded - item.QtyWorked,
  1260. WorkStartTime = beginTime,
  1261. WorkEndTime = endTime,
  1262. CreateTime = DateTime.Now
  1263. });
  1264. //下一工单开始时间=当前工单结束时间,如果位于工作区间结尾,则为下一工作区间开始时间
  1265. curPoint = workPoints.Find(p => p.StartPoint <= endTime && endTime <= p.EndPoint);
  1266. //结束时间位于工作区间结尾
  1267. if (curPoint != null && endTime == curPoint.EndPoint)
  1268. {
  1269. //获取后续生产时间段
  1270. curPoint = workPoints.Where(p => p.Level == curPoint.Level + 1).FirstOrDefault();
  1271. //存在后续工作区间
  1272. if (curPoint != null)
  1273. {
  1274. endTime = curPoint.StartPoint;
  1275. }
  1276. }
  1277. beginTime = endTime;
  1278. //工单排产完成,排产时长=工单工作时长
  1279. item.Worked = item.LbrVar;
  1280. item.QtyWorked = item.QtyOrded;
  1281. }
  1282. //剩余生产时长大于0,继续排正常工单(剩余产能<工单剩余待排产数量,当天不需要考虑该工单的清场时间)
  1283. if (residueTime >0)
  1284. {
  1285. //处理正常工单开工时间
  1286. workStartTime = endTime;
  1287. //剩余产能继续排正常工单
  1288. sumAmount = Math.Floor(dto.Rate * residueTime / 60);
  1289. //记录生产周期
  1290. curSequences.Add(new PeriodSequenceDet
  1291. {
  1292. Domain = domain,
  1293. Line = lineStart.Line,
  1294. ItemNum = workOrd.ItemNum,
  1295. PlanDate = workStartTime.Date,
  1296. Period = dto.Period,
  1297. OrdQty = sumAmount,
  1298. WorkOrds = workOrd.WorkOrd,
  1299. Op = lineStart.Op,
  1300. IsActive = true,
  1301. Status = "",
  1302. CreateTime = DateTime.Now
  1303. });
  1304. //记录排产记录
  1305. curScheduleRsts.Add(new ScheduleResultOpMaster
  1306. {
  1307. Domain = domain,
  1308. WorkOrd = workOrd.WorkOrd,
  1309. Line = lineStart.Line,
  1310. ItemNum = workOrd.ItemNum,
  1311. Op = lineStart.Op,
  1312. WorkDate = workStartTime.Date,
  1313. WorkQty = sumAmount,
  1314. WorkStartTime = workStartTime,
  1315. WorkEndTime = dto.EndTime,
  1316. CreateTime = DateTime.Now
  1317. });
  1318. //累计已排产数量
  1319. sumQty += sumAmount;
  1320. }
  1321. //继续排下一个工作日
  1322. workStartTime = GetNextWorkDay((int)workStartTime.DayOfWeek, workStartTime, mLCalendars);
  1323. isFstDay = false;
  1324. //排产完毕,特殊工单时长置0
  1325. sumTsTimes = 0;
  1326. isFullPC = true;
  1327. //最后一个工单的清场时长
  1328. lstCleanTime = 0m;
  1329. }
  1330. //当天的可用产能不满足特殊工单生产时长(最后一个工单的生产时长必定不满足)
  1331. else
  1332. {
  1333. foreach (var item in workDtos)
  1334. {
  1335. if (item.LbrVar == item.Worked)//当前工单已排产
  1336. {
  1337. continue;
  1338. }
  1339. //当前工单剩余待排产时长(分钟)
  1340. decimal needTime = item.LbrVar - item.Worked;
  1341. //当天剩余产能满足当前工单的剩余待排产时长,则当前工单的清场时长必定排完
  1342. if (residueTime >= needTime)
  1343. {
  1344. //计算工单排产结束时间
  1345. var curPoint = workPoints.Find(p => p.StartPoint <= beginTime && beginTime <= p.EndPoint);
  1346. span = curPoint.EndPoint - beginTime;
  1347. //当前工作时间段的有效生产时间(分钟)
  1348. decimal effMins = (decimal)span.TotalMinutes;
  1349. //当前工作时间段即可满足产能
  1350. if (effMins >= needTime)
  1351. {
  1352. endTime = beginTime.AddMinutes((double)needTime);
  1353. }
  1354. else
  1355. {
  1356. //获取后续生产时间段
  1357. var nextPoints = workPoints.Where(p => p.Level > curPoint.Level).OrderBy(p => p.Level).ToList();
  1358. //剩余需要工作时长
  1359. decimal nextMins = needTime - effMins;
  1360. foreach (var p in nextPoints)
  1361. {
  1362. if (p.WorkMinutes >= nextMins)
  1363. {
  1364. endTime = p.StartPoint.AddMinutes((double)nextMins);
  1365. break;
  1366. }
  1367. nextMins -= p.WorkMinutes;
  1368. }
  1369. }
  1370. //当天剩余可用生产时长
  1371. residueTime -= needTime;
  1372. //处理清场时间,两种场景:
  1373. //1、residueTime<=item.WaitTime,结束时间加上剩余清场时长
  1374. if (residueTime <= item.WaitTime)
  1375. {
  1376. //仍需排产的清场时长
  1377. decimal otherTime = item.WaitTime - residueTime;
  1378. endTime = dto.EndTime.AddMinutes((double)otherTime);
  1379. residueTime = 0;
  1380. }
  1381. //2、residueTime>item.WaitTime,剩余时长大于清场时长,需要过滤休息时间
  1382. else
  1383. {
  1384. //清场时长
  1385. needTime = item.WaitTime;
  1386. //获取工单排产结束时间所处时间段
  1387. curPoint = workPoints.Find(p => p.StartPoint <= endTime && endTime <= p.EndPoint);
  1388. span = curPoint.EndPoint - endTime;
  1389. //当前工作时间段的有效生产时间(分钟)
  1390. effMins = (decimal)span.TotalMinutes;
  1391. //当前工作时间段即可清场时长
  1392. if (effMins >= needTime)
  1393. {
  1394. endTime = endTime.AddMinutes((double)needTime);
  1395. }
  1396. else
  1397. {
  1398. //获取后续生产时间段
  1399. var nextPoints = workPoints.Where(p => p.Level > curPoint.Level).OrderBy(p => p.Level).ToList();
  1400. //剩余需要工作时长
  1401. decimal nextMins = needTime - effMins;
  1402. foreach (var p in nextPoints)
  1403. {
  1404. if (p.WorkMinutes >= nextMins)
  1405. {
  1406. endTime = p.StartPoint.AddMinutes((double)nextMins);
  1407. break;
  1408. }
  1409. nextMins -= p.WorkMinutes;
  1410. }
  1411. }
  1412. //剩余生产时长
  1413. residueTime -= needTime;
  1414. }
  1415. //处理特殊工单剩余时长减去当前工单待排产时长和清场时长
  1416. sumTsTimes -= (item.LbrVar - item.Worked + item.WaitTime);
  1417. //记录生产周期
  1418. curSequences.Add(new PeriodSequenceDet
  1419. {
  1420. Domain = domain,
  1421. Line = lineStart.Line,
  1422. ItemNum = item.ItemNum,
  1423. PlanDate = beginTime.Date,
  1424. Period = dto.Period,
  1425. OrdQty = item.QtyOrded - item.QtyWorked,
  1426. WorkOrds = item.WorkOrd,
  1427. Op = item.Op,
  1428. IsActive = true,
  1429. Status = "",
  1430. CreateTime = DateTime.Now
  1431. });
  1432. //记录排产记录
  1433. curScheduleRsts.Add(new ScheduleResultOpMaster
  1434. {
  1435. Domain = domain,
  1436. WorkOrd = item.WorkOrd,
  1437. Line = lineStart.Line,
  1438. ItemNum = item.ItemNum,
  1439. Op = item.Op,
  1440. WorkDate = beginTime.Date,
  1441. WorkQty = item.QtyOrded - item.QtyWorked,
  1442. WorkStartTime = beginTime,
  1443. WorkEndTime = endTime,
  1444. CreateTime = DateTime.Now
  1445. });
  1446. //当前工单已排产完成,已排产时间=工单生产时长,已排产数量=工单数量
  1447. item.Worked = item.LbrVar;
  1448. item.QtyWorked = item.QtyOrded;
  1449. beginTime = endTime;
  1450. //当天可用生产时长还有剩余
  1451. if (residueTime > 0)
  1452. {
  1453. curPoint = workPoints.Find(p => p.StartPoint <= endTime && endTime <= p.EndPoint);
  1454. if (endTime == curPoint.EndPoint)
  1455. {
  1456. var nextPoint = workPoints.FirstOrDefault(p => p.Level == curPoint.Level + 1);
  1457. endTime = nextPoint == null ? endTime : nextPoint.StartPoint;
  1458. }
  1459. beginTime = endTime;
  1460. }
  1461. //当天剩余产能排完
  1462. else {
  1463. break;
  1464. }
  1465. }
  1466. //当天剩余产能不满足当前工单的剩余待排产时长
  1467. else
  1468. {
  1469. //计算生产数量
  1470. decimal qty = Math.Ceiling(residueTime / item.LbrVar * item.QtyOrded);
  1471. //记录生产周期
  1472. curSequences.Add(new PeriodSequenceDet
  1473. {
  1474. Domain = domain,
  1475. Line = lineStart.Line,
  1476. ItemNum = item.ItemNum,
  1477. PlanDate = beginTime.Date,
  1478. Period = dto.Period,
  1479. OrdQty = qty,
  1480. WorkOrds = item.WorkOrd,
  1481. Op = item.Op,
  1482. IsActive = true,
  1483. Status = "",
  1484. CreateTime = DateTime.Now
  1485. });
  1486. //记录排产记录
  1487. curScheduleRsts.Add(new ScheduleResultOpMaster
  1488. {
  1489. Domain = domain,
  1490. WorkOrd = item.WorkOrd,
  1491. Line = lineStart.Line,
  1492. ItemNum = item.ItemNum,
  1493. Op = item.Op,
  1494. WorkDate = beginTime.Date,
  1495. WorkQty = qty,
  1496. WorkStartTime = beginTime,
  1497. WorkEndTime = dto.EndTime,
  1498. CreateTime = DateTime.Now
  1499. });
  1500. item.Worked += residueTime;
  1501. item.QtyWorked += qty;
  1502. //特殊工单剩余待排产时长(分钟)
  1503. sumTsTimes -= residueTime;
  1504. residueTime = 0m;
  1505. break;
  1506. }
  1507. }
  1508. //当天产能不能满足特殊工单排产
  1509. isFullPC = false;
  1510. //获取下一个工作日
  1511. workStartTime = GetNextWorkDay((int)workStartTime.DayOfWeek, workStartTime, mLCalendars);
  1512. isFstDay = false;
  1513. }
  1514. }
  1515. //当天没有特殊工单,直接进行正常工单排产(当天产能<工单剩余待排产数量,当天不需要考虑该工单的清场时间)
  1516. else
  1517. {
  1518. //记录生产周期
  1519. curSequences.Add(new PeriodSequenceDet
  1520. {
  1521. Domain = domain,
  1522. Line = lineStart.Line,
  1523. ItemNum = workOrd.ItemNum,
  1524. PlanDate = workStartTime.Date,
  1525. Period = dto.Period,
  1526. OrdQty = sumAmount,
  1527. WorkOrds = workOrd.WorkOrd,
  1528. Op = lineStart.Op,
  1529. IsActive = true,
  1530. Status = "",
  1531. CreateTime = DateTime.Now
  1532. });
  1533. //记录排产记录
  1534. curScheduleRsts.Add(new ScheduleResultOpMaster
  1535. {
  1536. Domain = domain,
  1537. WorkOrd = workOrd.WorkOrd,
  1538. Line = lineStart.Line,
  1539. ItemNum = workOrd.ItemNum,
  1540. Op = lineStart.Op,
  1541. WorkDate = workStartTime.Date,
  1542. WorkQty = sumAmount,
  1543. WorkStartTime = dto.StartTime,
  1544. WorkEndTime = dto.EndTime,
  1545. CreateTime = DateTime.Now
  1546. });
  1547. //累计已排产数量
  1548. sumQty += sumAmount;
  1549. //继续排下一个工作日
  1550. workStartTime = GetNextWorkDay((int)workStartTime.DayOfWeek, workStartTime, mLCalendars);
  1551. isFstDay = false;
  1552. }
  1553. }
  1554. //当天的剩余产能可满足正常工单剩余待排产数量,则先排正常工单,需要考虑清场时间,如果有特殊工单,则后排
  1555. else
  1556. {
  1557. #region 正常工单排产-开始
  1558. //剩余需要排产的数量
  1559. decimal residueQty = lineStart.QtyRemain - sumQty;
  1560. //剩余数量生产需要时长(分钟)
  1561. decimal workTime = Math.Ceiling(residueQty / dto.Rate * 60);
  1562. //处理工作时长:防止相上取整导致时间大于剩余可用时长
  1563. workTime = workTime >= residueTime ? residueTime : workTime;
  1564. //排产结束时间
  1565. DateTime workEndTime = workStartTime;
  1566. var curPoint = workPoints.Find(p => p.StartPoint <= workStartTime && workStartTime <= p.EndPoint);
  1567. span = curPoint.EndPoint - workStartTime;
  1568. //当天工作时间段的有效生产时间
  1569. decimal effMins = (decimal)span.TotalMinutes;
  1570. //当前工作时间段即可满足产能
  1571. if (effMins >= workTime)
  1572. {
  1573. workEndTime = workStartTime.AddMinutes((double)workTime);
  1574. }
  1575. else
  1576. {
  1577. //获取后续生产时间段
  1578. var nextPoints = workPoints.Where(p => p.Level > curPoint.Level).OrderBy(p => p.Level).ToList();
  1579. //剩余需要工作时长
  1580. decimal nextMins = workTime - effMins;
  1581. foreach (var p in nextPoints)
  1582. {
  1583. if (p.WorkMinutes >= nextMins)
  1584. {
  1585. workEndTime = p.StartPoint.AddMinutes((double)nextMins);
  1586. break;
  1587. }
  1588. nextMins -= p.WorkMinutes;
  1589. }
  1590. }
  1591. //工单排产完成,已排产数量=工单需排产数量数量
  1592. sumQty = lineStart.QtyRemain;
  1593. //当天剩余可用生产时长
  1594. residueTime -= workTime;
  1595. //处理清场时间,两种场景:
  1596. //1、residueTime<=lineStart.WaitTime,结束时间加上剩余清场时长
  1597. if (residueTime <= lineStart.WaitTime)
  1598. {
  1599. //仍需排产的清场时长
  1600. decimal otherTime = lineStart.WaitTime - residueTime;
  1601. workEndTime = dto.EndTime.AddMinutes((double)otherTime);
  1602. residueTime = 0;
  1603. }
  1604. //2、residueTime>lineStart.WaitTime,剩余时长大于清场时长,需要过滤休息时间
  1605. else
  1606. {
  1607. //清场时长
  1608. workTime = lineStart.WaitTime;
  1609. //获取工单排产结束时间所处时间段
  1610. curPoint = workPoints.Find(p => p.StartPoint <= workEndTime && workEndTime <= p.EndPoint);
  1611. span = curPoint.EndPoint - workEndTime;
  1612. //当前工作时间段的有效生产时间(分钟)
  1613. effMins = (decimal)span.TotalMinutes;
  1614. //当前工作时间段即可清场时长
  1615. if (effMins >= workTime)
  1616. {
  1617. workEndTime = workEndTime.AddMinutes((double)workTime);
  1618. }
  1619. else
  1620. {
  1621. //获取后续生产时间段
  1622. var nextPoints = workPoints.Where(p => p.Level > curPoint.Level).OrderBy(p => p.Level).ToList();
  1623. //剩余需要工作时长
  1624. decimal nextMins = workTime - effMins;
  1625. foreach (var p in nextPoints)
  1626. {
  1627. if (p.WorkMinutes >= nextMins)
  1628. {
  1629. workEndTime = p.StartPoint.AddMinutes((double)nextMins);
  1630. break;
  1631. }
  1632. nextMins -= p.WorkMinutes;
  1633. }
  1634. }
  1635. residueTime -= workTime;
  1636. }
  1637. //记录生产周期
  1638. curSequences.Add(new PeriodSequenceDet
  1639. {
  1640. Domain = domain,
  1641. Line = lineStart.Line,
  1642. ItemNum = workOrd.ItemNum,
  1643. PlanDate = workStartTime.Date,
  1644. Period = dto.Period,
  1645. OrdQty = residueQty,
  1646. WorkOrds = workOrd.WorkOrd,
  1647. Op = lineStart.Op,
  1648. IsActive = true,
  1649. Status = "",
  1650. CreateTime = DateTime.Now
  1651. });
  1652. //记录排产记录
  1653. curScheduleRsts.Add(new ScheduleResultOpMaster
  1654. {
  1655. Domain = domain,
  1656. WorkOrd = workOrd.WorkOrd,
  1657. Line = lineStart.Line,
  1658. ItemNum = workOrd.ItemNum,
  1659. Op = lineStart.Op,
  1660. WorkDate = workStartTime.Date,
  1661. WorkQty = residueQty,
  1662. WorkStartTime = workStartTime,
  1663. WorkEndTime = workEndTime,
  1664. CreateTime = DateTime.Now
  1665. });
  1666. #endregion 正常工单排产-结束
  1667. //当天排完正常工单后的剩余生产时长(分钟)
  1668. decimal restTime = residueTime < 0 ? 0 : residueTime;
  1669. //当天存在特殊工单
  1670. if (sumTsTimes > 0)
  1671. {
  1672. workDtos = workDtos.OrderBy(p => p.Priority).ToList();
  1673. //当天剩余生产时长大于0,特殊工单排产
  1674. if (restTime > 0)
  1675. {
  1676. //处理正常工单排产结束时间<=>特殊工单排产开始时间
  1677. curPoint = workPoints.Find(p => p.StartPoint <= workEndTime && workEndTime <= p.EndPoint);
  1678. if (workEndTime == curPoint.EndPoint)
  1679. {
  1680. var nextPoint = workPoints.FirstOrDefault(p => p.Level == curPoint.Level + 1);
  1681. if (nextPoint != null)
  1682. {
  1683. workEndTime = nextPoint.StartPoint;
  1684. }
  1685. }
  1686. #region 特殊工单排产-开始
  1687. DateTime beginTime = workEndTime;//排产开始时间
  1688. DateTime endTime = dto.EndTime;//排产结束时间
  1689. //当天的剩余生产时长满足特殊工单生产时长+清场时长(最后一个工单清场时长除外)
  1690. if (restTime >= sumTsTimes)
  1691. {
  1692. //获取最后一个工单
  1693. var lastWork = workDtos.Last();
  1694. //特殊工单排产
  1695. foreach (var item in workDtos)
  1696. {
  1697. if (item.LbrVar == item.Worked)//当前工单已排产
  1698. {
  1699. continue;
  1700. }
  1701. //当前工单还需工作时长
  1702. decimal needTime = 0m;
  1703. //最后一个特殊工单
  1704. if (item.WorkOrd == lastWork.WorkOrd)
  1705. {
  1706. //最后一个工单的生产时长+清场时长
  1707. needTime = lastWork.LbrVar - lastWork.Worked + lastWork.WaitTime;
  1708. //剩余可用工作时长满足最后一个特殊工单的生产时长+清场时长
  1709. if (restTime >= needTime)
  1710. {
  1711. //计算工单排产结束时间
  1712. curPoint = workPoints.Find(p => p.StartPoint <= beginTime && beginTime <= p.EndPoint);
  1713. //获取排产结束时间所处以及之后的生产时间段
  1714. var nextPoints = workPoints.Where(p => p.Level >= curPoint.Level).OrderBy(p => p.Level).ToList();
  1715. //处理第一个时间段的开始时间
  1716. nextPoints[0].StartPoint = beginTime;
  1717. foreach (var p in nextPoints)
  1718. {
  1719. span = p.EndPoint - p.StartPoint;
  1720. //当前工作时间段的有效生产时间
  1721. effMins = (decimal)span.TotalMinutes;
  1722. if (effMins >= needTime)
  1723. {
  1724. endTime = p.StartPoint.AddMinutes((double)needTime);
  1725. break;
  1726. }
  1727. needTime -= effMins;
  1728. restTime -= effMins;
  1729. }
  1730. restTime -= needTime;
  1731. }
  1732. //剩余可用工作时长不能满足清场时长
  1733. else
  1734. {
  1735. //还需排产的清场时间
  1736. decimal qcTime = needTime - restTime;
  1737. endTime = dto.EndTime.AddMinutes((double)qcTime);
  1738. restTime = 0;
  1739. }
  1740. //最后一个工单的清场时长
  1741. lstCleanTime = 0m;
  1742. }
  1743. //最后一个特殊工单之前的工单:剩余排产时长和清场时间全部排产
  1744. else
  1745. {
  1746. needTime = item.LbrVar - item.Worked + item.WaitTime;
  1747. //计算工单排产结束时间
  1748. curPoint = workPoints.Find(p => p.StartPoint <= beginTime && beginTime <= p.EndPoint);
  1749. span = curPoint.EndPoint - beginTime;
  1750. //当天工作时间段的有效生产时间(分钟)
  1751. effMins = (decimal)span.TotalMinutes;
  1752. //当前工作时间段即可满足产能
  1753. if (effMins >= needTime)
  1754. {
  1755. endTime = beginTime.AddMinutes((double)needTime);
  1756. }
  1757. else
  1758. {
  1759. //获取后续生产时间段
  1760. var nextPoints = workPoints.Where(p => p.Level > curPoint.Level).OrderBy(p => p.Level).ToList();
  1761. //剩余需要工作时长
  1762. decimal nextMins = needTime - effMins;
  1763. foreach (var p in nextPoints)
  1764. {
  1765. if (p.WorkMinutes >= nextMins)
  1766. {
  1767. endTime = p.StartPoint.AddMinutes((double)nextMins);
  1768. break;
  1769. }
  1770. nextMins -= p.WorkMinutes;
  1771. }
  1772. }
  1773. restTime -= needTime;
  1774. }
  1775. //记录生产周期
  1776. curSequences.Add(new PeriodSequenceDet
  1777. {
  1778. Domain = domain,
  1779. Line = lineStart.Line,
  1780. ItemNum = item.ItemNum,
  1781. PlanDate = beginTime.Date,
  1782. Period = dto.Period,
  1783. OrdQty = item.QtyOrded - item.QtyWorked,
  1784. WorkOrds = item.WorkOrd,
  1785. Op = item.Op,
  1786. IsActive = true,
  1787. Status = "",
  1788. CreateTime = DateTime.Now
  1789. });
  1790. //记录排产记录
  1791. curScheduleRsts.Add(new ScheduleResultOpMaster
  1792. {
  1793. Domain = domain,
  1794. WorkOrd = item.WorkOrd,
  1795. Line = lineStart.Line,
  1796. ItemNum = item.ItemNum,
  1797. Op = item.Op,
  1798. WorkDate = beginTime.Date,
  1799. WorkQty = item.QtyOrded - item.QtyWorked,
  1800. WorkStartTime = beginTime,
  1801. WorkEndTime = endTime,
  1802. CreateTime = DateTime.Now
  1803. });
  1804. //下一工单开始时间=当前工单结束时间,如果位于工作区间结尾,则为下一工作区间开始时间
  1805. curPoint = workPoints.Find(p => p.StartPoint <= endTime && endTime <= p.EndPoint);
  1806. //结束时间位于工作区间结尾
  1807. if (curPoint != null && endTime == curPoint.EndPoint)
  1808. {
  1809. //获取后续生产时间段
  1810. curPoint = workPoints.Where(p => p.Level == curPoint.Level + 1).FirstOrDefault();
  1811. if (curPoint != null)//存在后续工作区间
  1812. {
  1813. endTime = curPoint.StartPoint;
  1814. }
  1815. }
  1816. beginTime = endTime;
  1817. //工单排产完成,排产时长=工单工作时长
  1818. item.Worked = item.LbrVar;
  1819. item.QtyWorked = item.QtyOrded;
  1820. }
  1821. sumTsTimes = 0;//排产完毕,特殊工单时长置0
  1822. isFullPC = true;
  1823. }
  1824. //当天的剩余生产时长不满足特殊工单生产时长(至少最后一个特殊工单的生产时长不能满足)
  1825. else
  1826. {
  1827. foreach (var item in workDtos)
  1828. {
  1829. if (item.LbrVar == item.Worked)//当前工单已排产
  1830. {
  1831. continue;
  1832. }
  1833. //当前工单剩余待排产时长(分钟)
  1834. decimal needTime = item.LbrVar - item.Worked;
  1835. //当天剩余产能满足当前工单的剩余待排产时长(则当前工单的清场时长必定满足)
  1836. if (restTime >= needTime)
  1837. {
  1838. //计算工单排产结束时间
  1839. curPoint = workPoints.Find(p => p.StartPoint <= beginTime && beginTime <= p.EndPoint);
  1840. span = curPoint.EndPoint - beginTime;
  1841. //当前工作时间段的有效生产时间(分钟)
  1842. effMins = (decimal)span.TotalMinutes;
  1843. //当前工作时间段即可满足产能
  1844. if (effMins >= needTime)
  1845. {
  1846. endTime = beginTime.AddMinutes((double)needTime);
  1847. }
  1848. else
  1849. {
  1850. //获取后续生产时间段
  1851. var nextPoints = workPoints.Where(p => p.Level > curPoint.Level).OrderBy(p => p.Level).ToList();
  1852. //剩余需要工作时长
  1853. decimal nextMins = needTime - effMins;
  1854. foreach (var p in nextPoints)
  1855. {
  1856. if (p.WorkMinutes >= nextMins)
  1857. {
  1858. endTime = p.StartPoint.AddMinutes((double)nextMins);
  1859. break;
  1860. }
  1861. nextMins -= p.WorkMinutes;
  1862. }
  1863. }
  1864. //当天剩余可用生产时长
  1865. restTime -= needTime;
  1866. //处理清场时间,两种场景:
  1867. //1、restTime<=item.WaitTime,结束时间加上剩余清场时长
  1868. if (restTime <= item.WaitTime)
  1869. {
  1870. //仍需排产的清场时长
  1871. decimal otherTime = item.WaitTime - restTime;
  1872. endTime = dto.EndTime.AddMinutes((double)otherTime);
  1873. restTime = 0;
  1874. }
  1875. //2、restTime>item.WaitTime,剩余时长大于清场时长,需要过滤休息时间
  1876. else
  1877. {
  1878. //清场时长
  1879. needTime = item.WaitTime;
  1880. //获取工单排产结束时间所处时间段
  1881. curPoint = workPoints.Find(p => p.StartPoint <= endTime && endTime <= p.EndPoint);
  1882. span = curPoint.EndPoint - endTime;
  1883. //当前工作时间段的有效生产时间(分钟)
  1884. effMins = (decimal)span.TotalMinutes;
  1885. //当前工作时间段即可清场时长
  1886. if (effMins >= needTime)
  1887. {
  1888. endTime = endTime.AddMinutes((double)needTime);
  1889. }
  1890. else
  1891. {
  1892. //获取后续生产时间段
  1893. var nextPoints = workPoints.Where(p => p.Level > curPoint.Level).OrderBy(p => p.Level).ToList();
  1894. //剩余需要工作时长
  1895. decimal nextMins = needTime - effMins;
  1896. foreach (var p in nextPoints)
  1897. {
  1898. if (p.WorkMinutes >= nextMins)
  1899. {
  1900. endTime = p.StartPoint.AddMinutes((double)nextMins);
  1901. break;
  1902. }
  1903. nextMins -= p.WorkMinutes;
  1904. }
  1905. }
  1906. restTime -= needTime;
  1907. }
  1908. //处理特殊工单剩余时长减去当前工单待排产时长和清场时长
  1909. sumTsTimes -= (item.LbrVar - item.Worked + item.WaitTime);
  1910. //记录生产周期
  1911. curSequences.Add(new PeriodSequenceDet
  1912. {
  1913. Domain = domain,
  1914. Line = lineStart.Line,
  1915. ItemNum = item.ItemNum,
  1916. PlanDate = beginTime.Date,
  1917. Period = dto.Period,
  1918. OrdQty = item.QtyOrded - item.QtyWorked,
  1919. WorkOrds = item.WorkOrd,
  1920. Op = item.Op,
  1921. IsActive = true,
  1922. Status = "",
  1923. CreateTime = DateTime.Now
  1924. });
  1925. //记录排产记录
  1926. curScheduleRsts.Add(new ScheduleResultOpMaster
  1927. {
  1928. Domain = domain,
  1929. WorkOrd = item.WorkOrd,
  1930. Line = lineStart.Line,
  1931. ItemNum = item.ItemNum,
  1932. Op = item.Op,
  1933. WorkDate = beginTime.Date,
  1934. WorkQty = item.QtyOrded - item.QtyWorked,
  1935. WorkStartTime = beginTime,
  1936. WorkEndTime = endTime,
  1937. CreateTime = DateTime.Now
  1938. });
  1939. //当前工单已排产完成,已排产时间=工单生产时长,已排产数量=工单数量
  1940. item.Worked = item.LbrVar;
  1941. item.QtyWorked = item.QtyOrded;
  1942. beginTime = endTime;
  1943. if (restTime > 0)
  1944. {
  1945. curPoint = workPoints.Find(p => p.StartPoint <= endTime && endTime <= p.EndPoint);
  1946. if (endTime == curPoint.EndPoint )
  1947. {
  1948. var nextPoint = workPoints.FirstOrDefault(p => p.Level == curPoint.Level + 1);
  1949. if (nextPoint != null)
  1950. {
  1951. endTime = nextPoint.StartPoint;
  1952. }
  1953. beginTime = endTime;
  1954. }
  1955. }
  1956. //当天产能已全部用完
  1957. else
  1958. {
  1959. break;
  1960. }
  1961. }
  1962. //当天剩余产能不满足当前工单的剩余待排产时长
  1963. else
  1964. {
  1965. //计算生产数量
  1966. decimal qty = Math.Ceiling(restTime / item.LbrVar * item.QtyOrded);
  1967. //记录生产周期
  1968. curSequences.Add(new PeriodSequenceDet
  1969. {
  1970. Domain = domain,
  1971. Line = lineStart.Line,
  1972. ItemNum = item.ItemNum,
  1973. PlanDate = beginTime.Date,
  1974. Period = dto.Period,
  1975. OrdQty = qty,
  1976. WorkOrds = item.WorkOrd,
  1977. Op = item.Op,
  1978. IsActive = true,
  1979. Status = "",
  1980. CreateTime = DateTime.Now
  1981. });
  1982. //记录排产记录
  1983. curScheduleRsts.Add(new ScheduleResultOpMaster
  1984. {
  1985. Domain = domain,
  1986. WorkOrd = item.WorkOrd,
  1987. Line = lineStart.Line,
  1988. ItemNum = item.ItemNum,
  1989. Op = item.Op,
  1990. WorkDate = beginTime.Date,
  1991. WorkQty = qty,
  1992. WorkStartTime = beginTime,
  1993. WorkEndTime = dto.EndTime,
  1994. CreateTime = DateTime.Now
  1995. });
  1996. item.Worked += restTime;
  1997. item.QtyWorked += qty;
  1998. //特殊工单剩余待排产时长(分钟)
  1999. sumTsTimes -= restTime;
  2000. restTime = 0m;
  2001. break;
  2002. }
  2003. }
  2004. //获取下一个工作日
  2005. workStartTime = GetNextWorkDay((int)workStartTime.DayOfWeek, workStartTime, mLCalendars);
  2006. isFstDay = false;
  2007. //当天特殊工单未排产完全
  2008. isFullPC = false;
  2009. }
  2010. #endregion 特殊工单排产-结束
  2011. }
  2012. //当天剩余生产时长为0,由于存在特殊工单,则循环下一个工作日进行排产
  2013. else
  2014. {
  2015. //继续排下一个工作日
  2016. workStartTime = GetNextWorkDay((int)workStartTime.DayOfWeek, workStartTime, mLCalendars);
  2017. isFstDay = false;
  2018. //当天特殊工单未排产完全
  2019. isFullPC = false;
  2020. }
  2021. }
  2022. }
  2023. //记录提前期
  2024. sumTimes = lineStart.setupTime * 60;
  2025. }
  2026. //当天可用生产时长不能满足或者刚好满足提前期
  2027. else
  2028. {
  2029. //当天的可用生产时长不能满足提前期
  2030. sumTimes += dto.EffTime;
  2031. //获取下一个工作日
  2032. workStartTime = GetNextWorkDay((int)workStartTime.DayOfWeek, workStartTime, mLCalendars);
  2033. isFstDay = false;
  2034. }
  2035. }
  2036. //产线提前期满足的下一个工作日排产
  2037. else
  2038. {
  2039. //如果前一天的特殊工单没排产完,则先排特殊工单,如果当天还安排有特殊工单,则将特殊工单提前
  2040. if (!isFullPC)
  2041. {
  2042. //当天可用生产时长(分钟)
  2043. decimal residueTime = dto.EffTime;
  2044. DateTime beginTime = workStartTime;//排产开始时间
  2045. DateTime endTime = dto.EndTime;//排产结束时间
  2046. workDtos = workDtos.OrderBy(p => p.Priority).ToList();
  2047. //当天的可用生产时长满足特殊工单生产时长+清场时长(最后一个工单清场时间除外)
  2048. if (residueTime >= sumTsTimes)
  2049. {
  2050. //获取最后一个工单
  2051. var lastWork = workDtos.Last();
  2052. //开始或结束时间所处时间段
  2053. var curPoint = new LineWorkPointDto();
  2054. //特殊工单排产
  2055. foreach (var item in workDtos)
  2056. {
  2057. if (item.LbrVar == item.Worked)//当前工单已排产,跳过
  2058. {
  2059. continue;
  2060. }
  2061. //当前工单还需工作时长
  2062. decimal needTime = 0m;
  2063. //最后一个特殊工单
  2064. if (item.WorkOrd == lastWork.WorkOrd)
  2065. {
  2066. //最后一个工单的生产时长+清场时长
  2067. needTime = lastWork.LbrVar - lastWork.Worked + lastWork.WaitTime;
  2068. //剩余可用工作时长满足最后一个特殊工单的生产时长+清场时长
  2069. if (residueTime >= needTime)
  2070. {
  2071. //计算工单排产结束时间
  2072. curPoint = workPoints.Find(p => p.StartPoint <= beginTime && beginTime <= p.EndPoint);
  2073. //获取排产结束时间所处以及之后的生产时间段
  2074. var nextPoints = workPoints.Where(p => p.Level >= curPoint.Level).OrderBy(p => p.Level).ToList();
  2075. //处理第一个时间段的开始时间
  2076. nextPoints[0].StartPoint = beginTime;
  2077. foreach (var p in nextPoints)
  2078. {
  2079. span = p.EndPoint - p.StartPoint;
  2080. //当前工作时间段的有效生产时间
  2081. decimal effMins = (decimal)span.TotalMinutes;
  2082. if (effMins >= needTime)
  2083. {
  2084. endTime = p.StartPoint.AddMinutes((double)needTime);
  2085. break;
  2086. }
  2087. needTime -= effMins;
  2088. residueTime -= effMins;
  2089. }
  2090. residueTime -= needTime;
  2091. }
  2092. //剩余可用工作时长不能满足清场时长
  2093. else
  2094. {
  2095. //还需排产的清场时间
  2096. decimal qcTime = needTime - residueTime;
  2097. endTime = dto.EndTime.AddMinutes((double)qcTime);
  2098. residueTime = 0;
  2099. }
  2100. //最后一个工单的清场时长
  2101. lstCleanTime = 0m;
  2102. break;
  2103. }
  2104. //最后一个特殊工单之前的工单:剩余排产时长和清场时间全部排产
  2105. else
  2106. {
  2107. //当前工单还需工作时长+清场时长
  2108. needTime = item.LbrVar - item.Worked + item.WaitTime;
  2109. //计算工单排产结束时间
  2110. curPoint = workPoints.Find(p => p.StartPoint <= beginTime && beginTime <= p.EndPoint);
  2111. span = curPoint.EndPoint - beginTime;
  2112. //当天工作时间段的有效生产时间(分钟)
  2113. decimal effMins = (decimal)span.TotalMinutes;
  2114. //当前工作时间段即可满足产能
  2115. if (effMins >= needTime)
  2116. {
  2117. endTime = beginTime.AddMinutes((double)needTime);
  2118. }
  2119. else
  2120. {
  2121. //获取后续生产时间段
  2122. var nextPoints = workPoints.Where(p => p.Level > curPoint.Level).OrderBy(p => p.Level).ToList();
  2123. //剩余需要工作时长
  2124. decimal nextMins = needTime - effMins;
  2125. foreach (var p in nextPoints)
  2126. {
  2127. if (p.WorkMinutes >= nextMins)
  2128. {
  2129. endTime = p.StartPoint.AddMinutes((double)nextMins);
  2130. break;
  2131. }
  2132. nextMins -= p.WorkMinutes;
  2133. }
  2134. }
  2135. //剩余可用时长
  2136. residueTime -= needTime;
  2137. }
  2138. //记录生产周期
  2139. curSequences.Add(new PeriodSequenceDet
  2140. {
  2141. Domain = domain,
  2142. Line = lineStart.Line,
  2143. ItemNum = item.ItemNum,
  2144. PlanDate = beginTime.Date,
  2145. Period = dto.Period,
  2146. OrdQty = item.QtyOrded - item.QtyWorked,
  2147. WorkOrds = item.WorkOrd,
  2148. Op = item.Op,
  2149. IsActive = true,
  2150. Status = "",
  2151. CreateTime = DateTime.Now
  2152. });
  2153. //记录排产记录
  2154. curScheduleRsts.Add(new ScheduleResultOpMaster
  2155. {
  2156. Domain = domain,
  2157. WorkOrd = item.WorkOrd,
  2158. Line = lineStart.Line,
  2159. ItemNum = item.ItemNum,
  2160. Op = item.Op,
  2161. WorkDate = beginTime.Date,
  2162. WorkQty = item.QtyOrded - item.QtyWorked,
  2163. WorkStartTime = beginTime,
  2164. WorkEndTime = endTime,
  2165. CreateTime = DateTime.Now
  2166. });
  2167. //下一工单开始时间=当前工单结束时间,如果位于工作区间结尾,则为下一工作区间开始时间
  2168. curPoint = workPoints.Find(p => p.StartPoint <= endTime && endTime <= p.EndPoint);
  2169. //结束时间位于工作区间结尾
  2170. if (curPoint != null && endTime == curPoint.EndPoint)
  2171. {
  2172. //获取后续生产时间段
  2173. var nextPoint = workPoints.Where(p => p.Level == curPoint.Level + 1).FirstOrDefault();
  2174. //存在后续工作区间
  2175. if (nextPoint != null)
  2176. {
  2177. endTime = nextPoint.StartPoint;
  2178. }
  2179. }
  2180. beginTime = endTime;
  2181. //工单排产完成,排产时长=工单工作时长
  2182. item.Worked = item.LbrVar;
  2183. item.QtyWorked = item.QtyOrded;
  2184. }
  2185. //排产完毕,特殊工单时长置0
  2186. sumTsTimes = 0;
  2187. //当天特殊工单全部排产完成
  2188. isFullPC = true;
  2189. //特殊工单排产完成,最后一个工单的清场时长置0
  2190. lstCleanTime = 0m;
  2191. //剩余可用生产时长
  2192. residueTime = residueTime < 0 ? 0 : residueTime;
  2193. //特殊工单处理完成,剩余生产时长大于0且还有正常工单待排产,则继续排正常工单
  2194. if (residueTime > 0 && sumQty < lineStart.QtyRemain)
  2195. {
  2196. workStartTime = beginTime;//排产开始时间
  2197. //剩余产能继续排正常工单
  2198. decimal sumAmount = Math.Floor(dto.Rate * residueTime / 60);
  2199. //如果剩余产能不能满足正常工单,剩余产能全部排产
  2200. if (sumQty + sumAmount < lineStart.QtyRemain)
  2201. {
  2202. //记录生产周期
  2203. curSequences.Add(new PeriodSequenceDet
  2204. {
  2205. Domain = domain,
  2206. Line = lineStart.Line,
  2207. ItemNum = workOrd.ItemNum,
  2208. PlanDate = workStartTime.Date,
  2209. Period = dto.Period,
  2210. OrdQty = sumAmount,
  2211. WorkOrds = workOrd.WorkOrd,
  2212. Op = lineStart.Op,
  2213. IsActive = true,
  2214. Status = "",
  2215. CreateTime = DateTime.Now
  2216. });
  2217. //记录排产记录
  2218. curScheduleRsts.Add(new ScheduleResultOpMaster
  2219. {
  2220. Domain = domain,
  2221. WorkOrd = workOrd.WorkOrd,
  2222. Line = lineStart.Line,
  2223. ItemNum = workOrd.ItemNum,
  2224. Op = lineStart.Op,
  2225. WorkDate = workStartTime.Date,
  2226. WorkQty = sumAmount,
  2227. WorkStartTime = workStartTime,
  2228. WorkEndTime = dto.EndTime,
  2229. CreateTime = DateTime.Now
  2230. });
  2231. //累计已排产数量
  2232. sumQty += sumAmount;
  2233. //继续排下一个工作日
  2234. workStartTime = GetNextWorkDay((int)workStartTime.DayOfWeek, workStartTime, mLCalendars);
  2235. isFstDay = false;
  2236. }
  2237. //剩余产能满足正常工单待排产数量,此时需要排清场时长
  2238. else
  2239. {
  2240. //剩余需要排产的数量
  2241. decimal residueQty = lineStart.QtyRemain - sumQty;
  2242. //剩余数量生产需要时长(分钟)
  2243. decimal workTime = Math.Ceiling(residueQty / dto.Rate * 60);
  2244. //处理剩余需要生产时长:防止向上取整导致超过residueTime
  2245. workTime = workTime > residueTime ? residueTime : workTime;
  2246. curPoint = workPoints.Find(p => p.StartPoint <= workStartTime && workStartTime <= p.EndPoint);
  2247. span = curPoint.EndPoint - workStartTime;
  2248. //当天工作时间段的有效生产时间
  2249. decimal effMins = (decimal)span.TotalMinutes;
  2250. //当前工作时间段即可满足产能
  2251. if (effMins >= workTime)
  2252. {
  2253. endTime = workStartTime.AddMinutes((double)workTime);
  2254. }
  2255. else
  2256. {
  2257. //获取后续生产时间段
  2258. var nextPoints = workPoints.Where(p => p.Level > curPoint.Level).OrderBy(p => p.Level).ToList();
  2259. //剩余需要工作时长
  2260. decimal nextMins = workTime - effMins;
  2261. foreach (var p in nextPoints)
  2262. {
  2263. if (p.WorkMinutes >= nextMins)
  2264. {
  2265. endTime = p.StartPoint.AddMinutes((double)nextMins);
  2266. break;
  2267. }
  2268. nextMins -= p.WorkMinutes;
  2269. }
  2270. }
  2271. //工单排产完成,已排产数量=工单数量
  2272. sumQty = lineStart.QtyRemain;
  2273. //剩余可用生产时长
  2274. residueTime = (residueTime - workTime) < 0 ? 0 : (residueTime - workTime);
  2275. //处理清场时间,两种场景:
  2276. //1、residueTime<=lineStart.WaitTime,结束时间加上剩余清场时长
  2277. if (residueTime <= lineStart.WaitTime)
  2278. {
  2279. //仍需排产的清场时长
  2280. decimal otherTime = lineStart.WaitTime - residueTime;
  2281. endTime = dto.EndTime.AddMinutes((double)otherTime);
  2282. residueTime = 0;
  2283. }
  2284. //2、residueTime>lineStart.WaitTime,剩余时长大于清场时长,需要过滤休息时间
  2285. else
  2286. {
  2287. //清场时长
  2288. workTime = lineStart.WaitTime;
  2289. //获取工单排产结束时间所处时间段
  2290. curPoint = workPoints.Find(p => p.StartPoint <= endTime && endTime <= p.EndPoint);
  2291. span = curPoint.EndPoint - endTime;
  2292. //当前工作时间段的有效生产时间(分钟)
  2293. effMins = (decimal)span.TotalMinutes;
  2294. //当前工作时间段即可清场时长
  2295. if (effMins >= workTime)
  2296. {
  2297. endTime = endTime.AddMinutes((double)workTime);
  2298. }
  2299. else
  2300. {
  2301. //获取后续生产时间段
  2302. var nextPoints = workPoints.Where(p => p.Level > curPoint.Level).OrderBy(p => p.Level).ToList();
  2303. //剩余需要工作时长
  2304. decimal nextMins = workTime - effMins;
  2305. foreach (var p in nextPoints)
  2306. {
  2307. if (p.WorkMinutes >= nextMins)
  2308. {
  2309. endTime = p.StartPoint.AddMinutes((double)nextMins);
  2310. break;
  2311. }
  2312. nextMins -= p.WorkMinutes;
  2313. }
  2314. }
  2315. residueTime -= workTime;
  2316. }
  2317. //记录生产周期
  2318. curSequences.Add(new PeriodSequenceDet
  2319. {
  2320. Domain = domain,
  2321. Line = lineStart.Line,
  2322. ItemNum = workOrd.ItemNum,
  2323. PlanDate = workStartTime.Date,
  2324. Period = dto.Period,
  2325. OrdQty = residueQty,
  2326. WorkOrds = workOrd.WorkOrd,
  2327. Op = lineStart.Op,
  2328. IsActive = true,
  2329. Status = "",
  2330. CreateTime = DateTime.Now
  2331. });
  2332. //记录排产记录
  2333. curScheduleRsts.Add(new ScheduleResultOpMaster
  2334. {
  2335. Domain = domain,
  2336. WorkOrd = workOrd.WorkOrd,
  2337. Line = lineStart.Line,
  2338. ItemNum = workOrd.ItemNum,
  2339. Op = lineStart.Op,
  2340. WorkDate = workStartTime.Date,
  2341. WorkQty = residueQty,
  2342. WorkStartTime = workStartTime,
  2343. WorkEndTime = endTime,
  2344. CreateTime = DateTime.Now
  2345. });
  2346. }
  2347. }
  2348. else {
  2349. //获取下一个工作日
  2350. workStartTime = GetNextWorkDay((int)workStartTime.DayOfWeek, workStartTime, mLCalendars);
  2351. isFstDay = false;
  2352. }
  2353. }
  2354. //当天的可用产能不满特殊工单生产时长,则当天产能全部排特殊工单(至少最后一个特殊工单的生产时长不能满足)
  2355. else
  2356. {
  2357. //特殊工单排产
  2358. foreach (var item in workDtos)
  2359. {
  2360. if (item.LbrVar == item.Worked)//当前工单已排产
  2361. {
  2362. continue;
  2363. }
  2364. //当前工单剩余待排产时长(分钟)
  2365. decimal needTime = item.LbrVar - item.Worked;
  2366. //当天剩余产能满足当前工单的剩余待排产时长(则当前工单的清场时间必定排完)
  2367. if (residueTime >= needTime)
  2368. {
  2369. //计算工单排产结束时间
  2370. var curPoint = workPoints.Find(p => p.StartPoint <= beginTime && beginTime <= p.EndPoint);
  2371. span = curPoint.EndPoint - beginTime;
  2372. //当前工作时间段的有效生产时间(分钟)
  2373. decimal effMins = (decimal)span.TotalMinutes;
  2374. //当前工作时间段即可满足产能
  2375. if (effMins >= needTime)
  2376. {
  2377. endTime = beginTime.AddMinutes((double)needTime);
  2378. }
  2379. else
  2380. {
  2381. //获取后续生产时间段
  2382. var nextPoints = workPoints.Where(p => p.Level > curPoint.Level).OrderBy(p => p.Level).ToList();
  2383. //剩余需要工作时长
  2384. decimal nextMins = needTime - effMins;
  2385. foreach (var p in nextPoints)
  2386. {
  2387. if (p.WorkMinutes >= nextMins)
  2388. {
  2389. endTime = p.StartPoint.AddMinutes((double)nextMins);
  2390. break;
  2391. }
  2392. nextMins -= p.WorkMinutes;
  2393. }
  2394. }
  2395. //当天剩余可用生产时长
  2396. residueTime -= needTime;
  2397. //处理清场时间,两种场景:
  2398. //1、residueTime<=item.WaitTime,结束时间加上剩余清场时长
  2399. if (residueTime <= item.WaitTime)
  2400. {
  2401. //仍需排产的清场时长
  2402. decimal otherTime = item.WaitTime - residueTime;
  2403. endTime = dto.EndTime.AddMinutes((double)otherTime);
  2404. residueTime = 0;
  2405. }
  2406. //2、residueTime>item.WaitTime,剩余时长大于清场时长,需要过滤休息时间
  2407. else
  2408. {
  2409. //清场时长
  2410. needTime = item.WaitTime;
  2411. //获取工单排产结束时间所处时间段
  2412. curPoint = workPoints.Find(p => p.StartPoint <= endTime && endTime <= p.EndPoint);
  2413. span = curPoint.EndPoint - endTime;
  2414. //当前工作时间段的有效生产时间(分钟)
  2415. effMins = (decimal)span.TotalMinutes;
  2416. //当前工作时间段即可清场时长
  2417. if (effMins >= needTime)
  2418. {
  2419. endTime = endTime.AddMinutes((double)needTime);
  2420. }
  2421. else
  2422. {
  2423. //获取后续生产时间段
  2424. var nextPoints = workPoints.Where(p => p.Level > curPoint.Level).OrderBy(p => p.Level).ToList();
  2425. //剩余需要工作时长
  2426. decimal nextMins = needTime - effMins;
  2427. foreach (var p in nextPoints)
  2428. {
  2429. if (p.WorkMinutes >= nextMins)
  2430. {
  2431. endTime = p.StartPoint.AddMinutes((double)nextMins);
  2432. break;
  2433. }
  2434. nextMins -= p.WorkMinutes;
  2435. }
  2436. }
  2437. residueTime -= needTime;
  2438. }
  2439. //处理特殊工单剩余时长减去当前工单待排产时长和清场时长
  2440. sumTsTimes -= (item.LbrVar - item.Worked + item.WaitTime);
  2441. //记录生产周期
  2442. curSequences.Add(new PeriodSequenceDet
  2443. {
  2444. Domain = domain,
  2445. Line = lineStart.Line,
  2446. ItemNum = item.ItemNum,
  2447. PlanDate = beginTime.Date,
  2448. Period = dto.Period,
  2449. OrdQty = item.QtyOrded - item.QtyWorked,
  2450. WorkOrds = item.WorkOrd,
  2451. Op = item.Op,
  2452. IsActive = true,
  2453. Status = "",
  2454. CreateTime = DateTime.Now
  2455. });
  2456. //记录排产记录
  2457. curScheduleRsts.Add(new ScheduleResultOpMaster
  2458. {
  2459. Domain = domain,
  2460. WorkOrd = item.WorkOrd,
  2461. Line = lineStart.Line,
  2462. ItemNum = item.ItemNum,
  2463. Op = item.Op,
  2464. WorkDate = beginTime.Date,
  2465. WorkQty = item.QtyOrded - item.QtyWorked,
  2466. WorkStartTime = beginTime,
  2467. WorkEndTime = endTime,
  2468. CreateTime = DateTime.Now
  2469. });
  2470. //当前工单已排产完成,已排产时间=工单生产时长,已排产数量=工单数量
  2471. item.Worked = item.LbrVar;
  2472. item.QtyWorked = item.QtyOrded;
  2473. beginTime = endTime;
  2474. //当天可用生产时长还有剩余
  2475. if (residueTime > 0)
  2476. {
  2477. //获取结束时间所处时间段
  2478. curPoint = workPoints.Find(p => p.StartPoint <= endTime && endTime <= p.EndPoint);
  2479. if (endTime == curPoint.EndPoint)
  2480. {
  2481. var nextPoint = workPoints.FirstOrDefault(p => p.Level == curPoint.Level + 1);
  2482. endTime = nextPoint == null ? endTime : nextPoint.StartPoint;
  2483. }
  2484. beginTime = endTime;
  2485. }
  2486. //当天可用产能已全部用完
  2487. else
  2488. {
  2489. break;
  2490. }
  2491. }
  2492. //当天剩余产能不满足当前工单的剩余待排产时长
  2493. else
  2494. {
  2495. //计算生产数量
  2496. decimal qty = Math.Ceiling(residueTime / item.LbrVar * item.QtyOrded);
  2497. //记录生产周期
  2498. curSequences.Add(new PeriodSequenceDet
  2499. {
  2500. Domain = domain,
  2501. Line = lineStart.Line,
  2502. ItemNum = item.ItemNum,
  2503. PlanDate = beginTime.Date,
  2504. Period = dto.Period,
  2505. OrdQty = qty,
  2506. WorkOrds = item.WorkOrd,
  2507. Op = item.Op,
  2508. IsActive = true,
  2509. Status = "",
  2510. CreateTime = DateTime.Now
  2511. });
  2512. //记录排产记录
  2513. curScheduleRsts.Add(new ScheduleResultOpMaster
  2514. {
  2515. Domain = domain,
  2516. WorkOrd = item.WorkOrd,
  2517. Line = lineStart.Line,
  2518. ItemNum = item.ItemNum,
  2519. Op = item.Op,
  2520. WorkDate = beginTime.Date,
  2521. WorkQty = qty,
  2522. WorkStartTime = beginTime,
  2523. WorkEndTime = dto.EndTime,
  2524. CreateTime = DateTime.Now
  2525. });
  2526. item.Worked += residueTime;
  2527. item.QtyWorked += qty;
  2528. //特殊工单剩余待排产时长(分钟)
  2529. sumTsTimes -= residueTime;
  2530. residueTime = 0m;
  2531. break;
  2532. }
  2533. }
  2534. //当天特殊工单未排产完成
  2535. isFullPC = false;
  2536. //获取下一个工作日
  2537. workStartTime = GetNextWorkDay((int)workStartTime.DayOfWeek, workStartTime, mLCalendars);
  2538. isFstDay = false;
  2539. }
  2540. }
  2541. //当天之前的特殊工单全部排产完毕
  2542. else {
  2543. //已排产数量+当天的产能小于工单数量,当天的产能需要全部排产
  2544. if (sumQty + dto.ProductQty < lineStart.QtyRemain)
  2545. {
  2546. //当天有特殊工单,先排特殊工单
  2547. if (sumTsTimes > 0)
  2548. {
  2549. //当天剩余产能(分钟)
  2550. decimal residueTime = dto.EffTime;
  2551. DateTime beginTime = workStartTime;//排产开始时间
  2552. DateTime endTime = dto.EndTime;//排产结束时间
  2553. workDtos = workDtos.OrderBy(p => p.Priority).ToList();
  2554. //当天的可用产能满足特殊工单生产时长+清场时长(最后一个工单清场时间除外)
  2555. if (residueTime >= sumTsTimes)
  2556. {
  2557. var lastWork = workDtos.Last();
  2558. //开始或结束时间所处时间段
  2559. var curPoint = new LineWorkPointDto();
  2560. //特殊工单排产
  2561. foreach (var item in workDtos)
  2562. {
  2563. if (item.LbrVar == item.Worked)//当前工单已排产
  2564. {
  2565. continue;
  2566. }
  2567. //当前工单排产需要时长
  2568. decimal needTime = 0m;
  2569. //最后一个特殊工单
  2570. if (item.WorkOrd == lastWork.WorkOrd)
  2571. {
  2572. //最后一个工单的生产时长+清场时长
  2573. needTime = lastWork.LbrVar - lastWork.Worked + lastWork.WaitTime;
  2574. //剩余可用工作时长满足最后一个特殊工单的生产时长+清场时长
  2575. if (residueTime >= needTime)
  2576. {
  2577. //计算工单排产结束时间
  2578. curPoint = workPoints.Find(p => p.StartPoint <= beginTime && beginTime <= p.EndPoint);
  2579. //获取排产结束时间所处以及之后的生产时间段
  2580. var nextPoints = workPoints.Where(p => p.Level >= curPoint.Level).OrderBy(p => p.Level).ToList();
  2581. //处理第一个时间段的开始时间
  2582. nextPoints[0].StartPoint = beginTime;
  2583. foreach (var p in nextPoints)
  2584. {
  2585. span = p.EndPoint - p.StartPoint;
  2586. //当前工作时间段的有效生产时间
  2587. decimal effMins = (decimal)span.TotalMinutes;
  2588. if (effMins >= needTime)
  2589. {
  2590. endTime = p.StartPoint.AddMinutes((double)needTime);
  2591. break;
  2592. }
  2593. needTime -= effMins;
  2594. residueTime -= effMins;
  2595. }
  2596. residueTime -= needTime;
  2597. }
  2598. //剩余可用工作时长不能满足清场时长
  2599. else
  2600. {
  2601. //还需排产的清场时间
  2602. decimal qcTime = needTime - residueTime;
  2603. endTime = dto.EndTime.AddMinutes((double)qcTime);
  2604. residueTime = 0;
  2605. }
  2606. //最后一个工单的清场时长
  2607. lstCleanTime = 0m;
  2608. }
  2609. //最后一个特殊工单之前的工单:剩余排产时长和清场时间全部排产
  2610. else
  2611. {
  2612. //当前工单还需工作时长+工单的清场时长
  2613. needTime = item.LbrVar - item.Worked + item.WaitTime;
  2614. //计算工单排产结束时间
  2615. curPoint = workPoints.Find(p => p.StartPoint <= beginTime && beginTime <= p.EndPoint);
  2616. span = curPoint.EndPoint - beginTime;
  2617. //当天工作时间段的有效生产时间(分钟)
  2618. decimal effMins = (decimal)span.TotalMinutes;
  2619. if (effMins >= needTime)//当前工作时间段即可满足产能
  2620. {
  2621. endTime = beginTime.AddMinutes((double)needTime);
  2622. }
  2623. else
  2624. {
  2625. //获取后续生产时间段
  2626. var nextPoints = workPoints.Where(p => p.Level > curPoint.Level).OrderBy(p => p.Level).ToList();
  2627. //剩余需要工作时长
  2628. decimal nextMins = needTime - effMins;
  2629. foreach (var p in nextPoints)
  2630. {
  2631. if (p.WorkMinutes >= nextMins)
  2632. {
  2633. endTime = p.StartPoint.AddMinutes((double)nextMins);
  2634. break;
  2635. }
  2636. nextMins -= p.WorkMinutes;
  2637. }
  2638. }
  2639. residueTime -= needTime;
  2640. }
  2641. //记录生产周期
  2642. curSequences.Add(new PeriodSequenceDet
  2643. {
  2644. Domain = domain,
  2645. Line = lineStart.Line,
  2646. ItemNum = item.ItemNum,
  2647. PlanDate = beginTime.Date,
  2648. Period = dto.Period,
  2649. OrdQty = item.QtyOrded - item.QtyWorked,
  2650. WorkOrds = item.WorkOrd,
  2651. Op = item.Op,
  2652. IsActive = true,
  2653. Status = "",
  2654. CreateTime = DateTime.Now
  2655. });
  2656. //记录排产记录
  2657. curScheduleRsts.Add(new ScheduleResultOpMaster
  2658. {
  2659. Domain = domain,
  2660. WorkOrd = item.WorkOrd,
  2661. Line = lineStart.Line,
  2662. ItemNum = item.ItemNum,
  2663. Op = item.Op,
  2664. WorkDate = beginTime.Date,
  2665. WorkQty = item.QtyOrded - item.QtyWorked,
  2666. WorkStartTime = beginTime,
  2667. WorkEndTime = endTime,
  2668. CreateTime = DateTime.Now
  2669. });
  2670. //下一工单开始时间=当前工单结束时间,如果位于工作区间结尾,则为下一工作区间开始时间
  2671. curPoint = workPoints.Find(p => p.StartPoint <= endTime && endTime <= p.EndPoint);
  2672. //结束时间位于工作区间结尾
  2673. if (curPoint != null && endTime == curPoint.EndPoint)
  2674. {
  2675. //获取后续生产时间段
  2676. curPoint = workPoints.FirstOrDefault(p => p.Level == curPoint.Level + 1);
  2677. //存在后续工作区间
  2678. if (curPoint != null)
  2679. {
  2680. endTime = curPoint.StartPoint;
  2681. }
  2682. }
  2683. beginTime = endTime;
  2684. //工单排产完成,排产时长=工单工作时长
  2685. item.Worked = item.LbrVar;
  2686. item.QtyWorked = item.QtyOrded;
  2687. }
  2688. //剩余可用生产时长
  2689. residueTime = residueTime < 0 ? 0 : residueTime;
  2690. //特殊工单处理完成,剩余生产时长大于0继续排正常工单
  2691. if (residueTime > 0)
  2692. {
  2693. //处理正常工单开工时间
  2694. workStartTime = endTime;
  2695. //剩余产能继续排正常工单
  2696. decimal sumAmount = Math.Floor(dto.Rate * residueTime / 60);
  2697. //记录生产周期
  2698. curSequences.Add(new PeriodSequenceDet
  2699. {
  2700. Domain = domain,
  2701. Line = lineStart.Line,
  2702. ItemNum = workOrd.ItemNum,
  2703. PlanDate = workStartTime.Date,
  2704. Period = dto.Period,
  2705. OrdQty = sumAmount,
  2706. WorkOrds = workOrd.WorkOrd,
  2707. Op = lineStart.Op,
  2708. IsActive = true,
  2709. Status = "",
  2710. CreateTime = DateTime.Now
  2711. });
  2712. //记录排产记录
  2713. curScheduleRsts.Add(new ScheduleResultOpMaster
  2714. {
  2715. Domain = domain,
  2716. WorkOrd = workOrd.WorkOrd,
  2717. Line = lineStart.Line,
  2718. ItemNum = workOrd.ItemNum,
  2719. Op = lineStart.Op,
  2720. WorkDate = workStartTime.Date,
  2721. WorkQty = sumAmount,
  2722. WorkStartTime = workStartTime,
  2723. WorkEndTime = dto.EndTime,
  2724. CreateTime = DateTime.Now
  2725. });
  2726. //累计已排产数量
  2727. sumQty += sumAmount;
  2728. }
  2729. //继续排下一个工作日
  2730. workStartTime = GetNextWorkDay((int)workStartTime.DayOfWeek, workStartTime, mLCalendars);
  2731. isFstDay = false;
  2732. //排产完毕,特殊工单时长置0
  2733. sumTsTimes = 0;
  2734. //当天的特殊工单排产完成
  2735. isFullPC = true;
  2736. //最后一个特殊工单清场时长置0
  2737. lstCleanTime = 0m;
  2738. }
  2739. //当天的可用产能不满足特殊工单生产时长,则当天产能全部排特殊工单(至少最后一个特殊工单的生产时长不能满足)
  2740. else
  2741. {
  2742. foreach (var item in workDtos)
  2743. {
  2744. if (item.LbrVar == item.Worked)//当前工单已排产
  2745. {
  2746. continue;
  2747. }
  2748. //当前工单剩余待排产时长(分钟)
  2749. decimal needTime = item.LbrVar - item.Worked;
  2750. //当天剩余产能满足当前工单的剩余待排产时长(则当前工单的清场时间必定排完)
  2751. if (residueTime >= needTime)
  2752. {
  2753. //计算工单排产结束时间
  2754. var curPoint = workPoints.Find(p => p.StartPoint <= beginTime && beginTime <= p.EndPoint);
  2755. span = curPoint.EndPoint - beginTime;
  2756. //当前工作时间段的有效生产时间(分钟)
  2757. decimal effMins = (decimal)span.TotalMinutes;
  2758. if (effMins >= needTime)//当前工作时间段即可满足产能
  2759. {
  2760. endTime = beginTime.AddMinutes((double)needTime);
  2761. }
  2762. else
  2763. {
  2764. //获取后续生产时间段
  2765. var nextPoints = workPoints.Where(p => p.Level > curPoint.Level).OrderBy(p => p.Level).ToList();
  2766. //剩余需要工作时长
  2767. decimal nextMins = needTime - effMins;
  2768. foreach (var p in nextPoints)
  2769. {
  2770. if (p.WorkMinutes >= nextMins)
  2771. {
  2772. endTime = p.StartPoint.AddMinutes((double)nextMins);
  2773. break;
  2774. }
  2775. nextMins -= p.WorkMinutes;
  2776. }
  2777. }
  2778. //当天剩余可用生产时长
  2779. residueTime -= needTime;
  2780. //处理清场时间,两种场景:
  2781. //1、residueTime<=item.WaitTime,结束时间加上剩余清场时长
  2782. if (residueTime <= item.WaitTime)
  2783. {
  2784. //仍需排产的清场时长
  2785. decimal otherTime = item.WaitTime - residueTime;
  2786. endTime = dto.EndTime.AddMinutes((double)otherTime);
  2787. residueTime = 0;
  2788. }
  2789. //2、residueTime>item.WaitTime,剩余时长大于清场时长,需要过滤休息时间
  2790. else
  2791. {
  2792. //清场时长
  2793. needTime = item.WaitTime;
  2794. //获取工单排产结束时间所处时间段
  2795. curPoint = workPoints.Find(p => p.StartPoint <= endTime && endTime <= p.EndPoint);
  2796. span = curPoint.EndPoint - endTime;
  2797. //当前工作时间段的有效生产时间(分钟)
  2798. effMins = (decimal)span.TotalMinutes;
  2799. //当前工作时间段即可清场时长
  2800. if (effMins >= needTime)
  2801. {
  2802. endTime = endTime.AddMinutes((double)needTime);
  2803. }
  2804. else
  2805. {
  2806. //获取后续生产时间段
  2807. var nextPoints = workPoints.Where(p => p.Level > curPoint.Level).OrderBy(p => p.Level).ToList();
  2808. //剩余需要工作时长
  2809. decimal nextMins = needTime - effMins;
  2810. foreach (var p in nextPoints)
  2811. {
  2812. if (p.WorkMinutes >= nextMins)
  2813. {
  2814. endTime = p.StartPoint.AddMinutes((double)nextMins);
  2815. break;
  2816. }
  2817. nextMins -= p.WorkMinutes;
  2818. }
  2819. }
  2820. residueTime -= needTime;
  2821. }
  2822. //处理特殊工单剩余时长减去当前工单待排产时长和清场时长
  2823. sumTsTimes -= (item.LbrVar - item.Worked + item.WaitTime);
  2824. //记录生产周期
  2825. curSequences.Add(new PeriodSequenceDet
  2826. {
  2827. Domain = domain,
  2828. Line = lineStart.Line,
  2829. ItemNum = item.ItemNum,
  2830. PlanDate = beginTime.Date,
  2831. Period = dto.Period,
  2832. OrdQty = item.QtyOrded - item.QtyWorked,
  2833. WorkOrds = item.WorkOrd,
  2834. Op = item.Op,
  2835. IsActive = true,
  2836. Status = "",
  2837. CreateTime = DateTime.Now
  2838. });
  2839. //记录排产记录
  2840. curScheduleRsts.Add(new ScheduleResultOpMaster
  2841. {
  2842. Domain = domain,
  2843. WorkOrd = item.WorkOrd,
  2844. Line = lineStart.Line,
  2845. ItemNum = item.ItemNum,
  2846. Op = item.Op,
  2847. WorkDate = beginTime.Date,
  2848. WorkQty = item.QtyOrded - item.QtyWorked,
  2849. WorkStartTime = beginTime,
  2850. WorkEndTime = endTime,
  2851. CreateTime = DateTime.Now
  2852. });
  2853. //当前工单已排产完成,已排产时间=工单生产时长,已排产数量=工单数量
  2854. item.Worked = item.LbrVar;
  2855. item.QtyWorked = item.QtyOrded;
  2856. beginTime = endTime;
  2857. if (residueTime > 0)
  2858. {
  2859. //获取结束时间所处时间段
  2860. curPoint = workPoints.Find(p => p.StartPoint <= endTime && endTime <= p.EndPoint);
  2861. if (endTime == curPoint.EndPoint)
  2862. {
  2863. var nextPoint = workPoints.FirstOrDefault(p => p.Level == curPoint.Level + 1);
  2864. endTime = nextPoint == null ? endTime : nextPoint.StartPoint;
  2865. }
  2866. beginTime = endTime;
  2867. }
  2868. //当天可用产能已全部用完
  2869. else
  2870. {
  2871. break;
  2872. }
  2873. }
  2874. //当天剩余产能不满足当前工单的剩余待排产时长
  2875. else
  2876. {
  2877. //计算生产数量
  2878. decimal qty = Math.Ceiling(residueTime / item.LbrVar * item.QtyOrded);
  2879. //记录生产周期
  2880. curSequences.Add(new PeriodSequenceDet
  2881. {
  2882. Domain = domain,
  2883. Line = lineStart.Line,
  2884. ItemNum = item.ItemNum,
  2885. PlanDate = beginTime.Date,
  2886. Period = dto.Period,
  2887. OrdQty = qty,
  2888. WorkOrds = item.WorkOrd,
  2889. Op = item.Op,
  2890. IsActive = true,
  2891. Status = "",
  2892. CreateTime = DateTime.Now
  2893. });
  2894. //记录排产记录
  2895. curScheduleRsts.Add(new ScheduleResultOpMaster
  2896. {
  2897. Domain = domain,
  2898. WorkOrd = item.WorkOrd,
  2899. Line = lineStart.Line,
  2900. ItemNum = item.ItemNum,
  2901. Op = item.Op,
  2902. WorkDate = beginTime.Date,
  2903. WorkQty = qty,
  2904. WorkStartTime = beginTime,
  2905. WorkEndTime = dto.EndTime,
  2906. CreateTime = DateTime.Now
  2907. });
  2908. item.Worked += residueTime;
  2909. item.QtyWorked += qty;
  2910. //特殊工单剩余待排产时长(分钟)
  2911. sumTsTimes -= residueTime;
  2912. residueTime = 0;
  2913. break;
  2914. }
  2915. }
  2916. //当天的特殊工单未排产完成
  2917. isFullPC = false;
  2918. //获取下一个工作日
  2919. workStartTime = GetNextWorkDay((int)workStartTime.DayOfWeek, workStartTime, mLCalendars);
  2920. isFstDay = false;
  2921. }
  2922. }
  2923. //不存在特殊工单(此时不想需要考虑清场时间)
  2924. else
  2925. {
  2926. //记录生产周期
  2927. curSequences.Add(new PeriodSequenceDet
  2928. {
  2929. Domain = domain,
  2930. Line = lineStart.Line,
  2931. ItemNum = workOrd.ItemNum,
  2932. PlanDate = workStartTime.Date,
  2933. Period = dto.Period,
  2934. OrdQty = dto.ProductQty,
  2935. WorkOrds = workOrd.WorkOrd,
  2936. Op = lineStart.Op,
  2937. IsActive = true,
  2938. Status = "",
  2939. CreateTime = DateTime.Now
  2940. });
  2941. //记录排产记录
  2942. curScheduleRsts.Add(new ScheduleResultOpMaster
  2943. {
  2944. Domain = domain,
  2945. WorkOrd = workOrd.WorkOrd,
  2946. Line = lineStart.Line,
  2947. ItemNum = workOrd.ItemNum,
  2948. Op = lineStart.Op,
  2949. WorkDate = workStartTime.Date,
  2950. WorkQty = dto.ProductQty,
  2951. WorkStartTime = dto.StartTime,
  2952. WorkEndTime = dto.EndTime,
  2953. CreateTime = DateTime.Now
  2954. });
  2955. //累计已排产数量
  2956. sumQty += dto.ProductQty;
  2957. //继续排下一个工作日
  2958. workStartTime = GetNextWorkDay((int)workStartTime.DayOfWeek, workStartTime, mLCalendars);
  2959. isFstDay = false;
  2960. isFullPC = true;
  2961. }
  2962. }
  2963. //剩余产能满足正常工单待排产数量,此时需要排清场时长
  2964. else
  2965. {
  2966. //当天可用生产时长
  2967. decimal residueTime = dto.EffTime;
  2968. //正常工单生产时长
  2969. decimal workTime = 0m;
  2970. DateTime workEndTime = workStartTime;
  2971. if (sumQty < lineStart.QtyRemain)
  2972. {
  2973. #region 正常工单排产-开始
  2974. //剩余需要排产的数量
  2975. decimal residueQty = lineStart.QtyRemain - sumQty;
  2976. //剩余数量生产需要时长(分钟)
  2977. workTime = Math.Ceiling(residueQty / dto.Rate * 60);
  2978. //处理需要生产时长
  2979. workTime = workTime >= residueTime ? residueTime : workTime;
  2980. var curPoint = workPoints.Find(p => p.StartPoint <= workStartTime && workStartTime <= p.EndPoint);
  2981. span = curPoint.EndPoint - workStartTime;
  2982. //当天工作时间段的有效生产时间
  2983. decimal effMins = (decimal)span.TotalMinutes;
  2984. //当前工作时间段即可满足产能
  2985. if (effMins >= workTime)
  2986. {
  2987. workEndTime = workStartTime.AddMinutes((double)workTime);
  2988. }
  2989. else
  2990. {
  2991. //获取后续生产时间段
  2992. var nextPoints = workPoints.Where(p => p.Level > curPoint.Level).OrderBy(p => p.Level).ToList();
  2993. //剩余需要工作时长
  2994. decimal nextMins = workTime - effMins;
  2995. foreach (var p in nextPoints)
  2996. {
  2997. if (p.WorkMinutes >= nextMins)
  2998. {
  2999. workEndTime = p.StartPoint.AddMinutes((double)nextMins);
  3000. break;
  3001. }
  3002. nextMins -= p.WorkMinutes;
  3003. }
  3004. }
  3005. //工单排产完成,已排产数量=工单数量
  3006. sumQty = lineStart.QtyRemain;
  3007. //剩余可用生产时长
  3008. residueTime = (residueTime - workTime) < 0 ? 0 : (residueTime - workTime);
  3009. //处理清场时间,两种场景:
  3010. //1、residueTime<=lineStart.WaitTime,结束时间加上剩余清场时长
  3011. if (residueTime <= lineStart.WaitTime)
  3012. {
  3013. //仍需排产的清场时长
  3014. decimal otherTime = lineStart.WaitTime - residueTime;
  3015. workEndTime = dto.EndTime.AddMinutes((double)otherTime);
  3016. residueTime = 0;
  3017. }
  3018. //2、residueTime>lineStart.WaitTime,剩余时长大于清场时长,需要过滤休息时间
  3019. else
  3020. {
  3021. //清场时长
  3022. workTime = lineStart.WaitTime;
  3023. //获取工单排产结束时间所处时间段
  3024. curPoint = workPoints.Find(p => p.StartPoint <= workEndTime && workEndTime <= p.EndPoint);
  3025. span = curPoint.EndPoint - workEndTime;
  3026. //当前工作时间段的有效生产时间(分钟)
  3027. effMins = (decimal)span.TotalMinutes;
  3028. //当前工作时间段即可清场时长
  3029. if (effMins >= workTime)
  3030. {
  3031. workEndTime = workEndTime.AddMinutes((double)workTime);
  3032. }
  3033. else
  3034. {
  3035. //获取后续生产时间段
  3036. var nextPoints = workPoints.Where(p => p.Level > curPoint.Level).OrderBy(p => p.Level).ToList();
  3037. //剩余需要工作时长
  3038. decimal nextMins = workTime - effMins;
  3039. foreach (var p in nextPoints)
  3040. {
  3041. if (p.WorkMinutes >= nextMins)
  3042. {
  3043. workEndTime = p.StartPoint.AddMinutes((double)nextMins);
  3044. break;
  3045. }
  3046. nextMins -= p.WorkMinutes;
  3047. }
  3048. }
  3049. //剩余生产时长
  3050. residueTime -= workTime;
  3051. }
  3052. //记录生产周期
  3053. curSequences.Add(new PeriodSequenceDet
  3054. {
  3055. Domain = domain,
  3056. Line = lineStart.Line,
  3057. ItemNum = workOrd.ItemNum,
  3058. PlanDate = workStartTime.Date,
  3059. Period = dto.Period,
  3060. OrdQty = residueQty,
  3061. WorkOrds = workOrd.WorkOrd,
  3062. Op = lineStart.Op,
  3063. IsActive = true,
  3064. Status = "",
  3065. CreateTime = DateTime.Now
  3066. });
  3067. //记录排产记录
  3068. curScheduleRsts.Add(new ScheduleResultOpMaster
  3069. {
  3070. Domain = domain,
  3071. WorkOrd = workOrd.WorkOrd,
  3072. Line = lineStart.Line,
  3073. ItemNum = workOrd.ItemNum,
  3074. Op = lineStart.Op,
  3075. WorkDate = workStartTime.Date,
  3076. WorkQty = residueQty,
  3077. WorkStartTime = workStartTime,
  3078. WorkEndTime = workEndTime,
  3079. CreateTime = DateTime.Now
  3080. });
  3081. //处理排产开始时间
  3082. workStartTime = workEndTime;
  3083. curPoint = workPoints.FirstOrDefault(p => p.StartPoint <= workStartTime && workStartTime <= p.EndPoint);
  3084. if (curPoint != null && workStartTime == curPoint.EndPoint)
  3085. {
  3086. var nextPoint = workPoints.FirstOrDefault(p => p.Level == curPoint.Level + 1);
  3087. workStartTime = nextPoint == null ? workStartTime : nextPoint.StartPoint;
  3088. }
  3089. #endregion 正常工单排产-结束
  3090. }
  3091. //当天剩余产能(分钟)
  3092. residueTime = residueTime < 0 ? 0 : residueTime;
  3093. if (sumTsTimes > 0)//存在特殊工单
  3094. {
  3095. if (residueTime > 0)
  3096. {
  3097. #region 特殊工单排产-开始
  3098. DateTime beginTime = workStartTime;//排产开始时间
  3099. DateTime endTime = dto.EndTime;//排产结束时间
  3100. workDtos = workDtos.OrderBy(p => p.Priority).ToList();
  3101. //当天的可用产能满足特殊工单生产时长+清场时长(最后一个工单清场时间除外)
  3102. if (residueTime >= sumTsTimes)
  3103. {
  3104. //最后一个工单
  3105. var lastWork = workDtos.Last();
  3106. //开始或结束时间所处时间段
  3107. var curPoint = new LineWorkPointDto();
  3108. foreach (var item in workDtos)
  3109. {
  3110. if (item.LbrVar == item.Worked)//当前工单已排产
  3111. {
  3112. continue;
  3113. }
  3114. //当前工单排产需要时长
  3115. decimal needTime = 0m;
  3116. //最后一个特殊工单
  3117. if (item.WorkOrd == lastWork.WorkOrd)
  3118. {
  3119. //最后一个工单的生产时长+清场时长
  3120. needTime = lastWork.LbrVar - lastWork.Worked + lastWork.WaitTime;
  3121. //剩余可用工作时长满足最后一个特殊工单的生产时长+清场时长
  3122. if (residueTime >= needTime)
  3123. {
  3124. //计算工单排产结束时间
  3125. curPoint = workPoints.Find(p => p.StartPoint <= beginTime && beginTime <= p.EndPoint);
  3126. //获取排产结束时间所处以及之后的生产时间段
  3127. var nextPoints = workPoints.Where(p => p.Level >= curPoint.Level).OrderBy(p => p.Level).ToList();
  3128. //处理第一个时间段的开始时间
  3129. nextPoints[0].StartPoint = beginTime;
  3130. foreach (var p in nextPoints)
  3131. {
  3132. span = p.EndPoint - p.StartPoint;
  3133. //当前工作时间段的有效生产时间
  3134. decimal effMins = (decimal)span.TotalMinutes;
  3135. if (effMins >= needTime)
  3136. {
  3137. endTime = p.StartPoint.AddMinutes((double)needTime);
  3138. break;
  3139. }
  3140. needTime -= effMins;
  3141. residueTime -= effMins;
  3142. }
  3143. //剩余可用时长
  3144. residueTime -= needTime;
  3145. }
  3146. //剩余可用工作时长不能满足清场时长
  3147. else
  3148. {
  3149. //还需排产的清场时间
  3150. decimal qcTime = needTime - residueTime;
  3151. endTime = dto.EndTime.AddMinutes((double)qcTime);
  3152. residueTime = 0;
  3153. }
  3154. //最后一个工单的清场时长
  3155. lstCleanTime = 0m;
  3156. }
  3157. //最后一个特殊工单之前的工单:剩余排产时长和清场时间全部排产
  3158. else
  3159. {
  3160. //当前工单还需工作时长+工单的清场时长
  3161. needTime = item.LbrVar - item.Worked + item.WaitTime;
  3162. //计算工单排产结束时间
  3163. curPoint = workPoints.Find(p => p.StartPoint <= beginTime && beginTime <= p.EndPoint);
  3164. span = curPoint.EndPoint - beginTime;
  3165. //当天工作时间段的有效生产时间(分钟)
  3166. decimal effMins = (decimal)span.TotalMinutes;
  3167. if (effMins >= needTime)//当前工作时间段即可满足产能
  3168. {
  3169. endTime = beginTime.AddMinutes((double)needTime);
  3170. }
  3171. else
  3172. {
  3173. //获取后续生产时间段
  3174. var nextPoints = workPoints.Where(p => p.Level > curPoint.Level).OrderBy(p => p.Level).ToList();
  3175. //剩余需要工作时长
  3176. decimal nextMins = needTime - effMins;
  3177. foreach (var p in nextPoints)
  3178. {
  3179. if (p.WorkMinutes >= nextMins)
  3180. {
  3181. endTime = p.StartPoint.AddMinutes((double)nextMins);
  3182. break;
  3183. }
  3184. nextMins -= p.WorkMinutes;
  3185. }
  3186. }
  3187. residueTime -= needTime;
  3188. }
  3189. //记录生产周期
  3190. curSequences.Add(new PeriodSequenceDet
  3191. {
  3192. Domain = domain,
  3193. Line = lineStart.Line,
  3194. ItemNum = item.ItemNum,
  3195. PlanDate = beginTime.Date,
  3196. Period = dto.Period,
  3197. OrdQty = item.QtyOrded - item.QtyWorked,
  3198. WorkOrds = item.WorkOrd,
  3199. Op = item.Op,
  3200. IsActive = true,
  3201. Status = "",
  3202. CreateTime = DateTime.Now
  3203. });
  3204. //记录排产记录
  3205. curScheduleRsts.Add(new ScheduleResultOpMaster
  3206. {
  3207. Domain = domain,
  3208. WorkOrd = item.WorkOrd,
  3209. Line = lineStart.Line,
  3210. ItemNum = item.ItemNum,
  3211. Op = item.Op,
  3212. WorkDate = beginTime.Date,
  3213. WorkQty = item.QtyOrded - item.QtyWorked,
  3214. WorkStartTime = beginTime,
  3215. WorkEndTime = endTime,
  3216. CreateTime = DateTime.Now
  3217. });
  3218. //下一工单开始时间=当前工单结束时间,如果位于工作区间结尾,则为下一工作区间开始时间
  3219. curPoint = workPoints.Find(p => p.StartPoint <= endTime && endTime <= p.EndPoint);
  3220. //结束时间位于工作区间结尾
  3221. if (curPoint != null && endTime == curPoint.EndPoint)
  3222. {
  3223. //获取后续生产时间段
  3224. var nextPoint = workPoints.Where(p => p.Level == curPoint.Level + 1).FirstOrDefault();
  3225. if (nextPoint != null)//存在后续工作区间
  3226. {
  3227. endTime = nextPoint.StartPoint;
  3228. }
  3229. }
  3230. beginTime = endTime;
  3231. //工单排产完成,排产时长=工单工作时长
  3232. item.Worked = item.LbrVar;
  3233. item.QtyWorked = item.QtyOrded;
  3234. }
  3235. //排产完毕,特殊工单时长置0
  3236. sumTsTimes = 0;
  3237. //当天的特殊工单以排产完成
  3238. isFullPC = true;
  3239. //最后一个工单的清场时间置0
  3240. lstCleanTime = 0m;
  3241. }
  3242. //当天的可用产能不满足特殊工单生产时长,则当天产能全部排特殊工单(至少最后一个特殊工单的生产时长不能满足)
  3243. else
  3244. {
  3245. foreach (var item in workDtos)
  3246. {
  3247. if (item.LbrVar == item.Worked)//当前工单已排产
  3248. {
  3249. continue;
  3250. }
  3251. //当前工单剩余待排产时长(分钟)
  3252. decimal needTime = item.LbrVar - item.Worked;
  3253. //当天剩余产能满足当前工单的剩余待排产时长(则当前工单的清场时间必定排完)
  3254. if (residueTime >= needTime)
  3255. {
  3256. //计算工单排产结束时间
  3257. var curPoint = workPoints.Find(p => p.StartPoint <= beginTime && beginTime <= p.EndPoint);
  3258. span = curPoint.EndPoint - beginTime;
  3259. //当前工作时间段的有效生产时间(分钟)
  3260. decimal effMins = (decimal)span.TotalMinutes;
  3261. if (effMins >= needTime)//当前工作时间段即可满足产能
  3262. {
  3263. endTime = beginTime.AddMinutes((double)needTime);
  3264. }
  3265. else
  3266. {
  3267. //获取后续生产时间段
  3268. var nextPoints = workPoints.Where(p => p.Level > curPoint.Level).OrderBy(p => p.Level).ToList();
  3269. //剩余需要工作时长
  3270. decimal nextMins = needTime - effMins;
  3271. foreach (var p in nextPoints)
  3272. {
  3273. if (p.WorkMinutes >= nextMins)
  3274. {
  3275. endTime = p.StartPoint.AddMinutes((double)nextMins);
  3276. break;
  3277. }
  3278. nextMins -= p.WorkMinutes;
  3279. }
  3280. }
  3281. //当天剩余可用生产时长
  3282. residueTime -= needTime;
  3283. //处理清场时间,两种场景:
  3284. //1、residueTime<=item.WaitTime,结束时间加上剩余清场时长
  3285. if (residueTime <= item.WaitTime)
  3286. {
  3287. //仍需排产的清场时长
  3288. decimal otherTime = item.WaitTime - residueTime;
  3289. endTime = dto.EndTime.AddMinutes((double)otherTime);
  3290. residueTime = 0;
  3291. }
  3292. //2、residueTime>item.WaitTime,剩余时长大于清场时长,需要过滤休息时间
  3293. else
  3294. {
  3295. //清场时长
  3296. needTime = item.WaitTime;
  3297. //获取工单排产结束时间所处时间段
  3298. curPoint = workPoints.Find(p => p.StartPoint <= endTime && endTime <= p.EndPoint);
  3299. span = curPoint.EndPoint - endTime;
  3300. //当前工作时间段的有效生产时间(分钟)
  3301. effMins = (decimal)span.TotalMinutes;
  3302. //当前工作时间段即可清场时长
  3303. if (effMins >= needTime)
  3304. {
  3305. endTime = endTime.AddMinutes((double)needTime);
  3306. }
  3307. else
  3308. {
  3309. //获取后续生产时间段
  3310. var nextPoints = workPoints.Where(p => p.Level > curPoint.Level).OrderBy(p => p.Level).ToList();
  3311. //剩余需要工作时长
  3312. decimal nextMins = needTime - effMins;
  3313. foreach (var p in nextPoints)
  3314. {
  3315. if (p.WorkMinutes >= nextMins)
  3316. {
  3317. endTime = p.StartPoint.AddMinutes((double)nextMins);
  3318. break;
  3319. }
  3320. nextMins -= p.WorkMinutes;
  3321. }
  3322. }
  3323. residueTime -= needTime;
  3324. }
  3325. //处理特殊工单剩余时长减去当前工单待排产时长和清场时长
  3326. sumTsTimes -= (item.LbrVar - item.Worked + item.WaitTime);
  3327. //记录生产周期
  3328. curSequences.Add(new PeriodSequenceDet
  3329. {
  3330. Domain = domain,
  3331. Line = lineStart.Line,
  3332. ItemNum = item.ItemNum,
  3333. PlanDate = beginTime.Date,
  3334. Period = dto.Period,
  3335. OrdQty = item.QtyOrded - item.QtyWorked,
  3336. WorkOrds = item.WorkOrd,
  3337. Op = item.Op,
  3338. IsActive = true,
  3339. Status = "",
  3340. CreateTime = DateTime.Now
  3341. });
  3342. //记录排产记录
  3343. curScheduleRsts.Add(new ScheduleResultOpMaster
  3344. {
  3345. Domain = domain,
  3346. WorkOrd = item.WorkOrd,
  3347. Line = lineStart.Line,
  3348. ItemNum = item.ItemNum,
  3349. Op = item.Op,
  3350. WorkDate = beginTime.Date,
  3351. WorkQty = item.QtyOrded - item.QtyWorked,
  3352. WorkStartTime = beginTime,
  3353. WorkEndTime = endTime,
  3354. CreateTime = DateTime.Now
  3355. });
  3356. //当前工单已排产完成,已排产时间=工单生产时长,已排产数量=工单数量
  3357. item.Worked = item.LbrVar;
  3358. item.QtyWorked = item.QtyOrded;
  3359. beginTime = endTime;
  3360. if (residueTime > 0)
  3361. {
  3362. curPoint = workPoints.Find(p => p.StartPoint <= endTime && endTime <= p.EndPoint);
  3363. if (endTime == curPoint.EndPoint)
  3364. {
  3365. var nextPoint = workPoints.FirstOrDefault(p => p.Level == curPoint.Level + 1);
  3366. endTime = nextPoint == null ? endTime : nextPoint.StartPoint;
  3367. beginTime = endTime;
  3368. }
  3369. }
  3370. //当天可用产能已全部用完
  3371. else
  3372. {
  3373. break;
  3374. }
  3375. }
  3376. else//当天剩余产能不满足当前工单的剩余待排产时长
  3377. {
  3378. //计算生产数量
  3379. decimal qty = Math.Ceiling(residueTime / item.LbrVar * item.QtyOrded);
  3380. //记录生产周期
  3381. curSequences.Add(new PeriodSequenceDet
  3382. {
  3383. Domain = domain,
  3384. Line = lineStart.Line,
  3385. ItemNum = item.ItemNum,
  3386. PlanDate = beginTime.Date,
  3387. Period = dto.Period,
  3388. OrdQty = qty,
  3389. WorkOrds = item.WorkOrd,
  3390. Op = item.Op,
  3391. IsActive = true,
  3392. Status = "",
  3393. CreateTime = DateTime.Now
  3394. });
  3395. //记录排产记录
  3396. curScheduleRsts.Add(new ScheduleResultOpMaster
  3397. {
  3398. Domain = domain,
  3399. WorkOrd = item.WorkOrd,
  3400. Line = lineStart.Line,
  3401. ItemNum = item.ItemNum,
  3402. Op = item.Op,
  3403. WorkDate = beginTime.Date,
  3404. WorkQty = qty,
  3405. WorkStartTime = beginTime,
  3406. WorkEndTime = dto.EndTime,
  3407. CreateTime = DateTime.Now
  3408. });
  3409. item.Worked += residueTime;
  3410. item.QtyWorked += qty;
  3411. //特殊工单剩余待排产时长(分钟)
  3412. sumTsTimes -= residueTime;
  3413. residueTime = 0;
  3414. break;
  3415. }
  3416. }
  3417. //当天的特殊工单未排产完成
  3418. isFullPC = false;
  3419. //获取下一个工作日
  3420. workStartTime = GetNextWorkDay((int)workStartTime.DayOfWeek, workStartTime, mLCalendars);
  3421. isFstDay = false;
  3422. }
  3423. #endregion 特殊工单排产-结束
  3424. }
  3425. else
  3426. {
  3427. //继续排下一个工作日
  3428. workStartTime = GetNextWorkDay((int)workStartTime.DayOfWeek, workStartTime, mLCalendars);
  3429. isFstDay = false;
  3430. //当天的特殊工单未排产完成
  3431. isFullPC = false;
  3432. }
  3433. }
  3434. }
  3435. }
  3436. }
  3437. }
  3438. //记录已排产特殊工单
  3439. ypcWorkOrds.AddRange(workDtos.Select(p=>p.WorkOrd).ToList());
  3440. }
  3441. //记录排产结果
  3442. periodsDet.AddRange(curSequences);
  3443. scheduleResults.AddRange(curScheduleRsts);
  3444. }
  3445. /// <summary>
  3446. /// 特殊工单排产:和正常工单不共用产线的特殊工单
  3447. /// </summary>
  3448. /// <param name="workOrds">特殊工单</param>
  3449. /// <param name="periodsDet">生产周期</param>
  3450. /// <param name="scheduleResults">排产结果</param>
  3451. public void TsLineSchedule(List<WorkOrdMstDto> workOrds, List<PeriodSequenceDet> periodsDet, List<ScheduleResultOpMaster> scheduleResults)
  3452. {
  3453. foreach (var item in workOrds)
  3454. {
  3455. //工单生产时长(分钟)
  3456. decimal sumTimes = item.LbrVar;
  3457. //工单的排产开始时间
  3458. DateTime workStartTime = item.OrdDate;
  3459. //当前产线的工作日历
  3460. var mLCalendars = calendars.Where(p => p.ProdLine == item.ProdLine || string.IsNullOrEmpty(p.ProdLine)).ToList();
  3461. //当前产线的休息时间设置
  3462. var mlqtyWorkDtls = qualityLines.Where(p => p.ProdLine == item.ProdLine).ToList();
  3463. LineStartDto lineStart = new LineStartDto();
  3464. lineStart.RecID = 0;
  3465. lineStart.Line = item.ProdLine;
  3466. lineStart.Op = item.Op;
  3467. lineStart.StartTime = workStartTime;
  3468. lineStart.Rate = 0;
  3469. while (sumTimes > 0)
  3470. {
  3471. //获取当天的工作时间段
  3472. var curCalendar = mLCalendars.FirstOrDefault(p => !string.IsNullOrEmpty(p.ProdLine) && p.WeekDay == (int)workStartTime.DayOfWeek);
  3473. if (curCalendar == null)
  3474. {
  3475. curCalendar = mLCalendars.FirstOrDefault(p => string.IsNullOrEmpty(p.ProdLine) && p.WeekDay == (int)workStartTime.DayOfWeek);
  3476. }
  3477. List<LineWorkPointDto> workPoints = DealWorkDayToLevels(lineStart.Line, workStartTime, curCalendar, mlqtyWorkDtls);
  3478. //获取当天的产能
  3479. LineScheduledDto dto = GetScheduledPoint(lineStart, workStartTime, mLCalendars, mlqtyWorkDtls);
  3480. //当天的可用生产时长不能满足特殊工单生产时长
  3481. if (dto.EffTime < sumTimes)
  3482. {
  3483. decimal qty = Math.Ceiling(dto.EffTime / item.LbrVar * item.QtyOrded);
  3484. //记录生产周期
  3485. periodsDet.Add(new PeriodSequenceDet
  3486. {
  3487. Domain = domain,
  3488. Line = item.ProdLine,
  3489. ItemNum = item.ItemNum,
  3490. PlanDate = workStartTime.Date,
  3491. Period = dto.Period,
  3492. OrdQty = qty,
  3493. WorkOrds = item.WorkOrd,
  3494. Op = item.Op,
  3495. IsActive = true,
  3496. Status = "",
  3497. CreateTime = DateTime.Now
  3498. });
  3499. //记录排产记录
  3500. scheduleResults.Add(new ScheduleResultOpMaster
  3501. {
  3502. Domain = domain,
  3503. WorkOrd = item.WorkOrd,
  3504. Line = item.ProdLine,
  3505. ItemNum = item.ItemNum,
  3506. Op = item.Op,
  3507. WorkDate = workStartTime.Date,
  3508. WorkQty = qty,
  3509. WorkStartTime = dto.StartTime,
  3510. WorkEndTime = dto.EndTime,
  3511. CreateTime = DateTime.Now
  3512. });
  3513. //剩余待排产时长
  3514. sumTimes -= dto.EffTime;
  3515. //已排产数量
  3516. item.QtyWorked += qty;
  3517. item.Worked += dto.EffTime;
  3518. //继续排下一个工作日
  3519. workStartTime = GetNextWorkDay((int)workStartTime.DayOfWeek, workStartTime, mLCalendars);
  3520. }
  3521. //最后一天的产能全部占用或只能占用一部分
  3522. else
  3523. {
  3524. //结束时间
  3525. DateTime workEndTime = workStartTime;
  3526. //需要排产时长=剩余生产时长(分钟) + 清场时长
  3527. decimal workTime = sumTimes + item.WaitTime;
  3528. //当天可用时长满足生产时长+清场时长
  3529. if (dto.EffTime > workTime)
  3530. {
  3531. //排产开始时间位于哪个时间段
  3532. var curPoint = workPoints.Find(p => p.StartPoint <= workStartTime && workStartTime <= p.EndPoint);
  3533. TimeSpan span = curPoint.EndPoint - workStartTime;
  3534. //当前工作时间段的有效生产时间
  3535. decimal effMins = (decimal)span.TotalMinutes;
  3536. if (effMins >= workTime)//当前工作时间段即可满足产能
  3537. {
  3538. workEndTime = workStartTime.AddMinutes((double)workTime);
  3539. }
  3540. else
  3541. {
  3542. //获取后续生产时间段
  3543. var nextPoints = workPoints.Where(p => p.Level > curPoint.Level).OrderBy(p => p.Level).ToList();
  3544. //剩余需要工作时长
  3545. decimal nextMins = workTime - effMins;
  3546. foreach (var p in nextPoints)
  3547. {
  3548. if (p.WorkMinutes >= nextMins)
  3549. {
  3550. workEndTime = p.StartPoint.AddMinutes((double)nextMins);
  3551. break;
  3552. }
  3553. nextMins -= p.WorkMinutes;
  3554. }
  3555. }
  3556. }
  3557. //当天可用时长满足生产时长,但是不满足清场时长
  3558. else {
  3559. //剩余清场时长
  3560. decimal needTime = workTime - dto.EffTime;
  3561. workEndTime = dto.EndTime.AddMinutes((double)needTime);
  3562. }
  3563. //记录生产周期
  3564. periodsDet.Add(new PeriodSequenceDet
  3565. {
  3566. Domain = domain,
  3567. Line = item.ProdLine,
  3568. ItemNum = item.ItemNum,
  3569. PlanDate = workStartTime.Date,
  3570. Period = dto.Period,
  3571. OrdQty = item.QtyOrded - item.QtyWorked,
  3572. WorkOrds = item.WorkOrd,
  3573. Op = item.Op,
  3574. IsActive = true,
  3575. Status = "",
  3576. CreateTime = DateTime.Now
  3577. });
  3578. //记录排产记录
  3579. scheduleResults.Add(new ScheduleResultOpMaster
  3580. {
  3581. Domain = domain,
  3582. WorkOrd = item.WorkOrd,
  3583. Line = item.ProdLine,
  3584. ItemNum = item.ItemNum,
  3585. Op = item.Op,
  3586. WorkDate = workStartTime.Date,
  3587. WorkQty = item.QtyOrded - item.QtyWorked,
  3588. WorkStartTime = workStartTime,
  3589. WorkEndTime = workEndTime,
  3590. CreateTime = DateTime.Now
  3591. });
  3592. sumTimes = 0;
  3593. item.QtyWorked = item.QtyOrded;
  3594. item.Worked = item.LbrVar;
  3595. }
  3596. }
  3597. }
  3598. }
  3599. /// <summary>
  3600. /// 计算当天排产完成的剩余生产时长
  3601. /// </summary>
  3602. /// <param name="endTime">排产结束时间</param>
  3603. /// <param name="workPoints">当天的工作时间段</param>
  3604. /// <returns></returns>
  3605. public decimal CalcRemainWorkTime(DateTime endTime, List<LineWorkPointDto> workPoints)
  3606. {
  3607. decimal remainTime = 0m;
  3608. var curPoint = workPoints.Find(p => p.StartPoint <= endTime && endTime <= p.EndPoint);
  3609. TimeSpan span = curPoint.EndPoint - endTime;
  3610. remainTime = (decimal)span.TotalMinutes;
  3611. var nextPoints = workPoints.Where(p => p.Level > curPoint.Level).OrderBy(p => p.Level).ToList();
  3612. foreach (var item in nextPoints)
  3613. {
  3614. remainTime += item.WorkMinutes;
  3615. }
  3616. return remainTime;
  3617. }
  3618. /// <summary>
  3619. /// 获取产线当天的开工时间,结束时间,有效工作时长,生产数量
  3620. /// </summary>
  3621. /// <param name="lineStart">排产产线</param>
  3622. /// <param name="startTime">产线排产开始时间</param>
  3623. /// <param name="curCalendars"></param>
  3624. /// <param name="curQtyDtls"></param>
  3625. /// <returns></returns>
  3626. public LineScheduledDto GetScheduledPoint(LineStartDto lineStart, DateTime startTime, List<ShopCalendarWorkCtr> curCalendars, List<QualityLineWorkDetail> curQtyDtls)
  3627. {
  3628. LineScheduledDto scheduledDto = new LineScheduledDto();
  3629. //当天排产开始时间
  3630. scheduledDto.StartTime = startTime;
  3631. //开始时间是周几
  3632. int weekDay = (int)startTime.DayOfWeek;
  3633. //当天的工作日历
  3634. var shopCal = curCalendars.Where(p => !string.IsNullOrEmpty(p.ProdLine) && p.WeekDay == weekDay).FirstOrDefault();
  3635. if (shopCal == null)//当前产线当天没有设置工作日历
  3636. {
  3637. //取默认工作日历
  3638. shopCal = curCalendars.Where(p =>string.IsNullOrEmpty(p.ProdLine) && p.WeekDay == weekDay).FirstOrDefault();
  3639. }
  3640. //当前日期的工作时间段
  3641. List<LineWorkPointDto> workPoints = DealWorkDayToLevels(lineStart.Line, startTime, shopCal, curQtyDtls);
  3642. //当天排产结束时间
  3643. scheduledDto.EndTime = workPoints.Last().EndPoint;
  3644. //计算starttime处于那个工作时间段
  3645. var curPoint = workPoints.Where(p => startTime >= p.StartPoint && startTime <= p.EndPoint).First();
  3646. TimeSpan span = curPoint.EndPoint - startTime;
  3647. scheduledDto.EffTime = (decimal)span.TotalMinutes;
  3648. //获取后续工作时间段的有效工作时间
  3649. var nextPoints = workPoints.Where(p => p.Level > curPoint.Level).OrderBy(p => p.Level).ToList();
  3650. foreach (var item in nextPoints)
  3651. {
  3652. span = item.EndPoint - item.StartPoint;
  3653. scheduledDto.EffTime += (decimal)span.TotalMinutes;
  3654. }
  3655. //判断当前产线的UPH
  3656. var curRunCrews = prodLineDetailRunCrews.Where(p=>p.ProdLineDetailRecID == lineStart.RecID).ToList();
  3657. //判断当前日期是否配置了UPH
  3658. var curLevel = curRunCrews.FirstOrDefault(p => p.StartDate.GetValueOrDefault().Date <= startTime.Date && p.EndDate.GetValueOrDefault().Date >= startTime.Date);
  3659. decimal rate = curLevel == null ? lineStart.Rate : curLevel.Rate;
  3660. scheduledDto.Rate = rate;
  3661. //计算当天的产能(向下取整)
  3662. scheduledDto.ProductQty = Math.Floor(scheduledDto.EffTime / 60 * rate);
  3663. //计算班次
  3664. scheduledDto.Period = 1;//默认一班制
  3665. if (shopCal.ShiftsStart2 != 0 && shopCal.ShiftsHours2 != 0)
  3666. {
  3667. scheduledDto.Period = 2;
  3668. }
  3669. return scheduledDto;
  3670. }
  3671. /// <summary>
  3672. /// 计算主产线实际排产开始时间
  3673. /// </summary>
  3674. /// <param name="workOrd">工单</param>
  3675. /// <param name="routing">工序</param>
  3676. /// <param name="prodLines">生产线明细</param>
  3677. /// <param name="allResults">产线占用记录</param>
  3678. /// <returns></returns>
  3679. public LineStartDto DealStartTime(WorkOrdMaster workOrd,WorkOrdRouting routing,List<ProdLineDetail> prodLines, List<ScheduleResultOpMaster> allResults)
  3680. {
  3681. int op = routing.OP;
  3682. DateTime actStart = DateTime.Now.Date.AddDays(1);
  3683. LineStartDto lineStart = new LineStartDto();
  3684. //获取工序对应的产线,根据优先级排序
  3685. var lines = prodLines.Where(p => p.Part == workOrd.ItemNum && p.Op == op).OrderBy(p => p.Sequence).ToList();
  3686. //获取第一条产线排产结束时间
  3687. var schedule = allResults.Where(p => p.Line == lines[0].Line).OrderByDescending(p => p.WorkEndTime).FirstOrDefault();
  3688. actStart = schedule == null ? actStart : (schedule.WorkEndTime >= actStart ? schedule.WorkEndTime : actStart);
  3689. //计算实际开工时间
  3690. //产线工作日历:当前产线的工作日历+默认工作日历
  3691. var curCalendars = calendars.Where(p => p.ProdLine == lines[0].Line || string.IsNullOrEmpty(p.ProdLine)).ToList();
  3692. var curQtyDtls = qualityLines.Where(p=>p.ProdLine == lines[0].Line).ToList();
  3693. actStart = CalcActStartTime(lines[0].Line, actStart, curCalendars, curQtyDtls);
  3694. lineStart.RecID = lines[0].RecID;
  3695. lineStart.Line = lines[0].Line;
  3696. lineStart.StartTime = actStart;
  3697. lineStart.setupTime = lines[0].SetupTime;
  3698. lineStart.Rate = lines[0].Rate;
  3699. //循环其他产线
  3700. for (int i = 1; i < lines.Count; i++)
  3701. {
  3702. schedule = allResults.Where(p => p.Line == lines[i].Line).OrderByDescending(p => p.WorkEndTime).FirstOrDefault();
  3703. DateTime StartTime = schedule == null ? actStart : (schedule.WorkEndTime >= actStart ? schedule.WorkEndTime : actStart);
  3704. //计算实际开工时间
  3705. //产线工作日历:当前产线的工作日历+默认工作日历
  3706. curCalendars = calendars.Where(p => p.ProdLine == lines[i].Line || string.IsNullOrEmpty(p.ProdLine)).ToList();
  3707. curQtyDtls = qualityLines.Where(p => p.ProdLine == lines[i].Line).ToList();
  3708. StartTime = CalcActStartTime(lines[0].Line, StartTime, curCalendars, curQtyDtls);
  3709. if (StartTime < lineStart.StartTime)
  3710. {
  3711. lineStart.RecID = lines[i].RecID;
  3712. lineStart.Line = lines[i].Line;
  3713. lineStart.StartTime = StartTime;
  3714. lineStart.setupTime = lines[i].SetupTime;
  3715. lineStart.Rate = lines[i].Rate;
  3716. }
  3717. }
  3718. //如果当前工单正在排产,且是连续排产时,重新排产不需要考虑产线准备时间
  3719. if (workOrd.Status.ToLower() == "w" && workOrd.JointTyped.ToUpper() !="B")
  3720. {
  3721. lineStart.setupTime = 0m;
  3722. }
  3723. lineStart.Op = op;
  3724. lineStart.WaitTime = routing.WaitTime * 60;
  3725. lineStart.QtyRemain = workOrd.QtyOrded - routing.QtyComplete;
  3726. return lineStart;
  3727. }
  3728. /// <summary>
  3729. /// 计算主产线实际排产开始时间
  3730. /// </summary>
  3731. /// <param name="prodLine">生产线</param>
  3732. /// <param name="startTime">开始时间</param>
  3733. /// <param name="curCalendars">当前产线工作日历+默认工作日历</param>
  3734. /// <param name="curQtyDtls">当前产线休息记录</param>
  3735. /// <returns></returns>
  3736. public DateTime CalcActStartTime(string prodLine,DateTime startTime, List<ShopCalendarWorkCtr> curCalendars, List<QualityLineWorkDetail> curQtyDtls)
  3737. {
  3738. //实际排产开始时间
  3739. DateTime actStart = startTime;
  3740. //开始时间是周几
  3741. int weekDay = (int)startTime.DayOfWeek;
  3742. //判断当天是否是工作日
  3743. bool isWorkDay = CheckIsWorkDay(startTime);
  3744. if (!isWorkDay)//不是工作日
  3745. {
  3746. //获取下一个工作日开始时间
  3747. actStart = GetNextWorkDay(weekDay, startTime, curCalendars);
  3748. return actStart;
  3749. }
  3750. //当天的工作日历
  3751. var shopCal = curCalendars.Where(p => !string.IsNullOrEmpty(p.ProdLine) && p.WeekDay == weekDay).FirstOrDefault();
  3752. if (shopCal == null)
  3753. {
  3754. //产线没有维护当天的工作日历,则取默认工作日历
  3755. shopCal = curCalendars.Where(p => string.IsNullOrEmpty(p.ProdLine) && p.WeekDay == weekDay).FirstOrDefault();
  3756. }
  3757. //当前日期的工作时间段
  3758. List<LineWorkPointDto> workPoints = DealWorkDayToLevels(prodLine, startTime, shopCal, curQtyDtls);
  3759. //计算starttime处于那个工作时间段
  3760. var curPoint = workPoints.Where(p => startTime >= p.StartPoint && startTime <= p.EndPoint).FirstOrDefault();
  3761. if (curPoint == null)//不处于工作时间段
  3762. {
  3763. //开始时间小于当天工作开始时间
  3764. if (startTime < workPoints.First().StartPoint)
  3765. {
  3766. actStart = workPoints.First().StartPoint;
  3767. }
  3768. //开始时间大于当前工作结束时间
  3769. else if (startTime > workPoints.Last().EndPoint)
  3770. {
  3771. //获取下一个工作日开始时间
  3772. actStart = GetNextWorkDay(weekDay, startTime, curCalendars);
  3773. }
  3774. else
  3775. {//开始时间位于当天的休息时间段
  3776. foreach (var item in workPoints)
  3777. {
  3778. //获取下一个时间段
  3779. var next = workPoints.Find(p => p.Level == item.Level + 1);
  3780. if (item.EndPoint < startTime && startTime < next.StartPoint)
  3781. {
  3782. actStart = next.StartPoint;
  3783. break;
  3784. }
  3785. }
  3786. }
  3787. return actStart;
  3788. }
  3789. if (startTime != curPoint.EndPoint)
  3790. {
  3791. return actStart;
  3792. }
  3793. //查询下一时间段的开始时间点
  3794. var nextPoint = workPoints.Where(p => p.Level == curPoint.Level + 1).FirstOrDefault();
  3795. if (nextPoint != null)
  3796. {
  3797. return nextPoint.StartPoint;
  3798. }
  3799. //开始时间为今天下班时间,实际排产开始时间为下一个工作日的开始时间
  3800. actStart = GetNextWorkDay(weekDay, startTime, curCalendars);
  3801. return actStart;
  3802. }
  3803. /// <summary>
  3804. /// 排产开始时间处理为半小时/整点开始--向后取整
  3805. /// </summary>
  3806. /// <param name="startTime"></param>
  3807. /// <returns></returns>
  3808. public DateTime CalcStartTimeAfter(DateTime startTime)
  3809. {
  3810. DateTime rtnTime = startTime;
  3811. DateTime curDate = startTime.Date;
  3812. //时间转换为分钟
  3813. TimeSpan span = rtnTime - curDate;
  3814. decimal sumMinutes = (decimal)span.TotalMinutes;
  3815. int times = (int)Math.Ceiling(sumMinutes / 30);
  3816. rtnTime = curDate.AddMinutes(times * 30);
  3817. return rtnTime;
  3818. }
  3819. /// <summary>
  3820. /// 排产开始时间处理为半小时/整点开始--向前取整
  3821. /// </summary>
  3822. /// <param name="startTime"></param>
  3823. /// <returns></returns>
  3824. public DateTime CalcStartTimeBefore(DateTime startTime)
  3825. {
  3826. DateTime rtnTime = startTime;
  3827. DateTime curDate = startTime.Date;
  3828. //时间转换为分钟
  3829. TimeSpan span = rtnTime - curDate;
  3830. decimal sumMinutes = (decimal)span.TotalMinutes;
  3831. int times = (int)Math.Floor(sumMinutes / 30);
  3832. rtnTime = curDate.AddMinutes(times * 30);
  3833. return rtnTime;
  3834. }
  3835. /// <summary>
  3836. /// 判断当天是否是工作日
  3837. /// </summary>
  3838. /// <param name="dateTime"></param>
  3839. /// <returns></returns>
  3840. public bool CheckIsWorkDay(DateTime dateTime)
  3841. {
  3842. bool isWorkDay = true;
  3843. //周几
  3844. int weekDay = (int)dateTime.DayOfWeek;
  3845. //判断当天是否是工作日
  3846. if (weekDay == 0 || weekDay == 6)//周六或者周日,需要判断是否调班,需要加班
  3847. {
  3848. if (!holidays.Exists(p => p.Dated.GetValueOrDefault().Date == dateTime.Date && p.Ufld1 == "调班"))//不是调班
  3849. {
  3850. isWorkDay = false;
  3851. }
  3852. return isWorkDay;
  3853. }
  3854. //不是周六周日,需要判断是不是节假日
  3855. if (holidays.Exists(p => p.Dated.GetValueOrDefault().Date == dateTime.Date && p.Ufld1 == "休假"))//是节假日
  3856. {
  3857. isWorkDay = false;
  3858. }
  3859. return isWorkDay;
  3860. }
  3861. /// <summary>
  3862. /// 计算下一产线实际排产开始时间
  3863. /// </summary>
  3864. /// <param name="workOrd">工单</param>
  3865. /// <param name="lineStart">上一产线开始时间</param>
  3866. /// <param name="routing">工序</param>
  3867. /// <param name="prodLines">产线明细</param>
  3868. /// <param name="allResults">产线占用记录</param>
  3869. /// <returns></returns>
  3870. public LineStartDto DealNextStartTime(WorkOrdMaster workOrd,LineStartDto lineStart,WorkOrdRouting routing, List<ProdLineDetail> prodLines, List<ScheduleResultOpMaster> allResults)
  3871. {
  3872. int op = routing.OP;
  3873. LineStartDto startDto = new LineStartDto();
  3874. //获取产线
  3875. var lines = prodLines.Where(p => p.Part == workOrd.ItemNum && p.Op == op).OrderBy(p=>p.Sequence).ToList();
  3876. //获取第一条产线排产结束时间
  3877. var schedule = allResults.Where(p => p.Line == lines[0].Line).OrderByDescending(p => p.WorkEndTime).FirstOrDefault();
  3878. DateTime startTime = CalcStartTimeWithSetUpTime(lines[0], lineStart.StartTime, lineStart.setupTime + lines[0].OverlapTime);
  3879. startDto.RecID = lines[0].RecID;
  3880. startDto.Line = lines[0].Line;
  3881. startDto.setupTime = lines[0].SetupTime;
  3882. startDto.StartTime = schedule == null ? startTime : (startTime < schedule.WorkEndTime ? schedule.WorkEndTime : startTime);
  3883. startDto.Rate = lines[0].Rate;
  3884. //循环剩余产线,找到最早可开工产线
  3885. for (int i = 1; i < lines.Count(); i++)
  3886. {
  3887. schedule = allResults.Where(p => p.Line == lines[i].Line).OrderByDescending(p => p.WorkEndTime).FirstOrDefault();
  3888. startTime = CalcStartTimeWithSetUpTime(lines[i], lineStart.StartTime, lineStart.setupTime + lines[i].OverlapTime);
  3889. startTime = schedule == null ? startTime : (startTime < schedule.WorkEndTime ? schedule.WorkEndTime : startTime);
  3890. if (startTime < startDto.StartTime)
  3891. {
  3892. startDto.RecID = lines[i].RecID;
  3893. startDto.Line = lines[i].Line;
  3894. startDto.setupTime = lines[i].SetupTime;
  3895. startDto.StartTime = startTime;
  3896. startDto.Rate = lines[i].Rate;
  3897. }
  3898. }
  3899. //如果当前工单正在排产,且是连续排产时,重新排产不需要考虑产线准备时间
  3900. if (workOrd.Status.ToLower() == "w" && workOrd.JointTyped.ToUpper() != "B")
  3901. {
  3902. startDto.setupTime = 0m;
  3903. }
  3904. startDto.Op = op;
  3905. startDto.WaitTime = routing.WaitTime * 60;
  3906. startDto.QtyRemain = workOrd.QtyOrded - routing.QtyComplete;
  3907. return startDto;
  3908. }
  3909. /// <summary>
  3910. /// 通过提前期计算产线排产开始时间
  3911. /// </summary>
  3912. /// <param name="line">产线</param>
  3913. /// <param name="startTime">上一产线开始时间</param>
  3914. /// <param name="setupTime">上一产线准备时间+当前产线提前期</param>
  3915. /// <returns></returns>
  3916. public DateTime CalcStartTimeWithSetUpTime(ProdLineDetail line, DateTime startTime, decimal setupTime)
  3917. {
  3918. //提前期转换成分钟
  3919. decimal needMinute = setupTime * 60;
  3920. //实际排产开始时间
  3921. DateTime actStart = startTime;
  3922. //开始时间是周几
  3923. int weekDay = (int)startTime.DayOfWeek;
  3924. //当天的工作日历
  3925. var shopCal = calendars.Where(p => p.ProdLine == line.Line && p.WeekDay == weekDay).FirstOrDefault();
  3926. if (shopCal == null)
  3927. {
  3928. //产线没有维护当天的工作日历,则取默认工作日历
  3929. shopCal = calendars.Where(p => string.IsNullOrEmpty(p.ProdLine) && p.WeekDay == weekDay).FirstOrDefault();
  3930. }
  3931. //当前产线的休息时间设置
  3932. var curQtyDtls = qualityLines.Where(p => p.ProdLine == line.Line).ToList();
  3933. //当前日期的工作时间段
  3934. List<LineWorkPointDto> workPoints = DealWorkDayToLevels(line.Line, startTime, shopCal, curQtyDtls);
  3935. //计算starttime处于那个工作时间段
  3936. var curPoint = workPoints.Where(p => startTime >= p.StartPoint && startTime <= p.EndPoint).FirstOrDefault();
  3937. //当前时间段可用时长
  3938. TimeSpan span = curPoint.EndPoint - startTime;
  3939. decimal curMins = (decimal)span.TotalMinutes;
  3940. if (curMins >= needMinute)//当前时间段的可用时长满足提前期
  3941. {
  3942. actStart = startTime.AddMinutes((double)needMinute);
  3943. return actStart;
  3944. }
  3945. //当前时间段的可用时长不满足
  3946. //剩余提前期
  3947. needMinute -= curMins;
  3948. //获取后层级时间段
  3949. var prePoints = workPoints.Where(p => p.Level > curPoint.Level).OrderBy(p => p.Level).ToList();
  3950. bool flag = true;//标志位
  3951. foreach (var item in prePoints)
  3952. {
  3953. if (item.WorkMinutes >= needMinute)//当前时间段的可用时长满足
  3954. {
  3955. actStart = item.StartPoint.AddMinutes((double)needMinute);
  3956. flag = false;
  3957. break;
  3958. }
  3959. needMinute -= item.WorkMinutes;
  3960. }
  3961. if (!flag)
  3962. {
  3963. return actStart;
  3964. }
  3965. //今天可用时长不够,往后工作日找
  3966. DateTime nextStartTime = startTime;
  3967. while (flag)
  3968. {
  3969. //获取下一个工作日
  3970. nextStartTime = GetNextWorkDay(weekDay, startTime, calendars.Where(p => p.ProdLine == line.Line || string.IsNullOrEmpty(p.ProdLine)).ToList());
  3971. weekDay = (int)nextStartTime.DayOfWeek;
  3972. //获取前一个工作日的工作时间段数据,level顺排
  3973. var curCalendar = calendars.Where(p => p.ProdLine == line.Line && p.WeekDay == weekDay).FirstOrDefault();
  3974. if (curCalendar == null )
  3975. {
  3976. curCalendar = calendars.Where(p => string.IsNullOrEmpty(p.ProdLine) && p.WeekDay == weekDay).FirstOrDefault();
  3977. }
  3978. workPoints = DealWorkDayToLevels(line.Line, nextStartTime, curCalendar, curQtyDtls).OrderBy(p => p.Level).ToList();
  3979. //当天的工作时长(分钟)
  3980. decimal sumWorkMins = workPoints.Sum(p => p.WorkMinutes);
  3981. if (sumWorkMins >= needMinute)//当天可用提前期满足
  3982. {
  3983. //获取开始时间
  3984. foreach (var item in workPoints)
  3985. {
  3986. if (item.WorkMinutes >= needMinute)//当前时间段满足
  3987. {
  3988. actStart = item.StartPoint.AddMinutes((double)needMinute);
  3989. break;
  3990. }
  3991. needMinute -= item.WorkMinutes;
  3992. }
  3993. flag = false;
  3994. }
  3995. else
  3996. {
  3997. //当天可用提前期不满足
  3998. needMinute -= sumWorkMins;
  3999. }
  4000. }
  4001. return actStart;
  4002. }
  4003. /// <summary>
  4004. /// 获取下一个工作日开始时间
  4005. /// </summary>
  4006. /// <param name="weekDay">当前周几</param>
  4007. /// <param name="startTime">开始时间</param>
  4008. /// <param name="curCalendars">当前产线的工作日历+默认工作日历</param>
  4009. /// <returns></returns>
  4010. public DateTime GetNextWorkDay(int weekDay, DateTime startTime, List<ShopCalendarWorkCtr> curCalendars)
  4011. {
  4012. DateTime rtnData = startTime;
  4013. //下一天
  4014. DateTime nextDate = startTime.Date.AddDays(1);
  4015. //下一天是周几
  4016. int nextWeekDay = (weekDay + 1) % 7;
  4017. //获取工作日历:先获取当前产线的工作日历,若没有维护,则获取默认工作日历
  4018. var calendar = curCalendars.FirstOrDefault(p =>!string.IsNullOrEmpty(p.ProdLine) && p.WeekDay == nextWeekDay);
  4019. if (calendar == null)
  4020. {
  4021. calendar = curCalendars.FirstOrDefault(p => string.IsNullOrEmpty(p.ProdLine) && p.WeekDay == nextWeekDay);
  4022. }
  4023. string strStart = calendar.ShiftsStart1.ToString("0.00").Replace(".", ":");
  4024. //判断下一天是否是工作日
  4025. if (nextWeekDay == 0 || nextWeekDay == 6)//下一天是周六或者周日,需要判断是否调班,需要加班
  4026. {
  4027. if (!holidays.Exists(p => p.Dated.GetValueOrDefault().Date == nextDate && p.Ufld1 == "调班"))//下一天是周末
  4028. {
  4029. //递归继续找下一个工作日
  4030. rtnData = GetNextWorkDay(nextWeekDay, nextDate, curCalendars);
  4031. return rtnData;
  4032. }
  4033. rtnData = Convert.ToDateTime(nextDate.ToString("yyyy-MM-dd") + " " + strStart);
  4034. return rtnData;
  4035. }
  4036. //下一天不是周六周日,需要判断是不是节假日
  4037. if (holidays.Exists(p => p.Dated.GetValueOrDefault().Date == nextDate && p.Ufld1 == "休假"))//是节假日
  4038. {
  4039. //递归继续找下一个工作日
  4040. rtnData = GetNextWorkDay(nextWeekDay, nextDate, curCalendars);
  4041. return rtnData;
  4042. }
  4043. rtnData = Convert.ToDateTime(nextDate.ToString("yyyy-MM-dd") + " " + strStart);
  4044. return rtnData;
  4045. }
  4046. /// <summary>
  4047. /// 处理当前日期的工作时间段
  4048. /// </summary>
  4049. /// <param name="prodLine"></param>
  4050. /// <param name="startTime"></param>
  4051. /// <param name="shopCal">当前产线的工作日历-周几</param>
  4052. /// <param name="curQtyDtls">每天休息记录</param>
  4053. /// <returns></returns>
  4054. public List<LineWorkPointDto> DealWorkDayToLevels(string prodLine, DateTime startTime, ShopCalendarWorkCtr shopCal, List<QualityLineWorkDetail> curQtyDtls)
  4055. {
  4056. //年-月-日
  4057. string date = startTime.Date.ToString("yyyy-MM-dd");
  4058. //排产记录结束日期是周几
  4059. int weekDay = (int)startTime.DayOfWeek;
  4060. //工作时间段
  4061. List<LineWorkPointDto> workPoints = new List<LineWorkPointDto>();
  4062. LineWorkPointDto dto = new LineWorkPointDto();
  4063. int level = 1;
  4064. TimeSpan span = TimeSpan.Zero;
  4065. //开始时间
  4066. string strStart = shopCal.ShiftsStart1.ToString("0.00").Replace(".", ":");
  4067. DateTime dayStartPoint = Convert.ToDateTime(date + " " + strStart);
  4068. //结束时间
  4069. DateTime dayEndPoint = dayStartPoint.AddHours((double)(shopCal.ShiftsHours1 + shopCal.ShiftsHours2));
  4070. dto.Level = level;
  4071. dto.Line = prodLine;
  4072. dto.WeekDay = weekDay;
  4073. dto.StartPoint = dayStartPoint;
  4074. //按照产线休息时间切分时间段
  4075. curQtyDtls = curQtyDtls.OrderBy(p => p.RestTimePoint).ToList();
  4076. foreach (var item in curQtyDtls)
  4077. {
  4078. DateTime endPoint = Convert.ToDateTime(date + " " + item.RestTimePoint);
  4079. dto.EndPoint = endPoint;
  4080. span = dto.EndPoint - dto.StartPoint;
  4081. dto.WorkMinutes = (decimal)span.TotalMinutes;
  4082. workPoints.Add(dto);
  4083. level++;
  4084. dto = new LineWorkPointDto();
  4085. dto.Level = level;
  4086. dto.Line = prodLine;
  4087. dto.WeekDay = weekDay;
  4088. dto.StartPoint = endPoint.AddMinutes(item.RestTime);
  4089. }
  4090. dto.EndPoint = dayEndPoint;
  4091. span = dto.EndPoint - dto.StartPoint;
  4092. dto.WorkMinutes = (decimal)span.TotalMinutes;
  4093. workPoints.Add(dto);
  4094. //产线当天加班设置
  4095. var curOccupyTimes = resourceOccupancyTimes.Where(p => p.Resource == prodLine && p.StartTime.GetValueOrDefault().Date == startTime.Date).OrderBy(p=>p.StartTime).ToList();
  4096. foreach (var item in curOccupyTimes)
  4097. {
  4098. level++;
  4099. dto = new LineWorkPointDto();
  4100. dto.Level = level;
  4101. dto.Line = prodLine;
  4102. dto.WeekDay = weekDay;
  4103. dto.StartPoint = item.StartTime.GetValueOrDefault();
  4104. dto.EndPoint = dto.StartPoint.AddHours(Convert.ToDouble(item.Ufld1));
  4105. dto.WorkMinutes = Convert.ToDecimal(item.Ufld1) * 60;
  4106. workPoints.Add(dto);
  4107. }
  4108. return workPoints.OrderBy(p => p.Level).ToList();
  4109. }
  4110. /// <summary>
  4111. /// 调整领料单时间
  4112. /// </summary>
  4113. /// <param name="workords"></param>
  4114. public void AdjustNbrDate(List<WorkOrdMaster> workords)
  4115. {
  4116. if (workords.Any())
  4117. {
  4118. //找出当前工单的所有领料单,更新领料单的前处理时间和完成日期。
  4119. //1.如果未生成领料单,则无需调整。
  4120. //2.已生成领料单,但是领料单已出库,也不调整。nbr.Status='C'
  4121. //3.当领料单未出库,则代表需要调整这个领料单的处理时间。
  4122. var nbrlist = _nbrMaster.Select(s => workords.Select(x => x.WorkOrd).Contains(s.WorkOrd) && s.Domain == workords[0].Domain).ToList();
  4123. if (nbrlist.Any())
  4124. {
  4125. foreach (var work in workords)
  4126. {
  4127. var workNbr = nbrlist.Where(s => s.WorkOrd == work.WorkOrd).ToList();
  4128. foreach (var nbr in workNbr)
  4129. {
  4130. if (string.IsNullOrEmpty(nbr.Status))
  4131. {
  4132. if (nbr.TransType == "PrevProcess")
  4133. {
  4134. //前处理领料单
  4135. var ts = nbr.EffDate.GetValueOrDefault() - nbr.Date.GetValueOrDefault();
  4136. nbr.EffDate = work.OrdDate.GetValueOrDefault().AddDays(-1);
  4137. nbr.Date = nbr.EffDate.GetValueOrDefault().AddDays(-ts.Days);
  4138. }
  4139. else
  4140. {
  4141. nbr.EffDate = work.OrdDate.GetValueOrDefault().AddDays(-1);
  4142. nbr.Date = nbr.EffDate;
  4143. }
  4144. if (nbr.Date.GetValueOrDefault().Date <= DateTime.Now.Date)
  4145. {
  4146. nbr.Date = DateTime.Now.AddDays(1).Date;
  4147. }
  4148. if (nbr.EffDate.GetValueOrDefault().Date <= DateTime.Now.Date)
  4149. {
  4150. nbr.EffDate = DateTime.Now.AddDays(1).Date;
  4151. }
  4152. }
  4153. }
  4154. }
  4155. _nbrMaster.Update(nbrlist);
  4156. }
  4157. }
  4158. }
  4159. }
  4160. }