private void DataBind_SG(ArrayList ParameterList) { ErrorMsgLabel_SG.Text = ""; #region 連結資料庫 BCO.STM35_BCO bco = new BCO.STM35_BCO(ConntionDB); DataTable dt_PRICE_SG = bco.QueryDataPrice_SG(ParameterList); #endregion if (!dt_PRICE_SG.Columns.Contains("CHECKED"))//增加欄位以方便判別是否可 dt_PRICE_SG.Columns.Add("CHECKED"); if (!dt_PRICE_SG.Columns.Contains("ROWID"))//增加欄位以判別勾選與否 dt_PRICE_SG.Columns.Add("ROWID"); hidden_RowID_MaxID_G.Value = dt_PRICE_SG == null ? "-1" : (dt_PRICE_SG.Rows.Count - 1).ToString();//記錄最大ROWID hidden_RowID_Selected_G.Value = "";//清空已選 SetRowIDToDataTable(dt_PRICE_SG, false, "SG");//設定ROWID //抓取本頁初次登記的時間 string SessionIDName_SG = "STM352_SG_" + PageTimeStamp.Value; //Session["SessionID"] = SessionIDName; Session[SessionIDName_SG] = dt_PRICE_SG; bAfterQueryDataBinding = true; this.GridView2.DataSource = dt_PRICE_SG; this.GridView2.PageSize = (TextBoxPagesize1.Text == "") ? 10 : (int.Parse(TextBoxPagesize1.Text) < 0) ? 10 : int.Parse(TextBoxPagesize1.Text); this.GridView2.PageIndex = 0; this.GridView2.DataBind(); bAfterQueryDataBinding = false; if (dt_PRICE_SG.Rows.Count == 0) { SG_hid.Visible = false; SG_hid1.Visible = false; ErrorMsgLabel_SG.Text = "查無資料!"; } UpdatePanel4.Update(); }
/// <summary> /// BUTTON [審核通過]鈕(店群) /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnPASS_SG_Click(object sender, EventArgs e) { try { DataTable dt = GetCheckData("SG"); if (dt.Rows.Count == 0) { ScriptManager.RegisterStartupScript(this.UpdatePanel4, typeof(UpdatePanel), "STM35", "alert('尚未勾選任何資料');", true); return; } #region 連結資料庫 BCO.STM35_BCO bco = new BCO.STM35_BCO(ConntionDB); #endregion for (int i = 0; i < dt.Rows.Count; i++) { ArrayList arl = new ArrayList(); arl.Add(Convert.ToInt32(dt.Rows[i]["ID"])); arl.Add(Session["UID"].ToString()); string str_Resault = bco.UpdateComfirmPrice_SG(arl, null); if (str_Resault=="1") { ScriptManager.RegisterStartupScript(this.UpdatePanel4, typeof(UpdatePanel), "STM35", "alert('審核處理失敗');", true); return; } } ArrayList arl_Key = new ArrayList(); string s_Request_Key = Request.QueryString["STM352_PageTimeStamp"]; arl_Key = ((ArrayList)Session["STM352_SearchKey" + s_Request_Key]); ParameterList.Clear(); ParameterList.Add(Request["ITEM"].ToString());//[品號] for (int i = 0; i < 7; i++) { if (arl_Key[i].ToString() == string.Empty) { ParameterList.Add(DBNull.Value); } else { ParameterList.Add(arl_Key[i]); } } ParameterList.Add(TextBoxRowCountLimit1.Text); DataBind_SG(ParameterList); } catch (Exception ex) { WaringLogProcess(ex.Message); this.ErrorMsgLabel.Text = ex.Message; } finally { Finally_Function(); } }
/// <summary> /// 取得頁面上的資料 /// </summary> /// <param name="s_ITEM">品號</param> private void Get_PageDataMainAndDetl(string s_ITEM) { #region 傳入參數 BCO.STMCommon STMComm = new BCO.STMCommon(); ArrayList arl_Key = new ArrayList(); string s_Request_Key = Request.QueryString["STM352_PageTimeStamp"]; arl_Key = ((ArrayList)Session["STM352_SearchKey" + s_Request_Key]); ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(s_ITEM, "string", false));//[品號] for (int i = 0; i < 7; i++) { if (arl_Key[i].ToString() == string.Empty) { ParameterList.Add(DBNull.Value); } else { ParameterList.Add(arl_Key[i]); } } ParameterList.Add(TextBoxRowCountLimit.Text); #endregion #region 連結資料庫 BCO.STM35_BCO bco = new BCO.STM35_BCO(ConntionDB); DataTable ds_Return = bco.QueryDataItem(ParameterList); #endregion string s_RequestString = Request.QueryString["STM352_Type"]; if (ds_Return.Rows.Count == 0 || s_ITEM == string.Empty) { if (s_RequestString != "ToolBar") { ScriptManager.RegisterStartupScript(this.UpdatePanel3, typeof(UpdatePanel), "STM35", "alert('查無資料');", true); Response.Redirect("STM351.aspx?Code=STM35", false); } ScriptManager.RegisterStartupScript(this.UpdatePanel3, typeof(UpdatePanel), "STM35", "alert('查無此筆資料或已被其他使用者刪除,請點選上一筆/下一筆鈕或回查詢頁重新查詢!');", true); TabContainer2.Enabled = false; } else { #region 將資料寫入相關欄位 MAIN DataRow dr_Return_ITEM = ds_Return.Rows[0]; this.SLP_ITEM.Text = s_ITEM; this.txtITEM_WDS.Text = dr_Return_ITEM["ITEM_MAP"].ToString(); this.SLP_VENDOR.Text = dr_Return_ITEM["VENDOR"].ToString(); this.slp_TAX_TYPE.Text = dr_Return_ITEM["TAX_TYPE"].ToString(); this.slp_ROOT_NO.Text = dr_Return_ITEM["ROOT_NO"].ToString(); this.SLP_ItemPeriod.Text = dr_Return_ITEM["PERIOD"].ToString(); this.SLP_PMA.Text = dr_Return_ITEM["PMA"].ToString();//商品群分類 this.SLP_Category.Text = dr_Return_ITEM["Category"].ToString();//稅別 this.txt_PRICE.Text = dr_Return_ITEM["PRICE"].ToString(); this.txt_COST.Text = dr_Return_ITEM["COST"].ToString(); this.txt_DISCOUNT_RATE.Text = dr_Return_ITEM["DISCOUNT_RATE"].ToString(); this.slp_CREATEDATE.Text = dr_Return_ITEM["CREATEDATE"].ToString(); this.slp_CREATEUID.Text = dr_Return_ITEM["CREATEUID"].ToString(); this.slp_UPDATEDATE.Text = dr_Return_ITEM["UPDATEDATE"].ToString(); this.slp_UPDATEUID.Text = dr_Return_ITEM["UPDATEUID"].ToString(); #endregion #region 設定供應商合約獎勵金資料 ArrayList arl_Contract = new ArrayList(); arl_Contract = bco.QueryContract(dr_Return_ITEM["VENDOR"].ToString()); if (arl_Contract[0].ToString() != string.Empty) { string CNT_NO = arl_Contract[0].ToString(); string EDIT_NO = arl_Contract[1].ToString(); string SessionName = "VDM021_SortKey" + PageTimeStamp.Value; arl_Contract.Clear(); arl_Contract.Add(CNT_NO + "|" + EDIT_NO); Session[SessionName] = arl_Contract; btnVendor.OnClientClick = "AddIFrameTab('VDM02供應商合約維護處理','../VDM/VDM022.aspx?Code=VDM02&arl_Key=VDM021_SortKey" + PageTimeStamp.Value + "&isToolBar=N&VDM021=EDIT&CNT_NO=" + CNT_NO + "&EDIT_NO=" + EDIT_NO + "');return false;"; //因供應商帳務合約資料錯誤則帳務期別檔會無法抓取資料 #region 設定期別補貼主檔資料 string strSessionName = "ITM031_PK_" + PageTimeStamp.Value; Session[strSessionName] = null; DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("ITEM")); dt.Columns.Add(new DataColumn("PERIOD")); DataRow dr = dt.NewRow(); dr["ITEM"] = s_ITEM; dr["PERIOD"] = dr_Return_ITEM["PERIOD"].ToString(); dt.Rows.Add(dr); dt.AcceptChanges(); Session[strSessionName] = dt; btnPeriod.OnClientClick = "AddIFrameTab('ITM03期別帳務審核處理','../ITM/ITM032.aspx?Code=ITM03&DataItemIndex=0&SID=" + PageTimeStamp.Value + "');return false;"; #endregion } else { btnVendor.OnClientClick = "AddIFrameTab('VDM02供應商合約維護處理','../VDM/VDM021.aspx');return false;"; btnPeriod.OnClientClick = "AddIFrameTab('ITM03期別帳務審核處理','../ITM/ITM031.aspx');return false;"; } #endregion DataBind_S(ParameterList); DataBind_SG(ParameterList); } }
protected void ButtonQuery_Click(object sender, EventArgs e) { #region try { #region 檢查條件 this.ErrorMsgLabel.Text = ""; string s_CheckPage = CheckPage(sender); if (s_CheckPage != string.Empty) { this.ErrorMsgLabel.Text = s_CheckPage; return; } #endregion #region 傳入參數 ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(this.SLP_SKU_B.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_SKU_E.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_ItemPeriod_B.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_ItemPeriod_E.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.txtITEM_WDS.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_VENDOR.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_RootNo1.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_PMA_B.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_PMA_E.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_Category_B.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_Category_E.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_TAX_TYPE.Text, "int", false)); ParameterList.Add(GetValueSetParameter(this.SLP_Store_B.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_Store_E.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_StoreGroup_B.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_StoreGroup_E.Text.Trim(), "string", false)); if (this.rdoCONFIRM1.Checked) ParameterList.Add(GetValueSetParameter("", "int", false)); else if (this.rdoCONFIRM2.Checked) ParameterList.Add(GetValueSetParameter("1", "int", false)); else ParameterList.Add(GetValueSetParameter("0", "int", false)); ParameterList.Add(GetValueSetParameter(this.SLP_CREATEDATE.Text, "date", false)); ParameterList.Add(GetValueSetParameter(this.SLP_CREATEUID.Text, "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_UPDATEDATE.Text, "date", false)); ParameterList.Add(GetValueSetParameter(this.SLP_UPDATEUID.Text, "string", false)); ParameterList.Add(GetValueSetParameter(TextBoxRowCountLimit.Text.Trim(), "Decimal", false)); #endregion #region 取得資料 DataTable dt_Return = new DataTable(); STMModel.STM35_BCO bco = new STMModel.STM35_BCO(ConnectionDB); dt_Return = bco.QueryByLike(ParameterList); #endregion #region 資料與GridView繫結 //抓取本頁初次登記的時間 if (dt_Return.Rows.Count == 0) { this.GridView1.Visible = false; ErrorMsgLabel.Text = "查無資料!"; } else { string SessionIDName = string.Format("{0}_{1}", this.PageCode, PageTimeStamp.Value); this.GridView1.Visible = true; Session["SessionID"] = SessionIDName; Session[SessionIDName] = dt_Return; this.GridView1.DataSource = dt_Return; if (this.TextBoxPagesize.Text == "") this.GridView1.PageSize = 10; else this.GridView1.PageSize = Convert.ToInt32(this.TextBoxPagesize.Text); this.GridView1.PageIndex = 0; this.GridView1.DataBind(); ArrayList arl_Key = new ArrayList(); for (int i = 0; i < dt_Return.Rows.Count; i++) { arl_Key.Add(dt_Return.Rows[i]["ITEM"].ToString()); } Session["STM352_SortKey" + this.PageTimeStamp.Value] = arl_Key; string SessionSearchName = "STM352_SearchKey"+PageTimeStamp.Value; ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(this.SLP_ItemPeriod_B.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_ItemPeriod_E.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_Store_B.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_Store_E.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_StoreGroup_B.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_StoreGroup_E.Text.Trim(), "string", false)); if (this.rdoCONFIRM1.Checked) ParameterList.Add(GetValueSetParameter("", "int", false)); else if (this.rdoCONFIRM2.Checked) ParameterList.Add(GetValueSetParameter("1", "int", false)); else ParameterList.Add(GetValueSetParameter("0", "int", false)); Session[SessionSearchName]=ParameterList; } #endregion } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message.Split(Environment.NewLine.Replace(Environment.NewLine, "~").ToCharArray())[0]; //直接取第一個 } #endregion }//ButtonQuery_Click