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