/// <summary> /// az in tabe bara ijad ye list estefade mikonam /// </summary> /// <returns></returns> public List <ExcelInventoryCheck.frmMain.Prouduct> ReadExcelDataBase() { List <ExcelInventoryCheck.frmMain.Prouduct> myDataBaseList = new List <ExcelInventoryCheck.frmMain.Prouduct>(); ExcelInventoryCheck.frmMain.Prouduct currentProuct = new ExcelInventoryCheck.frmMain.Prouduct(); //#ForTest //MessageBox.Show(ws.Rows.Count.ToString()); // startubg index try { // MessageBox.Show(ws.Rows.Count.ToString()); for (int i = 2; i < ws.Rows.Count; i++) { currentProuct = ReadProuct(i); if (currentProuct.code == "-1") { break; } myDataBaseList.Add(currentProuct); } return(myDataBaseList); } catch (Exception) { return(myDataBaseList); } }
/// <summary> /// Crate Prouct From Excel Row /// </summary> /// <param name="row"></param> /// <returns>obj of Product</returns> public ExcelInventoryCheck.frmMain.Prouduct ReadProuct(int row) { ExcelInventoryCheck.frmMain.Prouduct myProduct = new ExcelInventoryCheck.frmMain.Prouduct(); string productCode = ReadCell(row, 2); string productName = ReadCell(row, 1); if (string.IsNullOrEmpty(productName)) { //flag proudut to count myProduct.code = "-1"; return(myProduct); } myProduct.code = productCode; myProduct.name = productName; //handel empty cell for column initial number string initValueString = ReadCell(row, 4); //MessageBox.Show(initValueString); if (initValueString != string.Empty || initValueString != null) { try { myProduct.initialNumber = int.Parse(initValueString); } catch (Exception) { myProduct.initialNumber = 0; } } return(myProduct); }
public void WriteProuduct(ExcelInventoryCheck.frmMain.Prouduct myProduct, int rowIndexforFiling) { //int numberOfFilledRow = ws.Rows.Count; //int rowIndexforFiling = numberOfFilledRow++; WriteToCell(rowIndexforFiling + 2, 1, myProduct.name); WriteToCell(rowIndexforFiling + 2, 2, myProduct.code); WriteToCell(rowIndexforFiling + 2, 3, myProduct.initialNumber.ToString()); WriteToCell(rowIndexforFiling + 2, 4, myProduct.totalNumber.ToString()); WriteToCell(rowIndexforFiling + 2, 5, myProduct.diffrenceNumber.ToString()); }