public Int32 QueryRankUsedCount(ArrayList ParameterList) { #region try { VDS_ALO_RANK_MAIN_DBO DBO = new VDS_ALO_RANK_MAIN_DBO(ref USEDB); return DBO.doQueryRankUsedCount(ParameterList); } catch (Exception ex) { throw GetNewException(ex); } #endregion }
public DataTable QueryStorRankForExcel(Hashtable htParams) { #region try { VDS_ALO_RANK_MAIN_DBO ALOR = new VDS_ALO_RANK_MAIN_DBO(ref USEDB); string strDynamicSQL = ""; DataTable dtTemp = ALOR.doQueryAll(); Int32 iRow = 0; foreach (DataRow dr in dtTemp.Rows) { iRow++; strDynamicSQL += string.Format( "(select d1.rank_code from vds_alo_storerank_detl d1 where d1.rank_code='{0}' and d1.pid=d.pid) Rank{1}," + "(select r5.NAME from vds_alo_storerank_detl d1 left join vds_alo_rank_main r5 ON (d1.rank_code = r5.code AND r5.ENABLE = 1) where d1.rank_code='{0}' and d1.pid=d.pid) Rank名稱{1}," + "(select d1.rank_value from vds_alo_storerank_detl d1 where d1.rank_code='{0}' and d1.pid=d.pid) 數值{1}," + "(select d1.rank_level from vds_alo_storerank_detl d1 where d1.rank_code='{0}' and d1.pid=d.pid) 等級{1},", dr["CODE"], iRow); } if (strDynamicSQL.Trim() != "") { strDynamicSQL = strDynamicSQL.Substring(0, strDynamicSQL.Length - 1); } htParams["DynamicSql"] = strDynamicSQL; VDS_ALO_STORERANK_MAIN_DBO ALOM = new VDS_ALO_STORERANK_MAIN_DBO(ref USEDB); return ALOM.doQueryForExcel(htParams); } catch (Exception ex) { throw GetNewException(ex); } #endregion }
public DataTable QueryStorRankForExcel2(Hashtable htParams) { #region try { VDS_ALO_RANK_MAIN_DBO ALOR = new VDS_ALO_RANK_MAIN_DBO(ref USEDB); string strDynamicSQL1 = "", strDynamicSQL2 = "", strDynamicSQL3 = ""; DataTable dtTemp = ALOR.doQueryAll(); Int32 iRow = 0; foreach (DataRow dr in dtTemp.Rows) { iRow++; strDynamicSQL1 += string.Format( " ,r{1}.rank_code rank{1},'{0}' as Rank名稱{1}, r{1}.rank_value as 數值{1}, r{1}.rank_level as 等級{1}", dr["NAME"], iRow); strDynamicSQL2 += string.Format( " ,vds_alo_storerank_detl r{0}", iRow); strDynamicSQL3 += string.Format( " and (x.id = r{1}.pid(+) and r{1}.rank_code(+)='{0}')", dr["CODE"], iRow); } htParams["DynamicSql1"] = strDynamicSQL1; htParams["DynamicSql2"] = strDynamicSQL2; htParams["DynamicSql3"] = strDynamicSQL3; VDS_ALO_STORERANK_MAIN_DBO ALOM = new VDS_ALO_STORERANK_MAIN_DBO(ref USEDB); return ALOM.doQueryForExcel2(htParams); } catch (Exception ex) { throw GetNewException(ex); } #endregion }
public DataTable QuerySwitch(QueryType QT, ArrayList ParameterList) { VDS_ALO_RANK_MAIN_DBO ALOM = new VDS_ALO_RANK_MAIN_DBO(ref USEDB); DataTable Dt; try { switch (QT) { case QueryType.ALL: Dt = ALOM.doQueryAll(); break; case QueryType.CODE: Dt = ALOM.doQueryByCode(ParameterList); break; case QueryType.ID: Dt = ALOM.doQueryByID(ParameterList); break; case QueryType.Custom: Dt = ALOM.doQueryByFind(ParameterList); break; case QueryType.QueryAllByEn: Dt = ALOM.doQueryAllByEnable(ParameterList); break; default: Dt = new DataTable(); break; } return Dt; } catch (Exception ex) { throw GetNewException(ex); } }
/// <summary> /// 取得RANK等級預設值 /// </summary> /// <param name="ParameterList"></param> /// <returns></returns> public string GetMinRankLevel(ArrayList ParameterList) { #region try { VDS_ALO_RANK_MAIN_DBO ALOM = new VDS_ALO_RANK_MAIN_DBO(ref USEDB); return ALOM.doGetMinRankLevel(ParameterList); } catch (Exception ex) { throw GetNewException(ex); } #endregion }
/// <summary> /// 基本表單新增BCO /// </summary> /// <param name="ParameterList">輸入變數</param> /// <param name="RootDBT">是否有主交易,無主交易輸入null</param> /// <returns>回傳影響筆數</returns> public int CreateDisRank(ArrayList ParameterList, DbTransaction RootDBT) { int PID = 0; bool IsRootTranscation = false; try { VDS_ALO_RANK_MAIN_DBO ALOM = new VDS_ALO_RANK_MAIN_DBO(ref USEDB); //判斷是否有傳入Root Transcation IsRootTranscation = (RootDBT == null) ? true : false; #region 啟動交易或指定RootTranscation if (IsRootTranscation) { //獨立呼叫啟動Transcation Conn = USEDB.CreateConnection(); Conn.Open(); DBT = Conn.BeginTransaction(); } else { DBT = RootDBT; } #endregion PID = ALOM.doCreate(ParameterList, DBT); #region 交易成功 if (IsRootTranscation) { //獨立呼叫Transcation成立 DBT.Commit(); } #endregion return PID; } catch (Exception ex) { #region 交易失敗 if (IsRootTranscation) { //獨立呼叫Transcation失敗 DBT.Rollback(); } #endregion throw GetNewException(ex); } finally { #region 判斷是否關閉交易連線 if (IsRootTranscation) { //獨立呼叫Transcation,關閉連線 if (Conn.State == ConnectionState.Connecting) { Conn.Close(); } } #endregion } }