public ReportDetailEntity SearchByShipmentId(string shipmentId) { ReportDetailEntity reportEntity = new ReportDetailEntity(); var result = _unitOfWork.ShipmentTempRepository.Get(t => t.ShipmentId.Equals(shipmentId, StringComparison.CurrentCultureIgnoreCase)); if (result != null) { reportEntity.ShipmentId = result.ShipmentId; if (result.BoxInfo != null) { reportEntity.BoxId = result.BoxInfo.BoxId; } else { reportEntity.BoxId = string.Empty; } return(reportEntity); } return(null); }
private void ChiTietSanLuongNhapKhoTheoThung() { List <ReportDetailEntity> listDetail = new List <ReportDetailEntity>(); BoxInforEntity boxSelected = (BoxInforEntity)cbbBoxId.SelectedItem; int totalShipment = 0; List <ShipmentEntity> listShipment = (List <ShipmentEntity>)_shipmentServices.GetByBoxId(boxSelected.Id); if (listShipment != null & listShipment.Count > 0) { foreach (var ship in listShipment) { ReportDetailEntity entity = new ReportDetailEntity(); entity.MasterId = cbbMasterBill.Text; entity.BoxId = boxSelected.BoxId; entity.ShipmentId = ship.ShipmentId; entity.Weight = ship.Weight; entity.Content = ship.Content; listDetail.Add(entity); } totalShipment = listShipment.Count; } string fileName = Environment.CurrentDirectory + @"\ChiTietSanLuongNhapKhoTheoThung" + DateTime.Now.ToString("ddMMyyyHHmmss") + ".doc"; string companyName = "CÔNG TY CP CÔNG NGHỆ THẦN TỐC\t\t\t\t\t\tIMW03"; string headlineText = "BẢNG KÊ CHI TIẾT SẢN LƯỢNG NHẬP KHO"; string ngayDen = "NGÀY ĐẾN : " + dtpNgayDen.Value.ToString("dd/MM/yyyy") + "\n" + "MÃ THÙNG: " + boxSelected.BoxId + "\t\t\tTỔNG SỐ ĐƠN HÀNG: " + totalShipment; string boPhanGiaoNhan = "BỘ PHẬN KHO\t\t\t\t\t\tBỘ PHẬN GIAO NHẬN"; // A formatting object for our headline: var headLineFormat = new Formatting(); headLineFormat.FontFamily = new System.Drawing.FontFamily("Times New Roman"); headLineFormat.Size = 18D; headLineFormat.Position = 12; headLineFormat.Bold = true; // A formatting object for our normal paragraph text: var paraFormat = new Formatting(); paraFormat.FontFamily = new System.Drawing.FontFamily("Times New Roman"); paraFormat.Size = 12D; paraFormat.Position = 10; paraFormat.Bold = false; var paraRightFormat = new Formatting(); paraRightFormat.FontFamily = new System.Drawing.FontFamily("Times New Roman"); paraRightFormat.Size = 12D; paraRightFormat.Position = 12; paraRightFormat.Bold = true; // Create the document in memory: var doc = DocX.Create(fileName); Table table = doc.AddTable(listDetail.Count + 1, 7); //table.ColumnWidths.Add(100); table.ColumnWidths.Add(500); table.ColumnWidths.Add(100); table.Rows[0].Cells[0].Paragraphs.First().Append("STT").Font(new FontFamily("Times New Roman")); //table.Rows[0].Cells[0].Width = 50; table.Rows[0].Cells[1].Paragraphs.First().Append("Vận đơn chủ (MAWB)").Font(new FontFamily("Times New Roman")).Alignment = Alignment.center; //table.Rows[0].Cells[1].Width = 800; table.Rows[0].Cells[2].Paragraphs.First().Append("Mã đơn hàng (ShipmentNo)").Font(new FontFamily("Times New Roman")).Alignment = Alignment.center; table.Rows[0].Cells[3].Paragraphs.First().Append("Mã thùng (BoxId)").Font(new FontFamily("Times New Roman")).Alignment = Alignment.center; table.Rows[0].Cells[4].Paragraphs.First().Append("Nội dung (Content)").Font(new FontFamily("Times New Roman")).Alignment = Alignment.center; table.Rows[0].Cells[5].Paragraphs.First().Append("Số lượng (Quantity)").Font(new FontFamily("Times New Roman")).Alignment = Alignment.center; table.Rows[0].Cells[6].Paragraphs.First().Append("Trọng lượng (Weight)").Font(new FontFamily("Times New Roman")).Alignment = Alignment.center; //table.Rows[0].Cells[2].Width = 100; table.Rows[0].Cells[0].FillColor = Color.FromName("DarkGray"); table.Rows[0].Cells[1].FillColor = Color.FromName("DarkGray"); table.Rows[0].Cells[2].FillColor = Color.FromName("DarkGray"); table.Rows[0].Cells[3].FillColor = Color.FromName("DarkGray"); table.Rows[0].Cells[4].FillColor = Color.FromName("DarkGray"); table.Rows[0].Cells[5].FillColor = Color.FromName("DarkGray"); table.Rows[0].Cells[6].FillColor = Color.FromName("DarkGray"); for (int i = 0; i < totalShipment; i++) { table.Rows[i + 1].Cells[0].Paragraphs.First().Append((i + 1) + "").Font(new FontFamily("Times New Roman")); table.Rows[i + 1].Cells[1].Paragraphs.First().Append(listDetail[i].MasterId).Font(new FontFamily("Times New Roman")); table.Rows[i + 1].Cells[2].Paragraphs.First().Append(listDetail[i].ShipmentId).Font(new FontFamily("Times New Roman")); table.Rows[i + 1].Cells[3].Paragraphs.First().Append(listDetail[i].BoxId).Font(new FontFamily("Times New Roman")); table.Rows[i + 1].Cells[4].Paragraphs.First().Append(listDetail[i].Content).Font(new FontFamily("Times New Roman")); table.Rows[i + 1].Cells[5].Paragraphs.First().Append("").Font(new FontFamily("Times New Roman")); table.Rows[i + 1].Cells[6].Paragraphs.First().Append("" + listDetail[i].Weight).Font(new FontFamily("Times New Roman")); } doc.InsertParagraph(companyName, false, paraFormat); doc.InsertParagraph(Environment.NewLine); // Insert the now text obejcts; Paragraph title = doc.InsertParagraph(headlineText, false, headLineFormat); title.Alignment = Alignment.center; doc.InsertParagraph(ngayDen, false, paraFormat); doc.InsertTable(table); doc.InsertParagraph(Environment.NewLine); Paragraph giaoNhan = doc.InsertParagraph(boPhanGiaoNhan, false, paraRightFormat); giaoNhan.Alignment = Alignment.center; // Save to the output directory: doc.SaveAs(fileName); // Open in Word: Process.Start("WINWORD.EXE", "\"" + fileName + "\""); }