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 }