/// <summary>
/// GetExcelData
/// : Upload할 엑셀파일을 DataSet으로 리턴
/// </summary>
/// <param name="asFilePath"></param>
/// <returns></returns>
public DataSet GetExcelData(string asFilePath)
{
DataSet lDS = new DataSet();
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Suppress))
{
Dac_ctl_ctlPassExcel_Upload dac = new Dac_ctl_ctlPassExcel_Upload();
lDS = dac.GetExcelData(asFilePath);
scope.Complete();
}
return(lDS);
}
/// <summary>
/// UpdateEmpPass
/// : 사용자 비밀번호 일괄 업데이트
/// </summary>
/// <param name="asFilePath"></param>
/// <returns></returns>
public int UpdateEmpPass(string asFilePath)
{
int iRet = 0;
DataSet lDS = new DataSet();
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Suppress))
{
Dac_ctl_ctlPassExcel_Upload dac = new Dac_ctl_ctlPassExcel_Upload();
lDS = GetExcelData(asFilePath);
foreach (DataRow dr in lDS.Tables[0].Rows)
{
iRet += dac.SetExcelUpdate(dr[0].ToString(), dr[2].ToString());
}
scope.Complete();
}
return(iRet);
}
