public void RunCombineMergerListItem()
{
CombineItem main = new CombineItem(packItem.GetColor1(), packItem.GetColor2());
main.UpdateCombineElement(new CombineEle(packItem.GetProductSize(), packItem.GetQuantity()));
listCombineItem.Add(main);
if (packItem.GetMergerList() != null && packItem.GetMergerList().Count > 0)
{
foreach (MergerItem merger in packItem.GetMergerList())
{
bool iscombine = false;
foreach (CombineItem combine in listCombineItem)
{
if (combine.GetColor1() == merger.GetColor1())
{
iscombine = true;
combine.UpdateCombineElement(new CombineEle(merger.GetProductSize(), merger.GetQuantity()));
break;
}
}
if (!iscombine)
{
main = new CombineItem(merger.GetColor1(), merger.GetColor2());
main.UpdateCombineElement(new CombineEle(merger.GetProductSize(), merger.GetQuantity()));
listCombineItem.Add(main);
}
}
}
}
////////////////////////////////////////////////////////////////////
private void CreateRowValueSheet_1(PackingListItem item, DatabaseItem databaseItem)
{
NPOI.SS.UserModel.IRow r;
if (item.GetQuantity() < databaseItem.GetMaxPacketSize())
{
r = sheet_1.CreateRow(rowIndex_sheet_1);
rowIndex_sheet_1++;
numberPacket_sheet_1++;
double valueMerger = item.GetQuantity();
if (item.GetMergerList() != null && item.GetMergerList().Count > 0)
{
foreach (MergerItem merger in item.GetMergerList())
{
valueMerger += merger.GetQuantity();
}
}
for (int idex = 0; idex < Sheet_1_Header.Length; idex++)
{
ICell cell = r.CreateCell(idex);
cell.CellStyle = sheet_1_headerStyle;
switch (idex)
{
case 0:
cell.SetCellValue(this.packingParser.GetDateTime());
break;
case 1:
cell.SetCellValue(item.GetNameProduct());
break;
case 2:
cell.SetCellValue(item.GetColor1());
break;
case 3:
cell.SetCellValue(item.GetColor2());
break;
case 4:
cell.SetCellValue(item.GetProductSize());
break;
case 5:
cell.SetCellValue(item.GetQuantity());
if (valueMerger > item.GetQuantity())
{
cell.CellStyle = sheet_1_headerStyle_2;
}
break;
case 6:
cell.SetCellValue(1);
break;
case 7:
cell.SetCellValue(numberPacket_sheet_1);
break;
case 8:
if (valueMerger <= item.GetQuantity())
{
cell.SetCellValue(valueMerger);
}
break;
case 9:
cell.SetCellValue(databaseItem.GetNetWeight());
break;
case 10:
cell.SetCellValue(databaseItem.GetAllWeight());
break;
case 11:
cell.SetCellValue(databaseItem.GetPacketInformation());
break;
default:
break;
}
}
}
else
{
for (int tmp = 0; tmp < (int)(item.GetQuantity() / databaseItem.GetMaxPacketSize()); tmp++)
{
numberPacket_sheet_1++;
r = sheet_1.CreateRow(rowIndex_sheet_1);
rowIndex_sheet_1++;
for (int idex = 0; idex < Sheet_1_Header.Length; idex++)
{
ICell cell = r.CreateCell(idex);
cell.CellStyle = sheet_1_headerStyle;
switch (idex)
{
case 0:
cell.SetCellValue(this.packingParser.GetDateTime());
break;
case 1:
cell.SetCellValue(item.GetNameProduct());
break;
case 2:
cell.SetCellValue(item.GetColor1());
break;
case 3:
cell.SetCellValue(item.GetColor2());
break;
case 4:
cell.SetCellValue(item.GetProductSize());
break;
case 5:
cell.SetCellValue(databaseItem.GetMaxPacketSize());
break;
case 6:
cell.SetCellValue(1);
break;
case 7:
cell.SetCellValue(numberPacket_sheet_1);
break;
case 8:
cell.SetCellValue(databaseItem.GetMaxPacketSize());
break;
case 9:
cell.SetCellValue(databaseItem.GetNetWeight());
break;
case 10:
cell.SetCellValue(databaseItem.GetAllWeight());
break;
case 11:
cell.SetCellValue(databaseItem.GetPacketInformation());
break;
default:
break;
}
}
}
}
if (item.GetMergerList() != null && item.GetMergerList().Count > 0)
{
foreach (MergerItem merger in item.GetMergerList())
{
r = sheet_1.CreateRow(rowIndex_sheet_1);
rowIndex_sheet_1++;
for (int idex = 0; idex < Sheet_1_Header.Length; idex++)
{
ICell cell = r.CreateCell(idex);
cell.CellStyle = sheet_1_headerStyle;
switch (idex)
{
case 0:
cell.SetCellValue(this.packingParser.GetDateTime());
break;
case 1:
cell.SetCellValue(merger.GetNameProduct());
break;
case 2:
cell.SetCellValue(merger.GetColor1());
break;
case 3:
cell.SetCellValue(merger.GetColor2());
break;
case 4:
cell.SetCellValue(merger.GetProductSize());
break;
case 5:
cell.SetCellValue(merger.GetQuantity());
cell.CellStyle = sheet_1_headerStyle_2;
break;
case 6:
break;
case 7:
cell.SetCellValue(numberPacket_sheet_1);
break;
case 8:
break;
case 9:
//cell.SetCellValue(databaseItem.GetNetWeight());
break;
case 10:
//cell.SetCellValue(databaseItem.GetAllWeight());
break;
case 11:
//cell.SetCellValue(databaseItem.GetPacketInformation());
break;
default:
break;
}
}
}
r = sheet_1.GetRow(rowIndex_sheet_1 - (1 + item.GetMergerList().Count));
String fomular = "SUM(F" + (rowIndex_sheet_1 - item.GetMergerList().Count) + ":F" + rowIndex_sheet_1 + ")";
if (r.GetCell(8) != null)
{
r.GetCell(8).CellFormula = fomular;
}
NPOI.SS.Util.CellRangeAddress range_1 = new NPOI.SS.Util.CellRangeAddress(rowIndex_sheet_1 - (1 + item.GetMergerList().Count),
rowIndex_sheet_1 - 1, 6, 6);
NPOI.SS.Util.CellRangeAddress range_2 = new NPOI.SS.Util.CellRangeAddress(rowIndex_sheet_1 - (1 + item.GetMergerList().Count),
rowIndex_sheet_1 - 1, 8, 8);
sheet_1.AddMergedRegion(range_1);
sheet_1.AddMergedRegion(range_2);
}
}
