private bool LoadShipmentsByBoxId(BoxOutEntity boxEntity, DataGridView shipmentGrid) { ShipmentRepository _repositoryShipment = new ShipmentRepository(); ShipmentExport shipmentexport = new ShipmentExport(); try { if (boxEntity == null) { shipmentGrid.DataSource = null; return(false); } List <ShipmentExport> listShipment = _repositoryShipment.GetListShipmentByBoxId(boxEntity.Id); string text = ""; DialogResult process = DialogResult.Yes; if (listShipment != null && listShipment.Count > 0) { text += "Tổng số đơn hàng: " + listShipment.Count; text += "\nXuất kho ngày " + boxEntity.DateCreated.ToString("dd/MM/yyyy"); text += "\nBạn muốn mở không ?"; process = MessageBox.Show(text, boxEntity.BoxId, MessageBoxButtons.YesNo, MessageBoxIcon.Question); } if (process == DialogResult.Yes) { if (listShipment != null) { AddShipmentListToGrid(listShipment, shipmentGrid); } return(true); } else { shipmentGrid.DataSource = null; return(false); } } catch (Exception ex) { Ultilities.FileHelper.WriteLog(Ultilities.ExceptionLevel.Function, "LoadShipmentsByBoxId", ex); return(false); } }
private void ChiTietSanLuongXuatKho() { BoxOutEntity box = _boxOutServices.GetByBoxCode(cbbBoxIdOut.Text); if (box == null) { MessageBox.Show("Chọn mã thùng để in báo cáo!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } List <ShipmentExport> listDetail = _repositoryShipment.GetListShipmentByBoxId(box.Id); DataTable table = new DataTable(); table.Columns.Add(StringHeaderReports.STT); table.Columns.Add(StringHeaderReports.MAWB); table.Columns.Add(StringHeaderReports.BOXID); table.Columns.Add(StringHeaderReports.SHIPMENTNO); //table.Columns.Add(StringHeaderReports.DECLARATION_NO, typeof(string)); table.Columns.Add(StringHeaderReports.CONTENT); //table.Columns.Add(StringHeaderReports.NUMBER_PACKAGE); table.Columns.Add(StringHeaderReports.WEIGHT); int totalThung = 0, index = 1; int totalShipment; if (listDetail != null && listDetail.Count > 0) { totalShipment = listDetail.Count; totalThung = 1; int boxId = listDetail[0].BoxIdRef; for (int i = 0; i < totalShipment; i++) { // var shipment = listShipDetail.Find(t => t.ShipmentId == listDetail[i].ShipmentId); DataRow row = table.NewRow(); row[StringHeaderReports.STT] = index; row[StringHeaderReports.MAWB] = listDetail[i].MasterBillIdString; row[StringHeaderReports.SHIPMENTNO] = "'" + listDetail[i].ShipmentId; row[StringHeaderReports.BOXID] = listDetail[i].BoxIdString; row[StringHeaderReports.WEIGHT] = listDetail[i].Weight; row[StringHeaderReports.CONTENT] = listDetail[i].Content; table.Rows.Add(row); index++; if (boxId != listDetail[i].BoxIdRef) { totalThung++; boxId = listDetail[i].BoxIdRef; } } } else { MessageBox.Show("Chưa có hàng hóa nào được xuất kho!"); return; } string infoHeader = "MÃ THÙNG: "; string value = box.BoxId; Dictionary <string, string> first = new Dictionary <string, string>(); first.Add("NGÀY XUẤT : ", dtpNgayXuat.Value.ToString("dd/MM/yyyy")); Dictionary <string, string> second = new Dictionary <string, string>(); second.Add(infoHeader, value); second.Add("TỔNG SỐ ĐƠN HÀNG: ", "" + totalShipment); FormUltils.getInstance().ExportToExcel(table, "CT_Xuat_Kho_Theo_Thung", StringHeaderReports.REPORTS_NAME_CHI_TIET_XUAT_KHO, StringHeaderReports.REPORT_CODE_01, first, second); #region word report //int totalShipment; //if (listDetail != null && listDetail.Count > 0) //{ // totalShipment = listDetail.Count; //} //else //{ // MessageBox.Show("Chưa có đơn hàng của mã thùng này nào được xuất kho!", "Không có dữ liệu", MessageBoxButtons.OK, MessageBoxIcon.Information); // return; //} //string fileName = Environment.CurrentDirectory + @"\ChiTietSanLuongXuatKho" + DateTime.Now.ToString("ddMMyyyHHmmss") + ".doc"; //string companyName = "CÔNG TY CP CÔNG NGHỆ THẦN TỐC\t\t\t\t\t\tEMW01"; //string headlineText = "BẢNG KÊ CHI TIẾT SẢN LƯỢNG XUẤT KHO"; //string ngayDen = "NGÀY ĐẾN : " + dtpNgayXuat.Value.ToString("dd/MM/yyyy") + "\n" // + "MÃ SỐ THÙNG: " + box.BoxId // + "\t\t\tTỔNG ĐƠ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].MasterBillIdString).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].BoxIdString).Font(new FontFamily("Times New Roman")); // table.Rows[i + 1].Cells[4].Paragraphs.First().Append("").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("").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 + "\""); #endregion }