private static String RenderConversionTables(MySqlConnection conn) { StringBuilder builder = new StringBuilder(); builder.Append("<script type=\"text/javascript\">"); WriteConversionArray(builder, conn.ExecuteDataTable("SELECT id, filename, name_ja, name_en FROM squid_stages ORDER BY id"), "squidStages"); WriteConversionArray(builder, conn.ExecuteDataTable("SELECT id, NULL AS filename, name_ja, name_en FROM squid_modes ORDER BY id"), "squidModes"); /* WriteConversionArray(builder, conn.ExecuteDataTable("SELECT identifier, filename, name_ja, name_en FROM squid_gear_head ORDER BY filename, identifier"), "squidGearHead"); WriteConversionArray(builder, conn.ExecuteDataTable("SELECT identifier, filename, name_ja, name_en FROM squid_gear_clothes ORDER BY filename, identifier"), "squidGearClothes"); WriteConversionArray(builder, conn.ExecuteDataTable("SELECT identifier, filename, name_ja, name_en FROM squid_gear_shoes ORDER BY filename, identifier"), "squidGearShoes"); WriteConversionArray(builder, conn.ExecuteDataTable("SELECT identifier, filename, name_ja, name_en FROM squid_weapons ORDER BY filename, identifier"), "squidWeapons"); */ builder.Append("</script>"); return builder.ToString(); }
/// <summary> /// Execute DataTable /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="parameters"></param> /// <returns></returns> public static DataTable ExecuteDataTable(this MySqlConnection conn, string cmdText, MySqlParameter[] parameters) { conn.CheckNull(nameof(conn)); return(conn.ExecuteDataTable(cmdText, parameters, CommandType.Text, null)); }
/// <summary> /// Execute DataTable /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="commandType"></param> /// <param name="transaction"></param> /// <returns></returns> public static DataTable ExecuteDataTable(this MySqlConnection conn, string cmdText, CommandType commandType, MySqlTransaction transaction) { conn.CheckNull(nameof(conn)); return(conn.ExecuteDataTable(cmdText, null, commandType, transaction)); }