private void Load_Err2(ArrayList ParameterList) { ImportStoreOrderItem BCO = new ImportStoreOrderItem(ConntionDB); DataTable dt = BCO.QueryTemp2Error(ParameterList); if (dt.Rows.Count > 0) { ViewState[gv_ErrorData2.ID] = dt; this.gv_ErrorData.DataSource = dt.DefaultView; //頁面顯示初始狀態設定 //設定檢視異常報表每頁幾筆資料 this.gv_ErrorData2.PageSize = (TextBoxPagesize2.Text == "") ? 10 : (int.Parse(TextBoxPagesize2.Text) < 0) ? 10 : int.Parse(TextBoxPagesize2.Text); this.gv_ErrorData2.PageIndex = 0; ViewState[gv_ErrorData2.ID + "SortField"] = null; ViewState[gv_ErrorData2.ID + "SortDirect"] = null; BindData(gv_ErrorData2); } else { this.gv_ErrorData2.DataBind(); } up_GridView2.Update(); }
private void Export_Excel() { try { ImportStoreOrderItem BCO = new ImportStoreOrderItem(ConntionDB); // 讀取 Excel 資料 ParameterList.Clear(); ParameterList.Add(Session["UID"].ToString()); DataTable dt = BCO.QueryTemp2(ParameterList); ExcelXmlWorkbook book = new ExcelXmlWorkbook(); Worksheet sheet0 = book[0];//即有品項 Worksheet sheet1 = book[1];//新增品項 Worksheet sheet2 = book[2];//異動品項 AddSheetData(ref sheet0, "即有品項", dt.Select("CHECK_FLAG='3'")); AddSheetData(ref sheet1, "新增品項", dt.Select("CHECK_FLAG='1'")); AddSheetData(ref sheet2, "異動品項", dt.Select("CHECK_FLAG='2'")); //設定輸出檔名 string s_FileName = ""; s_FileName = HttpUtility.UrlEncode(txtExportFileName.Text.Trim(), System.Text.Encoding.UTF8); //File download Response.Charset = "big5"; Response.ContentType = "application/x-excel;charset='utf-8'";//"application/vnd.ms-excel"; Response.AddHeader("content-disposition", "attachment; filename=" + s_FileName);//excel檔名 System.IO.MemoryStream stream = new System.IO.MemoryStream(); book.Export(stream); string producedExcel = GetStringFromMemoryStream(stream); stream.Close(); Response.Write(producedExcel); Response.Flush(); Response.End(); } catch (Exception ex) { this.ErrorMsgLabel.Text = ex.ToString(); } finally { } }
private void TmpToDb() { ImportStoreOrderItem BCO = new ImportStoreOrderItem(ConntionDB); ArrayList arl_Return = null; arl_Return = BCO.TmpToDB(Session["UID"].ToString(), this.SLP_StoreChain1.Text); // 將結果顯示在 UploadStatusPanel 中 //上傳結果 this.UploadStatusPanel1.ImportSum = ((int)arl_Return[1]); this.UploadStatusPanel1.ImportOK = ((int)arl_Return[2]); this.UploadStatusPanel1.ImportNG = ((int)arl_Return[3]); }
private bool FileToTmp1(string strDataSource, string strOrg_FileName) { bool bResult = false; ImportStoreOrderItem BCO = new ImportStoreOrderItem(ConntionDB); // 讀取 Excel 資料 //DataSet ds_Excel = Load_Excel(strDataSource, "高見出貨表", 0); //Excel Sheet_1 DataSet ds_Excel = Load_Excel(strDataSource, "雜誌出貨表", 0); //DataSet ds_Excel = Load_Excel(strDataSource, "", 1); //Excel Sheet_1 // 將檔案匯入TmpTable ArrayList arl_FileToTmp_Return = null; arl_FileToTmp_Return = BCO.FileToTmp1(ds_Excel, Session["UID"].ToString(), this.SLP_StoreChain1.Text, strOrg_FileName); // 將結果顯示在 UploadStatusPanel 中 //上傳結果 this.UploadStatusPanel1.UploadSum = ((int)arl_FileToTmp_Return[1]); if ((int)arl_FileToTmp_Return[1] > 0) bResult = true; else bResult = false; return bResult; }
private void ClientFileToServerTemp() { btnExport.Enabled = false; btnQueryErrALL.Enabled = false; if (FileUpload1.FileName != "") { try { //設定頁面狀態 this.ErrorMsgLabel.Text = ""; System.Threading.Thread.Sleep(2000); string s_UploadPath = string.Empty; string s_BackPath = string.Empty; ArrayList arl_FileUpload_Return = null; ImportStoreOrderItem BCO = new ImportStoreOrderItem(ConntionDB); //取得要上傳的路徑 s_UploadPath = Server.MapPath("..\\") + System.Configuration.ConfigurationManager.AppSettings["UploadPath"] + "\\MKT\\"; string strOrg_FileName = FileUpload1.FileName;//原始的檔名 //0.TRUE:成功 FALSE:失敗 //1.含路徑的完整上傳檔名 //2.上傳時間(DateTime格式) //3.不含路徑的完整上傳檔名含路徑 arl_FileUpload_Return = BCO.FileUpload(s_UploadPath, this.FileUpload1, Session["UID"].ToString()); if (arl_FileUpload_Return[0].ToString() == "FALSE")//檔案上傳至AP端錯誤 { this.ErrorMsgLabel.Text = "檔案上傳至AP端錯誤<br/>"; Clear_UploadStatus(); //狀態欄歸零 return; } else if (arl_FileUpload_Return[0].ToString() == "TRUE")//檔案上傳至AP端正常 { string s_AP_FileName = arl_FileUpload_Return[3].ToString();//檔案上傳後的新檔名 string strDataSource = arl_FileUpload_Return[1].ToString(); //把頁籤1的資料匯入Tmp1 bool bSuccess1 = FileToTmp1(strDataSource, strOrg_FileName); //把頁籤1的資料匯入Tmp1 bool bSuccess2 = FileToTmp2(strDataSource, strOrg_FileName); //把匯入資料做一些其他的檢查 BCO.CheckOther(Session["UID"].ToString()); //取得Tmp1和Tmp2 成功和錯誤筆數 ArrayList arl_Return1 = new ArrayList(); arl_Return1 = BCO.GetTmp1Count(Session["UID"].ToString()); this.UploadStatusPanel1.UploadOK = ((int)arl_Return1[0]); this.UploadStatusPanel1.UploadNG = ((int)arl_Return1[1]); ArrayList arl_Return2 = new ArrayList(); arl_Return2 = BCO.GetTmp2Count(Session["UID"].ToString()); this.UploadStatusPanel2.UploadOK = ((int)arl_Return2[0]); this.UploadStatusPanel2.UploadNG = ((int)arl_Return2[1]); if ((int)arl_Return1[0] > 0) { if (((int)arl_Return1[1] == 0) && ((int)arl_Return2[1] == 0)) { //暫存檔寫入對照檔 TmpToDb(); btnExport.Enabled = true; } else { btnQueryErrALL.Enabled = true; } } else { btnQueryErrALL.Enabled = true; } //把上傳檔案移到備份區 MoveFile(s_UploadPath, s_AP_FileName); } } catch (Exception ex) { this.ErrorMsgLabel.Text = ex.Message; } } }