/**
* この関数は、列と行を指定して、距離値1個をマップにセットします。
* <p>注意 -
* このAPIは低速です。性能が必要な時は、{@link #setPointDists}を参考に、一括書込みする関数を検討してください。
* </p>
* @param i_col
* 列のインデクスを指定します。
* @param i_row
* 行のインデクスを指定します。
* @param i_dist
* その行と列の距離値を指定します。
*/
public void setDist(int i_col, int i_row, int i_dist)
{
this._min_dist_index = this._size_col * i_row + i_col;
DistItem item = this._map[this._min_dist_index];
item.col = i_col;
item.row = i_row;
item.dist = i_dist;
//最小値・最大値の再計算
if (i_dist < this._min_dist)
{
this._min_dist = i_dist;
}
return;
}
public FileReaderResults AddDistReport(SkillsMatrixDB database, string filePath, out List <string> unknownUsers)
{
FileReaderResults ret = FileReaderResults.FileReaderUnknownError;
unknownUsers = new List <string>();
Excel.Application xlApp = new Excel.Application();
Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(filePath);
Excel._Worksheet xlWorksheet = (Excel.Worksheet)xlWorkbook.Sheets[1];
Excel.Range xlRange = xlWorksheet.UsedRange;
int rowCount = xlRange.Rows.Count;
int colCount = xlRange.Columns.Count;
int currentRow = 1;
int matches = 0;
try
{
//iterate over the rows and columns
//excel is not zero based!!
for (int col = 1; col <= colCount; col++)
{
Excel.Range cell = (Excel.Range)xlWorksheet.Cells[currentRow, col];
if (cell.Value2 != null)
{
if (DistColumns.Contains(cell.Value2))
{
matches++;
}
}
Marshal.FinalReleaseComObject(cell);
}
if (matches == DistColumns.Count)
{
ret = FileReaderResults.FileReaderSuccess;
}
else
{
ret = FileReaderResults.FileReaderWrongFormat;
}
if (ret == FileReaderResults.FileReaderSuccess)
{
for (currentRow++; currentRow <= rowCount; currentRow++)
{
PersonModel person = new PersonModel();
LocationModel locn = new LocationModel();
for (int col = 1; col <= colCount; col++)
{
Excel.Range cell = (Excel.Range)xlWorksheet.Cells[currentRow, col];
DistItem colIdx = (DistItem)(col - 1);
switch (colIdx)
{
case DistItem.MgrFullName:
// we only process people who are in the database already, so no need to get the manager
// person.ManagerName = cell.Value2.ToString();
break;
case DistItem.DistFullName:
person.Name = cell.Value2.ToString();
break;
case DistItem.DistLocation:
string locStr = cell.Value2.ToString();
string hashCode = ComputeSha256Hash(locStr);
if (LocationMap.ContainsKey(hashCode))
{
locn.LocationName = LocationMap[hashCode];
}
else
{
locn.LocationName = "Unknown";
}
break;
}
Marshal.FinalReleaseComObject(cell);
}
if (database.SaveDistData(person, locn) != 1)
{
ret = FileReaderResults.FileReaderUnknownUser;
unknownUsers.Add(person.Name);
}
}
}
}
catch (Exception ex)
{
ret = FileReaderResults.FileReaderUnknownError;
}
finally
{
//close and release
Marshal.FinalReleaseComObject(xlRange);
Marshal.FinalReleaseComObject(xlWorksheet);
//close and release
xlWorkbook.Close();
Marshal.FinalReleaseComObject(xlWorkbook);
//quit and release
xlApp.Quit();
Marshal.FinalReleaseComObject(xlApp);
// take the trash out
CleanupExcel();
}
return(ret);
}
