// 返回账号acc的余额 public static long getRemainMoney(string acc, bool isPlayer, GMUser user) { string sql = ""; SqlSelectGenerator gen = new SqlSelectGenerator(); gen.addField("money"); if (isPlayer) { sql = gen.getResultSql(TableName.PLAYER_ACCOUNT_XIANXIA, string.Format("acc='{0}'", acc)); } else { sql = gen.getResultSql(TableName.GM_ACCOUNT, string.Format("acc='{0}'", acc)); } Dictionary <string, object> data = user.sqlDb.queryOne(sql, user.getMySqlServerID(), MySqlDbName.DB_XIANXIA); if (data == null) { return(0); } return(Convert.ToInt64(data["money"])); }
// 返回玩家账号余额 public long getRemainMoney(string acc) { SqlSelectGenerator gen = new SqlSelectGenerator(); gen.addField("money"); string sql = gen.getResultSql(TableName.PLAYER_ACCOUNT_XIANXIA, string.Format("acc='{0}'", acc)); Dictionary <string, object> data = m_sqlDb.queryOne(sql, CMySqlDbName.DB_XIANXIA); if (data == null) { return(0); } return(Convert.ToInt64(data["money"])); }