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; }