private void textBox_PlanNo_Last_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { var planId = this.textBox_PlanNo_Last.Text.Trim(); using (_dbcontext = new FlowManageSystemEntities()) { orderRepositoy = new OrderRepository(_dbcontext); if (!orderRepositoy.PlanNoExist(planId)) { MessageBox.Show("计划单号不存在,请输入正确的单号!!!"); return; } var order = orderRepositoy.getOrderByPlanNo(planId); var snMin = order.SnMin; var snMax = order.SnMax; var needDo = order.OnLineQuantity; //根据SN范围查询已经做了测试的 using (_opwayDbContext = new ATSDATABASEEntities()) { opwayDataRepository = new OpwayDataRepository(_opwayDbContext); //拿到已做的数量更新界面 var count = 0; if (this.cBox_LastUndo.Checked == true) { var listFinishedSn = opwayDataRepository.GetLastTestFinishedSN(snMin, snMax); var AllList = SnHelper.GetSnlist(snMin, needDo); count = listFinishedSn.Count(); //更新界面未做的SN this.ltBox_LastUndo.DataSource = AllList.Except(listFinishedSn).ToList(); } else { count = opwayDataRepository.GetLastTestCount(snMin, snMax); } this.lbLastTestFinished.Text = count.ToString(); } } } }
private void textBox_searchPlanOrder_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { var planId = this.textBox_searchPlanOrder.Text.Trim(); using (var dbContext = new FlowManageSystemEntities()) { orderRepositoy = new OrderRepository(dbContext); collectionRepository = new CollectionRepository(dbContext); assembleRepository = new AssembleRepository(dbContext); if (!orderRepositoy.PlanNoExist(planId)) { MessageBox.Show("计划单号不存在,请输入正确的单号!!!"); return; } //更新界面--订单相关信息 var order = orderRepositoy.getOrderByPlanNo(planId); var orderId = order.OrderId; this.lbOrderDate.Text = order.OrderDate.ToShortDateString(); this.lbPlanOnlineDate.Text = order.PlannedLaunchDate.ToShortDateString(); this.lbDemandDate.Text = order.CustomDemandDate.ToShortDateString(); this.lbPlanStorageDate.Text = order.PlanStorageDate.ToShortDateString(); //更新界面--领料相关信息 if (collectionRepository.IsOrderCollectionExist(orderId)) { var collectionInfo = collectionRepository.GetCurrentOrderCollectionInfo(orderId); this.lbCollectionCount.Text = collectionInfo.Item1.ToString(); this.lbCollectionTime.Text = collectionInfo.Item2.ToString(); } else { this.lbCollectionCount.Text = "未领取物料"; this.lbCollectionTime.Text = ""; } //更新界面--组装相关信息 if (assembleRepository.IsOrderAssembleExist(orderId)) { var collectionInfo = assembleRepository.GetCurrentOrderAssembleInfo(orderId); this.lbAssembleCount.Text = collectionInfo.Item1.ToString(); this.lbAssembleTime.Text = collectionInfo.Item2.ToString(); } else { this.lbCollectionCount.Text = "未开始组装"; this.lbCollectionTime.Text = ""; } //初调相关信息 //终测相关信息 using (_opwayDbContext = new ATSDATABASEEntities()) { opwayDataRepository = new OpwayDataRepository(_opwayDbContext); var snMin = order.SnMin; var snMax = order.SnMax; this.lbFirstTestCount.Text = opwayDataRepository.GetFirstTestCount(snMin, snMax).ToString(); this.lbFInishedTestCount.Text = opwayDataRepository.GetLastTestCount(snMin, snMax).ToString(); } } } }
/// <summary> /// 订单入库 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void textBox_Storage_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { if (!RegexHelper.regExpNumber.IsMatch(this.textBox_StorageNumber.Text.Trim())) { MessageBox.Show("入库数量应该是数字"); return; } //从界面获取计划单号 和 入库数量 var planId = this.textBox_Storage.Text.Trim(); var StorageCount = Convert.ToInt32(this.textBox_StorageNumber.Text); using (_dbcontext = new FlowManageSystemEntities()) { orderRepositoy = new OrderRepository(_dbcontext); //判断计划单号是否存在 if (!orderRepositoy.PlanNoExist(planId)) { MessageBox.Show("当前计划单号在数据库不存在,请检查!"); return; } //获取当前订单生产模块个数 var order = orderRepositoy.getOrderByPlanNo(planId); var count = order.OnLineQuantity; var dbCount = order.OrderStorageCount; //入库数量不能大于订单要求做的数量 if (count < StorageCount) { MessageBox.Show("当前订单数量: " + count + " 入库数量:" + StorageCount + "请检查错误!"); return; } //不允许重复入库 if (dbCount != null) { MessageBox.Show("当前订单已入库!!!入库数量:" + dbCount); return; } //获取实际测试个数 using (_opwayDbContext = new ATSDATABASEEntities()) { var snMin = order.SnMin; var snMax = order.SnMax; opwayDataRepository = new OpwayDataRepository(_opwayDbContext); if (opwayDataRepository.GetLastTestCount(snMin, snMax) < StorageCount) { MessageBox.Show("入库数量不能大于终测通过的数量!!!"); return; } } //检查通过 进行入库 try { orderRepositoy.OrderStorage(planId, StorageCount); orderRepositoy.SaveChanges(); MessageBox.Show("入库成功!"); this.textBox_Storage.Text = ""; this.textBox_StorageNumber.Text = ""; } catch (Exception ex) { MessageBox.Show("发生异常:" + ex.Message); } } } }