private void Export_Excel() { try { this.ErrorMsgLabel.Text = ""; ParameterList.Clear(); ParameterList.Add(SLP_VENDOR.Text.Trim()); BCO.VAM21_BCO bco = new BCO.VAM21_BCO(ConntionDB); DataTable dt = bco.QueryData(ParameterList); if (dt.Rows.Count == 0) { this.ErrorMsgLabel.Text = "查無資料"; return; } ExcelXmlWorkbook book = new ExcelXmlWorkbook(); Worksheet sheet0 = book[0]; AddSheetData(ref sheet0, "Sheet1", dt); //設定輸出檔名 string s_FileName = s_FileName = HttpUtility.UrlEncode("折讓單自動排除廠商.XLS", System.Text.Encoding.UTF8); //File download Response.Charset = "big5"; Response.ContentType = "application/x-excel;charset='utf-8'"; 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 { } }
protected void btnSave_Click(object sender, EventArgs e) { ErrorMsgLabel.Text = ""; WriteToCache(); BCO.VAM21_BCO bco = new BCO.VAM21_BCO(ConntionDB); DataTable dt = (DataTable)Session["VAM211_" + PageTimeStamp.Value]; #region 檢查是否有輸入廠商資料 int iEmptyRows = 0; for (int i = 0; i < dt.Rows.Count; i++) { if ((dt.Rows[i]["CREATEUID"].ToString() == "") && (dt.Rows[i]["VENDOR"].ToString() == "")) { iEmptyRows++; } } if (dt.Rows.Count == iEmptyRows) { ErrorMsgLabel.Text = "尚未輸入廠商資料,不可儲存."; return; } #endregion #region 檢查是否有重複設定 string strErr = string.Empty; for (int i = 0; i < GridView1.Rows.Count; i++) { string strVENDOR = ((ASP.vdm_slp_slp_vendorbase_ascx)GridView1.Rows[i].FindControl("SLP_VENDOR")).Text; if (strVENDOR != "") { DataRow[] FindRows = dt.Select("VENDOR='" + strVENDOR + "' And ENABLE=1"); if (FindRows.Length > 1) { int iRow = i + 1; strErr += "第 " + iRow.ToString() + " 行 廠商編號重複設定<BR/>"; } } } if (strErr != "") { ErrorMsgLabel.Text = strErr; return; } #endregion #region 檢查DB裡面是否已經存在,並且不是在這次的編輯之中的 for (int i = 0; i < GridView1.Rows.Count; i++) { string strVENDOR = ((ASP.vdm_slp_slp_vendorbase_ascx)GridView1.Rows[i].FindControl("SLP_VENDOR")).Text; if (strVENDOR != "") { ParameterList.Clear(); ParameterList.Add(strVENDOR); DataTable dtCheck = bco.QueryData(ParameterList); if (dtCheck.Rows.Count != 0) { DataRow[] FindRows = dt.Select("ID=" + dtCheck.Rows[0]["ID"].ToString() + " And CREATEUID is not null"); //是否是在本次編輯的範圍內 if (FindRows.Length == 0) { int iRow = i + 1; strErr += "第 " + iRow.ToString() + " 行 廠商編號已經存在資料庫中<BR/>"; } } } } if (strErr != "") { ErrorMsgLabel.Text = strErr; return; } #endregion #region 儲存資料 ParameterList.Clear(); ParameterList.Add(DateTime.Now); ParameterList.Add(Session["UID"].ToString()); bco.SaveData(ParameterList, dt); #endregion #region 重新顯示所有資料 ParameterList.Clear(); ParameterList.Add(DBNull.Value); dt = bco.QueryData(ParameterList); if (dt.Rows.Count == 0) { this.ErrorMsgLabel.Text = "廠商資料已全部刪除"; btnNewRow.Visible = false; btnSave.Visible = false; } else { this.ErrorMsgLabel.Text = "儲存完成"; btnNewRow.Visible = true; btnSave.Visible = true; } Session["VAM211_" + PageTimeStamp.Value] = dt; Build_GridView1(); #endregion }
private void LoadData() { try { ParameterList.Clear(); ParameterList.Add(SLP_VENDOR.Text.Trim()); BCO.VAM21_BCO bco = new BCO.VAM21_BCO(ConntionDB); DataTable dt = bco.QueryData(ParameterList); if (dt.Rows.Count == 0) { this.ErrorMsgLabel.Text = "查無資料"; btnNewRow.Visible = false; btnSave.Visible = false; } else { btnNewRow.Visible = true; btnSave.Visible = true; } Session["VAM211_" + PageTimeStamp.Value] = dt; Build_GridView1(); } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }
protected void btnNew_Click(object sender, EventArgs e) { this.ErrorMsgLabel.Text = ""; ParameterList.Clear(); ParameterList.Add("XXXXXXXXXX"); //只讀取Table Schema BCO.VAM21_BCO bco = new BCO.VAM21_BCO(ConntionDB); DataTable dt = bco.QueryData(ParameterList); Session["VAM211_" + PageTimeStamp.Value] = dt; for (int i = 0; i < 5; i++) AddRow(); btnNewRow.Visible = true; btnSave.Visible = true; Build_GridView1(); string strClientID = ((ASP.vdm_slp_slp_vendorbase_ascx)GridView1.Rows[0].FindControl("SLP_VENDOR")).TextBox_Code.ClientID; ScriptManager.RegisterStartupScript(Page, this.GetType(), "SetToFocus", "SetToFocus('" + strClientID + "');", true); }