private void TempDataToDataBase()
{
#region
try
{
ArrayList arl_Return = null;
string s_LoginUser = string.Empty;
string s_UploadPath_File = string.Empty;
string s_BackPath_File = string.Empty;
int err_cnt;
s_LoginUser = Session["UID"].ToString();//登入人員
ALOModel.ImportStoreOrderItem BCO = new ALOModel.ImportStoreOrderItem(ConnectionDB);
if (s_AP_FileName != string.Empty)
{ arl_Return = BCO.TmpToDB(s_AP_FileName, s_LoginUser, PageTimeStamp.Value); }
else
{ this.Response.Write("請重新匯入 EXCEL 檔"); }
if (arl_Return[0].ToString() == "TEMPTODB 正確")
{
#region 設定 UploadStatusPanel 的值
//匯入結果
UploadStatusPanel1.ImportSum = iProcessingCounts;
UploadStatusPanel1.ImportOK = iProcessingCounts;
UploadStatusPanel1.ImportNG = 0;
#endregion
}
else if (arl_Return[0].ToString() == "CHECKDATA 不正確")
{
#region 設定 UploadStatusPanel 的值
//匯入結果
UploadStatusPanel1.ImportSum = iProcessingCounts;
int.TryParse(arl_Return[1].ToString(), out err_cnt);
UploadStatusPanel1.ImportOK = iProcessingCounts - err_cnt;
UploadStatusPanel1.ImportNG = err_cnt;
#endregion
}
}
catch (Exception ex)
{
this.ErrorMsgLabel.Text = ex.Message;
}
finally
{
this.but_Temp_To_DB.Enabled = false;
this.but_File_To_Temp.Enabled = true;
this.but_Unusual_Report.Enabled = true;
this.ButtonQuery.Enabled = true;
this.btn_Back.Enabled = true;
}
#endregion
}
