public static double getCurrencyRate(int tnCurrency_id, string tsMonth) { object loCurrencyRate = DBA.ExecuteScalar("select f_HO_getCurrencyRate(" + tnCurrency_id + ",'" + tsMonth.Trim() + "') from t_SD_Currency_Rate "); if (loCurrencyRate == null || loCurrencyRate == DBNull.Value) { return(1.0); } else { return(DouUtil.SafeCDou(loCurrencyRate)); } }
/// <summary> /// 执行查询,并返回查询所返回的结果集中第一行的第一列。所有其他的列和行将被忽略。 /// </summary> /// <param name="Command">CommandBuilder对象。</param> /// <returns></returns> public object ExecuteScalar(CommandBuilder Command) { return(DBA.ExecuteScalar(Command)); }
/// <summary> /// 根据货币Id查询汇率 /// </summary> /// <param name="tscurrency_id"></param> /// <returns></returns> public static String getCurrencyRate(String tsCurrency_id) { String lsSQL = "select currency_rate from t_sd_currency where currency_id =" + tsCurrency_id; return(DBA.ExecuteScalar(lsSQL).ToString()); }