private void QueryData() { #region #region 傳入參數 ArrayList ParameterList = new ArrayList(); ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(this.slp_TRANS_DATE.Text, "date", false)); ParameterList.Add(GetValueSetParameter(this.slp_ST_ACCEPT_DATE.Text, "date", false)); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(string.Format("{0}_{1}", PageTimeStamp.Value, Session["UID"].ToString())); #endregion #region 取得資料 ArrayList arl_Return = new ArrayList(); BCO.ProcessCRMOverDu bco = new BCO.ProcessCRMOverDu(ConntionDB); //2010/06/25 modified for new spec //arl_Return = bco.QueryForOverDu(ParameterList); arl_Return = bco.QueryForOverDu2(ParameterList); #endregion #region 資料與GridView繫結 DataTable dt_Return = new DataTable(); if (arl_Return[0].ToString() == string.Empty) { dt_Return = (DataTable)arl_Return[1]; } //抓取本頁初次登記的時間 string SessionIDName = string.Format("{0}_{1}", PAGE_DT_01, PageTimeStamp.Value); Session["SessionID"] = SessionIDName; Session[SessionIDName] = dt_Return; this.gv_OverDu.DataSource = dt_Return; this.gv_OverDu.PageSize = (TextBoxPagesize_Query.Text == "") ? 20 : (int.Parse(TextBoxPagesize_Query.Text) <= 0) ? 20 : int.Parse(TextBoxPagesize_Query.Text); this.gv_OverDu.DataBind(); if (dt_Return == null || (dt_Return != null && dt_Return.Rows.Count <= 0)) { if (btn_Export.Visible == true) { btn_Export.Enabled = false; } } else { if (btn_Export.Visible == true) { btn_Export.Enabled = true; } } #endregion #region 檢查回傳資料 string s_Err_Msg = string.Empty; s_Err_Msg = arl_Return[0].ToString(); if (s_Err_Msg == string.Empty) { if (dt_Return.Rows.Count == 0) { this.hid_FmOp_Step.Value = "查無資料"; this.ErrorMsgLabel.Text = "查無資料"; } else { this.hid_FmOp_Step.Value = "0"; this.RightMsgLabel.Text = "查詢成功"; } } else { this.hid_FmOp_Step.Value = "查詢資料發生錯誤"; this.ErrorMsgLabel.Text = s_Err_Msg; } #endregion hiddenProcessingID.Value = ""; hiddenProcessingIDCounts.Value = ""; #endregion }
/// <summary> /// BUTTON [訂單庫存檢查]鈕 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void but_Check_Stock_Click(object sender, EventArgs e) { #region string s_ERR_STOCK_CNT = string.Empty; //記錄異常筆數 try { #region 設定頁面狀態 int i_FmOp_Step = -1; try { i_FmOp_Step = int.Parse(this.hid_FmOp_Step.Value); } catch { this.ErrorMsgLabel.Text = "頁面狀態錯誤"; return; } if (i_FmOp_Step < 2) { this.ErrorMsgLabel.Text = "請先執行[店主檔檢查]鈕"; return; } this.hid_FmOp_Step.Value = "BUTTON [訂單庫存檢查]鈕開始"; #endregion #region 傳入參數 ArrayList ParameterList = new ArrayList(); ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(this.slp_TRANS_DATE.Text, "string", false)); ParameterList.Add(GetValueSetParameter(this.slp_ST_ACCEPT_DATE.Text, "string", false)); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(string.Format("{0}_{1}", PageTimeStamp.Value, Session["UID"].ToString())); ParameterList.Add(hiddenProcessingID.Value); #endregion #region 訂單庫存檢查 ArrayList arl_Return_CheckStock = new ArrayList(); BCO.ProcessCRMOverDu bco = new BCO.ProcessCRMOverDu(ConntionDB); //2010/06/25 modified for new spec //arl_Return_CheckStock = bco.CheckStock(ParameterList, null); arl_Return_CheckStock = bco.CheckStock2(ParameterList, null); #endregion #region 檢查訂單庫存檢查的回傳資料 string s_Err_Msg_CheckStock = string.Empty; s_Err_Msg_CheckStock = arl_Return_CheckStock[0].ToString(); s_ERR_STOCK_CNT = arl_Return_CheckStock[1].ToString(); if (s_Err_Msg_CheckStock != string.Empty) { this.hid_FmOp_Step.Value = "BUTTON [訂單庫存檢查]鈕發生錯誤"; this.ErrorMsgLabel.Text = s_Err_Msg_CheckStock; return; } #endregion #region 重新查詢資料 ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(this.slp_TRANS_DATE.Text, "date", false)); ParameterList.Add(GetValueSetParameter(this.slp_ST_ACCEPT_DATE.Text, "date", false)); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(string.Format("{0}_{1}", PageTimeStamp.Value, Session["UID"].ToString())); DataTable dt_Return = new DataTable(); //2010/06/25 modified for new spec //dt_Return = bco.QueryForOverDuForCheck(ParameterList); dt_Return = bco.QueryForOverDuForCheck2(ParameterList); #region 資料與GridView繫結 //抓取本頁初次登記的時間 string SessionIDName = string.Format("{0}_{1}", PAGE_DT_01, PageTimeStamp.Value); Session["SessionID"] = SessionIDName; Session[SessionIDName] = dt_Return; this.gv_OverDu.DataSource = dt_Return; this.gv_OverDu.DataBind(); #endregion #endregion #region 檢查回傳資料 if (dt_Return == null || dt_Return.Rows.Count < 1) { this.hid_FmOp_Step.Value = "查無資料"; this.ErrorMsgLabel.Text = "查無資料"; } else { this.hid_FmOp_Step.Value = "4"; if (s_ERR_STOCK_CNT != "" && s_ERR_STOCK_CNT != "0") { this.ErrorMsgLabel.Text = "訂單庫存檢查完成,但有庫存異常!"; } else { this.RightMsgLabel.Text = "訂單庫存檢查成功"; } } #endregion } catch (Exception ex) { this.hid_FmOp_Step.Value = "BUTTON [訂單庫存檢查]鈕發生錯誤"; WaringLogProcess(ex.Message); this.ErrorMsgLabel.Text = ex.Message; } finally { Set_but_Check_Stock_Click_PageStatus(s_ERR_STOCK_CNT); } #endregion }
/// <summary> /// BUTTON [轉手開配本]鈕 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void but_CreateDisRecord_Click(object sender, EventArgs e) { #region string s_HANDLE_COUNT = string.Empty; string s_SUCCESS_COUNT = string.Empty; BCO.CRMCommon CRMComm = new BCO.CRMCommon(); try { #region 設定頁面狀態 int i_FmOp_Step = -1; try { i_FmOp_Step = int.Parse(this.hid_FmOp_Step.Value); } catch { this.ErrorMsgLabel.Text = "頁面狀態錯誤"; return; } if (i_FmOp_Step < 4) { this.ErrorMsgLabel.Text = "請先執行[訂單庫存檢查]鈕"; return; } this.hid_FmOp_Step.Value = "BUTTON [轉手開配本]鈕開始"; #endregion #region 傳入參數 ArrayList ParameterList = new ArrayList(); ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(this.slp_TRANS_DATE.Text, "string", false)); ParameterList.Add(GetValueSetParameter(this.slp_ST_ACCEPT_DATE.Text, "string", false)); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(string.Format("{0}_{1}", PageTimeStamp.Value, Session["UID"].ToString())); ParameterList.Add(hiddenProcessingID.Value); #endregion #region 轉手開配本 ArrayList arl_Return = new ArrayList(); BCO.ProcessCRMOverDu bco = new BCO.ProcessCRMOverDu(ConntionDB); //2010/06/25 modified for new spec //arl_Return = bco.ProcessCreateDisRecord(ParameterList, null); arl_Return = bco.ProcessCreateDisRecord2(ParameterList, null); #endregion #region 檢查轉手開配本的回傳資料 string s_Err_Msg = string.Empty; s_Err_Msg = arl_Return[0].ToString(); if (s_Err_Msg != string.Empty) { this.hid_FmOp_Step.Value = "BUTTON [轉手開配本]鈕發生錯誤"; this.ErrorMsgLabel.Text = s_Err_Msg; } else { s_HANDLE_COUNT = arl_Return[1].ToString(); s_SUCCESS_COUNT = arl_Return[2].ToString(); this.hid_FmOp_Step.Value = "6"; this.RightMsgLabel.Text = "轉手開配本成功"; #region 預設POP查詢使用參數 string SessionIdName = "POP_QueryDisNo_" + PageTimeStamp.Value; Session[SessionIdName] = null; ParameterList.Clear(); ParameterList.Add(CRMComm.GetValueSetParameter("1", "string", false)); ParameterList.Add(CRMComm.GetValueSetParameter(this.slp_TRANS_DATE.Text, "string", false)); ParameterList.Add(CRMComm.GetValueSetParameter(this.slp_ST_ACCEPT_DATE.Text, "string", false)); ParameterList.Add(CRMComm.GetValueSetParameter("", "string", false)); //0代表未逾期客訂,1代表是逾期客訂 ParameterList.Add(CRMComm.GetValueSetParameter("", "string", false));//擷轉序號起 ParameterList.Add(CRMComm.GetValueSetParameter("", "string", false));//擷轉序號迄 ParameterList.Add(Session["UID"].ToString()); Session[SessionIdName] = ParameterList; #endregion //顯示配本序號 string s_ScriptManager_Script = string.Empty; s_ScriptManager_Script += "alert('逾期客訂轉手開單產生成功');"; s_ScriptManager_Script += string.Format(@"POP_QueryDisNo('{0}','{1}','{2}','{3}','{4}','{5}');", "1", //逾期客訂固定為雜誌 this.slp_TRANS_DATE.Text, this.slp_ST_ACCEPT_DATE.Text, "1", //逾期客訂 "", //擷轉序號起迄為空值 ""); ScriptManager.RegisterStartupScript(this.up_Msg, typeof(UpdatePanel), "CRM101", s_ScriptManager_Script, true); } #endregion } catch (Exception ex) { this.hid_FmOp_Step.Value = "BUTTON [轉手開配本]鈕發生錯誤"; WaringLogProcess(ex.Message); this.ErrorMsgLabel.Text = ex.Message; } finally { CRMComm = null; Set_but_CreateDisRecord_Click_PageStatus(s_HANDLE_COUNT, s_SUCCESS_COUNT); } #endregion }