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); }