private DataTable GetReportTableWIP()
{
DataTable dt = GetDataTableSchema(DataDefine.eTAGCardType.WIP);
ItemBIZ bizItem = new ItemBIZ();
ItemImageBIZ bizImage = new ItemImageBIZ();
int row = shtView.Rows.Count;
if (row == 0)
{
return(null);
}
int rowdt = -1;
for (int i = 0; i < row; i++)
{
// get Item Information for each row
NZString ItemCD = new NZString(null, shtView.Cells[i, (int)eColView.PART_NO].Value);
ItemDTO dtoItem = bizItem.LoadItem(ItemCD);
ItemImageDTO dtoImage = bizImage.LoadImage(ItemCD);
int copyCount = Convert.ToInt32(shtView.Cells[i, (int)eColView.NUM_OF_COPY].Value);
if (dtoItem == null)
{
continue;
}
for (int j = 0; j < copyCount; j++)
{
dt.Rows.Add();
rowdt++;
dt.Rows[rowdt][(int)eTAGCardWIP.BARCODE] = string.Format("{0}{3}{1}{3}{2}"
, shtView.Cells[i, (int)eColView.PART_NO].Value
, shtView.Cells[i, (int)eColView.LOT_NO].Value
, shtView.Cells[i, (int)eColView.LOT_SIZE].Value
, DataDefine.BARCODE_SEPARATER);
// Add by Pichet
dt.Rows[rowdt][(int)eTAGCardWIP.BARCODE] = GenBarcodeEncode((dt.Rows[rowdt][(int)eTAGCardWIP.BARCODE]).ToString(), m_barCodeType);
// Add by Pichet
dt.Rows[rowdt][(int)eTAGCardWIP.IMAGE_BIN] = dtoImage == null ? null : dtoImage.IMAGE.StrongValue;
dt.Rows[rowdt][(int)eTAGCardWIP.ITEM_CD] = dtoItem.ITEM_CD.StrongValue;
dt.Rows[rowdt][(int)eTAGCardWIP.ITEM_DESC] = dtoItem.ITEM_DESC.StrongValue;
//dt.Rows[rowdt][(int)eTAGCardWIP.FOR_CUSTOMER] = dtoItem.FOR_CUSTOMER.StrongValue;
//dt.Rows[rowdt][(int)eTAGCardWIP.PART_8_DIGIT] = dtoItem.ITEM_8_DIGITS.StrongValue;
dt.Rows[rowdt][(int)eTAGCardWIP.LOT_NO] = shtView.Cells[i, (int)eColView.LOT_NO].Value;
//dt.Rows[rowdt][(int)eTAGCardWIP.MAIN_MATTERIAL] = dtoItem.MAIN_MATTERIAL.StrongValue;
if (shtView.Cells[i, (int)eColView.LOT_SIZE].Value.ToString() != string.Empty)
{
dt.Rows[rowdt][(int)eTAGCardWIP.PACK_SIZE] = Convert.ToDecimal(shtView.Cells[i, (int)eColView.LOT_SIZE].Value).ToString();
}
//dt.Rows[rowdt][(int)eTAGCardWIP.INV_UM_CLS] = GetInventoryUMCls(dtoItem.INV_UM_CLS);
}
}
return(dt);
}
internal int AddNewImage(string ItemCD, Image image)
{
ItemImageBIZ biz = new ItemImageBIZ();
MemoryStream memStream = new MemoryStream();
image.Save(memStream, image.RawFormat);
memStream.Position = 0;
byte[] byteArray = memStream.ToArray();
memStream.Close();
return(biz.AddImage(ItemCD, byteArray));
}
internal Image LoadImageForItem(EVOFramework.NZString ItemCD)
{
ItemImageBIZ biz = new ItemImageBIZ();
ItemImageDTO dto = biz.LoadImage(ItemCD);
if (dto == null)
{
return(null);
}
// Convert byte array to Image.
byte[] byteArray = dto.IMAGE.StrongValue;
MemoryStream memoryStream = new MemoryStream(byteArray);
Image img = Image.FromStream(memoryStream);
return(img);
}
/// <summary>
/// Get new instance of all image on database. This method will store to cache together.
/// </summary>
/// <returns>Image Item List</returns>
public ImageItemList GetAllImages()
{
ImageItemList list = new ImageItemList();
ItemImageBIZ bizImage = new ItemImageBIZ();
List <ItemImageDTO> imgList = bizImage.LoadAllImage();
for (int i = 0; i < imgList.Count; i++)
{
// Convert byte array to Image.
byte[] byteArray = imgList[i].IMAGE.StrongValue;
MemoryStream memoryStream = new MemoryStream(byteArray);
Image img = Image.FromStream(memoryStream);
memoryStream.Close();
// Add to image cache.
ImageItem item = new ImageItem(imgList[i].ITEM_CD.StrongValue, img);
//m_imageItemList.Add(item);
list.Add(item);
}
return(list);
}
internal void ReMoveImage(EVOFramework.NZString ItemCD)
{
ItemImageBIZ biz = new ItemImageBIZ();
biz.DeleteImage(ItemCD);
}
