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 + "\"");
}