public bool UpdateInStockHeader(InStockHeaderViewModel model) { var instanceToUpdate = _inStockHeaderRepository.FindBy(x => x.InStockNumber == model.InStockNumber).FirstOrDefault(); if (instanceToUpdate == null) { return(false); } //instanceToUpdate.ApplicationPerson = model.ApplicationPerson; instanceToUpdate.CreatePerson = model.CreatePerson; //instanceToUpdate.FollowupPerson = model.FollowupPerson; instanceToUpdate.AuditDepart = model.AuditDepart; instanceToUpdate.Auditor = model.Auditor; instanceToUpdate.UpdateDate = DateTime.Now; try { _inStockHeaderRepository.Edit(instanceToUpdate); _inStockHeaderRepository.Save(); return(true); } catch (Exception) { return(false); } }
private void gridView1_RowUpdated(object sender, RowObjectEventArgs e) { SplashScreenManager.ShowDefaultWaitForm(); InStockHeaderViewModel row = (InStockHeaderViewModel)this.gridView1.GetFocusedRow(); _stockService.UpdateInStockHeader(row); SplashScreenManager.CloseDefaultWaitForm(); }
private void GenerateInStockWorkSheet(InStockHeaderViewModel inStockHeaderViewModel, ExcelWorksheet template) { if (inStockHeaderViewModel == null) { return; } decimal subTotal = 0; var row = 8; template.Name = inStockHeaderViewModel.InStockNumber; template.InsertRow(row, inStockHeaderViewModel.InStockViewModels.Count); //Header var requestHeader = _requestHeaderRepository.FindBy(x => x.RequestHeaderNumber == inStockHeaderViewModel.RequestNumber).Include(c => c.Contract).FirstOrDefault(); template.Cells["B3"].Value = DateTime.Now.ToString("yyyy-MM-dd"); //出单日期 template.Cells["D3"].Value = inStockHeaderViewModel.ApplicationDept; //制表科室 template.Cells["F3"].Value = inStockHeaderViewModel.CreatePerson; //制表人 template.Cells["H3"].Value = inStockHeaderViewModel.AuditDepart; //审核部门 template.Cells["J3"].Value = inStockHeaderViewModel.AuditDepart; //审核人 template.Cells["B4"].Value = inStockHeaderViewModel.InStockNumber; //入库单号 template.Cells["D4"].Value = inStockHeaderViewModel.CreatePerson; //仓库名称 template.Cells["H4"].Value = inStockHeaderViewModel.PurchaseNumber; //采购单号 if (requestHeader != null) { template.Cells["F4"].Value = requestHeader.Contract.Address; //合同地址 template.Cells["J4"].Value = requestHeader.Contract.ContractNumber; //合同编号 template.Cells["B5"].Value = requestHeader.RequestCategory.ToString(); //入库类型 } //Body foreach (var m in inStockHeaderViewModel.InStockViewModels) { var serialNo = "A" + row; var name = "B" + row; var code = "C" + row; var model = "D" + row; var specification = "E" + row; var dimension = "F" + row; var position = "G" + row; //库位 var total = "H" + row; var unit = "I" + row; var currentPrice = "J" + row; var totalPrice = "K" + row; var note = "L" + row; template.Cells[serialNo].Value = serialNo; template.Cells[name].Value = m.Name; template.Cells[code].Value = m.Code; template.Cells[model].Value = m.Model; template.Cells[specification].Value = m.Specification; template.Cells[dimension].Value = m.Dimension; template.Cells[position].Value = m.PositionName; template.Cells[total].Value = m.Total; template.Cells[unit].Value = m.Unit; template.Cells[currentPrice].Value = $"{m.Price:C}"; template.Cells[totalPrice].Value = $"{m.Price * m.Total:C}"; template.Cells[note].Value = m.Note; template.Row(row).Height = 35; template.Cells[serialNo + ":" + note].Style.Font.Size = 12; template.Cells[serialNo + ":" + note].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center; template.Cells[serialNo + ":" + note].Style.VerticalAlignment = ExcelVerticalAlignment.Center; template.Cells[serialNo + ":" + note].Style.Border.Top.Style = ExcelBorderStyle.Thin; template.Cells[serialNo + ":" + note].Style.Border.Left.Style = ExcelBorderStyle.Thin; template.Cells[serialNo + ":" + note].Style.Border.Right.Style = ExcelBorderStyle.Thin; template.Cells[serialNo + ":" + note].Style.Border.Bottom.Style = ExcelBorderStyle.Thin; subTotal = subTotal + (decimal)m.Price * m.Total; row++; } template.Cells["K" + row++].Value = $"{subTotal:C}"; //总计 template.Cells["K" + row++].Value = $"{subTotal * (decimal)0.13:C}"; //HST template.Cells["K" + row].Value = $"{subTotal * (decimal)1.13:C}"; //总合计 }