private DataTable GetErrorData(string strDate, string strUID)
{
DataTable dtResult = new DataTable();
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(strUID);
ParameterList.Add(strDate);
ParameterList.Add("2");
BSM_PUR.PUR09_BCO BCO = new BSM_PUR.PUR09_BCO(ConnectionDB);
dtResult = BCO.QueryTemp(ParameterList);
return dtResult;
}
private void TempToSession()
{
//從TMP取出放在Session內,等關掉視窗時在丟給PUR091_MST的SESSION
Session["PUR095_" + Request["PageTimeStamp"].ToString()] = null;
ErrorMsgLabel.Text = "";
DataTable dt = new DataTable();
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add("");
ParameterList.Add("");
BSM_PUR.PUR09_BCO BCO = new BSM_PUR.PUR09_BCO(ConnectionDB);
dt = BCO.QueryTemp(ParameterList);
ArrayList arl_Return = new ArrayList();
arl_Return.Add(dt.Rows.Count.ToString());
DataRow[] FindRows = dt.Select("DATATYPE=1");
arl_Return.Add(FindRows.Length);
FindRows = dt.Select("DATATYPE=2");
arl_Return.Add(FindRows.Length);
//上傳結果
this.UploadStatusPanel1.UploadSum = 0;
this.UploadStatusPanel1.UploadOK = 0;
this.UploadStatusPanel1.UploadNG = 0;
//匯入結果
this.UploadStatusPanel1.ImportSum = int.Parse(arl_Return[0].ToString());
this.UploadStatusPanel1.ImportOK = int.Parse(arl_Return[1].ToString());
this.UploadStatusPanel1.ImportNG = int.Parse(arl_Return[2].ToString());
if (int.Parse(arl_Return[0].ToString()) == int.Parse(arl_Return[1].ToString()))
{
Session["PUR095_" + Request["PageTimeStamp"].ToString()] = dt;
ErrorMsgLabel.Text = "［執行匯入］成功，資料已匯入。";
}
else if (int.Parse(arl_Return[0].ToString()) != int.Parse(arl_Return[1].ToString()))
{
ErrorMsgLabel.Text = "［執行匯入］失敗，請檢視異常報表！";
}
this.btn_File_To_Temp.Enabled = true;
this.btn_Unusual_Report.Enabled = true;
this.btnQuery.Enabled = true;
}
