/// <summary> /// 計算門市等級 /// </summary> /// <param name="ParameterList">變數集</param> /// <param name="ErrMsg">錯誤訊息</param> /// <returns>回傳計算成功或失敗</returns> private bool CalculateStoreRank(ArrayList ParameterList, ref string ErrMsg ) { #region bool bResult = false; Hashtable ht = GetInputValues(ParameterList); ht.Add("Module", "ALO"); ht.Add("FlagName", "SET_STORERANK_YN"); ht.Add("InProcess", "Y"); DataTable dtTemp; ALOModel.MaintainStoreRank BCO = new ALOModel.MaintainStoreRank(ConntionDB); try { dtTemp = BCO.CheckSysProcFlag();//檢查是否可進行計算 if (dtTemp != null && dtTemp.Rows.Count > 0) { #region if (dtTemp.Rows[0]["errStoreRank"].ToString().Trim() != "") { ErrMsg = dtTemp.Rows[0]["errStoreRank"].ToString().Trim(); return bResult; } if (dtTemp.Rows[0]["errDisRec"].ToString().Trim() != "") { ErrMsg = dtTemp.Rows[0]["errDisRec"].ToString().Trim(); return bResult; } if (dtTemp.Rows[0]["errMultiDisRec"].ToString().Trim() != "") { ErrMsg = dtTemp.Rows[0]["errMultiDisRec"].ToString().Trim(); return bResult; } #endregion #region bResult = BCO.ProcessCalculateStoreRank(ht); #endregion } } catch (Exception ex) { throw ex; } return bResult; #endregion }
private bool CalculateStoreRank() { #region bool bResult = false; Hashtable ht = GetInputValues(); ht.Add("Module", "ALO"); ht.Add("FlagName", "SET_STORERANK_YN"); ht.Add("InProcess", "Y"); DataTable dtTemp; ALOModel.MaintainStoreRank BCO = new ALOModel.MaintainStoreRank(ConnectionDB); try { dtTemp = BCO.CheckSysProcFlag();//檢查是否可進行計算 if (dtTemp != null && dtTemp.Rows.Count > 0) { #region if (dtTemp.Rows[0]["errStoreRank"].ToString().Trim() != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "ClientScript", string.Format("alert('{0}');", dtTemp.Rows[0]["errStoreRank"].ToString().Trim()), true); return bResult; } if (dtTemp.Rows[0]["errDisRec"].ToString().Trim() != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "ClientScript", string.Format("alert('{0}');", dtTemp.Rows[0]["errDisRec"].ToString().Trim()), true); return bResult; } if (dtTemp.Rows[0]["errMultiDisRec"].ToString().Trim() != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "ClientScript", string.Format("alert('{0}');", dtTemp.Rows[0]["errMultiDisRec"].ToString().Trim()), true); return bResult; } #endregion #region bResult = BCO.ProcessCalculateStoreRank(ht); #region deleted //try //{ // BCO.SetSYS_PROC_FLAG(ht, null);//設定計算執行中 // BCO.BackupStoreRankDetl(ht, null);//備份明細檔 // BCO.Add_ALO_STORERANK_MainDetl2(ht, null);//新增主檔明細檔 // BCO.SetStoreRankValueLevel2(ht, null);//計算Rank_Value Rank_Level // BCO.SetProcNoIsNullInDetl(ht, null);//設定明細檔計算處理批號欄位 // bResult = true; // //DBT.Commit();//交易成功 //} //catch (Exception ex) //{ // BCO.RollBackupStoreRankDetl(ht, null);//還原明細檔 // //DBT.Rollback();//交易失敗 // throw ex; //} //finally //{ // ht["InProcess"] = null; // BCO.SetSYS_PROC_FLAG(ht, null);//計算完畢 //} #endregion #endregion } } catch (Exception ex) { throw ex; } return bResult; #endregion }