public DataTable QueryStorRankByFind(Hashtable htParams) { #region try { VDS_ALO_STORERANK_MAIN_DBO ALOM = new VDS_ALO_STORERANK_MAIN_DBO(ref USEDB); return ALOM.doQueryByFind(htParams); } 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 int RollBackupStoreRankDetl(Hashtable htParams, DbTransaction RootDBT) { #region int iResult = 0; bool IsRootTranscation = false; try { VDS_ALO_STORERANK_MAIN_DBO ALOM = new VDS_ALO_STORERANK_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 iResult = ALOM.doRollBackupStoreRankDetl(htParams, DBT); #region 交易成功 if (IsRootTranscation) { //獨立呼叫Transcation成立 DBT.Commit(); } #endregion return iResult; } 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 } #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 CheckSysProcFlag() { #region try { VDS_ALO_STORERANK_MAIN_DBO ALOM = new VDS_ALO_STORERANK_MAIN_DBO(ref USEDB); return ALOM.doCheckSysProcFlag(); } catch (Exception ex) { throw GetNewException(ex); } #endregion }
public bool CheckCanCopy(Hashtable htParams) { #region try { VDS_ALO_STORERANK_MAIN_DBO ALOM = new VDS_ALO_STORERANK_MAIN_DBO(ref USEDB); return ALOM.doCheckCanCopy(htParams); } catch (Exception ex) { throw GetNewException(ex); } #endregion }
/// <summary> /// 判斷Excel筆數是否超過上限 /// </summary> /// <param name="htParams"></param> /// <returns></returns> public bool CheckExcelOutCount(Hashtable htParams, Int32 iLimitedRowsCounts) { #region try { VDS_ALO_STORERANK_MAIN_DBO ALOM = new VDS_ALO_STORERANK_MAIN_DBO(ref USEDB); return ALOM.doCheckExcelOutCount(htParams, iLimitedRowsCounts); } catch (Exception ex) { throw GetNewException(ex); } #endregion }