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