public void RecordItem(LightItem _obj)
{
Excel.Range cell = GetCell_ItemNumber(_obj);
cell.Value2 = _obj.ItemNumber;
cell = GetCell_BatchNumber(_obj);
cell.Value2 = _obj.BatchNumber;
cell = GetCell_SerialNumber(_obj);
cell.Value2 = _obj.SerialNumber;
cell = GetCell_ExpiryDate(_obj);
cell.Value2 = _obj.ExpiryDate.ToString("yyyy-MMM-dd");
cell = GetCell_Brand(_obj);
cell.Value2 = _obj.Brand;
cell = GetCell_Color(_obj);
cell.Value2 = _obj.Color;
cell = GetCell_Size(_obj);
cell.Value2 = ((int)_obj.Size).ToString();
cell = GetCell_Gender(_obj);
cell.Value2 = ((int)_obj.Gender).ToString();
}
public LightItem GetItem(string item_number)
{
LightItem _obj = new LightItem();
_obj.ItemNumber = item_number;
int fullRow = this.Rows.Count;
Excel.Range r = this.Cells[fullRow, 1] as Excel.Range;
Excel.Range endr = r.get_End(Excel.XlDirection.xlUp);
int nInLastRow = endr.Row;
//int nInLastRow = ws.Cells.Find("*", System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlPrevious, false, System.Reflection.Missing.Value, System.Reflection.Missing.Value).Row;
int rowIndex = GetRowIndex(nInLastRow, item_number);
if (rowIndex == nInLastRow + 1)
{
_obj.RecordIndex = rowIndex;
RecordItem(_obj);
}
else
{
_obj.RecordIndex = rowIndex;
LoadItem(_obj);
}
return(_obj);
}
public void LoadItem(LightItem _obj)
{
Excel.Range cell = GetCell_ItemNumber(_obj);
_obj.ItemNumber = cell.Value2.ToString();
cell = GetCell_BatchNumber(_obj);
if (cell.Value2 != null)
{
_obj.BatchNumber = cell.Value2.ToString();
}
cell = GetCell_SerialNumber(_obj);
if (cell.Value2 != null)
{
_obj.SerialNumber = cell.Value2.ToString();
}
cell = GetCell_ExpiryDate(_obj);
if (cell.Value2 != null)
{
_obj.ExpiryDate = DateTime.Parse(cell.Value2.ToString());
}
cell = GetCell_Brand(_obj);
if (cell.Value2 != null)
{
_obj.Brand = cell.Value2.ToString();
}
cell = GetCell_Color(_obj);
if (cell.Value2 != null)
{
_obj.Color = cell.Value2.ToString();
}
cell = GetCell_Size(_obj);
if (cell.Value2 != null)
{
_obj.Size = (LightItem.ItemSize)Convert.ToInt32(cell.Value2.ToString());
}
cell = GetCell_Gender(_obj);
if (cell.Value2 != null)
{
_obj.Gender = (LightItem.ItemGender)Convert.ToInt32(cell.Value2.ToString());
}
}
public Excel.Range GetCell_Gender(LightItem _obj)
{
return(this.Cells[_obj.RecordIndex, 8] as Excel.Range);
}
public Excel.Range GetCell_Size(LightItem _obj)
{
return(this.Cells[_obj.RecordIndex, 7] as Excel.Range);
}
public Excel.Range GetCell_Brand(LightItem _obj)
{
return(this.Cells[_obj.RecordIndex, 5] as Excel.Range);
}
public Excel.Range GetCell_ExpiryDate(LightItem _obj)
{
return(this.Cells[_obj.RecordIndex, 4] as Excel.Range);
}
public Excel.Range GetCell_SerialNumber(LightItem _obj)
{
return(this.Cells[_obj.RecordIndex, 3] as Excel.Range);
}
public Excel.Range GetCell_BatchNumber(LightItem _obj)
{
return(this.Cells[_obj.RecordIndex, 2] as Excel.Range);
}
