|
public static ToList ( DataTable table ) : IList |
||
| table | DataTable | |
| return | IList |
|
/// <summary>
/// 使用調整單的品號去，找退料檔裡面出現幾次，並產生免安裝執行檔
/// </summary>
private void btnCheckExcelData()
{
if (ddlExcelSheets.Items.Count == 0)
{
MessageBox.Show("Please Choose Excel File", "Info");
}
if (ddlExcelSheets.Items.Count > 0)
{
ImportFileService importFileService = new ImportFileService();
ExportFileService exportFileService = new ExportFileService();
try
{
//調整單
DataTable dtRevision = new DataTable();
dtRevision = importFileService.ExcelToDataTable(txtFilePath.Text, 0, 104);
//退料單
DataTable dtReturn = new DataTable();
dtReturn = importFileService.ExcelToDataTable(txtFilePath.Text, 1, 5);
var result = DataTableExtensions.ToList <Material>(dtReturn).ToList();
List <Material> returnList = result as List <Material>;
//Compare excel data
DataTable dt = importFileService.CompareRevisionAndReturn(dtRevision, returnList);
ResponseMessage response = exportFileService.DataTableToExcelFile(dt, txtFilePath.Text);
if (response.Success)
{
MessageBox.Show("檢查成功，已將Excel匯出到選擇檔案的路徑", "Info");
}
else
{
MessageBox.Show(response.ErrorMsg, "error");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "error");
}
}
}